mz0111NFT sales
    Updated 2022-10-02
    SELECT
    BLOCK_TIMESTAMP:: date as date,
    case
    when block_number < '15537351' then 'Pre-Merge'
    when block_number >= '15537351' then 'Post-Merge'
    end as "Period",
    count( distinct TX_HASH) as "sales count",
    count(distinct SELLER_ADDRESS ) as "unique sellers num",
    count(distinct BUYER_ADDRESS ) as "unique buyers num",
    sum(PRICE_USD) as "USD amount",
    "unique buyers num" / "unique sellers num" AS "unique buyers num / unique sellers num",
    "USD amount" / "sales count" AS "USD amount / sales count",
    sum ("USD amount") over (order by block_timestamp :: date) as "Cumulative USD amount",
    sum ("sales count") over (order by block_timestamp :: date) as "Cumulative sales count"
    from ethereum.core.ez_nft_sales
    where BLOCK_TIMESTAMP >= CURRENT_DATE-34
    and EVENT_TYPE = 'sale'
    group by 1 , 2
    Run a query to Download Data