Skip to main content

Tables

DToken_DLT_Transfer_event

Transfer events for Deri Protocol v3 DToken (derivatives position tokens) on Arbitrum, tracking NFT-style position token mints and transfers between addresses. Useful for analyzing position ownership changes and new position creation patterns.
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_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenIdSTRINGUnique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
in_toaddressin_fromremovedlog_indexin_tokenIdblock_numberblock_timestamptransaction_hash
0x91467a1cf52f178e8b857631b21c2bfbe5480c680x109f2f2b8e2490ba9cd8b5ab1d1dc7fb4aed3b630x0000000000000000000000000000000000000000false43463702406962023-03-16T01:01:01.000Z0xfb80415a0b9bb24878e239da8af0e634f0aa629e00dd50240c6a248c3ce82175
0x6cff92ee31861e6ec1544e081bd7c4b8038322410x109f2f2b8e2490ba9cd8b5ab1d1dc7fb4aed3b630x0000000000000000000000000000000000000000false43464703769842023-03-16T10:38:19.000Z0x31a3afddabac5f68864cab5298c22a31893a817aa74747a88f4d067c3d7f5440
0xf507e035b9243ae54b9bca48dc5448d2888f50bd0x109f2f2b8e2490ba9cd8b5ab1d1dc7fb4aed3b630x0000000000000000000000000000000000000000false653465704447952023-03-16T15:19:09.000Z0x0f0c1d1f4020ea260eeeb0b0219648e512ccd655ff215e6f735e02d84ebed6bd
Query with partition filter
SELECT *
FROM `tt-contracts.deriprotocol_v3_arbitrum.DToken_DLT_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

DToken_DPT_Transfer_event

DToken (DPT) NFT transfer events from Deriprotocol v3 on Arbitrum, tracking mints and transfers of tokenized position NFTs by token ID. Useful for analyzing position ownership changes and protocol liquidity provider activity.
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_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenIdSTRINGUnique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
in_toaddressin_fromremovedlog_indexin_tokenIdblock_numberblock_timestamptransaction_hash
0xf9629f4d682d5f81b1efc48197cd8f1813c7ff9c0x548758470914544bb289801153157517a6ca2a820x0000000000000000000000000000000000000000false254140145522022-06-07T22:11:04.000Z0x3f2d8feb04fb435ad388839362f76774a1a881c6d63e134defb672e45870f15b
0xa1cf43882b7984c1aa426ea6b0050fa162d8b7ce0x548758470914544bb289801153157517a6ca2a820x0000000000000000000000000000000000000000false253139877662022-06-07T15:09:46.000Z0x133537d28c25187a6ec4f537aaef29da6915f42b52fa86f73e86be43c901db87
0xffd3003a187d9951e49bda206f32a6e7653604270x548758470914544bb289801153157517a6ca2a820x0000000000000000000000000000000000000000false252139751362022-06-07T12:59:43.000Z0xf9775d13faf48a7bcb787d948c1fd89015263044d17346f7494d802481c1ea50
Query with partition filter
SELECT *
FROM `tt-contracts.deriprotocol_v3_arbitrum.DToken_DPT_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_AddLiquidity_event

Liquidity provision events recording deposits into decentralized exchange (DEX) pools. Contains deposited asset addresses, amounts, liquidity position identifiers, and updated pool liquidity balances for tracking capital inflows and position creation.
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_lTokenIdSTRINGLiquidity token identifier for the position. Numeric string representing the unique ID assigned to the liquidity provider’s token.
in_assetSTRINGContract address of the asset or token. 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_newLiquiditySTRINGUpdated liquidity amount after the operation. Numeric string representation in smallest denomination.
addressremovedin_assetin_amountlog_indexin_lTokenIdblock_numberblock_timestampin_newLiquiditytransaction_hash
0xde3447eb47ecdf9b5f90e7a6960a14663916cee8false0xff970a61a04b1ca14834a43f5de4533ebddb5cc8173005645143415373158022022-11-11T20:40:40.000Z1730773772875000000000x82c71171b3068c7d170998722d3014e9916cbf153b595c6be706763c70f6481a
0xde3447eb47ecdf9b5f90e7a6960a14663916cee8false0x0000000000000000000000000000000000000000100000000000000123414372119122022-11-11T12:36:51.000Z1273865000000000000x23f226ce86b080ae8917ed8eda00571e57f50994567d8427a7068d2f840a4f75
0xde3447eb47ecdf9b5f90e7a6960a14663916cee8false0x00000000000000000000000000000000000000001184333587042171492111127536181272023-01-17T05:10:28.000Z11638262903540675434688000x10e3fba1c4fb6a6b28a6a42dd3dc1af1ed6289259a37c81f59f94bfc1ea46ed9
Query with partition filter
SELECT *
FROM `tt-contracts.deriprotocol_v3_arbitrum.Pool_AddLiquidity_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_RemoveLiquidity_event

Liquidity withdrawal events from decentralized exchange pools recording the removal of assets by liquidity providers. Contains withdrawal amounts, recipient addresses, and pool state changes including updated liquidity balances and token identifiers.
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_lTokenIdSTRINGLiquidity token identifier for the position. Numeric string representing the unique ID assigned to the liquidity provider’s token.
in_assetSTRINGContract address of the asset or token. 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_newLiquiditySTRINGUpdated liquidity amount after the operation. Numeric string representation in smallest denomination.
addressremovedin_assetin_amountlog_indexin_lTokenIdblock_numberblock_timestampin_newLiquiditytransaction_hash
0xde3447eb47ecdf9b5f90e7a6960a14663916cee8false0xff970a61a04b1ca14834a43f5de4533ebddb5cc8115792089237316195423570985008687907853269984665640564039457113544917184022023-05-17T20:03:18.000Z6937730309510x1663ac0babe71c13037df02472a7a8afb839d26010b967d1742aed234a17cc2b
0xde3447eb47ecdf9b5f90e7a6960a14663916cee8false0x00000000000000000000000000000000000000001157920892373161954235709850086879078532699846656405640394571520871252120672023-08-26T16:35:57.000Z7505753354860xf29d76ae98dd1baac9d52e6bf74237bd0a9c65bb47ee2c9695ea4cedbd56abef
0xde3447eb47ecdf9b5f90e7a6960a14663916cee8false0x0000000000000000000000000000000000000000115792089237316195423570985008687907853269984665640564039457152721251163692023-08-26T09:43:51.000Z6950463577930xf6c2517198890f293806a19d8316c5fe2b00288b5810ebcd32b3bc7a01b25abb
Query with partition filter
SELECT *
FROM `tt-contracts.deriprotocol_v3_arbitrum.Pool_RemoveLiquidity_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_SetRouter_event

Router authorization events from Deri Protocol V3 perpetual futures pools on Arbitrum, tracking which router contracts are granted or revoked permission to interact with liquidity pools for trade execution and position management.
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_routerSTRINGAddress of the router responsible for facilitating the cross-chain transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_isActiveBOOLIndicates whether the specified router address is being activated or deactivated for the Deriprotocol pool. Boolean value where true enables the router and false disables it.
addressremovedin_routerlog_indexin_isActiveblock_numberblock_timestamptransaction_hash
0xde3447eb47ecdf9b5f90e7a6960a14663916cee8false0xf4d4583078561c8e2ddbed588db2da179f84a2f50true460780602022-12-14T12:13:25.000Z0x8591b26555b81adcb16eedcfa667f9255d8a41c9c1a6cb4299b8a5acfaa074af
0xde3447eb47ecdf9b5f90e7a6960a14663916cee8false0x8b381e5376f37c1fc1011c02212769b6ea7d8c0c0true460795812022-12-14T12:20:44.000Z0xf12e7a1cea1cfc0095c824a8e8825c801f63fbbcb44ac997a157bbbaeb79f84e
0xde3447eb47ecdf9b5f90e7a6960a14663916cee8false0x9eb9c0363f41e84c02c425cdb69c88d39e43aad833true1548940012023-11-28T11:20:55.000Z0xcbf1c46eb8a426ecd7a5e021dd09e5638c9fbb38f5526269d5f35eea74eecb92
Query with partition filter
SELECT *
FROM `tt-contracts.deriprotocol_v3_arbitrum.Pool_SetRouter_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

RewardVault_Claim_event

Reward claim events from Deribit Protocol V3 liquidity pools on Arbitrum, recording token withdrawals by position holders identified by tokenId. Used for analyzing reward distribution patterns and liquidity provider earnings across different pool positions.
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_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
in_accountSTRINGAccount address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenIdSTRINGUnique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressin_poolremovedin_amountlog_indexin_accountin_tokenIdblock_numberblock_timestamptransaction_hash
0xae77aa30a077bea1e62616e70c60c56c04dff4e70xde3447eb47ecdf9b5f90e7a6960a14663916cee8false16481186816978910x8e97e11b13f240dba275a5bced2620a72948fd913288267130162022-09-26T04:22:55.000Z0x796f954ae4227327cb2e3af6f6d98c920be0ae73c257c9d42bb92930cffc1d75
0xae77aa30a077bea1e62616e70c60c56c04dff4e70xde3447eb47ecdf9b5f90e7a6960a14663916cee8false3021987020989992060223610x092cda2230d41979999fdd210af1b73a7da46ce416268689112022-09-26T19:43:29.000Z0x1f477d957badfb9b83c75afe796712e9cfca6c220e158a7e93a3cf69bb413389
0xae77aa30a077bea1e62616e70c60c56c04dff4e70xde3447eb47ecdf9b5f90e7a6960a14663916cee8false45707600136339684834061610xd205ae9a8aa31ba41258e1e4a60145d560f238f1127474356192022-12-20T01:49:48.000Z0x835d884d11fa183accdf80353419ed12a8b54e2a163d1ec6af3eb183d2b2c039
Query with partition filter
SELECT *
FROM `tt-contracts.deriprotocol_v3_arbitrum.RewardVault_Claim_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Router_ExecuteTrade_event

Trade execution events from Deribit Protocol V3 options and perpetuals on Arbitrum, capturing order details including symbol (like ETHUSD-2000-C for call options), trade volume, price limits, and execution fees. Used for analyzing options trading activity, premium pricing, and position changes across BTC and ETH derivatives.
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_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
in_timestampSTRINGUnix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.
in_accountSTRINGAccount address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_symbolNameSTRINGTrading pair symbol for the derivatives contract being traded, using format BASE-STRIKE-TYPE (e.g., ETHUSD-2000-C for ETH/USD call option with $2000 strike). May also contain spot symbols without strike/type suffix for perpetual or spot positions.
in_tradeVolumeSTRINGVolume of the trade executed in the position. Numeric string representation in wei (1e18), with negative values indicating short positions and positive values indicating long positions.
in_priceLimitSTRINGSlippage protection threshold specified by the trader, representing the maximum acceptable price for buy orders or minimum acceptable price for sell orders. Value is typically a high-precision integer representing price in the protocol’s native units.
in_executionFeeSTRINGFee paid to execute the trade or position order. Numeric string representation in the smallest unit of the native chain token (wei for EVM chains).
addressremovedin_indexlog_indexin_accountblock_numberin_timestampin_priceLimitin_symbolNamein_tradeVolumeblock_timestampin_executionFeetransaction_hash
0xf4d4583078561c8e2ddbed588db2da179f84a2f5false133750x34dd7c497f4688a25beee118cacabc6a19cb46596204408416767097935638737250958313000ETHUSD-2000-C40000000000000000002023-02-18T08:43:14.000Z2000000000000000x52ee586b1d40b325cc182de6e4b2a220f6ec3453c0d18a409b011b0a8b2b6770
0xf4d4583078561c8e2ddbed588db2da179f84a2f5false133650x34dd7c497f4688a25beee118cacabc6a19cb46596204283416767094715454287110053901000ETHUSD-2000-C340000000000000000002023-02-18T08:37:53.000Z2000000000000000xe42f0e542c04372a04549bdfdcfe3cf33ff61be78883197bd728506a5e55edf9
0xf4d4583078561c8e2ddbed588db2da179f84a2f5false133850xf62d357f79ced9ab5b606cd12cb0e9199737271c62079425167671888138127381084202650000BTCUSD-30000-C-1200000000000000002023-02-18T11:14:42.000Z2000000000000000xcb6da4f052196147675d960418f86410d33862b485280bd71ca5e08546ba3907
Query with partition filter
SELECT *
FROM `tt-contracts.deriprotocol_v3_arbitrum.Router_ExecuteTrade_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

SymbolManager_Trade_event

Trade execution events from Deri Protocol V3 on Arbitrum, capturing perpetual futures trades with symbol identifiers, position token IDs, execution prices, volumes, and fees. Used to analyze trading activity, position changes, and fee generation across different derivatives symbols.
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_pTokenIdSTRINGPosition token identifier representing the specific position involved in this trade event. Numeric identifier that links to a unique position within the Deriprotocol v3 system on Arbitrum.
in_symbolIdSTRINGUnique identifier for the trading symbol or instrument being traded in the Deriprotocol perpetual futures contract. Keccak256 hash value represented as a 0x-prefixed 64-character hex string.
in_indexPriceSTRINGIndex price of the underlying asset at the time of the position change. String-encoded integer value representing the price with chain-specific precision, denominated in the smallest unit of the quote currency.
in_tradeVolumeSTRINGVolume of the trade executed in the position. Numeric string representation in wei (1e18), with negative values indicating short positions and positive values indicating long positions.
in_tradeCostSTRINGCost or profit/loss of the trade in the protocol’s base units, where negative values indicate a cost to the trader and positive values indicate a gain. Stored as a high-precision integer string representing the smallest token denomination.
in_tradeFeeSTRINGFee charged for this trade execution denominated in the base token unit (wei-equivalent for 18-decimal tokens). Typically represents protocol or liquidity provider fees, with positive values indicating fee collection regardless of trade direction.
addressremovedlog_indexin_pTokenIdin_symbolIdin_tradeFeeblock_numberin_tradeCostin_indexPricein_tradeVolumeblock_timestamptransaction_hash
0x741c8e810cd1c7bab6565e850b775fc33c15c084false2240x511e48778041c284afe356f7abd6d073fc97795ec744c3b436c6e86856a5a3b921214047905450000016020771-8806129333661834977121214047905450000000000-100000000000000002022-06-27T06:43:42.000Z0x233c0a3a58a8da192d4d4d0ff89524efdc774c24adebdd05e1bfc2d28bddd6e2
0x741c8e810cd1c7bab6565e850b775fc33c15c084false2720x59102b37de83bdda9f38ac8254e596f0d9ac61d2035c07936675e87342817160111966430327717033016116604-11196643032771703306851194178544580000000000-9390000000000000002022-06-27T19:03:03.000Z0xdeca5b88dd14d14775accd5a4257ede58ce49481b37da86de7458d56f260fde5
0x741c8e810cd1c7bab6565e850b775fc33c15c084false1730x98fc75eeaf2daf20762fde47b011dc0b9bbc272d057f010223476676501d04f71214788892964266693416033508-8098592619761777956381228403300000000000000-500000000000000000002022-06-27T08:10:25.000Z0xdeca1dc0776f906a77be1af1fc7e90451df965129d82c266394998957f2a6bb8
Query with partition filter
SELECT *
FROM `tt-contracts.deriprotocol_v3_arbitrum.SymbolManager_Trade_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100