-- forked from Diamond / $LOPPY Hourly Price Chart @ https://flipsidecrypto.xyz/Diamond/q/sloppy-hourly-price-feed-B4Xb-8
-- forked from jfo
select
trunc(recorded_hour, 'hour') as "Date",
avg(close) as "duck Price"
from
flow.core.fact_hourly_prices
where
id ilike '%duckcoin%'
-- and WEEK("Date") = WEEK(GETDATE ())
group by
1
order by
1 desc