paraswap_v5_avalanche

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	0xb77edd220cd24af29a57892e18c0d9a3	false	12	0x00000000000000000070617261737761702e696f	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	16307605	0xc7b5d72c836e718cda8888eaf03707faef675079	0x5596d991bf7753f0f14e1c5b59abbea626725401	509525055169721203	452312848583266388373324160190187140051835877600158453279131187530910711808	0x5596d991bf7753f0f14e1c5b59abbea626725401	2022-06-21T02:27:41.000Z	0x894c0376d866b2db80437c207019792175ec8b8ccb57ab45d062887c9da87778	509525055169721203	2902000000000000000000
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0xbcfeeb8fdf5f4714bd1b5e3d83fb0c48	false	33	0x0000000000000000000000000000000061617665	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	16345042	0xd586e7f844cea2f87f50152665bcbc2c279d8d70	0x8a743090e9759e758d15a4cfd18408fb6332c625	184040861705239522	452312848583266388373324160190187140051835877600158453279131187530910711808	0x8a743090e9759e758d15a4cfd18408fb6332c625	2022-06-21T23:18:28.000Z	0x121c027b4bf10b3de0bd9ff7b6d6c5f808511fa532e7796b5d3a61949bce1a45	184378547799307092	207946615006029685222
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0xfdcb1dac26904b63a9611886b45d81c9	false	44	0x0000000000000000000000000000000061617665	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	16320503	0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7	0x8a743090e9759e758d15a4cfd18408fb6332c625	218397458787189388	452312848583266388373324160190187140051835877600158453279131187530910711808	0x8a743090e9759e758d15a4cfd18408fb6332c625	2022-06-21T09:40:59.000Z	0xe6a71a1eb9f0d5a17fb699e8cc9bd1a133943030a64e1cd564e96f9c8da20bad	218328979338545626	253000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_avalanche.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	0x93cd65c029c94188bb2e3190547a02ff	false	5	0x0000000000000000000000000000000000000000	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	41198015	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	0x18b191cc6786b581763002580377d408903916ee	36133604	452312848583266388373324160190187140051835877600158453279131187530910679040	0x18b191cc6786b581763002580377d408903916ee	2024-02-03T13:21:27.000Z	0x85bcbdb8e8a96803294bea1b127459c85bc68adeeb90e1f169619049a128b447	1013323334676868186	1013323334676868186
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x434054ed755b4945b49933c8d45c4c7a	false	6	0x0000000000000000000000000000000000000000	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	41196185	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	0x22430c3556a3d7a90183dc89c4402f80931c152c	1000000000000000000	452312848583266388373324160190187140051835877600158453279131187530910679040	0x22430c3556a3d7a90183dc89c4402f80931c152c	2024-02-03T12:19:11.000Z	0x70fe3364fdc840afac1d9b71df59b25b1d9d91ccd1b99c58a67e5f382b094555	35721295	35718324
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x7c7bc567539744d1bea979125a010dff	false	14	0x0000000000000000000000000000000000000000	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	41183075	0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7	0x26b5810fa86db4bde2987afa5f2508c0f7ee3876	32281880	452312848583266388373324160190187140051835877600158453279131187530910679040	0x26b5810fa86db4bde2987afa5f2508c0f7ee3876	2024-02-03T04:50:53.000Z	0x4e7ea0a31df96657bf3766439ac5d7cf26d2d9176ad967dc1cae100d944d503d	32304231	32305174

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_avalanche.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	0x2143731e05a04a478ecf80b0522c8274	false	9	0x0000000000000000000000000000000000000000	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	19004505	0x027dbca046ca156de9622cd1e2d907d375e53aa7	0x7c2704b9f93383e7fed5097d433096dca4bff1cf	50000000	452312848583266388373324160190187140051835877600158453279131187530910679040	0x7c2704b9f93383e7fed5097d433096dca4bff1cf	2022-08-23T06:07:54.000Z	0x8fb9feab8a6dbbabb322e8b5399343e7f05a3261f69a833ecb6fc710f99b65df	49764992988	49764992988
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x0dca9d1dd3cc44e6ac9a3ef19c30e8a4	false	10	0x0000000000000000000000000000000000000000	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	19006379	0x111111111111ed1d73f860f57b2798b683f2d325	0x2749127dd6ada8a36826d888a6d63dd0008684ab	180730000000000000000	452312848583266388373324160190187140051835877600158453279131187530910679040	0x2749127dd6ada8a36826d888a6d63dd0008684ab	2022-08-23T07:10:45.000Z	0xd4b74eb9edebe2b2e2854ef659ca28529e4954f9e376f80c7709830d91a81970	4056341603866910703650	4052800678377656278105
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x86d4eda1927242538c1e940be10df1c7	false	13	0x0000000000000000000000000000000000000000	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	19017790	0x111111111111ed1d73f860f57b2798b683f2d325	0x2749127dd6ada8a36826d888a6d63dd0008684ab	438760000000000000000	452312848583266388373324160190187140051835877600158453279131187530910679040	0x2749127dd6ada8a36826d888a6d63dd0008684ab	2022-08-23T13:34:50.000Z	0x8ba3447e875657a86af0f52a3e8bdd69cabd32afe719a51f8d94f404f0a365e6	10100750835071573174268	10095024950429155309830

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_avalanche.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	0x75eac6fbe5a245e5af20fbafda7ed919	false	23	0x00000000000000000070617261737761702e696f	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	16015607	0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664	0x0342bf051724c2697362a3b947e170b4bea63299	2998112149746330378	452312848583266388373324160190187140051835877600158453279131187530910679040	0x0342bf051724c2697362a3b947e170b4bea63299	2022-06-14T09:29:04.000Z	0x953d0eadbf8755d803983936459e6b8c767c21c957120a57b6b5fcb9778a4e86	50000000
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x5669d3dd41d847859c1cd629389088c9	false	10	0x00000000000000000070617261737761702e696f	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	16028599	0xc55036b5348cfb45a932481744645985010d3a44	0x18c0c36c6e3fa02bbb65e84eefe1cc29564e302b	2991944	452312848583266388373324160190187140051835877600158453279131187530910679040	0x18c0c36c6e3fa02bbb65e84eefe1cc29564e302b	2022-06-14T16:35:35.000Z	0x106e67072ec523c9fea742ce9f6879afcdedbebc03086b95df94d2ebb2bcf466	10000000000000000
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0xc970911ca4094491ae98ba52957e0647	false	17	0x00000000000000000070617261737761702e696f	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	16022633	0xc55036b5348cfb45a932481744645985010d3a44	0x18c0c36c6e3fa02bbb65e84eefe1cc29564e302b	2842421	452312848583266388373324160190187140051835877600158453279131187530910679040	0x18c0c36c6e3fa02bbb65e84eefe1cc29564e302b	2022-06-14T13:20:16.000Z	0x559be13528d8c5fb613d8e545984413144d9ec9447c091551b061ea2b0782fbc	10000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_avalanche.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	0xb9879960aaef11ecb100c79e1005f65e	false	9	0x00000000000000000070617261737761702e696f	0x060556209e507d30f2167a101bfc6d256ed2f3e1	12489233	0x22d4002028f537599be9f666d1c4fa138522f9c8	0x3204be573c79b0b194e092cf83aeac827339c826	500000000000000000000	452312848583266388373324160190187140051835877600158453279131187530910679040	0x3204be573c79b0b194e092cf83aeac827339c826	2022-03-23T21:25:17.000Z	0xd230b69d1aa378ea187289d94d7cd20d495046e841522f9ab06581c52e20fcb4	486014953829286560327	486015208985404047471
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x2fd57430aaea11eca4a77341e018f776	false	9	0x00000000000000000070617261737761702e696f	0x060556209e507d30f2167a101bfc6d256ed2f3e1	12488075	0x22d4002028f537599be9f666d1c4fa138522f9c8	0x3204be573c79b0b194e092cf83aeac827339c826	500000000000000000000	452312848583266388373324160190187140051835877600158453279131187530910679040	0x3204be573c79b0b194e092cf83aeac827339c826	2022-03-23T20:45:39.000Z	0x6792898506c41b24bb9e15c89138f9234ddfe69a58cc63d6183d914f574d76a6	482898643381505495711	482898890108922251334
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x9296a830aaf111ec851b8d4e754d6aed	false	9	0x00000000000000000070617261737761702e696f	0x060556209e507d30f2167a101bfc6d256ed2f3e1	12489629	0x22d4002028f537599be9f666d1c4fa138522f9c8	0x3204be573c79b0b194e092cf83aeac827339c826	393629149499765600103	452312848583266388373324160190187140051835877600158453279131187530910679040	0x3204be573c79b0b194e092cf83aeac827339c826	2022-03-23T21:38:46.000Z	0x3d12b270b047c6172eee7d4737443a6d55e2960b3f0e675e995c6174041795c4	384862719994148953031	384862784575330739984

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_avalanche.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	0xdfd387d027a211ec9dbe1914eb0912b9	false	40	0x130966628846bfd36ff31a822705796e8cb8c18d	5342168	0x1f1e7c893855525b303f99bdf5c3c05be09ca251	0xedc8501c9f4173e2a76bff49c0b571f14903a7e7	751978419697058587534	0xedc8501c9f4173e2a76bff49c0b571f14903a7e7	2021-10-07T19:15:12.000Z	0x395db1608d68d6e952ecb47137b5476684903f416672c3f5d69b13d6b9c6341f	250000000000000000000
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0xc83be910274c11ecaa00b96e7267ae44	false	12	0x1f1e7c893855525b303f99bdf5c3c05be09ca251	5323923	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	0xd81ed022bbfe903f3e1bd75b7242a4ccebb3d6cd	9251191106398781560078	0xd81ed022bbfe903f3e1bd75b7242a4ccebb3d6cd	2021-10-07T08:58:52.000Z	0xd4d055d4f9b31cd89dee8c10c3663f19c52f650ca6a2f8664030f475c7063efd	6600000000000000000
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0xd0fa9bb027c811eca4498f79fddd54e0	false	28	0x21c5402c3b7d40c89cc472c9df5dd7e51bbab1b1	5350199	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	0xd9323babc3fe9cb475815aa1bd2e5aa78dd4cdab	130613206385172850397	0xd9323babc3fe9cb475815aa1bd2e5aa78dd4cdab	2021-10-07T23:46:46.000Z	0x09aabb0c6702d71178ef62f92e7766307e0101d09259c64087b16d0763b67834	1000000000000000000

Example Query

Query with partition filter

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

AugustusSwapperIParaswap_Swapped_event

Swap execution events emitted by the ParaSwap AugustusSwapper contract. Records source and destination token addresses, amounts sent and received, initiator, beneficiary, and unique swap identifier for DEX aggregator transaction tracking.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_uuid`	`STRING`	Unique identifier for the swap operation. 32-character hex string without 0x prefix.
`in_initiator`	`STRING`	Address of the account that initiated the flash loan operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_beneficiary`	`STRING`	Address that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_srcToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_destToken`	`STRING`	Contract address of the destination token received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_srcAmount`	`STRING`	Amount of source tokens sent by the initiator in the swap operation. String-encoded integer representing token units in the source token’s smallest denomination.
`in_receivedAmount`	`STRING`	Actual amount of destination tokens received by the beneficiary in the swap or withdrawal operation. String-encoded integer representing token units in the destination token’s smallest denomination.
`in_expectedAmount`	`STRING`	Expected amount of destination tokens for the swap operation. String-encoded integer representing token units in the destination token’s smallest denomination.

Sample Data

address	in_uuid	removed	log_index	in_srcToken	block_number	in_destToken	in_initiator	in_srcAmount	in_beneficiary	block_timestamp	transaction_hash	in_expectedAmount	in_receivedAmount
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x5735db206e0211ecb9406576fb9033b7	false	26	0x01c2086facfd7aa38f69a6bd8c91bef3bb5adfca	9160358	0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664	0x9718b714eb5fb390e73ad4972674837932e86e42	113214638284905853333679	0x9718b714eb5fb390e73ad4972674837932e86e42	2022-01-05T08:34:55.000Z	0xd90d3e493a547868cb4661cb594045e5023adc82010ff1b899accd61efabb648	1985708125	1985713079
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0xcb0866306e7f11ec92dd97519010001a	false	19	0x026187bdbc6b751003517bcb30ac7817d5b766f8	9187057	0xc7198437980c041c805a1edcba50c1ce5db95118	0x0d4b70dd05e02a18335ae3308b51011d491f758b	2071595527507611342371	0x0d4b70dd05e02a18335ae3308b51011d491f758b	2022-01-05T23:32:53.000Z	0xfd66b51ee704ce927955b20415f5177708e9ca88a60e06a20abee70ac649708e	1992059301	1992061164
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x4aa904406e5c11ec80a6b5c72c15ad14	false	18	0x027dbca046ca156de9622cd1e2d907d375e53aa7	9179349	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	0x69bec9c8fb9617f9325bfa7b464ea09c41d244b7	6350657824558	0x69bec9c8fb9617f9325bfa7b464ea09c41d244b7	2022-01-05T19:18:52.000Z	0x0b0340435be24875947aeecd36ce4945769aabfd6030a3daf90be23d0a38a399	48776691584864494300	48776692763047837548

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AugustusSwapper_BoughtV3_event

AugustusSwapper_SwappedDirect_event

AugustusSwapper_SwappedV3_event

AugustusSwapper2_Bought2_event

AugustusSwapper2_Swapped2_event

AugustusSwapperIParaswap_Bought_event

AugustusSwapperIParaswap_Swapped_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AugustusSwapper_BoughtV3_event

​AugustusSwapper_SwappedDirect_event

​AugustusSwapper_SwappedV3_event

​AugustusSwapper2_Bought2_event

​AugustusSwapper2_Swapped2_event

​AugustusSwapperIParaswap_Bought_event

​AugustusSwapperIParaswap_Swapped_event

Tables

AugustusSwapper_BoughtV3_event

AugustusSwapper_SwappedDirect_event

AugustusSwapper_SwappedV3_event

AugustusSwapper2_Bought2_event

AugustusSwapper2_Swapped2_event

AugustusSwapperIParaswap_Bought_event

AugustusSwapperIParaswap_Swapped_event