DAY | NEW_ADDRESSES | TOTAL_ADDRESSES | |
|---|---|---|---|
1 | 2024-11-27 00:00:00.000 | 2 | 2 |
2 | 2024-11-28 00:00:00.000 | 19 | 21 |
3 | 2024-12-01 00:00:00.000 | 1 | 22 |
4 | 2024-12-02 00:00:00.000 | 18 | 40 |
5 | 2024-12-03 00:00:00.000 | 248 | 288 |
6 | 2024-12-04 00:00:00.000 | 23 | 311 |
7 | 2024-12-05 00:00:00.000 | 15 | 326 |
8 | 2024-12-06 00:00:00.000 | 37 | 363 |
9 | 2024-12-07 00:00:00.000 | 3 | 366 |
10 | 2024-12-08 00:00:00.000 | 11 | 377 |
11 | 2024-12-09 00:00:00.000 | 56 | 433 |
12 | 2024-12-10 00:00:00.000 | 40 | 473 |
13 | 2024-12-11 00:00:00.000 | 45 | 518 |
14 | 2024-12-12 00:00:00.000 | 17 | 535 |
15 | 2024-12-13 00:00:00.000 | 17 | 552 |
16 | 2024-12-14 00:00:00.000 | 12 | 564 |
17 | 2024-12-15 00:00:00.000 | 8 | 572 |
18 | 2024-12-16 00:00:00.000 | 19 | 591 |
19 | 2024-12-17 00:00:00.000 | 61 | 652 |
20 | 2024-12-18 00:00:00.000 | 28 | 680 |
10Blockchainministerial-jade
Updated 2025-03-04
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
›
⌄
-- 1) Récupérer toutes les adresses apparues dans FROM_ADDRESS ou TO_ADDRESS
WITH all_addresses AS (
SELECT
DATE_TRUNC('DAY', block_timestamp) AS day,
from_address AS address
FROM swell.core.fact_transactions
UNION ALL
SELECT
DATE_TRUNC('DAY', block_timestamp) AS day,
to_address AS address
FROM swell.core.fact_transactions
-- Pas de WHERE tx_succeeded = TRUE
-- Pas de restriction de date
),
-- 2) Retrouver la première date (day) où chaque adresse apparaît
first_appearance AS (
SELECT
address,
MIN(day) AS first_day
FROM all_addresses
WHERE address IS NOT NULL
AND address <> '0x0000000000000000000000000000000000000000'
-- (Optionnel) exclure l’adresse zero si vous ne la comptez pas comme “vraie” address
GROUP BY address
),
-- 3) Compter le nombre de “nouvelles adresses” apparues chaque jour
daily_new AS (
SELECT
first_day AS day,
COUNT(*) AS new_addresses
FROM first_appearance
GROUP BY 1
Last run: about 2 months ago
96
3KB
2s