flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Galxe DAO, monthly votes
mucrypto
Galxe DAO, monthly votes
Updated 2024-08-17
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
select
date_trunc
(
'month'
,
proposal_start_time
)
as
"Month"
,
count
(
distinct
voter
)
as
"Votes"
,
sum
(
"Votes"
)
over
(
order
by
"Month"
)
as
"Total Votes Over Time"
from
external
.
snapshot
.
ez_snapshot
where
space_id
=
'gal.eth'
group
by
1
order
by
1
Results
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived