Timestamp | All TXNs Fee | Cumulative New Users | Returning Users | Total Active Users | Total New Users | Transactions | |
|---|---|---|---|---|---|---|---|
1 | 2025-03-01 00:00:00.000 | 11.960645898659914 | 2878405 | 104979 | 127868 | 22889 | 1008160 |
2 | 2025-02-01 00:00:00.000 | 21.485838578458626 | 2855516 | 140874 | 181013 | 40139 | 1380172 |
3 | 2025-01-01 00:00:00.000 | 42.66147192663485 | 2815377 | 204092 | 256513 | 52421 | 1585569 |
4 | 2024-12-01 00:00:00.000 | 46.788704624616415 | 2762956 | 309477 | 370188 | 60711 | 2290091 |
5 | 2024-11-01 00:00:00.000 | 69.57261167014143 | 2702245 | 466049 | 536046 | 69997 | 3006383 |
6 | 2024-10-01 00:00:00.000 | 279.4994296428417 | 2632248 | 1027963 | 1178879 | 150916 | 13238685 |
7 | 2024-09-01 00:00:00.000 | 193.8819145086439 | 2481332 | 811724 | 857700 | 45976 | 8778952 |
8 | 2024-08-01 00:00:00.000 | 179.34732783967948 | 2435356 | 657773 | 701064 | 43291 | 8644875 |
9 | 2024-07-01 00:00:00.000 | 381.5822417530146 | 2392065 | 920328 | 993276 | 72948 | 10253423 |
10 | 2024-06-01 00:00:00.000 | 403.60762460966066 | 2319117 | 918781 | 1062545 | 143764 | 9628384 |
11 | 2024-05-01 00:00:00.000 | 680.1605652626373 | 2175353 | 928769 | 1100032 | 171263 | 10995938 |
12 | 2024-04-01 00:00:00.000 | 1959.716108541022 | 2004090 | 925041 | 1093653 | 168612 | 8821687 |
13 | 2024-03-01 00:00:00.000 | 3521.8848544871485 | 1835478 | 848631 | 1042312 | 193681 | 10061465 |
14 | 2024-02-01 00:00:00.000 | 2296.4530213818025 | 1641797 | 552192 | 813943 | 261751 | 7176974 |
15 | 2024-01-01 00:00:00.000 | 1037.2510676544496 | 1380046 | 543934 | 635997 | 92063 | 4857519 |
16 | 2023-12-01 00:00:00.000 | 1674.0907543657177 | 1287983 | 697468 | 904898 | 207430 | 4337003 |
17 | 2023-11-01 00:00:00.000 | 1311.813284996816 | 1080553 | 146557 | 958425 | 811868 | 4189842 |
18 | 2023-10-01 00:00:00.000 | 420.08955209124406 | 268685 | 0 | 268685 | 268685 | 1798417 |
eferScroll_Users
Updated 20 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT
CAST(REPLACE(value:"date_time", ' UTC', '') AS DATE) AS "Timestamp",
value:"all_tx_fee" AS "All TXNs Fee",
value:"cumulative_new_users"::numeric AS "Cumulative New Users",
value:"returning_users"::numeric AS "Returning Users",
value:"total_active_users"::numeric AS "Total Active Users",
value:"total_new_users"::numeric AS "Total New Users",
value:"txs"::numeric AS "Transactions"
FROM (
SELECT livequery.live.udf_api(
'https://raw.githubusercontent.com/eferbarn/scroll-marks-sampler/main/assets/Users.json'
) AS response
), lateral FLATTEN (input => response:data:data:rows)
Last run: about 20 hours agoAuto-refreshes every 24 hours
18
1KB
2s