CrypticylNear Total Sales Volume July
    Updated 2024-08-12
    SELECT SUM(Sales_Volume) AS Total_Sales_Volume_July
    FROM (
    SELECT DATE_TRUNC('day', BLOCK_TIMESTAMP) AS Sale_Date, COUNT(*) AS Sales_Volume
    FROM near.nft.ez_nft_sales
    WHERE BLOCK_TIMESTAMP >= '2024-07-01' AND BLOCK_TIMESTAMP < '2024-08-01'
    GROUP BY Sale_Date
    ) AS July_Sales;
    QueryRunArchived: QueryRun has been archived