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_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
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_marginin_senderlog_indexblock_numberin_newMarginin_positionIdin_newLeverageblock_timestamptransaction_hash
0xd5a8f233cbddb40368d55c3320644fb36e5970020x8989bae372d82a8b53a62242caaa480b5d9a74fffalse30000000000x8989bae372d82a8b53a62242caaa480b5d9a74ff29361157960000000004499218228246267458067089947430084057394993149503190047276206262985623793928225000000002023-04-23T18:23:47.000Z0x0be485ecd26e7750bcc3f39ddf5db1891905d713f7d36c425c63461b9d9936c6
0xd5a8f233cbddb40368d55c3320644fb36e5970020xd4bad50a638cf475318cb43cc43d5f679ff760b8false102000000000xd4bad50a638cf475318cb43cc43d5f679ff760b8293490337407000000007889339055578788313424811154550380510841390974966081059950692046892017286755113240786232023-04-23T10:00:08.000Z0xa921c906637d9a7ae4e024aea8df19ffd5515e01f9ce1e3698178cf5141431e2
0xd5a8f233cbddb40368d55c3320644fb36e5970020xd4bad50a638cf475318cb43cc43d5f679ff760b8false135000000000xd4bad50a638cf475318cb43cc43d5f679ff760b8293485720305000000007889339055578788313424811154550380510841390974966081059950692046892017286755117668852452023-04-23T09:43:21.000Z0x3f8e47ba4512512c41155141e07feadd64963e161c6aa34567242562b792b360
Query with partition filter
SELECT *
FROM `tt-contracts.pikaprotocol_v3_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_fundingPaymentSTRINGFunding payment amount charged or credited to the position holder. String-encoded integer value representing the periodic fee in the smallest unit of the relevant token or currency, where negative values indicate payments owed by the trader and positive values indicate payments received.
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_hashin_fundingPayment
0-67000000000xd5a8f233cbddb40368d55c3320644fb36e5970020xcb797518917d54718fc93c349ca4b7ad1e6ee50bfalse1651800000006700000000311000000000072394154116664232356141685058247450232868308198346195004598765573239217766565218594310291917887772023-02-05T12:51:32.000Ztrue0x3f8cdc27c57602b2a0d42fd4cffba38e6b84975b47790db718ab812faa5028b1-21130935
0-4000000000xd5a8f233cbddb40368d55c3320644fb36e5970020x74725834fafd09e55e8f5b2e6685f376b7d5ccf1false161635000000400000000298300000000724438791163589342954892476406202350051394062970292036950331276739270809694942408468682886656872232023-02-05T17:51:05.000Ztrue0x3a8ef45a15f53be4c580a2da1b673e3ae6287d04e4210886ab274d9249adb195-17569137
0-75000000000xd5a8f233cbddb40368d55c3320644fb36e5970020x312cb3a46aa7d9fdd2a81e334e0785546768fc20false163636000000750000000026100000000007247252911621658465241150147639045965167834938747780379137941608584672012939978772110836656394695392023-02-05T22:36:03.000Ztrue0x965e895f35ca8ad9730504e0d6ae66a93afbc7ab0ee6b48ec6f2e0262bc467628717859
Query with partition filter
SELECT *
FROM `tt-contracts.pikaprotocol_v3_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_isNextPriceBOOLIndicates whether the position was executed at the next available oracle price rather than immediately. Typically true when orders are queued for execution at the next price update.
in_fundingSTRINGFunding fee amount applied to the position. String-encoded signed integer value representing the funding payment in the smallest unit of the relevant token or currency.
in_feeaddressin_userremovedin_pricein_isLongin_marginlog_indexin_fundingin_leverageblock_numberin_productIdin_positionIdin_isNextPricein_oraclePriceblock_timestamptransaction_hash
5000000000xd5a8f233cbddb40368d55c3320644fb36e5970020x2c3b311362ed28de8a7b06befac850db320fd27afalse57770371false1000000000030-12110379665000000000805040172543742188348833418940159580775273738494170048441449675133645576735409163695385true577800002023-03-13T09:27:50.000Z0xa9139fabb39eadc05506ec83cb641242aca9373118c881639a1e99c4ed5149d9
200000000xd5a8f233cbddb40368d55c3320644fb36e5970020xb3dd225131d1ea7a2abd98279a7077ced9595911false191198728false20000000000309866897173100000000805102891527044174423137231679451069939649495661365126095526351993779030383915882075240true1912000002023-03-13T09:52:54.000Z0x635a78e207931620ffdf6358c027fd87161350281ad936e8802de8090bb8f23c
1519020000xd5a8f233cbddb40368d55c3320644fb36e5970020x009a58233c67a9bc54dd687cb6798e07ef25e5d4false160243302716false18987750000301333044735680000000080470382148225429928853800206041241882994939661795828500141253366790488378755294389695true1602415000002023-03-13T06:05:56.000Z0x6d7a6ab9dc3227f133707d3fb9075462d620eb2615b2b370b1e78c381fd3c9e4
Query with partition filter
SELECT *
FROM `tt-contracts.pikaprotocol_v3_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
0xd5a8f233cbddb40368d55c3320644fb36e597002false391064026990xcb2d8d262f88fe43941295fd57a4617c191466ea658929499757292362717356208538793581979117037274030115521116072849391489845622023-07-03T17:09:35.000Z0x19fe0ac1072c6e068b59f495dfa5c72720c11523809f51f290b873245fa50497343528931343528930
0xd5a8f233cbddb40368d55c3320644fb36e597002false751063999930xcb2d8d262f88fe43941295fd57a4617c191466ea228986662915041709818527254912695312006085648363589176673672433491703014267522023-07-03T15:39:23.000Z0xaeaadcff63e6632652e67146da6ddd1f5ee54316580e54105a2c6103c6facd1135966629143596662914
0xd5a8f233cbddb40368d55c3320644fb36e597002false1051063889110xcb2d8d262f88fe43941295fd57a4617c191466ea844208913001765282773214109261986829660811513228632247022116584660909852584142023-07-03T09:29:59.000Z0x89cb65c35139347d2420b125aa8ae95199d7ee63330526f1369e76ef42f1fbea339913410339913409
Query with partition filter
SELECT *
FROM `tt-contracts.pikaprotocol_v3_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_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. 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_indexin_receiverblock_numberblock_timestampin_isFullRedeemin_shareBalancetransaction_hash
0xd5a8f233cbddb40368d55c3320644fb36e5970020x4d752ffb53417c10ae1116f94a9fe36b128272f1false8061771210x4d752ffb53417c10ae1116f94a9fe36b128272f1777005912023-02-28T07:33:56.000Ztrue82170xb901aa94454caab353fbda9357d8948e26161c7acc8aadf683451ed4fec0a2be
0xd5a8f233cbddb40368d55c3320644fb36e5970020xef61664dd62abf1cde1bca555fe3e0367b3db701false292972809010xef61664dd62abf1cde1bca555fe3e0367b3db701776990472023-02-28T07:20:31.000Ztrue299300x9f303ce91c9ce5a4e374f72485dcb0b64b7ec9cf7493c7bb4701bdb70cceea92
0xd5a8f233cbddb40368d55c3320644fb36e5970020x0b3773f53e13bf84c41f83a8d06bdf86cc6a5561false416403982710x0b3773f53e13bf84c41f83a8d06bdf86cc6a5561777001482023-02-28T07:30:09.000Ztrue424370xfac137bbdf81011addbebbedee4b6cda7aaeef827f00b817be82672f82eaabb7
Query with partition filter
SELECT *
FROM `tt-contracts.pikaprotocol_v3_optimism.PikaPerp_Redeemed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

PikaPerp_Staked_event

Staking events from Pika Protocol V3 perpetual futures platform on Optimism, recording user deposits with token amounts and vault share allocations. Used for tracking liquidity provision, share-to-token exchange rates, and staker participation 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
0xd5a8f233cbddb40368d55c3320644fb36e5970020xb4a957fedc75650d027a83ed992fac013c52dce7false4000000000003726288386422800784562023-03-11T12:17:06.000Z0xebde16958e91ae11372a80048d7f76f17ef19dcd994bfc1b46eaa8962e314593
0xd5a8f233cbddb40368d55c3320644fb36e5970020x8d85114de0e28d55ccc33162b265a2dcdffa3cc8false219800000020481499652801554972023-03-11T21:29:34.000Z0xac076c1916a3748b4be9b22957963c0470fc1d6e079f574f6652279659d55d80
0xd5a8f233cbddb40368d55c3320644fb36e5970020xba4d0a7c4bc1a42809998a630fa8da64bf88c010false1172290000001094864312602800261452023-03-11T07:28:30.000Z0x6e23d6b4838226a9eed6b06a36d273ad890eb946733d36eca9f018a0aa3b7337
Query with partition filter
SELECT *
FROM `tt-contracts.pikaprotocol_v3_optimism.PikaPerp_Staked_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

VaultTokenReward_RewardPaid_event

Reward distribution events from Pika Protocol v3 vault staking on Optimism, recording token rewards paid to liquidity providers. Used to track vault yield distributions and calculate individual staker earnings 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_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
addressin_userremovedin_rewardlog_indexblock_numberblock_timestamptransaction_hash
0x78136ef4bdcbdabb8d7aa09a33c3c16ca63819100x9874f9b05b073771c7b98e192543fa2684e61246false10684321592008491405111064513762023-07-04T20:12:09.000Z0xf6a3c6bfcbc51b47ed991eed9cbec36788c2630bfa76ddb4d9cef31f3e54beb1
0x78136ef4bdcbdabb8d7aa09a33c3c16ca63819100xda7fc7825eba671c937d4ec6517f66248caa8ef2false1596335407248892513511064305992023-07-04T08:39:35.000Z0xfd554245c2de5155e2e81ae834b1c08e8e78b885e06fe6059619c7524cd14bc9
0x78136ef4bdcbdabb8d7aa09a33c3c16ca63819100x95eb62e50c20733342f9d4424a717d3a2d33d7e5false55607808353661708721064396772023-07-04T13:42:11.000Z0x873f37da47356fbcfe4015b48b834d8d381ea8151ecff49f5f8cb83375c9f871
Query with partition filter
SELECT *
FROM `tt-contracts.pikaprotocol_v3_optimism.VaultTokenReward_RewardPaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100