mucryptoUntitled Query
    Updated 2023-01-13
    -- SELECT
    -- COUNT (DISTINCT tx_hash)

    -- FROM ethereum.core.ez_nft_sales

    -- WHERE platform_name = 'opensea'
    -- AND event_type = 'sale'
    -- AND block_timestamp::DATE BETWEEN '2022-06-01' AND '2022-06-30'

    SELECT
    count(tx_hash) as n_records,
    count(distinct tx_hash) as "Number of Transactions"
    FROM ethereum.core.ez_nft_sales
    WHERE
    block_timestamp::DATE BETWEEN '2022-06-01' AND '2022-06-30'
    AND platform_name = 'opensea'
    ;
    Run a query to Download Data