angel09-SK3z3aHyperspace and Coral Cube: Volume of Sales over time
Updated 2022-10-30
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with Hyperspace_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 ('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 sum(sales_amount) as val , trunc(block_timestamp, 'DAY') as date, 'hyperspace' as l from Hyperspace_datas group by date
UNION
select sum(sales_amount) as val , trunc(block_timestamp, 'DAY') as date, 'coral cube' as l from Coral_Cube_datas group by date
Run a query to Download Data