Features and Chains
Last updated
Last updated
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
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.
The core table structure per chain in Studio is the same as in the Data Platform.
Tier 1 includes blocks, transactions, events, calls.
Tier 2 includes Tier 1 plus messages(if applicable), state diffs ,storage diffs and transient storage diffs.
For each chain you will find the tables available listed under "Core" in the database explorer in Studio.
In addition to the Core Tables for each chain, we are also in the process of adding higher level datasets.
Chain specific higher level datasets are shown under each chain in the "Smart" grouping in the database explorer. These tables include tokens, transfers, DEX pricing etc.
Higher level datasets that are not chain specific can be found in the "Common" database in Studio, Currently this includes currencies and daily prices for top coins and tokens.
The following chains are available in Studio. The tables available for each chain are the same as in our Data Platform.
Ethereum
Starknet
Optimism
Base
Zora
Mode
Blast
Manta Pacific
Mint
Linea
Unichain Sepolia
The following chains and DA Layers are in the process of being added:
Arbitrum One
Polygon PoS
Polygon zkEVM
zkSync Era
Celestia
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.
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.
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.
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
