paraswap_v4_polygon

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
0x90249ed4d69d70e709ffcd8bee2c5a566f65dade	false	74	octobot	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	19058927	0x172370d5cd63279efa6d502dab29171933a610af	0x4e40c4c52c3e55c4a9c2ad3348910bf6d521a41f	239974167	0x4e40c4c52c3e55c4a9c2ad3348910bf6d521a41f	2021-09-13T11:32:28.000Z	0x84c00de78f57b159e32f5615dd256f8e9bcb730b0c2ed482f6502ff241823a64	112000000000000000000
0x90249ed4d69d70e709ffcd8bee2c5a566f65dade	false	197	octobot	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	19063736	0x7ceb23fd6bc0add59e62ac25578270cff1b9f619	0xda587912adf16855e6b69f9dcb3a0f661164a909	511424428	0xda587912adf16855e6b69f9dcb3a0f661164a909	2021-09-13T14:46:19.000Z	0x698d198ef4ff12b158acc0b9d5c29356c0c1071ae64a9b2fc976b720fac1509b	160000000000000000
0x90249ed4d69d70e709ffcd8bee2c5a566f65dade	false	159	octobot	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	19063222	0x7ceb23fd6bc0add59e62ac25578270cff1b9f619	0xda587912adf16855e6b69f9dcb3a0f661164a909	506323518	0xda587912adf16855e6b69f9dcb3a0f661164a909	2021-09-13T14:26:31.000Z	0xb28a7669790f21f1df01261057fb6e662e7fe0ccd8467bacec652fd86a71c1ed	160000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v4_polygon.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
0x90249ed4d69d70e709ffcd8bee2c5a566f65dade	false	183	stakedao	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	24808089	0x6863bd30c9e313b264657b107352ba246f8af8e0	0x9fd31424cfceab50218906bc1b3d87fe7778ca61	1213668169	0x9fd31424cfceab50218906bc1b3d87fe7778ca61	2022-02-11T09:16:59.000Z	0x4f68c49224931c85f4f1a695bea5a35ad24ebaa5b209bc352f65d366cef1c914	268866787668094501313	267409071713542990502
0x90249ed4d69d70e709ffcd8bee2c5a566f65dade	false	121	stakedao	0xc2132d05d31c914a87c6611c10748aeb04b58e8f	24811699	0x6863bd30c9e313b264657b107352ba246f8af8e0	0x9fd31424cfceab50218906bc1b3d87fe7778ca61	179539615	0x9fd31424cfceab50218906bc1b3d87fe7778ca61	2022-02-11T11:50:34.000Z	0x96786c1bb1d568652c9123cdb9ddd55e441640bbec70b9804bc99cad5ce524a9	39611624796114670935	39658549831108053145
0x90249ed4d69d70e709ffcd8bee2c5a566f65dade	false	151	stakedao	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	24826138	0x6863bd30c9e313b264657b107352ba246f8af8e0	0xadd975af19c3851688ee6e53fdab3ed659c6c530	95000000000000000000	0xadd975af19c3851688ee6e53fdab3ed659c6c530	2022-02-11T20:31:44.000Z	0x4c42a752e1d99c6c8a4dd44e951f84e612d13b26ddbcc31e6c3418f10a54df5b	38865091918784721168	38865095070040193792

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v4_polygon.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