DATE | Total addresses | cumulative addresses | |
|---|---|---|---|
1 | 2024-09-16 00:00:00.000 | 328561 | 45248299 |
2 | 2024-11-22 00:00:00.000 | 198267 | 89895688 |
3 | 2024-10-17 00:00:00.000 | 901605 | 80518485 |
4 | 2024-11-01 00:00:00.000 | 303095 | 84582321 |
5 | 2024-12-06 00:00:00.000 | 261566 | 93087441 |
6 | 2024-08-21 00:00:00.000 | 439640 | 36466576 |
7 | 2024-06-18 00:00:00.000 | 107083 | 472814 |
8 | 2024-08-07 00:00:00.000 | 351532 | 30438863 |
9 | 2024-08-01 00:00:00.000 | 553218 | 27612187 |
10 | 2024-09-03 00:00:00.000 | 300663 | 41080793 |
11 | 2024-11-21 00:00:00.000 | 236008 | 89697421 |
12 | 2024-09-29 00:00:00.000 | 1548159 | 57284586 |
13 | 2024-12-18 00:00:00.000 | 375934 | 96558177 |
14 | 2024-11-13 00:00:00.000 | 281185 | 87716108 |
15 | 2024-07-12 00:00:00.000 | 575824 | 13998354 |
16 | 2024-06-21 00:00:00.000 | 348881 | 1291681 |
17 | 2024-06-23 00:00:00.000 | 287976 | 1830360 |
18 | 2024-09-01 00:00:00.000 | 269899 | 40483328 |
19 | 2024-09-05 00:00:00.000 | 304967 | 41671099 |
20 | 2024-11-27 00:00:00.000 | 240097 | 91008966 |
Mrfti2024-07-25 01:10 AM
Updated 2025-03-05
9
1
2
3
4
5
6
›
⌄
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 berachain.testnet.fact_transactions
GROUP by 1
Last run: about 2 months agoAuto-refreshes every 12 hours
...
246
11KB
1s