tondatahub | Unsorted

Telegram-канал tondatahub - 📀 TON Data Hub

684

Our chat: @tondatachat Dune: https://dune.com/ton_foundation

Subscribe to a channel

📀 TON Data Hub

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?

Читать полностью…

📀 TON Data Hub

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

Читать полностью…

📀 TON Data Hub

Storm Trade Team just sent all the rewards and SBTs are already on the way!

Читать полностью…

📀 TON Data Hub

We will distribute rewards to the winners' wallets during the next few days

Читать полностью…

📀 TON Data Hub

🥇 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.

Читать полностью…

📀 TON Data Hub

🥉 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 🍫

Читать полностью…

📀 TON Data Hub

276 submissions …

Have a productive Monday, guys

Читать полностью…

📀 TON Data Hub

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.

Читать полностью…

📀 TON Data Hub

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

Читать полностью…

📀 TON Data Hub

will start in couple minutes

https://meet.google.com/pep-iytj-tjo

Читать полностью…

📀 TON Data Hub

🚨 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

Читать полностью…

📀 TON Data Hub

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

Читать полностью…

📀 TON Data Hub

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

Читать полностью…

📀 TON Data Hub

🏦 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

Читать полностью…

📀 TON Data Hub

🐦‍⬛ 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 Data Hub

🏷️ 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

Читать полностью…

📀 TON Data Hub

If you didn’t receive your reward, please contact Storm team @kandrey_90

Читать полностью…

📀 TON Data Hub

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 👀

Читать полностью…

📀 TON Data Hub

📮 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.

Читать полностью…

📀 TON Data Hub

✌️ 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

Читать полностью…

📀 TON Data Hub

charts made by our community

/channel/durov/429

Читать полностью…

📀 TON Data Hub

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

Читать полностью…

📀 TON Data Hub

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))

Читать полностью…

📀 TON Data Hub

Workshop with Denis (CEO of Storm Trade)

Also here is the Transcript and Summary (for your AI agents)

Читать полностью…

📀 TON Data Hub

Workshop in 1 hour. I’ll send the link later

Читать полностью…

📀 TON Data Hub

In case you didn’t know

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

_enjoy_

Читать полностью…

📀 TON Data Hub

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

-> /channel/tonlabels

Читать полностью…

📀 TON Data Hub

7.1M Custodial Wallets on TON Blockchain.

Methodology.
@tondatahub

Читать полностью…

📀 TON Data Hub

The list of all 88k sybil wallets we found.

@tondatahub

Читать полностью…

📀 TON Data Hub

2025-06-02

Читать полностью…
Subscribe to a channel