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
0x43de2d77bf8027e25dbd179b491e8d64f38398aafalse72311939701157920892373161954235709850086879078532699846656405640394575840079131296399350x82207988de27289f4a2977e0601c9c2e67cb447f58853b744d2d0c9e270c6feb2022-07-27T10:53:14.000Z0x1a13f4ca1d028320a707d99520abfefca3998b7f0x1a13f4ca1d028320a707d99520abfefca3998b7f1370x520f19c4315e401a98c34243ca4e23a4c18bc93d9bbf7b3ac9afffc012c8fcd110000
0x43de2d77bf8027e25dbd179b491e8d64f38398aafalse274311935901157920892373161954235709850086879078532699846656405640394575840079131296399350x09dbacc3080b395b40a3bd4c4ed1a82fbda805b04ccf4c1a0486f88cd68edc2b2022-07-27T10:37:51.000Z0x031706882fd1ce4943ff0b30ebfdc3c31bd5d4c60x04068da6c83afcfa0e13ba15a6696662335d5b752500x56fea48a7dc0253ef482779f6e8528af42f308e8a8302b4ce69b2741bef2c5c610000
0x43de2d77bf8027e25dbd179b491e8d64f38398aafalse35447970241157920892373161954235709850086879078532699846656405640394575840079131296399350x5be480c25ccbdd601fc37eeba96d96b271e76c09bd293c6415e526b9fc278c4c2023-07-07T16:04:03.000Z0x0adc86a387d62fd084fc2bd749039b962586b2a50xaf88d065e77c8cc2239327c5edb3a432268e5831421610xb89921cc49d54d7a2dd0930ef5eb23388b91d1360b817060f297340c5f03f5ae10000
Query with partition filter
SELECT *
FROM `tt-contracts.debridge_v1_polygon.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
0x43de2d77bf8027e25dbd179b491e8d64f38398aafalse5384001120xef4fb24ad0916217251f553c0596f8edc630eb664523744242161{“fixFee”:“500000000000000000”,“transferFee”:“0”,“useAssetFee”:true,“isNativeToken”:true,“receivedAmount”:“500000000000000000”}0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000c00000000000000000000000000000000000000000000000000000000000000014d96123fe9881344be9ab63ec054444902dc4d6a400000000000000000000000000000000000000000000000000000000000000000000000000000000000001446abd4ea70000000000000000000000000000000000000000000000000000000000000040000000000000000000000000d96123fe9881344be9ab63ec054444902dc4d6a4000000000000000000000000000000000000000000000000000000000000000704a28db6eec4e328da5bf8529fe64c94ac23a4f4c51db58d02776c2a621f23b8309fea290a6310349763d9fdaee9d4f368c9f91ee63f8242f977cf1fd4a36fa68c7e46d386f5c8bbcf736e3d2e6f1bd0fedc49fbc791ea99b9d5489a0cfa673918e7ac143988f66b9b7793581b0655b62ee7dad7fdd9a8b1e43a81c94a62c293c638b6b8f1ec259458d4009463d912cf537f1b6ed9055c20dc75754a93f981c8cb962813386d78d5181b0e253f60eb13723c6419cbe95882e4c321ab66c693ed2236787d1378f2f1438270dc3ccc037fba5822d1feb4ea6214f7dedd6b62dfe9000000000000000000000000000000000000000000000000000000000xa64f418a067d562d9c177be545e9f12ab864534625b002205b154a71ddd08be32023-07-18T19:39:34.000Z0xe7351fd770a37282b91d153ee690b63579d6dd7f00x0b7ae0c178bc4040e8626390b5aad4b4526b87d301d93f4fc1ad0d61cb59a6380xa2fc0d26926df9cf2cc0cf3b9f38752b2bf2737cd260a72d8bd446a5ff49f756
0x43de2d77bf8027e25dbd179b491e8d64f38398aafalse5383901550xef4fb24ad0916217251f553c0596f8edc630eb664523244556{“fixFee”:“500000000000000000”,“transferFee”:“868917886645048”,“useAssetFee”:true,“isNativeToken”:true,“receivedAmount”:“1368917886645048092”}0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000c0bedee147280000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000c00000000000000000000000000000000000000000000000000000000000000014555ce236c0220695b68341bc48c68d52210cc35b00000000000000000000000000000000000000000000000000000000000000000000000000000000000001a46abd4ea70000000000000000000000000000000000000000000000000000000000000040000000000000000000000000555ce236c0220695b68341bc48c68d52210cc35b000000000000000000000000000000000000000000000000000000000000000af3c1356a91b39a56afabd805be74c52d5a084bea3592b4e2eb2dd803fdbea931ccb59511bf565817d59bf3938825f16e72e0e1f266ca30680f18137c8afb1948dacde25f8e4edd3d7ff2941e08854e71e8fc33dc5dc460fd4ecb1ccdc959ec084a14aa5f22786eaa7ed786e50c0d49705b55be75109b8f551a6acc27470d3cf8ced80b15126926f0dcf1a5224b6377f6afddb51a0920058ac7c6eb11d812f5eaf50657180c8ec24e0b86a37ed1f657569980821733c6b93c2bab4e3944bb48871523c2aae5f6d4216431490ac76a3766103652321cc0545d4dc0b29e23eae8972dccff6427552d2d79e8f246b211e7ec6f4c3b0f1065aa5f23273c70c71472b8cb3b9751243a40fa2d00bbd2e24a1a990c5a01703b1d6569578c6d125a56e542979b4c3eb6a1ff67c4f04068f580c4d2666c8ddbd841853925ed886a25984a63000000000000000000000000000000000000000000000000000000000xa64f418a067d562d9c177be545e9f12ab864534625b002205b154a71ddd08be32023-07-18T16:12:46.000Z0xe7351fd770a37282b91d153ee690b63579d6dd7f00x1dec1a9737d8f6ad4c8687b9ea287536546886aacdc0ffd72042eb0f6d99f0850x4ce1b42f58d24f8bda3e722934d6f8e9b1ce7d25605ac8d7008636ed3626d6a4
0x43de2d77bf8027e25dbd179b491e8d64f38398aafalse4520628917722081540x92fbfcd2316dcd24ca69b63901b2b07e780c2dc4323172651{“fixFee”:“500000000000000000”,“transferFee”:“2904096”,“useAssetFee”:false,“isNativeToken”:false,“receivedAmount”:“2904096604”}0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000008fbe0c0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000000000001492fbfcd2316dcd24ca69b63901b2b07e780c2dc400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x473d5176dee4131db96e7b596120a4a3710d38e620ca2d6d3e3f12a059a834162022-08-25T19:27:53.000Z0x663dc15d3c1ac63ff12e45ab68fea3f0a883c25100x0a676a68a5fd32c6dfa7f612110df2950db346b922e5ce42cfe6c5390b7cac690xad4e5521bd0af85b5d354734e9b02362ab1b027748b4774bbf78c4cc801bd40d
Query with partition filter
SELECT *
FROM `tt-contracts.debridge_v1_polygon.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
0xef4fb24ad0916217251f553c0596f8edc630eb66false3480x8f453930d38f8267bd89540f5d00562bcfbd38942e9bc17aa0e8d6dcab730e5472576094775790760x555ce236c0220695b68341bc48c68d52210cc35b2025-06-10T00:41:01.000Z0x45ea17a7f0a1db81654dafb01e05fcf2c7cdecd81f79645da60c4ff652cf1ab70x3c499c542cef5e3811e1192ce70d8cc03d5c3359
0xef4fb24ad0916217251f553c0596f8edc630eb66false3400xf4efae2388ce2497c1899c5e718d9ebe197d4d738800af44bbe5e138114d5b767257609419917324670x555ce236c0220695b68341bc48c68d52210cc35b2025-06-10T00:41:01.000Z0x45ea17a7f0a1db81654dafb01e05fcf2c7cdecd81f79645da60c4ff652cf1ab70x3c499c542cef5e3811e1192ce70d8cc03d5c3359
0xef4fb24ad0916217251f553c0596f8edc630eb66false3460xc7a1a65223c084e3116617e81d72c4bcd1dd2214b72c9553d1de633928be0671725760941115753520x555ce236c0220695b68341bc48c68d52210cc35b2025-06-10T00:41:01.000Z0x45ea17a7f0a1db81654dafb01e05fcf2c7cdecd81f79645da60c4ff652cf1ab70x3c499c542cef5e3811e1192ce70d8cc03d5c3359
Query with partition filter
SELECT *
FROM `tt-contracts.debridge_v1_polygon.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”:“0xfb1691194412181ef2202fbe37c2f80ce1c58d8d”,“giveAmount”:“58064480130658072”,“takeAmount”:“57334030285304967”,“giveChainId”:“137”,“receiverDst”:“0xfb1691194412181ef2202fbe37c2f80ce1c58d8d”,“takeChainId”:“42161”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“0”,“giveTokenAddress”:“0x7ceb23fd6bc0add59e62ac25578270cff1b9f619”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0xfb1691194412181ef2202fbe37c2f80ce1c58d8d”,“orderAuthorityAddressDst”:“0xfb1691194412181ef2202fbe37c2f80ce1c58d8d”,“allowedCancelBeneficiarySrc”:“0x”}3180x5e1be1b914dec7ea6e42d64693453004bb74a9cdd48aabf8d3a71acb6f17cfe40x50596953233518922705242023-12-01T03:04:40.000Z0xd57de2fe6531a55ab609b5c7d33a099ad7670f5f0000000000000000000000000000000000000000000000000001097af38b93af50000000000000000000x8c3212fbdf9a6982ba0fc4a1b7cf243535e34f6be283cfa8dffc2c577d1f8879
0xef4fb24ad0916217251f553c0596f8edc630eb66false{“makerSrc”:“0xa3dcd9b7149915e2f214753a8e3a519446466c07”,“giveAmount”:“3435832”,“takeAmount”:“51373258”,“giveChainId”:“137”,“receiverDst”:“0xc2d5a34cc74455f55062a8c4a857739a24c61a4cdf63995606032e7175a5fa83”,“takeChainId”:“7565164”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“1701442180550”,“giveTokenAddress”:“0x2791bca1f2de4661ed88a30c99a7a9449aa84174”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0xa3dcd9b7149915e2f214753a8e3a519446466c07”,“orderAuthorityAddressDst”:“0xc2d5a34cc74455f55062a8c4a857739a24c61a4cdf63995606032e7175a5fa83”,“allowedCancelBeneficiarySrc”:“0x”}4450x28697ecf31f7e111ffa6d45221e772ae051dddeea947c02b5e04bc584a93baed0x01010000003183527cdc910006000000000000000000000000cae40f030000000000000000000000000000000000000000000000000000000000000000000000005061670413742023-12-01T14:52:09.000Z0x50000000000000000000x0df77fa5b5d3fef6d19b47ca807a42790d4f1414049c9b7ff680b4aeeca4abdf
0xef4fb24ad0916217251f553c0596f8edc630eb66false{“makerSrc”:“0xb0a2ad259c2d875632f5028aca169760e7580db9”,“giveAmount”:“8348945”,“takeAmount”:“2976435724620837”,“giveChainId”:“137”,“receiverDst”:“0xb0a2ad259c2d875632f5028aca169760e7580db9”,“takeChainId”:“42161”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“1701440743624”,“giveTokenAddress”:“0x2791bca1f2de4661ed88a30c99a7a9449aa84174”,“takeTokenAddress”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“givePatchAuthoritySrc”:“0xb0a2ad259c2d875632f5028aca169760e7580db9”,“orderAuthorityAddressDst”:“0xb0a2ad259c2d875632f5028aca169760e7580db9”,“allowedCancelBeneficiarySrc”:“0x”}32370x2de36168f965d5573f44117c7c1e610d226c951b7c10c7e262995e2bfcc6c2750x010100000067e9d1ed64f5db25000000000000000000000000251410720d930a0000000000000000000000000000000000000000000000000000000000000000005061597833442023-12-01T14:26:02.000Z0xc2b0476cc59186dea8641a5511714dcdbb2bf7c700000000000000000000000000000000000000000000000000000000000023ee50000000000000000000x8a3e4ae7f857991d3a90c2739bbee76679d02605e53a850fc9c4c4dd4a9a6154
Query with partition filter
SELECT *
FROM `tt-contracts.debridge_v1_polygon.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”:“0x2814b7def434cc0f7fc5e654f5e5ba2c49097f54”,“giveAmount”:“106456441682102956”,“takeAmount”:“89916000000000000”,“giveChainId”:“137”,“receiverDst”:“0x68a60dc885770ea15ec9bbcb2ffbd92d87386ffb”,“takeChainId”:“1”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“0”,“giveTokenAddress”:“0x7ceb23fd6bc0add59e62ac25578270cff1b9f619”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0x2814b7def434cc0f7fc5e654f5e5ba2c49097f54”,“orderAuthorityAddressDst”:“0x2814b7def434cc0f7fc5e654f5e5ba2c49097f54”,“allowedCancelBeneficiarySrc”:“0x”}30xd125bd5394111de8b77ff9808ad3002d980ec8f694f2d2715c42e5b6571902c742139778425996165194482023-04-30T14:37:15.000Z0x50000000000000000000x137d0d29bf867b923081bd5f514b0cef1ef86ea593cd46af1abc9e968fd5542d
0xef4fb24ad0916217251f553c0596f8edc630eb66false{“makerSrc”:“0x663dc15d3c1ac63ff12e45ab68fea3f0a883c251”,“giveAmount”:“31392421070394189”,“takeAmount”:“20953000000000000”,“giveChainId”:“137”,“receiverDst”:“0x22e36844455245c6261de6e8618b9083c833b79a”,“takeChainId”:“1”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“787”,“giveTokenAddress”:“0x7ceb23fd6bc0add59e62ac25578270cff1b9f619”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0x75dc8f656a33c51eb182552266828bdaa41e2173”,“orderAuthorityAddressDst”:“0x75dc8f656a33c51eb182552266828bdaa41e2173”,“allowedCancelBeneficiarySrc”:“0x”}230x96e4937c1e71f0ef3e0d03ee50d42c8fb598487be1b85b295c5aedc8be179cc642130478125619932254472023-04-30T09:01:44.000Z0x50000000000000000000xb0830f05038327ebbceee15ed6eaaafb6baa0709a1709e4a94f5085b0f36ed4b
0xef4fb24ad0916217251f553c0596f8edc630eb66false{“makerSrc”:“0x18d3685a8aff35635c9c991f956f301a03908e2b”,“giveAmount”:“74494210”,“takeAmount”:“71915459”,“giveChainId”:“137”,“receiverDst”:“0x18d3685a8aff35635c9c991f956f301a03908e2b”,“takeChainId”:“42161”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“2”,“giveTokenAddress”:“0x2791bca1f2de4661ed88a30c99a7a9449aa84174”,“takeTokenAddress”:“0xff970a61a04b1ca14834a43f5de4533ebddb5cc8”,“givePatchAuthoritySrc”:“0x18d3685a8aff35635c9c991f956f301a03908e2b”,“orderAuthorityAddressDst”:“0x18d3685a8aff35635c9c991f956f301a03908e2b”,“allowedCancelBeneficiarySrc”:“0x”}90xa95e9b6de3c2d48ca012f68ca716711096393ac6e9841e5c56f7927988f5d50642143297298092023-04-30T16:45:32.000Z0x50000000000000000000x4960677799236b4456e436ed8d7873bde935951c0ef9ffa0a56cf9f85d45717e
Query with partition filter
SELECT *
FROM `tt-contracts.debridge_v1_polygon.DlnSourceV1_CreatedOrder_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100