We're thrilled to announce two new tables on Dune to simplify TON blockchain analytics! 🎉

ton.balances_history: Tracks all balance changes for native TON and Jettons, perfect for diving into historical trends. 📊

ton.latest_balances: Snapshots current balances at the end of the previous day in UTC, ideal for real-time portfolio or DeFi insights. 💸

These tables make reconstructing balances from ton.jetton_events a thing of the past, powering up your analysis of wallet holdings, token flows, or TVL 🌟

Usage examples:

The TON Top Holders Dashboard uses ton.latest_balances to spotlight top holders for any Jetton (for example USDT) adding more context using our labels. 🕵️‍♂️

The TON Balance History Dashboard uses ton.balances_history to track daily balance trends, like USDT in the EVAA main pool. 📈

Start exploring with simple SQL queries and unlock insights into TON’s booming ecosystem! 🚀 Got questions or ideas? Feel free to ask in the comments! 🤑