TIME | Weekly users | Weekly transactions | |
|---|---|---|---|
1 | 2025-02-24 00:00:00.000 | 506732 | 6955653 |
2 | 2025-02-17 00:00:00.000 | 613974 | 6438723 |
3 | 2025-02-10 00:00:00.000 | 510957 | 5509945 |
4 | 2025-02-03 00:00:00.000 | 398186 | 7042412 |
5 | 2025-01-27 00:00:00.000 | 354758 | 5800961 |
6 | 2025-01-20 00:00:00.000 | 423606 | 5429433 |
7 | 2025-01-13 00:00:00.000 | 379300 | 5839342 |
8 | 2025-01-06 00:00:00.000 | 387989 | 5325552 |
9 | 2024-12-30 00:00:00.000 | 414957 | 5470616 |
10 | 2024-12-23 00:00:00.000 | 340050 | 5821854 |
11 | 2024-12-16 00:00:00.000 | 371172 | 7425855 |
12 | 2024-12-09 00:00:00.000 | 354202 | 7028317 |
13 | 2024-12-02 00:00:00.000 | 433597 | 6914502 |
14 | 2024-11-25 00:00:00.000 | 421786 | 6346313 |
15 | 2024-11-18 00:00:00.000 | 291663 | 6487892 |
16 | 2024-11-11 00:00:00.000 | 292973 | 6267602 |
17 | 2024-11-04 00:00:00.000 | 355488 | 5729930 |
18 | 2024-10-28 00:00:00.000 | 391569 | 5708339 |
19 | 2024-10-21 00:00:00.000 | 482480 | 5364520 |
20 | 2024-10-14 00:00:00.000 | 420303 | 5841765 |
tkvresearchOptimism I txs + user
Updated 10 days ago
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select date_trunc('week',block_timestamp) as time,
count(DISTINCT from_address) as "Weekly users",
count(DISTINCT tx_hash) as "Weekly transactions"
from Optimism.core.fact_transactions
where status = 'SUCCESS'
and date_trunc('week',block_timestamp) != date_trunc('week',current_date())
group by 1
order by 1 desc
Last run: 10 days ago
...
173
7KB
86s