Alexaytotal usd swaps
    Updated 2022-09-13
    with aeth as (select sum(amount_in_usd) as usd, 'aeth' as t
    from ethereum.core.ez_dex_swaps
    where pool_name like '%aETH%' and amount_in_usd>0),

    reth as ( select sum(amount_in_usd) as usd, 'reth' as t
    from ethereum.core.ez_dex_swaps
    where pool_name like '%rETH%' and amount_in_usd>0),

    steth as ( select sum(amount_in_usd) as usd, 'steth' as t
    from ethereum.core.ez_dex_swaps
    where pool_name like '%stETH%' and amount_in_usd>0)

    select * from aeth
    union
    select * from reth
    UNION
    select * from steth
    Run a query to Download Data