Skip to main content

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.
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
0x2923453ed0c0b12a1b1f1a6aff93aa216a8fe6080xc5b1de3769921e8b43222e3c221ab495193440c00x0000000000000000000000000000000000000000false225179151588952022-02-11T09:25:12.000Z0x94bb539f4285e1887fe9a75f8e49e5af17ff99431b56c2f95634c7b226f95ddf
0x4456819f46fc22f1ab6b5884612e488fbfacafb40x249aa77f25f298d3775c638686a43706d9821a560x0000000000000000000000000000000000000000false23146151544752022-02-11T05:43:39.000Z0xcf1126c353db722d7fa880f949d773bd54cbfef454367f0f4dd7c55df9f15a5e
0xfa7b0442405c3a391fed80b29485f4cc3a3440ed0xc5b1de3769921e8b43222e3c221ab495193440c00x0000000000000000000000000000000000000000false175316283857382023-05-20T20:55:23.000Z0x1d9189dd40ccf7063bf544e8175806004f10bfaff88a9237d64f39206f3cdbbf
Query with partition filter
SELECT *
FROM `tt-contracts.deriprotocol_v3_bsc.DToken_DLT_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
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
0xb23dc06ad3faf15615b0487e54876d8aff5cec930x25d5ad687068799739ff7b0e18c7cbff403acb640x0000000000000000000000000000000000000000false431162181673122022-05-27T13:16:03.000Z0xd9d42190e00e2eb342401d1543741e5e784cd33749a4d1122398be7e04d9f985
0x2dc9b88e57cda3f801889775d660d69a6ee245bc0x25d5ad687068799739ff7b0e18c7cbff403acb640x0000000000000000000000000000000000000000false68160181585272022-05-27T05:55:48.000Z0x21d56f71dd0abe8a030fe9a5c21f5735017c535b831b189d5f7ab8229c113e90
0xca6974d32186a3210fa005efaa8d1f267b0afd010x25d5ad687068799739ff7b0e18c7cbff403acb640x0000000000000000000000000000000000000000false143161181636592022-05-27T10:13:10.000Z0xde93546f21f24bc7b3835591a8d4feddfd7f609223fcf1b7ac764b0cb8c4fecd
Query with partition filter
SELECT *
FROM `tt-contracts.deriprotocol_v3_bsc.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_underlyingSTRINGContract address of the underlying asset. 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_amountlog_indexin_lTokenIdblock_numberin_underlyingblock_timestampin_newLiquiditytransaction_hash
0xd2d950e338478ef7feb092f840920b3482fcac40false20451639350498218725709252155984550xe9e7cea3dedca5984780bafc599bd69add087d562022-02-26T16:54:20.000Z2119204524835650451249280x200f835a9229c38f89d83f5824e27e616268e7905c4a74876d3beb12411fa23d
0xd2d950e338478ef7feb092f840920b3482fcac40false5000000000000000000016355156031980x00000000000000000000000000000000000000002022-02-26T20:52:47.000Z376363857448392138557100xcb86a4d7f1d9615b23e82d0c79bfc00fe7af15fcf44ca4803d01703312ce702c
0xd2d950e338478ef7feb092f840920b3482fcac40false500000000000000000009155156024960x00000000000000000000000000000000000000002022-02-26T20:17:41.000Z187604544519728600284850x4c78cfade9cb25616d2c2eb0f0ba356bf84fc6afdee47e528e41ca86617d8dc2
Query with partition filter
SELECT *
FROM `tt-contracts.deriprotocol_v3_bsc.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_underlyingSTRINGContract address of the underlying asset. 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_amountlog_indexin_lTokenIdblock_numberin_underlyingblock_timestampin_newLiquiditytransaction_hash
0x1ef92eda3cfeefb8dae0db4507f860d3b73f29bafalse115792089237316195423570985008687907853269984665640564039457232177278018910xe60eaf5a997dfae83739e035b005a33afdcc6df52023-04-30T13:37:36.000Z00x2005b901b9252adf7b920a00776cc044b75cf2bc495e97f4d41f21fc9b230160
0x243681b8cd79e3823ff574e07b2378b8ab292c1efalse115792089237316195423570985008687907853269984665640564039457166197278015010x00000000000000000000000000000000000000002023-04-30T13:18:06.000Z625087863262278612659120xc998da27aedd73a92378cef094c96a4f1edb8b30a98ffc5c24d1eb615f27e699
0x243681b8cd79e3823ff574e07b2378b8ab292c1efalse115792089237316195423570985008687907853269984665640564039457257252195522530x00000000000000000000000000000000000000002022-07-14T19:52:05.000Z99959926515739617620xcdfbbf7ffaf5a56075fcc47bcee138beb7abf6d880daa45b6d097479d77b147a
Query with partition filter
SELECT *
FROM `tt-contracts.deriprotocol_v3_bsc.Pool_RemoveLiquidity_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
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_isActiveBOOLRouter 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.
addressremovedin_routerlog_indexin_isActiveblock_numberblock_timestamptransaction_hash
0xd2d950e338478ef7feb092f840920b3482fcac40false0x41a1ea273a68a9bd8713c2081bdd44dc05cdb96132true238963742022-12-14T11:54:42.000Z0xa154e75d0cd6abd2092d409c593fd6ff61a0a5fc13c9c1281644379d68875747
0x243681b8cd79e3823ff574e07b2378b8ab292c1efalse0xf0eec79f8ad4de9a011fcce21636da5a471f1059106true238965112022-12-14T12:01:46.000Z0x2551c6261f8fc76a07db29eb5b2ee2762abc7db4794af608aca8572da2475070
0x243681b8cd79e3823ff574e07b2378b8ab292c1efalse0xfd7e8a3e9a5dae6b38e761819ac68b7a2546f7e0116true238968502022-12-14T12:18:43.000Z0x0a6a977ec75229362d8cfc17216a20998df907619093b8eb21da25b72e0c5295
Query with partition filter
SELECT *
FROM `tt-contracts.deriprotocol_v3_bsc.Pool_SetRouter_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
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
0x57b2cfac46f0521957929a70ae6fadcef22977400x1ef92eda3cfeefb8dae0db4507f860d3b73f29bafalse2804241068802314878471270x90cf5124d8dcecf9d4d5314cd986cde622a5fae38197917912022-07-23T04:07:23.000Z0xdc4efeb0c040856b01b4dfeb844d82aa375fcbf2b42573cef481119f71603f8d
0x57b2cfac46f0521957929a70ae6fadcef22977400xd2d950e338478ef7feb092f840920b3482fcac40false3383946876303406738342260x0dec29dca1d96d01a6d7a971fdd10cbdd99469b382249350252023-01-19T23:53:11.000Z0x1ee2acdf7b38d4f5fe53847a54f870668f33d7ccc4f830c1ca1b9197e30b38d9
0x57b2cfac46f0521957929a70ae6fadcef22977400x1ef92eda3cfeefb8dae0db4507f860d3b73f29bafalse1693574352278246358532350x4f3a4e4aabb85a373dc00b08ff7a196017a55e8d9302097582023-07-23T08:51:19.000Z0x4cfe62169475a3457feb79d46ddd85368f86865bd194f92881abca697ffde738
Query with partition filter
SELECT *
FROM `tt-contracts.deriprotocol_v3_bsc.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 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).
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 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_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_priceLimitSTRINGMaximum 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_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
0xf0eec79f8ad4de9a011fcce21636da5a471f1059false9531010x168fef2fd1af371625b2593468620185cea904ff25351084167543962833504579002853BTCUSD-60000-C-128164000000000000002023-02-03T15:53:57.000Z30000000000000000xbe5cc1286290122e861027f56e2d8d7d97770075f9c60f4979d7c279378330e8
0xf0eec79f8ad4de9a011fcce21636da5a471f1059false952480x168fef2fd1af371625b2593468620185cea904ff25351042167543950545733081437962BTCUSD-60000-C-40000000000000000002023-02-03T15:51:51.000Z30000000000000000x6f5fe0fc50a46bb7b93c049ec547a43fb108055d3ca4175d6b5b9c2c1a9f3259
0xf0eec79f8ad4de9a011fcce21636da5a471f1059false9541770x168fef2fd1af371625b2593468620185cea904ff253510951675439667-51229721456561BTCUSD-50000-C-10000000000000000002023-02-03T15:54:30.000Z30000000000000000xc03b0456918a12eff37db1138edcac6fc4d0175d4aa481e33d613d7f69d62b50
Query with partition filter
SELECT *
FROM `tt-contracts.deriprotocol_v3_bsc.Router_ExecuteTrade_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
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 within Deriprotocol’s system. Numeric values typically range from single digits to double digits as seen in sample data.
in_symbolIdSTRINGUnique 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_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_tradeCostSTRINGDollar 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_tradeFeeSTRINGFee 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.
addressremovedlog_indexin_pTokenIdin_symbolIdin_tradeFeeblock_numberin_tradeCostin_indexPricein_tradeVolumeblock_timestamptransaction_hash
0x8bb7ec8fb31dd6d33d9b71c1bd407f883cac7a91false13730xde1a79a8e08af5e6726310ecba443b85c6eb918e886e90431b5b9fa5464f87ce5766017927151842814620595018384401195143456187646116342900000000000000002250000000000000000002022-08-20T02:52:16.000Z0x38c5edd9a866bcc782835c928999d1be240b5a90a1e08dd4541ff83bcf7fc735
0x543a9fa25ba9a16612274dd707ac4462ed6988fafalse8240xde1a79a8e08af5e6726310ecba443b85c6eb918e886e90431b5b9fa5464f87ce-1206166533967288139617325837691544010000000000000000400000000000000000002022-08-20T20:54:01.000Z0xfb0480689701e3c1bc8426f376513e8263347be2b5c3547df4a4f81464945dde
0x543a9fa25ba9a16612274dd707ac4462ed6988fafalse8140x923b625f04202e6072bdc8db2599543123daa8c2d2ff39066064cb6103530d27-120616653185850174807383645206261544010000000000000000400000000000000000002022-08-20T20:54:01.000Z0xfb0480689701e3c1bc8426f376513e8263347be2b5c3547df4a4f81464945dde
Query with partition filter
SELECT *
FROM `tt-contracts.deriprotocol_v3_bsc.SymbolManager_Trade_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100