block_timestamp::date as date,

count(distinct(tx_id)) as txn_count,

sum(sales_amount) as total_sales_amount,

count(distinct (purchaser)) as buyer_count,

count(distinct seller) as seller_count,

sum(txn_count) over (order by date) as com_txn,

sum(buyer_count) over (order by date) as com_buyer,

sum(seller_count) over (order by date) as com_seller,

sum(total_sales_amount) over (order by date) as com_sales_amount

from solana.core.fact_nft_sales

where marketplace = 'coral cube'

and succeeded = true

group by date

order by date