-- forked from mar1na-catscatscode / fancy-emerald @ https://flipsidecrypto.xyz/mar1na-catscatscode/q/YRv8AinM2KXg/fancy-emerald
select
hour as hour,
open,
high,
low,
close
from near.price.fact_prices_ohlc_hourly
where asset_id = 'near'
and hour >= current_date - 7