Skip to main content

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.
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_debridgeIdSTRINGUnique identifier for the deBridge cross-chain bridge pairing or transaction. 66-character hex string including 0x prefix.
in_tokenAddressSTRINGToken contract address for the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_nativeAddressSTRINGToken address on the original source blockchain for cross-chain bridge operations. Hex-encoded string format varies by blockchain implementation.
in_nativeChainIdSTRINGBlockchain identifier for the token’s native chain in deBridge cross-chain operations. Decimal string representation of the chain ID where the asset originates.
in_maxAmountSTRINGMaximum allowable amount for the bridge operation. Decimal string representation of a uint256 value.
in_minReservesBpsSTRINGMinimum reserve requirement expressed in basis points (BPS). Decimal string representation of an integer value where 10000 equals 100%.
addressremovedlog_indexblock_numberin_maxAmountin_debridgeIdblock_timestampin_tokenAddressin_nativeAddressin_nativeChainIdtransaction_hashin_minReservesBps
0xc1656b63d9eeba6d114f6be19565177893e5bcbffalse6581486501157920892373161954235709850086879078532699846656405640394575840079131296399350x7d1511334ce12fb83d193e47e7cbd709b1498bfa5b3de9353735eaf74206df2e2023-12-20T15:37:27.000Z0xd3d977f1d8cc7bf4ab4e7748614ad681f029176a0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9421610x97a156ce0c691f150c534c593c6d2f5713ac2880205ed83136f71208edd9bf6110000
0xc1656b63d9eeba6d114f6be19565177893e5bcbffalse3822611901157920892373161954235709850086879078532699846656405640394575840079131296399350xf93982a76d8e8739fd39d418ca95d6d90f344b45e05ad231c2069a6a0eef7ea12023-08-06T08:48:47.000Z0x9fb9b8c43232fbe999b5b66c2050ea6c70353c960xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c560xabf42edcfc99ca502eab02f8478bcb5b85147150e9e44e1f0abd29eb798a8f9410000
0xc1656b63d9eeba6d114f6be19565177893e5bcbffalse1976006501157920892373161954235709850086879078532699846656405640394575840079131296399350x86d2634702b2ba9c5065250060d2d4e3fdba03c8311ffb65f6f7e393adec12c32023-12-07T23:10:47.000Z0x89afffd4b2f98861fa34fee49ca43b701c08ff780x2170ed0880ac9a755fd29b2688956bd959f933f8560xe5daabc83e2bb48b3785b02b8f6ad77dffacd66ea12bee9e1441b4fe5998c47a10000
Query with partition filter
SELECT *
FROM `tt-contracts.debridge_v1_base.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.
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_submissionIdSTRINGUnique identifier for the cross-chain bridge submission. 66-character hex string including 0x prefix.
in_debridgeIdSTRINGUnique identifier for the deBridge cross-chain bridge pairing or transaction. 66-character hex string including 0x prefix.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_nonceSTRINGUnique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.
in_chainIdToSTRINGDestination blockchain identifier for the cross-chain bridge transaction. Numeric string representation of the chain ID.
in_referralCodeSTRINGReferral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.
in_feeParamsSTRUCT<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_autoParamsSTRINGAutomation parameters for cross-chain bridge execution. Hex-encoded byte string containing encoded configuration data for automated processing on the destination chain.
in_nativeSenderSTRINGAddress that initiated the cross-chain bridge transaction on the source blockchain. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedin_noncein_amountlog_indexin_receiverblock_numberin_chainIdToin_feeParamsin_autoParamsin_debridgeIdblock_timestampin_nativeSenderin_referralCodein_submissionIdtransaction_hash
0xc1656b63d9eeba6d114f6be19565177893e5bcbffalse450010xef4fb24ad0916217251f553c0596f8edc630eb66771657310{“fixFee”:“1000000000000000”,“transferFee”:“10435326551”,“useAssetFee”:true,“isNativeToken”:true,“receivedAmount”:“1010435326551431”}0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000097a186608000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000c00000000000000000000000000000000000000000000000000000000000000014555ce236c0220695b68341bc48c68d52210cc35b00000000000000000000000000000000000000000000000000000000000000000000000000000000000001646abd4ea70000000000000000000000000000000000000000000000000000000000000040000000000000000000000000555ce236c0220695b68341bc48c68d52210cc35b0000000000000000000000000000000000000000000000000000000000000008329eaad99c375705961f6a6f2f36e7f35fd3c403ac3d2637deafe0ac65f7e512b13d727ea68434533cdc0a3e5228718d1633ca112605a8bd55fb2cc89ae41683cf0e821140845b99dac6fbc2d0019669545698773f5a1a2645788438231745cc21e51c7a10eb91997122d9e3d658059e9984aa35fc7e663a87856951fd821932c807fff644ca839ad013af6eb81c6547b45eb6c6e71ba7dc122cc9cbd56410fa255bbe82042d0bf01a2730a00c94b0f167614e4a8242c608f453c2cf8803bf05e95d92b5d5691c04bb93bbda560ba05c751ebec30109b0802a942eb56dd9b004a659b36ce073bf11da4bb5e36c90fcd95eb2ce9c7ec8748ec567903bddd50724000000000000000000000000000000000000000000000000000000000x1e08bd86be711e69863128bff50e31e8d6e5729a6626ce6aa189d7113a85823d2023-12-10T15:34:53.000Z0xe7351fd770a37282b91d153ee690b63579d6dd7f00xb429c1101a8d38d02bf3dfedfe013848cf69d18198806b10b0682a5c173d16600xa37af7d2d63eaaf8c316ed40a7f2f49cf559325ba51fdf0bcc44a19c74d0e74c
0xc1656b63d9eeba6d114f6be19565177893e5bcbffalse4420160xef4fb24ad0916217251f553c0596f8edc630eb66771084010{“fixFee”:“1000000000000000”,“transferFee”:“11592910810”,“useAssetFee”:true,“isNativeToken”:true,“receivedAmount”:“1011592910810810”}0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000a882dc958000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000c00000000000000000000000000000000000000000000000000000000000000014ef1ec136931ab5728b0783fd87d109c9d15d31f100000000000000000000000000000000000000000000000000000000000000000000000000000000000001a46abd4ea70000000000000000000000000000000000000000000000000000000000000040000000000000000000000000ef1ec136931ab5728b0783fd87d109c9d15d31f1000000000000000000000000000000000000000000000000000000000000000a98f57ee7c3b797ba7466e394ae9c50071807b5be1217fcaa66ac9f220faf3308888365f88e59277c7439c2f362ab90b6912a60ecea4ab4770179665bb5fea719c1bdb0a6a7da981117c0cedb2a04df60fb94cfc2ac1f181359278a186e24bd70935d7e53b9b2d6ba57a215d7bebdd1ebfcae454bf96c5f009fd782dcbc8a34b56bd422a8d249276bd7948fba068e56e9b0b4bcaa79fdd4d62cf6996d9a5afe1ed674162d32897476266f660d1e6bbf0b24efc2f6af6252bfd93d7e48de738437e14ae071d531c570732df34395b8006303481f81b47959133a26e8e63552b7a95ce920b1cc7784f36b4723a7c869544e17a604dbe759cfae6b37f62b7d39be10c8a57362d29c4da9b7a83e6610e4dd172d71e891129d8986c78183f6fb4fabaf35782831387d9050550ae1228b21d1461fee9cf2673685993db2cdd8cac6553c000000000000000000000000000000000000000000000000000000000x1e08bd86be711e69863128bff50e31e8d6e5729a6626ce6aa189d7113a85823d2023-12-10T12:23:47.000Z0xe7351fd770a37282b91d153ee690b63579d6dd7f00x608dc3d78bd52fdf4e78fad414fe8c555222e08ba3a879a505a7cfad59940f430x33e523b84adc436bc8a168159490c4c06098a0ec2abe19f0fceb1847dd9e6b82
0xc1656b63d9eeba6d114f6be19565177893e5bcbffalse4640200xef4fb24ad0916217251f553c0596f8edc630eb66772918410{“fixFee”:“1000000000000000”,“transferFee”:“9314877477”,“useAssetFee”:true,“isNativeToken”:true,“receivedAmount”:“1009314877477477”}0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000875533248000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000c00000000000000000000000000000000000000000000000000000000000000014ef1ec136931ab5728b0783fd87d109c9d15d31f100000000000000000000000000000000000000000000000000000000000000000000000000000000000001a46abd4ea70000000000000000000000000000000000000000000000000000000000000040000000000000000000000000ef1ec136931ab5728b0783fd87d109c9d15d31f1000000000000000000000000000000000000000000000000000000000000000af41eb8c4cb908fe0e00f31e3cfb37b99ffc421faeb7e33b1d718962ace36805185f06c40ae98b07971af913aeba9e8d488ff7fcd39c15fd58c4f05ad73f5aa0ea20fcd8b190524c2b77514aebbf1da37f018111f629aa4241f9acc3fe7778dae43ef34e0d953d205d7dce07f458aab07f2009569a6bf57fc16857c293c100c4719dd424683a7dc66faa1e91af00bc9dc257c1efcd91f5cfb0d4a03548291f59652c846cbf5d57399ea93bf2877d7180e02249a79da3923258967c12ba9531047101bfda0b0798a366b96ffa7a95b627f42fa10d7cd779fe6b314cf6c83cef6548084e61232df6d8a63cbf5655bc3337e67474accacdf4fef02c0304c1e583043400c13c1c3dd7c84e08202e7336fd42aa2a3e104eeca36e08dc094900ae61ba0faf07f8be4cb33967661d4df3bede7d095e9bd3a34b5fa26dd128dbf95ee2fd7000000000000000000000000000000000000000000000000000000000x1e08bd86be711e69863128bff50e31e8d6e5729a6626ce6aa189d7113a85823d2023-12-10T22:35:15.000Z0xe7351fd770a37282b91d153ee690b63579d6dd7f00x36781f14f8a8a05e64b27ce9acf1e54b5fcab421418cec49ffe6fecca5e83ae20x22e5294d24e1c60e6fb934f2d7c3f30241c7ddca7bba9a4f9636e9ee294d66d7
Query with partition filter
SELECT *
FROM `tt-contracts.debridge_v1_base.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.
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_orderIdSTRINGUnique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations.
in_beneficiarySTRINGAddress that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_giveAmountSTRINGAmount of tokens being transferred or unlocked in the operation. String-encoded integer value representing the token quantity in its smallest unit.
in_giveTokenAddressSTRINGContract address of the token being given or unlocked in the cross-chain bridge operation. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedlog_indexin_orderIdblock_numberin_giveAmountin_beneficiaryblock_timestamptransaction_hashin_giveTokenAddress
0xef4fb24ad0916217251f553c0596f8edc630eb66false110x1f51bf824c50c050f5d4a2b6bd668427286f630e230fc68878f3b9dd769acdc3789507538384321432186992910x555ce236c0220695b68341bc48c68d52210cc35b2023-12-14T18:44:57.000Z0xeafa1a7d24d0bda867e8b0d2acde4b61f6b47da84d827e26e6e86b6d776590700x0000000000000000000000000000000000000000
0xef4fb24ad0916217251f553c0596f8edc630eb66false120xa2cb358f412f99981b92f649221b3b2f294e442e11c8cffae1784e990c389dda789507539864823324271952230x555ce236c0220695b68341bc48c68d52210cc35b2023-12-14T18:44:57.000Z0xeafa1a7d24d0bda867e8b0d2acde4b61f6b47da84d827e26e6e86b6d776590700x0000000000000000000000000000000000000000
0xef4fb24ad0916217251f553c0596f8edc630eb66false450xc7eb471f3bb90e118908695a04edd5fdf0a34b64567dedc539ce93fe980e2e4e78735805149640795235470420x555ce236c0220695b68341bc48c68d52210cc35b2023-12-14T06:48:27.000Z0xe3563dbb298396c92a53b18125eccecd9aa0b6090fe5339d5c68c5c747c6efae0x0000000000000000000000000000000000000000
Query with partition filter
SELECT *
FROM `tt-contracts.debridge_v1_base.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.
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_orderSTRUCT<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_orderIdSTRINGUnique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations.
in_affiliateFeeSTRINGFee paid to an affiliate for referring the transaction. Hex-encoded bytes value representing the affiliate address and fee amount.
in_nativeFixFeeSTRINGFixed 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_percentFeeSTRINGPercentage-based fee amount charged on the order. String-encoded integer representing the fee in basis points or smallest fee unit.
in_referralCodeSTRINGReferral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.
in_metadataSTRINGMetadata payload associated with the operation. Hex-encoded bytes containing protocol-specific auxiliary data such as action identifiers, addresses, amounts, and configuration parameters.
addressremovedin_orderlog_indexin_orderIdin_metadatablock_numberin_percentFeeblock_timestampin_affiliateFeein_nativeFixFeein_referralCodetransaction_hash
0xef4fb24ad0916217251f553c0596f8edc630eb66false{“makerSrc”:“0xf9726ec833b7a4faf0965824bfe38f986005c3c0”,“giveAmount”:“403101681353100135”,“takeAmount”:“398629389761321612”,“giveChainId”:“8453”,“receiverDst”:“0xf9726ec833b7a4faf0965824bfe38f986005c3c0”,“takeChainId”:“1”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“12”,“giveTokenAddress”:“0x0000000000000000000000000000000000000000”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0xf9726ec833b7a4faf0965824bfe38f986005c3c0”,“orderAuthorityAddressDst”:“0xf9726ec833b7a4faf0965824bfe38f986005c3c0”,“allowedCancelBeneficiarySrc”:“0x”}10x068d98b1a061be085ca38d3f194beeff0842127d92d2862234ed9ae1420c644f0x46688551613051946190872023-10-01T02:24:17.000Z0x100000000000000048500x3d8e467f1c97bd962499e4e7a691144e4d3881ade322437a1ac21541ca28b945
0xef4fb24ad0916217251f553c0596f8edc630eb66false{“makerSrc”:“0x47ce4710f1ec69fd49eeee3d1711942de47266d9”,“giveAmount”:“4150363016372401”,“takeAmount”:“3985890562988090”,“giveChainId”:“8453”,“receiverDst”:“0x47ce4710f1ec69fd49eeee3d1711942de47266d9”,“takeChainId”:“10”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“14”,“giveTokenAddress”:“0x0000000000000000000000000000000000000000”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0x47ce4710f1ec69fd49eeee3d1711942de47266d9”,“orderAuthorityAddressDst”:“0x47ce4710f1ec69fd49eeee3d1711942de47266d9”,“allowedCancelBeneficiarySrc”:“0x”}50xa4f3d5683be262d73a47eadde64553907880ab720203fb8582f00c0e014b1fbe0x469314516608095303612023-10-01T15:53:57.000Z0x100000000000000045640x3ba3fbe98471c20297ca2e2b7089c5e29b3d61886b6101a5bd1d121b73b4d7f8
0xef4fb24ad0916217251f553c0596f8edc630eb66false{“makerSrc”:“0x9a608d9f416518b5f11acf3dc5594c90d6998e2c”,“giveAmount”:“146711994639341966”,“takeAmount”:“146001155734913770”,“giveChainId”:“8453”,“receiverDst”:“0x9a608d9f416518b5f11acf3dc5594c90d6998e2c”,“takeChainId”:“42161”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“2”,“giveTokenAddress”:“0x0000000000000000000000000000000000000000”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0x9a608d9f416518b5f11acf3dc5594c90d6998e2c”,“orderAuthorityAddressDst”:“0x9a608d9f416518b5f11acf3dc5594c90d6998e2c”,“allowedCancelBeneficiarySrc”:“0x”}100x45aadd0be6ef3a10d080258e26dcface47ab69aa4d3da065639fdf9c375267d20x4679618587082811682042023-10-01T08:23:03.000Z0x10000000000000003350x9f90e36b462ce210194c79c96d9ba71eba8a60df25474ab50f59d6cee5a4633f
Query with partition filter
SELECT *
FROM `tt-contracts.debridge_v1_base.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.
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_orderSTRUCT<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_orderIdSTRINGUnique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations.
in_affiliateFeeSTRINGFee paid to an affiliate for referring the transaction. Hex-encoded bytes value representing the affiliate address and fee amount.
in_nativeFixFeeSTRINGFixed 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_percentFeeSTRINGPercentage-based fee amount charged on the order. String-encoded integer representing the fee in basis points or smallest fee unit.
in_referralCodeSTRINGReferral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.
addressremovedin_orderlog_indexin_orderIdblock_numberin_percentFeeblock_timestampin_affiliateFeein_nativeFixFeein_referralCodetransaction_hash
0xef4fb24ad0916217251f553c0596f8edc630eb66false{“makerSrc”:“0xa263c0cc7ce8243d57cbc745db417de4c85b2407”,“giveAmount”:“80518348597440399”,“takeAmount”:“74726224726677691”,“giveChainId”:“8453”,“receiverDst”:“0xa263c0cc7ce8243d57cbc745db417de4c85b2407”,“takeChainId”:“1”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“1”,“giveTokenAddress”:“0x0000000000000000000000000000000000000000”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0xa263c0cc7ce8243d57cbc745db417de4c85b2407”,“orderAuthorityAddressDst”:“0xa263c0cc7ce8243d57cbc745db417de4c85b2407”,“allowedCancelBeneficiarySrc”:“0x”}30xb2588c13db0e4791439a4347cadf9ccaf8201ff8fd9ed3cbe64d39db488d9f8e2986771322202275299882023-08-23T03:54:49.000Z0x100000000000000048500xc28f8c0f7ae9432d621d7593a5537067452feb1a58f7b40cccbbd3caccbed8b1
0xef4fb24ad0916217251f553c0596f8edc630eb66false{“makerSrc”:“0x2d9ead45a8655584ef9db5f3abd66fccf28c2286”,“giveAmount”:“14483727441869285”,“takeAmount”:“9102753008373924”,“giveChainId”:“8453”,“receiverDst”:“0x2d9ead45a8655584ef9db5f3abd66fccf28c2286”,“takeChainId”:“1”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“0”,“giveTokenAddress”:“0x0000000000000000000000000000000000000000”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0x2d9ead45a8655584ef9db5f3abd66fccf28c2286”,“orderAuthorityAddressDst”:“0x2d9ead45a8655584ef9db5f3abd66fccf28c2286”,“allowedCancelBeneficiarySrc”:“0x”}360x39646b2c914e94c390408145b7b4487c20fea31fd648b1606fb325cac9ef7d3d298037857958093004672023-08-23T00:21:43.000Z0x100000000000000048500xde7e99ceb2f126a45c25df6f285de622c4f70bdded82ef7de694e54bdefb3602
0xef4fb24ad0916217251f553c0596f8edc630eb66false{“makerSrc”:“0xb779daead6031ef189cad4ac438c991efe7635a7”,“giveAmount”:“1111270640863083”,“takeAmount”:“1052714898709020509”,“giveChainId”:“8453”,“receiverDst”:“0xb779daead6031ef189cad4ac438c991efe7635a7”,“takeChainId”:“10”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“3”,“giveTokenAddress”:“0x0000000000000000000000000000000000000000”,“takeTokenAddress”:“0x4200000000000000000000000000000000000042”,“givePatchAuthoritySrc”:“0xb779daead6031ef189cad4ac438c991efe7635a7”,“orderAuthorityAddressDst”:“0xb779daead6031ef189cad4ac438c991efe7635a7”,“allowedCancelBeneficiarySrc”:“0x”}20xa0897d2a40623d614f3a67cd09622bc566e78c896d3f8ab9f3ad2d7dbabffdfd30024284446861307972023-08-23T12:36:43.000Z0x100000000000000048510x80579edc2c42ebb60a45dd098c9230dae3d46affcfdc5061daaeb567c347487d
Query with partition filter
SELECT *
FROM `tt-contracts.debridge_v1_base.DlnSourceV1_CreatedOrder_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100