Raw
1. ethereum.blobs
Table Description
The most important features of EIP-4844, a new type of transaction, solves the scalability problem that we’re all familiar with when it comes to ethereum. Blobs are binary large objects that store unstructured data in databases. In the context of blockchain data, blobs can be used to store various types of information, such as images, documents, or other binary data related to blockchain transactions, smart contracts, or other blockchain-related entities. Blobs are typically stored in databases as binary data and can be retrieved and processed as needed. For example, blobs can be used to store images of NFTs, documents related to smart contracts, or other large data files that are associated with blockchain entities.
Column Descriptions
Table Sample
2. ethereum.blocks
Table Description
The Ethereum.blocks table stores crucial data about the Ethereum blockchain’s block structure. Each block in the Ethereum blockchain contains a unique set of data that ensures the integrity and chronological order of transactions. Blocks are the building blocks of the Ethereum blockchain, and they contain several key components:
-
Block Header: This includes metadata such as the block number, timestamp, parent block hash, and nonce. The header is essential for maintaining the blockchain’s integrity and linking blocks together in a chain.
-
Transactions: Each block includes a list of transactions that have been validated and added to the blockchain. These transactions consist of various operations, such as transfers of Ether, execution of smart contracts, and other state changes.
-
Uncle Blocks (Ommer Blocks): These are blocks that were mined but not included in the main chain. They are referenced in the block to improve the chain’s security and reward miners for their efforts.
-
State Root: This is a cryptographic hash representing the state of the entire Ethereum network at the time the block was mined. It includes account balances, storage, and other state data.
-
Receipts Root: This is a hash of the receipts of all transactions included in the block. Receipts contain information about the execution of transactions, such as gas used and logs generated.
The Ethereum.blocks table provides a detailed and organized view of the blockchain’s structure, allowing for efficient retrieval and analysis of blockchain data. This information is crucial for developers, researchers, and analysts working with the Ethereum blockchain, as it enables them to understand the state and evolution of the network.
Column Descriptions
Table Sample
3. ethereum.contracts
Table Description
The Ethereum.contracts table contains essential data about smart contracts deployed on the Ethereum blockchain. Smart contracts are self-executing contracts with the terms of the agreement directly written into code. They are a fundamental aspect of Ethereum, enabling decentralized applications (DApps) and automating complex transactions without intermediaries. The Ethereum.contracts table includes several key components:
-
Contract Address: This is a unique identifier for each smart contract deployed on the Ethereum network. It is derived from the creator’s address and the transaction nonce.
-
Creator Address: This is the Ethereum address of the account that deployed the smart contract. It provides traceability and accountability for the origin of the contract.
-
Creation Transaction: This includes the transaction hash of the deployment transaction, linking the contract to the specific transaction that created it.
-
Bytecode: This is the compiled code of the smart contract that gets executed on the Ethereum Virtual Machine (EVM). It includes the contract’s logic and functions.
-
ABI (Application Binary Interface): The ABI defines the contract’s interface, including its functions, inputs, and outputs. It is crucial for interacting with the contract programmatically.
-
Source Code (optional): Some contracts include the original source code, providing transparency and enabling verification of the compiled bytecode.
-
Block Number: This indicates the block in which the smart contract was deployed, providing a chronological context for the contract’s creation.
-
Timestamp: The exact time when the smart contract was deployed, allowing for time-based analysis and tracking.
Column Descriptions
Table Sample
4. ethereum.token_transfers
Table Description
Token transfers in the context of blockchain data refer to the movement of digital tokens from one address to another. These transfers can be tracked on the blockchain, providing a transparent record of token movements. Here are some key points to understand about token transfers:Token transfers can be initiated by users or smart contracts. For example, a user can send tokens to another user, or a smart contract can transfer tokens to a user as part of a transaction.Token transfers can be tracked on the blockchain, providing a transparent record of token movements. This is particularly useful for auditing and compliance purposes.
Column Descriptions
Table Sample
5. ethereum.trace_calls
Table Description
The Ethereum.trace_calls table contains detailed data about the execution of transactions on the Ethereum blockchain. Trace calls provide a granular view of what happens during the execution of a transaction, including internal transactions and function calls within smart contracts. This information is essential for debugging, auditing, and understanding the complex interactions within the Ethereum network. The Ethereum.trace_calls table is a powerful tool for developers, auditors, and researchers working with Ethereum. It provides an in-depth view of transaction execution, enabling detailed analysis of smart contract interactions and internal transactions. This information is vital for ensuring the security, efficiency, and transparency of operations on the Ethereum network.
Column Descriptions
Table Sample
6. ethereum.transaction_logs
Table Description
This dataset holds detailed logs emitted during transactions by smart contract events. These logs are pivotal for tracking activities such as token transfers, contract updates, and custom event notifications set by contract developers. For instance, when a user transfers ERC-20 tokens, the transaction log would capture the ‘Transfer’ event with details like the sender’s address, recipient’s address, and the amount transferred. This information is crucial for applications that need to monitor and respond to specific contract activities.
Column Descriptions
Table Sample
7. ethereum.transactions
Table Description
The dataset encompasses comprehensive details of all transactions on the network. It includes the initiating account, destination address, value transferred, gas used, and the data payload. For example, when a user sends Ether to another user, the transaction record would include the sender’s and receiver’s addresses, the amount of Ether sent, and the gas price paid for the transaction. Additionally, it also captures the nonce, which is the transaction count of the sender, helping in preventing double-spending and replay attacks.
Column Descriptions
Table Sample
8. ethereum.withdrawals
Table Description
This table specifically documents withdrawal transactions from the network, focusing on the amount withdrawn, the source address, and the destination address. It’s crucial for analyzing the flow of value out of Ethereum, such as Ether or token withdrawals to external wallets or exchanges. For example, when a user withdraws Ether from a DeFi platform to their personal wallet, the transaction would be recorded here, including details like the withdrawal amount and the receiving wallet address, offering insights into user behavior and liquidity movements.