date_trunc('day', block_timestamp) as date,

--swap_pair,

sum(swap_fee_amount_usd) as usd_fees

from terra.swaps

where block_timestamp > getdate() - interval '30 days'

group by 1

order by 1