CryptoIcicleSolana-84.Hot Ball of Money (Solana NFTs)
Updated 2022-06-14
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
›
⌄
-- Payout 1.18 SOL
-- Grand Prize 3.53 SOL
-- Level Beginner
-- Q84. Compare Solana NFT sales activity on "new" collections to the activity on more established collections within the ecosystem.
-- Has the trend been to buy into the hype or invest in builders for the long term?
-- What do whales seem to be doing? Has it been more profitable to mint/buy these new hyped collections and flip them,
-- or to invest long term into NFT collections?
with collections as (
select
l.label as collection,
min(block_timestamp) as first_sale,
iff(first_sale < '2022-03-01', 'old', 'new') as collection_type
from solana.core.fact_nft_sales m
join solana.core.dim_labels l on m.mint = l.address and l.label_subtype = 'nf_token_contract'
group by collection
order by first_sale
),
sales as (
select
*,
(selling_price-bought_price) as profit
from (
select
l.label as collection,
m.*,
sales_amount as selling_price,
lag(sales_amount, 1) ignore nulls over (partition by mint order by block_timestamp asc) as bought_price
from solana.core.fact_nft_sales m
join solana.core.dim_labels l on m.mint = l.address and l.label_subtype = 'nf_token_contract'
)
),
whales as (
select
purchaser,
Run a query to Download Data