FROM solana.core.fact_proposal_votes WHERE GOVERNANCE_PLATFORM LIKE 'realms' GROUP BY VOTER)

,T2 AS (SELECT MIN(VOTE_TIMESTAMP) AS MIND,VOTER

FROM ethereum.core.ez_snapshot WHERE VOTE_TIMESTAMP >= '2021-12-01 10:30:34.000' GROUP BY VOTER)

SELECT 'REALMS' AS PLATFORM,DATE_TRUNC(DAY,MIND) AS MINDD,COUNT(DISTINCT VOTER) AS NEWVOTERS,SUM(NEWVOTERS) OVER (ORDER BY MINDD) AS CUMVOTERS

FROM T1 GROUP BY MINDD

UNION

SELECT 'SNAPSHOT' AS PLATFORM,DATE_TRUNC(DAY,MIND) AS MINDD,COUNT(DISTINCT VOTER) AS NEWVOTERS,SUM(NEWVOTERS) OVER (ORDER BY MINDD) AS CUMVOTERS

FROM T2 GROUP BY Mindd