Abbas_ra21Borrow by Symbol
    Updated 2023-03-08
    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