-- forked from Mrfti / What tokens $TON swapped to most? (Ethereum) @ https://flipsidecrypto.xyz/Mrfti/q/t30XU8qGENGW/what-tokens-ton-swapped-to-most-ethereum
select
symbol_out as "Token ($TON swapped to )",
sum(amount_in_usd) as "Volume (USD)"
from
ethereum.defi.ez_dex_swaps
where
token_in = lower ('0x582d872a1b094fc48f5de31d3b73f2d9be47def1')
and amount_in_usd is not null
and symbol_out is not null
group by
1
order by
2 desc
limit
100