DAY | NEW_ADDRESSES | NEW_ADDRESSES_CUMULATIVE | |
---|---|---|---|
1 | 2025-05-22 00:00:00.000 | 5 | 136762 |
2 | 2025-05-21 00:00:00.000 | 98 | 136757 |
3 | 2025-05-20 00:00:00.000 | 97 | 136659 |
4 | 2025-05-19 00:00:00.000 | 83 | 136562 |
5 | 2025-05-18 00:00:00.000 | 89 | 136479 |
6 | 2025-05-17 00:00:00.000 | 78 | 136390 |
7 | 2025-05-16 00:00:00.000 | 72 | 136312 |
8 | 2025-05-15 00:00:00.000 | 103 | 136240 |
9 | 2025-05-14 00:00:00.000 | 108 | 136137 |
10 | 2025-05-13 00:00:00.000 | 122 | 136029 |
11 | 2025-05-12 00:00:00.000 | 156 | 135907 |
12 | 2025-05-11 00:00:00.000 | 145 | 135751 |
13 | 2025-05-10 00:00:00.000 | 144 | 135606 |
14 | 2025-05-09 00:00:00.000 | 200 | 135462 |
15 | 2025-05-08 00:00:00.000 | 247 | 135262 |
16 | 2025-05-07 00:00:00.000 | 120 | 135015 |
17 | 2025-05-06 00:00:00.000 | 314 | 134895 |
18 | 2025-05-05 00:00:00.000 | 297 | 134581 |
19 | 2025-05-04 00:00:00.000 | 404 | 134284 |
20 | 2025-05-03 00:00:00.000 | 200 | 133880 |
pietrektNew Addresses daily and cumulative
Updated 16 hours ago
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
transactions AS (
SELECT
to_address as address,
to_date(block_timestamp) as date
FROM
thorchain.core.fact_transfer_events
UNION ALL
SELECT
from_address as address,
to_date(block_timestamp) as date
FROM
thorchain.core.fact_transfer_events
),
address_first_day AS (
SELECT
address,
MIN(date) as date
FROM
transactions
GROUP BY
address
ORDER BY
date,
address
),
dates AS (
SELECT DISTINCT
date,
0 as address_count_change
FROM
transactions
),
address_count_per_day AS (
SELECT
date,
Last run: about 16 hours agoAuto-refreshes every 24 hours
...
1481
54KB
5s