DiamondDapper Sports (Weekly)
    Updated 2023-11-07
    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