BLOCKCHAIN | TOTAL_TRANSACTIONS | TRANSACTIONS_PER_SECOND | AVG_GAS_USED_PER_TX | TOTAL_GAS_USED | TOTAL_FEES_PAID | AVG_TRANSACTION_FEE | TOTAL_UNIQUE_WALLETS | FAILED_TRANSACTIONS | |
|---|---|---|---|---|---|---|---|---|---|
1 | near | 192353433 | 79.511207 | 6059123080620.817 | 1.1654931255269499e+21 | 1.1654931356023e+29 | 605912313300018000000 | 43162623 | 1488 |
2 | bsc | 141162642 | 58.350984 | 107774.868069 | 15213785117823 | 45713.879687776 | 0.0003238383686 | 27878264 | 8248802 |
3 | polygon | 95582073 | 39.509818 | 168903.611045 | 16144157280872 | 2187360.96431829 | 0.02288463616 | 7791552 | 9027788 |
4 | arbitrum | 61923597 | 25.596725 | 209724.484817 | 12986894478852 | 816.371337303 | 0.00001318352578 | 7017684 | 8851158 |
5 | ethereum | 35574446 | 14.705118 | 100734.457226 | 3583572508920 | 17200.156848073 | 0.0004834975321 | 11563303 | 557094 |
6 | swell | 1355914 | 0.560481 | 52829.361528 | 71632070907 | 0.3110630839 | 2.294121042e-7 | 7270 | 3220 |
kentothin-pink
Updated 2025-03-01
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 transaction_metrics AS (
SELECT
'arbitrum' AS blockchain,
COUNT(TX_HASH) AS total_transactions,
COUNT(TX_HASH) / NULLIF(EXTRACT(EPOCH FROM MAX(BLOCK_TIMESTAMP)) - EXTRACT(EPOCH FROM MIN(BLOCK_TIMESTAMP)), 0) AS transactions_per_second,
AVG(GAS_USED) AS avg_gas_used_per_tx,
SUM(GAS_USED) AS total_gas_used,
SUM(TX_FEE) AS total_fees_paid,
AVG(TX_FEE) AS avg_transaction_fee,
COUNT(DISTINCT FROM_ADDRESS) + COUNT(DISTINCT TO_ADDRESS) AS total_unique_wallets,
SUM(CASE WHEN TX_SUCCEEDED = FALSE THEN 1 ELSE 0 END) AS failed_transactions
FROM arbitrum.core.fact_transactions
WHERE BLOCK_TIMESTAMP BETWEEN '2025-02-01'::TIMESTAMP AND '2025-03-01'::TIMESTAMP
UNION ALL
SELECT
'bsc' AS blockchain,
COUNT(TX_HASH) AS total_transactions,
COUNT(TX_HASH) / NULLIF(EXTRACT(EPOCH FROM MAX(BLOCK_TIMESTAMP)) - EXTRACT(EPOCH FROM MIN(BLOCK_TIMESTAMP)), 0) AS transactions_per_second,
AVG(GAS_USED) AS avg_gas_used_per_tx,
SUM(GAS_USED) AS total_gas_used,
SUM(TX_FEE) AS total_fees_paid,
AVG(TX_FEE) AS avg_transaction_fee,
COUNT(DISTINCT FROM_ADDRESS) + COUNT(DISTINCT TO_ADDRESS) AS total_unique_wallets,
SUM(CASE WHEN TX_SUCCEEDED = FALSE THEN 1 ELSE 0 END) AS failed_transactions
FROM bsc.core.fact_transactions
WHERE BLOCK_TIMESTAMP BETWEEN '2025-02-01'::TIMESTAMP AND '2025-03-01'::TIMESTAMP
UNION ALL
SELECT
'ethereum' AS blockchain,
COUNT(TX_HASH) AS total_transactions,
COUNT(TX_HASH) / NULLIF(EXTRACT(EPOCH FROM MAX(BLOCK_TIMESTAMP)) - EXTRACT(EPOCH FROM MIN(BLOCK_TIMESTAMP)), 0) AS transactions_per_second,
AVG(GAS_USED) AS avg_gas_used_per_tx,
Last run: 3 months ago
6
646B
68s