inner join solana.core.dim_nft_metadata as meta

on meta.mint=sales.mint

where program_id in ('HYPERfwdTjyJ2SCaKHmpF2MtrXqWxrsotYDsTrshHWq8') and succeeded=1)

, Coral_Cube_datas as (select sales_amount,block_timestamp,purchaser,seller,sales.mint,contract_name from solana.core.fact_nft_sales as sales

inner join solana.core.dim_nft_metadata as meta

on meta.mint=sales.mint

where program_id in ('6U2LkBQ6Bqd1VFt7H76343vpSwS5Tb1rNyXSNnjkf9VL','hausS13jsjafwWwGqZTUQRmWyvyxn9EQpqMwV1PBBmk') and succeeded=1)

select trunc(block_timestamp, 'DAY') as date,count(distinct seller) as seller , count(distinct purchaser) as buyer , count(distinct mint) as mint , count(distinct contract_name) as collections,

'hyperspace' as l from Hyperspace_datas

group by date

select trunc(block_timestamp, 'DAY') as date,count(distinct seller) as seller , count(distinct purchaser) as buyer , count(distinct mint) as mint , count(distinct contract_name) as collections,

'coral cube' as l from Coral_Cube_datas

group by date