bachiquix mkt2
    Updated 2022-09-28
    with quix_nfts as (
    SELECT tx_hash AS tx_id
    , block_timestamp
    , buyer_address AS buyer
    , seller_address AS seller
    , nft_address
    , NULL AS project_name
    , currency_symbol
    , price
    , price_usd
    FROM optimism.core.ez_nft_sales
    WHERE platform_name = 'quixotic'
    AND block_timestamp >= '2022-01-01'
    )

    select date(block_timestamp) as day,
    count(distinct tx_id) as no_of_txns,
    count(distinct buyer) as no_of_users,
    round(sum(price),2) as tot_volume,
    round(sum(price_usd),2) as tot_volume_usd
    from quix_nfts
    group by day
    order by day desc
    Run a query to Download Data