debridge_v1_optimism

Tables

DeBridgeGate_PairAdded_event

Event logs recording cross-chain token pair registrations in the deBridge protocol. Contains token addresses, chain identifiers, bridge IDs, maximum transfer amounts, and minimum reserve basis points for each paired asset configuration.

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_debridgeId`	`STRING`	Unique identifier for the deBridge cross-chain bridge pairing or transaction. 66-character hex string including 0x prefix.
`in_tokenAddress`	`STRING`	Token contract address for the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_nativeAddress`	`STRING`	Token address on the original source blockchain for cross-chain bridge operations. Hex-encoded string format varies by blockchain implementation.
`in_nativeChainId`	`STRING`	Blockchain identifier for the token’s native chain in deBridge cross-chain operations. Decimal string representation of the chain ID where the asset originates.
`in_maxAmount`	`STRING`	Maximum allowable amount for the bridge operation. Decimal string representation of a uint256 value.
`in_minReservesBps`	`STRING`	Minimum reserve requirement expressed in basis points (BPS). Decimal string representation of an integer value where 10000 equals 100%.

Sample Data

address	removed	log_index	block_number	in_maxAmount	in_debridgeId	block_timestamp	in_tokenAddress	in_nativeAddress	in_nativeChainId	transaction_hash	in_minReservesBps
0x43de2d77bf8027e25dbd179b491e8d64f38398aa	false	14	116580779	115792089237316195423570985008687907853269984665640564039457584007913129639935	0xbbb413bb5a7c158ec17d5dd73e13a28c30f22247ced216bbd7f34bc945bbe8ec	2024-02-24T07:38:55.000Z	0xdac71a61e1d9757d43f63e7db1c870f83cc1adb6	0x7e1b68d16c4acfdcde38f6eaabebb34eb3d5e2cb	56	0x2be96b4e00b6f868038de434a68f624e69d5ecac303261c7ab8a3fb81df58eff	10000
0x43de2d77bf8027e25dbd179b491e8d64f38398aa	false	4	110067615	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x205bad45ef7cdb9ddd952e827e7bd08f90db44dba571f4c86de41026c05d6446	2023-09-26T13:13:27.000Z	0x94b008aa00579c1307b0ef2c499ad98a8ce58e58	0x94b008aa00579c1307b0ef2c499ad98a8ce58e58	10	0x34f43d584b385af6dd2f3d8f834f556ef2829127ba73be3e8c15e282ccf455e6	10000
0x43de2d77bf8027e25dbd179b491e8d64f38398aa	false	48	108297937	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x20cae6ff4b292652a82bc7612494588850e9efcbb614557c214f5da106352ace	2023-08-16T14:04:11.000Z	0x7f5c764cbc14f9669b88837ca1490cca17c31607	0x7f5c764cbc14f9669b88837ca1490cca17c31607	10	0xf261cae36173ffd86008a436022bfbd93b594301fab23ec155389cfecf7ca55d	10000

Example Query

Query with partition filter

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

DeBridgeGate_Sent_event

Cross-chain bridge transfer initiation events emitted by the deBridge protocol. Records outbound asset transfers with source sender, destination chain identifier, receiver address, transfer amounts, fee parameters, and unique submission identifier for tracking cross-chain transactions.

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_submissionId`	`STRING`	Unique identifier for the cross-chain bridge submission. 66-character hex string including 0x prefix.
`in_debridgeId`	`STRING`	Unique identifier for the deBridge cross-chain bridge pairing or transaction. 66-character hex string including 0x prefix.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_nonce`	`STRING`	Unique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.
`in_chainIdTo`	`STRING`	Destination blockchain identifier for the cross-chain bridge transaction. Numeric string representation of the chain ID.
`in_referralCode`	`STRING`	Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.
`in_feeParams`	`STRUCT<receivedAmount STRING, fixFee STRING, transferFee STRING, useAssetFee BOOL, isNativeToken BOOL>`	Fee structure and payment details for the cross-chain bridge transaction. Contains receivedAmount (total tokens after fees), fixFee (base fee in wei), transferFee (variable fee in smallest denomination), useAssetFee (whether fees are paid in bridged asset), and isNativeToken (whether bridged asset is the chain’s native token).
`in_autoParams`	`STRING`	Automation parameters for cross-chain bridge execution. Hex-encoded byte string containing encoded configuration data for automated processing on the destination chain.
`in_nativeSender`	`STRING`	Address that initiated the cross-chain bridge transaction on the source blockchain. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_nonce	log_index	in_receiver	block_number	in_chainIdTo	in_feeParams	in_autoParams	in_debridgeId	block_timestamp	in_nativeSender	in_submissionId	transaction_hash
0x43de2d77bf8027e25dbd179b491e8d64f38398aa	false	151	10	0xef4fb24ad0916217251f553c0596f8edc630eb66	112335763	59144	{“fixFee”:“1000000000000000”,“transferFee”:“1863533095495”,“useAssetFee”:true,“isNativeToken”:true,“receivedAmount”:“2863533095495495”}	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000069d2b7efe18000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000c00000000000000000000000000000000000000000000000000000000000000014555ce236c0220695b68341bc48c68d52210cc35b00000000000000000000000000000000000000000000000000000000000000000000000000000000000001a46abd4ea70000000000000000000000000000000000000000000000000000000000000040000000000000000000000000555ce236c0220695b68341bc48c68d52210cc35b000000000000000000000000000000000000000000000000000000000000000ae2290a0ecce0e69d07f9f0831c023e01b13b968d08b3ea873133ac0f3c51e3102551430b683738b313600bc786c3e4921d069f58c8907b94ab5ea385bca71082377eaec206b1a8e3c1808319177455a41951397c6cd2fe88a1333b075751fac564787db14704665249bfca7510ec329c4bed64bd8c74967b73f30473ededa29df68945b20e47cb92cb7f00458bd56f0f7de17295dbd32886983892a8332d36f94339973cb25e6de647d8364746d042f0cc3bfef4f61622c676b6c5ac9bd2c76fc77958d5be6af31012bdff07e1d209f5ef01edc5efaf990648b0bea02b343f4981156ca5e30f994c72f529b535b3581d2f297c65df9704d11ab5f23ef60b7d4fad5a2d9deb0cc73da9b7ba4d3d84c7d0b55fad59255ba0f50343f797215e6787575658bfd0bddc52422e9bf6f453a56a24037effb33820f8fb966ee5410c7d7c00000000000000000000000000000000000000000000000000000000	0xa27dbcd48527b17bca5d7f0de61a0325212d9244c0286b2d8a2e33f844f69812	2023-11-18T01:18:23.000Z	0xe7351fd770a37282b91d153ee690b63579d6dd7f	0xa7f4031c6ea623b1cf6f9ac07fbfae3ae6c29f5cb15f3938d985ea4b346428b1	0x27572598339c0afcc28b81a745cf1b19129f623b3a20481f89a651991a8f4509
0x43de2d77bf8027e25dbd179b491e8d64f38398aa	false	157	190	0xef4fb24ad0916217251f553c0596f8edc630eb66	112349067	59144	{“fixFee”:“1000000000000000”,“transferFee”:“1593139455855”,“useAssetFee”:true,“isNativeToken”:true,“receivedAmount”:“2593139455855855”}	0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000005a77f485888000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000c00000000000000000000000000000000000000000000000000000000000000014555ce236c0220695b68341bc48c68d52210cc35b00000000000000000000000000000000000000000000000000000000000000000000000000000000000001a46abd4ea70000000000000000000000000000000000000000000000000000000000000040000000000000000000000000555ce236c0220695b68341bc48c68d52210cc35b000000000000000000000000000000000000000000000000000000000000000a38de9d7acf37931a8d134b576b221c72ef065bbb58f605dcb08f943cafb9f9571c5884e6c9e885880535e70f9b25e6f72dab434f2fc9d47bc29a624f30f9e9e00e3943f8db60aa2a49f7953cf18cff542422c053db852fcefc10d82aa339058c5dbf879922535e38081b34bd5f295b7dd3b9b6c07a865416398aa26873b6d4629f80aab260061ac1374c3bdc8c5e0754b07df4a73772d3c21fdc71dc638b536d989522738332b3e0798d361b855ff48866e25999bea14131721acb559de36378cfd1de217f69252c43df8ffaec6da7fd4ca4f9438bb3961215d662dd058e90dc3b12b4d80e50399379e6de2a1ce4f6961d9b80a58ad64c7ba23211281c2e2b6211293ed418d6756b2c3c08c68d06d3940c83c8097a25dbfe06017c0a176c79b7907ee1e0642286dfb1beb505c6dcd5a473c125c2635bf9fad3294204cd27264e00000000000000000000000000000000000000000000000000000000	0xa27dbcd48527b17bca5d7f0de61a0325212d9244c0286b2d8a2e33f844f69812	2023-11-18T08:41:51.000Z	0xe7351fd770a37282b91d153ee690b63579d6dd7f	0x94c82c1dd37918d16eb7f4c333e263e77cdbffc3b63b88742230284abf2ab5cd	0x21916af6625934538076980bb322948e921d25399810eb7a6907c59afed7d989
0x43de2d77bf8027e25dbd179b491e8d64f38398aa	false	156	8	0xef4fb24ad0916217251f553c0596f8edc630eb66	112348078	42161	{“fixFee”:“1000000000000000”,“transferFee”:“1581726649292”,“useAssetFee”:true,“isNativeToken”:true,“receivedAmount”:“2581726649292792”}	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000059d21036538000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000c00000000000000000000000000000000000000000000000000000000000000014555ce236c0220695b68341bc48c68d52210cc35b00000000000000000000000000000000000000000000000000000000000000000000000000000000000001a46abd4ea70000000000000000000000000000000000000000000000000000000000000040000000000000000000000000555ce236c0220695b68341bc48c68d52210cc35b000000000000000000000000000000000000000000000000000000000000000a3f0279803668c5d89c09d2cd33ea4d51e2d0d0e2faeac2adb7a4db7c891d1a19d2c057d968f343330583ed1afb292c09524c0d267f07b5d98d709b6cdbf229e0b742997300c2905eba96b2e24e2c06a2069d2e08da51c9f8f36c68ae7724e2445b987d3d7a63beaf4945ae7d1be694633c487894e142d3995ed20c060a56deb4306089369d69f21b96a65fc1cd14d6c484a35600ae7e3acdaf7c6806ca8d2965c469af282b66a2046a5f3e05dde4efb6ef078266d6e8618e5828b1cf3b527095efd3a36174d807d51b3495ad7e89309efa9fe3ae98e05b12751b81ad3e52bb39a1976c129a8e7274e83f9bb597002d3752e78d1620e841fc5e22c1d13d23c06c7f42fb69c7f64e025189bff2fe373898d97d94d0b5da026a2230e0f95403ec77743bad66f459676de889938ba42a6f34d6fff72e167ab8488af876ba6794bce100000000000000000000000000000000000000000000000000000000	0xa27dbcd48527b17bca5d7f0de61a0325212d9244c0286b2d8a2e33f844f69812	2023-11-18T08:08:53.000Z	0xe7351fd770a37282b91d153ee690b63579d6dd7f	0xdc3aac049a6329d295d343e3c7f31f84673697e8160ecb7bc9306c21ff7fa8c8	0x147929e0749087905d6f84b31c405d18f3156b9fd87b9276cc27e0d8889086f9

Example Query

Query with partition filter

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

DlnSource_ClaimedUnlock_event

DeBridge DlnSource (Decentralized Liquidity Network Source) ClaimedUnlock event emitted when an order creator claims their original tokens after a cross-chain order cancellation or unlock. Records the order identifier, token amount returned, token contract address, and beneficiary receiving the unlocked funds.

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_orderId`	`STRING`	Unique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations.
`in_beneficiary`	`STRING`	Address that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_giveAmount`	`STRING`	Amount of tokens being transferred or unlocked in the operation. String-encoded integer value representing the token quantity in its smallest unit.
`in_giveTokenAddress`	`STRING`	Contract address of the token being given or unlocked in the cross-chain bridge operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_orderId	block_number	in_giveAmount	in_beneficiary	block_timestamp	transaction_hash	in_giveTokenAddress
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	23	0xe234519bf0eaf94cdf34c199bbf0c3781d6764414839d54a3679747d783a5e85	109582162	55203218339435276	0x555ce236c0220695b68341bc48c68d52210cc35b	2023-09-15T07:31:41.000Z	0x290d8338ae931009f167303ea70c8742b39061a11642b37ebd572facb38d93bd	0x0000000000000000000000000000000000000000
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	18	0x3a3611a838848caee8a7f674866a35c2527a43492323b39e1768985f05625099	109582162	38366664042990405	0x555ce236c0220695b68341bc48c68d52210cc35b	2023-09-15T07:31:41.000Z	0x290d8338ae931009f167303ea70c8742b39061a11642b37ebd572facb38d93bd	0x0000000000000000000000000000000000000000
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	24	0x10cb04e15b13217cc284e39c68b8ebca08d1fccd1e60d0916a28aa9fc4b33a39	109582162	227129182920274070	0x555ce236c0220695b68341bc48c68d52210cc35b	2023-09-15T07:31:41.000Z	0x290d8338ae931009f167303ea70c8742b39061a11642b37ebd572facb38d93bd	0x0000000000000000000000000000000000000000

Example Query

Query with partition filter

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

DlnSource_CreatedOrder_event

Cross-chain order creation events from deBridge DLN (Deswap Liquidity Network) source contracts containing Request-for-Quote (RFQ) order parameters, fee structures, and routing metadata. Used for tracking intent-based cross-chain swap requests and order lifecycle 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_order`	`STRUCT<makerOrderNonce STRING, makerSrc STRING, giveChainId STRING, giveTokenAddress STRING, giveAmount STRING, takeChainId STRING, takeTokenAddress STRING, takeAmount STRING, receiverDst STRING, givePatchAuthoritySrc STRING, orderAuthorityAddressDst STRING, allowedTakerDst STRING, allowedCancelBeneficiarySrc STRING, externalCall STRING>`	Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.
`in_orderId`	`STRING`	Unique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations.
`in_affiliateFee`	`STRING`	Fee paid to an affiliate for referring the transaction. Hex-encoded bytes value representing the affiliate address and fee amount.
`in_nativeFixFee`	`STRING`	Fixed fee amount denominated in the chain’s native token. String-encoded integer representing the fee charged in wei (for EVM chains) or smallest token unit.
`in_percentFee`	`STRING`	Percentage-based fee amount charged on the order. String-encoded integer representing the fee in basis points or smallest fee unit.
`in_referralCode`	`STRING`	Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.
`in_metadata`	`STRING`	Metadata payload associated with the operation. Hex-encoded bytes containing protocol-specific auxiliary data such as action identifiers, addresses, amounts, and configuration parameters.

Sample Data

address	removed	in_order	log_index	in_orderId	in_metadata	block_number	in_percentFee	block_timestamp	in_affiliateFee	in_nativeFixFee	in_referralCode	transaction_hash
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	{“makerSrc”:“0x76a57421735b2313f0b114d127532f8b2f00ab87”,“giveAmount”:“3965501408359007”,“takeAmount”:“3496856913679734”,“giveChainId”:“10”,“receiverDst”:“0x76a57421735b2313f0b114d127532f8b2f00ab87”,“takeChainId”:“59144”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“0”,“giveTokenAddress”:“0x0000000000000000000000000000000000000000”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0x76a57421735b2313f0b114d127532f8b2f00ab87”,“orderAuthorityAddressDst”:“0x76a57421735b2313f0b114d127532f8b2f00ab87”,“allowedCancelBeneficiarySrc”:“0x”}	0	0x81c5f94bc122620438c1968b9f2e6bf9ebc0e0c379ad803fa965f2c3996ff857	0x	110808330	1586835297462	2023-10-13T16:43:57.000Z	0x	1000000000000000	4564	0x7c563fcc5facbbc35344f4605f0101ac1b66a6acbb480e71f9c8e1df4be93889
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	{“makerSrc”:“0xecaf401a100ff4e390075a5d45f7db021f90a0e4”,“giveAmount”:“150352403128541112”,“takeAmount”:“149879694011486262”,“giveChainId”:“10”,“receiverDst”:“0xecaf401a100ff4e390075a5d45f7db021f90a0e4”,“takeChainId”:“42161”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“0”,“giveTokenAddress”:“0x0000000000000000000000000000000000000000”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0xecaf401a100ff4e390075a5d45f7db021f90a0e4”,“orderAuthorityAddressDst”:“0xecaf401a100ff4e390075a5d45f7db021f90a0e4”,“allowedCancelBeneficiarySrc”:“0x”}	0	0x1f310569767cabb689cf7d6713de90f35957ff2cc50719423e00792762ff7fb3	0x	110807607	60165027262321	2023-10-13T16:19:51.000Z	0x	1000000000000000	4850	0xa08190fc1cce2ce3aa2f4b02cad5de15421e176c4739620fbf4baa377fbab5cc
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	{“makerSrc”:“0x82af599ae8a62842da38be6e5d4b14cd5882bddb”,“giveAmount”:“365541963447165445”,“takeAmount”:“365253457441211656”,“giveChainId”:“10”,“receiverDst”:“0x82af599ae8a62842da38be6e5d4b14cd5882bddb”,“takeChainId”:“8453”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“2”,“giveTokenAddress”:“0x0000000000000000000000000000000000000000”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0x82af599ae8a62842da38be6e5d4b14cd5882bddb”,“orderAuthorityAddressDst”:“0x82af599ae8a62842da38be6e5d4b14cd5882bddb”,“allowedCancelBeneficiarySrc”:“0x”}	88	0x92db47bda75630281500e999df64370894b5c73e9d5eb6227ad41ca7b206371c	0x	110791028	146275295497065	2023-10-13T07:07:13.000Z	0x	1000000000000000	4850	0x7dbc78d4bebac8a147355b7f296287c004f28dd91b9f46b8b0af2bd02b0af0d0

Example Query

Query with partition filter

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

DlnSourceV1_CreatedOrder_event

Cross-chain order creation events from DeBridge’s DLN (Debridge Liquidity Network) RFQ (Request-for-Quote) protocol. Contains order parameters including source/destination chains, token addresses, amounts, fees, maker addresses, and order identifiers for tracking cross-chain token swaps.

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_order`	`STRUCT<makerOrderNonce STRING, makerSrc STRING, giveChainId STRING, giveTokenAddress STRING, giveAmount STRING, takeChainId STRING, takeTokenAddress STRING, takeAmount STRING, receiverDst STRING, givePatchAuthoritySrc STRING, orderAuthorityAddressDst STRING, allowedTakerDst STRING, allowedCancelBeneficiarySrc STRING, externalCall STRING>`	Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.
`in_orderId`	`STRING`	Unique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations.
`in_affiliateFee`	`STRING`	Fee paid to an affiliate for referring the transaction. Hex-encoded bytes value representing the affiliate address and fee amount.
`in_nativeFixFee`	`STRING`	Fixed fee amount denominated in the chain’s native token. String-encoded integer representing the fee charged in wei (for EVM chains) or smallest token unit.
`in_percentFee`	`STRING`	Percentage-based fee amount charged on the order. String-encoded integer representing the fee in basis points or smallest fee unit.
`in_referralCode`	`STRING`	Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.

Sample Data

address	removed	in_order	log_index	in_orderId	block_number	in_percentFee	block_timestamp	in_affiliateFee	in_nativeFixFee	in_referralCode	transaction_hash
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	{“makerSrc”:“0xa41c6cd53775302e71fc8f3d7d836880a5732148”,“giveAmount”:“2664022102861139”,“takeAmount”:“2497868356489195”,“giveChainId”:“10”,“receiverDst”:“0xa41c6cd53775302e71fc8f3d7d836880a5732148”,“takeChainId”:“8453”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“0”,“giveTokenAddress”:“0x0000000000000000000000000000000000000000”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0xa41c6cd53775302e71fc8f3d7d836880a5732148”,“orderAuthorityAddressDst”:“0xa41c6cd53775302e71fc8f3d7d836880a5732148”,“allowedCancelBeneficiarySrc”:“0x”}	0	0x135621ef3cecec9dc008cdc797d1629a37a1a40a80d22291e98909c14b692ae6	108905824	1066035255246	2023-08-30T15:47:05.000Z	0x	1000000000000000	4850	0x5a7e31a40dacf9927e017b55f783563e4f4d73732f38b09a40ddbe377febc56a
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	{“makerSrc”:“0x598593527f8eab1c475bd15697dba6456cc11436”,“giveAmount”:“798740601”,“takeAmount”:“798361426”,“giveChainId”:“10”,“receiverDst”:“0x598593527f8eab1c475bd15697dba6456cc11436”,“takeChainId”:“137”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“0”,“giveTokenAddress”:“0x7f5c764cbc14f9669b88837ca1490cca17c31607”,“takeTokenAddress”:“0x2791bca1f2de4661ed88a30c99a7a9449aa84174”,“givePatchAuthoritySrc”:“0x598593527f8eab1c475bd15697dba6456cc11436”,“orderAuthorityAddressDst”:“0x598593527f8eab1c475bd15697dba6456cc11436”,“allowedCancelBeneficiarySrc”:“0x”}	12	0xdf77a52b12fec69456747fc58b99657d1505bb06813c3611aa2a5524c86ad670	108901318	319624	2023-08-30T13:16:53.000Z	0x	1000000000000000	4992	0x821f515f95b1a1154388aa4e028849aff45a30455d71748daa4c8de929862341
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	{“makerSrc”:“0x49a0008ded58fbd1754087ae99b61a82eef88dc7”,“giveAmount”:“26135873”,“takeAmount”:“25162863”,“giveChainId”:“10”,“receiverDst”:“0x49a0008ded58fbd1754087ae99b61a82eef88dc7”,“takeChainId”:“42161”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“0”,“giveTokenAddress”:“0x7f5c764cbc14f9669b88837ca1490cca17c31607”,“takeTokenAddress”:“0xff970a61a04b1ca14834a43f5de4533ebddb5cc8”,“givePatchAuthoritySrc”:“0x49a0008ded58fbd1754087ae99b61a82eef88dc7”,“orderAuthorityAddressDst”:“0x49a0008ded58fbd1754087ae99b61a82eef88dc7”,“allowedCancelBeneficiarySrc”:“0x”}	14	0xb605a82401638156838603f52c6aec63057a52885f0b81854ec48d0de3dc84c3	108879208	10458	2023-08-30T00:59:53.000Z	0x	1000000000000000	4850	0xf93585283d008161f8bf6513200e07dfb3b14453968b17352ea67eb758f4b2a6

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

DeBridgeGate_PairAdded_event

DeBridgeGate_Sent_event

DlnSource_ClaimedUnlock_event

DlnSource_CreatedOrder_event

DlnSourceV1_CreatedOrder_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​DeBridgeGate_PairAdded_event

​DeBridgeGate_Sent_event

​DlnSource_ClaimedUnlock_event

​DlnSource_CreatedOrder_event

​DlnSourceV1_CreatedOrder_event

Tables

DeBridgeGate_PairAdded_event

DeBridgeGate_Sent_event

DlnSource_ClaimedUnlock_event

DlnSource_CreatedOrder_event

DlnSourceV1_CreatedOrder_event