Sajjadiii2 Aave - 8. How does BTC funding affect rates?
    Updated 2022-08-08
    with tokens as(select symbol , sum(BORROWED_USD)
    from flipside_prod_db.aave.borrows
    where AAVE_VERSION = 'Aave V2'
    and BORROW_RATE_MODE != 'Stable Rate'
    group by 1
    order by 2 desc
    limit 10 ),

    borrows as (select block_timestamp::date as date , sum(BORROWED_USD) as daily_borrow , symbol
    from flipside_prod_db.aave.borrows
    where symbol in (select symbol from tokens)
    group by 1,3),

    suppleid as (select block_timestamp::date as date , sum(SUPPLIED_USD) as daily_supplied , symbol
    from flipside_prod_db.aave.deposits
    where symbol in (select symbol from tokens)
    group by 1,3),

    wbtc_suppleid as (select block_timestamp::date as date , sum(SUPPLIED_USD) as daily_supplied_Wbtc , symbol
    from flipside_prod_db.aave.deposits
    where symbol = 'WBTC'
    group by 1,3),



    final as (select a.date ,daily_borrow , daily_supplied ,a.symbol
    from borrows a
    join suppleid b
    on a.date = b.date and a.symbol = b.symbol)


    select *
    from final
    Run a query to Download Data