DATE | CHAIN | TOTAL_TRANSACTIONS | AVG_TPS | |
|---|---|---|---|---|
1 | 2025-01-01 00:00:00.000 | Arbitrum | 1185238 | 13.72 |
2 | 2025-01-01 00:00:00.000 | Base | 8760628 | 101.4 |
3 | 2025-01-01 00:00:00.000 | Flow | 222193 | 2.57 |
4 | 2025-01-01 00:00:00.000 | Mantle | 403406 | 4.67 |
5 | 2025-01-01 00:00:00.000 | Optimism | 640901 | 7.42 |
6 | 2025-01-02 00:00:00.000 | Arbitrum | 1429130 | 16.54 |
7 | 2025-01-02 00:00:00.000 | Base | 7352806 | 85.1 |
8 | 2025-01-02 00:00:00.000 | Flow | 245677 | 2.84 |
9 | 2025-01-02 00:00:00.000 | Mantle | 424643 | 4.91 |
10 | 2025-01-02 00:00:00.000 | Optimism | 841346 | 9.74 |
11 | 2025-01-03 00:00:00.000 | Arbitrum | 1404270 | 16.25 |
12 | 2025-01-03 00:00:00.000 | Base | 7405310 | 85.71 |
13 | 2025-01-03 00:00:00.000 | Flow | 230655 | 2.67 |
14 | 2025-01-03 00:00:00.000 | Mantle | 394556 | 4.57 |
15 | 2025-01-03 00:00:00.000 | Optimism | 795291 | 9.2 |
16 | 2025-01-04 00:00:00.000 | Arbitrum | 1326276 | 15.35 |
17 | 2025-01-04 00:00:00.000 | Base | 7704907 | 89.18 |
18 | 2025-01-04 00:00:00.000 | Flow | 235336 | 2.72 |
19 | 2025-01-04 00:00:00.000 | Mantle | 381246 | 4.41 |
20 | 2025-01-04 00:00:00.000 | Optimism | 872773 | 10.1 |
adriaparcerisasflow tx vs l2 1.3
Updated 2 days ago
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
›
⌄
WITH
flow_1 as (
select distinct tx_id as tx_hash, block_timestamp, tx_succeeded
from flow.core.fact_transactions
UNION
select distinct tx_hash as tx_id, block_timestamp, tx_succeeded
from flow.core_evm.fact_transactions
),
all_chains AS (
-- Arbitrum transactions
SELECT
DATE_TRUNC('day', block_timestamp) as date,
'Arbitrum' as chain,
COUNT(DISTINCT tx_hash) as total_transactions,
COUNT(DISTINCT tx_hash)/86400.0 as tps
FROM arbitrum.core.fact_transactions
WHERE date < CURRENT_DATE
AND date >= '2025-01-01'
AND status = 'SUCCESS'
-- Exclude system transactions for Arbitrum
AND origin_function_signature <> '0x6bf6a42d'
GROUP BY 1,2
UNION ALL
-- Base transactions
SELECT
DATE_TRUNC('day', block_timestamp) as date,
'Base' as chain,
COUNT(DISTINCT tx_hash) as total_transactions,
COUNT(DISTINCT tx_hash)/86400.0 as tps
FROM base.core.fact_transactions
WHERE date < CURRENT_DATE
AND date >= '2025-01-01'
AND status = 'SUCCESS'
GROUP BY 1,2
Last run: 2 days ago
...
515
25KB
180s