Abbas_ra21Borrow by Symbol
Updated 2023-03-08
9
1
2
3
4
5
6
7
8
9
›
⌄
select date_trunc('Day',BLOCK_TIMESTAMP)::DATE AS DAY,
SYMBOL,
sum(BORROWED_TOKENS) AS "BORROWED AMOUNT",
sum(BORROWED_USD) AS "BORROWED AMOUNT (USD)",
Avg(BORROWED_TOKENS) AS "AVERAGE BORROWED AMOUNT",
Avg(BORROWED_USD) AS "AVERAGE BORROWED AMOUNT (USD)",
avg(TOKEN_PRICE) AS "Price (USD)"
from ethereum.aave.ez_borrows where SYMBOL in ('MKR','UNI','SNX') and AAVE_VERSION='Aave V2'
group by 1,2
Run a query to Download Data