pika_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	0x0867613beeb5501c30e7a25ea88982c212f18871	false	46400000000	2	13388422	96400000000	102988931539522329258506490011637643544410404368595056737944041101588403988032	1556016597	2022-06-28T13:54:55.000Z	0x4f8345bfd965bd01c1b55fe82dc0f0258e21b16c4522efa6a224fb5cc6b749ae
0x2fae8c7edd26213ca1a88fc57b65352dbe353698	0x46caceee602eaa35f12c0a33dd2ad99ef4a0ef2d	false	5000000000	2	7289923	10000000000	85083239201597591343907090012589656739050877676179339536081832003053929260155	1500000000	2022-05-07T11:19:26.000Z	0x1bf18067b4bace134184a9042d55c521da32495af8bddd090e424b9a8e7e349a
0x2fae8c7edd26213ca1a88fc57b65352dbe353698	0xcd5d8a3ecb1780316e653dfe00f8b0335fd8ece1	false	10000000000	2	7311688	88242605880	508197964053775297522144303219999361797859803684039450955671588702436870732	177335211	2022-05-07T19:32:48.000Z	0xe297deb239a4830e8a9bdcd199325e9609e0e4e69782a78004a8506a84957848

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pika_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
9825722	0	0x2fae8c7edd26213ca1a88fc57b65352dbe353698	0x0a5abc4eef196994abb9cd34fa8fe9229ce53e4f	false	263413283707	9806040000	1	100000000	3775627	1	262247333490	7639014397477024906494184369787750171549399715548586627654787435762190458178	2022-02-23T04:10:00.000Z	false	0x3feaff12261ffd533d56d702f8eaf5abad5139f5ee880e19cf17116029197082
5012347	-409714	0x2fae8c7edd26213ca1a88fc57b65352dbe353698	0x0b5939e11c765e4d3d9ce7e2ec8bd397337f9701	false	271320451611	5011990000	1	100000000	3782279	1	271342633018	67476408134205920627627394116404311709243214538640240571735046089650831044870	2022-02-23T10:25:54.000Z	false	0xcf57648e7ed6d7603162299bed283d8e77fed57a0b9d55007dfd469b1aa1766c
5004153	0	0x2fae8c7edd26213ca1a88fc57b65352dbe353698	0x0b5939e11c765e4d3d9ce7e2ec8bd397337f9701	false	271880686192	5001560000	1	100000000	3782328	1	271342633018	67476408134205920627627394116404311709243214538640240571735046089650831044870	2022-02-23T10:28:33.000Z	false	0x02b70a091a8d895339cf44ac4e74c0960cc7d82d76861c7347902e90d5a2c003

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pika_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
8100000000	0x2fae8c7edd26213ca1a88fc57b65352dbe353698	0xa60be818f6e213ec535b5e0d0b271c40291320c4	false	688773908	false	270000000000	2	3000000000	5171912	4	34719577691786732559961615592078640170930464454670960762719092241016006557268	689800000	2022-04-01T05:37:52.000Z	0x5303a204e6979a6ada4a09ec9a91349261b23d7eed189f7866bda582d47653c0
6000000000	0x2fae8c7edd26213ca1a88fc57b65352dbe353698	0xe5621eb62ab4b6ceed2617021af183e17d57fd14	false	689512157	false	200000000000	2	3000000000	5164732	4	49156140223050494822710052118426405867679514284748339825468977164753965667982	690250000	2022-04-01T02:38:11.000Z	0x666339cab28e597b924fbf53686f0b689fbc26a90b5af8a64ee59849e0758a48
8100000000	0x2fae8c7edd26213ca1a88fc57b65352dbe353698	0xa60be818f6e213ec535b5e0d0b271c40291320c4	false	714825907	false	270000000000	2	3000000000	5196193	4	34719577691786732559961615592078640170930464454670960762719092241016006557268	716100000	2022-04-01T15:05:16.000Z	0xe0c2da7e3420dd91ca798cae74f3aa5239fe89cb48bb1997b8dfc757c0d5a871

Example Query

Query with partition filter

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

PikaPerp_PikaRewardDistributed_event

PIKA token reward distribution events from Pika Protocol v2 perpetual futures platform on Optimism. Records trader incentive payouts with recipient addresses and token amounts for analyzing platform reward mechanics and user incentivization.

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
0x6ced1c9e91820b8a3934773c6d80d635efe9f2e5	0x2fae8c7edd26213ca1a88fc57b65352dbe353698	false	11776	1	3105866	2022-02-02T02:50:43.000Z	0xfcd527d3fc781a6aceefd05084ee7d4887f560819b3714aee1b750751a86076b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pika_v2_optimism.PikaPerp_PikaRewardDistributed_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	5760016	0x0ee1bea664f0e888a54adab65c4a507e1e6e55f2	111564589400836793370189599532615231827229513410068488291773466584010388430902	2022-04-13T12:55:01.000Z	0x3c8f98174f7e7c056b2000f9f803ecd19ea04293b5a9494f4e192adc6c8ab8d1	855622090	855622089
0x2fae8c7edd26213ca1a88fc57b65352dbe353698	false	1	5743654	0x0ee1bea664f0e888a54adab65c4a507e1e6e55f2	113362384820623463059366820838483419117188572568643465652460169164863470115369	2022-04-13T03:22:15.000Z	0x7db063c8e043f01f394978a3376d94500adf223f640d9112704d107a05f84b8d	70590873617	70590873617
0x2fae8c7edd26213ca1a88fc57b65352dbe353698	false	1	5764476	0x0ee1bea664f0e888a54adab65c4a507e1e6e55f2	55128651768859315412541509878547210785198385045886695627934083237088323563865	2022-04-13T14:19:05.000Z	0xde666ed9f6e82a0c64113dfa33e00bb3a19df8e5e51427465a233b1ab2a0da8f	16581238181	16581238181

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pika_v2_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 v2 perpetual exchange on Optimism, tracking fee rebates or incentive payments to recipients. Useful for analyzing protocol revenue sharing and user reward programs.

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
0x6ced1c9e91820b8a3934773c6d80d635efe9f2e5	0x2fae8c7edd26213ca1a88fc57b65352dbe353698	false	19978504134	1	4142270	2022-03-05T08:16:15.000Z	0x22655a13f31a237802b5bc6bf941b0b04251152a15411fe64462072a38d68d80
0x6ced1c9e91820b8a3934773c6d80d635efe9f2e5	0x2fae8c7edd26213ca1a88fc57b65352dbe353698	false	73322442853	1	8840260	2022-05-23T13:28:59.000Z	0xec78e7e5047694b230e0e624f4bd0876a23f0549eebf0839087844f44aa34c5a
0x6ced1c9e91820b8a3934773c6d80d635efe9f2e5	0x2fae8c7edd26213ca1a88fc57b65352dbe353698	false	761746345	1	15444836	2022-07-23T04:33:00.000Z	0x136cc58546106acf6e913429ba36b2e6f9ec9286bb0c3afc545a3801896b09c2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pika_v2_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_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	0x84f734c6c6fe7bb628e0ff04ff0a5776b8d68f9f	false	400037619	529040442	3	112407246	2023-11-19T17:01:09.000Z	false	343800000	0x16de0610f6793157e3994069a5928fbba9f2fe429cde6588d41344c1038ed55a
0x2fae8c7edd26213ca1a88fc57b65352dbe353698	0x07d095ff9fcf13e086ab6d44309733e95daa28c3	false	300007640	388852483	1	55590992	2022-12-26T14:49:43.000Z	false	258900000	0x58ca55e8e6848fd0d527c38421c2aa650da0d6080345863e734024415775f300
0x2fae8c7edd26213ca1a88fc57b65352dbe353698	0xb6b7222416ed330a8f0ed0ddd4c27a06eb7e34ba	false	2592200000	2701190495	1	55438321	2022-12-26T09:35:10.000Z	true	1798466643	0xaeaacfcd4bc76b67a21463c6c9324fa8dc73b6f1b279d769f65d34c48b7fa977

Example Query

Query with partition filter

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

PikaPerp_VaultRewardDistributed_event

Vault reward distribution events from Pika Protocol v2 perpetual futures on Optimism, recording reward payouts to recipients with amounts and timestamps. Used for tracking vault incentive distributions and liquidity provider rewards.

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
0x58488bb666d2da33f8e8938dbdd582d2481d4183	0x2fae8c7edd26213ca1a88fc57b65352dbe353698	false	37777251	1	8466104	2022-05-17T12:55:49.000Z	0x49309480f99eca96321245e8275923a3f732bf8ff748ed9324d00906d6a6e9e2
0x58488bb666d2da33f8e8938dbdd582d2481d4183	0x2fae8c7edd26213ca1a88fc57b65352dbe353698	false	9445256	1	8458913	2022-05-17T10:09:18.000Z	0xd3a904f5c8809715d97e7fd25b88e187c1940d2061d51ed968349685dc0cc290
0x58488bb666d2da33f8e8938dbdd582d2481d4183	0x2fae8c7edd26213ca1a88fc57b65352dbe353698	false	797910	1	8459305	2022-05-17T10:20:46.000Z	0xea90f672c8e5170835d6088124620c2edb73e68b5d76e39ebe0560a2d6a51195

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

PikaPerp_AddMargin_event

PikaPerp_ClosePosition_event

PikaPerp_NewPosition_event

PikaPerp_PikaRewardDistributed_event

PikaPerp_PositionLiquidated_event

PikaPerp_ProtocolRewardDistributed_event

PikaPerp_Redeemed_event

PikaPerp_VaultRewardDistributed_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​PikaPerp_AddMargin_event

​PikaPerp_ClosePosition_event

​PikaPerp_NewPosition_event

​PikaPerp_PikaRewardDistributed_event

​PikaPerp_PositionLiquidated_event

​PikaPerp_ProtocolRewardDistributed_event

​PikaPerp_Redeemed_event

​PikaPerp_VaultRewardDistributed_event

Tables

PikaPerp_AddMargin_event

PikaPerp_ClosePosition_event

PikaPerp_NewPosition_event

PikaPerp_PikaRewardDistributed_event

PikaPerp_PositionLiquidated_event

PikaPerp_ProtocolRewardDistributed_event

PikaPerp_Redeemed_event

PikaPerp_VaultRewardDistributed_event