select block_timestamp,

tx_hash,

origin_from_address,

'ETH' as symbol,

from ethereum.core.ez_eth_transfers

where eth_to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'

union ALL

select block_timestamp,

tx_hash,

origin_from_address,

symbol,

from ethereum.core.ez_token_transfers

where to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'),

table1 as (

select t1.block_timestamp,

t1.tx_hash,

t1.origin_from_address,

t1.event_name

from optimism.core.fact_event_logs t1 join standardbridge t2 on t1.origin_from_address = t2.origin_from_address and t1.block_timestamp > t2.block_timestamp),

table2 as (

select date_trunc(month,block_timestamp) as date,

event_name,

count (distinct tx_hash) as TX_Count,

count (distinct origin_from_address) as Users_Count

from table1

group by 1,2),

maintable as (

select *,

row_number() over (partition by date order by TX_Count desc) as RN

from table2)