msafadoostThose who buy nft in last 6 month
    Updated 2022-06-09
    WITH minters AS (
    SELECT NFT_TO_ADDRESS
    FROM ethereum.core.ez_nft_mints
    WHERE BLOCK_TIMESTAMP >= '2022-06-07 16:00:00.000'
    AND BLOCK_TIMESTAMP <= '2022-06-07 17:00:00.000'
    AND MINT_PRICE_ETH = '0.1'
    AND NFT_ADDRESS = '0x903e2f5d42ee23156d548dd46bb84b7873789e44'
    GROUP BY 1
    )
    SELECT
    COUNT(DISTINCT(BUYER_ADDRESS)) AS nft_buyers
    FROM ethereum.core.ez_nft_sales
    WHERE BLOCK_TIMESTAMP >= CURRENT_DATE - 180
    AND BLOCK_TIMESTAMP <= '2022-06-07 16:00:00.000'
    AND BUYER_ADDRESS IN (
    SELECT NFT_TO_ADDRESS FROM minters
    )
    AND PRICE > '0'
    Run a query to Download Data