Cross Blockchain Stats

The CROSSCHAIN.STATS schema contains a suite of pre-aggregated, cross-chain analytics tables that provide daily (and hourly) metrics across multiple blockchain networks. These enriched tables are designed for efficient analysis of blockchain ecosystem performance, offering standardized metrics that span activity, decentralized finance (DeFi), liquidity, and asset flows. The schema includes core activity metrics tracking transactions, fees, and unique users; DEX metrics monitoring decentralized exchange volumes and swapper behavior at both chain and protocol levels; and specialized tables for bridges, centralized exchange flows, stablecoins, and token-level trading activity. Many tables include "quality" metrics that filter data based on user scores (4+), enabling analysis of high-value user behavior versus overall network activity.

<p><br/></p>

These tables are optimized for cross-chain comparative analysis and time-series research, with consistent schema structures featuring BLOCKCHAIN, BLOCK_DATE (or BLOCK_HOUR), and standardized USD-denominated metrics. Key tables include EZ_ACTIVITY_METRICS_DAILY for general network health, EZ_DEX_METRICS_DAILY and EZ_DEX_PROTOCOL_METRICS_DAILY for trading analytics, EZ_TVL_CHAIN_METRICS_DAILY  for liquidity tracking with 90-day risk metrics, EZ_BRIDGE_METRICS_DAILY for inter-chain asset flows, EZ_CEX_FLOWS_DAILY for exchange deposit/withdrawal patterns, and EZ_STABLECOIN_FLOWS_DAILY for stablecoin movement analysis. The schema also includes EZ_CORE_METRICS_HOURLY for near real-time performance monitoring. All tables are pre-joined and enriched with USD pricing, making them significantly faster to query than raw fact tables while maintaining data accuracy for ecosystem-wide blockchain intelligence.<br/>

<br/>Sample Questions:

- I want to see the aggregate CEX deposit and withdrawal volumes in USD for all centralized exchanges combined over the past 3 days (October 12-14, 2025)
- What are the top 5 blockchains that had the highest number of transactions for the week of OCT 6th 2025 - how does that compare to the weekly average over the last 6 months?

<p><br/></p>

<p><br/></p>

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

原始信息汇总

Cross Blockchain Stats 数据集概述

基本信息

• 数据集名称: Cross Blockchain Stats
• 提供商: Flipside Crypto
• 访问权限: 免费
• 访问模式: 无限制访问

数据集描述

CROSSCHAIN.STATS schema 包含一套预聚合的跨链分析表，提供跨多个区块链网络的每日（和每小时）指标。这些增强表旨在高效分析区块链生态系统性能，提供涵盖活动、去中心化金融（DeFi）、流动性和资产流的标准化指标。

核心特征

• 预聚合数据: 经过预连接和USD定价增强，查询速度显著快于原始事实表
• 质量指标: 包含基于用户评分（4+）过滤数据的"质量"指标，支持高价值用户行为分析
• 优化分析: 专为跨链比较分析和时间序列研究优化
• 一致结构: 具有一致的schema结构，包含BLOCKCHAIN、BLOCK_DATE（或BLOCK_HOUR）和标准化USD计价指标

数据表分类

核心活动指标

• 跟踪交易、费用和唯一用户

DEX指标

• 监控去中心化交易所交易量和交易者行为
• 涵盖链级别和协议级别

专业表

• 桥接指标
• 中心化交易所资金流
• 稳定币
• 代币级别交易活动

主要数据表

• EZ_ACTIVITY_METRICS_DAILY：通用网络健康状况
• EZ_DEX_METRICS_DAILY 和 EZ_DEX_PROTOCOL_METRICS_DAILY：交易分析
• EZ_TVL_CHAIN_METRICS_DAILY：流动性跟踪（含90天风险指标）
• EZ_BRIDGE_METRICS_DAILY：链间资产流
• EZ_CEX_FLOWS_DAILY：交易所存取款模式
• EZ_STABLECOIN_FLOWS_DAILY：稳定币流动分析
• EZ_CORE_METRICS_HOURLY：近实时性能监控

技术规格

• 刷新频率: 每小时
• 时间覆盖范围: 2025年1月1日之后
• 时间粒度: 按小时
• 云区域可用性: AWS多个区域

示例查询应用

• 查看过去3天所有中心化交易所的聚合CEX存款和取款量（USD）
• 比较2025年10月6日当周交易量最高的前5个区块链与过去6个月周平均值的对比

数据字典示例

EZ_BRIDGE_METRICS_DAILY表包含以下列：

• BLOCKCHAIN (Varchar)
• BLOCK_DATE (Date)
• TOTAL_INBOUND_VOLUME (Float)
• DISTINCT_INBOUND_ADDRESSES (Number)
• DISTINCT_INBOUND_TRANSACTIONS (Number)
• TOTAL_OUTBOUND_VOLUME (Float)
• DISTINCT_OUTBOUND_ADDRESSES (Number)
• DISTINCT_OUTBOUND_TRANSACTIONS (Number)
• NET_VOLUME (Float)
• GROSS_VOLUME (Float)
• EZ_BRIDGE_METRICS_DAILY_ID (Varchar)
• INSERTED_TIMESTAMP (Timestamp_NTZ)
• MODIFIED_TIMESTAMP (Timestamp_NTZ)