Visualizing Ethereum Data Using Spotfire

Introduction

With the increasing applications of blockchain and web3 technologies, it is more and more interesting to analyze the data on public permissionless blockchains.  However, blockchain data are typically encoded in their proprietary format, and not readily accessible by data analysts.

To help bridge the gap, we developed an open-source project eth-track that decodes Ethereum data and stores decoded data in a ClickHouse database.  We can then visualize and analyze the decoded data by using Spotfire.

Solution

To make the ClickHouse database available to Spotfire Analyst, we created a ClickHouse data source in a TIBCO Data Virtualization (TDV) instance by using the ClickHouse JDBC Driver v0.2.6, which is then used to implement Spotfire dashboard.

The Ethereum Dashboard demonstrates a snapshot view of the following Ethereum statistics:

• Blocks created by top miners, which shows the fact that most Ethereum blocks are created by only less than a dozen miners.
• Transactions and events created by top smart contracts.
• Token transfer transactions and events created by top ERC20 tokens.
• Top accounts that send and receive ERC20 tokens, which shows the fact that some accounts are involved in sending much more than receiving tokens, or vice versa.
• Top accounts that send or receive USDC tokens, which shows the fact that most active accounts send the same amount of tokens as they receive, although the number of send transactions may be different from the receive transactions.

This sample dashboard can display real-time Ethereum data when it is connected to a ClickHouse database that receives real-time update from the Ethereum Tracker.