kentonew total
    Updated 2025-02-23
    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