CrypticylNear Number of Bridge Transactions Per Day August 2024
    Updated 2024-08-23
    SELECT
    DATE_TRUNC('day', BLOCK_TIMESTAMP) AS day,
    COUNT(TX_HASH) AS total_transactions
    FROM
    near.defi.ez_bridge_activity
    WHERE
    BLOCK_TIMESTAMP >= '2024-08-01' AND BLOCK_TIMESTAMP < '2024-09-01'
    GROUP BY
    day
    ORDER BY
    day;

    QueryRunArchived: QueryRun has been archived