glass_blossomsALGO Unique Wallets, in 3 Months
Updated 2022-03-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT MONTHNAME(block_timestamp) MONTH,
COUNT(DISTINCT address) number_of_wallets
FROM algorand.transaction_participation
WHERE MONTH(block_timestamp) = 1
AND YEAR(block_timestamp) = 2021
GROUP BY MONTHNAME(block_timestamp)
UNION
SELECT MONTHNAME(block_timestamp) MONTH,
COUNT(DISTINCT address) number_of_wallets
FROM algorand.transaction_participation
WHERE MONTH(block_timestamp) = 12
AND YEAR(block_timestamp) = 2021
GROUP BY MONTHNAME(block_timestamp)
UNION
SELECT MONTHNAME(block_timestamp) MONTH,
COUNT(DISTINCT address) number_of_wallets
FROM algorand.transaction_participation
WHERE MONTH(block_timestamp) = 1
AND YEAR(block_timestamp) = 2022
GROUP BY MONTHNAME(block_timestamp)
Run a query to Download Data