sinahosseinzadehUntitled Query
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 , 'hyperspace' as l from Hyperspace_datas
UNION
select sum(sales_amount) as val , 'coral cube' as l from Coral_Cube_datas
Run a query to Download Data