hbd19943. These two 🆚 The Whole: Part II
Updated 2022-10-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with solana_nets as
(select
AVG (sales_amount) as "Average SOL Volume per Sale",
Median (sales_amount) as "Median SOL Volume per Sale",
Min (sales_amount) as "Minimum SOL Volume per Sale",
Max (sales_amount) as "Maximum SOL Volume per Sale"
from solana.core.fact_nft_sales
where succeeded = TRUE),
hyper as
(select
AVG (sales_amount) as "Average SOL Volume per Sale",
Median (sales_amount) as "Median SOL Volume per Sale",
Min (sales_amount) as "Minimum SOL Volume per Sale",
Max (sales_amount) as "Maximum SOL Volume per Sale"
from solana.core.fact_nft_sales
where marketplace in ('hyperspace')
and succeeded = TRUE),
coral as
(select
AVG (sales_amount) as "Average SOL Volume per Sale",
Median (sales_amount) as "Median SOL Volume per Sale",
Min (sales_amount) as "Minimum SOL Volume per Sale",
Max (sales_amount) as "Maximum SOL Volume per Sale"
from solana.core.fact_nft_sales
where marketplace in ('coral cube')
and succeeded = TRUE)
select
'Hyperspace' as "Marketplace",
"Average SOL Volume per Sale",
"Median SOL Volume per Sale",
"Minimum SOL Volume per Sale",
"Maximum SOL Volume per Sale"
from hyper
union all
select
Run a query to Download Data