Index, Scan, and Explore Ethereum Data with SXT

In this blog, we’ll explore how to use Space and Time’s data indexing to efficiently scan and analyze Ethereum data. We'll dive into the SXT Studio, which enables you to analyze and access data on Ethereum with ease. Whether you're a developer, researcher, or an enthusiast, this guide will help you get started with using SXT to make the most of Ethereum data. 

An Intro to Ethereum Network

Ethereum is a decentralized blockchain that supports smart contract functionality. Its native cryptocurrency, Ether, is the second-largest cryptocurrency by market capitalization, following Bitcoin. It’s also an open-source platform, enabling developers to build and deploy dapps.

Since Space and Time indexes data from the genesis block (the first block upon which all subsequent blocks are added to the chain), SXT maintains a comprehensive, real-time copy of the Ethereum blockchain, storing it in a queryable format. This ensures that all Ethereum data is readily available for analysis.

Now, let’s explore how we can access Ethereum data using the Space and Time engine and how to index any smart contract, allowing you to create custom tables based on events from your contract easily.

Explore and Scan Ethereum Data with SXT

Visualize The Ethereum Dataset

Getting a visual representation of all the indexed Ethereum data is extremely easy. Just follow these two simple steps:

1. Navigate to the "Datasets" option in the main menu
2. Click on "Ethereum" Dataset

Analyze and Scan Ethereum Data using Queries

You don’t need to be a developer or have technical expertise to scan the Ethereum network with SXT Studio. Since SXT stores data in a queryable format, it supports standard SQL for efficient data querying. While SQL is accessible to data analysts, it can be challenging for non-technical users.

To bridge this gap, Space and Time allows users to ask queries in natural language, which AI automatically converts into SQL and executes, enabling everyone, regardless of technical knowledge, to ask questions directly and get answers instantly.

So whether you want to find out the number of Ethereum wallets with a balance greater than a billion over a specific period of time, or the top 10 Ethereum wallets with the highest transactions, SXT has got you covered!

Let’s take a look at how can you do this in two simple steps:

1. Log into the Studio
2. Navigate to the "Query Editor" button under the "Queries" tab in the main menu

Suppose you want to find out the top 10 Ethereum wallets with the highest transactions.

Run this Query in the Editor:

Show me the top 10 Ethereum wallets with the highest transactions

Build Your Own Ethereum Explorer with Space and Time

An Ethereum Explorer is a tool that lets users view and interact with data on the Ethereum blockchain, such as transactions, blocks, and addresses. It helps track real-time network activity, monitor smart contracts, and check balances, all in a user-friendly format. Popular explorers include Etherscan and Etherchain.

SXT Studio simplifies the process of building a custom Ethereum explorer and allows you to transform the data into a dashboard. In this segment, we’ll walk through the simple steps to retrieve the latest Ethereum transactions and create a personalized dashboard to display the data.

1. Log into the Studio
2. Navigate to the "Query Editor" button under the "Queries" tab in the main menu.

Suppose you want to find out the Last transactions that were performed on Ethereum

Run this Query in the Editor:

Show me the last transactions that were performed on Ethereum

Within the studio, you can gain a deeper and more intuitive understanding of the data through Query Visualization. This option allows you to visually represent your data, making it easier to identify patterns, trends, and insights.

Additionally, you can take this visualization a step further by creating a comprehensive dashboard that brings all the relevant information together in one place for better analysis. This not only enhances your ability to interpret the data but also helps you make informed, data-driven decisions more efficiently.

To do this follow these simple steps:

1. Switch to “Query Visualization” tab from the bottom
2. Click on “Save Chart”
3. You can repeat this step with the charts you want to use to create a dashboard

For example, we’re creating a dashboard based on our two previous queries

4. Navigate to the "New Dashboard" button under the "Dashboards" tab in the main menu
5. Customize the layout and add your saved visualizations
6. Click on “Save” on the top right

You can find your dashboards by simply navigating to "My Dashboards" button under the "Dashboards" tab in the main menu

‍Index Your Smart Contract Data on Ethereum Network

Indexing a smart contract involves capturing and organizing the events emitted by the contract into structured tables, making it easy for developers to query and access the data. This process simplifies data retrieval, enabling efficient use in applications.

Space and Time enables users to submit a smart contract address for indexing, automatically generating custom tables for the events emitted by that contract. These events are written into the tables, which can then be queried, joined with other indexed or offchain data, and ZK-proven in sub-seconds.

This allows developers to create highly customized, efficient, and sophisticated applications by easily querying and combining chain-level data, protocol-specific data, offchain data, and data from their own smart contract events—all in a fast, affordable, and ZK-proven manner.

Follow along these simple steps to index your smart contract on Ethereum:

1. Log into the Studio and navigate to the “Get data from chain” button under the “Smart Contracts” tab on the main menu
2. Select your contract’s chain and enter the address
3. Review the tables generated by recent onchain data and submit for indexing

That’s it! We pull the ABI, we automatically generate a table for each smart contract event, and we begin populating them for you automatically.

‍Click here to start querying blockchain data for free
‍

‍Space and Time’s indexing and querying capabilities allow developers, researchers, and enthusiasts to unlock the full potential of onchain data. Whether building dapps, exploring transaction trends, or analyzing blockchain events, SXT Studio makes Ethereum data easily accessible and actionable. By providing fast, cost-effective access to ZK-proven data, Space and Time empowers you to gain valuable insights that help you make data-driven decisions.