alfredfx10Monthly Sales Volume Analysis by Marketplace
    Updated 2024-07-01
    SELECT DATE_TRUNC('month', BLOCK_TIMESTAMP) AS Month,
    SUM(PRICE_USD) AS "Sales Volume", PLATFORM_NAME
    FROM base.nft.ez_nft_sales
    WHERE BLOCK_TIMESTAMP >= '2024-01-01' AND
    BLOCK_TIMESTAMP<='2024-06-30'
    GROUP BY Month,3

    QueryRunArchived: QueryRun has been archived