hyperliquid.raw.misc_events table contains miscellaneous on-chain events including funding, deposits, withdrawals, liquidations, vault events, staking, and delegations.
Table Details
| Property | Value |
|---|---|
| Table Name | hyperliquid.raw.misc_events |
| Table Status | Production-Ready |
| Unique Key | time, hash, unique_id |
| Clustering Key(s) | to_date("time") |
| Search Optimization | hash, unique_id |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| hash | VARCHAR(16777216) | Hash of the event |
| time | TIMESTAMP_NTZ(9) | Timestamp |
| event | VARIANT | Event that happened. |
| _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. |
| unique_id | VARCHAR(16777216) | Unique identifier |
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 |