select

DISTINCT tx_hash

-- ORIGIN_TO_ADDRESS

-- ,count(*) as tx_count

from arbitrum.core.fact_event_logs

where block_timestamp::date>=CURRENT_DATE-30

and CONTRACT_ADDRESS=lower('0xfc5A1A6EB076a2C7aD06eD22C90d7E710E35ad0a')

and TX_STATUS='SUCCESS'

and EVENT_REMOVED=false

select

block_timestamp::date as date

,count(DISTINCT tx_hash) as tx_count

,count(DISTINCT FROM_ADDRESS) as wallets

,avg(tx_fee) as avg_amount_fee

,sum(tx_fee) as amount_fee

,sum(amount_fee) over (order by date) as growth_amount_fee

from arbitrum.core.fact_transactions

where tx_hash in (select tx_hash from lst_tx)

group by 1

order by 1