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.Columns
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_from | STRING | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_to | STRING | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_tokenId | STRING | Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID. |
Sample Data
Sample Data
| in_to | address | in_from | removed | log_index | in_tokenId | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0x91467a1cf52f178e8b857631b21c2bfbe5480c68 | 0x109f2f2b8e2490ba9cd8b5ab1d1dc7fb4aed3b63 | 0x0000000000000000000000000000000000000000 | false | 4 | 3463 | 70240696 | 2023-03-16T01:01:01.000Z | 0xfb80415a0b9bb24878e239da8af0e634f0aa629e00dd50240c6a248c3ce82175 |
| 0x6cff92ee31861e6ec1544e081bd7c4b803832241 | 0x109f2f2b8e2490ba9cd8b5ab1d1dc7fb4aed3b63 | 0x0000000000000000000000000000000000000000 | false | 4 | 3464 | 70376984 | 2023-03-16T10:38:19.000Z | 0x31a3afddabac5f68864cab5298c22a31893a817aa74747a88f4d067c3d7f5440 |
| 0xf507e035b9243ae54b9bca48dc5448d2888f50bd | 0x109f2f2b8e2490ba9cd8b5ab1d1dc7fb4aed3b63 | 0x0000000000000000000000000000000000000000 | false | 65 | 3465 | 70444795 | 2023-03-16T15:19:09.000Z | 0x0f0c1d1f4020ea260eeeb0b0219648e512ccd655ff215e6f735e02d84ebed6bd |
Example Query
Example Query
Query with partition filter
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.Columns
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_from | STRING | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_to | STRING | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_tokenId | STRING | Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID. |
Sample Data
Sample Data
| in_to | address | in_from | removed | log_index | in_tokenId | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0xf9629f4d682d5f81b1efc48197cd8f1813c7ff9c | 0x548758470914544bb289801153157517a6ca2a82 | 0x0000000000000000000000000000000000000000 | false | 2 | 54 | 14014552 | 2022-06-07T22:11:04.000Z | 0x3f2d8feb04fb435ad388839362f76774a1a881c6d63e134defb672e45870f15b |
| 0xa1cf43882b7984c1aa426ea6b0050fa162d8b7ce | 0x548758470914544bb289801153157517a6ca2a82 | 0x0000000000000000000000000000000000000000 | false | 2 | 53 | 13987766 | 2022-06-07T15:09:46.000Z | 0x133537d28c25187a6ec4f537aaef29da6915f42b52fa86f73e86be43c901db87 |
| 0xffd3003a187d9951e49bda206f32a6e765360427 | 0x548758470914544bb289801153157517a6ca2a82 | 0x0000000000000000000000000000000000000000 | false | 2 | 52 | 13975136 | 2022-06-07T12:59:43.000Z | 0xf9775d13faf48a7bcb787d948c1fd89015263044d17346f7494d802481c1ea50 |
Example Query
Example Query
Query with partition filter
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.Columns
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_lTokenId | STRING | Liquidity token identifier for the position. Numeric string representing the unique ID assigned to the liquidity provider’s token. |
in_asset | STRING | Contract address of the asset or token. 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_newLiquidity | STRING | Updated liquidity amount after the operation. Numeric string representation in smallest denomination. |
Sample Data
Sample Data
| address | removed | in_asset | in_amount | log_index | in_lTokenId | block_number | block_timestamp | in_newLiquidity | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0xde3447eb47ecdf9b5f90e7a6960a14663916cee8 | false | 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 | 173005645 | 14 | 3415 | 37315802 | 2022-11-11T20:40:40.000Z | 173077377287500000000 | 0x82c71171b3068c7d170998722d3014e9916cbf153b595c6be706763c70f6481a |
| 0xde3447eb47ecdf9b5f90e7a6960a14663916cee8 | false | 0x0000000000000000000000000000000000000000 | 100000000000000 | 12 | 3414 | 37211912 | 2022-11-11T12:36:51.000Z | 127386500000000000 | 0x23f226ce86b080ae8917ed8eda00571e57f50994567d8427a7068d2f840a4f75 |
| 0xde3447eb47ecdf9b5f90e7a6960a14663916cee8 | false | 0x0000000000000000000000000000000000000000 | 11843335870421714921 | 11 | 127 | 53618127 | 2023-01-17T05:10:28.000Z | 1163826290354067543468800 | 0x10e3fba1c4fb6a6b28a6a42dd3dc1af1ed6289259a37c81f59f94bfc1ea46ed9 |
Example Query
Example Query
Query with partition filter
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.Columns
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_lTokenId | STRING | Liquidity token identifier for the position. Numeric string representing the unique ID assigned to the liquidity provider’s token. |
in_asset | STRING | Contract address of the asset or token. 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_newLiquidity | STRING | Updated liquidity amount after the operation. Numeric string representation in smallest denomination. |
Sample Data
Sample Data
| address | removed | in_asset | in_amount | log_index | in_lTokenId | block_number | block_timestamp | in_newLiquidity | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0xde3447eb47ecdf9b5f90e7a6960a14663916cee8 | false | 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 | 115792089237316195423570985008687907853269984665640564039457 | 11 | 3544 | 91718402 | 2023-05-17T20:03:18.000Z | 693773030951 | 0x1663ac0babe71c13037df02472a7a8afb839d26010b967d1742aed234a17cc2b |
| 0xde3447eb47ecdf9b5f90e7a6960a14663916cee8 | false | 0x0000000000000000000000000000000000000000 | 115792089237316195423570985008687907853269984665640564039457 | 15 | 2087 | 125212067 | 2023-08-26T16:35:57.000Z | 750575335486 | 0xf29d76ae98dd1baac9d52e6bf74237bd0a9c65bb47ee2c9695ea4cedbd56abef |
| 0xde3447eb47ecdf9b5f90e7a6960a14663916cee8 | false | 0x0000000000000000000000000000000000000000 | 115792089237316195423570985008687907853269984665640564039457 | 15 | 272 | 125116369 | 2023-08-26T09:43:51.000Z | 695046357793 | 0xf6c2517198890f293806a19d8316c5fe2b00288b5810ebcd32b3bc7a01b25abb |
Example Query
Example Query
Query with partition filter
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.Columns
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_router | STRING | Address of the router responsible for facilitating the cross-chain transaction. Hex-encoded, 0x-prefixed, 42-character string. |
in_isActive | BOOL | Indicates 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. |
Sample Data
Sample Data
| address | removed | in_router | log_index | in_isActive | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|
| 0xde3447eb47ecdf9b5f90e7a6960a14663916cee8 | false | 0xf4d4583078561c8e2ddbed588db2da179f84a2f5 | 0 | true | 46078060 | 2022-12-14T12:13:25.000Z | 0x8591b26555b81adcb16eedcfa667f9255d8a41c9c1a6cb4299b8a5acfaa074af |
| 0xde3447eb47ecdf9b5f90e7a6960a14663916cee8 | false | 0x8b381e5376f37c1fc1011c02212769b6ea7d8c0c | 0 | true | 46079581 | 2022-12-14T12:20:44.000Z | 0xf12e7a1cea1cfc0095c824a8e8825c801f63fbbcb44ac997a157bbbaeb79f84e |
| 0xde3447eb47ecdf9b5f90e7a6960a14663916cee8 | false | 0x9eb9c0363f41e84c02c425cdb69c88d39e43aad8 | 33 | true | 154894001 | 2023-11-28T11:20:55.000Z | 0xcbf1c46eb8a426ecd7a5e021dd09e5638c9fbb38f5526269d5f35eea74eecb92 |
Example Query
Example Query
Query with partition filter
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.Columns
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_pool | STRING | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string. |
in_account | STRING | Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_tokenId | STRING | Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID. |
in_amount | STRING | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
Sample Data
Sample Data
| address | in_pool | removed | in_amount | log_index | in_account | in_tokenId | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0xae77aa30a077bea1e62616e70c60c56c04dff4e7 | 0xde3447eb47ecdf9b5f90e7a6960a14663916cee8 | false | 164811868169789 | 1 | 0x8e97e11b13f240dba275a5bced2620a72948fd91 | 3288 | 26713016 | 2022-09-26T04:22:55.000Z | 0x796f954ae4227327cb2e3af6f6d98c920be0ae73c257c9d42bb92930cffc1d75 |
| 0xae77aa30a077bea1e62616e70c60c56c04dff4e7 | 0xde3447eb47ecdf9b5f90e7a6960a14663916cee8 | false | 30219870209899920602236 | 1 | 0x092cda2230d41979999fdd210af1b73a7da46ce4 | 16 | 26868911 | 2022-09-26T19:43:29.000Z | 0x1f477d957badfb9b83c75afe796712e9cfca6c220e158a7e93a3cf69bb413389 |
| 0xae77aa30a077bea1e62616e70c60c56c04dff4e7 | 0xde3447eb47ecdf9b5f90e7a6960a14663916cee8 | false | 457076001363396848340616 | 1 | 0xd205ae9a8aa31ba41258e1e4a60145d560f238f1 | 127 | 47435619 | 2022-12-20T01:49:48.000Z | 0x835d884d11fa183accdf80353419ed12a8b54e2a163d1ec6af3eb183d2b2c039 |
Example Query
Example Query
Query with partition filter
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.Columns
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_index | STRING | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27). |
in_timestamp | STRING | Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch. |
in_account | STRING | Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_symbolName | STRING | Trading 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_tradeVolume | STRING | Volume 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_priceLimit | STRING | Slippage 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_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). |
Sample Data
Sample Data
| address | removed | in_index | log_index | in_account | block_number | in_timestamp | in_priceLimit | in_symbolName | in_tradeVolume | block_timestamp | in_executionFee | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0xf4d4583078561c8e2ddbed588db2da179f84a2f5 | false | 1337 | 5 | 0x34dd7c497f4688a25beee118cacabc6a19cb4659 | 62044084 | 1676709793 | 5638737250958313000 | ETHUSD-2000-C | 4000000000000000000 | 2023-02-18T08:43:14.000Z | 200000000000000 | 0x52ee586b1d40b325cc182de6e4b2a220f6ec3453c0d18a409b011b0a8b2b6770 |
| 0xf4d4583078561c8e2ddbed588db2da179f84a2f5 | false | 1336 | 5 | 0x34dd7c497f4688a25beee118cacabc6a19cb4659 | 62042834 | 1676709471 | 5454287110053901000 | ETHUSD-2000-C | 34000000000000000000 | 2023-02-18T08:37:53.000Z | 200000000000000 | 0xe42f0e542c04372a04549bdfdcfe3cf33ff61be78883197bd728506a5e55edf9 |
| 0xf4d4583078561c8e2ddbed588db2da179f84a2f5 | false | 1338 | 5 | 0xf62d357f79ced9ab5b606cd12cb0e9199737271c | 62079425 | 1676718881 | 38127381084202650000 | BTCUSD-30000-C | -120000000000000000 | 2023-02-18T11:14:42.000Z | 200000000000000 | 0xcb6da4f052196147675d960418f86410d33862b485280bd71ca5e08546ba3907 |
Example Query
Example Query
Query with partition filter
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.Columns
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_pTokenId | STRING | Position 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_symbolId | STRING | Unique 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_indexPrice | STRING | Index 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_tradeVolume | STRING | Volume 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_tradeCost | STRING | Cost 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_tradeFee | STRING | Fee 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. |
Sample Data
Sample Data
| address | removed | log_index | in_pTokenId | in_symbolId | in_tradeFee | block_number | in_tradeCost | in_indexPrice | in_tradeVolume | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0x741c8e810cd1c7bab6565e850b775fc33c15c084 | false | 2 | 24 | 0x511e48778041c284afe356f7abd6d073fc97795ec744c3b436c6e86856a5a3b9 | 212140479054500000 | 16020771 | -88061293336618349771 | 21214047905450000000000 | -10000000000000000 | 2022-06-27T06:43:42.000Z | 0x233c0a3a58a8da192d4d4d0ff89524efdc774c24adebdd05e1bfc2d28bddd6e2 |
| 0x741c8e810cd1c7bab6565e850b775fc33c15c084 | false | 2 | 72 | 0x59102b37de83bdda9f38ac8254e596f0d9ac61d2035c07936675e87342817160 | 1119664303277170330 | 16116604 | -1119664303277170330685 | 1194178544580000000000 | -939000000000000000 | 2022-06-27T19:03:03.000Z | 0xdeca5b88dd14d14775accd5a4257ede58ce49481b37da86de7458d56f260fde5 |
| 0x741c8e810cd1c7bab6565e850b775fc33c15c084 | false | 1 | 73 | 0x98fc75eeaf2daf20762fde47b011dc0b9bbc272d057f010223476676501d04f7 | 12147888929642666934 | 16033508 | -809859261976177795638 | 1228403300000000000000 | -50000000000000000000 | 2022-06-27T08:10:25.000Z | 0xdeca1dc0776f906a77be1af1fc7e90451df965129d82c266394998957f2a6bb8 |
Example Query
Example Query
Query with partition filter