princefarzamgovernance vs. non-governance
Updated 2022-02-10
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 Time as(
SELECT
block_timestamp,
block_id
FROM algorand.block
),
Addresses as(
SELECT
ADDRESS,
CREATED_AT
FROM algorand.account
),
ADDR_IN_GOVERN_PERIOD1 as (
SELECT
date_trunc('day', T.block_timestamp) AS day,
COUNT(DISTINCT AD.ADDRESS) AS UNIQUE_ADDRESSES_IN_GOVERN_PERIOD1
FROM Addresses AD INNER JOIN Time T ON AD.CREATED_AT=T.block_id
WHERE day::date >= '2021-09-20'
AND day::date <= '2021-10-14'
GROUP BY day
ORDER BY day ASC
),
ADDR_IN_GOVERN_PERIOD2 as (
SELECT
date_trunc('day', T.block_timestamp) AS day,
COUNT(DISTINCT AD.ADDRESS) AS UNIQUE_ADDRESSES_IN_GOVERN_PERIOD2
FROM Addresses AD INNER JOIN Time T ON AD.CREATED_AT=T.block_id
WHERE day::date >= '2021-12-24'
AND day::date <= '2022-01-07'
GROUP BY day
ORDER BY day ASC
),
ADDR_IN_ALL_PERIODS as (
SELECT
Run a query to Download Data