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