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.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
log_index | INT64 | Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission. |
address | STRING | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
removed | BOOL | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
in_caller | STRING | Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string. |
in_id | STRING | Unique identifier for the position, record, or entity within the protocol. Numeric string representation. |
in_curve | STRING | Contract address of the newly created curve pool. Hex-encoded, 0x-prefixed, 42-character string. |
Sample Data
Sample Data
| in_id | address | removed | in_curve | in_caller | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0xe536175454585898b9c59b3affc8fd4cc4b225b90e7f5f5d26cd1e72ebd80f50 | 0x1f5969e331423e0845e61a64545bba8f7426106e | false | 0x17f8ddcea03a8972559a8d32874e144c87baf5b6 | 0xa844df450711a669c75795d77f92b9b519bbd19a | 141 | 34233815 | 2022-10-12T02:38:34.000Z | 0x7f2949573fb9baeb525759162052bf7ff28cfc4f10e6db1594858e8ea7f01d18 |
| 0xfcfb0551278b1114a2f2caa57df97d7b67043d2fe34284bf7024f5678d1018dd | 0x1f5969e331423e0845e61a64545bba8f7426106e | false | 0x8c6eb8c26f166f87b4f886ce07116a823805602c | 0xa844df450711a669c75795d77f92b9b519bbd19a | 141 | 34233651 | 2022-10-12T02:32:54.000Z | 0x68d6151f6ce3af913885b87bc590696f76e97af59d276617b913bbdda5eabb47 |
| 0xa937f249b607811b58d50d7f8b32db4f0841dbe710b353d6e75121f2e8b7f8a6 | 0x1f5969e331423e0845e61a64545bba8f7426106e | false | 0xefac71536febe220d0bb5128aebbd1e3df2a1e67 | 0xa844df450711a669c75795d77f92b9b519bbd19a | 107 | 34233745 | 2022-10-12T02:36:10.000Z | 0x8cea96d00cb33d8a912813a0f8900812bc02e8f40d685bd4ddeb9e83b1345989 |
Example Query
Example Query
Query with partition filter
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.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
log_index | INT64 | Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission. |
address | STRING | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
removed | BOOL | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
in_caller | STRING | Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string. |
in_id | STRING | Unique identifier for the position, record, or entity within the protocol. Numeric string representation. |
in_curve | STRING | Contract address of the newly created curve pool. Hex-encoded, 0x-prefixed, 42-character string. |
Sample Data
Sample Data
| in_id | address | removed | in_curve | in_caller | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0xc9169ef302d684a2aeae55242103c566af46e01e534d836ae2fce356c6b43e3c | 0x3591040ce5df8828b3ed4ec39d030f832d43fd53 | false | 0x0245de27be4051e217cfc87bca0b3f9b86ee9a1b | 0x33af579f8fafada29d98922a825cfc0228d7ce39 | 120 | 45084970 | 2023-07-14T22:38:18.000Z | 0x181759c9361e3ab5c3f16a2d3574b1dafaa458eea533f6855f31eacfa71d093e |
| 0xe536175454585898b9c59b3affc8fd4cc4b225b90e7f5f5d26cd1e72ebd80f50 | 0x3591040ce5df8828b3ed4ec39d030f832d43fd53 | false | 0xaab708fbd208ac262821e229ded16234277b2b13 | 0xc02cd35432b72ab6cf8f511c62ff2e89d7baa0fb | 483 | 39183520 | 2023-02-11T19:32:07.000Z | 0x4a14dc3f7e165bf2b462fe11d1bbb0e475ad48487418f9f745f7f4716bff862d |
| 0xfcfb0551278b1114a2f2caa57df97d7b67043d2fe34284bf7024f5678d1018dd | 0x3591040ce5df8828b3ed4ec39d030f832d43fd53 | false | 0xbc408da6a7237682c8672ef7a66aff09a9069b15 | 0xc02cd35432b72ab6cf8f511c62ff2e89d7baa0fb | 203 | 39183404 | 2023-02-11T19:27:59.000Z | 0x5990d8ae5a4d9a242523f4d09f7098c436d73213d0c6037da512cdef48f30e11 |
Example Query
Example Query
Query with partition filter
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.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
trace_address | STRING | Hierarchical 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. |
status | BOOL | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
from_address | STRING | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
to_address | STRING | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
value | FLOAT64 | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
gas_used | INT64 | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
gas | NUMERIC | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
signature | STRING | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
in__info | STRUCT<_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_anon0 | STRING | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
Sample Data
Sample Data
| gas | value | status | gas_used | in__info | out_anon0 | signature | to_address | block_number | from_address | trace_address | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5159656 | 0 | true | 5159656 | {“_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”} | 0xc17c47129e18ec8447e27324e925c11abd5f7f78 | 0xb483079b | 0x3591040ce5df8828b3ed4ec39d030f832d43fd53 | 45003488 | 0x33af579f8fafada29d98922a825cfc0228d7ce39 | 2023-07-12T21:00:03.000Z | 0x3c510b2bbff8782fe0b913a9629b07bc93f642863d1b250c5b3c30b3e4bd339f | |
| 7129921 | 0 | true | 5161935 | {“_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”} | 0xbc408da6a7237682c8672ef7a66aff09a9069b15 | 0xb483079b | 0x3591040ce5df8828b3ed4ec39d030f832d43fd53 | 39183404 | 0xc02cd35432b72ab6cf8f511c62ff2e89d7baa0fb | 2023-02-11T19:27:59.000Z | 0x5990d8ae5a4d9a242523f4d09f7098c436d73213d0c6037da512cdef48f30e11 | |
| 9866695 | 0 | true | 6746459 | {“_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”} | 0x6691fa63aa1d7e422dc5d19c9b04f25909fde966 | 0xb483079b | 0x3591040ce5df8828b3ed4ec39d030f832d43fd53 | 39183404 | 0xc02cd35432b72ab6cf8f511c62ff2e89d7baa0fb | 2023-02-11T19:27:59.000Z | 0x287b579115b1d037633ace0acedcb6e9dc4bba0e06b63e8a3ba349423abb7898 |
Example Query
Example Query
Query with partition filter
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.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
log_index | INT64 | Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission. |
address | STRING | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
removed | BOOL | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
in_trader | STRING | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
in_origin | STRING | Source endpoint and sender information for a cross-chain message. Struct containing source endpoint identifier (srcEid), sender address, and nonce. |
in_target | STRING | Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string. |
in_originAmount | STRING | Amount of tokens sent from the origin chain in the smallest denomination of the token. Numeric string representing the token quantity in base units. |
in_targetAmount | STRING | Amount of target tokens received in the trade. String-encoded integer representing the token quantity in its smallest denomination. |
Sample Data
Sample Data
| address | removed | in_origin | in_target | in_trader | log_index | block_number | block_timestamp | in_originAmount | in_targetAmount | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|
| 0x17f8ddcea03a8972559a8d32874e144c87baf5b6 | false | 0x2791bca1f2de4661ed88a30c99a7a9449aa84174 | 0x4fb71290ac171e1d144f7221d882becac7196eb5 | 0x1051d69861a07d0b7927f6085ae6ef4165a7c7d5 | 205 | 34695332 | 2022-10-23T09:34:36.000Z | 160200898 | 3012065961 | 0x42143e5f3f2c8cff00946fcf5a07f79382313b1975fb30c46c898a40174849ce |
| 0x17f8ddcea03a8972559a8d32874e144c87baf5b6 | false | 0x2791bca1f2de4661ed88a30c99a7a9449aa84174 | 0x4fb71290ac171e1d144f7221d882becac7196eb5 | 0x1051d69861a07d0b7927f6085ae6ef4165a7c7d5 | 149 | 34701655 | 2022-10-23T13:24:32.000Z | 80543655 | 1513676811 | 0x69ea7b8ad83ba2e832fba59923b76a1c52837b377ae3840fd7301aae72c52ebd |
| 0x17f8ddcea03a8972559a8d32874e144c87baf5b6 | false | 0x2791bca1f2de4661ed88a30c99a7a9449aa84174 | 0x4fb71290ac171e1d144f7221d882becac7196eb5 | 0xce051e8d23590f63de7a8c907cfd0763316d8f95 | 119 | 34685776 | 2022-10-23T04:00:04.000Z | 9556014 | 179729691 | 0x171f1d885afe365f060243f5cd2e1d55f6c0915f38c1a603b388a9a297c2aa26 |
Example Query
Example Query
Query with partition filter
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.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
log_index | INT64 | Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission. |
address | STRING | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
removed | BOOL | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
in_trader | STRING | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
in_origin | STRING | Source endpoint and sender information for a cross-chain message. Struct containing source endpoint identifier (srcEid), sender address, and nonce. |
in_target | STRING | Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string. |
in_originAmount | STRING | Amount of tokens sent from the origin chain in the smallest denomination of the token. Numeric string representing the token quantity in base units. |
in_targetAmount | STRING | Amount of target tokens received in the trade. String-encoded integer representing the token quantity in its smallest denomination. |
in_rawProtocolFee | STRING | Protocol 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. |
Sample Data
Sample Data
| address | removed | in_origin | in_target | in_trader | log_index | block_number | block_timestamp | in_originAmount | in_targetAmount | transaction_hash | in_rawProtocolFee |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0xbc408da6a7237682c8672ef7a66aff09a9069b15 | false | 0xdc3326e71d45186f113a2f448984ca0e8d201995 | 0x2791bca1f2de4661ed88a30c99a7a9449aa84174 | 0x5ff960b7e6d6a7c7cb9e47a455f01aface69bf45 | 134 | 65677697 | 2024-12-19T15:41:48.000Z | 150094668 | 110287806 | 0xc66d332aa130d0504b3c804674ef93bf07fb80a35e82c29b91b968747e7de1f1 | 1018075805428030153 |
| 0xbc408da6a7237682c8672ef7a66aff09a9069b15 | false | 0x2791bca1f2de4661ed88a30c99a7a9449aa84174 | 0xdc3326e71d45186f113a2f448984ca0e8d201995 | 0x5ff960b7e6d6a7c7cb9e47a455f01aface69bf45 | 541 | 65652427 | 2024-12-19T00:30:24.000Z | 109441661 | 148927334 | 0xc2655a35eaebdcbf5a64a00ca14747f3c5d5ae8005b9eb2823c34c7cbe737c58 | 1009221368272649568 |
| 0xbc408da6a7237682c8672ef7a66aff09a9069b15 | false | 0xdc3326e71d45186f113a2f448984ca0e8d201995 | 0x2791bca1f2de4661ed88a30c99a7a9449aa84174 | 0x5ff960b7e6d6a7c7cb9e47a455f01aface69bf45 | 725 | 66739839 | 2025-01-15T19:31:30.000Z | 1305507 | 961655 | 0xe08a3accbd3d15a92297ce9370a71e3fe27ec50c35dc250c15b3e5bedc30e088 | 8854437155380584 |
Example Query
Example Query
Query with partition filter
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.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
trace_address | STRING | Hierarchical 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. |
status | BOOL | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
from_address | STRING | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
to_address | STRING | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
value | FLOAT64 | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
gas_used | INT64 | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
gas | NUMERIC | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
signature | STRING | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
in__quoteCurrency | STRING | Contract address of the currency used for price quotation in the swap operation. Hex-encoded, 0x-prefixed, 42-character string. |
in__origin | STRING | Contract address of the source token being swapped or transferred. Hex-encoded, 0x-prefixed, 42-character string. |
in__target | STRING | Contract address of the destination token to receive from the swap operation. Hex-encoded, 0x-prefixed, 42-character string. |
in__originAmount | STRING | Amount of source tokens being swapped in the transaction. Numeric string representing token amount in smallest denomination. |
in__minTargetAmount | STRING | Minimum acceptable amount of target tokens to receive from the swap operation. Numeric string representing token amount in smallest denomination. |
in__deadline | STRING | Unix timestamp representing the transaction deadline by which the swap or zap operation must be executed. Numeric string in milliseconds since epoch. |
out_targetAmount_ | STRING | Actual amount of target tokens received from the swap operation. Numeric string representing token amount in smallest denomination. |
Sample Data
Sample Data
| gas | value | status | gas_used | signature | in__origin | in__target | to_address | block_number | from_address | in__deadline | trace_address | block_timestamp | in__originAmount | transaction_hash | in__quoteCurrency | out_targetAmount_ | in__minTargetAmount |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 352476 | 0 | true | 284902 | 0x9d73b325 | 0x2791bca1f2de4661ed88a30c99a7a9449aa84174 | 0x9de41aff9f55219d5bf4359f167d1d0c772a396d | 0xce051e8d23590f63de7a8c907cfd0763316d8f95 | 34806953 | 0xbdd8129032a82200ed1476cbcaa39f69a56c7a70 | 1666754494585 | 2022-10-26T03:11:47.000Z | 1249158882 | 0xbd4e38fa6622b0dad8061aa559a2d493fdaba8059dbe7f929ceb5d9367724c73 | 0x2791bca1f2de4661ed88a30c99a7a9449aa84174 | 1699268187394818281948 | 1697376572593967694435 | |
| 337493 | 0 | true | 270193 | 0x9d73b325 | 0x2791bca1f2de4661ed88a30c99a7a9449aa84174 | 0xdc3326e71d45186f113a2f448984ca0e8d201995 | 0xce051e8d23590f63de7a8c907cfd0763316d8f95 | 34815946 | 0xd6c7447fabd79f30b3c7ef498b110adb92ea109c | 1666773433198 | 2022-10-26T08:27:22.000Z | 32191175 | 0x3879b71a65401736ac5c359406120166593a3a578c00a6d6b30fc8736692a3d1 | 0x2791bca1f2de4661ed88a30c99a7a9449aa84174 | 45270779 | 44818072 | |
| 337584 | 0 | true | 265488 | 0x9d73b325 | 0x9de41aff9f55219d5bf4359f167d1d0c772a396d | 0x2791bca1f2de4661ed88a30c99a7a9449aa84174 | 0xce051e8d23590f63de7a8c907cfd0763316d8f95 | 34827233 | 0xa930487c477ec4665ad12c130e13d37c3ef77f6a | 1666797780411 | 2022-10-26T15:13:05.000Z | 2052634251704595469524 | 0x60d7bfd2eab2deeca14e09c39eaf4220362eb8150cd7fbb4465eb401b032bece | 0x2791bca1f2de4661ed88a30c99a7a9449aa84174 | 1514927076 | 1500000000 |
Example Query
Example Query
Query with partition filter
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.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
trace_address | STRING | Hierarchical 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. |
status | BOOL | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
from_address | STRING | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
to_address | STRING | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
value | FLOAT64 | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
gas_used | INT64 | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
gas | NUMERIC | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
signature | STRING | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
in__quoteCurrency | STRING | Contract address of the currency used for price quotation in the swap operation. Hex-encoded, 0x-prefixed, 42-character string. |
in__origin | STRING | Contract address of the source token being swapped or transferred. Hex-encoded, 0x-prefixed, 42-character string. |
in__target | STRING | Contract address of the destination token to receive from the swap operation. Hex-encoded, 0x-prefixed, 42-character string. |
in__originAmount | STRING | Amount of source tokens being swapped in the transaction. Numeric string representing token amount in smallest denomination. |
in__minTargetAmount | STRING | Minimum acceptable amount of target tokens to receive from the swap operation. Numeric string representing token amount in smallest denomination. |
in__deadline | STRING | Unix timestamp representing the transaction deadline by which the swap or zap operation must be executed. Numeric string in milliseconds since epoch. |
out_targetAmount_ | STRING | Actual amount of target tokens received from the swap operation. Numeric string representing token amount in smallest denomination. |
Sample Data
Sample Data
| gas | value | status | gas_used | signature | in__origin | in__target | to_address | block_number | from_address | in__deadline | trace_address | block_timestamp | in__originAmount | transaction_hash | in__quoteCurrency | out_targetAmount_ | in__minTargetAmount |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 339497 | 0 | true | 272197 | 0x9d73b325 | 0x2791bca1f2de4661ed88a30c99a7a9449aa84174 | 0x9de41aff9f55219d5bf4359f167d1d0c772a396d | 0x575f1ed1e14ac1152bf2f1cdfb2c1865ca246f51 | 45211117 | 0x451ea7e4dae03807318d8e1e10e76d719501b2e3 | 1689649435595 | 2023-07-18T02:54:04.000Z | 3098080000 | 0x7f1356fa27c996a107140329e4269e7673e22e520eb16a3d0f07903aae843343 | 0x2791bca1f2de4661ed88a30c99a7a9449aa84174 | 4084682098003377171014 | 4043997014988721029193 | |
| 356859 | 0 | true | 294085 | 0x9d73b325 | 0x2791bca1f2de4661ed88a30c99a7a9449aa84174 | 0x9de41aff9f55219d5bf4359f167d1d0c772a396d | 0x575f1ed1e14ac1152bf2f1cdfb2c1865ca246f51 | 45224528 | 0x5a9258f96f753f2f9b879e4b1beff3aab6d8f57c | 1689678539847 | 2023-07-18T11:01:48.000Z | 15306382 | 0xe1062decd7f4d04a5c076e911444d0952a625092a64b37e2821619b24040f38d | 0x2791bca1f2de4661ed88a30c99a7a9449aa84174 | 20198868315289147060 | 20000000000000000000 | |
| 356614 | 0 | true | 285292 | 0x9d73b325 | 0x2791bca1f2de4661ed88a30c99a7a9449aa84174 | 0xdc3326e71d45186f113a2f448984ca0e8d201995 | 0x575f1ed1e14ac1152bf2f1cdfb2c1865ca246f51 | 45209324 | 0xa4036d9c5d1c5edb323cedc88699e8241a3773bd | 1689645520908 | 2023-07-18T01:48:54.000Z | 2587365 | 0x2b7ebb3b0c77f33977351fa8abda5387ee964ec2431deb195e36eab568fb20a2 | 0x2791bca1f2de4661ed88a30c99a7a9449aa84174 | 3441373 | 3406898 |
Example Query
Example Query
Query with partition filter
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.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
log_index | INT64 | Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission. |
address | STRING | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
removed | BOOL | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
in_token | STRING | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_user | STRING | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_reward | STRING | Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string. |
Sample Data
Sample Data
| address | in_user | removed | in_token | in_reward | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0x08a86d5627231301edc5a9a741bf5d7a55c8e02e | 0xc31caab1be8f4e79e198df9450cddb30d7a843a7 | false | 0xe7804d91dfcde7f776c90043e03eaa6df87e6395 | 30545412330009454025 | 240 | 35139230 | 2022-11-03T06:43:26.000Z | 0xf63b0808c8c2578eb3e0b7696e96db837499a40ea9e7085218b385cbcd0e14ff |
| 0x08a86d5627231301edc5a9a741bf5d7a55c8e02e | 0xac775ff3fd5db6c46a6dffc049617e31e841cf99 | false | 0xe7804d91dfcde7f776c90043e03eaa6df87e6395 | 456014926721940733256 | 227 | 35151108 | 2022-11-03T13:45:00.000Z | 0x4d92cf60db771be3bb75d0fa55b1de5083d09cbfdf847741d120b15dea3deae7 |
| 0x3b70a6f6922c756c3616d251fde0d91c19db68bd | 0x0246b0a279dd8466ecba9b3b0af5f51076763e09 | false | 0xe7804d91dfcde7f776c90043e03eaa6df87e6395 | 75198806411131435424 | 112 | 35129166 | 2022-11-03T00:45:00.000Z | 0xfeb65d20623b47789504b5652f34c859f0713b5a97f3398ed91ffe291f9f17c6 |
Example Query
Example Query
Query with partition filter
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.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
trace_address | STRING | Hierarchical 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. |
status | BOOL | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
from_address | STRING | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
to_address | STRING | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
value | FLOAT64 | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
gas_used | INT64 | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
gas | NUMERIC | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
signature | STRING | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
in__curve | STRING | Contract address of the Curve pool for the zap operation. Hex-encoded, 0x-prefixed, 42-character string. |
in__zapAmount | STRING | Amount of tokens to be deposited into the liquidity pool through the zap operation. Numeric string representing the token quantity in its smallest denomination. |
in__deadline | STRING | Unix timestamp representing the transaction deadline by which the swap or zap operation must be executed. Numeric string in milliseconds since epoch. |
in__minLPAmount | STRING | Minimum acceptable amount of LP tokens to receive from the zap operation. Numeric string representing the token quantity in its smallest denomination. |
out_anon0 | STRING | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
Sample Data
Sample Data
| gas | value | status | gas_used | in__curve | out_anon0 | signature | to_address | block_number | from_address | in__deadline | in__zapAmount | trace_address | block_timestamp | in__minLPAmount | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1036181 | 0 | true | 958267 | 0xbe9fa3e654a1bf8fe740e9d930d595f31fce1ae2 | 2173903218157969602335 | 0x72fe6789 | 0x1051d69861a07d0b7927f6085ae6ef4165a7c7d5 | 35083194 | 0x43e61bd20737b71e003021524020d9c3d03c90ae | 1667339562762 | 2997576026054018283798 | 2022-11-01T21:43:22.000Z | 2151164383667575011497 | 0x63d24c38515cdd51bb159a3789f14420a9bf881abb8bff4f69b2deb4afb453f4 | |
| 1190704 | 0 | true | 1113061 | 0x8c6eb8c26f166f87b4f886ce07116a823805602c | 3499754745653703532301 | 0x72fe6789 | 0x1051d69861a07d0b7927f6085ae6ef4165a7c7d5 | 35054637 | 0x643700b0703c013a66d20f85538006fe3d497669 | 1667279722505 | 4999990000 | 2022-11-01T05:05:37.000Z | 3481629102813000111940 | 0x59062d8f97808bf50ca2ae8d7f1704327640998c79ec712e98874e4a834304c7 | |
| 2802830 | 0 | true | 1318659 | 0x7e4a73278d6e578af34faaaba76ed29583ac0341 | 774407641018603901576 | 0x72fe6789 | 0x1051d69861a07d0b7927f6085ae6ef4165a7c7d5 | 35077568 | 0xb39d0152dfe751d20beb2f96298407e63fe31b11 | 1667327811399 | 79543 | 2022-11-01T18:27:15.000Z | 766762094558349183976 | 0x8e2fec27334e402f8b04117d964ccb67754a79803785437530998e3237582d02 |
Example Query
Example Query
Query with partition filter
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.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
trace_address | STRING | Hierarchical 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. |
status | BOOL | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
from_address | STRING | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
to_address | STRING | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
value | FLOAT64 | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
gas_used | INT64 | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
gas | NUMERIC | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
signature | STRING | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
in__curve | STRING | Contract address of the Curve pool for the zap operation. Hex-encoded, 0x-prefixed, 42-character string. |
in__zapAmount | STRING | Amount of tokens to be deposited into the liquidity pool through the zap operation. Numeric string representing the token quantity in its smallest denomination. |
in__deadline | STRING | Unix timestamp representing the transaction deadline by which the swap or zap operation must be executed. Numeric string in milliseconds since epoch. |
in__minLPAmount | STRING | Minimum acceptable amount of LP tokens to receive from the zap operation. Numeric string representing the token quantity in its smallest denomination. |
out_anon0 | STRING | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
Sample Data
Sample Data
| gas | value | status | gas_used | in__curve | out_anon0 | signature | to_address | block_number | from_address | in__deadline | in__zapAmount | trace_address | block_timestamp | in__minLPAmount | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1312164 | 0 | true | 1242423 | 0x17f8ddcea03a8972559a8d32874e144c87baf5b6 | 1056358677928765110354 | 0x8436f16a | 0x1051d69861a07d0b7927f6085ae6ef4165a7c7d5 | 35060912 | 0xa43a8b545f49dde3ff0b313f3c748917fd3bf44f | 1667293351099 | 1058199497 | 2022-11-01T08:51:09.000Z | 1045212532464458637823 | 0xe00b3e5b7f95212edb6d2762d0bc1b9e54b191111684eee6c85cf1e60da48c9f | |
| 2263034 | 0 | true | 1053112 | 0x7e4a73278d6e578af34faaaba76ed29583ac0341 | 13769124551909250698 | 0x8436f16a | 0x1051d69861a07d0b7927f6085ae6ef4165a7c7d5 | 35079536 | 0xb39d0152dfe751d20beb2f96298407e63fe31b11 | 1667331891395 | 13933521 | 2022-11-01T19:35:17.000Z | 13640084742877467348 | 0x6a8211b0a18b949f62d1ce2ec0f763e83a3ebd5191e39ba9717efa7fa5be271a | |
| 1525721 | 0 | false | 1515932 | 0x8436f16a | 0x1051d69861a07d0b7927f6085ae6ef4165a7c7d5 | 34805594 | 0x416af050bdd31eb3cf2dec83b0399b84783038b9 | 2022-10-26T02:25:02.000Z | 0x14b34078f1e0956169304cc12a8adc53eb506be48325c3d3b9df1981d5661316 |
Example Query
Example Query
Query with partition filter
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.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
trace_address | STRING | Hierarchical 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. |
status | BOOL | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
from_address | STRING | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
to_address | STRING | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
value | FLOAT64 | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
gas_used | INT64 | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
gas | NUMERIC | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
signature | STRING | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
in__curve | STRING | Contract address of the Curve pool for the zap operation. Hex-encoded, 0x-prefixed, 42-character string. |
in__zapAmount | STRING | Amount of tokens to be deposited into the liquidity pool through the zap operation. Numeric string representing the token quantity in its smallest denomination. |
in__deadline | STRING | Unix timestamp representing the transaction deadline by which the swap or zap operation must be executed. Numeric string in milliseconds since epoch. |
in__minLPAmount | STRING | Minimum acceptable amount of LP tokens to receive from the zap operation. Numeric string representing the token quantity in its smallest denomination. |
out_anon0 | STRING | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
Sample Data
Sample Data
| gas | value | status | gas_used | in__curve | out_anon0 | signature | to_address | block_number | from_address | in__deadline | in__zapAmount | trace_address | block_timestamp | in__minLPAmount | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1127826 | 0 | false | 1117992 | 0x72fe6789 | 0xa070fb11969a50aacc885b7b5245cbc84de2214c | 40373320 | 0x72c65dda795d9a2efa35643e598183ddc3c2a5cc | 2023-03-15T12:18:47.000Z | 0x16b61aeb2e193511094d07275adc0e66afccacbe39028f2586bc0d1bbbd21f33 | ||||||
| 1047123 | 0 | false | 1037109 | 0x72fe6789 | 0xa070fb11969a50aacc885b7b5245cbc84de2214c | 40373357 | 0x72c65dda795d9a2efa35643e598183ddc3c2a5cc | 2023-03-15T12:20:05.000Z | 0x0216b9f434f4aed79260c6c54ef42dc15fdcb9959ff29c9bc06ef3b85920b190 | ||||||
| 1047123 | 0 | false | 1047123 | 0xbc408da6a7237682c8672ef7a66aff09a9069b15 | 0x72fe6789 | 0xa070fb11969a50aacc885b7b5245cbc84de2214c | 40373302 | 0x72c65dda795d9a2efa35643e598183ddc3c2a5cc | 1678883263660 | 9990000 | 2023-03-15T12:18:09.000Z | 7313788943282239275 | 0x65cbe7366a2f59520eb78da8ee262cbb640f1a4114144fa38cf1314671c8de80 |
Example Query
Example Query
Query with partition filter
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.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
trace_address | STRING | Hierarchical 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. |
status | BOOL | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
from_address | STRING | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
to_address | STRING | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
value | FLOAT64 | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
gas_used | INT64 | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
gas | NUMERIC | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
signature | STRING | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
in__curve | STRING | Contract address of the Curve pool for the zap operation. Hex-encoded, 0x-prefixed, 42-character string. |
in__zapAmount | STRING | Amount of tokens to be deposited into the liquidity pool through the zap operation. Numeric string representing the token quantity in its smallest denomination. |
in__deadline | STRING | Unix timestamp representing the transaction deadline by which the swap or zap operation must be executed. Numeric string in milliseconds since epoch. |
in__minLPAmount | STRING | Minimum acceptable amount of LP tokens to receive from the zap operation. Numeric string representing the token quantity in its smallest denomination. |
out_anon0 | STRING | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
Sample Data
Sample Data
| gas | value | status | gas_used | in__curve | out_anon0 | signature | to_address | block_number | from_address | in__deadline | in__zapAmount | trace_address | block_timestamp | in__minLPAmount | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1118245 | 0 | true | 1048174 | 0x2385d7ab31f5a470b1723675846cb074988531da | 3835297916023205191870 | 0x8436f16a | 0xa070fb11969a50aacc885b7b5245cbc84de2214c | 41787717 | 0x93cf0a22a26895650a8aae960bf85a01ec6a551c | 1682084634427 | 3880340472 | 2023-04-21T13:34:30.000Z | 3828414424800003527546 | 0x684d0ee17c6102eb1f2c3efdb457bf42aebdba5b71c446191c9a6952c03a63ac | |
| 2330393 | 0 | true | 2252561 | 0x7b95c61f05e9720b778e81d8794f0f5dca704d1a | 11329414268743432725 | 0x8436f16a | 0xa070fb11969a50aacc885b7b5245cbc84de2214c | 48040628 | 0x9f8005a794fb01b7d950626ebe9c254c5e7aff51 | 1695809088990 | 11643005 | 2023-09-27T09:55:08.000Z | 11204755172972083777 | 0x14a6090747ebc41fdcd5be19d28912837fc9bef67f7c798bdcab9db8889b864a | |
| 1377709 | 0 | false | 1377532 | 0x8436f16a | 0xa070fb11969a50aacc885b7b5245cbc84de2214c | 45271939 | 0x8541cbbce3683b6be5b7a6e0a3bcf380a9a561d5 | 2023-07-19T17:02:41.000Z | 0x5a0e3672f2615f7576aa5be4eac8c9ec7ce1211feea3b1c32f7b898aa57bc93c |
Example Query
Example Query
Query with partition filter