paraswap_v5_polygon

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	0x9730931938254f38be1b991a5e2006ca	false	67	0x000000000000000000717569636b737761707633	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	34434239	0x70c006878a5a50ed185ac4c87d837633923de296	0x006ede7c25fb642ee797ab3e95b16aab39b8c67d	115721707585670720	452312848583266388373324160190187140051835877600158453279131187530910711808	0x006ede7c25fb642ee797ab3e95b16aab39b8c67d	2022-10-16T23:14:18.000Z	0x9e91b5a8c863a7f856aa916219d2e3dbbe90e8405b641dd9a462b431658b3c48	115721707585670720	6000000000000000000
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x49372fb85cc841bbb27da0d169916877	false	140	0x000000000000000000717569636b737761707633	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	34404788	0x70c006878a5a50ed185ac4c87d837633923de296	0x006ede7c25fb642ee797ab3e95b16aab39b8c67d	98095138621595100	452312848583266388373324160190187140051835877600158453279131187530910711808	0x006ede7c25fb642ee797ab3e95b16aab39b8c67d	2022-10-16T05:49:59.000Z	0x9cf41bf3f1f4a86708d6e3221a597fc35700c4631a9cf1db3906a69bc412a98d	98095138621595100	5000000000000000000
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x062fbeb4443c4757a988df770305f53d	false	35	0x000000000000000000717569636b737761707633	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	34403192	0x8d65d531cec2bd07b468b0dc68a89daa8fcfffa7	0x018299752a78e7a15a788a26eedf75039cd0bbd5	2075623884977551550	452312848583266388373324160190187140051835877600158453279131187530910711808	0x018299752a78e7a15a788a26eedf75039cd0bbd5	2022-10-16T04:55:01.000Z	0x0896de56a42fe5329829e726cee980cceb19f1fcd250270d40121ec8b59ef18e	2075623884977551550	10000000000000000000

Example Query

Query with partition filter

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

AugustusSwapper_SwappedDirect_event

Direct token swap events from Paraswap V5 AugustusSwapper contract containing source and destination token details, amounts exchanged, swap initiator, beneficiary, partner referral addresses, and fee percentages. Used for tracking DEX aggregator swap execution and slippage analysis.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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_kind`	`INT64`	Swap operation type indicator for Balancer V2/V3 batch swaps and liquidity operations. Integer value where 0 represents GIVEN_IN (exact input amount specified) and 1 represents GIVEN_OUT (exact output amount specified).
`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	0x67df0673e2d54a019aadb3058cd343c1	false	655	0x0000000000000000000000000000000000000000	0x03b54a6e9a984069379fae1a4fc4dbae93b3bccd	66066795	0xc91953e110ebb0039859304a0d1b64f8450763fc	0x3c233914c607069f2003e975c886f61509c2189b	555462401887627855	452312848583266388373324160190187140051835877600158453279131187530910679040	0x3c233914c607069f2003e975c886f61509c2189b	2024-12-29T14:40:28.000Z	0x4b85faeafdd3155d16eb2148f6bb957aa02754122927b77e10719c6f7bbe55d5	158647295940361045	158647295940361045
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x70d00765494a47e2a7a4e716d904b595	false	406	0x0000000000000000000000000000000000000000	0x03b54a6e9a984069379fae1a4fc4dbae93b3bccd	66076080	0xc91953e110ebb0039859304a0d1b64f8450763fc	0x3c233914c607069f2003e975c886f61509c2189b	466964008474980374	452312848583266388373324160190187140051835877600158453279131187530910679040	0x3c233914c607069f2003e975c886f61509c2189b	2024-12-29T20:26:32.000Z	0xdf1ba50d64863fde0ad117971f29754821a4d880e6a28065a76c37c43e9fefba	132290107963990150	132290107963990150
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0xea81eadb85bc407f994d4ecd82d59ca5	false	1026	0x0000000000000000000000000000000000000000	0x03b54a6e9a984069379fae1a4fc4dbae93b3bccd	66079025	0xc91953e110ebb0039859304a0d1b64f8450763fc	0x3c233914c607069f2003e975c886f61509c2189b	324734942598060239	452312848583266388373324160190187140051835877600158453279131187530910679040	0x3c233914c607069f2003e975c886f61509c2189b	2024-12-29T22:21:32.000Z	0xc70ab97dbe7fb9f3de72eceea328bc4ee1f7c6fa334a54a989e19020be1aeeee	91881942966769528	91881942966769528

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_polygon.AugustusSwapper_SwappedDirect_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	0x0699b1391f204afca7ec3768ec524096	false	322	0x0000000000000000000000000000000000000000	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	49165212	0x001b1ac29d937fc9dfd4b71327202a17034707ca	0x39e3e49c99834c9573c9fc7ff5a4b226cd7b0e63	5000000000000000000	452312848583266388373324160190187140051835877600158453279131187530910679040	0x39e3e49c99834c9573c9fc7ff5a4b226cd7b0e63	2023-10-26T07:01:01.000Z	0x7629fbd247900334df6f805de6daf60f40a33ffb40de1529a423c3a8e560ea45	95233834421090141904	95233834421090141906
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x7e6b167656844b19adb8d1e10dd6ad90	false	227	0x0000000000000000000000000000000000000000	0xc2132d05d31c914a87c6611c10748aeb04b58e8f	49191494	0x001b1ac29d937fc9dfd4b71327202a17034707ca	0xc590175e458b83680867afd273527ff58f74c02b	4956250	452312848583266388373324160190187140051835877600158453279131187530910679040	0xc590175e458b83680867afd273527ff58f74c02b	2023-10-26T22:40:40.000Z	0x4ed42b90a7713df0d0bfda98197023211c4f0472d08e1941ecedd36087a1353a	109841875113129948461	109841875113129948461
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x94f77ae1f779454383965e9970eeec5f	false	95	0x0000000000000000000000000000000000000000	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	49192970	0x01d35cbc2070a3b76693ce2b6364eae24eb88591	0xeb28914513e20d74694149dd36a178b421cce494	15000000000000000000	452312848583266388373324160190187140051835877600158453279131187530910679040	0xeb28914513e20d74694149dd36a178b421cce494	2023-10-26T23:34:19.000Z	0x34f00ec28c1359ba5fe601edb8accae8c5f72bb5d3b16102b2d7d408813ac32b	90758413559334213830149	90758413559334213830149

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_polygon.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	0xf69b6e70ad1611ec8bb18bbebb74d3b0	false	688	0x00000000000000000070617261737761702e696f	0xc2132d05d31c914a87c6611c10748aeb04b58e8f	26387136	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x48943bfbc11129299d3eb5fa54035d1ab9df75b3	28853783	452312848583266388373324160190187140051835877600158453279131187530910679040	0x48943bfbc11129299d3eb5fa54035d1ab9df75b3	2022-03-26T15:11:21.000Z	0xd8830f3ef84e337c527eb79fae30014f2d40bcc3f746c763c9ecb6ba1dd645d1	18000000000000000000
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x5c291270ad2a11ecb847bd76486c32ff	false	201	0x00000000000000000070617261737761702e696f	0x4e3decbb3645551b8a19f0ea1678079fcb33fb4c	26391112	0x1bfd67037b42cf73acf2047067bd4f2c47d9bfd6	0x8c14204ed32306b6bba72b39c93b132e5192cafc	81729199065996362793	452312848583266388373324160190187140051835877600158453279131187530910679040	0x8c14204ed32306b6bba72b39c93b132e5192cafc	2022-03-26T17:30:09.000Z	0xdbcbbead6d3552703f13f1b376f9feedd0e8d03d066481974d4c2470f729f827	198994
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x59d66620acf911ecb70073ffee58541d	false	415	0x00000000000000000070617261737761702e696f	0x23d29d30e35c5e8d321e1dc9a8a61bfd846d4c5c	26381322	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0xaf568b4acab91a8119994c69b86648271346796d	1087351787618	452312848583266388373324160190187140051835877600158453279131187530910679040	0xaf568b4acab91a8119994c69b86648271346796d	2022-03-26T11:39:26.000Z	0x95846a4758c308b9e82a82b3fc6860f196f10e3aa7e36f7ba351f4dd4cc3c9c8	1500000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_polygon.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	0xdd22dd30c64711ec91415de905357dd1	false	210	0x00000000000000000000006d6574616d61736b32	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	27643708	0x03f61137bfb86be07394f0fd07a33984020f96d8	0xc590175e458b83680867afd273527ff58f74c02b	4956250000000000000	452312848583266388373324160190187140051835877600158453279131187530910679040	0xc590175e458b83680867afd273527ff58f74c02b	2022-04-27T16:34:26.000Z	0xe7be69f5482dba27df85a126352ae84066f4c44d83dcdb67ed7fb2f38ae76631	487119854341550926129	483411731801692779163
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0xa796a1f0c66b11ec8769752604aef6e2	false	543	0x00000000000000000000006d6574616d61736b32	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	27650979	0x04b33078ea1aef29bf3fb29c6ab7b200c58ea126	0xc590175e458b83680867afd273527ff58f74c02b	991250000000000000	452312848583266388373324160190187140051835877600158453279131187530910679040	0xc590175e458b83680867afd273527ff58f74c02b	2022-04-27T20:50:41.000Z	0xfadcc5970a11da5df156a9dfc201d4f4b38c8cc34cc5b6703ceda8c923766ea5	32600973028448795813	32600973028448795813
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x1943b370c5c111ecac9981c80515da17	false	168	0x00000000000000000000006d6574616d61736b32	0x1adcef5c780d8895ac77e6ee9239b4b3ecb76da2	27616948	0x04f177fcacf6fb4d2f95d41d7d3fee8e565ca1d0	0xc590175e458b83680867afd273527ff58f74c02b	9912500	452312848583266388373324160190187140051835877600158453279131187530910679040	0xc590175e458b83680867afd273527ff58f74c02b	2022-04-27T00:29:38.000Z	0x88c979abadc98682920937e248545efde5dc63c8707c83f73dda3b7fe81e3192	1226515867128144188	1226515867128144188

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_polygon.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	0x35b1d0f0909711ecb576fd0c9acebcd6	false	583	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	25075870	0x1bfd67037b42cf73acf2047067bd4f2c47d9bfd6	0xf685b90cbc6f6a1d4cbb9ab18ce54942cecf8afa	411109216	0xf685b90cbc6f6a1d4cbb9ab18ce54942cecf8afa	2022-02-18T08:46:23.000Z	0xf70b139078ee8cc8e5d4f0f5fa8d1fa4d35869cd07a090c86acd2a03aac499da	1000000
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0xa8506e20908b11ecbbd1e7d8eed8620c	false	298	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	25074143	0x1bfd67037b42cf73acf2047067bd4f2c47d9bfd6	0xe61399fc0d5f1bf4e0522af6534ec940ada40950	412364036	0xe61399fc0d5f1bf4e0522af6534ec940ada40950	2022-02-18T07:23:55.000Z	0xdb737be1a44d0e92fdc5a4f8b11b3ef5b4d79439266e165cb1a0ca3380229419	1000000
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x3eff981090ae11ecb3f56988bbc777e6	false	458	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	25079814	0x1bfd67037b42cf73acf2047067bd4f2c47d9bfd6	0xf685b90cbc6f6a1d4cbb9ab18ce54942cecf8afa	101942369	0xf685b90cbc6f6a1d4cbb9ab18ce54942cecf8afa	2022-02-18T11:31:30.000Z	0x40ff430af59b94610b94d18718a3358a510b642d4c473ca342d24e8aeb008c21	250000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_polygon.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	0x326a27101cc711ec964229fc8061bb93	false	106	0x4c392822d4be8494b798cea17b43d48b2308109c	19437380	0x00e5646f60ac6fb446f621d146b6e1886f002905	0x028b2b9adca1bd1263086b0b221713a684968817	4850000000000000000000	0x028b2b9adca1bd1263086b0b221713a684968817	2021-09-23T23:37:37.000Z	0xaec32ff8f66af4c6ad43dc9537c8ee708429bb52063294616fa9887efb58f6ad	7790009993391820864	7790009993391820864
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x55289ef01c1111ecae662f48f615bcfe	false	531	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	19404551	0x033d942a6b495c4071083f4cde1f17e986fe856c	0xb01e4f6042590061c511d422b1f8e38302778b4d	462766220568029839	0xb01e4f6042590061c511d422b1f8e38302778b4d	2021-09-23T01:56:52.000Z	0xe9c0e3732da20ada61a48a2d076fe1f3fd419fb8073f2cf69edca0b574d36add	7282	7274
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0xdc1618201c1111ec8e070b45633c02f7	false	889	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	19404678	0x033d942a6b495c4071083f4cde1f17e986fe856c	0xb01e4f6042590061c511d422b1f8e38302778b4d	462766220568029839	0xb01e4f6042590061c511d422b1f8e38302778b4d	2021-09-23T02:04:58.000Z	0x938cc134650a1e3bc435d143b20d1feede238c9131d51cf269d1cfe189023796	7286	7261

Example Query

Query with partition filter

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

LiquidityMining2_RewardPaid_event

Reward distribution events from ParaSwap V5’s liquidity mining program on Polygon, recording token rewards paid to users for providing liquidity. Used to track incentive payouts and analyze participant rewards across different reward token types.

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_rewardToken`	`STRING`	Contract address of the reward token being distributed or claimed. 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	in_rewardToken	block_timestamp	transaction_hash
0x64d2b3994f64e3e82e48cc92e1122489e88e8727	0x065b3d184f0effcaae09337c700f806c695b457a	false	7643616215928034829	175	32675081	0x42d61d766b85431666b39b89c43011f24451bff6	2022-09-04T09:42:28.000Z	0x1f025ce16c91b318e81f3fb709028708690a8c8ea687f2cba238251aed15becc
0x64d2b3994f64e3e82e48cc92e1122489e88e8727	0x065b3d184f0effcaae09337c700f806c695b457a	false	1780974108171602	173	32675081	0xf28164a485b0b2c90639e47b0f377b4a438a16b1	2022-09-04T09:42:28.000Z	0x1f025ce16c91b318e81f3fb709028708690a8c8ea687f2cba238251aed15becc
0x64d2b3994f64e3e82e48cc92e1122489e88e8727	0xca5a98a7d71e0332d875f19b17618706c123412b	false	121029448143420810437	178	38916647	0x42d61d766b85431666b39b89c43011f24451bff6	2023-02-04T22:27:30.000Z	0x7e4d11e8abe650840593acb57493827435df794608437883ea4c54a463a0fa9f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_polygon.LiquidityMining2_RewardPaid_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
0xd15fe65bcf0b612343e879434dc72db1721f732d	false	103	860244984530224919	56875079	0x506480ce7db2848d0ce885e3999f5888c86bb729	2024-05-12T08:57:23.000Z	0x56c38fd778f7f77c8d5ab4409d8e809483c4f4b19e86cec21b5fa51aebd8d747
0xd15fe65bcf0b612343e879434dc72db1721f732d	false	89	54724374614284079122	50994774	0xf0d0be6ac03901d4d659005fafb687abbd2dbe91	2023-12-11T04:35:46.000Z	0x9a12daf8886a8760bda6506b26e5cfbf4588979b5c9aa03e1860f8579b6bff86
0xd15fe65bcf0b612343e879434dc72db1721f732d	false	182	107617722920384590232	36680668	0x8e13649613b774ab67d1c1edfc22a2202270fd81	2022-12-11T01:25:04.000Z	0x35d83f8ef283f13f4d02fcf36c1c03bf0e23130590f3ad01a39ed2a9c21014b2

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AugustusSwapper_BoughtV3_event

AugustusSwapper_SwappedDirect_event

AugustusSwapper_SwappedV3_event

AugustusSwapper2_Bought2_event

AugustusSwapper2_Swapped2_event

AugustusSwapperIParaswap_Bought_event

AugustusSwapperIParaswap_Swapped_event

LiquidityMining2_RewardPaid_event

MerkleRedeem_Claimed_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AugustusSwapper_BoughtV3_event

​AugustusSwapper_SwappedDirect_event

​AugustusSwapper_SwappedV3_event

​AugustusSwapper2_Bought2_event

​AugustusSwapper2_Swapped2_event

​AugustusSwapperIParaswap_Bought_event

​AugustusSwapperIParaswap_Swapped_event

​LiquidityMining2_RewardPaid_event

​MerkleRedeem_Claimed_event

Tables

AugustusSwapper_BoughtV3_event

AugustusSwapper_SwappedDirect_event

AugustusSwapper_SwappedV3_event

AugustusSwapper2_Bought2_event

AugustusSwapper2_Swapped2_event

AugustusSwapperIParaswap_Bought_event

AugustusSwapperIParaswap_Swapped_event

LiquidityMining2_RewardPaid_event

MerkleRedeem_Claimed_event