BitqueryBitqueryData Store
HyperliquidTransfersEvents

Hyperliquid Ledger and Funding

HyperCore ledger events: deposits, withdrawals, sends, vault flows, funding payments, staking and bridge events, plus actions written from HyperEVM contracts.

Coverage
Latest monthto Sep 23, 2026 · yesterday
Tables
2Parquet, one prefix each
Columns
65across 2 tables
Coverage ends yesterday, UTC

Overview

Hyperliquid ledger and funding data from the HyperCore L1. The misc_events table holds every non-trading account event: ledger updates (deposits, withdrawals, sends, sub-account and account class transfers, vault flows), funding payments, bridge deposits and withdrawals, staking delegations, validator rewards and gossip. InnerType says which event a row is, and only that group's columns are filled. The core_writer_actions table records actions HyperEVM contracts wrote into HyperCore through the CoreWriter precompile, with the HyperEVM transaction hash that triggered each.

Balances are not a table here; derive them by summing ledger deltas per User and Token from a known starting point, and add the fills from the Hyperliquid Trades dataset for perp position changes. Amounts are decimal strings, addresses are 0x-prefixed hex, and Time is epoch nanoseconds.

Use cases

  • Deposit, withdrawal and transfer flows by wallet, token and day
  • Funding payments received and paid per wallet and market
  • Vault deposits, withdrawals and leader commissions
  • HyperEVM to HyperCore activity: spot sends, orders and transfers placed through CoreWriter, with the EVM transaction hash

2 tables

65 columns · free sample for each table

misc_events

38 columns

Ledger updates (deposits, withdrawals, sends, transfers, vault flows), funding payments, bridge events, delegations, validator rewards and gossip. InnerType says which; only that group's columns are filled.

hyperliquid/misc_events<start_block>_<end_block>.parquet200 blocks per file
Browse columns Sample fileSample updated Sep 2, 2026

core_writer_actions

27 columns

Actions written into HyperCore from HyperEVM contracts through the CoreWriter precompile: spot sends, orders, vault and class transfers, staking, with the HyperEVM transaction hash.

hyperliquid/core_writer_actions<start_block>_<end_block>.parquet200 blocks per file
Browse columns Sample fileSample updated Sep 2, 2026

Schema reference

copies a column name
65 columns
misc_events38 columnsLedger updates (deposits, withdrawals, sends, transfers, vault flows), funding payments, bridge events, delegations, validator rewards and gossip. InnerType says which; only that group's columns are filled.
ColumnTypeDescription
Block2
Block_NumberUInt64HyperCore block number; the join key across all seven tables
Block_TimeUInt64Block time, epoch nanoseconds
Other10
TimeUInt64Event time, epoch nanoseconds
HashStringL1 transaction hash, 0x-prefixed hex; not a join key, one transaction spans many events and TWAP trades carry 32 zero bytes
InnerTypeStringWhich event this row is: LedgerUpdate, Funding, CDeposit, CWithdrawal, Delegation, ValidatorRewards or Gossip
FundingMapFunding payment details when InnerType is Funding, else null
CDepositMapBridge deposit details when InnerType is CDeposit, else null
CWithdrawalMapBridge withdrawal details when InnerType is CWithdrawal, else null
DelegationMapStaking delegation details when InnerType is Delegation, else null
ValidatorRewardsMapValidator reward details when InnerType is ValidatorRewards, else null
GossipMapGossip event details when InnerType is Gossip, else null
ExtraMapForward-compatibility map; non-empty when the node emitted a field not yet modelled
LedgerUpdate2
LedgerUpdate_UsersArrayAccounts touched by the ledger update
LedgerUpdate_ExtraMapForward-compatibility map; non-empty when the node emitted a field not yet modelled
LedgerUpdate_Delta24
LedgerUpdate_Delta_TypeStringLedger delta type: send, deposit, withdraw, accountClassTransfer, subAccountTransfer, vaultDeposit, and so on
LedgerUpdate_Delta_UserStringAccount the delta applies to
LedgerUpdate_Delta_AmountDecimalAmount moved, in the token's units
LedgerUpdate_Delta_TokenStringToken moved, for example USDC
LedgerUpdate_Delta_UsdcDecimalUSDC amount for deltas denominated in USDC, else null
LedgerUpdate_Delta_UsdcValueDecimalUSD value of the delta
LedgerUpdate_Delta_DestinationStringReceiving account for sends and transfers
LedgerUpdate_Delta_DestinationDexStringDestination HIP-3 dex for cross-dex transfers, empty otherwise
LedgerUpdate_Delta_SourceDexStringSource HIP-3 dex for cross-dex transfers, empty otherwise
LedgerUpdate_Delta_FeeDecimalFee charged on the delta
LedgerUpdate_Delta_FeeTokenStringToken the fee was charged in, empty when no fee
LedgerUpdate_Delta_NativeTokenFeeDecimalFee charged in the native token
LedgerUpdate_Delta_NonceUInt64Nonce of the originating action
LedgerUpdate_Delta_ToPerpBoolFor account class transfers: true when moving spot to perp, else null
LedgerUpdate_Delta_OperationNullable(String)Operation label for vault and staking deltas, else null
LedgerUpdate_Delta_InterestAmountDecimalInterest component for lending deltas, else null
LedgerUpdate_Delta_VaultStringVault address for vault deltas, else null
LedgerUpdate_Delta_BasisDecimalCost basis for vault withdrawals, else null
LedgerUpdate_Delta_ClosingCostDecimalClosing cost for vault withdrawals, else null
LedgerUpdate_Delta_CommissionDecimalVault leader commission, else null
LedgerUpdate_Delta_NetWithdrawnUsdDecimalNet USD withdrawn from a vault, else null
LedgerUpdate_Delta_RequestedUsdDecimalUSD requested in a vault withdrawal, else null
LedgerUpdate_Delta_IsDepositBoolTrue for deposit-type deltas, else null
LedgerUpdate_Delta_ExtraMapForward-compatibility map; non-empty when the node emitted a field not yet modelled
Sample file
core_writer_actions27 columnsActions written into HyperCore from HyperEVM contracts through the CoreWriter precompile: spot sends, orders, vault and class transfers, staking, with the HyperEVM transaction hash.
ColumnTypeDescription
Block2
Block_NumberUInt64HyperCore block number; the join key across all seven tables
Block_TimeUInt64Block time, epoch nanoseconds
Other4
UserStringSystem address that emitted the action, 0x-prefixed hex
NonceUInt64Action nonce
EvmTxHashStringHyperEVM transaction hash that triggered the action, 0x-prefixed hex
ExtraMapForward-compatibility map; non-empty when the node emitted a field not yet modelled
Action21
Action_TypeStringAction type, for example SystemSpotSendAction, LimitOrderAction, VaultTransferAction
Action_DestinationStringDestination address for send actions, else null
Action_TokenUInt64Token index for send actions, else null
Action_WeiUInt64Amount in wei for send actions, else null
Action_DestinationDexOrSpotNullable(String)Destination dex or spot for transfers, else null
Action_SourceDexOrSpotNullable(String)Source dex or spot for transfers, else null
Action_FromSubAccountStringSub-account the action came from, else null
Action_NtlDecimalNotional for USD class transfers, else null
Action_ToPerpBoolFor class transfers: true when moving to perp, else null
Action_GroupingNullable(String)Order grouping (na, normalTpsl, positionTpsl) for order actions, else null
Action_OrdersArrayOrders placed by an order action, empty otherwise
Action_AgentAddressStringAgent address for approve-agent actions, else null
Action_AgentNameNullable(String)Agent name for approve-agent actions, else null
Action_SignatureChainIdNullable(String)Chain id the action was signed for, else null
Action_HyperliquidChainNullable(String)Mainnet or Testnet, else null
Action_ValidatorStringValidator address for staking actions, else null
Action_IsUndelegateBoolTrue for undelegate actions, else null
Action_ActionNonceUInt64Nonce inside the signed action, else null
Action_BuilderStringBuilder address for approve-builder-fee actions, else null
Action_MaxFeeRateNullable(String)Maximum builder fee rate approved, else null
Action_ExtraMapForward-compatibility map; non-empty when the node emitted a field not yet modelled
Sample file

Ask an AI about this data

Send this dataset’s full schema to an assistant and ask it anything. It reads the plain-text brief first, so the answer comes from the real column list rather than a guess.

Start with

Opens a new chat with the question filled in. Nothing about you is sent to Bitquery, and the assistant sees only the public brief.

Delivery

Parquet files, delivered as signed download links by email after payment, in this layout:

# misc_events — 200 blocks per file
hyperliquid/misc_events<start_block>_<end_block>.parquet

# core_writer_actions — 200 blocks per file
hyperliquid/core_writer_actions<start_block>_<end_block>.parquet
  1. Download a free sampleNo email needed.
  2. Pay nowName, work email and licence check.
  3. Pay the invoiceBy card or bank transfer.
  4. Get signed linksThe team prepares the export and emails the links.

Price

Latest month
Aug 23, 2026 → Sep 23, 2026
$75one-time, USD
  • All 2 tables, 65 columns
  • Parquet files in the layout under Delivery
  • Signed download links by email
  • Licensed under the Data License
Pay now

FAQ

12 questions
What is included in Hyperliquid Ledger and Funding?

Two Parquet tables from HyperCore: misc_events and core_writer_actions, with 65 documented columns. Every row carries Block_Number and Block_Time, so the tables join on block with each other and with the Hyperliquid Trades and Order Book datasets.

How big is it?

Small next to the order book. In a measured 1,000-block slice (about 73 seconds) we counted 32 misc events and 10 CoreWriter actions. Scaled to a day that is roughly 40,000 ledger rows; exact row counts and sizes come with the delivery manifest, and these figures are estimates.

Does it include account balances?

No. It includes every event that changes a balance, so balances can be derived per User and Token by summing LedgerUpdate_Delta_Amount from a starting point. Perp position changes come from fills in the Hyperliquid Trades dataset.

How do I find funding payments?

Filter misc_events on InnerType = Funding. The Funding column holds the payment details for that row; the LedgerUpdate_ columns are null on funding rows.

What is a CoreWriter action?

A HyperEVM smart contract calling into HyperCore: placing an order, sending spot tokens, moving funds to a vault, staking. Each row names the action type, its fields and the EvmTxHash on HyperEVM that caused it, so the two chains can be joined.

How far back does it go?

30 days. HyperCore history is kept as a rolling 30-day window, so a purchase covers the 30 days up to yesterday and there is no longer window to buy. For a continuous feed beyond that, ask about the live stream.

Why are there two time units?

Because the node emits them that way and we keep the values as emitted. Block_Time and the Time column on statuses and events are epoch nanoseconds; Fill.Time and Order.Timestamp are epoch milliseconds. Divide by 1e9 or 1e3 respectively when converting to timestamps.

What does a non-empty Extra column mean?

The node emitted a field that the schema does not model yet, and we kept it rather than dropping it. Extra is empty on nearly every row. When a new field appears it lands there first, so nothing is silently lost between schema versions.

How do I load a file?

With DuckDB: SELECT * FROM read_parquet('fills/*.parquet'). With pandas: pd.read_parquet('fills/'). Parse Px, Sz, Fee and the other money columns with Decimal rather than float; they are stored as decimal strings on purpose.

Does this match the live stream?

Yes. These field definitions are the ones Bitquery's Hyperliquid Kafka topics use, so a backtest reading this archive and a production consumer reading the live stream decode with the same code.

How is the data delivered, and how current is it?

As flat Parquet files under a stable S3 layout, one prefix per table and one file per 200-block range, with a JSON manifest listing every file and its sha256. Signed HTTPS links are emailed once the files are prepared. Refreshed daily with T+1 latency; a purchase made today includes everything up to yesterday.

Can I try before I buy?

Yes. Every table links to a public sample Parquet file from a real 1,000-block slice, and the sample repository on GitHub shows the first records of each table as readable JSON. No email address required.