WITH Staking_CTE AS (
SELECT
date_trunc('day', block_timestamp) AS day,
COUNT(DISTINCT tx_from) AS stakers_count
FROM
sei.core.fact_transactions
WHERE
msgs LIKE '%bWludGVk%'
GROUP BY
date_trunc('day', block_timestamp)
)
SELECT
day,
stakers_count,
SUM(stakers_count) OVER (ORDER BY day) AS cumulative_stakers_count
FROM
Staking_CTE
ORDER BY
day ASC;