maybeyonasAAVE-dash-market-stats
Updated 2023-03-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with aave_pool_stats as(
select
block_hour,
lending_pool_add,
reserve_name,
aave_version,
reserve_price,
total_liquidity_token,
total_liquidity_usd,
total_stable_debt_token,
total_stable_debt_usd,
total_variable_debt_token,
total_variable_debt_usd,
supply_rate,
borrow_rate_stable,
borrow_rate_variable
from aave.market_stats
where total_liquidity_usd > 0
and block_hour = date(block_hour)
)
select * from aave_pool_stats
Run a query to Download Data