CASE when symbol is null then 'Other' else symbol end as token,

sum(events) as events,

sum(volume) as volume

FROM (

date(block_timestamp) as date,

'Arbitrum' as chain,

symbol,

--a.tx_hash,

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 c

on a.tx_hash = c.tx_hash