sum(events),

sum(volume)

FROM (

date(block_timestamp) as date,

'Arbitrum' as chain,

count(DISTINCT a.tx_hash) as events,

sum(amt) as volume,

sum(events) over (ORDER by date) as total_events,

sum(volume) over (ORDER by date) as total_volume

FROM arbitrum.core.fact_transactions as a

LEFT outer JOIN (

SELECT --*

tx_hash,

max(AMOUNT) as amt

FROM arbitrum.core.ez_token_transfers

WHERE contract_address in (

lower('0xFF970A61A04b1cA14834A43f5dE4533eBDDB5CC8'),

lower('0xFd086bC7CD5C481DCC9C85ebE478A1C0b69FCbb9'),

lower('0xfc90518D5136585ba45e34ED5E1D108BD3950CFa'),

lower('0xFF970A61A04b1cA14834A43f5dE4533eBDDB5CC8'),

lower('0xaf88d065e77c8cc2239327c5edb3a432268e5831')

)

--WHERE tx_hash LIKE '0xa984d31dafe0d7ad59ba2bb439e068b6f16c9fcec444d615a8237baea57a87ed'

GROUP BY 1

) as b

on a.tx_hash = b.tx_hash

WHERE to_address LIKE '0xe4f65f9a4659a2bd961a0e3ee68341bf221114e4'

AND ORIGIN_FUNCTION_SIGNATURE LIKE '0x53fdc1f3'