with avax_price as (

select

date_trunc('day', hour) as date,

median(price) as avax_price

from

avalanche.price.ez_prices_hourly

where

symbol = 'WAVAX'

group by 1

)

SELECT event_name,

count(DISTINCT origin_from_address) as n_stakers,

sum(decoded_log:avaxAmount) / pow(10, 18) as vol_stake,

sum(decoded_log:avaxAmount * avax_price)/pow(10,18) as vol_stake_usd

avalanche.core.ez_decoded_event_logs a

LEFT JOIN avax_price b

ON date_trunc('day', a.block_timestamp) = b.date

event_name in ('Submitted','Redeem')

AND tx_status = 'SUCCESS'

AND contract_name = 'Staked AVAX'

and date_trunc('day', a.block_timestamp) >= current_date - {{last_N_days}}

GROUP by 1