jkhuhnke11Most Active By Category (30d)
Updated 2023-04-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
›
⌄
WITH last_prop AS (
SELECT
space_id,
max(proposal_start_time) :: DATE as last_prop_start_date
FROM ethereum.core.ez_snapshot
GROUP BY space_id
),
votes AS (
SELECT
count(distinct space_id) as voted
FROM last_prop
WHERE last_prop_start_date >= CURRENT_DATE - 30
),
no_vote AS (
SELECT
COUNT(distinct space_id) as have_not_voted
FROM last_prop
WHERE last_prop_start_date < CURRENT_DATE - 30
)
SELECT
voted
FROM votes
UNION
SELECT
have_not_voted
FROM no_vote
Run a query to Download Data