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