(with tab1 as (

select

date(block_timestamp) as date,

nft_address ,

count(distinct tokenid) as tot

from optimism.core.ez_nft_sales

where block_timestamp >= '2022-07-01'

group by 1 , 2

order by 3 DESC)

select

date,

sum(tot) as "Total Number of NFTs"

from tab1

group by 1

order by 1

),

other as

(select

date(block_timestamp) as date,

count(*) as "Number of Sales",

count(distinct SELLER_ADDRESS) as "Number of Sellers",

count(distinct buyer_address) as "Number of Buyers",

sum(PRICE_USD) as "Sales Amount (USD)"

from optimism.core.ez_nft_sales

where block_timestamp >= '2022-07-01'

group by 1

order by 1)

select

'Quixotic' as "Marketplace",

a.date as "Date",

"Number of Sales",

"Number of Sellers",

"Number of Buyers",