Abbas_ra21Borrow by Symbol
Updated 2023-03-10
9
1
2
3
4
5
6
7
›
⌄
select date_trunc('Day',_INSERTED_TIMESTAMP)::DATE AS DAY,
RESERVE_NAME AS SYMBOL,
Avg(TOTAL_LIQUIDITY_USD) AS "Liquidity (USD)",
Avg(BORROW_RATE_STABLE) AS "Borrow Rate",
Avg(UTILIZATION_RATE) AS "UTILIZATION_ Rate"
from ethereum.aave.ez_market_stats where RESERVE_NAME in ('MKR','UNI','SNX') and AAVE_VERSION='Aave V2' and _INSERTED_TIMESTAMP::Date <= '2023-03-08'
group by 1,2
Run a query to Download Data