with nft_sales_transactions as (

select block_timestamp,buyer as purchaser,

tx_id,price

from flow.core.ez_nft_sales

SELECT

date_trunc('day',block_timestamp) as date,

count(distinct tx_id) as sales,

count(DISTINCT purchaser) as buyers,

sum(price) as usd_volume,

sum(usd_volume) over (order by date) as Cumulative_Volume_usd,

sum(sales) over (order by date) as Cumulative_Sales,

sum(buyers) over (order by date) as cumulative_buyers

FROM nft_sales_transactions

where block_timestamp >= '2022-01-01'

GROUP BY 1