Skip to main content

Documentation Index

Fetch the complete documentation index at: https://goldrush.dev/docs/llms.txt

Use this file to discover all available pages before exploring further.

HyperCore normalizers process trading and protocol event data from the HyperCore chain into structured tables. The miscevents normalizer routes events to one of 6 tables based on the event type.

FillsNormalizer

Entity: fills | Table: hl_fills Each fill represents one side of a matched order.
ColumnTypeDescription
block_numberUINT64Block number
block_timeSTRINGBlock timestamp
streamSTRINGStream identifier
user_addressSTRINGUser address
coinSTRINGTrading pair
pxSTRINGPrice
szSTRINGSize
sideSTRINGBuy/Sell
timeSTRINGFill time
start_positionSTRINGStarting position
dirSTRINGDirection
closed_pnlSTRINGClosed PnL
hashSTRINGFill hash
oidUINT64Order ID
crossedBOOLEANWhether fill crossed spread
feeSTRINGTrading fee
tidUINT64Trade ID
fee_tokenSTRINGFee token
builder_feeSTRINGBuilder fee (optional)
cloidSTRINGClient order ID (optional)
twap_idUINT64TWAP ID (optional)
builderSTRINGBuilder address (optional)
liquidation_userSTRINGLiquidated user
liquidation_mark_pxSTRINGMark price at liquidation
liquidation_methodSTRINGLiquidation method
Liquidation fields are null when no liquidation occurred.

TradesNormalizer

Entity: trades | Table: hl_trades Each trade represents a matched market event with both buyer and seller details.
ColumnTypeDescription
block_numberUINT64Block number
block_timeSTRINGBlock timestamp
streamSTRINGStream identifier
coinSTRINGTrading pair
pxSTRINGTrade price
szSTRINGTrade size
sideSTRINGAggressor side
timeSTRINGTrade time
tidUINT64Trade ID
hashSTRINGTrade hash
usersJSONArray of user addresses
buyer_jsonJSONBuyer fill details (JSON)
seller_jsonJSONSeller fill details (JSON)

OrdersNormalizer

Entity: orders | Table: hl_orders Order lifecycle events including placements, cancellations, and fills.
ColumnTypeDescription
block_numberUINT64Block number
block_timeSTRINGBlock timestamp
streamSTRINGStream identifier
builderSTRINGBuilder address (optional)
hashSTRINGOrder event hash (optional)
timeSTRINGOrder time
userSTRINGUser address
statusSTRINGOrder status
coinSTRINGTrading pair
sideSTRINGBuy/Sell
oidUINT64Order ID
limit_pxSTRINGLimit price
szSTRINGOrder size
orig_szSTRINGOriginal order size
timestampINT64Order timestamp
order_typeSTRINGOrder type
tifSTRINGTime in force
reduce_onlyBOOLEANReduce-only flag
is_triggerBOOLEANTrigger order flag
is_position_tpslBOOLEANPosition TP/SL flag
trigger_conditionSTRINGTrigger condition
trigger_pxSTRINGTrigger price
cloidSTRINGClient order ID (optional)
children_jsonJSONChild orders (JSON array)

MiscEventsNormalizer

Entity: miscevents | Tables: 6 tables The MiscEvents normalizer routes each event to the appropriate table based on its type:
Event TypeOutput Table
Deposithl_deposits
Withdrawalhl_withdrawals
Delegationhl_delegations
Validator Rewardshl_validator_rewards
Fundinghl_funding
Ledger Updatehl_ledger_updates

hl_deposits

ColumnTypeDescription
block_numberUINT64Block number
block_timeSTRINGBlock timestamp
hashSTRINGEvent hash
userSTRINGDepositor address
amountSTRINGDeposit amount

hl_withdrawals

ColumnTypeDescription
block_numberUINT64Block number
block_timeSTRINGBlock timestamp
hashSTRINGEvent hash
userSTRINGWithdrawer address
amountSTRINGWithdrawal amount
is_finalizedBOOLEANWhether withdrawal is finalized

hl_delegations

ColumnTypeDescription
block_numberUINT64Block number
block_timeSTRINGBlock timestamp
hashSTRINGEvent hash
userSTRINGDelegator address
validatorSTRINGValidator address
amountSTRINGDelegation amount
is_undelegateBOOLEANWhether this is an undelegation

hl_validator_rewards

ColumnTypeDescription
block_numberUINT64Block number
block_timeSTRINGBlock timestamp
hashSTRINGEvent hash
validatorSTRINGValidator address
rewardSTRINGReward amount

hl_funding

ColumnTypeDescription
block_numberUINT64Block number
block_timeSTRINGBlock timestamp
hashSTRINGEvent hash
coinSTRINGFunding coin
sziSTRINGSize
funding_rateSTRINGFunding rate
funding_amountSTRINGFunding amount
userSTRINGTrader address

hl_ledger_updates

ColumnTypeDescription
block_numberUINT64Block number
block_timeSTRINGBlock timestamp
hashSTRINGEvent hash
usersJSONArray of user addresses
delta_typeSTRINGLedger delta variant name
delta_jsonJSONSerialized ledger delta details
The delta_type field identifies the ledger operation. Supported types include: Withdraw, Deposit, VaultCreate, VaultDeposit, VaultWithdraw, VaultDistribution, VaultLeaderCommission, Liquidation, InternalTransfer, SubAccountTransfer, SpotTransfer, SpotGenesis, RewardsClaim, AccountActivationGas, AccountClassTransfer, PerpDexClassTransfer, DeployGasAuction, Send, CStakingTransfer, and BorrowLend.