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,

date_trunc('{{interval}}', a.block_timestamp) as date,

count(DISTINCT origin_from_address) as n_stakers,

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

sum(vol_stake)over(partition by event_name order by date_trunc('{{interval}}', a.block_timestamp)) as cum_vol_stake,

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

sum(vol_stake_usd)over(partition by event_name order by date_trunc('{{interval}}', a.block_timestamp)) as cum_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'

GROUP by 1,2