datavortexTransaction Trends
    Updated 2024-09-04
    SELECT
    DATE_TRUNC('week', block_timestamp) AS week_start,
    COUNT(DISTINCT tx_hash) AS unique_transactions,
    SUM(price_usd) AS total_volume_usd
    FROM
    optimism.nft.ez_nft_sales
    GROUP BY
    DATE_TRUNC('week', block_timestamp)
    ORDER BY
    week_start;

    QueryRunArchived: QueryRun has been archived