dfx_v1_ethereum

Tables

Curve_Trade_event

Token swap executions from DFX Protocol (formerly Curve) on Ethereum, recording origin and target token addresses with amounts for analyzing stablecoin and forex trading flows.

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
0x66310ec13f36caf5532c32b4359760592db835ab	false	0x1abaea1f7c830bd89acc67ec4af516284b1bc33c	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x9d0950c595786aba7c26dfddf270d66a8b18b4fa	428	15538979	2022-09-15T12:04:23.000Z	36139049638	36088357483	0x68abc6677456fb483aaf44b31a34b68f9faf628191c9901de9209b646dd5f61c
0x66310ec13f36caf5532c32b4359760592db835ab	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x1abaea1f7c830bd89acc67ec4af516284b1bc33c	0x1c073d5045b1abb6924d5f0f8b2f667b1653a4c3	26	15540644	2022-09-15T17:41:47.000Z	42592000000	42535191405	0xe963e3b3dfded33227dc61b4d84d555533743ac9a29dd1947a329055418e7fef
0xa6c0cbcaebd93ad3c6c94412ec06aaa37870216d	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0xcadc0acd4b445166f12d2c07eac6e2544fbe2eef	0xf2f400c138f9fb900576263af0bc7fcde2b1b8a8	53	15539734	2022-09-15T14:37:11.000Z	2174563864	2867704459889224011123	0xcff9a87bb90e43b9d2df7663caa7fc817738f35a3ef606dcac19fd843bb75415

Example Query

Query with partition filter

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

CurveFactory_NewCurve_event

Curve pool deployment events from the DFX (formerly Decentralized Foreign Exchange) protocol factory contract on Ethereum. Tracks new stablecoin liquidity pool creation with deployer address, pool address, and unique pool identifier for monitoring protocol 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
0xf470ff748917ed8c3cf843ac8df44d10c97568916c22024c5fd2c8cbfc6a3559	0xd3c1bf5582b5f3029b15be04a49c65d3226dfb0c	false	0xc574a613a3900e4314da13eb2287f13689a5b64d	0x27e843260c71443b4cc8cb6bf226c3f77b9695af	464	13282225	2021-09-23T13:16:50.000Z	0xf522fcb39509a3c7aaaa9a3d0df7284366e36ec66d8df1e801c276951d742831
0x32752d3abaf47a6461da245ee67864703219b3d4181f98a2ec4c3b40b3e7ce77	0xd3c1bf5582b5f3029b15be04a49c65d3226dfb0c	false	0x57bc10876febdc57f0abb8c82ffae600eecc03a2	0x27e843260c71443b4cc8cb6bf226c3f77b9695af	40	15528926	2022-09-13T20:27:42.000Z	0x34d0737c556345a44a0b239f2e0b0c00f04c2adabbaae337bae4d572cad3d725
0xaf3ebb6fad37a0eaecb2a07a0565c4a3e9d9170f40f17c5c56085271505211a1	0xd3c1bf5582b5f3029b15be04a49c65d3226dfb0c	false	0xdd39379ab7c93b9baae29e6ec03795d0bc99a889	0x27e843260c71443b4cc8cb6bf226c3f77b9695af	304	13720540	2021-12-01T10:31:54.000Z	0x16a9feb78a8ad111e64fd0936435b26bc1624a886ae79ad55535ff9b6138b9d5

Example Query

Query with partition filter

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

Router_originSwap_function

Token swap executions from DFX Protocol’s Router contract on Ethereum, recording origin and target token amounts with slippage protection parameters. Used for analyzing stablecoin swap volumes and price impacts 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.
`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
307424	true	245940	0x9d73b325	0xdb25f211ab05b1c97d595516f45794528a807ad8	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x9d0950c595786aba7c26dfddf270d66a8b18b4fa	14021946	0x758c30d1b462575f0bc1cd8fb0a0c8cec002a6df	1642408640214	2022-01-17T08:32:29.000Z	184395	0x409abe6e78ad893082318dfe672c259443d66e7b9845ded0d45d8377c1611d7f	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	2123550137	2112932387
286944	true	229556	0x9d73b325	0xcadc0acd4b445166f12d2c07eac6e2544fbe2eef	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x9d0950c595786aba7c26dfddf270d66a8b18b4fa	14023778	0xd90d5c7a6ebb19b45959cd622367e4be0985a05c	1642432970347	2022-01-17T15:12:58.000Z	8586241053598997836221	0x9cb01e12e1d20c8e92ef6b3249af6f87088beabbbe0607f2a50d02ead6f47696	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	6846897030	6812662545
288632	true	230906	0x9d73b325	0x70e8de73ce538da2beed35d14187f6959a8eca96	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x9d0950c595786aba7c26dfddf270d66a8b18b4fa	14023757	0x66d56e8b63f9874a376b8d3cec656581d49dc9fe	1642432661280	2022-01-17T15:07:53.000Z	7375916644	0xb0b325dcb0e1702556e0954b8d30ddbd3d94302cbbe84535556a3d4cbba71cb5	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	5469397095	5442050110

Example Query

Query with partition filter

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

StakingRewards_RewardPaid_event

Reward distribution events from StakingRewards contracts recording when staked positions earn incentives. Contains recipient address, reward amount, and optional token or position identifiers for tracking yield distribution across protocols.

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_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

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0xe06fa52e0d2d58fe192285bfa0507f09cdd9824a	0x45f9675804904a6d8116354bd9ba74cdbdbc88ca	false	4281982559541494277481	594	13884023	2021-12-27T00:23:29.000Z	0x4fd4b204ac6d8b240b2eaa3efa765a7f41c2761857fd3dd77f479dea0981d200
0x84bf8151394dcf32146965753b28760550f3d7a8	0x324e0b53cefa84cf970833939249880f814557c6	false	3131728036050056579335	109	13884052	2021-12-27T00:29:47.000Z	0xd6f1c77a6e643794e4320e9b2165b84ee934f08e2286c42cdbf10fa0a2f4c394
0xe29b7285c1169a9765e2a9bfe74209077bee55d6	0xdc4d38c70d1c038d500e5c59654392b78cdb460f	false	2226622167977788032263	484	13884820	2021-12-27T03:17:16.000Z	0x821bb45618c991a5fc4c748631ce48ba41e9d12b4c70a6a945421530467a3061

Example Query

Query with partition filter

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

Zap_zapFromBase_function

DFX Protocol zap function calls on Ethereum that convert base assets into liquidity provider (LP) tokens through Curve pools. Records include input amounts, minimum LP tokens expected, curve pool addresses, and output LP tokens received for analyzing liquidity provision activity.

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
850016	true	781415	0xe9669516e09f5710023566458f329cce6437aaac	20989349085710820217200	0x72fe6789	0x64d65e3d70ba0f8812a9d1d7b8b5c51dab78cd15	13489620	0x0f13b090efcceeb2ffb6711a5326546e25142709	1635206091868	29588000000	2021-10-25T23:49:05.000Z	20863517937941983849998	0xb6368eb1bd47406d8bae9b39272eec3232ddd401ce44acc114cdac8321f09562
699052	true	630952	0xa6c0cbcaebd93ad3c6c94412ec06aaa37870216d	40961592511549902464417	0x72fe6789	0x64d65e3d70ba0f8812a9d1d7b8b5c51dab78cd15	12614931	0x99c4fe0d7b8aeb5c5234914be2411648d89e4ba7	1623437637942	49975000000000000000000	2021-06-11T18:45:02.000Z	40920630919038352561952	0x29ea6cb4b592e13863fd7e79d12ef87a80bba86cda4fd7db9205479930e312a9
745568	true	677468	0xa6c0cbcaebd93ad3c6c94412ec06aaa37870216d	43625083998752708949441	0x72fe6789	0x64d65e3d70ba0f8812a9d1d7b8b5c51dab78cd15	12613382	0x25dc74048fdda2b3b321320293e48d0d3dff1c1d	1623416811662	53673388495416283420093	2021-06-11T12:59:11.000Z	43581458914753956240491	0xafcf029c103176166ff46fd589d91d762ecda722f09488455263e75b6aa5c36f

Example Query

Query with partition filter

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

Zap_zapFromQuote_function

Quote-based liquidity provision transactions for DFX protocol Curve pools on Ethereum. Records user deposits with input amounts, minimum LP token requirements, and actual LP tokens received for analyzing zap contract usage and slippage tolerance.

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
885483	true	817350	0xa6c0cbcaebd93ad3c6c94412ec06aaa37870216d	49317428471851568088398	0x8436f16a	0x64d65e3d70ba0f8812a9d1d7b8b5c51dab78cd15	13615451	0x66d56e8b63f9874a376b8d3cec656581d49dc9fe	1636913617574	49000000000	2021-11-14T18:05:15.000Z	49021770488162817937708	0x6e427def0a935998f740797ef5bb5b30d11fbdcb363013fd045da550d7888f35
835528	true	767395	0xa6c0cbcaebd93ad3c6c94412ec06aaa37870216d	20042346528191027162470	0x8436f16a	0x64d65e3d70ba0f8812a9d1d7b8b5c51dab78cd15	12799536	0x060253f772bb050ad5439e5c980356df02cf0725	1625919325048	20000000000	2021-07-10T12:05:36.000Z	20007225968967058884887	0x40178868fce5a9859bf60269e975acde1f749f7ed4002e255c2c1e6eb2aac175
814083	true	745950	0x2bab29a12a9527a179da88f422cdaaa223a90bd5	26233302204897733511067	0x8436f16a	0x64d65e3d70ba0f8812a9d1d7b8b5c51dab78cd15	15114359	0xdc4d38c70d1c038d500e5c59654392b78cdb460f	1657448963854	27000000000	2022-07-10T10:19:32.000Z	25944998213665907419780	0x66f1db0ea2d1d5e09d64cb4c88f6fd8b0931c3521b4203ba4157c538548792ae

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Curve_Trade_event

CurveFactory_NewCurve_event

Router_originSwap_function

StakingRewards_RewardPaid_event

Zap_zapFromBase_function

Zap_zapFromQuote_function

​Tables

​Curve_Trade_event

​CurveFactory_NewCurve_event

​Router_originSwap_function

​StakingRewards_RewardPaid_event

​Zap_zapFromBase_function

​Zap_zapFromQuote_function

Tables

Curve_Trade_event

CurveFactory_NewCurve_event

Router_originSwap_function

StakingRewards_RewardPaid_event

Zap_zapFromBase_function

Zap_zapFromQuote_function