Tobi_1guilty-emerald
    Updated 2024-08-01
    SELECT
    DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,
    PLATFORM_NAME,
    COUNT(TX_HASH) AS transaction_count
    FROM
    polygon.nft.ez_nft_sales;
    WHERE
    BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_TIMESTAMP)
    GROUP BY
    DATE_TRUNC('day', BLOCK_TIMESTAMP),
    PLATFORM_NAME
    ORDER BY
    DATE_TRUNC('day', BLOCK_TIMESTAMP),
    PLATFORM_NAME;

    QueryRunArchived: QueryRun has been archived