select
date(block_timestamp) as day,
platform,
sum(amount_in_usd),
case when symbol_out='XSGD' then symbol_in else symbol_out end as token_bought
from
polygon.defi.ez_dex_swaps
where
token_in='0xdc3326e71d45186f113a2f448984ca0e8d201995' or token_out='0xdc3326e71d45186f113a2f448984ca0e8d201995'
group by
day,
platform,
token_bought