with arenapricet as (

select date_trunc (hour,block_timestamp) as hour1,

avg (amount_in_usd/amount_out) as arenaprice

from avalanche.defi.ez_dex_swaps

where symbol_in = 'WAVAX'

and (symbol_out = 'ARENA' or token_out = '0xb8d7710f7d8349a506b75dd184f05777c82dad0c')

group by 1

order by 1 desc)

select to_address,

sum (amount) as Received_Amount,

sum (amount*arenaprice) as Received_Amount_USD

from avalanche.core.ez_token_transfers t1 left outer join arenapricet t2 on date_trunc (hour,t1.block_timestamp) = t2.hour1

where contract_address = '0xb8d7710f7d8349a506b75dd184f05777c82dad0c'

and from_address = '0x30f587903ef022774f5e35151e0e73c196bd755d'

and origin_function_signature = '0x3b439351'

and block_timestamp >= '2025-03-01 18:30:00.000'

group by 1

order by 2 DESC