SELECT
date_trunc('hour', block_timestamp) AS time
, price_usd
, MIN(CASE WHEN event_type = 'sale' THEN price_usd END)
OVER (
ORDER BY block_timestamp
RANGE BETWEEN INTERVAL '24 hours' PRECEDING AND CURRENT ROW
) AS min_price_last_24_hours
FROM
base.nft.ez_nft_sales
WHERE
nft_address = lower('0x217Ec1aC929a17481446A76Ff9B95B9a64F298cF')
ORDER BY block_timestamp DESC