flipside

    Who is getting Aave Rewards 3
    jackguyWho is getting Aave Rewards 3
    Updated 2021-10-02
    with tab1 as (
    SELECT
    reserve_name,
    block_hour,
    aave_version,
    avg(total_liquidity_usd * supply_rate)/8760 as fee
    FROM aave.market_stats
    GROUP BY 1,2,3
    )

    SELECT
    reserve_name,
    sum(fee)
    FROM tab1
    GROUP BY 1--,2
    Run a query to Download Data