-- forked from zakkisyed / 1.SUSHIswap pool/volume on Ethereum @ https://flipsidecrypto.xyz/zakkisyed/q/sushi-pool-volume-on-ethereum-PwowX3
select distinct(to_address_name) as pool_name, sum(amount)/1e18 as volume_in_M, sum(amount_usd)/1e18 as volume_usd_in_M
from ethereum.udm_events
where origin_function_name = 'swapExactTokensForTokens'
and to_label = 'sushiswap'
group by pool_name
order by volume_in_M desc