flipside

    Floor stuff
    nsa2000Floor stuff
    Updated 2022-10-27
    select contract_name, count(tx_id) as "Sales Count", avg(price) as "Average Price", median(Price) as " Median Price"
    from flow.core.dim_contract_labels
    inner join flow.core.ez_nft_sales
    on event_contract=nft_collection
    where contract_name like '%TopShot%'
    or contract_name like '%AllDay%'
    or contract_name like '%UFC_NFT%'
    or contract_name like '%CricketMoments%'
    or contract_name like '%OlympicPin%'
    group by 1
    Run a query to Download Data