DAY | NEW_ADDRESSES | NEW_ADDRESSES_CUMULATIVE | |
|---|---|---|---|
1 | 2025-04-18 00:00:00.000 | 6 | 131620 |
2 | 2025-04-17 00:00:00.000 | 113 | 131614 |
3 | 2025-04-16 00:00:00.000 | 110 | 131501 |
4 | 2025-04-15 00:00:00.000 | 137 | 131391 |
5 | 2025-04-14 00:00:00.000 | 113 | 131254 |
6 | 2025-04-13 00:00:00.000 | 123 | 131141 |
7 | 2025-04-12 00:00:00.000 | 173 | 131018 |
8 | 2025-04-11 00:00:00.000 | 145 | 130845 |
9 | 2025-04-10 00:00:00.000 | 211 | 130700 |
10 | 2025-04-09 00:00:00.000 | 230 | 130489 |
11 | 2025-04-08 00:00:00.000 | 298 | 130259 |
12 | 2025-04-07 00:00:00.000 | 408 | 129961 |
13 | 2025-04-06 00:00:00.000 | 540 | 129553 |
14 | 2025-04-05 00:00:00.000 | 428 | 129013 |
15 | 2025-04-04 00:00:00.000 | 39 | 128585 |
16 | 2025-04-03 00:00:00.000 | 57 | 128546 |
17 | 2025-04-02 00:00:00.000 | 54 | 128489 |
18 | 2025-04-01 00:00:00.000 | 75 | 128435 |
19 | 2025-03-31 00:00:00.000 | 54 | 128360 |
20 | 2025-03-30 00:00:00.000 | 35 | 128306 |
pietrektNew Addresses daily and cumulative
Updated 22 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 22 hours agoAuto-refreshes every 24 hours
...
1447
53KB
7s