date_trunc('HOUR',BLOCK_TIMESTAMP) AS Day,

avg(LATEST_ANSWER_ADJ) AS Price

from ethereum.chainlink.ez_oracle_feeds

where FEED_CATEGORY='Cryptocurrency (USD pairs)' and BLOCK_TIMESTAMP::date >= dateadd('month',-6,CURRENT_DATE)

and LATEST_ANSWER_ADJ is not null