token_out,

token_in,

sum(amount_in) as volume,

count(distinct tx_hash) as tx_count

from near.core.ez_dex_swaps

where token_in ilike '%usdt%' and block_timestamp::date >= current_date - 30

group by 1, 2