-- date_trunc('hour', CONVERT_TIMEZONE('America/New_York', block_timestamp)) as date,

-- avg(price) as avg_eth,

-- count(*) as num_tx,

-- max(price) as hour_max,

-- min(price) as hour_min

CONVERT_TIMEZONE('America/New_York', block_timestamp) as date,

price,

CASE

WHEN price > 0 AND price < 0.2 THEN 'low'

WHEN price > 0.19 AND price < 0.5 THEN 'low-med'

WHEN price > 0.49 AND price < 0.75 THEN 'med'

WHEN price > 0.74 AND price < 1.5 THEN 'high'

WHEN price > 1.49 THEN 'whale'

END AS bucket

FROM ethereum.nft_events

WHERE contract_address = '0xbd3531da5cf5857e7cfaa92426877b022e612cf8'

AND CONVERT_TIMEZONE('America/New_York', block_timestamp) > GETDATE() - interval '3 days'

ORDER BY 1