ACTIVITY_DATE | DAILY_ACTIVE_ADDRESSES | CUMULATIVE_ACTIVE_ADDRESSES | |
|---|---|---|---|
1 | 2025-02-14 00:00:00.000 | 457371 | 116779835 |
2 | 2025-02-13 00:00:00.000 | 584183 | 116322464 |
3 | 2025-02-12 00:00:00.000 | 568714 | 115738281 |
4 | 2025-02-11 00:00:00.000 | 573679 | 115169567 |
5 | 2025-02-10 00:00:00.000 | 529058 | 114595888 |
6 | 2025-02-09 00:00:00.000 | 884858 | 114066830 |
7 | 2025-02-08 00:00:00.000 | 534011 | 113181972 |
8 | 2025-02-07 00:00:00.000 | 544866 | 112647961 |
9 | 2025-02-06 00:00:00.000 | 582552 | 112103095 |
10 | 2025-02-05 00:00:00.000 | 559973 | 111520543 |
11 | 2025-02-04 00:00:00.000 | 555641 | 110960570 |
12 | 2025-02-03 00:00:00.000 | 599118 | 110404929 |
13 | 2025-02-02 00:00:00.000 | 482891 | 109805811 |
14 | 2025-02-01 00:00:00.000 | 636624 | 109322920 |
15 | 2025-01-31 00:00:00.000 | 606642 | 108686296 |
16 | 2025-01-30 00:00:00.000 | 595388 | 108079654 |
17 | 2025-01-29 00:00:00.000 | 628342 | 107484266 |
18 | 2025-01-28 00:00:00.000 | 599925 | 106855924 |
19 | 2025-01-27 00:00:00.000 | 650002 | 106255999 |
20 | 2025-01-26 00:00:00.000 | 500876 | 105605997 |
picasoDaily active address (last year)
Updated 2025-02-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH daily_active_addresses AS (
SELECT
DATE_TRUNC('DAY', block_timestamp) AS activity_date,
from_address AS address
FROM ronin.core.fact_transactions
UNION
SELECT
DATE_TRUNC('DAY', block_timestamp) AS activity_date,
to_address AS address
FROM ronin.core.fact_transactions
)
SELECT
activity_date,
COUNT(DISTINCT address) AS daily_active_addresses,
SUM(COUNT(DISTINCT address)) OVER (ORDER BY activity_date) AS cumulative_active_addresses
FROM daily_active_addresses
GROUP BY activity_date
ORDER BY activity_date DESC;
Last run: about 1 month ago
...
137
6KB
10s