DiamondDapper Sports (Weekly)
Updated 2023-11-07
999
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
›
⌄
WITH
sales AS (
SELECT
block_timestamp,
block_height,
n.nft_id,
n.nft_collection,
case
when nft_collection = 'A.0b2a3299cc857e29.TopShot' then 'NBA Top Shot'
when nft_collection = 'A.329feb3ab062d289.UFC_NFT' then 'UFC Strike'
when nft_collection = 'A.e4cf4bdc1751c65d.AllDay' then 'NFL All Day'
when nft_collection = 'A.87ca73a41bb50ad5.Golazos' then 'LaLiga Golazos'
when nft_collection = 'A.27ece19eff91bab0.NBATopShotArena' then 'NBA Top Shot Arena'
when nft_collection = 'A.329feb3ab062d289.NFL_NFT' then 'NFL All Day Team NFTs'
when nft_collection = 'A.e4cf4bdc1751c65d.PackNFT' then 'NFL All Day Packs'
when nft_collection = 'A.87ca73a41bb50ad5.PackNFT' then 'LaLiga Golazos Packs'
when nft_collection = 'A.0b2a3299cc857e29.PackNFT' then 'NBA Top Shot Packs'
end as collection,
n.price,
n.seller,
n.buyer,
marketplace,
n.tx_id,
currency
FROM
flow.core.ez_nft_sales n
WHERE
nft_collection in (
'A.0b2a3299cc857e29.TopShot',
'A.0b2a3299cc857e29.PackNFT',
'A.27ece19eff91bab0.NBATopShotArena',
'A.329feb3ab062d289.UFC_NFT',
'A.e4cf4bdc1751c65d.AllDay',
'A.87ca73a41bb50ad5.Golazos',
'A.329feb3ab062d289.NFL_NFT',
'A.e4cf4bdc1751c65d.PackNFT',
Run a query to Download Data