Crazy_KidActive Daily Wallets Algorand
Updated 2022-03-01
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
›
⌄
WITH jan2022 AS (SELECT date(block_timestamp) as date_jan_2022, COUNT(DISTINCT sender) as active_wallets_jan_2022,
ROW_NUMBER() OVER (ORDER BY date_jan_2022) as row1
FROM algorand.transactions
WHERE date_jan_2022 BETWEEN '2022-01-01' AND '2022-01-31'
GROUP BY date_jan_2022
ORDER BY date_jan_2022),
dec2021 AS (SELECT date(block_timestamp) as date_dec_2021, COUNT(DISTINCT sender) as active_wallets_dec_2021,
ROW_NUMBER() OVER (ORDER BY date_dec_2021) as row2
FROM algorand.transactions
WHERE date_dec_2021 BETWEEN '2021-12-01' AND '2021-12-31'
GROUP BY date_dec_2021
ORDER BY date_dec_2021),
jan2021 AS (SELECT date(block_timestamp) as date_jan_2021, COUNT(DISTINCT sender) as active_wallets_jan_2021,
ROW_NUMBER() OVER (ORDER BY date_jan_2021) as row3
FROM algorand.transactions
WHERE date_jan_2021 BETWEEN '2021-01-01' AND '2021-01-31'
GROUP BY date_jan_2021
ORDER BY date_jan_2021)
SELECT date_jan_2022, active_wallets_jan_2022, date_dec_2021, active_wallets_dec_2021, date_jan_2021, active_wallets_jan_2021
FROM jan2022
JOIN dec2021 ON row1 = row2
JOIN jan2021 ON row1 = row3
ORDER BY row1
Run a query to Download Data