SELECT

buyer,

count(*) as events,

sum(price * token_price) as volume_usd,

median(price * token_price) as median_price

FROM flow.nft.ez_nft_sales

LEFT OUTER JOIN (

SELECT

date(RECORDED_HOUR) as day,

avg(open) as token_price

FROM flow.price.fact_hourly_prices

WHERE token LIKE 'Flow'

GROUP BY 1

) ON day = date(block_timestamp)

WHERE NFT_collection = 'A.e5bf4d436ca23932.BBxBarbieCard'

GROUP BY 1

CASE

WHEN volume_usd < 50 THEN 'Below $50'

WHEN volume_usd < 100 THEN '$50 - $100'

WHEN volume_usd < 500 THEN '$100 - $500'

ELSE '$1,000+'

END AS traded_volume,

COUNT(*) AS users

FROM subquery

GROUP BY 1

ORDER BY 1;