rackhaelHoliday season - Polygon Transactions and Unique Addresses
Updated 2023-01-12
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 ALL_ADDRESSES AS (
SELECT
date_trunc('day',BLOCK_TIMESTAMP) AS "DATE",
FROM_ADDRESS AS "ADDRESS"
FROM polygon.core.fact_transactions
WHERE "DATE" >= '2022-11-24'
GROUP BY 1,2
ORDER BY 1
),
NEW_ADDRESSES AS(
SELECT
date_trunc('day',BLOCK_TIMESTAMP) AS "DATE",
FROM_ADDRESS AS "ADDRESS"
FROM polygon.core.fact_transactions
WHERE "DATE" >= '2022-11-24'
GROUP BY 1,2
ORDER BY 1
)
/*TO_ADDRESSES AS (
SELECT
date_trunc('day',BLOCK_TIMESTAMP) AS "DATE",
TO_ADDRESS AS "ADDRESS"
FROM polygon.core.fact_transactions
WHERE "DATE" >= '2022-11-24T00:00:00Z'
-- GROUP BY 1
ORDER BY 1
),*/
/*ALL_ADDRESSES AS (
(SELECT * FROM ALL_ADDRESSES)
UNION
(SELECT * FROM NEW_ADDRESSES)
),*/
ADDRESS_COUNT AS(
SELECT
"DATE",
COUNT(DISTINCT(A."ADDRESS")) AS "N_UNIQUE_ADDRESSES"
Run a query to Download Data