select
SYMBOL,
sum(AMOUNT_USD) amount_paid
from ethereum.udm_events
where contract_address in ('0x7e9d8f07a64e363e97a648904a89fb4cd5fb94cd','0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48')
and from_address = lower('0x2Fb9F0ef424b24a8D293999298F392a33Fe6A8b5')
and block_timestamp::date >= '2021-07-19'
and SYMBOL is not null
group by 1