flipside

    2024-03-28 03:37 PM
    tucker192024-03-28 03:37 PM
    Updated 2024-03-28
    -- select * -- ATOKEN_ADDRESS, TOTAL_LIQUIDITY_USD
    -- from ethereum.aave.ez_market_stats;

    select ATOKEN_ADDRESS, RESERVE_NAME as ASSET, sum(ifnull(TOTAL_LIQUIDITY_USD, 0.0)) as TOTAL_LIQUIDITY_USD
    from ethereum.aave.ez_market_stats
    group by ATOKEN_ADDRESS, RESERVE_NAME
    -- having sum(ifnull(TOTAL_LIQUIDITY_USD, 0.0)) > 100
    order by ATOKEN_ADDRESS, RESERVE_NAME;

    select DISTINCT(BLOCK_HOUR)
    from ethereum.aave.ez_market_stats;
    QueryRunArchived: QueryRun has been archived