Crosschain Stats Cortex

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.

原始信息汇总

Crosschain Stats Cortex 数据集概述

数据集基本信息

• 数据集名称: Crosschain Stats Cortex
• 提供商: Flipside Crypto
• 访问方式: 免费访问（需申请）
• 数据更新频率: 每小时
• 时间覆盖范围: 2025年1月1日之后
• 数据粒度: 按小时

数据集描述

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

核心特性

• 预聚合和跨链分析表
• 支持每日和每小时指标
• 包含标准化USD计价指标
• 优化用于跨链比较分析和时间序列研究
• 预连接并包含USD定价，查询速度显著快于原始事实表

数据表结构

主要数据表

• 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: 近实时性能监控

数据类别

核心活动指标

• 交易跟踪
• 费用统计
• 唯一用户数

DEX指标

• 去中心化交易所交易量
• 交易者行为分析
• 链级和协议级监控

专业分析表

• 桥接分析
• 中心化交易所流
• 稳定币分析
• 代币级交易活动

数据质量特性

• 包含基于用户评分（4+）的"质量"指标
• 支持高价值用户行为与整体网络活动对比分析
• 保持数据准确性

技术架构

• 一致的模式结构，包含BLOCKCHAIN、BLOCK_DATE（或BLOCK_HOUR）字段
• 标准化USD计价指标
• 支持跨链比较分析

云区域可用性

AWS

• Asia Pacific (Jakarta)
• Asia Pacific (Mumbai)
• Asia Pacific (Osaka)
• Asia Pacific (Seoul)
• 45个其他区域

支持区块链

包括Ethereum、Solana、Arbitrum、Avalanche、Binance Smart Chain (BSC)、Gnosis、Optimism、Polygon、Osmosis、Near、Flow、Thorchain和Aptos等。

搜集汇总

背景与挑战

背景概述

Crosschain Stats Cortex 数据集提供跨区块链网络的预聚合每日和每小时指标，涵盖活动、DeFi、流动性及资产流等标准化度量，并包含高质量用户行为筛选功能。其一致的表结构和USD定价支持高效的跨链比较与时间序列分析，适用于生态级区块链智能研究。