SELECT

TRUNC(e.MODIFIED_TIMESTAMP, 'day') AS epoch_day,

SUM(v.ACTIVE_STAKE) AS total_active_stake_sol

FROM solana.gov.fact_stake_accounts v

JOIN solana.gov.dim_epoch e ON

v.ACTIVATION_EPOCH <= e.EPOCH

AND v.DEACTIVATION_EPOCH >= e.EPOCH

GROUP BY TRUNC(e.MODIFIED_TIMESTAMP, 'day')

ORDER BY TRUNC(e.MODIFIED_TIMESTAMP, 'day') DESC