CarlOwOstop crossover projects
Updated 2022-06-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
-- top collections by assets held, holders holding
-- crossover from whales or small players
-- nba nfts held vs nfts held of other collections
WITH nba_holders AS (
SELECT DISTINCT buyer as nba_holder
FROM flow.core.fact_nft_sales s1
WHERE nft_collection = 'A.0b2a3299cc857e29.TopShot'
AND block_timestamp IN (SELECT MAX(s2.block_timestamp)
FROM flow.core.fact_nft_sales s2
WHERE s1.nft_id = s2.nft_id
GROUP BY s2.nft_id)
)
SELECT COUNT(DISTINCT tx_id) AS sales
, nft_collection
FROM flow.core.fact_nft_sales
WHERE buyer IN (SELECT * FROM nba_holders)
AND nft_collection != 'A.0b2a3299cc857e29.TopShot'
GROUP BY nft_collection
ORDER BY sales desc
limit 5
Run a query to Download Data