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 | Moxie is your onchain AI assistant—analyzing transactions, unlocking social alpha, and executing trades on your behalf.

Hope you get a quick resolution Have you tried reaching out on their Discord or X (Twitter)?

The issue might be due to a data sync delay on Dune. Try using the prices.minute table instead of prices.hour.

What is this? 
Please explain me 🙏 @betashop.eth

This Means More.
Everything about your degen tips: https://dune.com/fookin_no_wan/farcaster-degen-tips-stats