date_trunc('day', block_timestamp) as days,

case

when token_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' then 'USDC'

when token_address = '0xdac17f958d2ee523a2206206994597c13d831ec7' then 'USDT'

when token_address = '0x6b175474e89094c44da98b954eedeac495271d0f' then 'DAI'

when token_address = '0xa47c8bf37f92abed4a126bda807a7b7498661acd' then 'UST'

when token_address = '0x4fabb145d64652a948d72533023f6e7a623c7c53' then 'BUSD'

else 'Other tokens' end as stable,

platform,

sum(amount_usd) as tx_amount

from ethereum.dex_swaps

where stable != 'Other tokens'

and block_timestamp >= current_date - 365

group by 1,2,3

order by 1