select
platform,
symbol_out as symbol,
count(distinct(tx_hash)) as tx_count,
sum(amount_in) as total_amount
from ethereum.core.ez_dex_swaps
where block_timestamp > current_date - interval '1 month'
and symbol_out in ('USDT', 'USDC', 'BUSD', 'DAI', 'USDP', 'TUSD', 'USDD', 'USDN', 'GUSD', 'FEI', 'FRAX', 'LUSD', 'SUSD')
and block_timestamp > current_date - interval '1 month'
group by 1, 2