sinahosseinzadehUntitled Query
    Updated 2022-08-28
    SELECT BLOCK_TIMESTAMP::DATE AS DATE,
    COUNT (DISTINCT BUYER_ADDRESS) AS BUYERS_COUNT,
    COUNT (DISTINCT SELLER_ADDRESS) AS SELLERS_COUNT,
    SUM (PRICE) AS ETHPRICE,
    SUM (PRICE_USD) AS USDPRICE
    FROM ethereum.core.ez_nft_sales WHERE EVENT_TYPE ILIKE 'sale' AND PROJECT_NAME ILIKE 'cryptopunks' GROUP BY DATE
    Run a query to Download Data