trunc(block_timestamp,'day') AS date,

marketplace as secondary_market,

count(distinct tx_id) AS transactions,

sum(transactions) over (partition by secondary_market order by date) as cum_transactions,

sum(sales_amount) as volume_of_sales,

sum(volume_of_sales) over (partition by secondary_market order by date) as cum_volume_sales,

avg(sales_amount) as avg_nft_price,

avg(avg_nft_price) over (partition by secondary_market order by date) as cum_avg_price,

count(purchaser) as users,

sum(users) over (partition by secondary_market order by date) as cum_users

from solana.core.fact_nft_sales

group by 1,2

order by 1 asc