Blast: Streaming Full Historical Blockchain Data

Blast is an EVM-compatible Ethereum layer 2 platform that offers native yield for ether and stablecoins. It operates as an optimistic rollup solution to tackle scalability issues on Ethereum by increasing the network’s capacity for more transactions at lower costs. Learn more at [www.sonarx.com](https://www.sonarx.com/)

<p><br/></p>

Tables include:

- Approvals: This table stores vital information regarding permissions granted for actions executed on the blockchain, such as token transfers or interactions with non-fungible tokens (NFTs).<br/>
- Blocks: Batches of transactions are processed together. This table provides all the details about the block activity.<br/>
- Logs: Collection of log records and most importantly they contain events. A single log record includes both topics and data. Topics is a list that includes the signature of the event as well as any indexed fields. A single log record can have up to four topics in it. Logs contain events, where smart contracts have the ability to "emit" events during execution.<br/>
- Priced Net Transfers: Curated table of transfer "events" for a digital asset. They include all transfers including the native token, erc20s, and other token types. This table has converted all the values using token metadata and have priced historical asset value to USD. The difference of the net table vs the standard priced table is that the transfers are broken up into in-flow and out-flow based on the sending and receiving parties. It's useful when evaluating transfers from a party: wallets, exchanges, and smart contracts.<br/>
- Priced Transfers: Curated table of transfer "events" for a digital asset. They include all transfers including the native token, erc20s, and other token types. This table has converted all the values using token metadata and have priced historical asset value to USD.<br/>
- Receipts: Provided for transactions to know the status of a transaction. SonarX uses the receipts data to identify successful vs failed transactions.<br/>
- Tokens: Curated metadata that identify the key properties of a token and identify the token type.<br/>
- Token Transfers: Provides information about token transfers, including transaction hash, sender, recipient, token type, amount, and timestamp.<br/>
- Transactions: Contains successful transactions and contain details including the amount of native token and gas which was used in the transaction.<br/>
- Transactions Failed: Contains only failed transactions which are identified by the transaction receipt status.<br/>
- Withdrawals: A database table that compiles information about withdrawals made from staking contracts or protocols within the blockchain network.

搜集汇总

背景与挑战

背景概述

该数据集提供流式全历史区块链数据，源自Blast这一以太坊二层平台，旨在通过乐观Rollup技术提升交易处理能力并降低成本。数据集包含多个核心表格，如区块、交易、日志、代币转移和代币元数据等，用于记录和分析区块链上的各类活动，包括权限批准、资产转移和交易状态。