Features

With Token Flow Studio you can ...

• Explore Blockchain Data: Access real-time data from multiple blockchains without restrictions in an unified format via our MultiChain Data Warehouse (MCDW).

• Query blockchain data with standard SQL: Write your own queries or use any of the ready-to-use predefined queries we have prepared for you.

• Create clear, interactive charts and graphs for effective data interpretation of your query results.

• Share Findings via Dashboards: Upcoming feature for collaborative, interactive dashboards to present and share insights

Explore Token Flow's MultiChain Data Warehouse

A classic user interface for a database exploration tool, displaying the list of available tables. When clicking on the table name, you'll see the table details below.

By double-clicking on either the name of the table or the name of the column, you'll add them directly to the query.

Only 7 core tables? Yes with multi-chain data. We use just seven core tables to represent the core on-chain datasets such as blocks, transactions, events, calls, messages, state diffs and storage diffs. This approach simplifies the process of cross-chain data analysis without compromising the depth and breadth of information available. Additional business tables will be added incrementally, such as tokens, transfers, wallets, vaults.

How to filter by chain?

Every table has a chain_id that allows query level filtering. Identifiers follow the standard Chainlist identifiers in decimal format, with the exception of Starknet.

Chain	chain_id	chain_id (hex)
Ethereum	1	0x1
Optimism	10	0xa
Base	8453	0x2105
Starknet	5461067	0x53544C
Polygon PoS	137	0x89
Arbitrum One	42161	0xa4b1

What about the data model?

We are using a unified data model for all chains, with unused columns returning a NULL value. Columns will contain only chain specific values and the meaning of the content will have to be interpreted according to each chain logic, as described in the chain specific documentation.

Run SQL Queries

Navigate to the Query area to start running queries against the available blockchain data. You can use standard SQL syntax. Here is a hands on guide to writing SQL queries, highlighting the particularities of our data.

You can start from scratch or use one of the shared queries.

Working with parameters

Make your queries reusable with parameters. This functionality will be particularly handy when sharing queries or creating dashboards later.

• Add new parameters using the big plus in the Parameters area or by simply using double curly brackets {{parameter_name}} in your sql syntax. Either way, parameters will show up in order in the right hand side panel.

• Remove parameters by deleting them from the SQL syntax.

• Pass values in the right hand side panel. All parameters are mandatory for query execution and there is no format validation.

Working with queries

• Running queries:

  • You can only run one query at a time.

  • Use standard keyboard shortcuts (cmd+enter / ctrl+enter) to run your query. If your query is successful you'll be shown the results, execution metrics (number of rows, result size and query duration in milliseconds) and the possibility to download the results in .csv format. Otherwise, you'll be shown an error message. Fix the issue and run the query again.

Currently, execution time is limited at 5 minutes and return a maximum of 10'000 rows.

• Saving Queries

  • You can save queries in your personal library.

  • When saving a query, you'll save the query content, it's parameters and any visualisation configuration you may have added to your query. Results are not saved.

  • Queries are not being autosaved, so make sure you save any changes you make.

  • You cannot edit shared queries, but you can Fork them. This will create a new query in you personal library.

Query names are not unique so make sure you provide a meaningful name so you can easily retrieve your queries later.

Add Visualisations

For every query you are running you can add an associated visualisation:

• bar

• line

• area

• pie

Each chart time has specific configurations:

• selecting data

  • select one or multiple columns from the results to be plotted on the X and Y axis.

• configuring the appearance

  • show or hide the chart legend

  • add axis labels

  • configure the color palette