paraswap_v3_ethereum

Tables

AugustusSwapper_Bought_event

Token swap completion events emitted by ParaSwap’s AugustusSwapper contract recording source and destination token addresses, amounts exchanged, initiator, beneficiary, and referrer. Used for tracking DEX aggregator trade execution and referral attribution.

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_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_referrer`	`STRING`	Address that referred the user to the protocol or facilitated the transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_referrer	in_srcToken	block_number	in_destToken	in_initiator	in_srcAmount	in_beneficiary	block_timestamp	transaction_hash	in_receivedAmount
0xf90e98f3d8dce44632e5020abf2e122e0f99dfab	false	77	mooni	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	11890374	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	0xc26cf1179fb5078ac4ff3f2c1d08de0655cb9106	1111000000	0xc26cf1179fb5078ac4ff3f2c1d08de0655cb9106	2021-02-19T23:31:41.000Z	0xa56eb707ba3e589d7075e9f8399b4297d009ec4a441ed19cba818bb280755f2b	564761061733183300
0xf90e98f3d8dce44632e5020abf2e122e0f99dfab	false	202	mooni	0xbc396689893d065f41bc2c6ecbee5e0085233447	12016475	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	0x7aa1d4620d05479a17aa94c97f937b87c75ad239	4949000000000000000	0x7aa1d4620d05479a17aa94c97f937b87c75ad239	2021-03-11T09:29:47.000Z	0xa0b5c955ca6c707e0931293e6cc7aa065e34c2cd9b5aa8e868a1c526d164cd95	18597675749207064
0xf90e98f3d8dce44632e5020abf2e122e0f99dfab	false	236	artis	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	11908947	0x00a8b738e453ffd858a7edf03bccfe20412f0eb0	0xb4aada74f8ceb1bb9ae14ad934180b67e718c8f1	180917444471533953	0xb4aada74f8ceb1bb9ae14ad934180b67e718c8f1	2021-02-22T20:16:56.000Z	0x111d477065871ae3fbf376f8a96cefc77e1f5077db9b4823583f6c0bccaf49d4	400000000000000000000

Example Query

Query with partition filter

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

AugustusSwapper_Swapped_event

Token swap execution events emitted by ParaSwap’s AugustusSwapper contract. Contains source and destination token addresses, swap amounts (sent and received versus expected), initiator and beneficiary addresses, and referrer identifier for tracking swap origins across DEX aggregation routes.

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_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.
`in_referrer`	`STRING`	Address that referred the user to the protocol or facilitated the transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_referrer	in_srcToken	block_number	in_destToken	in_initiator	in_srcAmount	in_beneficiary	block_timestamp	transaction_hash	in_expectedAmount	in_receivedAmount
0xf90e98f3d8dce44632e5020abf2e122e0f99dfab	false	195	paraswap.io	0xdac17f958d2ee523a2206206994597c13d831ec7	11725368	0xae7ab96520de3a18e5e111b5eaab095312d7fe84	0x3b4512e84017ec2dbc24e97006b47318807e1d3f	578816361	0x3b4512e84017ec2dbc24e97006b47318807e1d3f	2021-01-25T14:12:40.000Z	0xc1ce9d4a1dbdcc63e153147483d3164d26d3a63ee5824e6f9b9b03a3ef859097	391302565543326100	391320211202027007
0xf90e98f3d8dce44632e5020abf2e122e0f99dfab	false	84	paraswap.io	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	11721731	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	0x3b4512e84017ec2dbc24e97006b47318807e1d3f	300000000	0x3b4512e84017ec2dbc24e97006b47318807e1d3f	2021-01-25T01:03:24.000Z	0x564afccb133971abf0e60b4c7e3dfa99baed0f7b62f63b386f3de6296faefa98	206206544462248130	206206544462248113
0xf90e98f3d8dce44632e5020abf2e122e0f99dfab	false	98	paraswap.io	0x0000000000004946c0e9f43f4dee607b0ef1fa1c	11935918	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	0xda76eb73f18dce71750ca3a9d918b2beb7751e9d	140	0xda76eb73f18dce71750ca3a9d918b2beb7751e9d	2021-02-26T23:42:11.000Z	0xb02d5a2dbbfa3e5c2b3be6eb84387841cf304b8c118021bb306e16a3f6326bdf	318584967421282200	318584967421282201

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AugustusSwapper_Bought_event

AugustusSwapper_Swapped_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AugustusSwapper_Bought_event

​AugustusSwapper_Swapped_event

Tables

AugustusSwapper_Bought_event

AugustusSwapper_Swapped_event