> ## 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.
# paraswap_v5_fantom
> Tables in tt-contracts.paraswap_v5_fantom
## Tables
### AugustusSwapper\_BoughtV3\_event
BoughtV3 event emitted by Paraswap AugustusSwapper contract when a token swap completes successfully. Records source and destination token addresses, amounts swapped, partner/referral information, and fee parameters for DEX aggregation analytics.
| 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_uuid` | `STRING` | Unique identifier for the swap operation. 32-character hex string without 0x prefix. |
| `in_partner` | `STRING` | Address of the partner or referral entity associated with the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_feePercent` | `STRING` | Fee percentage charged for the swap transaction. String-encoded 256-bit integer used in Paraswap protocol fee calculations. |
| `in_initiator` | `STRING` | Address of the account that initiated the flash loan operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_beneficiary` | `STRING` | Address that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_srcToken` | `STRING` | Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_destToken` | `STRING` | Contract address of the destination token received in the swap. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_srcAmount` | `STRING` | Amount of source tokens sent by the initiator in the swap operation. String-encoded integer representing token units in the source token's smallest denomination. |
| `in_receivedAmount` | `STRING` | Actual amount of destination tokens received by the beneficiary in the swap or withdrawal operation. String-encoded integer representing token units in the destination token's smallest denomination. |
| `in_expectedAmount` | `STRING` | Expected amount of destination tokens for the swap operation. String-encoded integer representing token units in the destination token's smallest denomination. |
| address | in\_uuid | removed | log\_index | in\_partner | in\_srcToken | block\_number | in\_destToken | in\_initiator | in\_srcAmount | in\_feePercent | in\_beneficiary | block\_timestamp | transaction\_hash | in\_expectedAmount | in\_receivedAmount |
| ------------------------------------------ | ---------------------------------- | ------- | ---------- | ------------------------------------------ | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------------------------ | ------------- | --------------------------------------------------------------------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------ | --------------------- |
| 0xdef171fe48cf0115b1d80b88dc8eab59176fee57 | 0x009330a773b74beab7312913e121c1d1 | false | 21 | 0x0000000000000000000000000000000061617665 | 0x04068da6c83afcfa0e13ba15a6696662335d5b75 | 43409812 | 0x8d11ec38a3eb5e956b052f67da8bdc9bef8abf3e | 0x1408401b2a7e28cb747b3e258d0831fc926bac51 | 1079655 | 452312848583266388373324160190187140051835877600158453279131187530910711808 | 0x1408401b2a7e28cb747b3e258d0831fc926bac51 | 2022-07-23T23:58:27.000Z | 0xefe710edb029a5a32e5db6e03da077d4ab3d00d5bae947f8abb05e080056fe08 | 1082356 | 1078082628147584516 |
| 0xdef171fe48cf0115b1d80b88dc8eab59176fee57 | 0x95e958ba4fb3420895112d2950cd720c | false | 40 | 0x0000000000000000000000000000000061617665 | 0x04068da6c83afcfa0e13ba15a6696662335d5b75 | 43393841 | 0xae75a438b2e0cb8bb01ec1e1e376de11d44477cc | 0x1408401b2a7e28cb747b3e258d0831fc926bac51 | 393475649 | 452312848583266388373324160190187140051835877600158453279131187530910711808 | 0x1408401b2a7e28cb747b3e258d0831fc926bac51 | 2022-07-23T18:27:46.000Z | 0xe75f721b419eff0484fe5f017f4211e0ce67ac3437bbc39952e21fe61273439e | 393691220 | 300000000000000000000 |
| 0xdef171fe48cf0115b1d80b88dc8eab59176fee57 | 0x51e553054766434782d6848be2e780e1 | false | 60 | 0x0000000000000000000000000000000061617665 | 0x04068da6c83afcfa0e13ba15a6696662335d5b75 | 43408969 | 0x8d11ec38a3eb5e956b052f67da8bdc9bef8abf3e | 0x1408401b2a7e28cb747b3e258d0831fc926bac51 | 4003627 | 452312848583266388373324160190187140051835877600158453279131187530910711808 | 0x1408401b2a7e28cb747b3e258d0831fc926bac51 | 2022-07-23T23:42:27.000Z | 0xb27bd9d7bdb59a54b877320244cdb8cddfa5a0081f772e9f754b4a8d2ff9b986 | 4003627 | 4000000000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.paraswap_v5_fantom.AugustusSwapper_BoughtV3_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### AugustusSwapper\_SwappedV3\_event
Token swap completion events emitted by ParaSwap V5's AugustusSwapper contract containing source/destination token addresses, amounts exchanged, initiator, beneficiary, partner referral, expected versus received amounts, and fee percentage. Used for tracking DEX aggregator swap execution and slippage analysis across multiple blockchain networks.
| 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_uuid` | `STRING` | Unique identifier for the swap operation. 32-character hex string without 0x prefix. |
| `in_partner` | `STRING` | Address of the partner or referral entity associated with the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_feePercent` | `STRING` | Fee percentage charged for the swap transaction. String-encoded 256-bit integer used in Paraswap protocol fee calculations. |
| `in_initiator` | `STRING` | Address of the account that initiated the flash loan operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_beneficiary` | `STRING` | Address that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_srcToken` | `STRING` | Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_destToken` | `STRING` | Contract address of the destination token received in the swap. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_srcAmount` | `STRING` | Amount of source tokens sent by the initiator in the swap operation. String-encoded integer representing token units in the source token's smallest denomination. |
| `in_receivedAmount` | `STRING` | Actual amount of destination tokens received by the beneficiary in the swap or withdrawal operation. String-encoded integer representing token units in the destination token's smallest denomination. |
| `in_expectedAmount` | `STRING` | Expected amount of destination tokens for the swap operation. String-encoded integer representing token units in the destination token's smallest denomination. |
| address | in\_uuid | removed | log\_index | in\_partner | in\_srcToken | block\_number | in\_destToken | in\_initiator | in\_srcAmount | in\_feePercent | in\_beneficiary | block\_timestamp | transaction\_hash | in\_expectedAmount | in\_receivedAmount |
| ------------------------------------------ | ---------------------------------- | ------- | ---------- | ------------------------------------------ | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------------------------ | ---------------------- | --------------------------------------------------------------------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------ | ------------------ |
| 0xdef171fe48cf0115b1d80b88dc8eab59176fee57 | 0xdf9b59ae32e44df5947a365f2c137c31 | false | 116 | 0x8c208b7b5625d78deb49240ef28126cbe2738098 | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 51188351 | 0x04068da6c83afcfa0e13ba15a6696662335d5b75 | 0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae | 2819200000000000000000 | 452312848583266388373324160190187140051835877600158453279131187530910679040 | 0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae | 2022-11-20T14:20:54.000Z | 0x22f25687283e9ca48ae0c688389239a78713ea8f5026f784c2d7c031b330a874 | 506832413 | 506348396 |
| 0xdef171fe48cf0115b1d80b88dc8eab59176fee57 | 0x9f4121152b8f46abafd0808450063a2c | false | 11 | 0x8c208b7b5625d78deb49240ef28126cbe2738098 | 0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590 | 51202338 | 0x04068da6c83afcfa0e13ba15a6696662335d5b75 | 0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae | 78397560420465064451 | 452312848583266388373324160190187140051835877600158453279131187530910679040 | 0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae | 2022-11-20T20:20:56.000Z | 0xecc99d2ea565b00937556e5f08f5844b3297b5cca36d3383eedf3af63cdcfc79 | 32301676 | 32301676 |
| 0xdef171fe48cf0115b1d80b88dc8eab59176fee57 | 0xe7265a69af434538ac3828325af6f8a9 | false | 20 | 0x8c208b7b5625d78deb49240ef28126cbe2738098 | 0x8d11ec38a3eb5e956b052f67da8bdc9bef8abf3e | 51197955 | 0x04068da6c83afcfa0e13ba15a6696662335d5b75 | 0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae | 53000000000000000000 | 452312848583266388373324160190187140051835877600158453279131187530910679040 | 0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae | 2022-11-20T18:38:17.000Z | 0xdb25f279446acc08bbcb02090cc963b6b699eea79be8a7b5b19104c8112f9e1c | 52985572 | 52985572 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.paraswap_v5_fantom.AugustusSwapper_SwappedV3_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### AugustusSwapper2\_Bought2\_event
Paraswap AugustusSwapper V2 token swap completion events emitted when a buy order executes. Contains source and destination token addresses, swap amounts, initiator and beneficiary addresses, partner referral information, and protocol fee percentages for DEX aggregation analytics.
| 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_uuid` | `STRING` | Unique identifier for the swap operation. 32-character hex string without 0x prefix. |
| `in_partner` | `STRING` | Address of the partner or referral entity associated with the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_feePercent` | `STRING` | Fee percentage charged for the swap transaction. String-encoded 256-bit integer used in Paraswap protocol fee calculations. |
| `in_initiator` | `STRING` | Address of the account that initiated the flash loan operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_beneficiary` | `STRING` | Address that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_srcToken` | `STRING` | Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_destToken` | `STRING` | Contract address of the destination token received in the swap. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_srcAmount` | `STRING` | Amount of source tokens sent by the initiator in the swap operation. String-encoded integer representing token units in the source token's smallest denomination. |
| `in_receivedAmount` | `STRING` | Actual amount of destination tokens received by the beneficiary in the swap or withdrawal operation. String-encoded integer representing token units in the destination token's smallest denomination. |
| address | in\_uuid | removed | log\_index | in\_partner | in\_srcToken | block\_number | in\_destToken | in\_initiator | in\_srcAmount | in\_feePercent | in\_beneficiary | block\_timestamp | transaction\_hash | in\_receivedAmount |
| ------------------------------------------ | ---------------------------------- | ------- | ---------- | ------------------------------------------ | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------------------------ | ----------------- | --------------------------------------------------------------------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------- |
| 0xdef171fe48cf0115b1d80b88dc8eab59176fee57 | 0xfe23a200c1cc11eca88a4d199eb1072a | false | 153 | 0x0000000000000000000000000000000061617665 | 0x04068da6c83afcfa0e13ba15a6696662335d5b75 | 36656131 | 0x049d68029688eabf473097a2fc38ef61633a3c7a | 0x85272bf6ddccbdea45cf0535ea5c65bf91b480c4 | 60309917 | 452312848583266388373324160190187140051835877600158453279131187530910679040 | 0x85272bf6ddccbdea45cf0535ea5c65bf91b480c4 | 2022-04-21T23:44:42.000Z | 0x819c6e2f3195a9a59407b4137238f4425a8cbfe4887984d3bb180f2cbe3b14c9 | 60045928 |
| 0xdef171fe48cf0115b1d80b88dc8eab59176fee57 | 0xb20457d0c17b11ecaf25d3301cf4f06c | false | 61 | 0x0000000000000000000000000000000061617665 | 0x74b23882a30290451a17c44f4f05243b6b58c76d | 36624954 | 0x04068da6c83afcfa0e13ba15a6696662335d5b75 | 0x85272bf6ddccbdea45cf0535ea5c65bf91b480c4 | 90839300396261537 | 452312848583266388373324160190187140051835877600158453279131187530910679040 | 0x85272bf6ddccbdea45cf0535ea5c65bf91b480c4 | 2022-04-21T14:03:46.000Z | 0x60d507341fe9477f15cb0c440ab3f6760f5c56b09bba8787c0a368f0ed1650cd | 286251735 |
| 0xdef171fe48cf0115b1d80b88dc8eab59176fee57 | 0xdf4cb6e0c1b911ec8d2b69a8b595f6f5 | false | 12 | 0x00000000000000000070617261737761702e696f | 0x04068da6c83afcfa0e13ba15a6696662335d5b75 | 36648345 | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 0x04261f3a4f4e244b80ed7e3d8b7ff28abd6c4dc9 | 10747600 | 452312848583266388373324160190187140051835877600158453279131187530910679040 | 0x04261f3a4f4e244b80ed7e3d8b7ff28abd6c4dc9 | 2022-04-21T21:27:56.000Z | 0xa15ff8d43b40a8f76e3390ec697451acd207adfc6484f9d98b47ad17dfe43dab | 9500000000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.paraswap_v5_fantom.AugustusSwapper2_Bought2_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### AugustusSwapper2\_Swapped2\_event
Token swap execution events emitted by ParaSwap's AugustusSwapper2 contract containing source and destination token addresses, amounts exchanged, initiator and beneficiary addresses, fee percentages, and unique swap identifiers. Records completed swaps through the ParaSwap DEX aggregator protocol for multi-chain token exchange analytics.
| 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_uuid` | `STRING` | Unique identifier for the swap operation. 32-character hex string without 0x prefix. |
| `in_partner` | `STRING` | Address of the partner or referral entity associated with the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_feePercent` | `STRING` | Fee percentage charged for the swap transaction. String-encoded 256-bit integer used in Paraswap protocol fee calculations. |
| `in_initiator` | `STRING` | Address of the account that initiated the flash loan operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_beneficiary` | `STRING` | Address that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_srcToken` | `STRING` | Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_destToken` | `STRING` | Contract address of the destination token received in the swap. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_srcAmount` | `STRING` | Amount of source tokens sent by the initiator in the swap operation. String-encoded integer representing token units in the source token's smallest denomination. |
| `in_receivedAmount` | `STRING` | Actual amount of destination tokens received by the beneficiary in the swap or withdrawal operation. String-encoded integer representing token units in the destination token's smallest denomination. |
| `in_expectedAmount` | `STRING` | Expected amount of destination tokens for the swap operation. String-encoded integer representing token units in the destination token's smallest denomination. |
| address | in\_uuid | removed | log\_index | in\_partner | in\_srcToken | block\_number | in\_destToken | in\_initiator | in\_srcAmount | in\_feePercent | in\_beneficiary | block\_timestamp | transaction\_hash | in\_expectedAmount | in\_receivedAmount |
| ------------------------------------------ | ---------------------------------- | ------- | ---------- | ------------------------------------------ | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------------------------ | ---------------------- | --------------------------------------------------------------------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------ | ------------------ |
| 0xdef171fe48cf0115b1d80b88dc8eab59176fee57 | 0x0233c4c0d9c311eca5706d519b33ddeb | false | 72 | 0x00000000000000000070617261737761702e696f | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 38802283 | 0x04068da6c83afcfa0e13ba15a6696662335d5b75 | 0x0c42d47037720a09802aca6b1b33e4d281cb2059 | 359023568713957266373 | 452312848583266388373324160190187140051835877600158453279131187530910679040 | 0x0c42d47037720a09802aca6b1b33e4d281cb2059 | 2022-05-22T11:33:46.000Z | 0xb2a015c1471ddd9571b1ff6969fdcaa70954170383c5e6cc9a79b9406889b4a2 | 151305819 | 150831093 |
| 0xdef171fe48cf0115b1d80b88dc8eab59176fee57 | 0xe05255f0d9f511ec8093c7695932d7ca | false | 22 | 0x00000000000000000070617261737761702e696f | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 38820810 | 0x04068da6c83afcfa0e13ba15a6696662335d5b75 | 0x0c42d47037720a09802aca6b1b33e4d281cb2059 | 359089891881543867353 | 452312848583266388373324160190187140051835877600158453279131187530910679040 | 0x0c42d47037720a09802aca6b1b33e4d281cb2059 | 2022-05-22T17:37:44.000Z | 0x19084d46f126103cfec3b6eddb6b4d15fe29a210d50c0cd903d2e49fd3b7bb11 | 150226570 | 150224845 |
| 0xdef171fe48cf0115b1d80b88dc8eab59176fee57 | 0x2c570090d9b511ec81a7d358e6f42ec9 | false | 16 | 0x00000000000000000070617261737761702e696f | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 38797568 | 0x04068da6c83afcfa0e13ba15a6696662335d5b75 | 0x0cb47935613b46e03ae1cda174dbfb5f6b358781 | 2343663645505451425415 | 452312848583266388373324160190187140051835877600158453279131187530910679040 | 0x0cb47935613b46e03ae1cda174dbfb5f6b358781 | 2022-05-22T09:54:35.000Z | 0x1510e6a3affdcb5cbf1bf25d7144b93769a7d484e138d20996d6b1961afffb41 | 1034239185 | 1031032245 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.paraswap_v5_fantom.AugustusSwapper2_Swapped2_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### AugustusSwapperIParaswap\_Bought\_event
Token swap execution events from Paraswap V5's Augustus contract recording successful buy-side trades. Contains initiator address, source and destination token addresses, amounts exchanged, beneficiary, and unique swap identifier for tracking DEX aggregator transactions.
| 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_uuid` | `STRING` | Unique identifier for the swap operation. 32-character hex string without 0x prefix. |
| `in_initiator` | `STRING` | Address of the account that initiated the flash loan operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_beneficiary` | `STRING` | Address that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_srcToken` | `STRING` | Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_destToken` | `STRING` | Contract address of the destination token received in the swap. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_srcAmount` | `STRING` | Amount of source tokens sent by the initiator in the swap operation. String-encoded integer representing token units in the source token's smallest denomination. |
| `in_receivedAmount` | `STRING` | Actual amount of destination tokens received by the beneficiary in the swap or withdrawal operation. String-encoded integer representing token units in the destination token's smallest denomination. |
| address | in\_uuid | removed | log\_index | in\_srcToken | block\_number | in\_destToken | in\_initiator | in\_srcAmount | in\_beneficiary | block\_timestamp | transaction\_hash | in\_receivedAmount |
| ------------------------------------------ | ---------------------------------- | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ----------------------- |
| 0xdef171fe48cf0115b1d80b88dc8eab59176fee57 | 0x156727708d9811ecadb4f14afd082185 | false | 70 | 0x04068da6c83afcfa0e13ba15a6696662335d5b75 | 30945120 | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 0x3e0aa189d6f802e77cacdb8fd14df75c3db9dca1 | 195482260 | 0x3e0aa189d6f802e77cacdb8fd14df75c3db9dca1 | 2022-02-14T13:15:29.000Z | 0x9225aa9db682cb3dc3df6d250e5bec2a97bf8d8731ec97f700bf89bbd174c565 | 100000000000000000003 |
| 0xdef171fe48cf0115b1d80b88dc8eab59176fee57 | 0x18ed55408dca11ec886fe71b833d3fee | false | 93 | 0x04068da6c83afcfa0e13ba15a6696662335d5b75 | 30969794 | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 0x42721727e57416613d4db08c534d8b517aa299aa | 1907213 | 0x42721727e57416613d4db08c534d8b517aa299aa | 2022-02-14T19:13:06.000Z | 0xe14a6b5f7e670ce72f47d797e8e8e34f0f5bc102848bddd27ba4a74d29b40110 | 1000000000000000000 |
| 0xdef171fe48cf0115b1d80b88dc8eab59176fee57 | 0xa04029c08d3711ecba0d8902f1505010 | false | 33 | 0x04068da6c83afcfa0e13ba15a6696662335d5b75 | 30897350 | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 0x544bc429c762ac9ea3383975cd5b6f6bd0e5e2dd | 23876293514 | 0x544bc429c762ac9ea3383975cd5b6f6bd0e5e2dd | 2022-02-14T01:45:40.000Z | 0x907a1b60db45b28e2b99178784db5a83be523b233e1c20be3e494734ee0ea845 | 12910000000000000000005 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.paraswap_v5_fantom.AugustusSwapperIParaswap_Bought_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### AugustusSwapperIParaswap\_Swapped\_event
Swap execution events emitted by the ParaSwap AugustusSwapper contract. Records source and destination token addresses, amounts sent and received, initiator, beneficiary, and unique swap identifier for DEX aggregator transaction tracking.
| 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_uuid` | `STRING` | Unique identifier for the swap operation. 32-character hex string without 0x prefix. |
| `in_initiator` | `STRING` | Address of the account that initiated the flash loan operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_beneficiary` | `STRING` | Address that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_srcToken` | `STRING` | Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_destToken` | `STRING` | Contract address of the destination token received in the swap. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_srcAmount` | `STRING` | Amount of source tokens sent by the initiator in the swap operation. String-encoded integer representing token units in the source token's smallest denomination. |
| `in_receivedAmount` | `STRING` | Actual amount of destination tokens received by the beneficiary in the swap or withdrawal operation. String-encoded integer representing token units in the destination token's smallest denomination. |
| `in_expectedAmount` | `STRING` | Expected amount of destination tokens for the swap operation. String-encoded integer representing token units in the destination token's smallest denomination. |
| address | in\_uuid | removed | log\_index | in\_srcToken | block\_number | in\_destToken | in\_initiator | in\_srcAmount | in\_beneficiary | block\_timestamp | transaction\_hash | in\_expectedAmount | in\_receivedAmount |
| ------------------------------------------ | ---------------------------------- | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------------------------ | ---------------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------ | ------------------ |
| 0xdef171fe48cf0115b1d80b88dc8eab59176fee57 | 0xb713f0a0833711ec95334d4f20246dd7 | false | 27 | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 29664269 | 0x04068da6c83afcfa0e13ba15a6696662335d5b75 | 0x0207b4732e347a9214e0c1cc4f3c86e4b416126e | 8000000000000000000 | 0x0207b4732e347a9214e0c1cc4f3c86e4b416126e | 2022-02-01T08:19:55.000Z | 0xbae1c3d25337c700a07f6597443acc45662af360dfe312155ac0a2fd9e8103eb | 16869817 | 16869818 |
| 0xdef171fe48cf0115b1d80b88dc8eab59176fee57 | 0x470b5280834111ec9adeb31feb320c04 | false | 101 | 0x8d11ec38a3eb5e956b052f67da8bdc9bef8abf3e | 29668696 | 0x04068da6c83afcfa0e13ba15a6696662335d5b75 | 0x09a5c464e7d8144a8d071938429736d2f1ce5cc9 | 3584390615797416191782 | 0x09a5c464e7d8144a8d071938429736d2f1ce5cc9 | 2022-02-01T09:28:21.000Z | 0x93cf90433e1f8e170b223663a5cae2c5e0c8d9dfd6fad2b89589bfe79494dcdc | 3583203564 | 3581116629 |
| 0xdef171fe48cf0115b1d80b88dc8eab59176fee57 | 0x18a39a20839a11ecbc268dd3a65bf7e5 | false | 19 | 0xfb98b335551a418cd0737375a2ea0ded62ea213b | 29712692 | 0x04068da6c83afcfa0e13ba15a6696662335d5b75 | 0x0fd62cf3270a64eeca0ee9918a618366d57e4e38 | 531145978384311052789 | 0x0fd62cf3270a64eeca0ee9918a618366d57e4e38 | 2022-02-01T20:04:08.000Z | 0xff869e01031f3ad4325a7a23029f108137e09dde8ec520525cb9a05ae9029aa2 | 530380621 | 530380624 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.paraswap_v5_fantom.AugustusSwapperIParaswap_Swapped_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### MerkleRedeem\_Claimed\_event
Token claim events from Merkle tree-based distribution contracts recording successful redemptions. Contains claimant address and claimed token balance for tracking airdrop and reward distribution execution.
| 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__claimant` | `STRING` | Address of the account claiming the tokens or rewards. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__balance` | `STRING` | Token amount represented in smallest denomination. String-encoded integer value without decimal places. |
| address | removed | log\_index | in\_\_balance | block\_number | in\_\_claimant | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ---------------------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0xca82162e3666dbdf97814197ae82731d857125de | false | 60 | 8252572333668190279619 | 39165519 | 0xc02427f0b937f9905c47ddcc661374e0a49c8f03 | 2022-05-27T09:58:23.000Z | 0x0ec03b8001c7d2103ca17abcc26d22e4655ae9e3dd2ee2d1ec65c7dfc58ac301 |
| 0xca82162e3666dbdf97814197ae82731d857125de | false | 30 | 29411909611716498025 | 68140307 | 0xbed58fa67bd966a40460b42f065dcccb0fd4fe4f | 2023-09-13T09:50:59.000Z | 0x6d4a1ce4beeec1eb5c8905d985b68bd706243b609773c1da9d0649540e549c60 |
| 0xca82162e3666dbdf97814197ae82731d857125de | false | 48 | 160222480153485189 | 53092540 | 0xbd5f593c86319523e6e8afe60dedbefaedbdb8c9 | 2023-01-02T07:18:00.000Z | 0x2a07ef9677860438733ba9ab4d927a6e0d071de42bb8f79d5c437c576ebd228d |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.paraswap_v5_fantom.MerkleRedeem_Claimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***