DAY | VOTERS | VOTES | PROPOSALS | |
|---|---|---|---|---|
1 | 2021-04-26 00:00:00.000 | 12118 | 21927 | 324 |
2 | 2021-02-08 00:00:00.000 | 7635 | 13402 | 175 |
3 | 2021-12-27 00:00:00.000 | 36939 | 72355 | 949 |
4 | 2023-07-10 00:00:00.000 | 540934 | 1825935 | 4334 |
5 | 2021-09-06 00:00:00.000 | 10302 | 17868 | 292 |
6 | 2022-09-26 00:00:00.000 | 45242 | 63422 | 668 |
7 | 2021-05-31 00:00:00.000 | 8217 | 23751 | 273 |
8 | 2022-08-01 00:00:00.000 | 51661 | 70678 | 774 |
9 | 2022-07-25 00:00:00.000 | 55558 | 101374 | 813 |
10 | 2020-10-12 00:00:00.000 | 5150 | 6022 | 100 |
11 | 2020-08-17 00:00:00.000 | 169 | 347 | 7 |
12 | 2023-01-16 00:00:00.000 | 94876 | 232100 | 747 |
13 | 2020-11-09 00:00:00.000 | 1369 | 1795 | 82 |
14 | 2022-05-30 00:00:00.000 | 47933 | 72772 | 784 |
15 | 2022-07-11 00:00:00.000 | 21315 | 36653 | 622 |
16 | 2020-10-26 00:00:00.000 | 2625 | 3780 | 123 |
17 | 2022-06-20 00:00:00.000 | 48822 | 158424 | 664 |
18 | 2020-07-27 00:00:00.000 | 122 | 138 | 2 |
19 | 2023-06-26 00:00:00.000 | 158763 | 487189 | 14506 |
20 | 2023-10-09 00:00:00.000 | 222682 | 1692771 | 2402 |
jackguysnapshot 1
Updated 2024-02-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
date_trunc('week', proposal_start_time) as day,
count(DISTINCT voter) as voters,
count(*) as votes,
COUNT(DISTINCT PROPOSAL_ID) as proposals
-- date_trunc('day', block_timestamp) as day,
-- avg(amount_usd / amount)
FROM ethereum.core.ez_snapshot
WHERE proposal_start_time > '2019-01-01'
--WHERE not amount = 0
--WHERE symbol LIKE 'WETH'
GROUP BY 1
--ORDER BY 3 DESC
--LIMIT 1000
Last run: about 1 year ago
...
172
7KB
1s