flipside

    Module 2 - Transaction Trend
    feyikemiModule 2 - Transaction Trend
    Updated 2024-03-20
    SELECT
    Date_trunc('Month', BLOCK_TIMESTAMP) AS Month,
    Count(DISTINCT TX_HASH) AS Transactions
    from
    arbitrum.core.fact_transactions
    where
    BLOCK_TIMESTAMP :: Date >= '2024-01-01'
    GROUP BY
    1
    QueryRunArchived: QueryRun has been archived