binhachonstETH Most Common Pools - Use the old table
    Updated 2022-04-26
    with swap_transactions as (
    select
    block_timestamp,
    pool_name,
    platform,
    amount_in + amount_out as stETH_amount
    from ethereum.dex_swaps
    where block_timestamp > getdate() - interval'3 months'
    and token_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
    )
    select
    pool_name,
    platform,
    sum(stETH_amount) as volume,
    row_number() over (order by volume desc) as rank
    from swap_transactions
    group by 1, 2
    qualify rank < 11

    Run a query to Download Data