BLOCK_TIMESTAMP::DATE as day,

sum(AMOUNT_IN_USD) as daily_amt_in_USD

from ethereum.sushi.ez_swaps

where SYMBOL_OUT = 'USDC'

group by day

order by day desc

limit 30