select hour,

price as usdprice

from avalanche.price.ez_prices_hourly

where symbol = 'WAVAX'

and hour >= '2025-04-09')

select count (distinct tx_hash) as Registrations,

count (distinct origin_From_address) as Registrants,

sum (decoded_log:amount/1e18) as Total_Volume,

sum (decoded_log:amount*usdprice/1e18) as USD_Volume,

avg (decoded_log:amount/1e18) as AVG_Volume,

median (decoded_log:amount/1e18) as Median_Volume,

from avalanche.core.ez_decoded_event_logs t1 join pricet t2 on date_trunc (hour,block_timestamp) = t2.hour

where origin_to_address = '0xba8f5bf247febfe419be7034c6fe0d2e10a89c37'

and origin_function_signature = '0xe97e6dca'

and tx_succeeded

and event_name = 'Applied'