chispastop 20 weekly y00ts whales
    Updated 2023-09-22
    SELECT
    BUYER_ADDRESS AS buyer_address,
    SUM(PRICE_USD) AS usd_spent,
    SUM(PRICE) AS ETH_spent,
    COUNT(*) AS nfts_bought
    FROM
    POLYGON.nft.ez_nft_sales
    WHERE
    PROJECT_NAME = 'y00ts'
    AND EVENT_TYPE = 'sale'
    AND BLOCK_TIMESTAMP > CURRENT_DATE - 7
    AND BUYER_ADDRESS != '0x29469395eaf6f95920e59f858042f0e28d98a20b' -- exclude blur's contract
    GROUP BY
    BUYER_ADDRESS
    HAVING
    SUM(PRICE_USD) > 0
    ORDER BY
    usd_spent DESC
    LIMIT 20;
    Run a query to Download Data