pikaprotocol_v2_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_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	log_index	block_number	in_newMargin	in_positionId	in_newLeverage	block_timestamp	transaction_hash
0x2fae8c7edd26213ca1a88fc57b65352dbe353698	0x9da847cd29d0da97fbfaee0692d336857cf00cd3	false	40000000000	2	3255352	105000000000	26589239547014710334790188123429762221908550750373586871221794783528803962188	495238095	2022-02-06T03:00:00.000Z	0xb7348a01c619c65dd56f7cf81b7f7289523fcec949b44268a14b3a5db8792f5f
0x2fae8c7edd26213ca1a88fc57b65352dbe353698	0xc875c65601a98761c5dd38ae8ca34f718277bf3f	false	200000000000	2	5785814	985057333000	21676648007675453149496235835858703251759990983698743072517382444173413500675	2390898397	2022-04-14T01:28:36.000Z	0x5776eb3ff5e442d7781d0b1fb6c116b9d596b3c50bead4da43ba6b24a76104dc
0x2fae8c7edd26213ca1a88fc57b65352dbe353698	0x362b425c921999c7b19b780e4152f88fae9d6882	false	5000000000	2	4910083	10500000000	112560196729278614612081859163474589613160678033598110658236876885038455873925	471428571	2022-03-27T16:29:50.000Z	0x31ede0c0cee1150c297e4cf74e349b7290f9df944bac72be91879a491834267d

Example Query

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.

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_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
10061429	-12804201	0x2fae8c7edd26213ca1a88fc57b65352dbe353698	0x4a1866bc7d5614664ebd377d31c24868909b463f	false	60551954	5000000000	1	100000000	12958719	22	60707416	27887824385820409975306101975963741258498311778085849265764202733184565980576	2022-06-24T20:18:43.000Z	false	0x76018f71e1306b5d5151fc036aea36508905653ff009ca8f24c689ea5c0d4e23
186880664	16295044132	0x2fae8c7edd26213ca1a88fc57b65352dbe353698	0x9a4773eeee73e34e1ee0e9a64e4b7453b0b04246	false	60595061	11100000000	1	720000000	12883899	22	50332641	17186568643867964740341895014244029539757822830195143015192460105510943325226	2022-06-24T05:54:22.000Z	false	0x2ddec924aff04b5e7ef721f6d4c3e8dc677657bd974589a3112b6fca6bcb401a
169847290	-828724661	0x2fae8c7edd26213ca1a88fc57b65352dbe353698	0xb3dd225131d1ea7a2abd98279a7077ced9595911	false	547540953	16827333040	1	500000000	12972968	26	552987741	98026940146223410501806102911600070044690328771115948082251716935708866091029	2022-06-24T23:55:36.000Z	false	0xa49b3452c63ec747507338d99cb8e0b3decef154c481be5d588c9b0fe3fa590e

Example Query

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.

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.

Sample Data

in_fee	address	in_user	removed	in_price	in_isLong	in_margin	log_index	in_leverage	block_number	in_productId	in_positionId	in_oraclePrice	block_timestamp	transaction_hash
59392438	0x2fae8c7edd26213ca1a88fc57b65352dbe353698	0x4d9daffb02a454eacc27858923cb55250e9111df	false	1638472962	true	59392438110	2	100000000	5389286	3	15331167011113337965666091821003290816210531309980630851918835205852290981584	1638333491	2022-04-06T04:15:41.000Z	0x4593c7f056009cf5bd14b0ce8da137a849258535962a44bd404a4a2612988d09
5000000	0x2fae8c7edd26213ca1a88fc57b65352dbe353698	0xae780a263184ba59c8524fe59b73b03e2296acba	false	323207843006	false	5000000000	2	100000000	5439596	1	53065272898602191189826806754521142025093348344092053511481489091199203002675	323172000000	2022-04-06T20:04:25.000Z	0x77f60da53d317462a130795a6cc60dcb377fd2f6a23a9f9f23d6a820d108a452
5150644	0x2fae8c7edd26213ca1a88fc57b65352dbe353698	0x98ec3de89799be76552f8873907028c01a0eccf0	false	324351753824	true	5150644200	2	100000000	5424891	1	109782841442990759595870226046926905748678766098408245258334202607307161672778	324301532489	2022-04-06T16:18:28.000Z	0x5974777871961be100cd5bbdea8cc9aa89ff22ba16e1c8821172ff42b74a7f2b

Example Query

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.

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
0x2fae8c7edd26213ca1a88fc57b65352dbe353698	false	1	4307150	0x0ee1bea664f0e888a54adab65c4a507e1e6e55f2	24889752343464388607143195862879568376495351115295331102455116184502601207923	2022-03-10T05:09:10.000Z	0xf69bf6edf05e279348e6ff7efd2a5321adc7f63343d6d169559f88a3fb67d246	1555771014	1555771013
0x2fae8c7edd26213ca1a88fc57b65352dbe353698	false	1	4319866	0x0ee1bea664f0e888a54adab65c4a507e1e6e55f2	36066793792720010270759004952862527908014032996305858771182163953669680626091	2022-03-10T13:33:48.000Z	0x58e16e9bf6be156c48fe1f6b84321547b8493b22858733dad5703b9f1fcda1be	440807545	440807545
0x2fae8c7edd26213ca1a88fc57b65352dbe353698	false	1	4303729	0x0ee1bea664f0e888a54adab65c4a507e1e6e55f2	71241734152747544131593585005932012356041682961208599130580707329174500777244	2022-03-10T03:30:22.000Z	0x6ba1351b0a372e4f4eebff463c33b81690044e12c501f5fe7f68a5127d2a086e	0	0

Example Query

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.

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_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	block_number	block_timestamp	in_isFullRedeem	in_shareBalance	transaction_hash
0x2fae8c7edd26213ca1a88fc57b65352dbe353698	0x49ba5b7eb69601723c0879064de9bbdddc572949	false	109996638	118571165	14	109056584	2023-09-03T03:32:25.000Z	false	76969999	0x2bbdd34e1e30eac073cc34f59f10f58991b0c7576a8aae686b291ebc736d8c78
0x2fae8c7edd26213ca1a88fc57b65352dbe353698	0x89b7cfb32e2056c90ba1792af5e2401ba11caab1	false	109996782	118571165	40	109060037	2023-09-03T05:27:31.000Z	false	76969999	0xb1c6b4e9209452fcbc74b11e877d12f92c8de095ff5cff8b9b1ac4aa9104eb49
0x2fae8c7edd26213ca1a88fc57b65352dbe353698	0xf5459c27440efc83c917bd3d635919cab49b6490	false	109997157	118571165	42	109051733	2023-09-03T00:50:43.000Z	false	76969999	0x0a92ac915fa278ff27035c41b995c20fe77f2baf620b2dbd4c781e8114ba1812

Example Query

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.

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_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.

Sample Data

address	in_user	removed	in_amount	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x2fae8c7edd26213ca1a88fc57b65352dbe353698	0x0c6d190b146030c00bf654f1179cf8222d0db560	false	10100000000	10570404452	2	3681632	2022-02-19T12:39:58.000Z	0x03fdbef1f68192dee410f2279ada9dfd3c7c204f3017f5674b19ff594b9b9e56
0x2fae8c7edd26213ca1a88fc57b65352dbe353698	0xd491447348c474af15c40839d3e0056a80fec352	false	20000000000	20940799750	2	3687122	2022-02-19T19:58:18.000Z	0xbe9d95ee6670f9c036d5d97d7c17e603f3ca99735271a9ddef58371998151412
0x2fae8c7edd26213ca1a88fc57b65352dbe353698	0x47a127bc1004baf6c2f5b0ea275ecd4a5347d236	false	99900000	104552812	2	3681583	2022-02-19T12:34:38.000Z	0x49791ceaf11dc15453560d983c286841ca61599f47a6b16f24d98da5e2b247f0

Example Query

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

PikaPerp_AddMargin_event

PikaPerp_ClosePosition_event

PikaPerp_NewPosition_event

PikaPerp_PositionLiquidated_event

PikaPerp_Redeemed_event

PikaPerp_Staked_event

​Tables

​PikaPerp_AddMargin_event

​PikaPerp_ClosePosition_event

​PikaPerp_NewPosition_event

​PikaPerp_PositionLiquidated_event

​PikaPerp_Redeemed_event

​PikaPerp_Staked_event

Tables

PikaPerp_AddMargin_event

PikaPerp_ClosePosition_event

PikaPerp_NewPosition_event

PikaPerp_PositionLiquidated_event

PikaPerp_Redeemed_event

PikaPerp_Staked_event