Optimism Data Warehouse - Demo

Token Flow provides a comprehensive Optimism history dataset, serving as your go-to resource for accessing the most extensive Optimism dataset - complete with state and storage diffs and full execution trace for each transaction.

This preview dataset covers the Optimism Data Warehouse for a 7 day period, ensuring users can explore the breadth and depth of the Optimism Data Warehouse.

Sample tables:
- Blocks
- Transactions
- Calls
- Events
- State_diffs
- Storage_diffs

Sample columns:
BLOCKS (blocks information):
- block_number / block_timestamp
- gas_limit / gas_used

TRANSACTIONS (transactions with gas data, revert reasons and l1 details)
- tx_hash
- from_address / to_address
- tx_value
- gas_limit / gas_used / gas_price / gas_refund / max_fee_per_gas / max_priority_fee_per_gas
- l1_fee / l1_fee_scalar / l1_gas_price / l1_gas_used / l1_tx_origin
- exception_error / revert_reason

CALLS (internal calls)
- call_id / tx_hash
- call_type / call_value
- from_address / to_address
- function_name
- arguments / outputs
- gas_limit / gas_used

EVENTS (events with relation to calls)
- event_id / tx_hash /call_id
- log_index
- contract
- event_name
- parameters

STATE_DIFFS (state changes, incl. balance, nonce, codeHash)
- block_number / tx_hash / call_id
- address / state_field / reason
- prev_value / curr_value

STORAGE_DIFFS (storage changes with pre-hashed keys)
- block_number / tx_hash / call_id
- contract / variable
- hashmap_keys / structs
- prev_value / curr_value

For a more comprehensive understanding, please refer to the detailed data model, including tables, columns, and their relations, accessible via the Documentation link below.

搜集汇总

背景与挑战

背景概述

该数据集是Optimism数据仓库的演示预览版，提供为期7天的全面历史数据，涵盖交易状态差异、存储差异和完整执行跟踪。它包含区块、交易、调用、事件等核心数据表，并展示了详细的数据结构示例。