h4wkbuying price type
    Updated 2023-03-30
    -- forked from 0fd27af6-f090-4dd1-a34d-2c3a80d9f973

    -- forked from 5d9ab8ba-f50e-4c59-8883-88f8c547e4d2

    with base as (
    select *
    from flow.core.ez_nft_sales
    where nft_collection ilike '%dimension%' and tx_succeeded = TRUE
    )

    select
    case when price < 10 then 'Price < $10'
    when price < 100 then 'Price < $100'
    when price < 1000 then 'Price < $1000'
    else 'Price > $1000' end as type,
    count(distinct tx_id) as sales_count

    from base group by 1



    Run a query to Download Data