Bitlayer: Streaming Full Historical Blockchain Data

Bitlayer is a Bitcoin Layer 2 solution utilizing the BitVM paradigm. It provides Turing completeness while maintaining security equivalent to Bitcoin. Designed to enhance the Bitcoin ecosystem, Bitlayer focuses on secure scalability, support for diverse assets, and fostering innovation. It aims to deliver a faster, safer, and more flexible user experience. 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.

Bitlayer是采用BitVM范式的比特币二层扩容方案，可在保持与比特币同等安全性的前提下实现图灵完备性。该方案旨在赋能比特币生态，聚焦安全可扩展性、多资产支持与生态创新，致力于为用户提供更快捷、更安全且更灵活的使用体验。更多信息可访问[www.sonarx.com](https://www.sonarx.com/)

<p><br/></p>

数据集包含以下数据表：
- 授权表（Approvals）：该表存储区块链上已授予的操作权限相关关键信息，例如代币转账或与非同质化代币（NFT，Non-Fungible Token）的交互权限。
- 区块表（Blocks）：包含批量处理的交易集，记录区块活动的全部细节信息。
- 日志表（Logs）：日志记录的集合，核心承载各类事件。单条日志记录同时包含主题（Topics）与数据（Data）两部分：主题为一个列表，涵盖事件签名及所有索引字段，单条日志最多可包含4个主题。日志承载的事件是智能合约在执行过程中可主动“触发”的事件。
- 计价净转账表（Priced Net Transfers）：针对数字资产转账“事件”整理的专用数据表，涵盖原生代币、ERC20标准代币及其他类型代币的全部转账记录。该表通过代币元数据完成数值转换，并将历史资产价值折算为美元计价。与标准计价转账表的区别在于，本数据表根据转账的收发双方，将转账拆分为流入与流出两类，适用于针对特定主体（钱包、交易所与智能合约）的转账分析。
- 计价转账表（Priced Transfers）：针对数字资产转账“事件”整理的专用数据表，涵盖原生代币、ERC20标准代币及其他类型代币的全部转账记录。该表通过代币元数据完成数值转换，并将历史资产价值折算为美元计价。
- 交易收据表（Receipts）：用于查询交易状态的数据集，SonarX通过该表的数据区分交易成功与失败的情况。
- 代币元数据表（Tokens）：整理了用于标识代币核心属性与类型的元数据信息。
- 代币转账表（Token Transfers）：提供代币转账相关信息，包括交易哈希、发送方、接收方、代币类型、转账金额与时间戳。
- 成功交易表（Transactions）：收录所有成功的交易，包含原生代币用量、交易消耗的燃气（Gas）等详细信息。
- 失败交易表（Transactions Failed）：仅收录通过交易收据状态识别出的失败交易。
- 提现记录表（Withdrawals）：汇总区块链网络内质押合约或协议下所有提现操作信息的数据库表。

搜集汇总

背景与挑战

背景概述

Bitlayer是一个采用BitVM范式的比特币Layer 2解决方案，在保持与比特币同等安全性的同时实现图灵完备，旨在通过安全扩展和多资产支持增强比特币生态。该数据集提供完整的区块链历史数据流，包含区块、交易、代币转移、日志、授权等多个表格，用于记录和分析链上活动。