Token Flow Studio：用于区块链数据分析的 SQL 编辑器服务

Token Flow Studio，简称 Studio，是一种 SQL（结构化查询语言）编辑器服务，为传统和 Web3 原生团队和分析师提供对所有链上活动和智能合约的简单直接的数据分析。

Token Flow, a Swiss company, aims to simplify blockchain analytics by offering fully decoded blockchain data at scale.

瑞士公司 Token Flow 旨在通过大规模提供完全解码的区块链数据来简化区块链分析。

Their product, Token Flow Studio (also known as Studio), is an SQL (structured query language) editor service that provides an easy and direct way to analyze on-chain activities and smart contracts for both traditional and Web3 native teams and analysts.

他们的产品 Token Flow Studio（也称为 Studio）是一种 SQL（结构化查询语言）编辑器服务，为传统和 Web3 原生团队和分析师提供了一种简单直接的方法来分析链上活动和智能合约。

The complexity of blockchain data often makes it difficult for analysts to conduct analysis and derive insights from it. Studio aims to solve this problem by providing developers with a service that allows them to explore blockchain data, create visualizations, query using standard SQL, and publish dashboards.

区块链数据的复杂性通常使分析师难以进行分析并从中得出见解。 Studio 旨在通过为开发人员提供一项服务来解决这个问题，使他们能够探索区块链数据、创建可视化、使用标准 SQL 进行查询以及发布仪表板。

To simplify the process for analysts as much as possible, Studio supports Token Flow's multi-chain view, which provides the same few core tables and consistent schema across each chain, making cross-chain querying significantly easier.

为了尽可能简化分析师的流程，Studio 支持 Token Flow 的多链视图，该视图在每个链上提供相同的几个核心表和一致的架构，使跨链查询变得更加容易。

Since Token Flow's datasets are decoded, Studio provides multichain data in a human-readable format. Currently, it includes data from the Ethereum, Optimism, Starknet, Mode, Zora, Mint, Base, Blast, Linea and Frame ecosystems, with tables such as storage_diffs, events, calls, transactions, blocks, and more. The team also plans to integrate Arbitrum, Polygon and zkSync chains in the near future and continue adding more OP Stack chains.

由于 Token Flow 的数据集已解码，Studio 以人类可读的格式提供多链数据。目前，它包括来自以太坊、Optimism、Starknet、Mode、Zora、Mint、Base、Blast、Linea 和 Frame 生态系统的数据，以及 storage_diffs、事件、调用、交易、区块等表。该团队还计划在不久的将来集成 Arbitrum、Polygon 和 zkSync 链，并继续添加更多 OP Stack 链。

Smart Contract Decoding

智能合约解码

While blockchain data is freely available through nodes and RPCs, it is also difficult to use in its raw form. Unlike many indexer teams, Token Flow focuses not only on processing the data, but also on fully and automatically decoding the contents of the chain from genesis, making it easier to work with.

虽然区块链数据可以通过节点和 RPC 免费获取，但也很难以其原始形式使用。与许多索引器团队不同，Token Flow 不仅专注于处理数据，还专注于从创世开始完全自动解码链的内容，使其更易于使用。

All of Token Flow's datasets available in Studio are already decoded and ready to use, and thanks to their extensive semantics and signature library, contracts without verified code or published ABI can often still be decoded!

Studio 中提供的所有 Token Flow 数据集均已解码并可供使用，并且由于其广泛的语义和签名库，没有经过验证的代码或发布的 ABI 的合约通常仍然可以被解码！

Decoded State and Storage

解码状态和存储

Two of Token Flow's primary innovations are decoding state and storage. Once accessible and queryable, storage - a smart contract's own internal ledger - enables more reliable analysis, such as obtaining token balances by holder at any point in time without aggregating numerous calls and events.

Token Flow 的两项主要创新是解码状态和存储。一旦可访问和可查询，存储（智能合约自己的内部分类账）就可以实现更可靠的分析，例如在任何时间点获取持有者的代币余额，而无需聚合大量调用和事件。

Having previously made storage available only via data warehouse, Token Flow has now worked to simplify its usage - storage diffs will be available for Ethereum for everyone to use within Studio.

之前仅通过数据仓库提供存储，Token Flow 现在致力于简化其使用 - 存储差异将可用于以太坊，供每个人在 Studio 中使用。

How to Get Started

如何开始

To use Token Flow Studio, visit the studio homepage and create an account by clicking on the "sign up link" and entering your email and password, or using one of the available social login options.

要使用 Token Flow Studio，请访问工作室主页并通过单击“注册链接”并输入您的电子邮件和密码或使用可用的社交登录选项之一来创建帐户。

With Token Flow Studio, you can build your own dashboards, run ad-hoc queries, choose from a variety of visualizations and create your own dashboards that you can share with anyone.

借助 Token Flow Studio，您可以构建自己的仪表板、运行即席查询、从各种可视化中进行选择并创建可以与任何人共享的自己的仪表板。

For Ethereum, Token Flow provides analysts with a streamlined SQL experience with a strong emphasis on state and storage information. This opens up the possibility for easily consumable and precise data on any on-chain account's history of interaction with a specific ERC20 token, group of tokens, and more.

对于以太坊来说，Token Flow 为分析师提供了简化的 SQL 体验，重点关注状态和存储信息。这为任何链上账户与特定 ERC20 代币、代币组等的交互历史记录提供易于使用和精确的数据成为可能。

Dune SQL vs TF SQL Editor

Dune SQL 与 TF SQL 编辑器

All data is available in near real time, continuously updated and decoded.

所有数据均近乎实时可用，并不断更新和解码。

The query results can then be visualized in the preferred format and shared among peers or the wider community for a precise and collaborative approach to data analytics. Some useful analyses that Studio is suited for include calculating token holding rates, examining market maker positions, viewing total fees earned for a Uniswap v3 position, and more.

然后，查询结果可以以首选格式可视化，并在同行或更广泛的社区之间共享，以实现精确的协作数据分析方法。 Studio 适合的一些有用分析包括计算代币持有率、检查做市商头寸、查看 Uniswap v3 头寸赚取的总费用等等。

Data for Difficult Cases

疑难病例数据

In cases where basic data is insufficient to get the job done, Token Flow provides a simplified approach to handling complex cases.

当基本数据不足以完成工作时，Token Flow 提供了一种简化的方法来处理复杂的情况。

This includes indexing non-EVM chains like Starknet, indexing chains based on Cosmos SDK (Celestia, for example), or building a complex, cross chain board for tracking DEX activity, all of which is possible thanks to Token Flow's auto-decoding and storage diffs. You can now also explore this data in Studio!

这包括索引像 Starknet 这样的非 EVM 链、基于 Cosmos SDK（例如 Celestia）的索引链，或者构建一个复杂的跨链板来跟踪 DEX 活动，所有这些都是可能的，这要归功于 Token Flow 的自动解码和存储差异。您现在还可以在 Studio 中探索这些数据！

Summary

概括

Services like Token Flow Studio aim to streamline the experience for core teams and analysts.

Token Flow Studio 等服务旨在简化核心团队和分析师的体验。

The tools within Studio are designed to cater to analysts of all levels, whether they need to perform simple aggregated event or transaction based querying for simpler use cases, or require low level data sets for experienced users and use cases. For power users the full datasets are available directly for integration into pipelines and analytical tools.

Studio 中的工具旨在满足各个级别的分析师的需求，无论他们需要为更简单的用例执行简单的聚合事件或基于事务的查询，还是需要为有经验的用户和用例提供低级别数据集。对于高级用户来说，完整的数据集可直接集成到管道和分析工具中。