Token Flow Studio: SQL Editor Service for Blockchain Data Analysis

Token Flow Studio, or Studio for short, is an SQL (structured query language) editor service, offering traditional and Web3 native teams and analysts simple and direct data analysis for all on-chain activities and smart contracts.

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

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.

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.

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.

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.

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.

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!

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.

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.

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.

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.

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.

Dune SQL vs TF SQL Editor

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.

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.

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!

Summary

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

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.