from_address,

count(distinct from_address) as whale_count,

sum(amount_usd) as stablecoin_volume,

case

when origin_to_address = '0xa0c68c638235ee32657e8f720a23cec1bfc77c77' then 'Polygon'

when origin_to_address = '0x72ce9c846789fdb6fc1f34ac4ad25dd9ef7031ef' then 'Arbitrum'

when origin_to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1' then 'Optimism'

end as native_bridge

from ethereum.core.ez_token_transfers

where origin_to_address in (

'0xa0c68c638235ee32657e8f720a23cec1bfc77c77',

'0x72ce9c846789fdb6fc1f34ac4ad25dd9ef7031ef',

'0x99c9fc46f92e8a1c0dec1b1747d010903e884be1')

and symbol in ('USDC','USDT', 'DAI')

group by from_address, native_bridge

having stablecoin_volume > 1000000

order by stablecoin_volume DESC