paraswap_v5_arbitrum

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	0xe8ce20126e3448a2aaf32213c4a518ad	false	14	0xbbd9f90699c1fa0d7a65870d241dd1f1217c96eb	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	33993271	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	0x32fdc26affa1eb331263bcdd59f2e46ecbcc2e24	19354452	452312848583266388373324160190187140051835877600158453279131187530910695424	0x32fdc26affa1eb331263bcdd59f2e46ecbcc2e24	2022-10-30T21:24:10.000Z	0x96900b5f5513ff07ad667a18536af3b93f5de2e418c0b078a4514f7cec34ce29	19354732	4000000000
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x6a60b0fbe1d543d7a5f9b223e5695c4d	false	10	0xe4d12a78a24f63f856b7192beaacc9875d387fec	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	33911972	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	0x2806c31cca13d68645811bcae45c29945b8ddd6c	629966279890157	452312848583266388373324160190187140051835877600158453279131187530910711808	0x2806c31cca13d68645811bcae45c29945b8ddd6c	2022-10-30T14:33:04.000Z	0x3eb46bc48aa6639befcdcf1748f3cfa31fa83a269441b5ad33f25caa84e25ead	629966279890157	1000000
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x8da0d83a222446d7a822805816cbeb5c	false	21	0xbbd9f90699c1fa0d7a65870d241dd1f1217c96eb	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	33974784	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	0x32fdc26affa1eb331263bcdd59f2e46ecbcc2e24	6304977189281196	452312848583266388373324160190187140051835877600158453279131187530910695424	0x32fdc26affa1eb331263bcdd59f2e46ecbcc2e24	2022-10-30T19:30:54.000Z	0xccf3cda0dd63de10527c4ab19aa67eda09ddccd576b09b01c252c99e25232670	6304977189281196	10000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_arbitrum.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_kind	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	4	0x66eee5e534fe4ca0aa4b6e3757fc0a5d	false	10	0x08a3c2a819e3de7aca384c798269b3ce1cd0e437	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	210602587	0x040d1edc9569d4bab2d15287dc5a4f10f56a56b8	0x57e6b2841d2dc914391fd1fc24c44615dc536413	12000000000000000	452312848583266388373324160190187140051835877600158453279131187530910864264	0x57e6b2841d2dc914391fd1fc24c44615dc536413	2024-05-12T20:06:16.000Z	0xd955fd9e7fb9905e270b1a372afd4a8204570e9dbe29bcd1cfce06d015ceeaf9	10351509401341644425	10351509401341644425
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0	0x038045a0760a4caaaa9ab6d29bd13df3	false	5	0x0000000000000000000000000000000000000000	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	210515021	0x088cd8f5ef3652623c22d48b1605dcfe860cd704	0xe05dd51e4eb5636f4f0e8e7fbe82ea31a2ecef16	2000000000000000	452312848583266388373324160190187140051835877600158453279131187530910679040	0xe05dd51e4eb5636f4f0e8e7fbe82ea31a2ecef16	2024-05-12T13:58:15.000Z	0x800276376a4b3b8146a198ee0588545eaecf6e29e7945f17e6d3cd7fb6c62675	11334501053309374944	11334501053309374944
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0	0xec12bb245e1a46408e0995ca9c9c8906	false	7	0x0000000000000000000000000000000000000000	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	210557399	0x088cd8f5ef3652623c22d48b1605dcfe860cd704	0xb80d90fcf2ed0e4febe02d2a209109bf1f62df95	85517066530242016	452312848583266388373324160190187140051835877600158453279131187530910679040	0x06435b9bab75b85baaaa75b86b25dcaae2319610	2024-05-12T16:56:42.000Z	0xe26ccd68e99517835d737a9bb07a7d5e1e019b71443144edb80560f08309aafb	420422593925687406742	419109276615934826965

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_arbitrum.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	0x8b878810be164c27a3783773898d32bc	false	6	0xe4d12a78a24f63f856b7192beaacc9875d387fec	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	49364547	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	0xf2185d1a719d54357fe86b6f652e46c8dc118f0a	1100000000000000000	452312848583266388373324160190187140051835877600158453279131187530910679040	0xf2185d1a719d54357fe86b6f652e46c8dc118f0a	2022-12-28T08:53:35.000Z	0x3d13078d92018ee3030e5c8e3ada16f0fc843586f2788258cf572b57459f1859	920520633450378	920520633450378
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x6a2a362936284d5ea97eef4c65c4f251	false	11	0x0000000000000000696e737461646170702e696f	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	49483279	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	0x4d9f9c26ac3b391bd79b62ecac75751eb172655f	42280000000000000	452312848583266388373324160190187140051835877600158453279131187530910679040	0x4d9f9c26ac3b391bd79b62ecac75751eb172655f	2022-12-28T21:50:57.000Z	0xbdbd9aec8234d3dc73d4170f341e92ffb31b285dddadea2de3b470ed32a5b99a	50209460	49917487
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x606ea8a1c6b34bec8fae3b3b9f6c92fc	false	7	0xe4d12a78a24f63f856b7192beaacc9875d387fec	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	49293762	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	0x4486c00c4e1a8c643f73560d534e2bea756c8481	101273996	452312848583266388373324160190187140051835877600158453279131187530910679040	0x4486c00c4e1a8c643f73560d534e2bea756c8481	2022-12-28T00:01:01.000Z	0x16c97d5bafff657a417101389c6eb81f8f465a177b0664a88d5a7ff67064b854	101270310	101270310

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

​Tables

​AugustusSwapper_BoughtV3_event

​AugustusSwapper_SwappedDirect_event

​AugustusSwapper_SwappedV3_event

Tables

AugustusSwapper_BoughtV3_event

AugustusSwapper_SwappedDirect_event

AugustusSwapper_SwappedV3_event