picasoDaily Unique Addresses
Updated 2025-01-29
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
›
⌄
WITH Daily_Address_Count AS (
SELECT
DATE(BLOCK_TIMESTAMP) AS Date,
ORIGIN_FROM_ADDRESS,
CASE
WHEN BLOCK_TIMESTAMP < '2024-12-16 17:00:00.000' THEN 'Before_Update'
ELSE 'After_Update'
END AS Time_Period
FROM
avalanche.core.ez_decoded_event_logs
WHERE
BLOCK_TIMESTAMP BETWEEN '2024-11-16 17:00:00.000'
AND '2025-01-16 17:00:00.000'
GROUP BY
Date,
ORIGIN_FROM_ADDRESS,
Time_Period
)
SELECT
Time_Period,
Date,
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS Unique_Addresses
FROM
Daily_Address_Count
GROUP BY
Time_Period,
Date
ORDER BY
Time_Period,
Date;
QueryRunArchived: QueryRun has been archived