jepraixeirrelevant-azure
    Updated 2025-03-20

    WITH sei_native_data AS (
    SELECT
    COUNT(*) AS total_transactions,
    AVG(SPLIT_PART(fee, 'u', 1)::float / POW(10, 6)) AS avg_transaction_fee
    FROM sei.core.fact_transactions
    WHERE DATE_PART('year', block_timestamp) = 2025
    )
    , sei_evm_data AS (
    SELECT
    COUNT(*) AS total_transactions,
    AVG(tx_fee_precise::float) AS avg_transaction_fee
    FROM sei.core_evm.fact_transactions
    WHERE DATE_PART('year', block_timestamp) = 2025
    )

    -- Combine the Results
    SELECT
    'Sei Native' AS transaction_type,
    total_transactions,
    avg_transaction_fee
    FROM sei_native_data

    UNION ALL

    SELECT
    'Sei EVM' AS transaction_type,
    total_transactions,
    avg_transaction_fee
    FROM sei_evm_data;

    QueryRunArchived: QueryRun has been archived