SELECT DATE_DAY AS realms_date, rank() OVER (ORDER BY DATE_DAY) AS day_realms

FROM ethereum.core.dim_dates

WHERE DATE_DAY >= (SELECT MIN(BLOCK_TIMESTAMP)::date FROM solana.core.fact_proposal_votes WHERE GOVERNANCE_PLATFORM = 'realms' AND SUCCEEDED = 'TRUE')

AND DATE_DAY <= CURRENT_DATE ),

Snapshot_day AS (

SELECT DATE_DAY AS SNAP_date, rank() OVER (ORDER BY DATE_DAY) AS day_snapshot

FROM ethereum.core.dim_dates

WHERE DATE_DAY >= (SELECT MIN(VOTE_TIMESTAMP)::date FROM ethereum.core.ez_snapshot)

AND DATE_DAY <= CURRENT_DATE ),

Days AS (

SELECT day_snapshot AS day, SNAP_date, realms_date

FROM Snapshot_day

LEFT JOIN Realms_day ON Realms_day.day_realms = Snapshot_day.day_snapshot

),

t1 AS (

SELECT VOTE_TIMESTAMP::date as dt1, count(*) AS value_snapshot

FROM ethereum.core.ez_snapshot

GROUP BY 1

),

t2 AS (

SELECT BLOCK_TIMESTAMP::date as dt2, count(*) AS value_realms

FROM solana.core.fact_proposal_votes WHERE GOVERNANCE_PLATFORM = 'realms' AND SUCCEEDED = 'TRUE'

GROUP BY 1

SELECT day,

value_snapshot AS Snapshot_votes,