Tables
DToken_DLT_Transfer_event
NFT transfer events from Deriprotocol v3 DToken contracts on BSC, tracking movement of position tokens including mints (from zero address), transfers, and burns with unique token IDs. Used for analyzing liquidity provider position ownership changes and protocol participation 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 |
|---|---|---|---|---|---|---|---|---|
| 0x2923453ed0c0b12a1b1f1a6aff93aa216a8fe608 | 0xc5b1de3769921e8b43222e3c221ab495193440c0 | 0x0000000000000000000000000000000000000000 | false | 225 | 179 | 15158895 | 2022-02-11T09:25:12.000Z | 0x94bb539f4285e1887fe9a75f8e49e5af17ff99431b56c2f95634c7b226f95ddf |
| 0x4456819f46fc22f1ab6b5884612e488fbfacafb4 | 0x249aa77f25f298d3775c638686a43706d9821a56 | 0x0000000000000000000000000000000000000000 | false | 231 | 46 | 15154475 | 2022-02-11T05:43:39.000Z | 0xcf1126c353db722d7fa880f949d773bd54cbfef454367f0f4dd7c55df9f15a5e |
| 0xfa7b0442405c3a391fed80b29485f4cc3a3440ed | 0xc5b1de3769921e8b43222e3c221ab495193440c0 | 0x0000000000000000000000000000000000000000 | false | 175 | 316 | 28385738 | 2023-05-20T20:55:23.000Z | 0x1d9189dd40ccf7063bf544e8175806004f10bfaff88a9237d64f39206f3cdbbf |
Example Query
Example Query
Query with partition filter
DToken_DPT_Transfer_event
DToken (DPT) transfer events from Deri Protocol v3 on BNB Smart Chain, tracking NFT-style position token movements with zero-address minting indicating new position creation. Useful for analyzing trader position lifecycle and ownership changes in Deri’s derivatives markets.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 |
|---|---|---|---|---|---|---|---|---|
| 0xb23dc06ad3faf15615b0487e54876d8aff5cec93 | 0x25d5ad687068799739ff7b0e18c7cbff403acb64 | 0x0000000000000000000000000000000000000000 | false | 431 | 162 | 18167312 | 2022-05-27T13:16:03.000Z | 0xd9d42190e00e2eb342401d1543741e5e784cd33749a4d1122398be7e04d9f985 |
| 0x2dc9b88e57cda3f801889775d660d69a6ee245bc | 0x25d5ad687068799739ff7b0e18c7cbff403acb64 | 0x0000000000000000000000000000000000000000 | false | 68 | 160 | 18158527 | 2022-05-27T05:55:48.000Z | 0x21d56f71dd0abe8a030fe9a5c21f5735017c535b831b189d5f7ab8229c113e90 |
| 0xca6974d32186a3210fa005efaa8d1f267b0afd01 | 0x25d5ad687068799739ff7b0e18c7cbff403acb64 | 0x0000000000000000000000000000000000000000 | false | 143 | 161 | 18163659 | 2022-05-27T10:13:10.000Z | 0xde93546f21f24bc7b3835591a8d4feddfd7f609223fcf1b7ac764b0cb8c4fecd |
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_underlying | STRING | Contract address of the underlying asset. 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_amount | log_index | in_lTokenId | block_number | in_underlying | block_timestamp | in_newLiquidity | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0xd2d950e338478ef7feb092f840920b3482fcac40 | false | 2045163935049821872570 | 92 | 52 | 15598455 | 0xe9e7cea3dedca5984780bafc599bd69add087d56 | 2022-02-26T16:54:20.000Z | 211920452483565045124928 | 0x200f835a9229c38f89d83f5824e27e616268e7905c4a74876d3beb12411fa23d |
| 0xd2d950e338478ef7feb092f840920b3482fcac40 | false | 50000000000000000000 | 163 | 55 | 15603198 | 0x0000000000000000000000000000000000000000 | 2022-02-26T20:52:47.000Z | 37636385744839213855710 | 0xcb86a4d7f1d9615b23e82d0c79bfc00fe7af15fcf44ca4803d01703312ce702c |
| 0xd2d950e338478ef7feb092f840920b3482fcac40 | false | 50000000000000000000 | 91 | 55 | 15602496 | 0x0000000000000000000000000000000000000000 | 2022-02-26T20:17:41.000Z | 18760454451972860028485 | 0x4c78cfade9cb25616d2c2eb0f0ba356bf84fc6afdee47e528e41ca86617d8dc2 |
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_underlying | STRING | Contract address of the underlying asset. 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_amount | log_index | in_lTokenId | block_number | in_underlying | block_timestamp | in_newLiquidity | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0x1ef92eda3cfeefb8dae0db4507f860d3b73f29ba | false | 115792089237316195423570985008687907853269984665640564039457 | 232 | 177 | 27801891 | 0xe60eaf5a997dfae83739e035b005a33afdcc6df5 | 2023-04-30T13:37:36.000Z | 0 | 0x2005b901b9252adf7b920a00776cc044b75cf2bc495e97f4d41f21fc9b230160 |
| 0x243681b8cd79e3823ff574e07b2378b8ab292c1e | false | 115792089237316195423570985008687907853269984665640564039457 | 166 | 197 | 27801501 | 0x0000000000000000000000000000000000000000 | 2023-04-30T13:18:06.000Z | 62508786326227861265912 | 0xc998da27aedd73a92378cef094c96a4f1edb8b30a98ffc5c24d1eb615f27e699 |
| 0x243681b8cd79e3823ff574e07b2378b8ab292c1e | false | 115792089237316195423570985008687907853269984665640564039457 | 257 | 252 | 19552253 | 0x0000000000000000000000000000000000000000 | 2022-07-14T19:52:05.000Z | 9995992651573961762 | 0xcdfbbf7ffaf5a56075fcc47bcee138beb7abf6d880daa45b6d097479d77b147a |
Example Query
Example Query
Query with partition filter
Pool_SetRouter_event
Router authorization events from Deriprotocol v3 pools on BSC, tracking which router addresses are granted or revoked access to interact with specific pool contracts. Used for monitoring protocol access control changes and authorized trading infrastructure.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 | Router activation status flag indicating whether the specified router address is enabled or disabled for the pool. All sample values show true, indicating routers are activated when this event is emitted. |
Sample Data
Sample Data
| address | removed | in_router | log_index | in_isActive | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|
| 0xd2d950e338478ef7feb092f840920b3482fcac40 | false | 0x41a1ea273a68a9bd8713c2081bdd44dc05cdb961 | 32 | true | 23896374 | 2022-12-14T11:54:42.000Z | 0xa154e75d0cd6abd2092d409c593fd6ff61a0a5fc13c9c1281644379d68875747 |
| 0x243681b8cd79e3823ff574e07b2378b8ab292c1e | false | 0xf0eec79f8ad4de9a011fcce21636da5a471f1059 | 106 | true | 23896511 | 2022-12-14T12:01:46.000Z | 0x2551c6261f8fc76a07db29eb5b2ee2762abc7db4794af608aca8572da2475070 |
| 0x243681b8cd79e3823ff574e07b2378b8ab292c1e | false | 0xfd7e8a3e9a5dae6b38e761819ac68b7a2546f7e0 | 116 | true | 23896850 | 2022-12-14T12:18:43.000Z | 0x0a6a977ec75229362d8cfc17216a20998df907619093b8eb21da25b72e0c5295 |
Example Query
Example Query
Query with partition filter
RewardVault_Claim_event
Reward claim events from Deriprotocol V3 on BSC where liquidity providers withdraw earned rewards from specific pools. Tracks claimed amounts, token IDs, and recipient accounts for analyzing yield distribution and LP reward collection 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_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 |
|---|---|---|---|---|---|---|---|---|---|
| 0x57b2cfac46f0521957929a70ae6fadcef2297740 | 0x1ef92eda3cfeefb8dae0db4507f860d3b73f29ba | false | 280424106880231487847 | 127 | 0x90cf5124d8dcecf9d4d5314cd986cde622a5fae3 | 8 | 19791791 | 2022-07-23T04:07:23.000Z | 0xdc4efeb0c040856b01b4dfeb844d82aa375fcbf2b42573cef481119f71603f8d |
| 0x57b2cfac46f0521957929a70ae6fadcef2297740 | 0xd2d950e338478ef7feb092f840920b3482fcac40 | false | 338394687630340673834 | 226 | 0x0dec29dca1d96d01a6d7a971fdd10cbdd99469b3 | 82 | 24935025 | 2023-01-19T23:53:11.000Z | 0x1ee2acdf7b38d4f5fe53847a54f870668f33d7ccc4f830c1ca1b9197e30b38d9 |
| 0x57b2cfac46f0521957929a70ae6fadcef2297740 | 0x1ef92eda3cfeefb8dae0db4507f860d3b73f29ba | false | 169357435227824635853 | 235 | 0x4f3a4e4aabb85a373dc00b08ff7a196017a55e8d | 9 | 30209758 | 2023-07-23T08:51:19.000Z | 0x4cfe62169475a3457feb79d46ddd85368f86865bd194f92881abca697ffde738 |
Example Query
Example Query
Query with partition filter
Router_ExecuteTrade_event
Trade execution events from Deribit Protocol V3 options trading on BSC, capturing options trades with strike prices, volumes, and execution fees. Used for analyzing options trading activity including call/put positions (e.g., BTCUSD-60000-C) and power perpetuals (BTC^2).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 symbol identifier for the derivative contract, typically formatted as underlying-strike-type (e.g., BTCUSD-20000-P for a Bitcoin put option with $20,000 strike). May also include power perpetuals (BTC^2) and other structured products. |
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 | Maximum acceptable price for the trade execution, denominated in the protocol’s internal price units. Can be positive or negative depending on trade direction (long/short), with larger absolute values indicating less restrictive price constraints. |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0xf0eec79f8ad4de9a011fcce21636da5a471f1059 | false | 953 | 101 | 0x168fef2fd1af371625b2593468620185cea904ff | 25351084 | 1675439628 | 33504579002853 | BTCUSD-60000-C | -12816400000000000000 | 2023-02-03T15:53:57.000Z | 3000000000000000 | 0xbe5cc1286290122e861027f56e2d8d7d97770075f9c60f4979d7c279378330e8 |
| 0xf0eec79f8ad4de9a011fcce21636da5a471f1059 | false | 952 | 48 | 0x168fef2fd1af371625b2593468620185cea904ff | 25351042 | 1675439505 | 45733081437962 | BTCUSD-60000-C | -4000000000000000000 | 2023-02-03T15:51:51.000Z | 3000000000000000 | 0x6f5fe0fc50a46bb7b93c049ec547a43fb108055d3ca4175d6b5b9c2c1a9f3259 |
| 0xf0eec79f8ad4de9a011fcce21636da5a471f1059 | false | 954 | 177 | 0x168fef2fd1af371625b2593468620185cea904ff | 25351095 | 1675439667 | -51229721456561 | BTCUSD-50000-C | -1000000000000000000 | 2023-02-03T15:54:30.000Z | 3000000000000000 | 0xc03b0456918a12eff37db1138edcac6fc4d0175d4aa481e33d613d7f69d62b50 |
Example Query
Example Query
Query with partition filter
SymbolManager_Trade_event
Trade execution events from Deriprotocol V3 derivatives platform on BSC, capturing perpetual futures trades with volume, cost, fees, and index prices per position token and symbol. Enables analysis of trading activity, fee generation, and price execution across different derivative markets.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 within Deriprotocol’s system. Numeric values typically range from single digits to double digits as seen in sample data. |
in_symbolId | STRING | Unique hash identifier for the trading symbol or derivative instrument being traded in the Deri Protocol. 64-character hex string (without 0x prefix) that remains consistent across trades of the same symbol. |
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 | Dollar value of the trade’s profit or loss, denominated in the position token. Values are wei-denominated integers and can be negative for losing trades. |
in_tradeFee | STRING | Fee charged for executing this trade on the Deriprotocol derivatives platform. Values are in wei (smallest token unit), with -1 indicating fee rebates or maker rewards. |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0x8bb7ec8fb31dd6d33d9b71c1bd407f883cac7a91 | false | 137 | 3 | 0xde1a79a8e08af5e6726310ecba443b85c6eb918e886e90431b5b9fa5464f87ce | 57660179271518428146 | 20595018 | 3844011951434561876461 | 1634290000000000000000 | 225000000000000000000 | 2022-08-20T02:52:16.000Z | 0x38c5edd9a866bcc782835c928999d1be240b5a90a1e08dd4541ff83bcf7fc735 |
| 0x543a9fa25ba9a16612274dd707ac4462ed6988fa | false | 82 | 4 | 0xde1a79a8e08af5e6726310ecba443b85c6eb918e886e90431b5b9fa5464f87ce | -1 | 20616653 | 396728813961732583769 | 1544010000000000000000 | 40000000000000000000 | 2022-08-20T20:54:01.000Z | 0xfb0480689701e3c1bc8426f376513e8263347be2b5c3547df4a4f81464945dde |
| 0x543a9fa25ba9a16612274dd707ac4462ed6988fa | false | 81 | 4 | 0x923b625f04202e6072bdc8db2599543123daa8c2d2ff39066064cb6103530d27 | -1 | 20616653 | 18585017480738364520626 | 1544010000000000000000 | 40000000000000000000 | 2022-08-20T20:54:01.000Z | 0xfb0480689701e3c1bc8426f376513e8263347be2b5c3547df4a4f81464945dde |
Example Query
Example Query
Query with partition filter