distinct TO_ADDRESS as users,

BLOCK_TIMESTAMP,

sum(RAW_AMOUNT/1e18) as volume_ACX

from ethereum.core.ez_token_transfers

where FROM_ADDRESS = '0xe50b2ceac4f60e840ae513924033e753e2366487'

and contract_address = '0x44108f0223a3c3028f5fe7aec7f9bb2e66bef82f'

group by 1,2

),

tb2 as (

select

x.BLOCK_TIMESTAMP,

x.origin_from_address,

x.origin_to_address,

x.tx_hash

from ethereum.core.fact_event_logs x

join tt y on x.origin_from_address = y.users and x.block_timestamp>y.block_timestamp

where contract_address = '0x44108f0223a3c3028f5fe7aec7f9bb2e66bef82f'

order by 1

)

select

date_trunc('hour',BLOCK_TIMESTAMP) as date,

event_name as first_actions,

count(distinct tx_hash) as counts,

count(distinct origin_from_address) as users

from ethereum.core.fact_event_logs

where tx_hash in (select tx_hash from tb2)

group by 1,2

having first_actions is not null