WITH Olash AS (

SELECT block_timestamp, tx_hash, origin_from_address AS voters,

decoded_log:proposalId AS proposalId,

decoded_log:support AS support

FROM ethereum.core.ez_decoded_event_logs

WHERE event_name = 'VoteCast'

and contract_name = 'Governor OLAS'

AND tx_status = 'SUCCESS'

SELECT Date_trunc('month', block_timestamp) AS Date,

COUNT(DISTINCT tx_hash) AS no_of_vote,

SUM(no_of_vote) OVER (ORDER BY date) AS Cum_vote,

COUNT(DISTINCT voters) AS voters

FROM Olash

GROUP BY Date

ORDER BY date Desc