kentonew total
Updated 2025-02-23
999
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,
COUNT(*) / (28 * 86400.0) AS transactions_per_second, -- TPS for February (28 days)
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,
COUNT(*) / (28 * 86400.0) AS transactions_per_second, -- TPS for February (28 days)
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'
),
arbitrum_feb_2025 AS (
SELECT
SUM(VALUE) AS total_transaction_volume,
SUM(TX_FEE) AS total_transaction_fees,
AVG(GAS_PRICE_BID) AS avg_gas_price,
SUM(GAS_USED) AS total_gas_used,
COUNT(*) AS total_transactions,
COUNT(*) / (28 * 86400.0) AS transactions_per_second, -- TPS for February (28 days)
QueryRunArchived: QueryRun has been archived