Syscoin: Streaming Full Historical Blockchain Data

Syscoin is a blockchain platform uniting Bitcoin’s security, Ethereum’s smart contracts, and ZK-Rollups for scalability. It delivers a decentralized blockchain, development platform, and token framework with high throughput and cross-chain interoperability. Syscoin supports Ethereum-like smart contracts for Syscoin Platform Tokens (SPTs) and scalable solutions for blockchains and DLTs. 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 only 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.

Syscoin是一款融合比特币安全性、以太坊智能合约与零知识汇总（ZK-Rollups）以实现可扩展性的区块链平台。其提供具备高吞吐量与跨链互操作性的去中心化区块链、开发平台与通证框架，支持面向Syscoin平台通证（SPTs）的类以太坊智能合约，以及面向区块链与分布式账本技术（DLTs）的可扩展解决方案。更多信息请访问：[www.sonarx.com](https://www.sonarx.com/)
数据集包含以下数据表：
- 授权记录表（Approvals）：该表存储区块链上执行操作（如通证转账或与非同质化通证（NFTs）交互）的授权相关关键信息。
- 区块表（Blocks）：批量交易的打包处理单元，该表涵盖区块活动的全部详细信息。
- 日志表（Logs）：日志记录的集合，核心用于存储事件。单条日志记录同时包含主题（Topics）与数据两部分：主题是包含事件签名及所有索引字段的列表，单条日志记录最多可包含4个主题。日志承载智能合约在执行过程中可“触发”的事件。
- 净额计价转账表（Priced Net Transfers）：针对数字资产的精选转账“事件”数据表，涵盖原生通证、ERC-20标准通证及其他类型通证的全部转账记录。该表通过通证元数据完成所有数值转换，并将历史资产价值折算为美元。与标准计价转账表的区别在于，本表根据转账双方将转账记录拆分为流入与流出两类，便于从特定主体（钱包、交易所与智能合约）的视角评估转账行为。
- 计价转账表（Priced Transfers）：针对数字资产的精选转账“事件”数据表，涵盖原生通证、ERC-20标准通证及其他类型通证的全部转账记录。该表通过通证元数据完成所有数值转换，并将历史资产价值折算为美元。
- 交易收据表（Receipts）：用于记录交易状态的数据源，SonarX通过该表的数据区分交易成功与失败的情况。
- 通证元数据表（Tokens）：用于标识通证核心属性与类型的精选元数据集。
- 通证转账表（Token Transfers）：提供通证转账相关信息，包括交易哈希、转账发起方、接收方、通证类型、转账金额与时间戳。
- 成功交易表（Transactions）：仅收录成功完成的交易，包含原生通证转账金额与交易消耗的Gas等详细信息。
- 失败交易表（Transactions Failed）：仅收录通过交易收据状态标识的失败交易。

搜集汇总

背景与挑战

背景概述

该数据集提供Syscoin区块链的完整历史数据，该平台融合比特币的安全性和以太坊的智能合约功能。包含区块、交易、代币转移等9类核心数据表，涵盖权限记录、交易状态、资产定价等关键链上活动信息。