datavortexActive Traders
    Updated 2024-09-04
    SELECT
    DATE_TRUNC('week', block_timestamp) AS month,
    COUNT(DISTINCT trader_address) AS unique_traders
    FROM
    (
    SELECT
    block_timestamp,
    seller_address AS trader_address
    FROM
    optimism.nft.ez_nft_sales
    UNION
    SELECT
    block_timestamp,
    buyer_address AS trader_address
    FROM
    optimism.nft.ez_nft_sales
    ) AS unique_traders
    GROUP BY
    DATE_TRUNC('week', block_timestamp)
    ORDER BY
    month;

    QueryRunArchived: QueryRun has been archived