BLOCKCHAIN | TOTAL_TRANSACTIONS | TOTAL_SECONDS | TPS | |
|---|---|---|---|---|
1 | Arbitrum | 25821981 | 2419199 | 10.673773 |
2 | BSC | 93053002 | 2419197 | 38.464417 |
3 | Ethereum | 29793399 | 2419188 | 12.315454 |
4 | NEAR | 11172596 | 2419198 | 4.618306 |
5 | Polygon | 80163484 | 2419198 | 33.136388 |
6 | Swell | 0 |
kentoweak-azure
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 blockchain_data AS (
-- Arbitrum
SELECT
'Arbitrum' AS blockchain,
COUNT(*) AS total_transactions,
MIN(BLOCK_TIMESTAMP) AS start_time,
MAX(BLOCK_TIMESTAMP) AS end_time
FROM
arbitrum.core.fact_transactions
WHERE
BLOCK_TIMESTAMP >= '2023-02-01' AND BLOCK_TIMESTAMP < '2023-03-01'
UNION ALL
-- BSC
SELECT
'BSC' AS blockchain,
COUNT(*) AS total_transactions,
MIN(BLOCK_TIMESTAMP) AS start_time,
MAX(BLOCK_TIMESTAMP) AS end_time
FROM
bsc.core.fact_transactions
WHERE
BLOCK_TIMESTAMP >= '2023-02-01' AND BLOCK_TIMESTAMP < '2023-03-01'
UNION ALL
-- Ethereum
SELECT
'Ethereum' AS blockchain,
COUNT(*) AS total_transactions,
MIN(BLOCK_TIMESTAMP) AS start_time,
MAX(BLOCK_TIMESTAMP) AS end_time
FROM
ethereum.core.fact_transactions
WHERE
Last run: 3 months ago
6
212B
6s