aor67open e 2 high
    Updated 2022-09-22
    WITH town_star AS (
    SELECT * FROM ethereum.core.ez_nft_sales
    WHERE event_type = 'sale'
    AND block_timestamp::DATE >= '2022-01-01'
    AND project_name IN ('town star')
    AND buyer_address <> '0x0000000000000000000000000000000000000000'
    AND price <> '0'
    )

    SELECT tokenid, price_usd, price
    FROM town_star
    ORDER BY 2 DESC
    LIMIT 10
    Run a query to Download Data