binhachonDaily stETH Metrics - #1
    Updated 2022-06-06
    with stETH_swaps as (
    select
    block_timestamp,
    platform,
    case when direction = 'IN' then amount_in else amount_out end as amount
    from flipside_prod_db.ethereum.dex_swaps
    where token_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
    )
    select
    date_trunc('day', block_timestamp) as time,
    platform,
    sum(amount) as volume
    from stETH_swaps
    group by 1, 2

    Run a query to Download Data