Echo5577DAILY STATS
    Updated 2025-04-30
    SELECT
    DATE_TRUNC('day', BLOCK_TIMESTAMP) AS Day,
    MARKETPLACE,
    COUNT(*) AS NFT_SALES,
    COUNT(DISTINCT buyer_address) AS Total_Unique_Buyers,
    COUNT(DISTINCT seller_address) AS Total_Unique_Sellers,
    COUNT(DISTINCT MINT) AS NFT_MINTS
    FROM
    solana.nft.ez_nft_sales
    WHERE
    BLOCK_TIMESTAMP >= '2025-01-01' AND BLOCK_TIMESTAMP <= '2024-05-01'
    GROUP BY
    Day, MARKETPLACE
    ORDER BY
    Day DESC, MARKETPLACE;

    Last run: 29 days ago
    No Data to Display
    0
    2B
    1s