Skip to main content

Tables

PikaPerp_AddMargin_event

Margin addition events emitted when traders increase collateral on existing perpetual futures positions in Pika Protocol. Contains position identifier, added margin amount, new total margin, and recalculated leverage after the operation.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_positionIdSTRINGUnique identifier for the trading position. String-encoded integer representing the position’s hash or ID in the protocol.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_marginSTRINGMargin amount posted or held for the trading position. String-encoded integer value representing collateral in the smallest unit of the relevant token or currency.
in_newMarginSTRINGTotal margin balance for the position after adding the additional collateral. String-encoded integer value representing the sum of previous and newly added margin in the smallest unit of the relevant token.
in_newLeverageSTRINGUpdated leverage ratio for the position after adding margin. String-encoded integer representing the leverage multiplier with a fixed-point decimal scaling factor.
addressin_userremovedin_marginlog_indexblock_numberin_newMarginin_positionIdin_newLeverageblock_timestamptransaction_hash
0x2fae8c7edd26213ca1a88fc57b65352dbe3536980x9da847cd29d0da97fbfaee0692d336857cf00cd3false4000000000023255352105000000000265892395470147103347901881234297622219085507503735868712217947835288039621884952380952022-02-06T03:00:00.000Z0xb7348a01c619c65dd56f7cf81b7f7289523fcec949b44268a14b3a5db8792f5f
0x2fae8c7edd26213ca1a88fc57b65352dbe3536980xc875c65601a98761c5dd38ae8ca34f718277bf3ffalse200000000000257858149850573330002167664800767545314949623583585870325175999098369874307251738244417341350067523908983972022-04-14T01:28:36.000Z0x5776eb3ff5e442d7781d0b1fb6c116b9d596b3c50bead4da43ba6b24a76104dc
0x2fae8c7edd26213ca1a88fc57b65352dbe3536980x362b425c921999c7b19b780e4152f88fae9d6882false500000000024910083105000000001125601967292786146120818591634745896131606780335981106582368768850384558739254714285712022-03-27T16:29:50.000Z0x31ede0c0cee1150c297e4cf74e349b7290f9df944bac72be91879a491834267d
Query with partition filter
SELECT *
FROM `tt-contracts.pikaprotocol_v2_optimism.PikaPerp_AddMargin_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

PikaPerp_ClosePosition_event

Position closure events from Pika Protocol perpetual futures contracts containing realized PNL (profit and loss), fees, margin, leverage, entry and exit prices, and liquidation status. Used for tracking trading outcomes and settlement calculations in perpetual swap analytics.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_positionIdSTRINGUnique identifier for the trading position. String-encoded integer representing the position’s hash or ID in the protocol.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_productIdSTRINGIdentifier for the financial product or trading pair involved in the transaction. Numeric string representation of the product ID in the protocol’s internal indexing system.
in_priceSTRINGPrice of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
in_entryPriceSTRINGPrice at which the trading position was entered. String-encoded numeric value representing the entry price in the smallest denomination or with extended precision.
in_marginSTRINGMargin amount posted or held for the trading position. String-encoded integer value representing collateral in the smallest unit of the relevant token or currency.
in_leverageSTRINGLeverage multiplier applied to the trading position. String-encoded numeric value representing the multiple of the margin amount used to determine position size.
in_feeSTRINGFee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
in_pnlSTRINGProfit and loss realized from closing the position. String-encoded integer value representing the net gain or loss in the smallest unit of the relevant token or currency, where negative values indicate losses and positive values indicate profits.
in_wasLiquidatedBOOLBoolean flag indicating whether the position was liquidated. True when the position was forcibly closed due to insufficient margin, false when voluntarily closed by the user.
in_feein_pnladdressin_userremovedin_pricein_marginlog_indexin_leverageblock_numberin_productIdin_entryPricein_positionIdblock_timestampin_wasLiquidatedtransaction_hash
10061429-128042010x2fae8c7edd26213ca1a88fc57b65352dbe3536980x4a1866bc7d5614664ebd377d31c24868909b463ffalse6055195450000000001100000000129587192260707416278878243858204099753061019759637412584983117780858492657642027331845659805762022-06-24T20:18:43.000Zfalse0x76018f71e1306b5d5151fc036aea36508905653ff009ca8f24c689ea5c0d4e23
186880664162950441320x2fae8c7edd26213ca1a88fc57b65352dbe3536980x9a4773eeee73e34e1ee0e9a64e4b7453b0b04246false60595061111000000001720000000128838992250332641171865686438679647403418950142440295397578228301951430151924601055109433252262022-06-24T05:54:22.000Zfalse0x2ddec924aff04b5e7ef721f6d4c3e8dc677657bd974589a3112b6fca6bcb401a
169847290-8287246610x2fae8c7edd26213ca1a88fc57b65352dbe3536980xb3dd225131d1ea7a2abd98279a7077ced9595911false5475409531682733304015000000001297296826552987741980269401462234105018061029116000700446903287711159480822517169357088660910292022-06-24T23:55:36.000Zfalse0xa49b3452c63ec747507338d99cb8e0b3decef154c481be5d588c9b0fe3fa590e
Query with partition filter
SELECT *
FROM `tt-contracts.pikaprotocol_v2_optimism.PikaPerp_ClosePosition_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

PikaPerp_NewPosition_event

Perpetual futures position opening events from Pika Protocol containing user address, product identifier, margin amount, leverage multiplier, execution price, and fee charged. Records both long and short positions with oracle price reference and funding rate tracking for derivatives position lifecycle analysis.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_positionIdSTRINGUnique identifier for the trading position. String-encoded integer representing the position’s hash or ID in the protocol.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_productIdSTRINGIdentifier for the financial product or trading pair involved in the transaction. Numeric string representation of the product ID in the protocol’s internal indexing system.
in_isLongBOOLBoolean flag indicating whether the position is long or short. True represents a long position (betting on price increase), false represents a short position (betting on price decrease).
in_priceSTRINGPrice of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
in_oraclePriceSTRINGOracle price of the asset at the time of position creation. String-encoded integer value representing the price feed data used for settlement and liquidation calculations.
in_marginSTRINGMargin amount posted or held for the trading position. String-encoded integer value representing collateral in the smallest unit of the relevant token or currency.
in_leverageSTRINGLeverage multiplier applied to the trading position. String-encoded numeric value representing the multiple of the margin amount used to determine position size.
in_feeSTRINGFee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
in_feeaddressin_userremovedin_pricein_isLongin_marginlog_indexin_leverageblock_numberin_productIdin_positionIdin_oraclePriceblock_timestamptransaction_hash
593924380x2fae8c7edd26213ca1a88fc57b65352dbe3536980x4d9daffb02a454eacc27858923cb55250e9111dffalse1638472962true593924381102100000000538928631533116701111333796566609182100329081621053130998063085191883520585229098158416383334912022-04-06T04:15:41.000Z0x4593c7f056009cf5bd14b0ce8da137a849258535962a44bd404a4a2612988d09
50000000x2fae8c7edd26213ca1a88fc57b65352dbe3536980xae780a263184ba59c8524fe59b73b03e2296acbafalse323207843006false5000000000210000000054395961530652728986021911898268067545211420250933483440920535114814890911992030026753231720000002022-04-06T20:04:25.000Z0x77f60da53d317462a130795a6cc60dcb377fd2f6a23a9f9f23d6a820d108a452
51506440x2fae8c7edd26213ca1a88fc57b65352dbe3536980x98ec3de89799be76552f8873907028c01a0eccf0false324351753824true51506442002100000000542489111097828414429907595958702260469269057486787660984082452583342026073071616727783243015324892022-04-06T16:18:28.000Z0x5974777871961be100cd5bbdea8cc9aa89ff22ba16e1c8821172ff42b74a7f2b
Query with partition filter
SELECT *
FROM `tt-contracts.pikaprotocol_v2_optimism.PikaPerp_NewPosition_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

PikaPerp_PositionLiquidated_event

Perpetual position liquidation events from Pika Protocol containing position identifiers, liquidator addresses, and reward distribution amounts. Used for tracking forced position closures and liquidator profitability on Optimism.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_positionIdSTRINGUnique identifier for the trading position. String-encoded integer representing the position’s hash or ID in the protocol.
in_liquidatorSTRINGAddress of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
in_liquidatorRewardSTRINGReward amount paid to the liquidator for executing the liquidation. String-encoded integer representing the token amount in smallest denomination.
in_remainingRewardSTRINGReward amount remaining after liquidator compensation in a position liquidation. String-encoded integer representing the token amount in smallest denomination.
addressremovedlog_indexblock_numberin_liquidatorin_positionIdblock_timestamptransaction_hashin_remainingRewardin_liquidatorReward
0x2fae8c7edd26213ca1a88fc57b65352dbe353698false143071500x0ee1bea664f0e888a54adab65c4a507e1e6e55f2248897523434643886071431958628795683764953511152953311024551161845026012079232022-03-10T05:09:10.000Z0xf69bf6edf05e279348e6ff7efd2a5321adc7f63343d6d169559f88a3fb67d24615557710141555771013
0x2fae8c7edd26213ca1a88fc57b65352dbe353698false143198660x0ee1bea664f0e888a54adab65c4a507e1e6e55f2360667937927200102707590049528625279080140329963058587711821639536696806260912022-03-10T13:33:48.000Z0x58e16e9bf6be156c48fe1f6b84321547b8493b22858733dad5703b9f1fcda1be440807545440807545
0x2fae8c7edd26213ca1a88fc57b65352dbe353698false143037290x0ee1bea664f0e888a54adab65c4a507e1e6e55f2712417341527475441315935850059320123560416829612085991305807073291745007772442022-03-10T03:30:22.000Z0x6ba1351b0a372e4f4eebff463c33b81690044e12c501f5fe7f68a5127d2a086e00
Query with partition filter
SELECT *
FROM `tt-contracts.pikaprotocol_v2_optimism.PikaPerp_PositionLiquidated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

PikaPerp_Redeemed_event

Liquidity provider share redemption events from Pika Protocol perpetual contracts. Records user withdrawals from vault pools including shares burned, amount received, and remaining share balance for tracking LP position changes.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_sharesSTRINGNumber of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.
in_shareBalanceSTRINGUser’s total share balance before the redemption transaction. Numeric string representation of share quantity in the protocol’s accounting system.
in_isFullRedeemBOOLBoolean flag indicating whether the user is redeeming their entire share balance. True when the redemption amount equals the user’s total shares.
addressin_userremovedin_amountin_shareslog_indexblock_numberblock_timestampin_isFullRedeemin_shareBalancetransaction_hash
0x2fae8c7edd26213ca1a88fc57b65352dbe3536980x49ba5b7eb69601723c0879064de9bbdddc572949false109996638118571165141090565842023-09-03T03:32:25.000Zfalse769699990x2bbdd34e1e30eac073cc34f59f10f58991b0c7576a8aae686b291ebc736d8c78
0x2fae8c7edd26213ca1a88fc57b65352dbe3536980x89b7cfb32e2056c90ba1792af5e2401ba11caab1false109996782118571165401090600372023-09-03T05:27:31.000Zfalse769699990xb1c6b4e9209452fcbc74b11e877d12f92c8de095ff5cff8b9b1ac4aa9104eb49
0x2fae8c7edd26213ca1a88fc57b65352dbe3536980xf5459c27440efc83c917bd3d635919cab49b6490false109997157118571165421090517332023-09-03T00:50:43.000Zfalse769699990x0a92ac915fa278ff27035c41b995c20fe77f2baf620b2dbd4c781e8114ba1812
Query with partition filter
SELECT *
FROM `tt-contracts.pikaprotocol_v2_optimism.PikaPerp_Redeemed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

PikaPerp_Staked_event

Staking deposit events from Pika Protocol v2 perpetual futures platform on Optimism, recording token amounts staked and corresponding share allocations for user positions. Useful for analyzing vault participation, deposit flows, and share-to-token conversion rates over time.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_sharesSTRINGNumber of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.
addressin_userremovedin_amountin_shareslog_indexblock_numberblock_timestamptransaction_hash
0x2fae8c7edd26213ca1a88fc57b65352dbe3536980x0c6d190b146030c00bf654f1179cf8222d0db560false1010000000010570404452236816322022-02-19T12:39:58.000Z0x03fdbef1f68192dee410f2279ada9dfd3c7c204f3017f5674b19ff594b9b9e56
0x2fae8c7edd26213ca1a88fc57b65352dbe3536980xd491447348c474af15c40839d3e0056a80fec352false2000000000020940799750236871222022-02-19T19:58:18.000Z0xbe9d95ee6670f9c036d5d97d7c17e603f3ca99735271a9ddef58371998151412
0x2fae8c7edd26213ca1a88fc57b65352dbe3536980x47a127bc1004baf6c2f5b0ea275ecd4a5347d236false99900000104552812236815832022-02-19T12:34:38.000Z0x49791ceaf11dc15453560d983c286841ca61599f47a6b16f24d98da5e2b247f0
Query with partition filter
SELECT *
FROM `tt-contracts.pikaprotocol_v2_optimism.PikaPerp_Staked_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100