🏦
DeFi Lending Yields
Minute-by-minute Aave V3 lending and borrowing rates
Category
States
Point-in-time snapshots
Granularity
~1 minute updates
Format
Apache Parquet
Snappy compression, Hive-partitioned
Nodes
1 (EU-Central)
Frankfurt — low-latency to HyperLiquid & Ethereum
About This Dataset
Supply APY, borrow APY, utilization, and total supply for major assets on Aave V3. Essential for delta-neutral basis trade backtesting and yield farming analysis.
Partitions
protocol:
aave_v3Schema
| Column | Type | Description |
|---|---|---|
time_chain | timestamp | Rate update timestamp (UTC) |
time_local | timestamp | Ingestion timestamp (UTC) |
asset | string | Asset symbol |
supply_apy | float64 | Supply APY (annualized) |
borrow_apy | float64 | Borrow APY (annualized) |
utilization | float64 | Pool utilization rate (0–1) |
total_supply_usd | float64 | Total supply (USD) |
Use Cases
- Backtest delta-neutral basis trades accounting for borrowing costs
- Analyze yield curve dynamics across DeFi protocols
- Detect utilization spikes that indicate borrowing demand surges
- Build yield farming optimization strategies
R2 Path
s3://algotick-data-lake/states/yields/protocol=aave_v3/year=YYYY/month=MM/day=DD/node={node}/data.parquet
Replace
YYYY, MM, DD with the target date.
Data is collected from node=eu-central.
Query with DuckDB
import duckdb df = duckdb.sql(""" SELECT * FROM read_parquet( 's3://algotick-data-lake/states/yields/protocol=aave_v3/year=2026/month=04/day=20/node=eu-central/data.parquet' ) LIMIT 100 """).df() print(f"Rows: {len(df)}, Columns: {list(df.columns)}")
Download via API
import requests resp = requests.get( "https://algotick.dev/v2/history/raw?dataset=yields&protocol=aave_v3&date=2026-04-20", stream=True, ) with open("yields.parquet", "wb") as f: for chunk in resp.iter_content(8192): f.write(chunk) # Then query locally import duckdb df = duckdb.sql("SELECT * FROM 'yields.parquet' LIMIT 100").df() print(df)
Related
Related signals: Arbitrage
Related datasets: Perpetual Funding Rates Liquid Staking Events
Don't just stare at the dashboard. Automate it.
Every metric on this page is available via our sub-millisecond API.
Build trading bots, backtest strategies, and power AI agents with institutional-grade data.