select *

from ethereum.udm_events

where contract_address in ('0xb832cc0e8ed40ae42eddc63d9d07ebaf022994e8',

'0x462991d18666c578f787e9ec0a74cd18d2971e5f',

'0x42d4e90ff4068abe7bc4eab838c7de1d2f5998a3',

'0x92be6adb6a12da0ca607f9d87db2f9978cd6ec3e')

),

zap_in_nodup as (

select distinct

block_timestamp, block_id, tx_id, origin_address, from_address, to_address, symbol, amount, amount_usd

from ethereum.udm_events

where tx_id in (select tx_id from zap_in)

and origin_address = from_address

and amount_usd > 10000 -- to filter out small tx to fit the graph

)

select symbol

, count(tx_id) as tx_count

, sum(amount) as amount

, sum(amount_USD) as amount_USD

from zap_in_nodup

group by 1

order by 2 desc