dfx_v2_ethereum

Tables

CurveFactoryV2_NewCurve_event

Pool deployment events from Curve Finance Factory V2 contract on Ethereum. Captures newly created liquidity pool addresses with deployer information for tracking Curve ecosystem growth and pool analytics.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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

in_id	address	removed	in_curve	in_caller	log_index	block_number	block_timestamp	transaction_hash
0x7b1f61981a7efffb03de0ee406a2d352f36b21ff443514acf585ca23aac13566	0xde5bb69892d663f1facbe351363509bcb65573aa	false	0x477658494c3541ba272a7120176d77674a0183ba	0xa75ceb6801d48449affa0ee6f31205b2a5567bec	113	15747451	2022-10-14T16:10:11.000Z	0x10c7e7e2f5634e05743aba3ff0ed5cd415fb31e4079f95297e2208ce1bbf73af
0xabf20d296f8652c576a05ff7445b7d356fae74c3e7188fe1a933a0b61c420582	0xde5bb69892d663f1facbe351363509bcb65573aa	false	0xf3d7aa346965656e7c65fb4135531e0c2270af83	0xa75ceb6801d48449affa0ee6f31205b2a5567bec	230	15747427	2022-10-14T16:05:11.000Z	0xda97a4fa92da5b86ac0c4d142aa83fab2f3272881e8647a00cbe8f86741a2580
0x32752d3abaf47a6461da245ee67864703219b3d4181f98a2ec4c3b40b3e7ce77	0xde5bb69892d663f1facbe351363509bcb65573aa	false	0x63cb0f59b7e67c7d4cb96214ca456597d85c587d	0xa75ceb6801d48449affa0ee6f31205b2a5567bec	142	15747495	2022-10-14T16:19:11.000Z	0x3efb87d409d1ead52780e2730f3a1207a2250cf2a0583ba692c4d3c9cee70066

Example Query

Query with partition filter

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

CurveFactoryV22_NewCurve_event

Curve Finance Factory V2.2 pool creation events on Ethereum, emitted when new liquidity pools are deployed through the factory contract. Used for tracking pool launches, identifying deployers, and analyzing Curve ecosystem expansion.

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

in_id	address	removed	in_curve	in_caller	log_index	block_number	block_timestamp	transaction_hash
0x617b4482b422e13518c6990980fb4103473d2279b89debcf6dce6988040f3e7d	0x9adeac3b6d29d9d5e543b8579e803a7cce72c9cd	false	0x7d1ba2c18cbde0d790cc1d626f0c70b3c13c9eec	0xc02cd35432b72ab6cf8f511c62ff2e89d7baa0fb	34	16723372	2023-02-28T01:23:11.000Z	0x0c91091e9a0941fccaac9a6a5da8c23ad21db8432ad4de6ba93924bc4c4b305d
0x7b1f61981a7efffb03de0ee406a2d352f36b21ff443514acf585ca23aac13566	0x9adeac3b6d29d9d5e543b8579e803a7cce72c9cd	false	0x8cd86fbc94bebfd910caae7ae4ce374886132c48	0xc02cd35432b72ab6cf8f511c62ff2e89d7baa0fb	51	16607851	2023-02-11T20:16:59.000Z	0x4ac3cb0da1c8ad2ffe44dd4658a2b037888651a7fd5d996e9ff3a965ef987bff
0xabf20d296f8652c576a05ff7445b7d356fae74c3e7188fe1a933a0b61c420582	0x9adeac3b6d29d9d5e543b8579e803a7cce72c9cd	false	0xda9dcc7fd51f0d9aa069a82647a5f3ba594edaed	0xc02cd35432b72ab6cf8f511c62ff2e89d7baa0fb	42	16607851	2023-02-11T20:16:59.000Z	0x5bc4086e05373ba8cf5be7c598f48df817ad659b72540f8109c91dac975125e1

Example Query

Query with partition filter

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

CurveFactoryV22_newCurve_function

Curve deployment records from DFX Protocol’s factory contract on Ethereum, capturing the creation of new forex-stablecoin liquidity pools. Contains pool configuration parameters including oracle addresses, curve coefficients (alpha, beta, epsilon, lambda), and deployed contract addresses for analyzing DFX’s multi-currency stablecoin infrastructure.

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`	`INT64`	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>`	Input parameters for the new Curve pool creation, including token pairs, oracle addresses, and pool configuration settings. Contains structured data for base/quote currencies, weights, price feeds, and fee parameters specific to DFX protocol’s stablecoin AMM (Automated Market Maker) pools.
`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

gas	status	gas_used	in__info	out_anon0	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
9870159	true	6748827	{“_beta”:“350000000000000000”,“_name”:“dfx-cadc-usdc-v2”,“_alpha”:“500000000000000000”,“_lambda”:“1000000000000000000”,“_symbol”:“dfx-cadc-v2”,“_epsilon”:“1500000000000000”,“_feeAtHalt”:“150000000000000000”,“_baseOracle”:“0xa34317db73e77d453b1b8d04550c44d10e981c8e”,“_baseWeight”:“500000000000000000”,“_quoteOracle”:“0x8fffffd4afb6115b954bd326cbe7b4ba576818f6”,“_quoteWeight”:“500000000000000000”,“_baseCurrency”:“0xcadc0acd4b445166f12d2c07eac6e2544fbe2eef”,“_quoteCurrency”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”}	0xda9dcc7fd51f0d9aa069a82647a5f3ba594edaed	0xb483079b	0x9adeac3b6d29d9d5e543b8579e803a7cce72c9cd	16607851	0xc02cd35432b72ab6cf8f511c62ff2e89d7baa0fb	2023-02-11T20:16:59.000Z	0x5bc4086e05373ba8cf5be7c598f48df817ad659b72540f8109c91dac975125e1
7128293	true	5160756	{“_beta”:“350000000000000000”,“_name”:“dfx-euroc-usdc-v2”,“_alpha”:“500000000000000000”,“_lambda”:“1000000000000000000”,“_symbol”:“dfx-euroc-v2”,“_epsilon”:“1500000000000000”,“_feeAtHalt”:“150000000000000000”,“_baseOracle”:“0xb49f677943bc038e9857d61e7d053caa2c1734c1”,“_baseWeight”:“500000000000000000”,“_quoteOracle”:“0x8fffffd4afb6115b954bd326cbe7b4ba576818f6”,“_quoteWeight”:“500000000000000000”,“_baseCurrency”:“0x1abaea1f7c830bd89acc67ec4af516284b1bc33c”,“_quoteCurrency”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”}	0x8cd86fbc94bebfd910caae7ae4ce374886132c48	0xb483079b	0x9adeac3b6d29d9d5e543b8579e803a7cce72c9cd	16607851	0xc02cd35432b72ab6cf8f511c62ff2e89d7baa0fb	2023-02-11T20:16:59.000Z	0x4ac3cb0da1c8ad2ffe44dd4658a2b037888651a7fd5d996e9ff3a965ef987bff
7133045	true	5164196	{“_beta”:“350000000000000000”,“_name”:“dfx-xsgd-usdc-v2”,“_alpha”:“500000000000000000”,“_lambda”:“1000000000000000000”,“_symbol”:“dfx-xsgd-v2”,“_epsilon”:“1500000000000000”,“_feeAtHalt”:“150000000000000000”,“_baseOracle”:“0xe25277ff4bbf9081c75ab0eb13b4a13a721f3e13”,“_baseWeight”:“500000000000000000”,“_quoteOracle”:“0x8fffffd4afb6115b954bd326cbe7b4ba576818f6”,“_quoteWeight”:“500000000000000000”,“_baseCurrency”:“0x70e8de73ce538da2beed35d14187f6959a8eca96”,“_quoteCurrency”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”}	0xacc5dca0b684f444bc6b4be30b95ca7d928a4b9c	0xb483079b	0x9adeac3b6d29d9d5e543b8579e803a7cce72c9cd	16607852	0xc02cd35432b72ab6cf8f511c62ff2e89d7baa0fb	2023-02-11T20:17:11.000Z	0x69306d86fc02ead36366e082802ae4bca0d2c9a62c6f8194e63673c57e40b842

Example Query

Query with partition filter

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

CurveV2_Trade_event

Token swap transactions from Curve V2 liquidity pools on Ethereum. Each record captures the origin token, target token, amounts exchanged, and trader address for analyzing DEX trading volumes and price execution.

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

address	removed	in_origin	in_target	in_trader	log_index	block_number	block_timestamp	in_originAmount	in_targetAmount	transaction_hash
0x477658494c3541ba272a7120176d77674a0183ba	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x1abaea1f7c830bd89acc67ec4af516284b1bc33c	0xa06943f16e0bcd73025807428c0ab1088575f1b7	104	15832797	2022-10-26T14:18:35.000Z	29993189667	29889616234	0x5b6fe82af8a39181cd909dc748c1cbc871435222bf13e9550f421c47fa45fe07
0x46161158b1947d9149e066d6d31af1283b2d377c	false	0xebf2096e01455108badcbaf86ce30b6e5a72aa52	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0xa06943f16e0bcd73025807428c0ab1088575f1b7	138	15829197	2022-10-26T02:15:47.000Z	1000000000000000	64047199538	0x2207812896997e0e128c9a04805e8e625e13a3303b3d4fa578a78d89205b6dee
0x477658494c3541ba272a7120176d77674a0183ba	false	0x1abaea1f7c830bd89acc67ec4af516284b1bc33c	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0xa06943f16e0bcd73025807428c0ab1088575f1b7	300	15830441	2022-10-26T06:25:23.000Z	15120943116	15058707105	0x1a7625db68e854d471471ce7af80bedc8957fc37e43a444b790dd19d8c463f62

Example Query

Query with partition filter

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

CurveV22_Trade_event

Trade execution events from DFX (formerly known as DFX Finance) V2 stablecoin swaps on Ethereum, capturing origin/target token pairs, amounts, traders, and protocol fees. Used for analyzing foreign exchange-focused stablecoin trading patterns and fee generation across DFX liquidity pools.

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`	Raw protocol fee amount collected by Curve V2 on this trade, denominated in the smallest unit of the fee token. Typically a large integer value representing wei or similar base units.

Sample Data

address	removed	in_origin	in_target	in_trader	log_index	block_number	block_timestamp	in_originAmount	in_targetAmount	transaction_hash	in_rawProtocolFee
0xacc5dca0b684f444bc6b4be30b95ca7d928a4b9c	false	0x70e8de73ce538da2beed35d14187f6959a8eca96	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x9bba6805f25b35bdf65e50a42015369e7825428e	227	16700163	2023-02-24T19:07:23.000Z	4364918026	3231681861	0xe2aaceb6d5d8b6c6b118eea156f539473983d28a0db329e29353500d1d743963	44773568280826349491
0xc147cee0f6bb0e56240868c9f53ae916d3b86073	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0xda446fad08277b4d2591536f204e018f32b6831c	0x9bba6805f25b35bdf65e50a42015369e7825428e	232	16700163	2023-02-24T19:07:23.000Z	3231681861	5225531336	0xe2aaceb6d5d8b6c6b118eea156f539473983d28a0db329e29353500d1d743963	89412844264796093446
0xc147cee0f6bb0e56240868c9f53ae916d3b86073	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0xda446fad08277b4d2591536f204e018f32b6831c	0xf3cc0702493d394323187f330830b7bf0a9b545d	550	16697140	2023-02-24T08:53:35.000Z	15632160381	25104486798	0xe5bdc739e2a57f9e283715e2dd6e5e678a5044403e416c00bc79ebac948d14f2	432504759628923729430

Example Query

Query with partition filter

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

RouterV2_originSwap_function

Function call records for DFX protocol’s RouterV2 originSwap contract on Ethereum, capturing token swap transactions with origin/target tokens, amounts, deadlines, and price slippage parameters. Used for analyzing DFX stablecoin exchange activity and execution prices.

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`	`INT64`	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

gas	status	gas_used	signature	in__origin	in__target	to_address	block_number	from_address	in__deadline	block_timestamp	in__originAmount	transaction_hash	in__quoteCurrency	out_targetAmount_	in__minTargetAmount
338992	true	271692	0x9d73b325	0x70e8de73ce538da2beed35d14187f6959a8eca96	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0xa06943f16e0bcd73025807428c0ab1088575f1b7	15866801	0x39e1d2007901f8c774bfbfaa1a096b7defe1faab	1667204937972	2022-10-31T08:19:35.000Z	29858959150	0x3aca5bd503afa42d49803201136453438e8d684a771bc592761b59f4b1e4a768	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	21118360034	21097241674
350312	true	287546	0x9d73b325	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0xc08512927d12348f6620a698105e1baac6ecd911	0xa06943f16e0bcd73025807428c0ab1088575f1b7	15867328	0x55639dac6e3d86d3d291716c63efcd9b209b9a3c	1667211291152	2022-10-31T10:05:11.000Z	18000000000	0xda86e428c6fe1d795d7caa159a28f133ca056ba1c5a9fbb137d46454955ef3f3	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	2666964009758	2664297045749
350312	true	287546	0x9d73b325	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0xc08512927d12348f6620a698105e1baac6ecd911	0xa06943f16e0bcd73025807428c0ab1088575f1b7	15867518	0x55639dac6e3d86d3d291716c63efcd9b209b9a3c	1667213576368	2022-10-31T10:43:11.000Z	20000000000	0x94a02493426ba008c5b74934f55c1c87d28fb72a665547f30ce9bfbca71e5e99	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	2968444115955	2965475671840

Example Query

Query with partition filter

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

RouterV22_originSwap_function

DFX (decentralized foreign exchange) V2 protocol swap transactions on Ethereum, capturing token exchanges with origin/target currencies, amounts, and slippage parameters. Used for analyzing stablecoin and forex token trading activity through DFX’s automated market maker.

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`	`INT64`	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

gas	status	gas_used	signature	in__origin	in__target	to_address	block_number	from_address	in__deadline	block_timestamp	in__originAmount	transaction_hash	in__quoteCurrency	out_targetAmount_	in__minTargetAmount
343449	true	274760	0x9d73b325	0xc08512927d12348f6620a698105e1baac6ecd911	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x9bba6805f25b35bdf65e50a42015369e7825428e	17406208	0x6394a6c8718eda7f1f0e6c43df28f0605aa6d46d	1685869643597	2023-06-04T08:57:35.000Z	177021456127	0x57b6a690afc0a4de27def388e6db30038a77222c7d226697f900d0e8a5eb06dc	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	1263212199	1250580078
387423	true	315323	0x9d73b325	0xda446fad08277b4d2591536f204e018f32b6831c	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x9bba6805f25b35bdf65e50a42015369e7825428e	17406918	0x0f5e1e7821ceeaad5a6884bfa5b7ff1ea30c6227	1685878281798	2023-06-04T11:22:23.000Z	2448215129	0x312fc7e8e0517c234f6c991596b7279e93eef17b30e80d34e219c2b94aac2317	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	1284521996	1271676777
352644	true	285072	0x9d73b325	0xcadc0acd4b445166f12d2c07eac6e2544fbe2eef	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x9bba6805f25b35bdf65e50a42015369e7825428e	16934258	0x3732fe38e7497da670bd0633d565a5d80d3565e2	1680109408018	2023-03-29T16:54:11.000Z	72000000000000000000000	0xc122d2ee007c4a7084666c749ef502bca52123f4de7ab261a732bfb37ec5b7f1	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	52969370249	52704523398

Example Query

Query with partition filter

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

ZapV2_zapFromBase_function

DFX protocol zap function calls that convert base tokens into liquidity provider (LP) tokens via specified Curve pools on Ethereum. Tracks deposits with input amounts, slippage protection parameters, and resulting LP token outputs for liquidity provision analysis.

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`	`INT64`	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

gas	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
1354854	true	1354635	0x764a5a29f982d3513e76fe07df2034821fbdba72	28163733410198275618480	0x72fe6789	0xeff6a7d39eeaa696d7421fa47b498b31f3bd0e39	15876624	0xf3adff70d3897d6d8cceaa082e18fe418329f4fb	1666908638479	50000000000	0,1	2022-11-01T17:19:23.000Z	27857004219047445044211	0x6720cd8b8b74729f8b9e9d46730f8b1fcd52f49030d6d807c700881b019edab0
941767	true	873448	0x477658494c3541ba272a7120176d77674a0183ba	2096118184508463448105	0x72fe6789	0xeff6a7d39eeaa696d7421fa47b498b31f3bd0e39	15818194	0x05f13a948a4c345e4921adb4ec12f9c76ee3d331	1666617839157	2143338843		2022-10-24T13:14:35.000Z	2078977123606550265544	0x0b8e68141baba7cd7643fd8c5536ecc4c5cb5d32cca9bb8020f8e16935abd9c3
1184918	true	1096918	0x63cb0f59b7e67c7d4cb96214ca456597d85c587d	2309811255823816185351	0x72fe6789	0xeff6a7d39eeaa696d7421fa47b498b31f3bd0e39	15784565	0xeae3974c879fbeb83cdbe537737c519cbe8836da	1666212231368	345452098057		2022-10-19T20:34:23.000Z	2286036674105239726805	0xbb1f15f8fcd785fb68b2f71a9a61b6c0ce96efb13dfa76843b9f47b4d4ff0956

Example Query

Query with partition filter

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

ZapV2_zapFromQuote_function

Function call logs for DFX Finance V2 zap operations that convert quote tokens into liquidity provider (LP) tokens on Ethereum. Tracks deposits into DFX curve pools with slippage protection via minimum LP amount parameters.

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`	`INT64`	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

gas	status	gas_used	in__curve	out_anon0	signature	to_address	block_number	from_address	in__deadline	in__zapAmount	block_timestamp	in__minLPAmount	transaction_hash
1619515	true	1551415	0xcf3c8f51de189c8d5382713b716b133e485b99b7	7054326348785014137785	0x8436f16a	0xeff6a7d39eeaa696d7421fa47b498b31f3bd0e39	15929640	0xa457549ff0bed5a952e2fbdf308478a73debd736	1667963264279	7000000000	2022-11-09T02:57:59.000Z	6981531568054562715711	0x24f712bbcfa922b642704d53ecf2015f78f426aeb4c6b81f6c80092e7b5996b4
1681632	true	1613532	0xcf3c8f51de189c8d5382713b716b133e485b99b7	100629037062980709757	0x8436f16a	0xeff6a7d39eeaa696d7421fa47b498b31f3bd0e39	15930361	0x383cdbcfa1249dc5220a3a84134d9ac95b10ce1a	1667971925113	100000000	2022-11-09T05:22:47.000Z	99628952338359205132	0xb7809b55e9ed3372e1a75ba8dc8b69764fd38fd6a9bf6d25fb489e49196806f3
928725	true	860625	0xf3d7aa346965656e7c65fb4135531e0c2270af83	4014100198685834101852	0x8436f16a	0xeff6a7d39eeaa696d7421fa47b498b31f3bd0e39	15929574	0x8f0d4cd6f0dc60e315188ccc1c42f266e8de86ae	1667962454226	4086067762	2022-11-09T02:44:35.000Z	3972111683574992915574	0xeaa19a7123dcf003e49e4519358b970e1209bb9842df01529799403a50515ad7

Example Query

Query with partition filter

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

ZapV22_zapFromBase_function

DFX (decentralized foreign exchange) Protocol V2 zap function calls on Ethereum that convert base assets into liquidity provider (LP) tokens in one transaction. Records include input amounts, Curve pool addresses, minimum LP amounts, and returned LP tokens for analyzing liquidity provision patterns.

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`	`INT64`	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

gas	status	gas_used	in__curve	out_anon0	signature	to_address	block_number	from_address	in__deadline	in__zapAmount	block_timestamp	in__minLPAmount	transaction_hash
1044640	true	976540	0x7d1ba2c18cbde0d790cc1d626f0c70b3c13c9eec	936407566869809893995	0x72fe6789	0xf3cc0702493d394323187f330830b7bf0a9b545d	16823161	0x61bdfe77ccede9a4cc900644b9e3e908b52345ad	1678760752873	773829822251590510050	2023-03-14T02:16:11.000Z	934036863100703555267	0x8b92baa3a87f57b679c373fd177376aee2854ede2eb409d00db37d048d678554
974040	true	900917	0x8cd86fbc94bebfd910caae7ae4ce374886132c48	4143568351966006436187	0x72fe6789	0xf3cc0702493d394323187f330830b7bf0a9b545d	18233479	0x2dd38f8e6245c6efde41018f7086c8db828e629f	1695895568080	3954078788	2023-09-28T09:56:35.000Z	4098030535777900025453	0x082ba5002ead9cd6a30ec9e5d7de24365db5ce6546bdeab1be3ea3afb81c9a41
1024358	true	951458	0xacc5dca0b684f444bc6b4be30b95ca7d928a4b9c	12458994463238878185657	0x72fe6789	0xf3cc0702493d394323187f330830b7bf0a9b545d	16820982	0x15d04985a77c97961b1393aa247326661ccb4d63	1678734269670	16763333378	2023-03-13T18:54:59.000Z	12322070114087882914397	0xbfda49087a5b261f8f884030adde2ad852a97dd55255a111e468843f9595fed8

Example Query

Query with partition filter

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

ZapV22_zapFromQuote_function

DFX (decentralized foreign exchange) ZapV2 function calls for converting quote tokens into Curve liquidity provider (LP) tokens on Ethereum. Records zap transactions with input amounts, minimum LP token expectations, deadline parameters, and actual LP tokens received for analyzing liquidity provision patterns.

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`	`INT64`	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

gas	status	gas_used	in__curve	out_anon0	signature	to_address	block_number	from_address	in__deadline	in__zapAmount	block_timestamp	in__minLPAmount	transaction_hash
1068461	true	995561	0xc147cee0f6bb0e56240868c9f53ae916d3b86073	26232812576444995766109	0x8436f16a	0xf3cc0702493d394323187f330830b7bf0a9b545d	16697140	0x15d04985a77c97961b1393aa247326661ccb4d63	1677229395888	26070573664	2023-02-24T08:53:35.000Z	25944513966229865262639	0xe5bdc739e2a57f9e283715e2dd6e5e678a5044403e416c00bc79ebac948d14f2
1094796	true	1026696	0xc147cee0f6bb0e56240868c9f53ae916d3b86073	36199499010078143479730	0x8436f16a	0xf3cc0702493d394323187f330830b7bf0a9b545d	16700983	0xd8942da20c0438d67a55ca4db93d08a8625ccd5d	1677276229169	35832233087	2023-02-24T21:54:59.000Z	35801666515957384682888	0x5fbed025cf45a5d0059db9a8d68a3f0729e891a5242d4d9854d4e3ce6ed14668
964401	true	896301	0xc147cee0f6bb0e56240868c9f53ae916d3b86073	4304899529470761879988	0x8436f16a	0xf3cc0702493d394323187f330830b7bf0a9b545d	16700191	0x8f0d4cd6f0dc60e315188ccc1c42f266e8de86ae	1677266563224	4256524906	2023-02-24T19:12:59.000Z	4257588683641878206927	0x8d26d3b0d77d432cfad1243933e9038cf2d8f56b4accf907244a6cf13db6e021

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

CurveFactoryV2_NewCurve_event

CurveFactoryV22_NewCurve_event

CurveFactoryV22_newCurve_function

CurveV2_Trade_event

CurveV22_Trade_event

RouterV2_originSwap_function

RouterV22_originSwap_function

ZapV2_zapFromBase_function

ZapV2_zapFromQuote_function

ZapV22_zapFromBase_function

ZapV22_zapFromQuote_function

​Tables

​CurveFactoryV2_NewCurve_event

​CurveFactoryV22_NewCurve_event

​CurveFactoryV22_newCurve_function

​CurveV2_Trade_event

​CurveV22_Trade_event

​RouterV2_originSwap_function

​RouterV22_originSwap_function

​ZapV2_zapFromBase_function

​ZapV2_zapFromQuote_function

​ZapV22_zapFromBase_function

​ZapV22_zapFromQuote_function

Tables

CurveFactoryV2_NewCurve_event

CurveFactoryV22_NewCurve_event

CurveFactoryV22_newCurve_function

CurveV2_Trade_event

CurveV22_Trade_event

RouterV2_originSwap_function

RouterV22_originSwap_function

ZapV2_zapFromBase_function

ZapV2_zapFromQuote_function

ZapV22_zapFromBase_function

ZapV22_zapFromQuote_function