MLDZMNBase- floor price
    Updated 2025-01-01

    -- Top projects across chains by floor price

    select
    PROJECT_NAME as Collection,
    round(min(price_usd), 2) as "Floor price USD"
    from
    base.nft.ez_nft_sales
    where
    PROJECT_NAME is not null
    and Block_timestamp >= '{{Start_date}}'
    and Block_timestamp <= '{{End_date}}'
    group by
    Collection
    order by
    "Floor price USD" desc
    limit
    10







    QueryRunArchived: QueryRun has been archived