SELECT

date(block_timestamp) AS date,

sum(event_inputs:amount/pow(10,18)) AS total_daily_staked,

avg(event_inputs:amount/pow(10,18)) AS avg_daily_staked,

max(event_inputs:amount/pow(10,18)) AS max_daily_staked,

sum(total_daily_staked) OVER (ORDER BY date) AS cumulative_staked,

COUNT(DISTINCT event_inputs:user) AS stakers

FROM avalanche.core.fact_event_logs

WHERE tx_status = 'SUCCESS'

AND event_name = 'Staked'

GROUP BY 1

),

min_staked AS (

SELECT

date(block_timestamp) AS date,

min(event_inputs:amount/pow(10,18)) AS min_daily_staked

FROM avalanche.core.fact_event_logs

WHERE tx_status = 'SUCCESS'

AND event_name = 'Staked'

AND event_inputs:amount/pow(10,18) != 0

GROUP BY 1

SELECT

s.date AS "Date",

s.total_daily_staked AS "Daily staked",

s.avg_daily_staked AS "Average staked size",

m.min_daily_staked AS "Minimum staked",

s.max_daily_staked AS "Maximum staked",

s.cumulative_staked AS "Total staked",

s.stakers AS "Daily stakers"

FROM staked s