pika_v3_optimism

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_positionId`	`STRING`	Unique identifier for the trading position. String-encoded integer representing the position’s hash or ID in the protocol.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_margin`	`STRING`	Margin 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_newMargin`	`STRING`	Total 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_newLeverage`	`STRING`	Updated leverage ratio for the position after adding margin. String-encoded integer representing the leverage multiplier with a fixed-point decimal scaling factor.

Sample Data

address	in_user	removed	in_margin	in_sender	log_index	block_number	in_newMargin	in_positionId	in_newLeverage	block_timestamp	transaction_hash
0xd5a8f233cbddb40368d55c3320644fb36e597002	0x6613a1521394c2f17c7d705e48279e44c2a01936	false	3000000000	0x6613a1521394c2f17c7d705e48279e44c2a01936	2	74084251	11859375000	5365907784844251939113453154369341254976602219759283811800978268817175209919	1473438734	2023-02-13T12:26:04.000Z	0x3e658bb218a46fe93c8d74961f1b6ea5a1742c35ecbd43ec62ede7520c991d11
0xd5a8f233cbddb40368d55c3320644fb36e597002	0x191ac84067db87283a1864e1c606e9d51c32f511	false	3000000000	0x191ac84067db87283a1864e1c606e9d51c32f511	2	73973418	12000000000	72032980250318584447080636919461482676546778735193757204647654273137511510396	3750000000	2023-02-13T01:53:15.000Z	0xf71c2950abbc81e6c554f60bc67f73e79c336d5704bcc845ba5b7a37da2ebc80
0xd5a8f233cbddb40368d55c3320644fb36e597002	0xa8293dd8eb52564a35b8357a539146321b934153	false	3000000000	0xa8293dd8eb52564a35b8357a539146321b934153	2	74084913	6100000000	106987411348676418474712596689096712574591121648703597217494063595516071077979	442131147	2023-02-13T12:30:04.000Z	0xccfcc4564a9a1159fcd838b165121dd6ca7b1ee82585db8627a0a8157797094e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pika_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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_positionId`	`STRING`	Unique identifier for the trading position. String-encoded integer representing the position’s hash or ID in the protocol.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_productId`	`STRING`	Identifier 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_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_entryPrice`	`STRING`	Price at which the trading position was entered. String-encoded numeric value representing the entry price in the smallest denomination or with extended precision.
`in_margin`	`STRING`	Margin 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_leverage`	`STRING`	Leverage multiplier applied to the trading position. String-encoded numeric value representing the multiple of the margin amount used to determine position size.
`in_fee`	`STRING`	Fee 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_pnl`	`STRING`	Profit 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_fundingPayment`	`STRING`	Funding 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_wasLiquidated`	`BOOL`	Boolean 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.

Sample Data

in_fee	in_pnl	address	in_user	removed	in_price	in_margin	log_index	in_leverage	block_number	in_productId	in_entryPrice	in_positionId	block_timestamp	in_wasLiquidated	transaction_hash	in_fundingPayment
260000000	3305749095	0xd5a8f233cbddb40368d55c3320644fb36e597002	0xb9598225c6d4e63573e08e59ba4d048d30bbd07d	false	9329775	13000000000	28	2000000000	91930490	13	9211123	11914860297183332843888675882586659977012237281504385720123250198243889502635	2023-04-18T13:32:28.000Z	false	0x18cae1b86b9a89381c38677709fd312239c9781d9f268651a988df6ae789907d	43410394
190000000	1200931332	0xd5a8f233cbddb40368d55c3320644fb36e597002	0xb3f876c9972339a1405346b1a8a27204f0bc154a	false	9393993	10000000000	28	1900000000	91913096	13	9334816	95379502943539778386778708212252603526930422016809600715378708057790300882871	2023-04-18T12:33:27.000Z	false	0xcd1a8adee7d0479f18318ef4928c6e2aaafa20d1c5cd81f0224a217818f57340	3551970
100000000	3673956874	0xd5a8f233cbddb40368d55c3320644fb36e597002	0x964e785e3314b943f1990a9d6f864f828ee9b40a	false	9445776	4000000000	28	2500000000	91912368	13	9110215	23678876497327274762729616005796655321958738326119709075575836063105685751153	2023-04-18T12:30:27.000Z	false	0xfc5d7e1e5b6fc15f7de2b0c5711d6d8057ce76cf850d88ec74938ff7610a71df	9391982

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pika_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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_positionId`	`STRING`	Unique identifier for the trading position. String-encoded integer representing the position’s hash or ID in the protocol.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_productId`	`STRING`	Identifier 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_isLong`	`BOOL`	Boolean 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_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_oraclePrice`	`STRING`	Oracle 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_margin`	`STRING`	Margin 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_leverage`	`STRING`	Leverage multiplier applied to the trading position. String-encoded numeric value representing the multiple of the margin amount used to determine position size.
`in_fee`	`STRING`	Fee 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_isNextPrice`	`BOOL`	Indicates whether the position was executed at the next oracle price or immediately at market price. True means the order was queued for execution at the subsequent price update.
`in_funding`	`STRING`	Funding 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.

Sample Data

in_fee	address	in_user	removed	in_price	in_isLong	in_margin	log_index	in_funding	in_leverage	block_number	in_productId	in_positionId	in_isNextPrice	in_oraclePrice	block_timestamp	transaction_hash
300000000	0xd5a8f233cbddb40368d55c3320644fb36e597002	0x1abfa3d823f9f8d85af33622046d3b7f66262670	false	152463658562	false	3000000000	30	12563556761	10000000000	69057929	1	93456822264389785860062862177833765713415396324438671320409898990227844920	true	152463500000	2023-01-19T02:40:05.000Z	0x509b600d1e4104258f44f989030466a9c83738ffa92489660cd28ead5484dc3c
4999999	0xd5a8f233cbddb40368d55c3320644fb36e597002	0x13ae8169f922ab50068135c8066a5cb59bce3588	false	152901704888	true	3846153846	30	12566341034	130000000	69086449	1	883885969673567857508638322559039080424547695117071627055567623995853808582	true	152901500000	2023-01-19T07:45:39.000Z	0xd09e4badcfcaba67b0c3e4a399702a6737bb0e5a76f327cc7a54c5d9ce2ce7dd
45858599	0xd5a8f233cbddb40368d55c3320644fb36e597002	0x780173aa6c72d7b069f3a5edf9be3313228ccd42	false	152843509170	false	4131405405	30	12566326743	1110000000	69085323	1	2203496107010950801492027090921360285920682689543078609650860403469068030088	true	152843500000	2023-01-19T07:36:32.000Z	0x091aa315107b5e5ebc1f33cfe8282b38e4bee64aa4e7d1ab0697458a3d7d8319

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pika_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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_positionId`	`STRING`	Unique identifier for the trading position. String-encoded integer representing the position’s hash or ID in the protocol.
`in_liquidator`	`STRING`	Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_liquidatorReward`	`STRING`	Reward amount paid to the liquidator for executing the liquidation. String-encoded integer representing the token amount in smallest denomination.
`in_remainingReward`	`STRING`	Reward amount remaining after liquidator compensation in a position liquidation. String-encoded integer representing the token amount in smallest denomination.

Sample Data

address	removed	log_index	block_number	in_liquidator	in_positionId	block_timestamp	transaction_hash	in_remainingReward	in_liquidatorReward
0xd5a8f233cbddb40368d55c3320644fb36e597002	false	120	106307234	0xcb2d8d262f88fe43941295fd57a4617c191466ea	33791885672716873158801220211950707575400084113549677117180279127468191398358	2023-07-01T12:07:25.000Z	0x6467563539114b32ea75cacd7ad5503a3a1a37293f02a3ad3e2bfbedc6ddf031	2283012623	2283012623
0xd5a8f233cbddb40368d55c3320644fb36e597002	false	23	106316400	0xcb2d8d262f88fe43941295fd57a4617c191466ea	58627358794231800837035572983875583164655364971568666876949606124749832878122	2023-07-01T17:12:57.000Z	0x9a5644079ed0fb75838fcf0a5af0fe278a6fb0e9a680584dc7dfe0ba9f498c4d	2838668882	2838668882
0xd5a8f233cbddb40368d55c3320644fb36e597002	false	56	106315069	0xcb2d8d262f88fe43941295fd57a4617c191466ea	27893612573804736155520255413901373494485677658991484624736362999275185305813	2023-07-01T16:28:35.000Z	0xa5ef580e0595ac500f52ec2b7a3478c13616cd08bb4fc53cb24510b7388aa8d8	238968697	238968696

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pika_v3_optimism.PikaPerp_PositionLiquidated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

PikaPerp_ProtocolRewardDistributed_event

Protocol reward distribution events from Pika Protocol v3 perpetual futures platform on Optimism. Records reward payouts to addresses with amounts and timestamps for tracking protocol incentive distribution.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_to	address	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xbcb15f57f8fdbbea6a1d1dedd67e862dc8a9d623	0xd5a8f233cbddb40368d55c3320644fb36e597002	false	33341947596	1	27100910	2022-10-03T08:09:13.000Z	0x1b99d2cba5e0492c938b1f0c4cf65a7a0321c093e58666a57d8b101e1cfa4198
0xbcb15f57f8fdbbea6a1d1dedd67e862dc8a9d623	0xd5a8f233cbddb40368d55c3320644fb36e597002	false	22383054415	1	48062486	2022-12-11T15:59:09.000Z	0xe57ee6d68076ba19b4a31303a1ffad137b76d890225a5cac70f546319d80fda8
0xbcb15f57f8fdbbea6a1d1dedd67e862dc8a9d623	0xd5a8f233cbddb40368d55c3320644fb36e597002	false	16914902156	1	23307478	2022-09-15T15:55:42.000Z	0x809aa989b0e5c3255587901d6d17c98ec9b0f63dd34ce83ac8da894257be5d3f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pika_v3_optimism.PikaPerp_ProtocolRewardDistributed_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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.
`in_shareBalance`	`STRING`	User’s total share balance before the redemption transaction. Numeric string representation of share quantity in the protocol’s accounting system.
`in_isFullRedeem`	`BOOL`	Boolean flag indicating whether the user is redeeming their entire share balance. True when the redemption amount equals the user’s total shares.

Sample Data

address	in_user	removed	in_amount	in_shares	log_index	in_receiver	block_number	block_timestamp	in_isFullRedeem	in_shareBalance	transaction_hash
0xd5a8f233cbddb40368d55c3320644fb36e597002	0xebc4625726197f736e5f4dcce15dc3e1cda62603	false	3099943114	2993481575	17	0xebc4625726197f736e5f4dcce15dc3e1cda62603	116162704	2024-02-14T15:23:05.000Z	false	3425299999	0x97448243d4af825288bfc25ef343d9fcd7c6257e0d8f94855c122f3885dc0350
0xd5a8f233cbddb40368d55c3320644fb36e597002	0xc5192ad83d7610ead79e0f6c82cf253c6c64d59a	false	51994381	49958884	26	0xc5192ad83d7610ead79e0f6c82cf253c6c64d59a	116172592	2024-02-14T20:52:41.000Z	false	57149999	0x4894bfca604bb65c377a2a305fc3ab7a4137437b1cd0fc518166bf198de339c3
0xd5a8f233cbddb40368d55c3320644fb36e597002	0xbb334ddd8d55dc9eee374d8fe9f15b8fc8e1ad46	false	48210	46327	1	0xbb334ddd8d55dc9eee374d8fe9f15b8fc8e1ad46	74247085	2023-02-14T09:05:57.000Z	true	49053	0xac3bac3ab3b8516e7f53f504f624f2f3f015b00fa55f8b8f90f65824eaef533d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pika_v3_optimism.PikaPerp_Redeemed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

PikaPerp_VaultRewardDistributed_event

Reward distribution events from Pika Protocol v3 vault on Optimism, tracking token amounts paid to recipients. Used for analyzing vault fee distributions and liquidity provider earnings over time.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_to	address	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x939c11c596b851447e5220584d37f12854ba02ae	0xd5a8f233cbddb40368d55c3320644fb36e597002	false	16000	1	80434903	2023-03-13T02:49:25.000Z	0x1f704dcd89322bc12bdf15c8aa3adca78574f45612e5beb43f2641113ce0d010
0x939c11c596b851447e5220584d37f12854ba02ae	0xd5a8f233cbddb40368d55c3320644fb36e597002	false	16197	1	80530773	2023-03-13T12:15:16.000Z	0xf27873a0523bef44669a0fde7bbada8db01b0da0e173f6b66c0af322100919c5
0x939c11c596b851447e5220584d37f12854ba02ae	0xd5a8f233cbddb40368d55c3320644fb36e597002	false	75000	1	80464281	2023-03-13T05:20:12.000Z	0x4ee8828df78d26fd7dff58c486a8da9070913f98630d0d67dfc3d377a31acca6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pika_v3_optimism.PikaPerp_VaultRewardDistributed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

PositionManager_ExecuteClosePosition_event

Position closure events from Pika Protocol v3 perpetual futures on Optimism, capturing when traders execute position exits with margin amounts, acceptable slippage prices, and directional (long/short) information. Used for analyzing position lifecycle, trader behavior patterns, and execution timing dynamics.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_productId`	`STRING`	Identifier 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_margin`	`STRING`	Margin 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_isLong`	`BOOL`	Boolean 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_acceptablePrice`	`STRING`	Maximum acceptable execution price for the position close order, denominated in the protocol’s base units with high precision. This slippage protection parameter ensures the position only closes if market conditions meet the trader’s specified price threshold.
`in_executionFee`	`STRING`	Fee paid to execute the trade or position order. Numeric string representation in the smallest unit of the native chain token (wei for EVM chains).
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
`in_blockGap`	`STRING`	Number of blocks elapsed between position close request submission and execution. Values typically range from 0-6 blocks, with 0 indicating same-block execution.
`in_timeGap`	`STRING`	Time elapsed in seconds between position close request submission and execution. Values typically range from 0-6 seconds based on sample data.

Sample Data

address	removed	in_index	in_isLong	in_margin	log_index	in_account	in_timeGap	in_blockGap	block_number	in_productId	block_timestamp	in_executionFee	transaction_hash	in_acceptablePrice
0x8add31bc901214a37f3bb676cb90ad62b24fd9a5	false	1	true	9302822330	68	0x3bbfcf6bf66e2eedd1a6895f089e639a1d459cdc	6	3	107184312	1	2023-07-21T19:23:21.000Z	25000	0x4271d4b7f3dc3ff31501390c6b7c399fb256c45d8aeee7659945b5549e3a6985	188714154000
0x8add31bc901214a37f3bb676cb90ad62b24fd9a5	false	401	false	5493848354	58	0x8e140b709ad3a3213a9061926d46a67b844e5936	0	0	105589859	2	2023-06-14T21:34:55.000Z	25000	0x89dca55dc02d82e2c0ee25b477229b26ac0d15a8da53eea24decb3bbb6f1e0bb	2516527000000
0x8add31bc901214a37f3bb676cb90ad62b24fd9a5	false	24	false	151515151515	110	0x1ad3056bdacfc543afa8c4ae282cfa8e1d33e212	0	0	105578200	14	2023-06-14T15:06:17.000Z	25000	0x4ac78f1c1f6d8a9162f532607eaa20217f30092b3cc15795a7e4fee1240d62f6	63891100

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pika_v3_optimism.PositionManager_ExecuteClosePosition_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

PositionManager_ExecuteOpenPosition_event

Position opening execution events from Pika Protocol V3 perpetual futures on Optimism. Records margin, leverage (scaled by 1e8), direction (long/short), product ID, execution fees, and slippage protection via acceptable price limits for analyzing trader behavior and protocol usage.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_productId`	`STRING`	Identifier 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_margin`	`STRING`	Margin 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_leverage`	`STRING`	Leverage multiplier applied to the trading position. String-encoded numeric value representing the multiple of the margin amount used to determine position size.
`in_tradeFee`	`STRING`	Fee charged for executing this trade on the Pika protocol, denominated in the smallest unit of the fee token. Typically proportional to the position size and leverage, ranging from tens of thousands to hundreds of millions based on sample values.
`in_isLong`	`BOOL`	Boolean 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_acceptablePrice`	`STRING`	Maximum acceptable price for the position execution, denominated in the protocol’s price units with extended precision. Sample values around 180 billion suggest prices with 9 decimal places of precision for perpetual futures trades.
`in_executionFee`	`STRING`	Fee paid to execute the trade or position order. Numeric string representation in the smallest unit of the native chain token (wei for EVM chains).
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
`in_blockGap`	`STRING`	Number of blocks elapsed between position request submission and execution on-chain. Value of 0 indicates execution in the same block as the request.
`in_timeGap`	`STRING`	Time elapsed in seconds between position request submission and execution. Typically 0 or 15 seconds based on sample values.

Sample Data

address	removed	in_index	in_isLong	in_margin	log_index	in_account	in_timeGap	in_blockGap	in_leverage	in_tradeFee	block_number	in_productId	block_timestamp	in_executionFee	transaction_hash	in_acceptablePrice
0x8add31bc901214a37f3bb676cb90ad62b24fd9a5	false	1	false	4990005000	32	0x5c990b077fa5cc9f781a686c78e404fd630f285d	0	27	390000000	19461019	85632465	1	2023-04-02T15:28:50.000Z	30000	0x4a4aad8e86377e3687764cc4dbe2bafba31d5c52b600604fa399aa66311d755e	178950533000
0x8add31bc901214a37f3bb676cb90ad62b24fd9a5	false	1	true	99790209900	32	0x23255a1da72b2ab4c31d903c65d2d945b1fbe802	15	30	100000000	99790209	85557425	1	2023-04-02T09:36:53.000Z	30000	0x862b4e50d4b78a79cc2029e11fc773aa24f1397aef8885c68c0f75cf89cf6572	182715507000
0x8add31bc901214a37f3bb676cb90ad62b24fd9a5	false	1	false	25288265660	32	0x31fe35d72541204d2b856eb3d849532c33fff5f8	0	10	400000000	101153062	85698310	1	2023-04-02T22:09:56.000Z	30000	0x996e1a3541801c26d3a569ea50274d67b2935120851fd1b00278bb88ca5a65d1	177892716000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pika_v3_optimism.PositionManager_ExecuteOpenPosition_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

VaultFeeReward_ClaimedReward_event

Reward claim events from Pika Protocol v3 vault fee distribution contract on Optimism. Records user withdrawals of accumulated fee rewards with token address and claim amounts for tracking vault participant earnings.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_rewardToken`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	log_index	block_number	in_rewardToken	block_timestamp	transaction_hash
0x939c11c596b851447e5220584d37f12854ba02ae	0x0626a4d229e4feb73a9a17170a68f566f739fe44	false	190538164	1	22014526	0x7f5c764cbc14f9669b88837ca1490cca17c31607	2022-09-05T15:39:26.000Z	0x8c1d8d2d239a6242719f6945edd5aa50f2393f9efa4d00f67ab1cf7890f4fb10
0x939c11c596b851447e5220584d37f12854ba02ae	0x0bb9f7c03eb9c1a31c25b3b7e61e2c503c30b81d	false	1361892	1	22014497	0x7f5c764cbc14f9669b88837ca1490cca17c31607	2022-09-05T15:38:56.000Z	0x176f304232f9599b83226caa914581f712c5e0ed33eec81833ff02877820badb
0x939c11c596b851447e5220584d37f12854ba02ae	0x10a78ba329d754ba5af48c744cfadc0f8b777d0d	false	430286	1	22037232	0x7f5c764cbc14f9669b88837ca1490cca17c31607	2022-09-05T20:55:38.000Z	0x7a898b6fbb51b3b2caa0c1537fe2d4368414271e17146867f03df62001d4d070

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pika_v3_optimism.VaultFeeReward_ClaimedReward_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

PikaPerp_AddMargin_event

PikaPerp_ClosePosition_event

PikaPerp_NewPosition_event

PikaPerp_PositionLiquidated_event

PikaPerp_ProtocolRewardDistributed_event

PikaPerp_Redeemed_event

PikaPerp_VaultRewardDistributed_event

PositionManager_ExecuteClosePosition_event

PositionManager_ExecuteOpenPosition_event

VaultFeeReward_ClaimedReward_event

​Tables

​PikaPerp_AddMargin_event

​PikaPerp_ClosePosition_event

​PikaPerp_NewPosition_event

​PikaPerp_PositionLiquidated_event

​PikaPerp_ProtocolRewardDistributed_event

​PikaPerp_Redeemed_event

​PikaPerp_VaultRewardDistributed_event

​PositionManager_ExecuteClosePosition_event

​PositionManager_ExecuteOpenPosition_event

​VaultFeeReward_ClaimedReward_event

Tables

PikaPerp_AddMargin_event

PikaPerp_ClosePosition_event

PikaPerp_NewPosition_event

PikaPerp_PositionLiquidated_event

PikaPerp_ProtocolRewardDistributed_event

PikaPerp_Redeemed_event

PikaPerp_VaultRewardDistributed_event

PositionManager_ExecuteClosePosition_event

PositionManager_ExecuteOpenPosition_event

VaultFeeReward_ClaimedReward_event