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.

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

Sample Data

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

Example Query

Query with partition filter

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.

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

Sample Data

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

Example Query

Query with partition filter

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.

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

Sample Data

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

Example Query

Query with partition filter

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.

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

Sample Data

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

Example Query

Query with partition filter

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.

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

Sample Data

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

Example Query

Query with partition filter

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.

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

Sample Data

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

Example Query

Query with partition filter

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.

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__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.

Sample Data

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

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AugustusSwapper_BoughtV3_event

AugustusSwapper_SwappedV3_event

AugustusSwapper2_Bought2_event

AugustusSwapper2_Swapped2_event

AugustusSwapperIParaswap_Bought_event

AugustusSwapperIParaswap_Swapped_event

MerkleRedeem_Claimed_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AugustusSwapper_BoughtV3_event

​AugustusSwapper_SwappedV3_event

​AugustusSwapper2_Bought2_event

​AugustusSwapper2_Swapped2_event

​AugustusSwapperIParaswap_Bought_event

​AugustusSwapperIParaswap_Swapped_event

​MerkleRedeem_Claimed_event

Tables

AugustusSwapper_BoughtV3_event

AugustusSwapper_SwappedV3_event

AugustusSwapper2_Bought2_event

AugustusSwapper2_Swapped2_event

AugustusSwapperIParaswap_Bought_event

AugustusSwapperIParaswap_Swapped_event

MerkleRedeem_Claimed_event