flipside

    LAVA TRANSACTION VOLUME
    0x_spadeLAVA TRANSACTION VOLUME
    Updated 2024-08-21
    SELECT TO_CHAR( DATE_TRUNC('month',BLOCK_TIMESTAMP), 'YYYY-MM') AS month, COUNT (TX_id) AS N_transactions,
    FROM lava.core.fact_transactions
    GROUP BY month
    ORDER BY month ASC
    ;
    QueryRunArchived: QueryRun has been archived