Skip to main content

Tables

CurveFactoryV2_NewCurve_event

Curve deployment events from the DFX V2 factory contract on Polygon, recording new liquidity pool creation with curve addresses and deployer accounts. Used for tracking protocol expansion and identifying new trading pools.
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_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_idSTRINGUnique identifier for the position, record, or entity within the protocol. Numeric string representation.
in_curveSTRINGContract address of the newly created curve pool. Hex-encoded, 0x-prefixed, 42-character string.
in_idaddressremovedin_curvein_callerlog_indexblock_numberblock_timestamptransaction_hash
0xe536175454585898b9c59b3affc8fd4cc4b225b90e7f5f5d26cd1e72ebd80f500x1f5969e331423e0845e61a64545bba8f7426106efalse0x17f8ddcea03a8972559a8d32874e144c87baf5b60xa844df450711a669c75795d77f92b9b519bbd19a141342338152022-10-12T02:38:34.000Z0x7f2949573fb9baeb525759162052bf7ff28cfc4f10e6db1594858e8ea7f01d18
0xfcfb0551278b1114a2f2caa57df97d7b67043d2fe34284bf7024f5678d1018dd0x1f5969e331423e0845e61a64545bba8f7426106efalse0x8c6eb8c26f166f87b4f886ce07116a823805602c0xa844df450711a669c75795d77f92b9b519bbd19a141342336512022-10-12T02:32:54.000Z0x68d6151f6ce3af913885b87bc590696f76e97af59d276617b913bbdda5eabb47
0xa937f249b607811b58d50d7f8b32db4f0841dbe710b353d6e75121f2e8b7f8a60x1f5969e331423e0845e61a64545bba8f7426106efalse0xefac71536febe220d0bb5128aebbd1e3df2a1e670xa844df450711a669c75795d77f92b9b519bbd19a107342337452022-10-12T02:36:10.000Z0x8cea96d00cb33d8a912813a0f8900812bc02e8f40d685bd4ddeb9e83b1345989
Query with partition filter
SELECT *
FROM `tt-contracts.dfx_v2_polygon.CurveFactoryV2_NewCurve_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

CurveFactoryV22_NewCurve_event

Pool creation events from DFX Finance v2 curve factory on Polygon. Records new liquidity pool deployments with factory address, pool address, and deployer for tracking protocol expansion.
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_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_idSTRINGUnique identifier for the position, record, or entity within the protocol. Numeric string representation.
in_curveSTRINGContract address of the newly created curve pool. Hex-encoded, 0x-prefixed, 42-character string.
in_idaddressremovedin_curvein_callerlog_indexblock_numberblock_timestamptransaction_hash
0xc9169ef302d684a2aeae55242103c566af46e01e534d836ae2fce356c6b43e3c0x3591040ce5df8828b3ed4ec39d030f832d43fd53false0x0245de27be4051e217cfc87bca0b3f9b86ee9a1b0x33af579f8fafada29d98922a825cfc0228d7ce39120450849702023-07-14T22:38:18.000Z0x181759c9361e3ab5c3f16a2d3574b1dafaa458eea533f6855f31eacfa71d093e
0xe536175454585898b9c59b3affc8fd4cc4b225b90e7f5f5d26cd1e72ebd80f500x3591040ce5df8828b3ed4ec39d030f832d43fd53false0xaab708fbd208ac262821e229ded16234277b2b130xc02cd35432b72ab6cf8f511c62ff2e89d7baa0fb483391835202023-02-11T19:32:07.000Z0x4a14dc3f7e165bf2b462fe11d1bbb0e475ad48487418f9f745f7f4716bff862d
0xfcfb0551278b1114a2f2caa57df97d7b67043d2fe34284bf7024f5678d1018dd0x3591040ce5df8828b3ed4ec39d030f832d43fd53false0xbc408da6a7237682c8672ef7a66aff09a9069b150xc02cd35432b72ab6cf8f511c62ff2e89d7baa0fb203391834042023-02-11T19:27:59.000Z0x5990d8ae5a4d9a242523f4d09f7098c436d73213d0c6037da512cdef48f30e11
Query with partition filter
SELECT *
FROM `tt-contracts.dfx_v2_polygon.CurveFactoryV22_NewCurve_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

CurveFactoryV22_newCurve_function

Liquidity pool deployment events from DFX Finance factory contract (v2.2) on Polygon. Contains pool creation parameters including token pairs, oracle addresses, curve coefficients (alpha, beta, lambda, epsilon), and fee settings for analyzing DFX stablecoin swap pool configurations.
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.
trace_addressSTRINGHierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueFLOAT64Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasNUMERICGas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in__infoSTRUCT<_name STRING, _symbol STRING, _baseCurrency STRING, _quoteCurrency STRING, _baseWeight STRING, _quoteWeight STRING, _baseOracle STRING, _quoteOracle STRING, _alpha STRING, _beta STRING, _feeAtHalt STRING, _epsilon STRING, _lambda STRING>Configuration parameters for a new DFX (Curve) liquidity pool. Includes pool metadata (_name, _symbol), trading parameters (alpha, beta, lambda, epsilon, feeAtHalt), asset addresses (_baseCurrency, _quoteCurrency), oracle addresses, and weight allocations for the base and quote assets.
out_anon0STRINGActual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.
gasvaluestatusgas_usedin__infoout_anon0signatureto_addressblock_numberfrom_addresstrace_addressblock_timestamptransaction_hash
51596560true5159656{“_beta”:“420000000000000000”,“_name”:“dfx-1inch-usdc-v2”,“_alpha”:“800000000000000000”,“_lambda”:“300000000000000000”,“_symbol”:“dfx-1inch-v2”,“_epsilon”:“500000000000000”,“_feeAtHalt”:“230000000000000000”,“_baseOracle”:“0x443c5116cdf663eb387e72c688d276e702135c87”,“_baseWeight”:“500000000000000000”,“_quoteOracle”:“0xfe4a8cc5b5b2366c1b58bea3858e81843581b2f7”,“_quoteWeight”:“500000000000000000”,“_baseCurrency”:“0x9c2c5fd7b07e95ee044ddeba0e97a665f142394f”,“_quoteCurrency”:“0x2791bca1f2de4661ed88a30c99a7a9449aa84174”}0xc17c47129e18ec8447e27324e925c11abd5f7f780xb483079b0x3591040ce5df8828b3ed4ec39d030f832d43fd53450034880x33af579f8fafada29d98922a825cfc0228d7ce392023-07-12T21:00:03.000Z0x3c510b2bbff8782fe0b913a9629b07bc93f642863d1b250c5b3c30b3e4bd339f
71299210true5161935{“_beta”:“350000000000000000”,“_name”:“dfx-xsgd-usdc-v2”,“_alpha”:“500000000000000000”,“_lambda”:“1000000000000000000”,“_symbol”:“dfx-xsgd-v2”,“_epsilon”:“1000000000000000”,“_feeAtHalt”:“150000000000000000”,“_baseOracle”:“0x8ce3cac0e6635ce04783709ca3cc4f5fc5304299”,“_baseWeight”:“500000000000000000”,“_quoteOracle”:“0xfe4a8cc5b5b2366c1b58bea3858e81843581b2f7”,“_quoteWeight”:“500000000000000000”,“_baseCurrency”:“0xdc3326e71d45186f113a2f448984ca0e8d201995”,“_quoteCurrency”:“0x2791bca1f2de4661ed88a30c99a7a9449aa84174”}0xbc408da6a7237682c8672ef7a66aff09a9069b150xb483079b0x3591040ce5df8828b3ed4ec39d030f832d43fd53391834040xc02cd35432b72ab6cf8f511c62ff2e89d7baa0fb2023-02-11T19:27:59.000Z0x5990d8ae5a4d9a242523f4d09f7098c436d73213d0c6037da512cdef48f30e11
98666950true6746459{“_beta”:“350000000000000000”,“_name”:“dfx-cadc-usdc-v2”,“_alpha”:“500000000000000000”,“_lambda”:“1000000000000000000”,“_symbol”:“dfx-cadc-v2”,“_epsilon”:“500000000000000”,“_feeAtHalt”:“150000000000000000”,“_baseOracle”:“0xaca44abb8b04d07d883202f99fa5e3c53ed57fb5”,“_baseWeight”:“500000000000000000”,“_quoteOracle”:“0xfe4a8cc5b5b2366c1b58bea3858e81843581b2f7”,“_quoteWeight”:“500000000000000000”,“_baseCurrency”:“0x9de41aff9f55219d5bf4359f167d1d0c772a396d”,“_quoteCurrency”:“0x2791bca1f2de4661ed88a30c99a7a9449aa84174”}0x6691fa63aa1d7e422dc5d19c9b04f25909fde9660xb483079b0x3591040ce5df8828b3ed4ec39d030f832d43fd53391834040xc02cd35432b72ab6cf8f511c62ff2e89d7baa0fb2023-02-11T19:27:59.000Z0x287b579115b1d037633ace0acedcb6e9dc4bba0e06b63e8a3ba349423abb7898
Query with partition filter
SELECT *
FROM `tt-contracts.dfx_v2_polygon.CurveFactoryV22_newCurve_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

CurveV2_Trade_event

Token swap events from Curve V2 automated market maker pools on Polygon, capturing trader addresses, input/output token pairs, and swap amounts. Used for analyzing trading volume, price impact, and liquidity provider performance across Curve V2 pools.
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_traderSTRINGAddress that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_originSTRINGSource endpoint and sender information for a cross-chain message. Struct containing source endpoint identifier (srcEid), sender address, and nonce.
in_targetSTRINGAddress of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
in_originAmountSTRINGAmount of tokens sent from the origin chain in the smallest denomination of the token. Numeric string representing the token quantity in base units.
in_targetAmountSTRINGAmount of target tokens received in the trade. String-encoded integer representing the token quantity in its smallest denomination.
addressremovedin_originin_targetin_traderlog_indexblock_numberblock_timestampin_originAmountin_targetAmounttransaction_hash
0x17f8ddcea03a8972559a8d32874e144c87baf5b6false0x2791bca1f2de4661ed88a30c99a7a9449aa841740x4fb71290ac171e1d144f7221d882becac7196eb50x1051d69861a07d0b7927f6085ae6ef4165a7c7d5205346953322022-10-23T09:34:36.000Z16020089830120659610x42143e5f3f2c8cff00946fcf5a07f79382313b1975fb30c46c898a40174849ce
0x17f8ddcea03a8972559a8d32874e144c87baf5b6false0x2791bca1f2de4661ed88a30c99a7a9449aa841740x4fb71290ac171e1d144f7221d882becac7196eb50x1051d69861a07d0b7927f6085ae6ef4165a7c7d5149347016552022-10-23T13:24:32.000Z8054365515136768110x69ea7b8ad83ba2e832fba59923b76a1c52837b377ae3840fd7301aae72c52ebd
0x17f8ddcea03a8972559a8d32874e144c87baf5b6false0x2791bca1f2de4661ed88a30c99a7a9449aa841740x4fb71290ac171e1d144f7221d882becac7196eb50xce051e8d23590f63de7a8c907cfd0763316d8f95119346857762022-10-23T04:00:04.000Z95560141797296910x171f1d885afe365f060243f5cd2e1d55f6c0915f38c1a603b388a9a297c2aa26
Query with partition filter
SELECT *
FROM `tt-contracts.dfx_v2_polygon.CurveV2_Trade_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

CurveV22_Trade_event

Trade events from DFX Finance (Curve v2.2 fork) stablecoin DEX on Polygon, capturing swaps between origin and target tokens with amounts, trader addresses, and protocol fees. Used for analyzing DFX trading volume, liquidity pool activity, and fee generation.
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_traderSTRINGAddress that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_originSTRINGSource endpoint and sender information for a cross-chain message. Struct containing source endpoint identifier (srcEid), sender address, and nonce.
in_targetSTRINGAddress of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
in_originAmountSTRINGAmount of tokens sent from the origin chain in the smallest denomination of the token. Numeric string representing the token quantity in base units.
in_targetAmountSTRINGAmount of target tokens received in the trade. String-encoded integer representing the token quantity in its smallest denomination.
in_rawProtocolFeeSTRINGProtocol fee collected by Curve V2 on this trade, denominated in the smallest unit of the origin token. Raw integer value requiring decimal adjustment based on the origin token’s decimals.
addressremovedin_originin_targetin_traderlog_indexblock_numberblock_timestampin_originAmountin_targetAmounttransaction_hashin_rawProtocolFee
0xbc408da6a7237682c8672ef7a66aff09a9069b15false0xdc3326e71d45186f113a2f448984ca0e8d2019950x2791bca1f2de4661ed88a30c99a7a9449aa841740x5ff960b7e6d6a7c7cb9e47a455f01aface69bf45134656776972024-12-19T15:41:48.000Z1500946681102878060xc66d332aa130d0504b3c804674ef93bf07fb80a35e82c29b91b968747e7de1f11018075805428030153
0xbc408da6a7237682c8672ef7a66aff09a9069b15false0x2791bca1f2de4661ed88a30c99a7a9449aa841740xdc3326e71d45186f113a2f448984ca0e8d2019950x5ff960b7e6d6a7c7cb9e47a455f01aface69bf45541656524272024-12-19T00:30:24.000Z1094416611489273340xc2655a35eaebdcbf5a64a00ca14747f3c5d5ae8005b9eb2823c34c7cbe737c581009221368272649568
0xbc408da6a7237682c8672ef7a66aff09a9069b15false0xdc3326e71d45186f113a2f448984ca0e8d2019950x2791bca1f2de4661ed88a30c99a7a9449aa841740x5ff960b7e6d6a7c7cb9e47a455f01aface69bf45725667398392025-01-15T19:31:30.000Z13055079616550xe08a3accbd3d15a92297ce9370a71e3fe27ec50c35dc250c15b3e5bedc30e0888854437155380584
Query with partition filter
SELECT *
FROM `tt-contracts.dfx_v2_polygon.CurveV22_Trade_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

RouterV2_originSwap_function

Token swap execution records from DFX V2 protocol on Polygon. Captures origin-to-target token conversions with amounts, slippage limits, and quote currency details for analyzing stablecoin and forex curve trading activity.
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.
trace_addressSTRINGHierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueFLOAT64Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasNUMERICGas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in__quoteCurrencySTRINGContract address of the currency used for price quotation in the swap operation. Hex-encoded, 0x-prefixed, 42-character string.
in__originSTRINGContract address of the source token being swapped or transferred. Hex-encoded, 0x-prefixed, 42-character string.
in__targetSTRINGContract address of the destination token to receive from the swap operation. Hex-encoded, 0x-prefixed, 42-character string.
in__originAmountSTRINGAmount of source tokens being swapped in the transaction. Numeric string representing token amount in smallest denomination.
in__minTargetAmountSTRINGMinimum acceptable amount of target tokens to receive from the swap operation. Numeric string representing token amount in smallest denomination.
in__deadlineSTRINGUnix timestamp representing the transaction deadline by which the swap or zap operation must be executed. Numeric string in milliseconds since epoch.
out_targetAmount_STRINGActual amount of target tokens received from the swap operation. Numeric string representing token amount in smallest denomination.
gasvaluestatusgas_usedsignaturein__originin__targetto_addressblock_numberfrom_addressin__deadlinetrace_addressblock_timestampin__originAmounttransaction_hashin__quoteCurrencyout_targetAmount_in__minTargetAmount
3524760true2849020x9d73b3250x2791bca1f2de4661ed88a30c99a7a9449aa841740x9de41aff9f55219d5bf4359f167d1d0c772a396d0xce051e8d23590f63de7a8c907cfd0763316d8f95348069530xbdd8129032a82200ed1476cbcaa39f69a56c7a7016667544945852022-10-26T03:11:47.000Z12491588820xbd4e38fa6622b0dad8061aa559a2d493fdaba8059dbe7f929ceb5d9367724c730x2791bca1f2de4661ed88a30c99a7a9449aa8417416992681873948182819481697376572593967694435
3374930true2701930x9d73b3250x2791bca1f2de4661ed88a30c99a7a9449aa841740xdc3326e71d45186f113a2f448984ca0e8d2019950xce051e8d23590f63de7a8c907cfd0763316d8f95348159460xd6c7447fabd79f30b3c7ef498b110adb92ea109c16667734331982022-10-26T08:27:22.000Z321911750x3879b71a65401736ac5c359406120166593a3a578c00a6d6b30fc8736692a3d10x2791bca1f2de4661ed88a30c99a7a9449aa841744527077944818072
3375840true2654880x9d73b3250x9de41aff9f55219d5bf4359f167d1d0c772a396d0x2791bca1f2de4661ed88a30c99a7a9449aa841740xce051e8d23590f63de7a8c907cfd0763316d8f95348272330xa930487c477ec4665ad12c130e13d37c3ef77f6a16667977804112022-10-26T15:13:05.000Z20526342517045954695240x60d7bfd2eab2deeca14e09c39eaf4220362eb8150cd7fbb4465eb401b032bece0x2791bca1f2de4661ed88a30c99a7a9449aa8417415149270761500000000
Query with partition filter
SELECT *
FROM `tt-contracts.dfx_v2_polygon.RouterV2_originSwap_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

RouterV22_originSwap_function

Token swap execution records from DFX Finance V2 protocol on Polygon capturing originSwap function calls that exchange origin tokens for target tokens with minimum amount guarantees. Contains swap parameters including origin/target token addresses, amounts, quote currency, and slippage protection limits for analyzing DEX trading activity and price execution.
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.
trace_addressSTRINGHierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueFLOAT64Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasNUMERICGas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in__quoteCurrencySTRINGContract address of the currency used for price quotation in the swap operation. Hex-encoded, 0x-prefixed, 42-character string.
in__originSTRINGContract address of the source token being swapped or transferred. Hex-encoded, 0x-prefixed, 42-character string.
in__targetSTRINGContract address of the destination token to receive from the swap operation. Hex-encoded, 0x-prefixed, 42-character string.
in__originAmountSTRINGAmount of source tokens being swapped in the transaction. Numeric string representing token amount in smallest denomination.
in__minTargetAmountSTRINGMinimum acceptable amount of target tokens to receive from the swap operation. Numeric string representing token amount in smallest denomination.
in__deadlineSTRINGUnix timestamp representing the transaction deadline by which the swap or zap operation must be executed. Numeric string in milliseconds since epoch.
out_targetAmount_STRINGActual amount of target tokens received from the swap operation. Numeric string representing token amount in smallest denomination.
gasvaluestatusgas_usedsignaturein__originin__targetto_addressblock_numberfrom_addressin__deadlinetrace_addressblock_timestampin__originAmounttransaction_hashin__quoteCurrencyout_targetAmount_in__minTargetAmount
3394970true2721970x9d73b3250x2791bca1f2de4661ed88a30c99a7a9449aa841740x9de41aff9f55219d5bf4359f167d1d0c772a396d0x575f1ed1e14ac1152bf2f1cdfb2c1865ca246f51452111170x451ea7e4dae03807318d8e1e10e76d719501b2e316896494355952023-07-18T02:54:04.000Z30980800000x7f1356fa27c996a107140329e4269e7673e22e520eb16a3d0f07903aae8433430x2791bca1f2de4661ed88a30c99a7a9449aa8417440846820980033771710144043997014988721029193
3568590true2940850x9d73b3250x2791bca1f2de4661ed88a30c99a7a9449aa841740x9de41aff9f55219d5bf4359f167d1d0c772a396d0x575f1ed1e14ac1152bf2f1cdfb2c1865ca246f51452245280x5a9258f96f753f2f9b879e4b1beff3aab6d8f57c16896785398472023-07-18T11:01:48.000Z153063820xe1062decd7f4d04a5c076e911444d0952a625092a64b37e2821619b24040f38d0x2791bca1f2de4661ed88a30c99a7a9449aa841742019886831528914706020000000000000000000
3566140true2852920x9d73b3250x2791bca1f2de4661ed88a30c99a7a9449aa841740xdc3326e71d45186f113a2f448984ca0e8d2019950x575f1ed1e14ac1152bf2f1cdfb2c1865ca246f51452093240xa4036d9c5d1c5edb323cedc88699e8241a3773bd16896455209082023-07-18T01:48:54.000Z25873650x2b7ebb3b0c77f33977351fa8abda5387ee964ec2431deb195e36eab568fb20a20x2791bca1f2de4661ed88a30c99a7a9449aa8417434413733406898
Query with partition filter
SELECT *
FROM `tt-contracts.dfx_v2_polygon.RouterV22_originSwap_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

StakingRewardsV2_RewardPaid_event

Reward claim events from DFX Finance v2 staking contracts on Polygon, capturing token rewards paid to users. Used for tracking staking yield distributions and analyzing reward token flows across liquidity providers.
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_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
addressin_userremovedin_tokenin_rewardlog_indexblock_numberblock_timestamptransaction_hash
0x08a86d5627231301edc5a9a741bf5d7a55c8e02e0xc31caab1be8f4e79e198df9450cddb30d7a843a7false0xe7804d91dfcde7f776c90043e03eaa6df87e639530545412330009454025240351392302022-11-03T06:43:26.000Z0xf63b0808c8c2578eb3e0b7696e96db837499a40ea9e7085218b385cbcd0e14ff
0x08a86d5627231301edc5a9a741bf5d7a55c8e02e0xac775ff3fd5db6c46a6dffc049617e31e841cf99false0xe7804d91dfcde7f776c90043e03eaa6df87e6395456014926721940733256227351511082022-11-03T13:45:00.000Z0x4d92cf60db771be3bb75d0fa55b1de5083d09cbfdf847741d120b15dea3deae7
0x3b70a6f6922c756c3616d251fde0d91c19db68bd0x0246b0a279dd8466ecba9b3b0af5f51076763e09false0xe7804d91dfcde7f776c90043e03eaa6df87e639575198806411131435424112351291662022-11-03T00:45:00.000Z0xfeb65d20623b47789504b5652f34c859f0713b5a97f3398ed91ffe291f9f17c6
Query with partition filter
SELECT *
FROM `tt-contracts.dfx_v2_polygon.StakingRewardsV2_RewardPaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ZapV2_zapFromBase_function

DFX Protocol V2 liquidity zaps on Polygon that convert base tokens into LP tokens via curve pools, with slippage protection via minimum LP amounts and deadline parameters. Used to analyze liquidity provision patterns, slippage tolerance, and automated market maker (AMM) interactions.
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.
trace_addressSTRINGHierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueFLOAT64Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasNUMERICGas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in__curveSTRINGContract address of the Curve pool for the zap operation. Hex-encoded, 0x-prefixed, 42-character string.
in__zapAmountSTRINGAmount of tokens to be deposited into the liquidity pool through the zap operation. Numeric string representing the token quantity in its smallest denomination.
in__deadlineSTRINGUnix timestamp representing the transaction deadline by which the swap or zap operation must be executed. Numeric string in milliseconds since epoch.
in__minLPAmountSTRINGMinimum acceptable amount of LP tokens to receive from the zap operation. Numeric string representing the token quantity in its smallest denomination.
out_anon0STRINGActual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.
gasvaluestatusgas_usedin__curveout_anon0signatureto_addressblock_numberfrom_addressin__deadlinein__zapAmounttrace_addressblock_timestampin__minLPAmounttransaction_hash
10361810true9582670xbe9fa3e654a1bf8fe740e9d930d595f31fce1ae221739032181579696023350x72fe67890x1051d69861a07d0b7927f6085ae6ef4165a7c7d5350831940x43e61bd20737b71e003021524020d9c3d03c90ae166733956276229975760260540182837982022-11-01T21:43:22.000Z21511643836675750114970x63d24c38515cdd51bb159a3789f14420a9bf881abb8bff4f69b2deb4afb453f4
11907040true11130610x8c6eb8c26f166f87b4f886ce07116a823805602c34997547456537035323010x72fe67890x1051d69861a07d0b7927f6085ae6ef4165a7c7d5350546370x643700b0703c013a66d20f85538006fe3d497669166727972250549999900002022-11-01T05:05:37.000Z34816291028130001119400x59062d8f97808bf50ca2ae8d7f1704327640998c79ec712e98874e4a834304c7
28028300true13186590x7e4a73278d6e578af34faaaba76ed29583ac03417744076410186039015760x72fe67890x1051d69861a07d0b7927f6085ae6ef4165a7c7d5350775680xb39d0152dfe751d20beb2f96298407e63fe31b111667327811399795432022-11-01T18:27:15.000Z7667620945583491839760x8e2fec27334e402f8b04117d964ccb67754a79803785437530998e3237582d02
Query with partition filter
SELECT *
FROM `tt-contracts.dfx_v2_polygon.ZapV2_zapFromBase_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ZapV2_zapFromQuote_function

Function call records for DFX Protocol’s ZapV2 contract on Polygon, converting quote tokens into liquidity provider (LP) tokens via curve pools. Used to analyze liquidity provision patterns and slippage tolerance across different curve implementations.
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.
trace_addressSTRINGHierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueFLOAT64Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasNUMERICGas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in__curveSTRINGContract address of the Curve pool for the zap operation. Hex-encoded, 0x-prefixed, 42-character string.
in__zapAmountSTRINGAmount of tokens to be deposited into the liquidity pool through the zap operation. Numeric string representing the token quantity in its smallest denomination.
in__deadlineSTRINGUnix timestamp representing the transaction deadline by which the swap or zap operation must be executed. Numeric string in milliseconds since epoch.
in__minLPAmountSTRINGMinimum acceptable amount of LP tokens to receive from the zap operation. Numeric string representing the token quantity in its smallest denomination.
out_anon0STRINGActual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.
gasvaluestatusgas_usedin__curveout_anon0signatureto_addressblock_numberfrom_addressin__deadlinein__zapAmounttrace_addressblock_timestampin__minLPAmounttransaction_hash
13121640true12424230x17f8ddcea03a8972559a8d32874e144c87baf5b610563586779287651103540x8436f16a0x1051d69861a07d0b7927f6085ae6ef4165a7c7d5350609120xa43a8b545f49dde3ff0b313f3c748917fd3bf44f166729335109910581994972022-11-01T08:51:09.000Z10452125324644586378230xe00b3e5b7f95212edb6d2762d0bc1b9e54b191111684eee6c85cf1e60da48c9f
22630340true10531120x7e4a73278d6e578af34faaaba76ed29583ac0341137691245519092506980x8436f16a0x1051d69861a07d0b7927f6085ae6ef4165a7c7d5350795360xb39d0152dfe751d20beb2f96298407e63fe31b111667331891395139335212022-11-01T19:35:17.000Z136400847428774673480x6a8211b0a18b949f62d1ce2ec0f763e83a3ebd5191e39ba9717efa7fa5be271a
15257210false15159320x8436f16a0x1051d69861a07d0b7927f6085ae6ef4165a7c7d5348055940x416af050bdd31eb3cf2dec83b0399b84783038b92022-10-26T02:25:02.000Z0x14b34078f1e0956169304cc12a8adc53eb506be48325c3d3b9df1981d5661316
Query with partition filter
SELECT *
FROM `tt-contracts.dfx_v2_polygon.ZapV2_zapFromQuote_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ZapV22_zapFromBase_function

Function call records for DFX V2 zap contract converting base tokens to liquidity provider (LP) tokens on Polygon. Contains input parameters like zap amounts, minimum LP amounts, deadline timestamps, and curve pool addresses for analyzing single-sided liquidity provision behavior.
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.
trace_addressSTRINGHierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueFLOAT64Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasNUMERICGas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in__curveSTRINGContract address of the Curve pool for the zap operation. Hex-encoded, 0x-prefixed, 42-character string.
in__zapAmountSTRINGAmount of tokens to be deposited into the liquidity pool through the zap operation. Numeric string representing the token quantity in its smallest denomination.
in__deadlineSTRINGUnix timestamp representing the transaction deadline by which the swap or zap operation must be executed. Numeric string in milliseconds since epoch.
in__minLPAmountSTRINGMinimum acceptable amount of LP tokens to receive from the zap operation. Numeric string representing the token quantity in its smallest denomination.
out_anon0STRINGActual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.
gasvaluestatusgas_usedin__curveout_anon0signatureto_addressblock_numberfrom_addressin__deadlinein__zapAmounttrace_addressblock_timestampin__minLPAmounttransaction_hash
11278260false11179920x72fe67890xa070fb11969a50aacc885b7b5245cbc84de2214c403733200x72c65dda795d9a2efa35643e598183ddc3c2a5cc2023-03-15T12:18:47.000Z0x16b61aeb2e193511094d07275adc0e66afccacbe39028f2586bc0d1bbbd21f33
10471230false10371090x72fe67890xa070fb11969a50aacc885b7b5245cbc84de2214c403733570x72c65dda795d9a2efa35643e598183ddc3c2a5cc2023-03-15T12:20:05.000Z0x0216b9f434f4aed79260c6c54ef42dc15fdcb9959ff29c9bc06ef3b85920b190
10471230false10471230xbc408da6a7237682c8672ef7a66aff09a9069b150x72fe67890xa070fb11969a50aacc885b7b5245cbc84de2214c403733020x72c65dda795d9a2efa35643e598183ddc3c2a5cc167888326366099900002023-03-15T12:18:09.000Z73137889432822392750x65cbe7366a2f59520eb78da8ee262cbb640f1a4114144fa38cf1314671c8de80
Query with partition filter
SELECT *
FROM `tt-contracts.dfx_v2_polygon.ZapV22_zapFromBase_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ZapV22_zapFromQuote_function

Quote token to liquidity pool zap transactions from DFX Finance V2 protocol on Polygon. Records single-sided liquidity provisions with input amounts, minimum LP token expectations, and deadline parameters for analyzing DFX curve deposits.
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.
trace_addressSTRINGHierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueFLOAT64Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasNUMERICGas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in__curveSTRINGContract address of the Curve pool for the zap operation. Hex-encoded, 0x-prefixed, 42-character string.
in__zapAmountSTRINGAmount of tokens to be deposited into the liquidity pool through the zap operation. Numeric string representing the token quantity in its smallest denomination.
in__deadlineSTRINGUnix timestamp representing the transaction deadline by which the swap or zap operation must be executed. Numeric string in milliseconds since epoch.
in__minLPAmountSTRINGMinimum acceptable amount of LP tokens to receive from the zap operation. Numeric string representing the token quantity in its smallest denomination.
out_anon0STRINGActual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.
gasvaluestatusgas_usedin__curveout_anon0signatureto_addressblock_numberfrom_addressin__deadlinein__zapAmounttrace_addressblock_timestampin__minLPAmounttransaction_hash
11182450true10481740x2385d7ab31f5a470b1723675846cb074988531da38352979160232051918700x8436f16a0xa070fb11969a50aacc885b7b5245cbc84de2214c417877170x93cf0a22a26895650a8aae960bf85a01ec6a551c168208463442738803404722023-04-21T13:34:30.000Z38284144248000035275460x684d0ee17c6102eb1f2c3efdb457bf42aebdba5b71c446191c9a6952c03a63ac
23303930true22525610x7b95c61f05e9720b778e81d8794f0f5dca704d1a113294142687434327250x8436f16a0xa070fb11969a50aacc885b7b5245cbc84de2214c480406280x9f8005a794fb01b7d950626ebe9c254c5e7aff511695809088990116430052023-09-27T09:55:08.000Z112047551729720837770x14a6090747ebc41fdcd5be19d28912837fc9bef67f7c798bdcab9db8889b864a
13777090false13775320x8436f16a0xa070fb11969a50aacc885b7b5245cbc84de2214c452719390x8541cbbce3683b6be5b7a6e0a3bcf380a9a561d52023-07-19T17:02:41.000Z0x5a0e3672f2615f7576aa5be4eac8c9ec7ce1211feea3b1c32f7b898aa57bc93c
Query with partition filter
SELECT *
FROM `tt-contracts.dfx_v2_polygon.ZapV22_zapFromQuote_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100