flipside

    Daily transaction volume accross market
    SpecterDaily transaction volume accross market
    Updated 2024-05-07
    SELECT DATE_TRUNC(DAY, BLOCK_TIMESTAMP) AS DATE,
    PLATFORM_NAME AS Marketplace, COUNT(*) AS Transactioncount,
    FROM optimism.nft.ez_nft_sales
    WHERE date < current_date
    GROUP BY DATE, PLATFORM_NAME
    ORDER BY DATE DESC
    QueryRunArchived: QueryRun has been archived