SET_NAME | SET_SERIES_NUMBER | PLAYER | NFT_COUNT | |
|---|---|---|---|---|
1 | The Anthology: Magic Johnson | 5 | Magic Johnson | 236 |
2 | The Tour | 5 | Channing Frye | 62 |
3 | Metallic Gold LE | 4 | Devin Booker | 145 |
4 | The Champion's Path | 5 | Anthony Davis | 143 |
5 | Rising Stars | 4 | Tyrese Haliburton | 4 |
6 | Run It Back | 1 | Kelly Olynyk | 34 |
7 | Base Set | 1 | Kyrie Irving | 218 |
8 | Base Set | 1 | Rudy Gobert | 116 |
9 | For the Win | 5 | John Collins | 251 |
10 | Run It Back 2005-06 | 3 | Chris Paul | 122 |
11 | Metallic Silver FE | 4 | Ja Morant | 32 |
12 | Metallic Gold LE | 2 | Tim Hardaway Jr. | 43 |
13 | Metallic Gold LE | 1 | Dillon Brooks | 41 |
14 | Metallic Gold LE | 1 | Ivica Zubac | 50 |
15 | WNBA: Best of 2021 | 3 | Sabrina Ionescu | 4 |
16 | Deck the Hoops | 4 | Kawhi Leonard | 11 |
17 | Run It Back | 1 | Manu Ginobili | 37 |
18 | Run It Back | 1 | Mo Williams | 36 |
19 | Base Set | 5 | Steven Adams | 4 |
20 | Metallic Gold LE | 2 | John Collins | 14 |
aisportsSeries count
Updated 2024-02-20
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
›
⌄
flow.core.dim_contract_labelsWITH sales_data AS (
SELECT
NFT_ID,
PRICE,
CURRENCY,
BLOCK_TIMESTAMP
FROM
flow.nft.ez_nft_sales
WHERE
NFT_COLLECTION = 'A.0b2a3299cc857e29.TopShot'
AND PRICE > 20
AND EXTRACT (YEAR FROM BLOCK_TIMESTAMP) IN (2023, 2024)
ORDER BY
BLOCK_TIMESTAMP DESC
)
SELECT
dm.set_name,
dm.set_series_number,
dm.player,
--dm.SERIAL_NUMBER,
COUNT(dm.NFT_ID) AS NFT_Count -- Counting the NFTs for each combination of set_name and set_series_number
FROM
flow.nft.dim_topshot_metadata dm
JOIN
sales_data sd ON dm.NFT_ID = sd.NFT_ID
GROUP BY
dm.set_name, -- Grouping by set_name
dm.set_series_number, -- and set_series_number
--dm.SERIAL_NUMBER,
dm.player --this is more specific, may only want set & Series
Last run: about 1 year ago
...
3397
129KB
6s