> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# dfx_v1_ethereum
> Tables in tt-contracts.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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
| ------ | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | -------------- | ------------------------ | ---------------------- | ------------------------------------------------------------------ | ------------------------------------------ | ------------------- | --------------------- |
| 307424 | 0 | true | 245940 | 0x9d73b325 | 0xdb25f211ab05b1c97d595516f45794528a807ad8 | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 0x9d0950c595786aba7c26dfddf270d66a8b18b4fa | 14021946 | 0x758c30d1b462575f0bc1cd8fb0a0c8cec002a6df | 1642408640214 | | 2022-01-17T08:32:29.000Z | 184395 | 0x409abe6e78ad893082318dfe672c259443d66e7b9845ded0d45d8377c1611d7f | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 2123550137 | 2112932387 |
| 286944 | 0 | true | 229556 | 0x9d73b325 | 0xcadc0acd4b445166f12d2c07eac6e2544fbe2eef | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 0x9d0950c595786aba7c26dfddf270d66a8b18b4fa | 14023778 | 0xd90d5c7a6ebb19b45959cd622367e4be0985a05c | 1642432970347 | | 2022-01-17T15:12:58.000Z | 8586241053598997836221 | 0x9cb01e12e1d20c8e92ef6b3249af6f87088beabbbe0607f2a50d02ead6f47696 | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 6846897030 | 6812662545 |
| 288632 | 0 | true | 230906 | 0x9d73b325 | 0x70e8de73ce538da2beed35d14187f6959a8eca96 | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 0x9d0950c595786aba7c26dfddf270d66a8b18b4fa | 14023757 | 0x66d56e8b63f9874a376b8d3cec656581d49dc9fe | 1642432661280 | | 2022-01-17T15:07:53.000Z | 7375916644 | 0xb0b325dcb0e1702556e0954b8d30ddbd3d94302cbbe84535556a3d4cbba71cb5 | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 5469397095 | 5442050110 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
| ------ | ----- | ------ | --------- | ------------------------------------------ | ----------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ----------------------- | -------------- | ------------------------ | ----------------------- | ------------------------------------------------------------------ |
| 850016 | 0 | true | 781415 | 0xe9669516e09f5710023566458f329cce6437aaac | 20989349085710820217200 | 0x72fe6789 | 0x64d65e3d70ba0f8812a9d1d7b8b5c51dab78cd15 | 13489620 | 0x0f13b090efcceeb2ffb6711a5326546e25142709 | 1635206091868 | 29588000000 | | 2021-10-25T23:49:05.000Z | 20863517937941983849998 | 0xb6368eb1bd47406d8bae9b39272eec3232ddd401ce44acc114cdac8321f09562 |
| 699052 | 0 | true | 630952 | 0xa6c0cbcaebd93ad3c6c94412ec06aaa37870216d | 40961592511549902464417 | 0x72fe6789 | 0x64d65e3d70ba0f8812a9d1d7b8b5c51dab78cd15 | 12614931 | 0x99c4fe0d7b8aeb5c5234914be2411648d89e4ba7 | 1623437637942 | 49975000000000000000000 | | 2021-06-11T18:45:02.000Z | 40920630919038352561952 | 0x29ea6cb4b592e13863fd7e79d12ef87a80bba86cda4fd7db9205479930e312a9 |
| 745568 | 0 | true | 677468 | 0xa6c0cbcaebd93ad3c6c94412ec06aaa37870216d | 43625083998752708949441 | 0x72fe6789 | 0x64d65e3d70ba0f8812a9d1d7b8b5c51dab78cd15 | 12613382 | 0x25dc74048fdda2b3b321320293e48d0d3dff1c1d | 1623416811662 | 53673388495416283420093 | | 2021-06-11T12:59:11.000Z | 43581458914753956240491 | 0xafcf029c103176166ff46fd589d91d762ecda722f09488455263e75b6aa5c36f |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
| ------ | ----- | ------ | --------- | ------------------------------------------ | ----------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | --------------- | -------------- | ------------------------ | ----------------------- | ------------------------------------------------------------------ |
| 885483 | 0 | true | 817350 | 0xa6c0cbcaebd93ad3c6c94412ec06aaa37870216d | 49317428471851568088398 | 0x8436f16a | 0x64d65e3d70ba0f8812a9d1d7b8b5c51dab78cd15 | 13615451 | 0x66d56e8b63f9874a376b8d3cec656581d49dc9fe | 1636913617574 | 49000000000 | | 2021-11-14T18:05:15.000Z | 49021770488162817937708 | 0x6e427def0a935998f740797ef5bb5b30d11fbdcb363013fd045da550d7888f35 |
| 835528 | 0 | true | 767395 | 0xa6c0cbcaebd93ad3c6c94412ec06aaa37870216d | 20042346528191027162470 | 0x8436f16a | 0x64d65e3d70ba0f8812a9d1d7b8b5c51dab78cd15 | 12799536 | 0x060253f772bb050ad5439e5c980356df02cf0725 | 1625919325048 | 20000000000 | | 2021-07-10T12:05:36.000Z | 20007225968967058884887 | 0x40178868fce5a9859bf60269e975acde1f749f7ed4002e255c2c1e6eb2aac175 |
| 814083 | 0 | true | 745950 | 0x2bab29a12a9527a179da88f422cdaaa223a90bd5 | 26233302204897733511067 | 0x8436f16a | 0x64d65e3d70ba0f8812a9d1d7b8b5c51dab78cd15 | 15114359 | 0xdc4d38c70d1c038d500e5c59654392b78cdb460f | 1657448963854 | 27000000000 | | 2022-07-10T10:19:32.000Z | 25944998213665907419780 | 0x66f1db0ea2d1d5e09d64cb4c88f6fd8b0931c3521b4203ba4157c538548792ae |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.dfx_v1_ethereum.Zap_zapFromQuote_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***