WITH avax_price AS (

SELECT

AVG(PRICE) AS price

FROM

avalanche.price.ez_prices_hourly

WHERE

SYMBOL = 'WAVAX'

AND DATE(HOUR) = CURRENT_DATE()

),

Stake AS (

SELECT

Date_trunc('Day', Block_timestamp) AS Date,

COUNT(DISTINCT decoded_log:user) AS Total_Stakers,

SUM(

CASE

WHEN event_name = 'Submitted' THEN decoded_log:avaxAmount * 1e-18

ELSE 0

END

) AS submitted_amount,

SUM(

CASE

WHEN event_name = 'Redeem' THEN -decoded_log:avaxAmount * 1e-18

ELSE 0

END

) AS redeemed_amount,

SUM(

CASE

WHEN event_name = 'AccrueRewards' THEN decoded_log:value * 1e-18

ELSE 0

END

) AS accrued_rewards

FROM

avalanche.core.ez_decoded_event_logs