WITH daily_staking_balances AS (
SELECT
DATE(date) AS date,
SUM(balance) AS total_balance
FROM
near.gov.fact_staking_pool_daily_balances
WHERE
date >= DATEADD(day, -30000000, CURRENT_TIMESTAMP)
GROUP BY
DATE(date)
)
SELECT
date,
total_balance
FROM
daily_staking_balances
ORDER BY
date;