BLOCKCHAIN | DATE | DAILY_ACTIVE_USER | Daily # of TXs | |
|---|---|---|---|---|
1 | Blast | 2024-05-01 00:00:00.000 | 595727 | 20750241 |
2 | Base | 2024-05-01 00:00:00.000 | 3963929 | 67203902 |
3 | Optimism | 2024-05-01 00:00:00.000 | 2023318 | 17538097 |
4 | Arbitrum | 2024-05-01 00:00:00.000 | 8119283 | 73646316 |
5 | Optimism | 2021-11-01 00:00:00.000 | 34252 | 636341 |
6 | Arbitrum | 2021-11-01 00:00:00.000 | 77989 | 782850 |
7 | Optimism | 2022-04-01 00:00:00.000 | 73080 | 1682900 |
8 | Arbitrum | 2022-04-01 00:00:00.000 | 188767 | 2087195 |
9 | Optimism | 2022-05-01 00:00:00.000 | 122192 | 2781529 |
10 | Arbitrum | 2022-05-01 00:00:00.000 | 214157 | 2749735 |
11 | Blast | 2024-11-01 00:00:00.000 | 156826 | 16576892 |
12 | Base | 2024-11-01 00:00:00.000 | 18680731 | 221392662 |
13 | Optimism | 2024-11-01 00:00:00.000 | 1095696 | 28240993 |
14 | Arbitrum | 2024-11-01 00:00:00.000 | 3668742 | 77476157 |
15 | Base | 2024-01-01 00:00:00.000 | 886219 | 10993591 |
16 | Optimism | 2024-01-01 00:00:00.000 | 1140973 | 12473069 |
17 | Arbitrum | 2024-01-01 00:00:00.000 | 2371826 | 39235724 |
18 | Blast | 2024-04-01 00:00:00.000 | 444113 | 14956145 |
19 | Base | 2024-04-01 00:00:00.000 | 3946396 | 82932613 |
20 | Optimism | 2024-04-01 00:00:00.000 | 2302181 | 20751126 |
rezarwzDaily Active User
Updated 2025-02-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
SELECT
*
FROM
(SELECT
'Blast' as blockchain,
date_trunc('{{time_frame}}', block_Timestamp) as date,
count(DISTINCT from_address) as Daily_Active_User,
count(tx_hash) as "Daily # of TXs"
FROM
blast.core.fact_transactions
where
block_Timestamp :: date >= '{{day_from}}'
and block_Timestamp :: date <= '{{day_to}}'
group by
1,
2
union
all
SELECT
'Base' as blockchain,
date_trunc('{{time_frame}}', block_Timestamp) as date,
count(DISTINCT from_address) as Daily_Active_User,
count(tx_hash) as "Daily # of TXs"
FROM
Base.core.fact_transactions
where
block_Timestamp :: date >= '{{day_from}}'
and block_Timestamp :: date <= '{{day_to}}'
group by
1,
2
union
all
SELECT
'Optimism' as blockchain,
date_trunc('{{time_frame}}', block_Timestamp) as date,
Last run: 2 months ago
...
116
6KB
327s