Skip to main content
Schema: crosschain.olas Table: ez_olas_staking Type: View

What

This fact-based convenience table contains OLAS token staking events, including deposits (Stake), withdrawals (Unstake), and amount USD where available.

Columns

Column NameData TypeDescription
BLOCKCHAINTEXTBlockchain, Network, or Platform the transaction or event occurs on.
BLOCK_NUMBERNUMBERThe block number at which the transaction is finalized.
BLOCK_TIMESTAMPTIMESTAMP_NTZThe block timestamp of this transaction in UTC
TX_HASHTEXTTransaction hash is a unique 66-character identifier that is generated when a transaction is executed.
ORIGIN_FUNCTION_SIGNATURETEXTThe function signature of this transaction.
ORIGIN_FROM_ADDRESSTEXTThe address that initiates the transaction. If a transaction generates multiple events, all of them will have the same originfromaddress.
ORIGIN_TO_ADDRESSTEXTThe address that receives the transaction. If a transaction generates multiple events, all of them will have the same origintoaddress.
CONTRACT_ADDRESSTEXTThe address of the contract interacted with.
EVENT_INDEXNUMBEREvent number within a transaction.
EVENT_NAMETEXTThe name of the event.
STAKER_ADDRESSTEXTThe address of the staker.
AMOUNT_UNADJNUMBERThe value of the asset, non-decimal adjusted.
AMOUNTFLOATThe value of the asset, decimal adjusted.
AMOUNT_USDFLOATThe value of the asset, denominated in USD where available.
TOKEN_SYMBOLTEXTThe symbol of the token.
TOKEN_ADDRESSTEXTThe address of the token.
PROGRAM_NAMETEXTThe name of the staking program.
EZ_OLAS_STAKING_IDTEXTThe unique identifier for each row in the table.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was inserted into the table.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was last modified.