Solutions to Extract Data from Ethereum
Tags: distributedledger, ethereum, blockchain, onchaindata
Published: 2019-01-16 11:32:13

---
title: Solutions to Extract Data from Ethereum
published: true
description: Ethereum is easy and fun, but it is also relatively new. The developer solutions today are going through the teething stage - so, it’s new and cool but also slightly painful. As an example, take data extraction from the Ethereum blockchain. I’ve been keeping an eye out on solutions to access smart contract data in a decentralized way. In this article, I also include centralized data query companies and centralized analytics dashboards.
tags: Distributed Ledger, Ethereum, Blockchain,On-Chain Data
---

Originally published on [madewithtea.com](https://www.madewithtea.com/solutions-to-extract-data-from-ethereum.html)


Ethereum started in 2013. Ethereum became the de-facto standard to
develop and run smart contracts. Data is either value transfer in Ether, ERC-20 (think of all the [ICOs](https://icodrops.com)), crypto-collectibles a.k.a. non-fungible tokens (NFTs, e.g. digital kittens in [CryptoKitties](https://www.cryptokitties.co/), virtual land property in [Decentraland](https://decentraland.org/)) or custom smart contract calls. [State of the Dapps](https://www.stateofthedapps.com/rankings) is counting 1763 dApps on Ethereum. Another good resource is [DappRadar](https://dappradar.com/dapps).

If you want to extract data from an already deployed smart contract - or right after deployment - one might **shop for monitoring and analytics tools** similar to Google Analytics or Mixpanel. However, there’s **no established player yet**. Monitoring and analytics are just two use cases, further use cases for data follow after the list. Since **decentralization and open source go hand in hand**, I'll start with it:

### Open Source

* **[EthQL](https://github.com/ConsenSys/ethql)**: ConsenSys project, GraphQL endpoint to the public Ethereum ledger
* **[QuickBlocks](https://github.com/Great-Hill-Corporation/quickBlocks)**: collection of tools to retrieve Ethereum data
* **[EthSlurp](http://ethslurp.com/)**: Extracting TXs for specific address or smart contract to CSV or text file
* **[EthEvents](https://github.com/brainbot-com/ethevents)**: Indexing transactions, events into ElasticSearch, [talk](https://www.youtube.com/watch?v=zoNlF4MfHVg)
* **[Kundera](https://github.com/Impetus/Kundera)**: JPA to extract data from nodes and ingest them into a variety of sinks
* **[Presto-Ethereum](https://github.com/xiaoyao1991/presto-ethereum)**: Presto Connector to Ethereum clients
* **[The Graph](https://www.thegraph.com/)**: Decentralized scalable queries for blockchain data (ICO stage)
* **[Smart Contract Watch](https://github.com/Neufund/smart-contract-watch)**: A smart contract monitoring tool
* **[Eventeum](https://github.com/ConsenSys/eventeum)**: Event-bridge between Ethereum and microservices
* **[Seth](https://github.com/dapphub/dapptools/tree/master/src/seth)**: Metamask for the command-line
* **[Gnarly](https://github.com/XLNT/gnarly)**: Gnarly ETL tool
* **[Ethereum ETL](https://github.com/medvedev1088/ethereum-etl)**: Set of ETL scripts
* **[CoinMetrics Scripts](https://github.com/coinmetrics-io/haskell-tools)**: Haskell based scripts
* **[EtherSQL](https://github.com/analyseether/ether_sql)**: Python scripts
* **[Chainsaw](https://github.com/SpankChain/chainsaw)**: Simple event tracking by Spankchain
* **[Dappboard-etl](https://github.com/DAppBoard/dappboard-etl?files=1)**: Analytics ETL for Dapps
* **[VulcanizeDB](https://github.com/vulcanize/VulcanizeDB)**: Set of tools that write dapp indexes and caches.
* **[Blockchain2Graph](https://github.com/straumat/blockchain2graph)**: Extracts blockchain data to Neo4j

### Data Query Companies

* **[TokenAnalyst](https://docs.tokenanalyst.io)**: Free cross-chain on-chain data provider
* **[Alethio](https://aleth.io)**: ConsenSys-backed, Working on semantic lifting of data, [talk](https://www.youtube.com/watch?v=KzfEDNuNFi8&t=21s)
* **[Chainalysis](https://www.chainalysis.com/)**: KYC and AML services for exchanges and governments
* **[Elliptic](https://www.elliptic.co/)**: KYC and AML services
* **[Zapier](https://zapier.com/apps/dagger-for-ethereum/integrations)**: Ethereum integration into Zapier

### Analytics Dashboards

* **[Bloxy](https://bloxy.info/analytics)**: Analytics Dashboard for Ethereum
* **[Etherscan](https://etherscan.io/)**: De-facto standard block explorer for Ethereum
* **[Amberdata](https://amberdata.io/)**: Analytics for ERC-20 tokens, [talk](https://www.youtube.com/watch?v=IhugJ__ickM)
* **[TokenAnalyst](https://www.tokenanalyst.io/)**: Analytics for ERC-20 tokens and ICOs, [talk](https://www.youtube.com/watch?v=JopYHeEetC8)
* **[Rufflet](http://rufflet.cryptokitties.co/)**: Mixpanel for smart contracts hack by Axiom Zen, creators of CryptoKitties
* **[Supermax](https://supermax.cool/)**: Another smart contract dashboard
* **[Blockspur](https://blockspur.com/)**: Another smart contract dashboard
* **[Trivial](https://trivial.co/)**: Another smart contract dashboard

### Use Cases

Here are five use cases for getting data out: 1) **Providing transparency** and accountability for governance of e.g. DAOs or companies e.g. DACs. 2) **Automated tax returns** for smart contracts 3) **Smart contract monitoring** e.g. getting notifications when things happen e.g. anomaly detection 4) **Smart contract reporting** e.g like website reports, sales resports 5) **Auditing support** e.g. for ICOs (distribution of token holders).

### Did I miss one?

This article should serve as a list of resources for solutions in the smart contract analytics and monitoring space. Please let me know if I missed one, or important references. Would also be fun if you can share stories of interesting things you were able to do with these tools. And also if there are tools you wish to exist!