Query editor
WITHvote AS (SELECT*,SUM(vote_count) OVER (ORDER BYdt ROWS BETWEEN UNBOUNDED PRECEDINGAND CURRENT ROW) AS total_vote_countFROM(SELECTCOUNT(DISTINCT hash) AS vote_count,DATE_TRUNC('day', TRY_CAST(block_time AS DATE)) AS dtFROMbnb.transactionsWHERE"to" = 0x62ee96e6365ab515ec647c065c2707d1122d7b26GROUP BY2) AS a),voter AS (SELECTCOUNT(DISTINCT "from") AS unique_voterFROMbnb.transactionsWHERE"to" = 0x62ee96e6365ab515ec647c065c2707d1122d7b26)SELECTvote_count,total_vote_count AS cumulative_vote_count,unique_voter,dtFROMvote,voter