RayyykFlow NFT Floor Price 6
    Updated 2022-10-27
    with nft as (select nft_collection as nft_address,
    case
    when nft_collection = 'A.0b2a3299cc857e29.TopShot' then 'NBA TopShot'
    when nft_collection = 'A.e4cf4bdc1751c65d.AllDay' then 'NFL AllDay'
    when nft_collection = 'A.e4cf4bdc1751c65d.PackNFT' then 'Pack NFT'
    when nft_collection = 'A.329feb3ab062d289.RaceDay_NFT' then 'RaceDay NFT'
    when nft_collection = 'A.329feb3ab062d289.UFC_NFT' then 'UFC NFT'
    end as collections
    from flow.core.ez_nft_sales
    where collections is not null
    group by 1)

    select collections,
    count(distinct(tx_id)) as tx_count
    from flow.core.ez_nft_sales a
    join nft b on a.nft_collection = b.nft_address
    where nft_collection = 'A.0b2a3299cc857e29.TopShot'
    and price = 0.01
    and tx_succeeded = 'TRUE'
    and block_timestamp >= '{{Start_date}}'
    group by 1
    union
    select collections,
    count(distinct(tx_id)) as tx_count
    from flow.core.ez_nft_sales a
    join nft b on a.nft_collection = b.nft_address
    where nft_collection = 'A.e4cf4bdc1751c65d.AllDay'
    and price = 1
    and tx_succeeded = 'TRUE'
    and block_timestamp >= '{{Start_date}}'
    group by 1
    union
    select collections,
    count(distinct(tx_id)) as tx_count
    from flow.core.ez_nft_sales a
    join nft b on a.nft_collection = b.nft_address
    Run a query to Download Data