⚡4
Deadline in 1 hour. Make sure we can open your link (test in incognito)
The contest is now officially over, meaning we are no longer accepting dashboard updates or awarding bounties for new labels.
▪ 41 dashboards were submitted for Dedust, and the team is currently reviewing them. Results will be announced on March 27.
▪ 10 detectives labeled 63 addresses, covering 82% of our shortlist.
What's Next?
▪ We’re gearing up for the next round of the contest next week — stay tuned!
@tondatahub
Please open Telegram to view this post
VIEW IN TELEGRAM
🔥15
💡 Did you know that you can send HTTP requests from your Dune query?
This magic is called “LiveFetch functions”. It supports
Dune docs:
🔗 docs.dune.com/query-engine/Functions-and-operators/live-fetch
Dashboard that queries Coinmarketcap data:
🔗 dune.com/ton_foundation/ton-game-index-total-mcap-of-tokens
This magic is called “LiveFetch functions”. It supports
http_get and http_post, has a 5 sec timeout and 50 requests/second throttling. Dune docs:
🔗 docs.dune.com/query-engine/Functions-and-operators/live-fetch
Dashboard that queries Coinmarketcap data:
🔗 dune.com/ton_foundation/ton-game-index-total-mcap-of-tokens
Dune Docs
LiveFetch functions - Dune Docs
LiveFetch functions send HTTP requests to a specified URL.
👨💻4
If your bot uses Telegram Stars for payments, you’ll withdraw your earnings via Fragment. These transactions happen on-chain and can be tracked!
As you already know, we identify and label addresses associated with projects on TON, including GameFi. For some of them, we can estimate their Telegram Stars revenue, as well as the TON and Jettons they’ve received.
🔗 dune.com/ton_foundation/ton-games-revenue
Please open Telegram to view this post
VIEW IN TELEGRAM
🔥12
New to TON? Want to understand how TON transactions work?
One of our community members has written an article explaining TON transactions in simple terms. This foundational knowledge will help you dive deeper into on-chain data analysis on TON Blockchain.
Check it out here:
🔗 elovianoo.substack.com/p/how-to-analyse-ton-data
Feel free to ask the questions here in the comments
One of our community members has written an article explaining TON transactions in simple terms. This foundational knowledge will help you dive deeper into on-chain data analysis on TON Blockchain.
Check it out here:
🔗 elovianoo.substack.com/p/how-to-analyse-ton-data
Feel free to ask the questions here in the comments
Substack
How to Analyse Ton Data.
...post-ton bounty lessons
🔥9🐳3🌚1
With Dune, you can calculate anything …… yourself.
For most use cases, you can simply use other analytics platforms to get the stats you need.
Here’s a list of other analytical tools that shed light on what’s happening on the TON Blockchain:
🔗 https://news.1rj.ru/str/thedailyton/869
For most use cases, you can simply use other analytics platforms to get the stats you need.
Here’s a list of other analytical tools that shed light on what’s happening on the TON Blockchain:
🔗 https://news.1rj.ru/str/thedailyton/869
Telegram
The Daily TON | News
📒 Analytics platforms for every occasion. #howtoton series
To celebrate the launch of TON Data HUB, we’ve put together a list of services that come in handy when working with data on TON Blockchain.
⚫️ giftstat.com — Let’s start with the most relevant:…
To celebrate the launch of TON Data HUB, we’ve put together a list of services that come in handy when working with data on TON Blockchain.
⚫️ giftstat.com — Let’s start with the most relevant:…
🔥7
TON DATA HUB CONTEST #1: RESULTS
Some outcomes:
🍞 +83 labels
—— labelled 5% of activity on TON
🍞 +41 DeDust dashboards (insane!)
—— +25% TON-related activity on Dune
We already know the winners. 20 reactions and I’ll share the results.
Some outcomes:
🍞 +83 labels
—— labelled 5% of activity on TON
🍞 +41 DeDust dashboards (insane!)
—— +25% TON-related activity on Dune
We already know the winners. 20 reactions and I’ll share the results.
🔥28🤯7🐳6🌚2💯1
BRONZE MEDAL
AND 1000 USD₮ ON TON
🥉 🥉 🥉 🥉 🥉 🥉 🥉 🥉
➡️ dune.com/msu/dedust ⬅️
🥉 🥉 🥉 🥉 🥉 🥉 🥉 🥉
(don’t forget to smash a star on dune)
AND 1000 USD₮ ON TON
🥉 🥉 🥉 🥉 🥉 🥉 🥉 🥉
➡️ dune.com/msu/dedust ⬅️
🥉 🥉 🥉 🥉 🥉 🥉 🥉 🥉
(don’t forget to smash a star on dune)
🔥21👨💻4🤯1
SILVER MEDAL
AND 2000 USD₮ ON TON
💍🪙📎🩶🖇️📏📐🛸🥄🍴
🥈 dune.com/vaitar/dedust 🥈
📐🛸🥄🍴💍🖇️📏🪙📎🩶
(star it on dune please)
AND 2000 USD₮ ON TON
💍🪙📎🩶🖇️📏📐🛸🥄🍴
🥈 dune.com/vaitar/dedust 🥈
📐🛸🥄🍴💍🖇️📏🪙📎🩶
(star it on dune please)
🔥18💯6🤯4🍾3
AND THE ABSOLUTE WINNER
THE GOLD MEDAL HOLDER
THE 3000 USD₮ OWNER
🏅🏅🏅🏅🏅🏅🏅🏅🏅🏅🏅
👑 dune.com/tubaecci/dedust 👑
🏅🏅🏅🏅🏅🏅🏅🏅🏅🏅🏅
👑👑👑 @tubaecci 👑👑👑
THE GOLD MEDAL HOLDER
THE 3000 USD₮ OWNER
👑
🏅🏅🏅🏅🏅🏅🏅🏅🏅🏅🏅
👑👑👑
🔥25🤯6🍾6🐳2
Please make your queries and dashboards public,
and stay tuned for the upcoming contest next week!
And I’ll contact the winners today to verify your TON address
and stay tuned for the upcoming contest next week!
And I’ll contact the winners today to verify your TON address
DeDust team shared some insights on how to make great and usable dashboard. Will share them later this week. Use them to win next time.
Next challenge will be much harder.
Meanwhile, feel free to share the links to your dashboards in our @tondatachat.💎
Next challenge will be much harder.
Meanwhile, feel free to share the links to your dashboards in our @tondatachat.
Please open Telegram to view this post
VIEW IN TELEGRAM
🔥6
Ton Blockchain on Dune stats: before and after our contest.
March 10th
Creator Count: 98
Query Count: 345
Dashboard Count: 49
Total Favorites: 822
March 27th
Creator Count: 209
Query Count: 1,801
Dashboard Count: 149
Total Favorites: 1,219
🔥 🔥 🔥 @tondatahub
March 10th
Creator Count: 98
Query Count: 345
Dashboard Count: 49
Total Favorites: 822
March 27th
Creator Count: 209
Query Count: 1,801
Dashboard Count: 149
Total Favorites: 1,219
Please open Telegram to view this post
VIEW IN TELEGRAM
🔥13🤯4
How to Create a Great Dashboard – DeDust Interview
I asked the DeDust team to share the most common mistakes they saw in Dune Dashboards submissions. Avoid these, and you’ll increase your chances next time.
❌ Common Mistakes:
▪ Not following the full requirements – if something is requested in the brief, it must be on your dashboard.
▪ Unnecessary tables/graphs or duplicating the same data in different formats (e.g., a bar chart and the same data in a table).
▪ Two smaller dashboards are worse than one well-structured one – all key information should be in one place.
▪ Fewer tables, more charts – graphs make data easier to interpret.
▪ Inconsistent group colors across graphs – the same DEX should have the same color in all visualizations.
▪ Inconsistent layout in similar sections (e.g., Daily Report vs. Monthly Report) – these should be visually identical, differing only in the time period.
Creating a dashboard is a creative process.
Asking for feedback from friends is a great way to refine its clarity.
Next week we’ll run the next contest with one of TON DeFi projects. Any guesses which one?😳
I asked the DeDust team to share the most common mistakes they saw in Dune Dashboards submissions. Avoid these, and you’ll increase your chances next time.
TL;DR:
The goal of any analytics is clarity and ease of perception.
A great dashboard should be compact, simple, and not misleading.
❌ Common Mistakes:
▪ Not following the full requirements – if something is requested in the brief, it must be on your dashboard.
▪ Unnecessary tables/graphs or duplicating the same data in different formats (e.g., a bar chart and the same data in a table).
▪ Two smaller dashboards are worse than one well-structured one – all key information should be in one place.
▪ Fewer tables, more charts – graphs make data easier to interpret.
▪ Inconsistent group colors across graphs – the same DEX should have the same color in all visualizations.
▪ Inconsistent layout in similar sections (e.g., Daily Report vs. Monthly Report) – these should be visually identical, differing only in the time period.
Creating a dashboard is a creative process.
Asking for feedback from friends is a great way to refine its clarity.
Next week we’ll run the next contest with one of TON DeFi projects. Any guesses which one?
Please open Telegram to view this post
VIEW IN TELEGRAM
🔥13🍾1
USDT transafers $10+ 20M 2025-03-28.csv.zip
843.8 MB
Each month I have extra Dune credits. I decided to spend them to export some interesting data for you.
This time I exported all USDT transfers >$10
— 20M rows, 3.4Gb. #dataset
This is the query I used to download the data:
🔗 dune.com/queries/4916266
Let’s see what you can do with it! Share the your findings in the chat! @tondatachat
This time I exported all USDT transfers >$10
— 20M rows, 3.4Gb. #dataset
This is the query I used to download the data:
🔗 dune.com/queries/4916266
Let’s see what you can do with it! Share the your findings in the chat! @tondatachat
🤯5
Media is too big
VIEW IN TELEGRAM
For example, you can use cosmograph.app/run to visualize this graph!
My macbook is old enough, so I filtered the data to keep only transfers >$10k (500k rows).
Will share the filtered data in a chat. You can unzip it and have your own graph with a simple drag-n-drop. Try it yourself!
☕️ 🏃♂️
My macbook is old enough, so I filtered the data to keep only transfers >$10k (500k rows).
Will share the filtered data in a chat. You can unzip it and have your own graph with a simple drag-n-drop. Try it yourself!
Please open Telegram to view this post
VIEW IN TELEGRAM
🐳4🤯3
Forwarded from DeDust.io – TON DEX
This media is not supported in your browser
VIEW IN TELEGRAM
Our joint competition with TON Foundation has concluded, and we're thrilled to announce the best works:
🏆 1st Place – dune.com/tubaecci/dedust
🥈 2nd Place – dune.com/vaitar/dedust
🥉 3rd Place – dune.com/msu/dedust
Selecting the winners was a challenge due to the high quality of many submissions. After careful consideration, we've decided to award additional prizes of $100 in $DUST tokens each to 7 more participants, bringing the total number of prize winners to 10.
We were pleasantly surprised to receive 41 submissions, which exceeded our expectations. We are very grateful to everyone who participated and wish you the best of luck in future contests hosted by TON Data Hub. Your contributions are helping to enhance DeFi on The Open Network.
Sincerely,
DeDust Team
Please open Telegram to view this post
VIEW IN TELEGRAM
🔥11
I just got a message from Ton Society that our SBTs were issued and were sent to the participants who submitted a valid DeDust dashboard or a label.
😎 Welcome to the club
🔗 society.ton.org/ton-data-hackathon
🔗 society.ton.org/ton-data-hackathon
Please open Telegram to view this post
VIEW IN TELEGRAM
TON
Your Digital Passport in TON Ecosystem
Build your reputation with every app you use and every contribution you make.
💯4
Build a Dune Dashboard for EVAA Protocol
—————————————> win up to $3000
Ton Data Hub invites you to our second data contest!
This time, explore the world of lending protocols
by building a Dune dashboard for EVAA
and win:
📅 Deadline: Apr 13, 11:59 PM UTC
📐 READ THE RULES 📏
Got questions? Ask in our chat: @tondatachat
—————————————> win up to $3000
Ton Data Hub invites you to our second data contest!
This time, explore the world of lending protocols
by building a Dune dashboard for EVAA
and win:
🥇 1st place: $3000
🥈 2nd place: $2000
🥉 3rd place: $1000📅 Deadline: Apr 13, 11:59 PM UTC
📐 READ THE RULES 📏
Got questions? Ask in our chat: @tondatachat
🔥20🐳10🤣1
📎 TODAY 2PM UTC
📎 WORKSHOP from @sepezho
📎 CTO of EVAA Protocol
Highly recommended to anyone new to DeFi and Decentralized Lending Protocols.
(this is not a joke)
📎 WORKSHOP from @sepezho
📎 CTO of EVAA Protocol
Highly recommended to anyone new to DeFi and Decentralized Lending Protocols.
(this is not a joke)
🔥12🤔2