five

Hyperliquid Premium Onchain Data

收藏
Snowflake2026-03-25 更新2026-03-27 收录
下载链接:
https://app.snowflake.com/marketplace/listing/GZT0Z438N7G6G
下载链接
链接失效反馈
官方服务:
资源简介:
Flipside Crypto provides access to the most comprehensive blockchain data in crypto covering dozens of chains, DEX exchanges, and thousands of protocols. Our data sets empower analysts, data scientists, developers, and AI agents without the hassle of managing nodes, decoding transactions, or building complex pipelines. <p><br/></p> Premium listings deliver curated, labeled, and priced data structured for both human analysts and AI agents. Core listings are also available for raw and decoded data without labels, prices, or curation. <p><br/></p> HOW TO GET ACCESS 1. Click Request on this listing page 2. Our team will reach out with pricing and terms 3. Once agreed, data access is provisioned directly to your Snowflake account 4. Start querying immediately. <p><br/></p> Sample Tables (HyperCore L1): core.fact_trades, core.ez_perp_trades, core.ez_spot_trades, core.ez_perp_fills, core.ez_perp_liquidations, core.ez_perp_funding_payments, core.ez_perp_funding_rates, core.ez_perp_candles, core.ez_perp_l2_book, core.ez_perp_predicted_fundings, core.ez_perp_asset_snapshots, core.ez_spot_asset_snapshots, core.fact_ledger_events, core.fact_staking_events, core.fact_validator_rewards, core.fact_mid_prices, core.fact_vault_snapshots, core.dim_perp_markets, core.dim_spot_markets <p><br/></p> Sample Tables (HyperEVM): core.fact_blocks, core.fact_transactions, core.fact_event_logs, core.fact_traces, core.ez_native_transfers, core.ez_token_transfers, core.ez_decoded_event_logs, core.dim_contracts, core.dim_contract_abis, core.dim_labels, nft.ez_nft_transfers, price.ez_prices_hourly, price.dim_asset_metadata, stats.ez_core_metrics_hourly <p><br/></p> Fields Include: trade_id, block_number, block_timestamp, coin, symbol, market_type, trade_timestamp, tx_hash, price, trade_size, trade_notional, buyer_address, seller_address, is_liquidation, fill_side, is_taker, user_address, fee, closed_pnl, counterparty_address, liquidated_address, event_type, amount, usdc_value, validator_address, reward_amount, funding_amount, funding_rate, open_interest, oracle_price, mark_price, mid_price, asset_index, token_index, token_name, tvl, apr, from_address, to_address, contract_address, event_name, decoded_log, amount_usd, balance, balance_usd, label_type, label
提供机构:
Flipside Crypto
创建时间:
2026-03-25
原始信息汇总

Hyperliquid Premium Onchain Data 数据集概述

数据集基本信息

  • 数据集名称: Hyperliquid Premium Onchain Data
  • 提供商: Flipside Crypto
  • 数据描述: 完整的 HyperCore L1 和 HyperEVM 数据
  • 数据类别: 区块链分析、商业、金融
  • 数据更新频率: 每小时
  • 时间覆盖范围: 2025年7月27日之后
  • 数据触发方式: 基于事件

数据内容与结构

核心数据范围

  • HyperCore L1数据: 涵盖永续期货、现货交易、资金、质押、验证者奖励、市场快照。
  • HyperEVM数据: 涵盖EVM交易、事件日志、追踪、代币转账、解码合约、NFT、标签、价格。

示例表(HyperCore L1)

core.fact_trades, core.ez_perp_trades, core.ez_spot_trades, core.ez_perp_fills, core.ez_perp_liquidations, core.ez_perp_funding_payments, core.ez_perp_funding_rates, core.ez_perp_candles, core.ez_perp_l2_book, core.ez_perp_predicted_fundings, core.ez_perp_asset_snapshots, core.ez_spot_asset_snapshots, core.fact_ledger_events, core.fact_staking_events, core.fact_validator_rewards, core.fact_mid_prices, core.fact_vault_snapshots, core.dim_perp_markets, core.dim_spot_markets

示例表(HyperEVM)

core.fact_blocks, core.fact_transactions, core.fact_event_logs, core.fact_traces, core.ez_native_transfers, core.ez_token_transfers, core.ez_decoded_event_logs, core.dim_contracts, core.dim_contract_abis, core.dim_labels, nft.ez_nft_transfers, price.ez_prices_hourly, price.dim_asset_metadata, stats.ez_core_metrics_hourly

包含的字段示例

trade_id, block_number, block_timestamp, coin, symbol, market_type, trade_timestamp, tx_hash, price, trade_size, trade_notional, buyer_address, seller_address, is_liquidation, fill_side, is_taker, user_address, fee, closed_pnl, counterparty_address, liquidated_address, event_type, amount, usdc_value, validator_address, reward_amount, funding_amount, funding_rate, open_interest, oracle_price, mark_price, mid_price, asset_index, token_index, token_name, tvl, apr, from_address, to_address, contract_address, event_name, decoded_log, amount_usd, balance, balance_usd, label_type, label

数据字典详情(以FACT_TRADES为例)

表描述

核心事实表,记录Hyperliquid上所有市场类型(永续期货、现货和预发行)的每一笔匹配交易。每一行代表一笔包含买卖双方详情、费用、盈亏和清算信息的交易。这是HyperCore上所有交易活动的主要事实来源。

关键用例

  • 分析永续、现货和预发行市场的交易量和模式。
  • 跟踪买方/卖方活动、费用和已实现盈亏。
  • 监控清算事件和方法。
  • 衡量做市商(构建者)参与度和费用。
  • 理解时间加权平均价格和客户端订单路由。

重要关联关系

  • 通过core__ez_perp_trades丰富(连接dim_perp_markets获取杠杆、规模小数)。
  • 通过core__ez_spot_trades丰富(连接dim_spot_markets获取代币名称、规范状态)。
  • 市场类型源自代币格式:普通=永续,@N=现货,xyz:name=预发行。
  • 符号从dim_spot_marketssilver__token_details解析现货代币。

常用字段

  • trade_id: 来自L1的唯一交易标识符。
  • coin / symbol: 原始资产ID和人类可读符号。
  • market_type: perpspotprelaunch
  • price / trade_size / trade_notional: 执行价格、规模和美元名义价值。
  • buyer_address / seller_address: 交易对手方。
  • buyer_fee / seller_fee: 收取的费用(负值=回扣)。
  • is_liquidation: 此交易是否为清算。

数据预览(FACT_TRADES表列示例)

TRADE_ID, BLOCK_NUMBER, BLOCK_TIMESTAMP, COIN, SYMBOL, MARKET_TYPE, TRADE_TIMESTAMP, TX_HASH, PRICE, TRADE_SIZE, TRADE_NOTIONAL, BUYER_ADDRESS, SELLER_ADDRESS, BUYER_ORDER_ID, SELLER_ORDER_ID, BUYER_DIR, SELLER_DIR, BUYER_CROSSED, SELLER_CROSSED, BUYER_FEE, SELLER_FEE, FEE_TOKEN, BUYER_CLOSED_PNL, SELLER_CLOSED_PNL, BUYER_START_POSITION, SELLER_START_POSITION, BUYER_BUILDER_ADDRESS, BUYER_BUILDER_FEE, SELLER_BUILDER_ADDRESS, SELLER_BUILDER_FEE, BUILDER_FEE, BUYER_TWAP_ID, SELLER_TWAP_ID, BUYER_CLIENT_ORDER_ID, SELLER_CLIENT_ORDER_ID, LIQUIDATED_USER, LIQUIDATION_MARK_PRICE, LIQUIDATION_METHOD, IS_LIQUIDATION, INSERTED_TIMESTAMP, MODIFIED_TIMESTAMP, FACT_TRADES_ID, _INVOCATION_ID

使用示例

每日HyperCore永续交易量

sql SELECT block_timestamp::DATE as dt, COUNT(*) as trades, SUM(trade_notional) as volume FROM core.fact_trades WHERE market_type = perp AND block_timestamp >= DATEADD(day, -7, CURRENT_DATE) GROUP BY 1 ORDER BY 1

获取方式与定价

  • 获取步骤:
    1. 在此列表页面点击“请求”。
    2. 团队将联系您并提供定价和条款。
    3. 达成一致后,数据访问权限将直接配置到您的Snowflake账户。
    4. 立即开始查询。
  • 定价模式: 按需请求。

云区域可用性

  • AWS: 亚太(雅加达)、亚太(孟买)、亚太(大阪)、亚太(首尔)等48个区域。

支持与联系

  • 销售: data-shares@flipsidecrypto.com
  • 支持: data-shares@flipsidecrypto.com
5,000+
优质数据集
54 个
任务类型
进入经典数据集
二维码
社区交流群

面向社区/商业的数据集话题

二维码
科研交流群

面向高校/科研机构的开源数据集话题

数据驱动未来

携手共赢发展

商业合作