📀 TON Data Hub

📀 TON Data Hub pinned «Build a graph on Dune for Storm Trade ➡➡➡➡➡➡➡ win up to $200 per chart TON Data Hub invites you to our third data contest. This time, dive into the world of perpetual DEXs and create a graph using Storm Trade data on Dune. 📅 Deadline: June, 9 00:00 UTC…»

🚨 WORKSHOP ALERT 🚨

Join Denis, CEO of Storm Trade, as he dives into the technical details behind how Storm Trade works — essential knowledge for building charts on Dune.

📅 Tomorrow at 11 AM UTC || 2PM Moscow time

In case you didn’t know

You can enable autocomplete in Dune SQL editor. Works with TON tables too!

_enjoy_

Build a graph on Dune for Storm Trade
➡➡➡➡➡➡➡ win up to $200 per chart

TON Data Hub invites you to our third data contest.

This time, dive into the world of perpetual DEXs and create a graph using Storm Trade data on Dune.

📅 Deadline: June, 9 00:00 UTC (1 week left!)

Read more:
👉 [ Rules & Guidelines ] 👈

Got questions? Ask in out chat: @tondatachat

By the way, I created the channel with automatic posting of new labels we add to our repo

-> https://t.me/tonlabels

Real Users on TON

As you may know, the TON blockchain has hundreds of millions of addresses — but not all of them represent real user wallets. Even accounts with the wallet_* interface aren't always tied to real users; many are controlled by code, such as Sybil networks or custodial wallets for deposits on CEX.

If you want to focus your charts on real users, check out this query using our materialized views for Sybil and custodial wallet filtering:

🔗 dune.com/queries/5206674

7.1M Custodial Wallets on TON Blockchain.

Methodology.
@tondatahub

🏦 CUSTODIAL WALLETS 🏦

More and more exchanges are switching to custodial wallets for processing deposits, instead of using memos. All the custodial wallets we’ve identified follow the same pattern: they forward deposited funds to other addresses owned by the same organization (usually a CEX or payment processor).

Since introducing a special tag in ton-labels, we've identified 6.7 million custodial wallets!

You can explore the full list on Dune:
📕 dune.ton_foundation.result_custodial_wallets

And here’s the SQL we used to generate it:
🔗 dune.com/queries/5032986

The list of all 88k sybil wallets we found.

@tondatahub

🐦‍⬛ SYBIL WALLETS 🐦‍⬛

A couple of months ago, we started labeling Sybil wallets in ton-labels. By taking the labeled Sybils and identifying wallets that received their first transaction from them—then repeating the process—we were able to generate a full list of 88,000 Sybil wallets.

We’re now releasing this materialized view for the community:
📕 dune.ton_foundation.result_sybil_wallets

Check out the SQL we used to generate it:
🔗 dune.com/queries/5206440

This approach may not be perfect, so please don’t hesitate to let us know if we accidentally included any legitimate addresses.

$DOGS just got a new flashy dune dashboard! 😎

All the data in a single place 🫨

💻 New table on Dune!

We asked for your help with naming the table, you delivered, and now it’s live! 🙌 A massive thank you to the incredible TON community for your support! The new dns_ton.address_book table on Dune Analytics provides a 1:1 mapping between TON blockchain addresses and TON.DNS domains. This feature replaces complex hex addresses with user-friendly names, making transactions and interactions on the TON network smoother and more engaging! 😎

For a deeper dive, explore the dns_ton.domain_latest_info table, which includes details like the original minter, current owner, and domain delegation information.

See it in action on the Dune dashboard for top ANON token holders 🎱.

Use the dns_ton.address_book table whenever you want to transform raw address lists into a more human-readable format.

Need your help

We’ve decoded TON DNS, TG usernames, and other data to use them as additional address labels in our queries.

Since a single address can have multiple DNS entries assigned to it, we want to create a table with a 1:1 mapping from address to domain.

Any suggestions for the table name? Our goal is to make it as clear as possible.

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! 🤑

🚀 Labeling Contest Update! 🏷️

Keep tagging the addresses! The more you label, the higher your chances to shine in our contest. 🌟

📢 Big News: We’re distributing SBTs next week to reward your efforts! Everyone who submitted a PR after April 14th that was merged is eligible for SBT rewards. So far, we have 108 PRs qualifying for SBTs—let’s make that number grow!

💰 Extra Incentive: Active labels in specific categories are also eligible for TON rewards! Check the rules for more details.

Join the fun and let’s build something amazing together! 💪

FYI

How we generate ton.prices_daily table from RAW data

🔗 https://github.com/duneanalytics/spellbook/blob/d13067c92a0364b18ad574596332d89543039ca6/dbt_subprojects/daily_spellbook/models/ton/ton_jetton_price_daily.sql

TON & Flipside

Couple facts for you:
🔺 Flipside pays hourly if your dashboard is in top 50.
🔺 TON data was added to Flipside only recently
🔺 TON 3x reward boost until 04/26 01:00PM

Dune Trending -> Flipside dashboard arbitrage should be quite profitable.

Read more:
🔗 flipsidecrypto.xyz/rewards/Top-Dashboards-April-2025

Hi guys,
Happy Easter.

We promised to launch the next Ton Data contest today but unfortunately we need more time to validate the data and make everything available on Dune.

The data is far far more complicated than simple dex trades………

🚀 Tact Smart Battle has officially started! 🤜

All tasks are now live.
The GitHub repo with setup, templates, and participation guide is here:

🐱 tact-smart-battle

Dive in, build, and push your skills to the limit