Madifirst-time voters 3794
Updated 2023-01-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with ft as (
select voter, min(BLOCK_TIMESTAMP::date) as mindate
from terra.core.fact_governance_votes where TX_SUCCEEDED
group by 1),
ft3612 as (
select
DISTINCT a.voter
from terra.core.fact_governance_votes a
join ft b on a.voter = b.voter and TX_SUCCEEDED and mindate >= '2022-12-12'
where PROPOSAL_ID = '3612'
)
SELECT
BLOCK_TIMESTAMP::date as date,
ROW_NUMBER() OVER(partition by VOTE_OPTION_TEXT ORDER BY date asc) AS Number_of_the_day,
VOTE_OPTION_TEXT, count(DISTINCT TX_ID) as votes
from terra.core.fact_governance_votes
where voter in (select * from ft3612) and TX_SUCCEEDED and PROPOSAL_ID = '3612'
group by 1,3
Run a query to Download Data