0x_spadeSEI Number of Transactions from Jan 2024 (EVM)
    Updated 2024-10-09
    SELECT
    count(distinct tx_hash) as n_transactions,
    date_trunc('month', Block_timestamp) as Month,
    sum(count(distinct tx_hash)) OVER (ORDER BY date_trunc('month', block_timestamp)) as cumulative_transactions
    FROM sei.core_evm.fact_transactions
    WHERE block_timestamp:: date >= '2024-01-01'
    GROUP BY MONTH
    ORDER BY MONTH asc
    ;
    QueryRunArchived: QueryRun has been archived