What is a Transaction? Ethereum is a global computer that executes smart contract and stores its data (generally referred as contract state). In addition to smart contract’s state, it also stores account balances i.e ETH owned by accounts.

Ethereum is a decentralized protocol that supports smart contract execution. What does that mean? Let’s decode DECENTRALIZATION A centralized system is owned by a single or group of entities. They provide value by facilitating transactions between the participants, unless otherwise it is hard to achieve. …

How does anyone get this information? The public blockchain records everything that happens on the Ethereum network. Every participating node contains raw data that can be queried to learn or answer questions about what is going on in the ecosystem. Let’s take a look at the data stores in an…

Despite the fact that Ethereum was launched in 2015, there was no easy way to query blockchain data until a few years ago. Although Ethereum clients expose APIs for accessing account balances and transaction logs, they lack options for efficiently filtering and aggregating data for analytical purposes. In this article…

It is alright if you are not familiar with Ethereum or SQL. You can build the dashboard by following the steps. I hope this will motivate you to explore blockchain analytics further. Blockchain data Ethereum is a decentralised protocol that supports the execution of smart contracts. It is one of the most…

Anyone can access public blockchain data because it is not owned by any centralized entity. As the ecosystem expands, the blockchain will store an infinite amount of valuable information. When combined with data analytics and machine learning, the insights gleaned from such open data would be extremely valuable. Despite the…

Transaction receipt contains transaction outcomes (status and logs) and are organised in a trie structure. The receipt data resides in the state database and the root hash is stored in the block header. What information does the receipt trie contain? Who stands to benefit? Let’s dig deeper into those questions.

An Ethereum node stores two types of data : block data and state data. State data includes world state trie, account storage trie, transaction receipt trie and transaction trie. Every block has one transaction trie. Transaction trie organises the transactions in the block into a tree structure, and the root…

Ethereum is a world computer meaning that it can be accessed by anyone anywhere and they could all see the same information. It has a single global state that holds information about account balances and smart contract data. It is not a physical computer but an imaginary one made up…