Mode: Streaming Full Historical Blockchain Data

Mode is a DeFi ecosystem built on top of Optimism, a Layer-2 network running on the Ethereum blockchain. Mode is designed to facilitate the development of new DeFi dApps, serving as a hub for all things finance on Ethereum. 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 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 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/>
- Traces: Traces are only provided on archive nodes and store every function call that is emitted on the blockchain.

Mode是一款构建于以太坊（Ethereum）二层网络Optimism之上的去中心化金融（DeFi，Decentralized Finance）生态系统，旨在助力新型DeFi去中心化应用（dApps，decentralized applications）的开发，成为以太坊生态内全金融类应用的枢纽。更多信息可访问[www.sonarx.com](https://www.sonarx.com/)

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

搜集汇总

背景与挑战

背景概述

该数据集提供基于Optimism链的Mode DeFi生态全量历史数据，包含区块、交易、代币转移等11类结构化数据表，支持开发者分析链上活动并构建金融应用。所有资产转移记录均包含美元计价转换，并区分成功/失败交易状态。