OneDataAnalystMonthly new Stats
Updated 2022-08-13
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
31
32
33
34
35
36
›
⌄
WITH t1 AS
(
SELECT Month, Count(*) AS new_voters
FROM (
SELECT MIN(Date_trunc('month',PROPOSAL_START_TIME)) AS Month,
VOTER
FROM ethereum.core.ez_snapshot
GROUP BY 2 )
GROUP By 1
),
t2 AS
(
SELECT Month as m2, Count(*) AS new_authors
FROM (
SELECT MIN(Date_trunc('month',PROPOSAL_START_TIME)) AS Month,
PROPOSAL_AUTHOR
FROM ethereum.core.ez_snapshot
GROUP BY 2 )
GROUP By 1
),
t3 AS
(
SELECT Month as m3, Count(*) AS new_spaces
FROM (
SELECT MIN(Date_trunc('month',PROPOSAL_START_TIME)) AS Month,
SPACE_ID
FROM ethereum.core.ez_snapshot
GROUP BY 2 )
GROUP By 1
)
SELECT Month, new_voters, new_authors, new_spaces
FROM t1
Run a query to Download Data