zakkisyedActive NFT Traders
    Updated 2023-04-06
    WITH sales_by_month AS (
    SELECT
    BUYER_ADDRESS,
    DATE_TRUNC('month', BLOCK_TIMESTAMP) AS month,
    COUNT(*) AS num_sales
    FROM
    ethereum.core.ez_nft_sales
    WHERE
    BLOCK_TIMESTAMP >= '2022-01-01'
    GROUP BY
    1,
    2
    ),

    months_active AS (
    SELECT
    BUYER_ADDRESS,
    COUNT(DISTINCT month) AS num_months_active
    FROM
    sales_by_month
    GROUP BY
    1
    ),

    active_traders AS (
    SELECT
    BUYER_ADDRESS
    FROM
    months_active
    WHERE
    num_months_active >= 12
    )

    SELECT
    COUNT(DISTINCT ez_nft_sales.BUYER_ADDRESS) AS active_traders,
    DATE_TRUNC('month', BLOCK_TIMESTAMP) AS month,
    Run a query to Download Data