815
Our chat: @tondatachat Dune: https://dune.com/ton_foundation
TON is the most transparent chain.
Why?
Because we already have more than 2000 labels in our open-source ton-labels collection. And 8M custodial wallets for CEX, apps and even some trading bots.
These tables are available on Dune:
dune.ton_foundation.dataset_labels
dune.ton_foundation.result_custodial_wallets
🎉 Great news for anyone looking to work directly with the TON Data Lake! TON data has now been added to the AWS Public Blockchain Data registry. All tables are available daily at s3://aws-public-blockchain/v1.1/ton/. This data is stored in Parquet file format for enhanced flexibility and bandwidth efficiency.
Our data is optimized for AWS analytical tools, ensuring seamless integration with Amazon Athena, SageMaker, QuickSight, and EMR. We've also set up an AI agent for AWS Bedrock, allowing users to obtain data-driven insights without writing SQL code. Examples are available in the article in the AWS re:Post blog.
🔬 TON data on Dune Advanced Guide
Shared some advanced sql magic for fellow analysts.
🔹 How to analyze authentic users (excluding contracts and custodial wallets)
🔹 How to calculate TVL using balance tables
🔹 How to calculate USD volumes flowing through addresses
🔹 How to track Telegram Stars volumes on TON Blockchain
🔹 How to analyze both on-chain and estimated off-chain NFT trading volumes
Read the article:
🔗 blog.ton.org/how-to-analyze-ton-users-and-token-flows-on-dune
If you are new to TON data or Dune, read the first part: blog.ton.org/ton-on-chain-data-analysis-dune
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
🕵🏻 REQUEST FOR LABELS
We’ve added a next batch of the most popular & unlabelled addresses on TON.
Go find their owners and add the labels to our repo.
Note: not all labels are eligible for the 7 or 4 TON reward. Read the rules first.
TL;DR: We reward only for labels related to apps on TON. We don’t want to dox anyone here 🌚
🔗 dune.com/ton_foundation/labelling
Added more addresses for our labelling contest.
https://dune.com/ton_foundation/labelling
Some unique stats on Telegram Gifts
/channel/GiftStickers/106
🏷️ 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