paraswap_v5_ethereum

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	0x650b86e84f424799ac6a8a314b273994	false	207	0x0000000000000000000000000000000000000000	0xdac17f958d2ee523a2206206994597c13d831ec7	17762340	0x514910771af9ca656af840dff83e8264ecf986ca	0x02e7b8511831b1b02d9018215a0f8f500ea5c6b3	9174898049	452312848583266388373324160190187140051835877600158453279131187530910711808	0x02e7b8511831b1b02d9018215a0f8f500ea5c6b3	2023-07-24T10:22:47.000Z	0x38b19ed7d9e64e4ab258f3f87461ca0d7f5697a5ce4a046b11ec2253ce4bacb8	9189919246	1200032671862058280573
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x9bdaa598a12a4e909d54da5002e1a5ea	false	263	0x0000000000000000000000000000000000000000	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	17765764	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x02e7b8511831b1b02d9018215a0f8f500ea5c6b3	39954136979298914360	452312848583266388373324160190187140051835877600158453279131187530910711808	0x02e7b8511831b1b02d9018215a0f8f500ea5c6b3	2023-07-24T21:52:11.000Z	0xf742ed4a5eb51c8fa780f558ca783e44b5ca2bc77607fcbad32c0e80294a4cf4	40052338875310532378	73818911477
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0xe3d14e7bbb794920870a54915753d805	false	19	0x0000000000000000000000000000000000000000	0xd533a949740bb3306d119cc777fa900ba034cd52	17764502	0x6b175474e89094c44da98b954eedeac495271d0f	0x02e7b8511831b1b02d9018215a0f8f500ea5c6b3	34185896276684380296340	452312848583266388373324160190187140051835877600158453279131187530910711808	0x02e7b8511831b1b02d9018215a0f8f500ea5c6b3	2023-07-24T17:38:23.000Z	0x96376f95f2c5040800246221368db7243a598f18d57a0da8f5ce6cffdbbbdde7	34015835503257380340980	24294240141738902038979

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_ethereum.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	0x3fbeaf6a7add429a9d828f0a937b551c	false	371	0xa9298e4ab79e68d69069039cb149c2c2ff3d6f0a	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	21649823	0x03dcee0d21ab39614c768dab67bfc33b0fc0a047	0xf795bcd8c5ee5d454d5a261097b385b9e18818be	70000000000000000	452312848583266388373324160190187140051835877600158453279131187530910679135	0xf795bcd8c5ee5d454d5a261097b385b9e18818be	2025-01-18T07:17:35.000Z	0x27d8e9771dbdd92890c3d75b187f57e96c75126b9c875e237fc458627def1a69	99379425065459240302853	99379425065459240302853
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x1a9db389a427461d94b14ed36971fe45	false	252	0xca74f404e0c7bfa35b13b511097df966d5a65597	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	21650060	0x0b7f0e51cd1739d6c96982d55ad8fa634dd43a9c	0xca74f404e0c7bfa35b13b511097df966d5a65597	1000000000000000000	452312848583266388373324160190187140051835877600158453279131187530910864264	0xca74f404e0c7bfa35b13b511097df966d5a65597	2025-01-18T08:05:23.000Z	0x0a366d6ba930e37dca1a769f527b88b58eb82294bd7bd0e2975b51545ba657bd	119901119754854854148	119901119754854854148
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x11abe063152643919e8be235f8145643	false	385	0xca74f404e0c7bfa35b13b511097df966d5a65597	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	21650407	0x1151cb3d861920e07a38e03eead12c32178567f6	0xca74f404e0c7bfa35b13b511097df966d5a65597	1000000000000000000	452312848583266388373324160190187140051835877600158453279131187530910864264	0xca74f404e0c7bfa35b13b511097df966d5a65597	2025-01-18T09:14:59.000Z	0x5f4844fa9564adeb5803247b9d17c6c98ffd50b12cc1ed4e54220b760156a4f0	10419066890569	10419066890569

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_ethereum.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	0x43ae192cd818452a9364af3197ff4e42	false	183	0x0000000000000000000000000000000000000000	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	17173749	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x59347361ae8dfa71837b4a69b75fd771cf77733b	5265082109780664661	452312848583266388373324160190187140051835877600158453279131187530910679040	0x59347361ae8dfa71837b4a69b75fd771cf77733b	2023-05-02T14:41:59.000Z	0xa94557a87586a3490fb55a36e2a774ad1f10a79c1cf6518c16245f8dc81e6d55	9799436715	9808404242
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x9364bcd8a1d64da59d85f19ed1257d8c	false	225	0x0000000000000000000000000000000000000000	0xac3211a5025414af2866ff09c23fc18bc97e79b1	17170905	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x65a8f07bd9a8598e1b5b6c0a88f4779dbc077675	123440058286597930009842	452312848583266388373324160190187140051835877600158453279131187530910679040	0x65a8f07bd9a8598e1b5b6c0a88f4779dbc077675	2023-05-02T05:05:35.000Z	0xcc89b9b3db3c0f7cd6bafb6b8b66616e9d752d320fa6c1b1efb9a5c42ed4bdce	2183409842	1091704921
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x59f9b7be8b484dd0a7e60f388c2af91f	false	164	0x0000000000000000000000000000000000000000	0xfb4d8bee1840f3897d2344035f68ed594359c939	17173757	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0x65a8f07bd9a8598e1b5b6c0a88f4779dbc077675	229854847518765218565	452312848583266388373324160190187140051835877600158453279131187530910679040	0x65a8f07bd9a8598e1b5b6c0a88f4779dbc077675	2023-05-02T14:43:35.000Z	0xd04fabf221921814e1e9178827d0ba243db80ff4208a3e567b1de2997866e284	3333410692529809062	1666705346264904531

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_ethereum.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	0xbdaf49b0be2d11ec9bfe95ba0f6c7a71	false	191	0x0000000000000000000000000000000000000000	0x3472a5a71965499acd81997a54bba8d852c6e53d	14601876	0xdac17f958d2ee523a2206206994597c13d831ec7	0xb24dca776c1257248024f8fb4315d5f5009217fe	346174536357927008211	452312848583266388373324160190187140051835877600158453279131187530910679040	0xb24dca776c1257248024f8fb4315d5f5009217fe	2022-04-17T09:07:32.000Z	0x3bb94143aa32adc9e300261f0a140be1807ca51e73ae29346b463e334c81df4b	3000000000
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x4b2bc710be6411ecba5273cf158fa208	false	604	0x0000000000000000000000000000000000000000	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	14603619	0xc0d4ceb216b3ba9c3701b291766fdcba977cec3a	0xe87a10d5b212d169ccbc9a50cf5e23dd3da27cb6	391002061708027019	452312848583266388373324160190187140051835877600158453279131187530910679040	0xe87a10d5b212d169ccbc9a50cf5e23dd3da27cb6	2022-04-17T15:37:40.000Z	0x7f82b6541bd63ae7f80dd05e6b801f939a7e61808926bcec70140561eaca07cb	6000000000
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x94abf8d0be6711ec9224ef05ef3474d2	false	311	0x0000000000000000000000000000000000000000	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	14603721	0xf59257e961883636290411c11ec5ae622d19455e	0xe87a10d5b212d169ccbc9a50cf5e23dd3da27cb6	280660334734874763	452312848583266388373324160190187140051835877600158453279131187530910679040	0xe87a10d5b212d169ccbc9a50cf5e23dd3da27cb6	2022-04-17T16:01:10.000Z	0x4ec9944ae00193f90bedd8641d846e726eb327b5601fd3ddf6eba7206982e830	30000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_ethereum.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	0x67bae706540d4f07ac3c0265ceed98e5	false	207	0x0000000000000000000000000000000000000000	0xcafe001067cdef266afb7eb5a286dcfd277f3de5	14957779	0xdac17f958d2ee523a2206206994597c13d831ec7	0x000000000062c524bd4d32f62f2e569bf171ffdd	344574956688981179104703	452312848583266388373324160190187140051835877600158453279131187530910679040	0x000000000062c524bd4d32f62f2e569bf171ffdd	2022-06-13T19:47:44.000Z	0xf0dfde4d8768aeae586fc1c8d542fc01bc7731f993dfc2abdbf258a62cd4cb0a	9523565919	9507296494
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x69a3bc90467f4daa89f48730ed9183eb	false	352	0x0000000000000000000000000000000000000000	0x7ddc52c4de30e94be3a6a0a2b259b2850f421989	14957426	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	0x000000000062c524bd4d32f62f2e569bf171ffdd	34326620000000000000000	452312848583266388373324160190187140051835877600158453279131187530910679040	0x000000000062c524bd4d32f62f2e569bf171ffdd	2022-06-13T18:18:51.000Z	0xf5dad93de7ff0d6bdc86699c10c24eea2d70604be11f28e444db2e815e008623	3538413931692740123	3538413931692740123
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x0d891236db674cb59d91494f358c5998	false	236	0x0000000000000000000000000000000000000000	0xbc19712feb3a26080ebf6f2f7849b417fdd792ca	14957422	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	0x000000000062c524bd4d32f62f2e569bf171ffdd	132794210732776338700277	452312848583266388373324160190187140051835877600158453279131187530910679040	0x000000000062c524bd4d32f62f2e569bf171ffdd	2022-06-13T18:17:34.000Z	0xc8cb8fd55c3d3758344b1f313a7bda2b8110954c8acca3dfcd30d6ce6ab80487	1135192734146921221	1135229542652255874

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_ethereum.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	0xb2045fc05b5d11ec8a2947db3a228725	false	14	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	13791038	0xe41d2489571d322189246dafa5ebde1f4699f498	0x43229759e12efbe3e2a0fb0510b15e516d046442	2729949600402041490	0x43229759e12efbe3e2a0fb0510b15e516d046442	2021-12-12T15:12:00.000Z	0x3785b600a0f1d1f1b3e934a563cc2cbc7ef1aa78fb071231647a4881c494fd87	12600000000000000000000
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0xe5c382805b4111ec9c5be3847b6a7adb	false	55	0xf5581dfefd8fb0e4aec526be659cfab1f8c781da	13790132	0x6b175474e89094c44da98b954eedeac495271d0f	0x9008d19f58aabd9ed0d60971565aa8510560ab41	84399806549915419815483	0x9008d19f58aabd9ed0d60971565aa8510560ab41	2021-12-12T11:52:32.000Z	0x3cf988b79a9d21b363541f94b0602a52812204345b0e50334cbaa597f7f2a4a6	20000000000000000000000
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x2467ebc05b7e11ecaa31dd20eda2245f	false	107	0x7ae1d57b58fa6411f32948314badd83583ee0e8c	13792125	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0x9008d19f58aabd9ed0d60971565aa8510560ab41	318653318497366542171050	0x9008d19f58aabd9ed0d60971565aa8510560ab41	2021-12-12T19:06:46.000Z	0xd72cef28e458a5785b04c0a374e922c82d672b3354bdc9b9952d8fa36cfcf0d5	2000000000000000000

Example Query

Query with partition filter

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

AugustusSwapperIParaswap_buyOnUniswap_function

ParaSwap V5 buyOnUniswap function calls on Ethereum showing exact-output swaps through Uniswap pools with token paths, maximum input amounts, and execution details. Used for analyzing limit buy orders and price impact for specific output token amounts.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_amountInMax`	`STRING`	Maximum amount of input tokens allowed to be spent for the swap. Numeric string representing the token quantity in its smallest denomination.
`in_amountOut`	`STRING`	Amount of output tokens received from the swap. Numeric string representing the token quantity in its smallest denomination.
`in_path`	`ARRAY<STRING>`	Ordered sequence of token contract addresses representing the swap route from input token to output token. Array of hex-encoded, 0x-prefixed, 42-character addresses.

Sample Data

gas	value	status	in_path	gas_used	signature	to_address	block_number	from_address	in_amountOut	in_amountInMax	block_timestamp	transaction_hash
231371	1085507798038727800	false	[]	45296	0x935fb84b	0xdef171fe48cf0115b1d80b88dc8eab59176fee57	13937985	0xdf8b436045b7223eb2c999ec56b2557d358787d2			2022-01-04T08:43:04.000Z	0x915896ddf97c759de739cfa577d98ff74943154c93aacc4521efdbdea2f9b4ae
153817	182342055396436450	true	[“0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee”,“0x03be5c903c727ee2c8c4e9bc0acc860cca4715e2”]	112729	0x935fb84b	0xdef171fe48cf0115b1d80b88dc8eab59176fee57	13938888	0x5f8e8c2d947645439a5f6e9d50b6de7cffb0ae02	7000000000000000000000	182342055396436448	2022-01-04T12:05:05.000Z	0x925d53a5763bd571715f173b80215b4a7281c4320d98beb0a844439a1d7d4a8c
175578	453075895223560450	true	[“0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee”,“0x6123b0049f904d730db3c36a31167d9d4121fa6b”]	121483	0x935fb84b	0xdef171fe48cf0115b1d80b88dc8eab59176fee57	13938771	0xdd84ce1adcb3a4908db61a1dfa3353c3974c5a2b	500000000000000000000	453075895223560467	2022-01-04T11:37:46.000Z	0x2797d0171645f0a8675e0acc6c3b138415be89cc939517dc8d97dfb80976ce44

Example Query

Query with partition filter

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

AugustusSwapperIParaswap_buyOnUniswapFork_function

Function calls to ParaSwap V5’s buyOnUniswapFork method on Ethereum, recording buy orders executed through Uniswap fork DEXs with swap paths, amounts, and factory addresses. Used for analyzing ParaSwap’s Uniswap-compatible routing and failed transaction patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_factory`	`STRING`	Contract address of the factory that deployed or created the associated resource. Hex-encoded, 0x-prefixed, 42-character string.
`in_initCode`	`STRING`	Keccak-256 hash of the initialization code used by the factory to compute pair addresses. 66-character hex string including 0x prefix.
`in_amountInMax`	`STRING`	Maximum amount of input tokens allowed to be spent for the swap. Numeric string representing the token quantity in its smallest denomination.
`in_amountOut`	`STRING`	Amount of output tokens received from the swap. Numeric string representing the token quantity in its smallest denomination.
`in_path`	`ARRAY<STRING>`	Ordered sequence of token contract addresses representing the swap route from input token to output token. Array of hex-encoded, 0x-prefixed, 42-character addresses.

Sample Data

gas	value	status	in_path	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
407849	248030610262596640	false	[]	46323	0xc03786b0	0xdef171fe48cf0115b1d80b88dc8eab59176fee57	13323659	0x7f0297bc2a3dc75cec24385324bf21d7236c8220	2021-09-29T23:35:01.000Z	0x1acab23db87abee4e8fab8c3063a8410604348dd032cae548b769eeb8ae639e0
187694	0	false	[]	166928	0xc03786b0	0xdef171fe48cf0115b1d80b88dc8eab59176fee57	13320609	0x4ecbaa7d2f86f2d78c04f49986ec2c57938752a6	2021-09-29T12:18:41.000Z	0x03cb4bc5023cb9f316bc267c91da303c24c97056f298a264f6f4e18f92d847ec
333514	250241879252698800	false	[]	38346	0xc03786b0	0xdef171fe48cf0115b1d80b88dc8eab59176fee57	13323641	0x7f0297bc2a3dc75cec24385324bf21d7236c8220	2021-09-29T23:31:14.000Z	0xac34bdbe9bb24158159e6af513703f9a8ca69141ac08d6e646a016c417081c1f

Example Query

Query with partition filter

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

AugustusSwapperIParaswap_buyOnUniswapV2Fork_function

Function call records for ParaSwap V5’s buyOnUniswapV2Fork method on Ethereum, executing token purchases through Uniswap V2-compatible DEXs with specified maximum input amounts and target output quantities for price-limited swap 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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_tokenIn`	`STRING`	Contract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountInMax`	`STRING`	Maximum amount of input tokens allowed to be spent for the swap. Numeric string representing the token quantity in its smallest denomination.
`in_amountOut`	`STRING`	Amount of output tokens received from the swap. Numeric string representing the token quantity in its smallest denomination.
`in_weth`	`STRING`	Contract address of the Wrapped ETH (WETH) token used in the swap or pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_pools`	`ARRAY<STRING>`	Array of encoded pool identifiers for routing token swaps through decentralized exchanges. Elements are numeric strings representing packed pool addresses and swap parameters.

Sample Data

gas	value	status	in_weth	gas_used	in_pools	signature	in_tokenIn	to_address	block_number	from_address	in_amountOut	in_amountInMax	block_timestamp	transaction_hash
227419	1012457565593600100	false		36572	[]	0xb2f1e6db		0xdef171fe48cf0115b1d80b88dc8eab59176fee57	18080250	0x9da106d7a71a0f5a37464dc48e7300231c2e3883			2023-09-06T22:02:35.000Z	0x626e749baa75cb787c7f14a9a8c14b76286260dc07ba9007aaf024495e02b973
143326	0	true	0x0000000000000000000000000000000000000000	109639	[“29143191691814345574290076702460616132169920624637750”]	0xb2f1e6db	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0xdef171fe48cf0115b1d80b88dc8eab59176fee57	18077390	0xaadf465695b80d5f8a1079b6646ba0bdbbaa4307	1338000000000000000000	527391017835106130	2023-09-06T12:25:59.000Z	0x1d882237c04d3f0934391e05d367e00185c522bfff1963f43ef72d97875ed233
144222	0	true	0x0000000000000000000000000000000000000000	110345	[“29144181392993959472682930482181132511069976815422113”]	0xb2f1e6db	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0xdef171fe48cf0115b1d80b88dc8eab59176fee57	18078774	0xaadf465695b80d5f8a1079b6646ba0bdbbaa4307	105570000000000000000000	509652465821229486	2023-09-06T17:04:47.000Z	0x4919848f31adcd5fd63ecf3ef90b1179cd0a159047715cec3025292f31572c29

Example Query

Query with partition filter

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

AugustusSwapperIParaswap_swapOnUniswap_function

Uniswap swap executions routed through ParaSwap V5 aggregator on Ethereum, capturing token paths, input/output amounts, and slippage parameters. Used for analyzing DEX aggregator routing patterns and comparing expected versus actual swap outcomes.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_amountIn`	`STRING`	Amount of input tokens being swapped or deposited in the transaction. Numeric string representing the token quantity in its smallest denomination.
`in_amountOutMin`	`STRING`	Minimum acceptable output amount for the swap or transfer operation. Numeric string representation of token quantity in smallest denomination.
`in_path`	`ARRAY<STRING>`	Ordered sequence of token contract addresses representing the swap route from input token to output token. Array of hex-encoded, 0x-prefixed, 42-character addresses.

Sample Data

gas	status	in_path	gas_used	signature	to_address	in_amountIn	block_number	from_address	block_timestamp	in_amountOutMin	transaction_hash
233713	true	[“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“0x88acdd2a6425c3faae4bc9650fd7e27e0bebb7ab”]	197832	0x54840d1a	0xdef171fe48cf0115b1d80b88dc8eab59176fee57	95288182708980942	13381381	0x517540ee76e5bb0bcd8472c6c91a1f0e54f21849	2021-10-09T00:25:05.000Z	2524918908134278793	0x6383feb0ed35bf52f2f5d6f68d30a7b1a6b4fdc326939f5b34ecd505522cbdd5
173338	true	[“0xd9016a907dc0ecfa3ca425ab20b6b785b42f2373”,“0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee”]	120410	0x54840d1a	0xdef171fe48cf0115b1d80b88dc8eab59176fee57	50000000000000000000000	13382053	0xa75f9c8246f7269279be4c969e7bc6eb619cc204	2021-10-09T02:59:23.000Z	3601048132330405215	0x23fcb60d61f52d63b4545d901d80d1d79bdfdba90bfb41f82f91e0d8d1cb7e7b
170762	true	[“0xac3211a5025414af2866ff09c23fc18bc97e79b1”,“0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee”]	123722	0x54840d1a	0xdef171fe48cf0115b1d80b88dc8eab59176fee57	15000000000000000000000	13383866	0x952138b856771785c2b55da4aa1c926aeaaba214	2021-10-09T09:59:51.000Z	91284998215080352	0xe348067dfdd85bc3d31cffadd9dfa376c0a199d494b05c16feabc1c3fb6bc507

Example Query

Query with partition filter

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

AugustusSwapperIParaswap_swapOnUniswapFork_function

Function call records for Uniswap fork swaps executed through ParaSwap v5’s Augustus router on Ethereum. Tracks swap paths, input/output amounts, and factory addresses for analyzing DEX aggregation routing and execution efficiency.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_factory`	`STRING`	Contract address of the factory that deployed or created the associated resource. Hex-encoded, 0x-prefixed, 42-character string.
`in_initCode`	`STRING`	Keccak-256 hash of the initialization code used by the factory to compute pair addresses. 66-character hex string including 0x prefix.
`in_amountIn`	`STRING`	Amount of input tokens being swapped or deposited in the transaction. Numeric string representing the token quantity in its smallest denomination.
`in_amountOutMin`	`STRING`	Minimum acceptable output amount for the swap or transfer operation. Numeric string representation of token quantity in smallest denomination.
`in_path`	`ARRAY<STRING>`	Ordered sequence of token contract addresses representing the swap route from input token to output token. Array of hex-encoded, 0x-prefixed, 42-character addresses.

Sample Data

gas	value	status	in_path	gas_used	signature	in_factory	to_address	in_amountIn	in_initCode	block_number	from_address	trace_address	block_timestamp	in_amountOutMin	transaction_hash
165072	20000000000000000	false	[]	145405	0xf5661034		0xdef171fe48cf0115b1d80b88dc8eab59176fee57			14075869	0x0411e650dff0c6680c9e147f2413e0480718aa27		2022-01-25T16:37:41.000Z		0xde8c46d9af0a85348b0822fb706cc3b75f0802a0ba0174fbbed41341ee924981
1143657	0	false	[]	98971	0xf5661034		0xdef171fe48cf0115b1d80b88dc8eab59176fee57			14071977	0x135896de8421be2ec868e0b811006171d9df802a	0,1,13	2022-01-25T01:59:23.000Z		0xfc00256dca14c2f9844f75af2955d3c3047aeea8794c3c6901c8d45c5dbc1fb9
134578	71370000000000000	true	[“0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee”,“0x761d38e5ddf6ccf6cf7c55759d5210750b5d60f3”]	106367	0xf5661034	0x115934131916c8b277dd010ee02de363c09d037c	0xdef171fe48cf0115b1d80b88dc8eab59176fee57	71370000000000000	0x65d1a3b1e46c6e4f1be1ad5f99ef14dc488ae0549dc97db9b30afe2241ce1c7a	14074591	0x74de5d4fcbf63e00296fd95d33236b9794016631	0,0,0	2022-01-25T11:49:05.000Z	218212117697758072431599727	0xce034f7429f80f3617d1c2c503e129700c6565e0076e355633b752cde9328c13

Example Query

Query with partition filter

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

AugustusSwapperIParaswap_swapOnUniswapV2Fork_function

Failed swap attempts on ParaSwap V5’s UniswapV2Fork router function on Ethereum. All sample records show failed transactions (status=false) with null input parameters, useful for analyzing routing failures and transaction error patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_tokenIn`	`STRING`	Contract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountIn`	`STRING`	Amount of input tokens being swapped or deposited in the transaction. Numeric string representing the token quantity in its smallest denomination.
`in_amountOutMin`	`STRING`	Minimum acceptable output amount for the swap or transfer operation. Numeric string representation of token quantity in smallest denomination.
`in_weth`	`STRING`	Contract address of the Wrapped ETH (WETH) token used in the swap or pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_pools`	`ARRAY<STRING>`	Array of encoded pool identifiers for routing token swaps through decentralized exchanges. Elements are numeric strings representing packed pool addresses and swap parameters.

Sample Data

gas	status	gas_used	in_pools	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
230208	false	221862	[]	0x0b86a4c1	0xdef171fe48cf0115b1d80b88dc8eab59176fee57	17915494	0x1d7274b99b908be28a85be69ea164784faf9a20c	2023-08-14T20:32:23.000Z	0x23314a6a01ff1ae1f84c8f51fd76ba449e950189dc3e3c8f1cecba83e084bb6a
257072	false	168909	[]	0x0b86a4c1	0xdef171fe48cf0115b1d80b88dc8eab59176fee57	17915711	0xbc9ae2d9e75507b77a0466e877cfdaecd2447ac0	2023-08-14T21:16:35.000Z	0xfea61d6125e9fdb0b0cbca37bba15b846fffb89d47fe2164abf825ed367f3971
183750	false	135213	[]	0x0b86a4c1	0xdef171fe48cf0115b1d80b88dc8eab59176fee57	17915327	0xcc7dcbf7b968ef2fa60c174981f51b1757312f84	2023-08-14T19:58:59.000Z	0x6e6eec1c290d0afd5bcfa77a5aa7489fa5bcfa3f4511f48622a7890abc29debb

Example Query

Query with partition filter

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

AugustusSwapperIParaswap_swapOnZeroXv2_function

ParaSwap v5 token swap executions on Ethereum routed through 0x v2 protocol, capturing swap parameters including input/output tokens, amounts, minimum output thresholds, and execution status for analyzing DEX aggregator routing patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_amountOutMin`	`STRING`	Minimum acceptable output amount for the swap or transfer operation. Numeric string representation of token quantity in smallest denomination.
`in_exchange`	`STRING`	Contract address of the 0x exchange router used to execute this token swap. Hex-encoded, 0x-prefixed 40-character Ethereum address identifying the DEX protocol integration.
`in_payload`	`STRING`	Encoded data transmitted in a cross-chain message or contract call. Hex-encoded, 0x-prefixed string containing function parameters, transaction instructions, or other application-specific information.

Sample Data

gas	value	status	gas_used	signature	in_payload	in_toToken	to_address	in_exchange	block_number	from_address	in_fromToken	in_fromAmount	trace_address	block_timestamp	in_amountOutMin	transaction_hash
35794	0	false	35794	0x81033120	0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000002c0000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000006daea1723962647b7e189d311d757fb793000000000000000000000000def171fe48cf0115b1d80b88dc8eab59176fee5700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000015f2bb07f66311000000000000000000000000000000000000000000000000000000000023461a8b000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000612d2d3a00000000000000000000000000000000000000000000000000000000196cd614000000000000000000000000000000000000000000000000000000000000018000000000000000000000000000000000000000000000000000000000000001e00000000000000000000000000000000000000000000000000000000000000024f47261b00000000000000000000000007fc66500c84a76ad7e9c93437bfc5ac33e2ddae9000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000024f47261b0000000000000000000000000dac17f958d2ee523a2206206994597c13d831ec7000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000421c7b44cfc210222497f3ece7e875e9f9ff9dbf01924c0204e7839722f722cf79572e015d46b0a648f88521c327ed0ff19bf17ce6d762eaa8080fcd144b64e26d1204000000000000000000000000000000000000000000000000000000000000	0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9	0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x080bf510fcbf18b91105470639e9561022937712	15281972	0xb13bb982865b222c2e62b665512e2dbc91874535	0xdac17f958d2ee523a2206206994597c13d831ec7	150000000000		2022-08-05T11:12:55.000Z	389176674727515482850	0xdebbf9208cd8c483e043bc982454ac0899290e3c029a922b43d70983afa7899e
671310	0	true	503535	0x81033120	0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000002c0000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000006daea1723962647b7e189d311d757fb793000000000000000000000000def171fe48cf0115b1d80b88dc8eab59176fee5700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000015f2bb07f66311000000000000000000000000000000000000000000000000000000000023461a8b000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000612d2d3a00000000000000000000000000000000000000000000000000000000196cd614000000000000000000000000000000000000000000000000000000000000018000000000000000000000000000000000000000000000000000000000000001e00000000000000000000000000000000000000000000000000000000000000024f47261b00000000000000000000000007fc66500c84a76ad7e9c93437bfc5ac33e2ddae9000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000024f47261b0000000000000000000000000dac17f958d2ee523a2206206994597c13d831ec7000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000421c7b44cfc210222497f3ece7e875e9f9ff9dbf01924c0204e7839722f722cf79572e015d46b0a648f88521c327ed0ff19bf17ce6d762eaa8080fcd144b64e26d1204000000000000000000000000000000000000000000000000000000000000	0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9	0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x080bf510fcbf18b91105470639e9561022937712	13128687	0xbc147973709a9f8f25b5f45021cab1ea030d3885	0xdac17f958d2ee523a2206206994597c13d831ec7	150000000000		2021-08-30T19:10:08.000Z	389176674727515482850	0xe37f4739b8069ff94b052b500a50f137bfa26d6f50b05a6f7c145f477e6beb0a

Example Query

Query with partition filter

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

AugustusSwapperIParaswap_swapOnZeroXv4_function

ParaSwap v5 function calls routing swaps through 0x Protocol v4 on Ethereum, capturing token pair swaps, input/output amounts, and transaction execution status for analyzing DEX aggregator routing patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_amountOutMin`	`STRING`	Minimum acceptable output amount for the swap or transfer operation. Numeric string representation of token quantity in smallest denomination.
`in_exchange`	`STRING`	Contract address of the 0x Protocol exchange router used to execute this swap. Null when the function call failed before parameters were decoded.
`in_payload`	`STRING`	Encoded data transmitted in a cross-chain message or contract call. Hex-encoded, 0x-prefixed string containing function parameters, transaction instructions, or other application-specific information.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
1175799	false	46331	0x64466805	0xdef171fe48cf0115b1d80b88dc8eab59176fee57	14021235	0x135896de8421be2ec868e0b811006171d9df802a	0,1,13	2022-01-17T05:56:11.000Z	0xf4df2ff4afb13517cd0bf1074432366f15f9ba8a96a26b85e21d4c9b1c738d96
292243	false	96274	0x64466805	0xdef171fe48cf0115b1d80b88dc8eab59176fee57	14023630	0x46c8cf6c7330953d4cfc270a1369b4c31cf7c464		2022-01-17T14:43:42.000Z	0xf5174c9a587dc6336c71b54df7da035f06f11e8c296238608cb307b6335dc89b
228713	false	107221	0x64466805	0xdef171fe48cf0115b1d80b88dc8eab59176fee57	14022530	0x33d66941465ac776c38096cb1bc496c673ae7390		2022-01-17T10:39:11.000Z	0xf5853c648950762a615e34b72743816b480949578232e5e3ed27c6bebfe9f260

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_ethereum.AugustusSwapperIParaswap_swapOnZeroXv4_function`
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	0x65ceb6003f4211ecadde6511f6c6f59a	false	294	0x6b175474e89094c44da98b954eedeac495271d0f	13565161	0x4c2e59d098df7b6cbae0848d66de2f8a4889b9c3	0x5fc79e21ceca2aa0f7a0aac71ef3ddde8f004e9e	30000000000000000000000	0x5fc79e21ceca2aa0f7a0aac71ef3ddde8f004e9e	2021-11-06T20:45:16.000Z	0x09c8805d4d42335f5e0bcdf5b0186fb63707454eabd4053a7538d2867ff4c1f0	55867014413593153159213	55867357534095778096746
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x46aea9603f2e11ecae029109135e8ea8	false	104	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	13564550	0x77777feddddffc19ff86db637967013e6c6a116c	0x2270f8a2d6ad718d3d50e3016c211426b156407a	5000000000000000000	0x2270f8a2d6ad718d3d50e3016c211426b156407a	2021-11-06T18:21:56.000Z	0x6b8e641f98d1837851ff9ec2a0ec6524007927ac16ee2befbaaa7e54bee546ac	379392136863608157280	379392136863608157280
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x8f64cbd03f1a11ecbce23f5f5a9b1c7a	false	556	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	13563913	0x9c4a4204b79dd291d6b6571c5be8bbcd0622f050	0x72f54a04a7b5feea68e20855a3c69d7a02ef8c6b	10000000000	0x72f54a04a7b5feea68e20855a3c69d7a02ef8c6b	2021-11-06T16:00:47.000Z	0xe8e7743624bd6745bec7ee560a25ca99e7c7a415b0fc3715973462f821c71ec5	20132322737543011273093	20133148891221980692025

Example Query

Query with partition filter

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

LiquidityMining_LogOnReward_event

Liquidity mining reward distribution events from ParaSwap v5 DEX aggregator on Ethereum, recording token rewards claimed by users from specific pool IDs (pid). Used for tracking incentive program participation and reward payouts to liquidity providers.

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_pid`	`STRING`	Pool identifier referencing a specific staking or liquidity pool within the protocol. Numeric string representation of the pool ID.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	in_pid	address	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x53c4859560e3f268789f6de934d776b9d91e190a	31	0xefa54bae2eaa3250f096217f9d78ca599e04c9ce	0x53c4859560e3f268789f6de934d776b9d91e190a	false	3608281467275746560732	518	14473563	2022-03-28T08:13:03.000Z	0x25258182676190ed51f259062e7e0fffa6375f1f570bfc35bc5e053221c5adc6
0x63503d2809ecc72f337d562f54b05ab5f18a8457	31	0xefa54bae2eaa3250f096217f9d78ca599e04c9ce	0x63503d2809ecc72f337d562f54b05ab5f18a8457	false	607334064883033213166	165	14471462	2022-03-28T00:32:02.000Z	0x42fd1dd73716bfff26f50d2a0ed4e1c0435574ee05058ae1916c3f8bbb184df2
0x63503d2809ecc72f337d562f54b05ab5f18a8457	31	0xefa54bae2eaa3250f096217f9d78ca599e04c9ce	0x63503d2809ecc72f337d562f54b05ab5f18a8457	false	877181790037372002926	347	14477743	2022-03-28T23:53:37.000Z	0x3aa01a8f47a3c5faf33b3acbccab8033cb073874a879478cc8fd0297cadea873

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_ethereum.LiquidityMining_LogOnReward_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
0xfeb7e2d8584bef7bb21da0b70c148dabf1388031	false	589	2107301664906383338672	15442405	0x9d6949cfb82266da146daf32c52994e2224a8b38	2022-08-30T20:17:39.000Z	0x0a88dec77922e43f49e037b0f1d5aa76e94e8982085c11de84b9bbeb4f83194d
0xfeb7e2d8584bef7bb21da0b70c148dabf1388031	false	177	200374210533316974507	17754787	0x0e42d32dcc5b83a9bc74523af3b8c3a3b4cf107f	2023-07-23T09:00:35.000Z	0x5a11630aede4149e2312a7f09867ccf815c38be78f0c5f68e13cf433c78f6a57
0xfeb7e2d8584bef7bb21da0b70c148dabf1388031	false	101	864936342492179129410	16711690	0x6a3c59489f75df432408267b83290cea0e215298	2023-02-26T10:02:47.000Z	0x7e3f040ceb5a1b418fa92d5d8f140a245c84ac51dcaa8074b75be3c1987552c0

Example Query

Query with partition filter

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

MerkleRedeem2_Claimed_event

Token claim events from ParaSwap V5’s MerkleRedeem2 contract on Ethereum, recording user addresses claiming PSP token balances via Merkle proof verification. Used for analyzing reward distribution campaigns and airdrop participation patterns.

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
0x0ecb7de52096638c01757180c88b74e4474473ab	false	92	6507254784823444750096	18130001	0xd880507d359af862a5f8f318c8e934ab478ca818	2023-09-13T21:16:47.000Z	0x1ae53197593f5787a67bbf4bcdc615d44773eb240887ecefa399bc82a7857067
0x0ecb7de52096638c01757180c88b74e4474473ab	false	194	18307343390203186247647	18123921	0xc3c4ecb0845ec0393408dfadaddd6f8d4ac29e57	2023-09-13T00:49:23.000Z	0x85723769f7269bc71583ba2db85aba30f240ac9cc167009e83e270c71b3d2c8a
0x0ecb7de52096638c01757180c88b74e4474473ab	false	68	3032377316348914502358	18123890	0xbeae3275f81688bd6e51982f2fdb16bc0e333333	2023-09-13T00:43:11.000Z	0x49a395e78d78037002c6881f8c1b107de958159d97ff17597d8e620fd282b542

Example Query

Query with partition filter

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

ParaSwapLiquiditySwapAdapter_Swapped_event

Token swap events from ParaSwap v5’s Liquidity Swap Adapter contract on Ethereum. Records input/output token addresses and amounts for swaps executed through this adapter, useful for analyzing ParaSwap routing patterns and liquidity aggregation behavior.

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_fromAsset`	`STRING`	Contract address of the token being sold in the swap on Ethereum. Hex-encoded, 0x-prefixed 40-character string representing ERC-20 tokens like USDC or WETH.
`in_toAsset`	`STRING`	Contract address of the token received in the swap on Ethereum. Hex-encoded, 0x-prefixed 40-character string representing the destination asset.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`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	removed	log_index	in_toAsset	block_number	in_fromAsset	in_fromAmount	block_timestamp	transaction_hash	in_receivedAmount
0x135896de8421be2ec868e0b811006171d9df802a	false	443	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	15701397	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	500000000	2022-10-08T05:51:59.000Z	0xbf4ad89178a5e40388f7f2b39166ece33d730767df991c918386e4118f1c859b	2556103
0x135896de8421be2ec868e0b811006171d9df802a	false	206	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	15701685	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	500794722	2022-10-08T06:49:47.000Z	0x86c6eaaee679e884c47009b9ac09eab25cda66cf299db2257c133242eab480d7	2566367
0x135896de8421be2ec868e0b811006171d9df802a	false	34	0x514910771af9ca656af840dff83e8264ecf986ca	15704676	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	94419359499	2022-10-08T16:50:11.000Z	0x630a97bf9bd6e29e3b5ddd9448c02276475e269c067e460543b0aa845173ef11	12523047784964380394064

Example Query

Query with partition filter

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

SafetyModule_RewardsClaimed_event

Reward claim events from ParaSwap’s Safety Module staking contract on Ethereum, capturing when users withdraw their earned staking rewards. Used for analyzing Safety Module reward distribution patterns and staker behavior.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_to	address	in_from	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xf9aa0da6e2fa01a17e2f69e878e45bb26c1b34b7	0xc8dc2ec5f5e02be8b37a8444a1931f02374a17ab	0xf9aa0da6e2fa01a17e2f69e878e45bb26c1b34b7	false	3300763527871238716155	366	14157389	2022-02-07T06:33:33.000Z	0x0d946af72146ad9f424b48488c8d6c4755df021242c7e91ea63ed35d5d36f1e9
0x3538fb8136bd83dec94a508bd4f87fd43b3f5ca0	0xc8dc2ec5f5e02be8b37a8444a1931f02374a17ab	0x3538fb8136bd83dec94a508bd4f87fd43b3f5ca0	false	666064944188165998256	206	14158853	2022-02-07T12:19:32.000Z	0x2e5e26ab9781f6d156e9eede947fc25463c3f1c28194e3c12d0bdd14abd98924
0x81ea04c179b82d31662994a68b2582ad9d860f88	0xc8dc2ec5f5e02be8b37a8444a1931f02374a17ab	0x81ea04c179b82d31662994a68b2582ad9d860f88	false	886467536865402005628	175	14476742	2022-03-28T20:14:44.000Z	0x60df87ec3ecd68d5127860023a7a465c4d13fe8ad29a190bd986fa63ef6ba40b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_ethereum.SafetyModule_RewardsClaimed_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_buyOnUniswap_function

AugustusSwapperIParaswap_buyOnUniswapFork_function

AugustusSwapperIParaswap_buyOnUniswapV2Fork_function

AugustusSwapperIParaswap_swapOnUniswap_function

AugustusSwapperIParaswap_swapOnUniswapFork_function

AugustusSwapperIParaswap_swapOnUniswapV2Fork_function

AugustusSwapperIParaswap_swapOnZeroXv2_function

AugustusSwapperIParaswap_swapOnZeroXv4_function

AugustusSwapperIParaswap_Swapped_event

LiquidityMining_LogOnReward_event

MerkleRedeem_Claimed_event

MerkleRedeem2_Claimed_event

ParaSwapLiquiditySwapAdapter_Swapped_event

SafetyModule_RewardsClaimed_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_buyOnUniswap_function

​AugustusSwapperIParaswap_buyOnUniswapFork_function

​AugustusSwapperIParaswap_buyOnUniswapV2Fork_function

​AugustusSwapperIParaswap_swapOnUniswap_function

​AugustusSwapperIParaswap_swapOnUniswapFork_function

​AugustusSwapperIParaswap_swapOnUniswapV2Fork_function

​AugustusSwapperIParaswap_swapOnZeroXv2_function

​AugustusSwapperIParaswap_swapOnZeroXv4_function

​AugustusSwapperIParaswap_Swapped_event

​LiquidityMining_LogOnReward_event

​MerkleRedeem_Claimed_event

​MerkleRedeem2_Claimed_event

​ParaSwapLiquiditySwapAdapter_Swapped_event

​SafetyModule_RewardsClaimed_event

Tables

AugustusSwapper_BoughtV3_event

AugustusSwapper_SwappedDirect_event

AugustusSwapper_SwappedV3_event

AugustusSwapper2_Bought2_event

AugustusSwapper2_Swapped2_event

AugustusSwapperIParaswap_Bought_event

AugustusSwapperIParaswap_buyOnUniswap_function

AugustusSwapperIParaswap_buyOnUniswapFork_function

AugustusSwapperIParaswap_buyOnUniswapV2Fork_function

AugustusSwapperIParaswap_swapOnUniswap_function

AugustusSwapperIParaswap_swapOnUniswapFork_function

AugustusSwapperIParaswap_swapOnUniswapV2Fork_function

AugustusSwapperIParaswap_swapOnZeroXv2_function

AugustusSwapperIParaswap_swapOnZeroXv4_function

AugustusSwapperIParaswap_Swapped_event

LiquidityMining_LogOnReward_event

MerkleRedeem_Claimed_event

MerkleRedeem2_Claimed_event

ParaSwapLiquiditySwapAdapter_Swapped_event

SafetyModule_RewardsClaimed_event