684
Our chat: @tondatachat Dune: https://dune.com/ton_foundation
On February 2025 we’ve released the article which helped all of you guys to dive into the TON data on Dune.
🤫 And it is one of the most engaged artices on ton org 🤫
🔗 blog.ton.org/ton-on-chain-data-analysis-dune
Now we are working on the second — more advanced part.
What will be included:
0. How to analyse only real users (not random contracts or custodial wallets of CEXs)
1. How to calculate TVL using balances tables
2. How to calculate USD volumes went through an address
3. … and TG Stars volumes as well! (if they touched TON blockchain of course)
Any ideas what Dune tricks should we cover?
Some ideas for potentially useful Dune dashboads for TON:
— tg stars & tg premium sellers comparison (fragment, split tg, etc)
— trading bots
— defi protocols ranked by APY
Storm Trade Team just sent all the rewards and SBTs are already on the way!
Читать полностью…
We will distribute rewards to the winners' wallets during the next few days
Читать полностью…
🥇 the first place aka the WINNER ☝️
@zerosky with a MASSIVE C-C-COMBO:
+$200 🤜 dune.com/queries/5251814
+$200 🤛 dune.com/queries/5251533
+$200 👊 dune.com/queries/5244388
= $600 from Storm Trade and an exclusive $3000 contract to build the Official Dune Dashboard™ for Storm Trade.
🥉 THIRD PLACE 🥉
was taken by 7 people at the same time
@rAndom1ze
- dune.com/random1zer/storm-daily-traders-by-user-type
@elovianoo
- dune.com/queries/5251491/8628961
@KekiusArmy
- dune.com/queries/5252075/8629872
@elovianoo
- dune.com/queries/5244044/8619973
@smartymetrics
- dune.com/queries/5239892/8612535
@Dan_The_Mage
- dune.com/queries/5249809/8631412
@firstbml2
- dune.com/queries/5222139/8629067
Each of them won $200 from Storm Trade and the huge respect from all our community 🍫
Quick update on the impact of our contests on Dune metrics
(overall for TON Blockchain)
Before we started (March 10):
- Creators: 98
- Dashboards: 49
Now (June 6):
- Creators: 317 (3.2×)
- Dashboards: 220 (4.5×)
📞📞📞
For now, 64 graphs have been submitted for our contest #3 with Storm Trade. Deadline in ~3 days.
If you've already built any Dune graph for Storm Trade, don’t forget to submit them via our submission form!
If you’ve created multiple charts, please submit each one separately — it makes reviewing them much easier for us 💜
👉 https://forms.gle/tnTABcjtbtfVvHtr8
will start in couple minutes
https://meet.google.com/pep-iytj-tjo
🚨 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
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
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
🏦 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
🐦⬛ 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.
🏷️ ton-labels contest update
We’ve added 14 new addresses to the labeling contest using a new filter based on Telegram Stars purchase + sale volume. This will highlight app addresses that either earned a lot of Stars or spent a lot on them.
New addresses to label // Read the rules
If you didn’t receive your reward, please contact Storm team @kandrey_90
Читать полностью…
Calling all onchain analysts!
Tonstakers — the largest liquid staking protocol on TON by TVL — is looking for a talented mind to help team launch their own dashboard on Dune.
We're kicking things off with a grants-based collaboration, but if the stars align, Tonstakers' team is not ruling out a full-time role either.
If you're excited to work with one of the top ecosystem products on TON, drop them a message -> @solivox
And hey, some of you may have already got a message from us directly, so don’t be surprised 👀
📮 This time the Storm team will distribute the $$$, so dear winners, please DM to @kandrey_90.
Don’t forget to copy the link to the announcement from this channel and your TON address.
✌️ SECOND PLACE ✌️
And 2 x $200 = $400 from Storm Trade for the sexiest dashboard of this contest goes to
@Obi1kenobie
— dune.com/astroknight/stormtrade
wow
⏰ DEADLINE in 6 hours ⏰
Don’t forget to submit the link to your Storm Trade graph on Dune!
Rules & Guidelines: /channel/tondatahub/98
Submission form
👉 https://forms.gle/tnTABcjtbtfVvHtr8
The most reliable way to generate a link to a transaction in Dune
As you may notice, if you simply use trace_id or tx_hash fields while generating the links to a tonviewer (block explorer) it will not work because the hash may contain special characters.
And even if you html-encode it this will not work in some cases as well.
So let me show you the most reliable way to generate a clickable link to any transaction.
Simply use this magic ⬇️
Читать полностью…
'https://tonviewer.com/transaction/' || to_hex(from_base64(trace_id))
Workshop with Denis (CEO of Storm Trade)
Also here is the Transcript and Summary (for your AI agents)
In case you didn’t know
You can enable autocomplete in Dune SQL editor. Works with TON tables too!
_enjoy_
By the way, I created the channel with automatic posting of new labels we add to our repo
-> /channel/tonlabels
7.1M Custodial Wallets on TON Blockchain.
Methodology.
@tondatahub
The list of all 88k sybil wallets we found.
@tondatahub