select
date_trunc('day',block_timestamp) as day,
symbol,
--contract_address,
sum(amount_usd) as amount_sent
FROM gold.ethereum_events
WHERE to_label = 'uniswap' AND
(LOWER(to_address_name) like '%usdc%' OR
LOWER(to_address_name) like '%dai%')
AND block_timestamp > getdate() - interval '1 month'
AND contract_address in (
'0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48',
'0x6b175474e89094c44da98b954eedeac495271d0f'
)
AND amount_usd > 0
GROUP BY day, symbol
ORDER BY symbol, day;