with t1 as ( select (block_timestamp) as date,

to_address as user,

RAW_AMOUNT/pow(10,18) as amount

from ethereum.core.ez_token_transfers

where contract_address = lower('0x4d224452801aced8b2f0aebe155379bb5d594381')

and from_address = lower('0x025c6da5bd0e6a5dd1350fda9e3b6a614b205a1f')

and date >= '2022-03-17')

,

t2 as ( select trunc(block_timestamp,'day') as date,

label,

label_subtype,

tx_hash,

from ethereum.core.dim_labels a join ethereum.core.fact_event_logs b on a.address = b.origin_to_address

where block_timestamp::date >= '2022-03-17'

and (origin_from_address in (select user from t1)

or event_inputs:from in (select user from t1)))

,

final_result as ( select date,

label,

count(DISTINCT tx_hash) as total_transaction

from t2

group by date,label)

select *

from final_result

where total_transaction > 250