BLOCKCHAIN | TOTAL_TRANSACTION_VOLUME | TOTAL_TRANSACTION_FEES | AVG_GAS_PRICE | TOTAL_GAS_USED | TOTAL_TRANSACTIONS | AVG_TRANSACTION_VALUE | AVG_TRANSACTION_FEE | SUCCESS_RATE | |
|---|---|---|---|---|---|---|---|---|---|
1 | Kaia | 2570464199.19652 | 114521.622504438 | 33.686122852 | 3094006013016 | 20484624 | 125.482615605 | 0.005590613843 | 0.989311 |
2 | Avalanche | 142415071.469028 | 19447.160602589 | 14.072065693 | 2392034517741 | 7862501 | 18.113202335 | 0.002473406439 | 0.894345 |
kentodevoted-harlequin
Updated 2025-02-23
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 kaia_feb_2025 AS (
SELECT
SUM(VALUE) AS total_transaction_volume,
SUM(TX_FEE) AS total_transaction_fees,
AVG(GAS_PRICE) AS avg_gas_price,
SUM(GAS_USED) AS total_gas_used,
COUNT(*) AS total_transactions,
AVG(VALUE) AS avg_transaction_value,
AVG(TX_FEE) AS avg_transaction_fee,
SUM(CASE WHEN TX_SUCCEEDED THEN 1 ELSE 0 END) * 1.0 / COUNT(*) AS success_rate
FROM kaia.core.fact_transactions
WHERE BLOCK_TIMESTAMP >= '2025-02-01' AND BLOCK_TIMESTAMP < '2025-03-01'
),
avalanche_feb_2025 AS (
SELECT
SUM(VALUE) AS total_transaction_volume,
SUM(TX_FEE) AS total_transaction_fees,
AVG(GAS_PRICE) AS avg_gas_price,
SUM(GAS_USED) AS total_gas_used,
COUNT(*) AS total_transactions,
AVG(VALUE) AS avg_transaction_value,
AVG(TX_FEE) AS avg_transaction_fee,
SUM(CASE WHEN TX_SUCCEEDED THEN 1 ELSE 0 END) * 1.0 / COUNT(*) AS success_rate
FROM avalanche.core.fact_transactions
WHERE BLOCK_TIMESTAMP >= '2025-02-01' AND BLOCK_TIMESTAMP < '2025-03-01'
)
SELECT
'Kaia' AS blockchain,
total_transaction_volume,
total_transaction_fees,
avg_gas_price,
total_gas_used,
total_transactions,
avg_transaction_value,
avg_transaction_fee,
success_rate
Last run: 3 months ago
2
237B
2s