Base
收藏Snowflake2025-10-27 更新2025-10-29 收录
下载链接：
https://app.snowflake.com/marketplace/listing/GZ2FQZ3OJ5PT8
下载链接
链接失效反馈官方服务：
资源简介：
The **Base Raw dataset** provides a complete, query-ready mirror of the Base 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 Base'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 Base 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. What is the total number of blocks and the average gas used per block for blocks mined in October 2025?
2. How many contracts were deployed by the address '0x379002701bf6f2862e3dfdd1f96d3c5e1bf450b6' in January 2025?
Snowflake Semantic views capture the metadata required for consistent and accurate AI-powered analytics, such as synonyms, sample values and verified queries.
提供机构：
Allium
创建时间：
2025-10-24
原始信息汇总
Base Raw 数据集概述
数据集基本信息
- 数据集名称: Base Raw
- 提供商: Allium
- 定价模式: 免费试用
- 试用期限: 7天试用期
数据集描述
Base Raw 数据集提供 Base 区块链的完整、可直接查询的镜像，可直接在 Snowflake 中访问。该数据共享包括规范的区块链实体，如区块、交易、日志、代币标准、追踪和智能合约，所有数据均已解码和规范化，便于分析使用。
核心特性
- 每个表对应 Base 执行层的核心组件
- 无需节点基础设施、索引或 ETL 管道
- 持续刷新以保持与实时链同步
- 为高效的 SQL 探索、时间序列分析而构建
- 支持 DeFi、NFT 和 Web3 分析工作流程集成
技术规格
- 刷新频率: 近实时
- 云区域可用性:
- AWS: 亚太地区（雅加达、孟买、大阪、首尔）等20多个区域
数据表结构
BLOCKS 表
包含以下列：
- NUMBER (数字)
- TIMESTAMP_NTZ (时间戳)
- HASH (字符串)
- PARENT_HASH (字符串)
- NONCE (字符串)
- SHA3_UNCLES (字符串)
- LOGS_BLOOM (字符串)
- STATE_ROOT (字符串)
- RECEIPTS_ROOT (字符串)
- MINER (字符串)
- DIFFICULTY (数字)
- TOTAL_DIFFICULTY (数字)
- SIZE (数字)
- EXTRA_DATA (字符串)
- GAS_LIMIT (数字)
- GAS_USED (数字)
- BASE_FEE_PER_GAS (数字)
- TRANSACTION_COUNT (数字)
- TRANSACTIONS_ROOT (字符串)
- _CREATED_AT (时间戳)
- _UPDATED_AT (时间戳)
应用场景
- 区块链分析
- 资金流向追踪
- 交易模式识别
- 智能合约交互分析
- 风险评分和欺诈检测
- 市场研究
- 用户细分模型构建
- 协议采用指标监控
- 合规报告系统
- 实时仪表板
- 金融产品丰富
- 区块链行为机器学习模型训练
示例查询
- 2025年10月挖出的区块总数和每个区块的平均Gas使用量是多少？
- 地址0x379002701bf6f2862e3dfdd1f96d3c5e1bf450b6在2025年1月部署了多少个合约？
联系方式
- 销售: inquiry@allium.so
- 支持: support@allium.so
