Transactions

Hyperliquid Hypercore L1 transactions.

Property	Value
Table Name	`hyperliquid.raw.transactions`
Table Status	Production-Ready
Unique Key	`block_timestamp`, `hash`
Clustering Key(s)	`to_date("block_timestamp")`
Search Optimization	`block_height`, `hash`, `user`

The hyperliquid.raw.transactions table contains transaction data for each block on Hyperliquid.

Column Name	Data Type	Description
action	VARIANT	The action triggered by the transaction. There are multiple types of actions. See below.
block_height	NUMBER(38,0)	The height of the block the transaction belongs to.
error	VARCHAR(16777216)	Error message if the action in the transaction failed.
hash	VARCHAR(16777216)	Transaction hash.
block_timestamp	TIMESTAMP_NTZ(9)	The timestamp of the block the transaction belongs to.
user	VARCHAR(16777216)	The address of the user that executed the transaction.
_created_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was created in the database.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was last updated in the database.
tx_index	NUMBER(38,0)	Zero-based position of the transaction within its block. The first transaction in a block has index 0.

Action Types

The action column is a semi-structured field. The type of action can be extracted using action:type. The following types are currently supported:

Type
`CSignerAction`
`CValidatorAction`
`NetChildVaultPositionsAction`
`PerpDexClassTransfer`
`PerpDexTransfer`
`SetGlobalAction`
`SignValidatorSetUpdateAction`
`SystemAlignedQuoteSupplyDeltaAction`
`SystemApproveBuilderFeeAction`
`SystemBoleAction`
`SystemSendAssetAction`
`SystemSpotSendAction`
`SystemUsdClassTransferAction`
`ValidatorSignWithdrawalAction`
`VoteEthDepositAction`
`VoteEthFinalizedValidatorSetUpdateAction`
`VoteEthFinalizedWithdrawalAction`
`VoteGlobalAction`
`agentEnableDexAbstraction`
`agentSetAbstraction`
`approveAgent`
`approveBuilderFee`
`batchModify`
`borrowLend`
`cDeposit`
`cWithdraw`
`cancel`
`cancelByCloid`
`claimRewards`
`convertToMultiSigUser`
`createSubAccount`
`createVault`
`evmRawTx`
`evmUserModify`
`finalizeEvmContract`
`linkStakingUser`
`liquidate`
`modify`
`noop`
`order`
`perpDeploy`
`registerReferrer`
`reserveRequestWeight`
`scheduleCancel`
`sendAsset`
`sendToEvmWithData`
`setDisplayName`
`setReferrer`
`spotDeploy`
`spotSend`
`spotUser`
`subAccountModify`
`subAccountSpotTransfer`
`subAccountTransfer`
`tokenDelegate`
`topUpIsolatedOnlyMargin`
`twapCancel`
`twapOrder`
`updateIsolatedMargin`
`updateLeverage`
`usdClassTransfer`
`usdSend`
`userDexAbstraction`
`userPortfolioMargin`
`userSetAbstraction`
`validatorL1Stream`
`validatorL1Vote`
`vaultDistribute`
`vaultModify`
`vaultTransfer`
`voteAppHash`
`withdraw3`

More types might be added over time. To get the full list of supported types, run:

SELECT DISTINCT type
FROM (SELECT action:type AS type FROM hyperliquid.raw.transactions)
ORDER BY type ASC;