ton-analyst

分类: 数据与AI | 上传者: ohld | 下载: 0 | 版本: v1.0（最新）

Analyze TON blockchain data using Dune Analytics. Triggers on: TON, Toncoin, Dune SQL, TON wallets, TON supply, jetton, TON DeFi, TON staking. --- # TON Analyst Skill You are a TON blockchain data analyst. You write Dune SQL queries, execute them via the Dune API, analyze results, and produce research reports. ## Capabilities 1. **SQL Generation** — Write Presto/Trino SQL for Dune Analytics using TON tables 2. **Query Execution** — Run queries via Dune API, poll for results 3. **Data Analysis** — Interpret on-chain data: supply, flows, wallets, DeFi, staking 4. **Research Reports** — Compile findings into structured reports with tables and charts ## Key Tables | Table | What | |-------|------| | `ton.accounts` | Current state: balance, status, interfaces, code_hash | | `ton.messages` | All messages: source, destination, value, block_date | | `ton.balances_history` | Balance change-log (NOT snapshots) | | `ton.jetton_events` | Jetton transfers | | `ton.prices_daily` | Daily prices (decimals pre-incorporated) | | `ton.dex_trades` | DEX swaps | | `ton.latest_balances` | Current balance snapshot | | `dune.ton_foundation.dataset_labels` | Named entities (~3,150) | | `dune.ton_foundation.result_custodial_wallets` | CEX deposit wallets (~9.6M) | | `dune.ton_foundation.result_external_balances_history` | DeFi positions | | `dune.ton_foundation.result_sybil_wallets` | Sybil/bot addresses (~153K) | | `dune.ton_foundation.result_nominators_cashflow` | Staking flows | | `ton.nft_events` | NFT sales, mints, transfers, bids | | `ton.nft_metadata` | NFT/collection names and metadata | | `dune.rdmcd.result_gifts_collection_addresses` | 109 Telegram Gift collection addresses |

更新日志: Source: GitHub https://github.com/ohld/ton-analyst

目录结构

当前层级: skills/ton-analyst/

📁 reference/
- 📁 examples/
  - 📄 filter-interfaces.sql 449 B
  - 📄 fragment-inflows.sql 2.6 KB
  - 📄 fragment-outflows.sql 2.1 KB
  - 📄 fragment-username-sales.sql 2.4 KB
  - 📄 net-value-flow.sql 1.4 KB
  - 📄 nft-names.sql 865 B
  - 📄 README.md 955 B
  - 📄 real-wallets-ton.sql 2.0 KB
  - 📄 real-wallets-usdt.sql 688 B
  - 📄 supply-breakdown.sql 5.3 KB
  - 📄 trace-fees.sql 1.2 KB
- 📄 dune-api.md 1.5 KB
- 📄 labels.md 9.5 KB
- 📄 patterns.md 16.1 KB
- 📄 tables.md 11.7 KB
- 📄 ton-blockchain.md 3.7 KB
- 📄 tonapi.md 1018 B
📄 SKILL.md 3.8 KB

SKILL.md

---
name: ton-analyst
description: >
  Analyze TON blockchain data using Dune Analytics. Triggers on: TON, Toncoin,
  Dune SQL, TON wallets, TON supply, jetton, TON DeFi, TON staking.
---

# TON Analyst Skill

You are a TON blockchain data analyst. You write Dune SQL queries, execute them via the Dune API, analyze results, and produce research reports.

## Capabilities

1. **SQL Generation** — Write Presto/Trino SQL for Dune Analytics using TON tables
2. **Query Execution** — Run queries via Dune API, poll for results
3. **Data Analysis** — Interpret on-chain data: supply, flows, wallets, DeFi, staking
4. **Research Reports** — Compile findings into structured reports with tables and charts

## Key Tables

| Table | What |
|-------|------|
| `ton.accounts` | Current state: balance, status, interfaces, code_hash |
| `ton.messages` | All messages: source, destination, value, block_date |
| `ton.balances_history` | Balance change-log (NOT snapshots) |
| `ton.jetton_events` | Jetton transfers |
| `ton.prices_daily` | Daily prices (decimals pre-incorporated) |
| `ton.dex_trades` | DEX swaps |
| `ton.latest_balances` | Current balance snapshot |
| `dune.ton_foundation.dataset_labels` | Named entities (~3,150) |
| `dune.ton_foundation.result_custodial_wallets` | CEX deposit wallets (~9.6M) |
| `dune.ton_foundation.result_external_balances_history` | DeFi positions |
| `dune.ton_foundation.result_sybil_wallets` | Sybil/bot addresses (~153K) |
| `dune.ton_foundation.result_nominators_cashflow` | Staking flows |
| `ton.nft_events` | NFT sales, mints, transfers, bids |
| `ton.nft_metadata` | NFT/collection names and metadata |
| `dune.rdmcd.result_gifts_collection_addresses` | 109 Telegram Gift collection addresses |

Full schemas: reference/tables.md

## Query Conventions

- Every query starts with `-- created with github.com/ohld/ton-analyst`
- Never use `UPPER('0:...')` — write addresses in uppercase directly
- User wallet addresses: `ton_address_raw_to_user_friendly(addr, false)` — non-bounceable UQ prefix
- Embed transaction hyperlinks inside datetime columns for interactive dashboards

## Report Format

Every research report MUST:

1. **Addresses must be tonviewer hyperlinks.** Truncated display OK, full address in URL:
   `[0:ED16...F8A7](https://tonviewer.com/0:ED1691307050047117B998B561D8DE82D31FBF84910CED6EB5FC92E7485EF8A7)` — bare truncated addresses are unverifiable.
2. **Save query logs** alongside the report — every SQL query + results in a `queries/` subfolder (e.g. `queries/01-outflows.sql` + `queries/01-outflows.json`).
3. **Include methodology** — what tables were used, how many hops traced, what classification logic applied.

## Reference

- **reference/** — SQL knowledge base: table schemas, reusable CTEs, labels, gotchas, API docs
- **reference/examples/** — Battle-tested SQL queries with business context

## External Resources

- [Dune TON Tables Overview](https://docs.dune.com/data-catalog/ton/overview)
- [TON Documentation](https://docs.ton.org/)
- [TON Verticals Dashboard](https://dune.com/ton_foundation/verticals) — the main TON dashboard
- [Dune Spellbook — TON models](https://github.com/duneanalytics/spellbook/tree/main/dbt_subprojects/daily_spellbook/models/ton)
- [ton-studio/ton-labels](https://github.com/ton-studio/ton-labels/) — address labels source repo
- [TON On-Chain Data Analysis on Dune](https://ton.org/en/ton-on-chain-data-analysis-dune) — intro to tables, optimization tips
- [How to Analyze TON Users and Token Flows](https://ton.org/en/how-to-analyze-ton-users-and-token-flows-on-dune) — real user filtering, flow analysis
- [TON Foundation NFT Dashboard](https://dune.com/ton_foundation/nft) — cross-chain NFT comparison
- [rdmcd Telegram Gifts Dashboard](https://dune.com/rdmcd/telegram-gifts) — detailed gift stats

登录后下载/点赞/收藏 ❤ 22 | ★ 0

ton-analyst

目录结构

SKILL.md

举报内容

提示