select from_address as ArenaUser

from avalanche.core.fact_transactions

where to_address = '0xc605c2cf66ee98ea925b1bb4fea584b71c00cc4c'

and from_address != '0xc605c2cf66ee98ea925b1bb4fea584b71c00cc4c'),

userst as (

select block_timestamp as receive_date,

to_address as receiver,

amount as received_amount

from avalanche.core.ez_token_transfers

where tx_hash in ('0xf5059e806f6db0a4754bc49d9be1067996973d4b52e72676aeb03bfc941a9497','0x7a36567a7dc87a73634af63203ad34cc92edc6a96fbba8490f5be5515e4a6f83')

and contract_address = '0x0f669808d88b2b0b3d23214dcd2a1cc6a8b1b5cd'

and from_address = '0xebf747761b6942adabaa58a594ba24931afa0a3f'

and block_timestamp::date = '2025-03-04'

),

actionstable as (

select distinct from_address

from avalanche.core.ez_token_transfers t1 join userst t2 on t1.from_address = t2.receiver and t1.block_timestamp > t2.receive_date and t1.amount <= t2.received_amount)

select case when to_address = '0xf2c15bd1bf3d7863a4b6d72f89758c18489794aa' then 'Token Mill Staking'

when to_address = '0x000000000000000000000000000000000000dEaD' then 'Burn'

when to_address = '0xe8e45d1866efe193268ba3820a52717a2645d78c' then 'Token Mill: $CHAMP / $AVAX Pool'

when to_address = lower ('0x19fb2F2DcE3A276e8F5C1b40B72ABDD4074c4d53') then 'TraderJoe $CHAMP / $AMI Pool'

when to_address = '0xeed1c0ba2c17855288c3a2b36f3b5068346fa2bd' then 'TraderJoe Swap'

when to_address = '0x73f252375ca0d6f7e3308ac38c6e1dbee760cd81' then 'TraderJoe $WINK / $WAVAX Pool'

when to_address = lower ('0x45A62B090DF48243F12A21897e7ed91863E2c86b') then 'TraderJoe Swap'

when to_address = lower ('0x1daC23e41Fc8ce857E86fD8C1AE5b6121C67D96d') then 'OKX DEX Aggregator'

when to_address = '0x39888258d60fed9228f89e13eb57a92f1fa832eb' then 'TraderJoe Swap'

when to_address = lower ('0x44404cD47CD199014eC0D7DB4FC86545AEA4762d') then 'TraderJoe Swap'

when to_address in (select distinct arenauser from arenauserst) or to_address = '0x2fe5da4d27ee12a8ca78d62f8922b90f074fd59a' then 'Tipped To Arena Users'

else to_address end as destination,

sum (amount) as Volume,

count (distinct from_address) as Users

from avalanche.core.ez_token_transfers t1 join userst t2 on t1.from_address = t2.receiver and t1.block_timestamp > t2.receive_date and t1.amount <= t2.received_amount