DATE | Total addresses | cumulative addresses | |
|---|---|---|---|
1 | 2025-03-14 00:00:00.000 | 3375447 | 34955763 |
2 | 2025-03-09 00:00:00.000 | 1294814 | 21640767 |
3 | 2025-03-18 00:00:00.000 | 4369669 | 53693523 |
4 | 2025-02-19 00:00:00.000 | 127071 | 127071 |
5 | 2025-02-21 00:00:00.000 | 465659 | 879260 |
6 | 2025-02-24 00:00:00.000 | 763550 | 2637754 |
7 | 2025-03-02 00:00:00.000 | 1130708 | 10880592 |
8 | 2025-02-28 00:00:00.000 | 1200925 | 8604015 |
9 | 2025-03-15 00:00:00.000 | 4944542 | 39900305 |
10 | 2025-03-03 00:00:00.000 | 1359838 | 12240430 |
11 | 2025-03-07 00:00:00.000 | 1640739 | 18834564 |
12 | 2025-03-12 00:00:00.000 | 3133499 | 27933765 |
13 | 2025-03-13 00:00:00.000 | 3646551 | 31580316 |
14 | 2025-02-23 00:00:00.000 | 552590 | 1874204 |
15 | 2025-02-26 00:00:00.000 | 2108705 | 5950151 |
16 | 2025-02-27 00:00:00.000 | 1452939 | 7403090 |
17 | 2025-03-10 00:00:00.000 | 1182650 | 22823417 |
18 | 2025-03-06 00:00:00.000 | 1501760 | 17193825 |
19 | 2025-03-11 00:00:00.000 | 1976849 | 24800266 |
20 | 2025-02-20 00:00:00.000 | 286530 | 413601 |
Mrftiangry-sapphire
Updated 3 hours ago
9
1
2
3
4
5
6
7
›
⌄
SELECT
date_trunc (day, block_timestamp) as date,
count (DISTINCT from_address) as "Total addresses",
sum ("Total addresses") over (order by date) as "cumulative addresses"
from monad.testnet.fact_transactions
where date > '2025-02-18 00:00:00.000'
GROUP by 1
Last run: about 3 hours agoAuto-refreshes every 12 hours
28
1KB
68s