Ethereum

The **Ethereum Raw dataset** provides a complete, query-ready mirror of the Ethereum blockchain, directly accessible in Snowflake. This data share includes canonical blockchain entities such as blocks, transactions, logs, token standards, traces, and smart contracts — all decoded and normalized for analytical use. Each table corresponds to a core component of Ethereum's execution layer, enabling detailed analysis of on-chain activity without requiring node infrastructure, indexing, or ETL pipelines.

**This dataset eliminates months of engineering effort typically required to build and maintain blockchain data pipelines, allowing teams to immediately query historical and real-time Ethereum data for market intelligence, risk assessment, and product development.** The dataset is refreshed continuously to maintain alignment with the live chain and structured for efficient SQL exploration, time-series analysis, and integration with DeFi, NFT, and Web3 analytics workflows.

## Example questions

1. For the latest 10 blocks on Ethereum, list the block number, its timestamp, the total number of transactions, and the sum of Ether (in Wei) transferred by all transactions within each block.
2. For the 10 most recently deployed contracts, retrieve their address, the deployer's address, the transaction hash that created them, and any associated log entries (emitter address, topic0) and trace entries (trace type, from address, to address, value) that occurred within the same creation transaction.

Snowflake Semantic views capture the metadata required for consistent and accurate AI-powered analytics, such as synonyms, sample values and verified queries.

原始信息汇总

Ethereum Raw 数据集概述

数据集基本信息

• 数据集名称: Ethereum Raw
• 提供商: Allium
• 数据内容: 以太坊区块链原始数据

数据集描述

该数据集提供以太坊区块链的完整、可直接查询的镜像，可直接在Snowflake中访问。数据共享包括规范的区块链实体，如区块、交易、日志、代币标准、追踪和智能合约，所有数据均已解码和规范化，可供分析使用。

核心特性

• 每个表对应以太坊执行层的核心组件
• 无需节点基础设施、索引或ETL管道即可进行详细的链上活动分析
• 持续更新以保持与实时链的一致性
• 为高效的SQL探索、时间序列分析以及与DeFi、NFT和Web3分析工作流程的集成而构建

数据结构

主要数据表

• BLOCKS表: 包含区块相关数据

BLOCKS表字段结构

• TIMESTAMP_NTZ (TIMESTAMP)
• NUMBER (NUMBER)
• HASH (Varchar)
• PARENT_HASH (Varchar)
• NONCE (Varchar)
• SHA3_UNCLES (Varchar)
• LOGS_BLOOM (Varchar)
• TRANSACTIONS_ROOT (Varchar)
• STATE_ROOT (Varchar)
• RECEIPTS_ROOT (Varchar)
• MINER (Varchar)
• DIFFICULTY (Number)
• TOTAL_DIFFICULTY (Number)
• SIZE (Number)
• EXTRA_DATA (Varchar)
• GAS_LIMIT (Number)
• GAS_USED (Number)
• TRANSACTION_COUNT (Number)
• BASE_FEE_PER_GAS (Number)
• _CREATED_AT (Timestamp_NTZ)
• _UPDATED_AT (Timestamp_NTZ)
• BLOB_GAS_USED (Number)
• EXCESS_BLOB_GAS (Number)
• PARENT_BEACON_BLOCK_ROOT (Varchar)

业务应用场景

区块链分析

• 追踪跨钱包的资金流动
• 识别交易模式
• 分析智能合约交互以进行风险评分、欺诈检测或市场研究
• 构建用户细分模型
• 监控协议采用指标
• 创建合规报告系统

技术优势

• 消除构建和维护区块链数据管道通常需要的数月工程工作
• 支持实时和历史以太坊数据查询
• 适用于市场情报、风险评估和产品开发

数据更新频率

• 刷新频率: 每小时

云区域可用性

• GCP: US Central 1 (Iowa)

联系信息

• 销售: [e-mail]
• 支持: [e-mail]

搜集汇总

背景与挑战

背景概述

该数据集提供标准化的以太坊区块链完整镜像数据，包含区块、交易、智能合约等核心实体，支持实时查询和历史分析，无需自行搭建数据管道。数据持续更新并优化结构，便于直接用于市场分析、风险评估及Web3产品开发等场景。