date_trunc(day,block_timestamp) as date,

count (distinct tx_id) as Sales_Count,

count (distinct purchaser) as Buyers_Count,

count (distinct seller) as Sellers_Count,

count (distinct mint) as NFTS_Count,

sum (sales_amount) as Total_SOL_Volume,

AVG (sales_amount) as AVG_SOL_Volume,

Median (sales_amount) as Median_SOL_Volume,

Min (sales_amount) as Min_SOL_Volume,

Max (sales_amount) as Max_SOL_Volume,

sum (sales_count) over (order by date) as Cumulative_Sales_Count,

sum (total_sol_volume) over (order by date) as Cumulative_Sales_Volume

from solana.core.fact_nft_sales

where marketplace = 'hyperspace'

and succeeded = 'TRUE'

group by 1,2

union ALL

select 'Coral Cube' as platform,

date_trunc(day,block_timestamp) as date,

count (distinct tx_id) as Sales_Count,

count (distinct purchaser) as Buyers_Count,

count (distinct seller) as Sellers_Count,

count (distinct mint) as NFTS_Count,

sum (sales_amount) as Total_SOL_Volume,

AVG (sales_amount) as AVG_SOL_Volume,

Median (sales_amount) as Median_SOL_Volume,

Min (sales_amount) as Min_SOL_Volume,

Max (sales_amount) as Max_SOL_Volume,

sum (sales_count) over (order by date) as Cumulative_Sales_Count,

sum (total_sol_volume) over (order by date) as Cumulative_Sales_Volume

from solana.core.fact_nft_sales

where marketplace = 'coral cube'

and succeeded = 'TRUE'