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 中的工具旨在滿足各個層級的分析師的需求，無論他們需要為更簡單的用例執行簡單的聚合事件或基於事務的查詢，還是需要為有經驗的使用者和用例提供低階資料集。對於進階用戶來說，完整的資料集可直接整合到管道和分析工具中。