CryptoIcicleThe Battle of the Solana NFT Aggregator - MarketPlace
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
›
⌄
-- A new sector of NFT marketplaces have begun to gain popularity on Solana, the NFT AMM. One of the most notable NFT AMMs on Solana so far is Hadeswap.
-- Pay by Quality Your score determines your final payout.
-- Grand Prize 3.572 SOL (A score of 11 or 12 earns you a Grand Prize title)
-- Payout 2.381 SOL
-- Score Multiplier0-7 : 0% 8 : 50% 9 : 75% 10 : 100% 11 : 125% 12 : 150%
-- Payout Network Solana
-- Level Intermediate
-- Difficulty Hard
-- Hyperspace and Coral Cube are the two most popular NFT aggregators on Solana.
-- This means that they list all NFTs across different marketplaces along with allowing listings on their own marketplace.
-- Create a dashboard comparing KPIs between Hyperspace and Coral Cube.
-- Which marketplace has done more volume? Which collections are popular on each marketplace? Why would I use one marketplace over the other?
-- Are there any noticeable market trends between the marketplaces, especially after Solana marketplaces moved to a 0% creator royalty?
-- SQL Credit: https://app.flipsidecrypto.com/velocity/queries/4fb4a340-7a32-4b5a-b110-d20ccf1aa2e3
with sportnfts as (
select address_name as a_name, address from solana.core.dim_labels
-- where address_name in ('Hockey Heroes','Collectorz Club: The Collectorz','collectorz club gen1','The Suites','Laidback Lions','Sports Rewind')
),
SOLPricet as (
select block_timestamp::date as day,
avg (swap_to_amount/swap_from_amount) as SOLprice
from solana.fact_swaps
where swap_from_mint = 'So11111111111111111111111111111111111111112' --SOL
and swap_to_mint in ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v','Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB') --USDC,USDT
and swap_to_amount > 0
and swap_from_amount > 0
and succeeded = 'TRUE'
and block_timestamp >= CURRENT_DATE - {{n_days}}
group by 1)
select
date_trunc('{{date_range}}',block_timestamp) as date,
Run a query to Download Data