CryptoIcicleFlow-9.Crossover with NBA Top Shot - Cross Over Whales ?
Updated 2022-06-12
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
›
⌄
-- Crossover with NBA Top Shot
-- Payout 29.88 FLOW
-- Grand Prize 89.64 FLOW
-- Level Intermediate
-- Q9. Which Flow NFT projects appear to have the most crossover of buyers with NBA Top Shot addresses?
-- Is NBA Top Shot an effective onboarding tool in getting users interested into other Flow collections?
-- Does this crossover tend to come from Top Shot "whales", or does the crossover come from average to smaller players?
-- How can Flow projects better attract liquidity from Top Shot players?
with topshot as (
select
distinct buyer as buyer,
count(distinct nft_id) as n_nfts,
iff(n_nfts > 1000,'whale', 'average') as type
from flow.core.fact_nft_sales
where block_timestamp >= '2022-05-09'
and split(nft_collection,'.')[2] = 'TopShot'
group by buyer
order by n_nfts desc
)
select
split(nft_collection,'.')[2] as name,
type,
count(distinct s.buyer) as n_wallets
from flow.core.fact_nft_sales s join topshot t on s.buyer = t.buyer
where block_timestamp >= '2022-05-09' and name <> 'TopShot'
group by name, type
order by n_wallets desc
Run a query to Download Data