hyperliquid.raw.misc_events table contains miscellaneous on-chain events including funding, deposits, withdrawals, liquidations, vault events, staking, and delegations.
Table Columns
| Column Name | Description |
|---|---|
| time | Timestamp |
| hash | Hash of the event |
| unique_id | Unique identifier |
| event | Event that happened. |
Event Types
| Type | Description | Where Clause |
|---|---|---|
| accountActivationGas | event:LedgerUpdate:delta:type = ‘accountActivationGas’ | |
| accountClassTransfer | event:LedgerUpdate:delta:type = ‘accountClassTransfer’ | |
| deployGasAuction | event:LedgerUpdate:delta:type = ‘deployGasAuction’ | |
| deposit | event:LedgerUpdate:delta:type = ‘deposit’ | |
| internalTransfer | event:LedgerUpdate:delta:type = ‘internalTransfer’ | |
| liquidation | event:LedgerUpdate:delta:type = ‘liquidation’ | |
| rewardsClaim | event:LedgerUpdate:delta:type = ‘rewardsClaim’ | |
| spotGenesis | event:LedgerUpdate:delta:type = ‘spotGenesis’ | |
| spotTransfer | event:LedgerUpdate:delta:type = ‘spotTransfer’ | |
| subAccountTransfer | event:LedgerUpdate:delta:type = ‘subAccountTransfer’ | |
| vaultCreate | event:LedgerUpdate:delta:type = ‘vaultCreate’ | |
| vaultDeposit | event:LedgerUpdate:delta:type = ‘vaultDeposit’ | |
| vaultDistribution | event:LedgerUpdate:delta:type = ‘vaultDistribution’ | |
| vaultLeaderCommission | event:LedgerUpdate:delta:type = ‘vaultLeaderCommission’ | |
| vaultWithdraw | event:LedgerUpdate:delta:type = ‘vaultWithdraw’ | |
| withdraw | event:LedgerUpdate:delta:type = ‘withdraw’ | |
| CDeposit | Staking Deposit | event:CDeposit IS NOT NULL |
| CWithdrawal | Staking Withdrawal | event:CWithdrawal IS NOT NULL |
| Delegation | event:Delegation IS NOT NULL | |
| Funding | Funding fee | event:Funding IS NOT NULL |
| ValidatorRewards | event:ValidatorRewards IS NOT NULL |