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

A small hint for friends participating in our labeling contest:

I’ve been analyzing the first_tx_senders of new TON wallets and, unsurprisingly, saw a bunch of CEXs there.

Then I checked some unlabelled addresses and found them on our labeling dashboard! So, they probably belong to some CEXs or wallets.

0:2ED2A8DF730B37139491B65FFA978D355284A9BE185AC9C622BCE4DD61F78299
0:5EB976E79F0515B66E20404144A9A333681635B21C73F7FA23CD16CD11A72D51
0:2F01AC8D0B27152D76AD54EA0103C29CED484FA88794499A5DA0BACEB83296DC
0:D241CCE22FA91BC9A1BACEE22D36EFD0D8258597205D1849500AB7EE61B003C5

👋 Sup guys,

I received a lot of positive feedback from you about our previous contests—maybe we can take things even further!

If you’ve ever participated in other data contests related to blockchain stuff, feel free to share what you liked the most and why.
Maybe we can bring similar ideas to TON!

🏷️ Following our tradition, we sent SBTs for all participants!

These SBTs are Compressed SBTs. That means you can see find them on Tonkeeper, Wallet and Getgems.

If you want to convert it to a real NFT (e.g. to make it visible on Tonviewer) you need to use “Claim NFT” button on Getgems.

Thank you guys for participating in our second @tondatahub contest. Dear winners, please dm me to confirm your ton wallet for the reward. @okhlopkov

We always want to make our events better. Any feedback? Please share in the comments!

And don’t forget that we also have the active TON address labeling challenge!

The analysis of a dex feels simpler than a lending protocol, right?
Well, let’s see how you crack the next contest which starts next Monday!
Any guesses who might it be?

AND THE NUMBER ONE
THE WINNER
TON DEFI RESEARCHER
EVAA ANALYZER
BIG BRAIN OWNER
$3000 USDT SPENDER

@rdmcd

🔗 dune.com/rdmcd/evaa

Silver medal and $2000 goes to

🥈🥈🥈🥈��

🔗 dune.com/elovianoo/evaa-protocol

🥈🥈🥈🥈🥈

🥉🥉🥉🥉��

🔗 dune.com/xyzcats/evaaprotocol

🥉🥉🥉🥉🥉

I have the winners list.

30 reactions and I’ll announce them

Sorry guys, we will announce winners tomorrow…

While we wait, our friends from Wallet shared a job — they are looking for a senior analyst like you

https://jobs.ton.org/companies/wallet-2/jobs/47998743-senior-data-analyst

The EVAA Contest has ended, and the team has already started reviewing the 46 dashboards you submitted.

The winners will be announced tomorrow!

Deadline in ~13 hours!

Submit your dashboard to get SBT and a chance to win up to $3k!

Rules: https://docs.google.com/document/d/1endw_vIB0qQtLe5qXZPdQI4cCQ0F1afItFR-ACQGi4I/edit?tab=t.0

Submission link: https://forms.gle/UywjBGTjkBx2gFMc7

Lil guide on
WHERE TO FIND EVAA TABLES ON DUNE

1️⃣ “Create” query
2️⃣ Search for EVAA
3️⃣ Click the small arrows to paste the table name into the query builder

😎

To clear things up, we spoke with the EVAA Protocol team and clarified some of the requirements for the Winner Dashboard.

We also rephrased a few metric definitions based on questions from the chat — just to make everything easier to understand.
Sorry for the late update, we know it’s close to the deadline.

Changelog is on the first screenshot. The team also shared some js snippets that might be helpful.

Full rules here:
https://docs.google.com/document/d/1endw_vIB0qQtLe5qXZPdQI4cCQ0F1afItFR-ACQGi4I/edit?tab=t.0

How's your EVAA dashboard coming along?

The deadline is in less than a week — there's still plenty of time to join the contest!
So far, we've received only 4 submissions.

If you're looking for the asset config values, the EVAA team shared these constants in our chat:
https://t.me/tondatachat/1992

😳Exclusive Dune Analyst Plan Coupon for @tondatahub 😳

Dune has been impressed by the growing activity of TON-related queries on Dune. To support our contributors, Dune is offering 50 free Analyst plan coupons to those experiencing credit limitations.

▪ Coupon Name: TON
▪ Plan: Analyst (more query credits)
▪ Duration: 1 month (free)

⚠️ Important: After the free month, the plan will automatically renew at the standard rate. To avoid charges, you must manually downgrade before the month ends.

(this is not a joke)

Act fast—coupons are limited! 💙

EVAA Protocol workshop with @sepezho

Join the contest
-> Read the rules

Workshop in less than a hour.

I’ll send a link to Google meet here. Stay tuned. Prepare your questions

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

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

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

🤔 The Dune Dashboards contest has wrapped up, here are the winners!

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

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!

☕️🏃‍♂️

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

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

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

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 THE ABSOLUTE WINNER
THE GOLD MEDAL HOLDER
THE 3000 USD₮ OWNER

🏅🏅🏅🏅🏅🏅🏅🏅🏅🏅🏅
👑 dune.com/tubaecci/dedust 👑
🏅🏅🏅🏅🏅🏅��🏅🏅🏅🏅

👑👑👑 @tubaecci 👑👑👑

SILVER MEDAL
AND 2000 USD₮ ON TON

💍🪙📎🩶🖇️📏��🛸🥄🍴
🥈 dune.com/vaitar/dedust 🥈
📐🛸🥄🍴💍🖇️📏🪙📎🩶

(star it on dune please)

BRONZE MEDAL
AND 1000 USD₮ ON TON

🥉 🥉 🥉 🥉 🥉 🥉 🥉 🥉
➡️ dune.com/msu/dedust ⬅️
🥉 🥉 🥉 🥉 🥉 🥉 🥉 🥉

(don’t forget to smash a star on dune)

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.

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://t.me/thedailyton/869

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

💰 TON Games Revenue 💰

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

💡 Did you know that you can send HTTP requests from your Dune query?

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

📰 The First-Ever TON Data Contest Has Concluded!

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

Deadline in 1 hour. Make sure we can open your link (test in incognito)

⚠️ Deadline in 12 hours!

🔗 Rules
�� Submission form
🔗 Workshop #1
🔗 Workshop #2 & QnA Session

lil reminder about the deadline in ~1.5 days

don’t forget to submit a link to your dashboard (even unfinished) 🐳

💡 HINT:

DeDust launched the aggregator on Mar, 14.
So you can speed up your queries by reading the required partitions only:

WHERE block_date >= TIMESTAMP '2025-03-14'

Just updated the bonus task from Dedust. Added more clarifications and examples.

They shipped their own dex aggregator that finds the most optimal path maximising the output usd value of you swap.

🔗 Read in Googe Doc

Questions? Welcome to chat @tondatachat.

The workshop from 2025-03-19

🤯 BONUS TASK FROM DeDust

As you may know, DeDust launched their dex agregator recently. And they want to know what’s happening there!

read more / ask questions in chat

Less than 4 days left!

We've already received 8 submissions.

The top 3 dashboards will share a $6,000 prize pool.

Deadline: Mar, 24 00:00 UTC

Submit your dashboard link now, you can update it later:
https://forms.gle/qvvSexJJayAAXEB37

some links from the qna session:

▪ notes from the call (google docs)
▪ ton-labels (github)
▪ ton-data-llm-txt (github)
▪ ton-labels-extension (github)
▪ ton data quickstart dashboard (dune)
▪ build graphs like on img (link)
▪ docs on raw TON tables (dune)
▪ dune quickstart guide (blog)

Join ➡ @tondatachat

Materialized views and how they were generated

Jetton Metadata Latest values (sql)
- dune.ton_foundation.result_ton_jettons_metadata_latest_values

Dex pools latest values (sql)
- dune.ton_foundation.result_dex_pools_latest

Dex pools daily values (sql)
- dune.ton_foundation.result_dex_pools_daily

Jetton & TON Balances (sql, work in progress)
- dune.ton_foundation.result_balances_latest

Jetton & TON prices daily (sql)
- ton.prices_daily

TON accounts properties (sql)
- ton.accounts

Join ➡ @tondatachat

QnA Starts now:
https://meet.google.com/gqe-tfrd-jei

QnA session in 1 hour!

Let’s have a QnA session tomorrow March, 19. 3PM UTC (in 24.5 hours).

I’ll show useful materialized views (custom tables on Dune) and answer your questions. See you!

⚠️ A quick reminder: submission deadline for DeDust dashboard is Mar, 24 00:00 UTC.

So this Sunday is the last day you can send a link to your dashboard in our google form. I’d recommend you to submit the link to your unfinished dashboard now (2 people did it).

Also all participants will get a unique SBT from TON Society.

Rules / Submission form

Do you need a QnA session tomorrow❓

If yes, react on this message and drop a question in the chat.

Huge milestone for TON Data:

Together we labelled 1000+ addresses! 🍾

Workshop recording

We discussed each contest task and shared some hacks on how to win.

🔗 youtu.be/yyfuT5eFKic

Join our workshop

The event will cover an introduction to Dune, a step-by-step guide for data contest tasks, strategies for using AI and existing dashboards for SQL queries, and techniques for finding onchain activity patterns, followed by a Q&A session.

https://meet.google.com/fdr-zcrt-rgf

Workshop in 53 minutes! Will send a link here. https://t.me/tondatahub/13

FYI

Once a label is added to our repo, it automatically appears on Dune!

You can access the 986 existing labels using this query:


SELECT *
FROM dune.ton_foundation.dataset_labels
WHERE organization = 'dedust'


Here’s an example of how these labels help analyze application activity on TON: https://dune.com/ton_foundation/application-activity

We’ve sent out our first bounties for address labels!

🔗 Eligible addresses: Spreadsheet

Labeled addresses are now marked. Check merged PRs for formatting examples and evidence.

Join Our TON Data Workshop Tomorrow!

📅 When? Tomorrow at 4 PM UTC
📌 What? A workshop on getting started with TON data analysis using Dune, followed by a short Q&A session.

We'll share the event link here shortly before we begin. See you there!
Feel free to drop your questions in the chat.

🏷️ Clarification on the Labelling Task

TL;DR: We will only reward labels for addresses listed in this 🔗 Dune Dashboard.

However, we encourage labelling other addresses belonging to organizations (apps, DeFi, CeFi, etc.) in TON.

For convenience, we’ve copied the dashboard list into this spreadsheet:
📄 Google Spreadsheet
Rewards apply only to addresses from this list.

📨 How to Submit a Label
1️⃣ Open a PR in this repo: GitHub Repo
2️⃣ Ensure all CI tests pass (entries must follow the correct format).
3️⃣ Provide one direct (e.g., a screenshot of an app interaction) or two indirect (e.g., third-party mentions) pieces of evidence for each address.

💬 Questions? Ask in our chat: @tondatachat

If you want to doublecheck the numbers from your dashboards, you can use Defillama. They have mostly correct data.

https://defillama.com/protocol/dedust?volume=true

🎨 Some cool Dune dashboards for dexes for your inspiration

Uniswap V4: https://dune.com/uniswap_fnd/unichain-overview-metrics
Uniswap V4: https://dune.com/uniswap_fnd/uniswap-v4-metrics-by-pools-and-assets
Stonfi: https://dune.com/whale_hunter/stonfi
Camelot: https://dune.com/whale_hunter/camelot-dex
Balancer: https://dune.com/balancer/vebal
Balancer: https://dune.com/balancer/exchange

Looking for the location of specific TON data on Dune? Drop a question — I’ll show how to find it.

E.g. All dex trades are already decoded and located in table ton.dex_trades.

Build a Dashboard for DeDust
——————> Win up to $3000

Welcome to our first data contest where we reward for making TON data more transparent.

Build a Dune dashboard for DeDust and win:
🥇 1st place: $3000
🥈 2nd place: $2000
🥉 3rd place: $1000

📅 Deadline: Mar, 24

Read more:
👉 [ Rules & Guidelines ] 👈
(bonus task for onchain detectives inside)

Got questions? Ask in our chat: @tondatachat

Jetton Transfer Fees Dashboard on Dune!

This tool compares average fees for Jetton transfers (covering the full transaction chain) with standard TON transfers. It also serves as a practical example of how to calculate fees on the TON blockchain.

Dive in here: https://dune.com/pshuvalov/ton-transfers-fees-dashboard

How to start analysing data on TON?

A quickstart guide: formats, tables and materialize views you should know.

https://blog.ton.org/ton-on-chain-data-analysis-dune

Start your journey here:

https://dune.com/blockchains/ton