select from_address as ArenaUser

from avalanche.core.fact_transactions

where to_address = '0xc605c2cf66ee98ea925b1bb4fea584b71c00cc4c'

and from_address != '0xc605c2cf66ee98ea925b1bb4fea584b71c00cc4c'),

pricet as (

select hour::date as day,

token_address,

symbol,

decimals,

avg (price) as usdprice

from avalanche.price.ez_prices_hourly

where hour >= '2025-01-23 00:00:00.000'

group by 1,2,3,4),

arenatipsendt as (

select block_timestamp,

tx_hash,

origin_from_address as tipper,

'AVAX' as symbol,

decoded_log:total*usdprice/1e18 as amount

from avalanche.core.ez_decoded_event_logs t1 join pricet t2 on t1.block_timestamp::Date = t2.day and t2.symbol = 'WAVAX'

where origin_tO_address = '0xf60fadfb18820c58af892692838b354fc808fd61'

and contract_address = '0xf60fadfb18820c58af892692838b354fc808fd61'

and origin_function_signature = '0xbb4c9f0b'

and tx_succeeded

union all

select block_timestamp,

tx_hash,

origin_from_address as tipper,

symbol,

decoded_log:total*usdprice/pow(10,decimals) as amount

from avalanche.core.ez_decoded_event_logs t1 join pricet t2 on t1.block_timestamp::Date = t2.day and t1.decoded_log:token = t2.token_address