anyone here work at @dune.eth ?

I am running the following query on Dune for ERC20 prices (prices.hour data) and don't see new prices for the last 12 hours.

select * from prices.hour where blockchain = 'base' and DATE_TRUNC('day', timestamp) = CURRENT_DATE order by timestamp desc

can someone on team check it please? we checked the Dune Status dashboard but there’s no issue of Data Sync on Base Chain

paid customer on premium plan; haven't been able to get ahold of anyone via support

thanks!

chef at moxie.xyz - the ecosystem for creators on Base. Launch & own Creator Coins. 🔜 Creator Agents with skills to help creators earn, trade & grow!

ok so there's an issue with prices.hour and .minute and the team is on flights to our offsite

prices.usd should work