hbd19946. Common Sellers
Updated 2022-10-31
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
›
⌄
with hyper as (
select
seller as "Sellers",
count (*) as "Number of Sales",
count (distinct mint) as "Number of NFTs",
sum (sales_amount) as "Sales Volume (SOL)"
from solana.core.fact_nft_sales
where marketplace in ('hyperspace')
and succeeded = TRUE
group by 1),
coral as (
select
seller as "Sellers",
count (*) as "Number of Sales",
count (distinct mint) as "Number of NFTs",
sum (sales_amount) as "Sales Volume (SOL)"
from solana.core.fact_nft_sales
where marketplace in ('coral cube')
and succeeded = TRUE
group by 1)
select
a."Sellers",
a."Number of Sales" as "Number of Sales on Hyperspace",
b."Number of Sales" as "Number of Sales on Coral Cube",
a."Number of NFTs" as "Number of Traded NFT on Hyperspace",
b."Number of NFTs" as "Number of Traded NFT on Coral Cube",
a."Sales Volume (SOL)" as "Sales Volume (SOL) on Hyperspace",
b."Sales Volume (SOL)" as "Sales Volume (SOL) on Coral Cube"
from hyper a
join coral b on a."Sellers"=b."Sellers"
Run a query to Download Data