Transactions

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

Table Columns

Column Name	Description
action	The action triggered by the transaction. There are multiple types of actions. See below.
block_height	The height of the block the transaction belongs to.
error	Error message if the action in the transaction failed.
hash	Transaction hash.
block_timestamp	The timestamp of the block the transaction belongs to.
user	The address of the user that executed the transaction.

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;