paraswap_v5_bsc

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	0xda4f4a7d72b94a2fb3726df9ff2ea589	false	65	0x08a3c2a819e3de7aca384c798269b3ce1cd0e437	0x2170ed0880ac9a755fd29b2688956bd959f933f8	30308635	0x55d398326f99059ff775485246999027b3197955	0x8c802022f7803b3b72588b0038b61e5f1b519fc9	134886826936746574	452312848583266388373324160190187140051835877600158453279131187530910864264	0x8c802022f7803b3b72588b0038b61e5f1b519fc9	2023-07-26T19:31:18.000Z	0x9432759ca20fb396846ead7b8796a14970e36ed6f9d75fcc9a7164ae6e407a38	134886878190594508	252000000000000000000
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x60f4fe6c4856421b8dce05889d2f0ee4	false	432	0x08a3c2a819e3de7aca384c798269b3ce1cd0e437	0x2170ed0880ac9a755fd29b2688956bd959f933f8	30296568	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	0x38389e1ca3b9ef7d21d2566d9b744d535f7cafaf	2568481539987744	452312848583266388373324160190187140051835877600158453279131187530910864264	0x38389e1ca3b9ef7d21d2566d9b744d535f7cafaf	2023-07-26T09:26:25.000Z	0x438663818b6d4488090f3fe0ff991353fd19407a397ad0238fd6e6b94f0db934	2568481539987745	20000000000000000
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x4139d3a5fce04f61a88537ca00967b44	false	193	0x08a3c2a819e3de7aca384c798269b3ce1cd0e437	0x55d398326f99059ff775485246999027b3197955	30304701	0x03ff0ff224f904be3118461335064bb48df47938	0xe86287707e5b9a1521e324953452c1bc105e2fe9	5944111472125603628	452312848583266388373324160190187140051835877600158453279131187530910864264	0xe86287707e5b9a1521e324953452c1bc105e2fe9	2023-07-26T16:14:17.000Z	0xff2f26ceb8b4df5751297209327a2fc69fa3e9c72c9f305a3c17951bd3ac596d	5944728344670784717	500000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_bsc.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	0	0x992d9663d5d24f9794401a3ac611a310	false	138	0x0000000000000000000000000000000000000000	0x55d398326f99059ff775485246999027b3197955	29668907	0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3	0x63381c9ecd68f774e7a2758168f4c551522dfc26	11110000000000000000	452312848583266388373324160190187140051835877600158453279131187530910679040	0x63381c9ecd68f774e7a2758168f4c551522dfc26	2023-07-04T12:50:05.000Z	0xc373b88d570bc94e2c0bb63eeb6b0033a2b34f5f3edb7a57b875655418f1a097	11110365152904969938	11110365152904969938
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0	0xdbbc63f52e2e4bbcbf90faa40c3cbec5	false	96	0x0000000000000000000000000000000000000000	0x55d398326f99059ff775485246999027b3197955	29668811	0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3	0x7b2e3fc7510d1a51b3bef735f985446589219354	123971932000000000000	452312848583266388373324160190187140051835877600158453279131187530910679040	0x7b2e3fc7510d1a51b3bef735f985446589219354	2023-07-04T12:45:16.000Z	0xf76fd5d8623e30062126567be70b7f9f980a6d581ba989fec0d6f40fd4ed761f	123976521881129561505	123976521881129561505
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	1	0xe0a439badc4f4917b597d26ac793729d	false	204	0x0000000000000000000000000000000000000000	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	29674079	0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3	0x89354c91839103275405465eff6a59dfa873c2e5	2500760242695627599459	452312848583266388373324160190187140051835877600158453279131187530910711808	0x89354c91839103275405465eff6a59dfa873c2e5	2023-07-04T17:09:19.000Z	0x305ae6809e47a78d21fd8e62a7190be5e1c251406090f3c3595cbe7c68350d7d	2500756169167954757629	2500000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_bsc.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	0x993691294faa4760b98bb0ccf0ab84af	false	214	0xe4d12a78a24f63f856b7192beaacc9875d387fec	0xe9e7cea3dedca5984780bafc599bd69add087d56	21238972	0xe580074a10360404af3abfe2d524d5806d993ea3	0x313e74f7755afbae4f90e02ca49f8f09ff934a37	1700221211054656585893	452312848583266388373324160190187140051835877600158453279131187530910679040	0x313e74f7755afbae4f90e02ca49f8f09ff934a37	2022-09-11T12:25:12.000Z	0x14abf37fc27029fdedfe5745bd9552dd63b970378a57e93e06967cb4e0889d0a	1040182288848820590665016	1040182288848820590665016
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0xc1dd331d213d4ca4a7eaaabf3b70bb27	false	198	0xe4d12a78a24f63f856b7192beaacc9875d387fec	0xe9e7cea3dedca5984780bafc599bd69add087d56	21226569	0xae98e63db1c4646bf5b40b29c664bc922f71bc65	0x313e74f7755afbae4f90e02ca49f8f09ff934a37	500000000000000000000	452312848583266388373324160190187140051835877600158453279131187530910679040	0x313e74f7755afbae4f90e02ca49f8f09ff934a37	2022-09-11T02:05:01.000Z	0x9a073aad6b77796086a2d60d6acc54adb83362dbe302e23b5f458f866243cad9	114831116320424855136141	114831116320424855136141
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0xb46884905d9844c495fc3febfc090681	false	18	0x8c208b7b5625d78deb49240ef28126cbe2738098	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	21229724	0xe4cc45bb5dbda06db6183e8bf016569f40497aa5	0x362fa9d0bca5d19f743db50738345ce2b40ec99f	21110000000000000	452312848583266388373324160190187140051835877600158453279131187530910679040	0x362fa9d0bca5d19f743db50738345ce2b40ec99f	2022-09-11T04:42:46.000Z	0x7c7655ffd659892dd0f3a829b2a79c04c2016ca5345eccf3da53da9e7f042055	2008301414097123637	2008301414097123637

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_bsc.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	0x1b5960ccce9044e8939d70e80c58d898	false	240	0x558247e365be655f9144e1a0140d793984372ef3	0x55d398326f99059ff775485246999027b3197955	18335158	0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3	0x62711effdd46e32d44d28c867a51c428f0522c5c	10009990892537241355	452312848583266388373324160190187140051835877600158453279131187530910679135	0x62711effdd46e32d44d28c867a51c428f0522c5c	2022-06-02T10:05:12.000Z	0xdb886f13f1454dc27ee7cae32be3f7d7701ce36d4c57773c9c61a1c3b19f456f	9992468450277637557
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0xca2f68fddb234e7fb8f6af19a5b01a62	false	93	0x00000000000000000070617261737761702e696f	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	18351677	0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3	0x62555aa2789cd8fa52356b314c4565616a3cb103	231418306078797004	452312848583266388373324160190187140051835877600158453279131187530910679040	0x62555aa2789cd8fa52356b314c4565616a3cb103	2022-06-02T23:58:57.000Z	0xac9c0b10db5d3d5d187dbc9a03d333f5a5cba41795877beb5092775d168fe618	71000000000000000000
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0xf0f13d18c86445b788bac14d25766c2a	false	355	0x00000000000000000070617261737761702e696f	0x55d398326f99059ff775485246999027b3197955	18340466	0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3	0x77619c02dd779619a506b167e997ac092f83057a	806285846082354742251	452312848583266388373324160190187140051835877600158453279131187530910679040	0x77619c02dd779619a506b167e997ac092f83057a	2022-06-02T14:31:52.000Z	0x1a3d4f6db5354456e984171c38e7671396d2672ceabdb86de1582cb21ce16ab3	800000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_bsc.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	0x9ad9d940d59e11ecbe76ef9429d2a6dd	false	72	0x00000000000000000070617261737761702e696f	0x55d398326f99059ff775485246999027b3197955	17871260	0x2170ed0880ac9a755fd29b2688956bd959f933f8	0x010e0d20b256620b6ab77729c8152112e0b78561	20185277839110505505857	452312848583266388373324160190187140051835877600158453279131187530910679040	0x010e0d20b256620b6ab77729c8152112e0b78561	2022-05-17T05:02:59.000Z	0x3d2d63aff3d32bdb6e3737a6c36bd1e14e5b691d31cc5b48b04c12d30bdbf259	9695191204193020778	9695191204193020778
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0xf03bfea0d5c511ecb48e5b12107aa6c1	false	277	0x00000000000000000070617261737761702e696f	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	17876770	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	0x036fb0243928b60e2016c68495bd2fe1a8f33fb2	150288518585664026	452312848583266388373324160190187140051835877600158453279131187530910679040	0x036fb0243928b60e2016c68495bd2fe1a8f33fb2	2022-05-17T09:44:45.000Z	0x5fe0c8277a45baaaad47c13bcf9da5e6c7976dae8e149759dc0887f267301a13	150288518585664026	150288518585664026
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x360659e0d60111ec9cfee911ebd7ec79	false	129	0x00000000000000000070617261737761702e696f	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	17885135	0x2170ed0880ac9a755fd29b2688956bd959f933f8	0x0429802d1bf8b60249500f3b6340f14a36b047a9	30381380000000000	452312848583266388373324160190187140051835877600158453279131187530910679040	0x0429802d1bf8b60249500f3b6340f14a36b047a9	2022-05-17T16:48:51.000Z	0xdb5becf8a0cc8d656554199b75d91ee1d26708c4151f62626b247594fa6be240	4453886302215225	4453886302215225

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_bsc.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	0x992438606d0311ecbbc2ff332f5a77d4	false	140	0x55d398326f99059ff775485246999027b3197955	14058536	0x3f670f65b9ce89b82e82121fd68c340ac22c08d6	0x5c7a3671471d9505808de6e78ba1d3bd7c5c800a	476338292133832335369	0x5c7a3671471d9505808de6e78ba1d3bd7c5c800a	2022-01-04T02:11:23.000Z	0x270f4eef1d26e301bbd2c04ea5b16f55e0e4545f57342b9131d7f1609f2904ef	10196198382064190000000
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x59a55a206d7611ecb10565144649c2aa	false	168	0x55d398326f99059ff775485246999027b3197955	14074932	0x3f670f65b9ce89b82e82121fd68c340ac22c08d6	0x5c7a3671471d9505808de6e78ba1d3bd7c5c800a	1199150730829565034310	0x5c7a3671471d9505808de6e78ba1d3bd7c5c800a	2022-01-04T15:52:46.000Z	0x10e49f8cc093fafc129c8bbbdd47a9a973d198e3908faac0f821dbb6c6175e06	22931361190084073000000
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0xf50836006d7511ecb10565144649c2aa	false	145	0x55d398326f99059ff775485246999027b3197955	14074876	0x3f670f65b9ce89b82e82121fd68c340ac22c08d6	0x5c7a3671471d9505808de6e78ba1d3bd7c5c800a	664324795274589048196	0x5c7a3671471d9505808de6e78ba1d3bd7c5c800a	2022-01-04T15:49:58.000Z	0x41d4136e069cfc0db9b4e491ec378e8a577c8e9a4cea37a5673711d3bf93b0e5	13387774720332201000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_bsc.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	0x70e74f8085cd11ec84c9edd6a9be01d1	false	1083	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	14964542	0x55d398326f99059ff775485246999027b3197955	0x000000004c354cf7211c30f7957a56572615768e	1000000000000000000	0x000000004c354cf7211c30f7957a56572615768e	2022-02-04T15:16:41.000Z	0x0ebcfc926408cef631769cd0d01440bca19fd02d1acebb44b93de307420c1c1d	379972935142018319270	380248790267415541588
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x6369d18085ef11ec98d6818ce9d9bfcd	false	316	0x55d398326f99059ff775485246999027b3197955	14969369	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	0x000000004c354cf7211c30f7957a56572615768e	380110862704716930429	0x000000004c354cf7211c30f7957a56572615768e	2022-02-04T19:19:43.000Z	0xdb3fd2cd44d05ef3ada1c526ced0950d431eed0aa40c684596904c809e99b5dd	968811623789394083	968876015705438357
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	0x5bc30c3085ef11ec90828bc50b715f48	false	214	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	14969365	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	0x000000004c354cf7211c30f7957a56572615768e	239012063107472567862	0x000000004c354cf7211c30f7957a56572615768e	2022-02-04T19:19:31.000Z	0x350b7ef089ab842152d26a72d0f5aabb27a3cba1056b0ee6f5c97685e42cf211	608860186374238302	608879449452060259

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v5_bsc.AugustusSwapperIParaswap_Swapped_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
0x8fdcdac765128f2a5cb2eb7ed8990b2b24cb66d7	false	411	22442824489933867981	29550848	0xaadf465695b80d5f8a1079b6646ba0bdbbaa4307	2023-06-30T10:09:10.000Z	0xb358ae3f5cfdef35ffc4bd4e52f4c307fe09efdcc48bd5637bdcff9e6be6f574
0x8fdcdac765128f2a5cb2eb7ed8990b2b24cb66d7	false	203	988412277474108759546	26074507	0x947c4efaf086821ed8f5d3980d466808f3fe4808	2023-03-01T01:47:17.000Z	0x15f769f4310669e9c2014a5b40840f676dceeb5766bd6ec2101e511daf766172
0x8fdcdac765128f2a5cb2eb7ed8990b2b24cb66d7	false	90	550565652840319059954	26084801	0xf4484efb942029b1535eb55d3858145bd6c2a2bc	2023-03-01T10:28:22.000Z	0x3f492c788aa5276c5dc9cc8f7bbf7936f16b5ca80bc951e2f791c008b4c0eb9a

Example Query

Query with partition filter

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

MerkleRedeem_Claimed_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

​MerkleRedeem_Claimed_event

Tables

AugustusSwapper_BoughtV3_event

AugustusSwapper_SwappedDirect_event

AugustusSwapper_SwappedV3_event

AugustusSwapper2_Bought2_event

AugustusSwapper2_Swapped2_event

AugustusSwapperIParaswap_Bought_event

AugustusSwapperIParaswap_Swapped_event

MerkleRedeem_Claimed_event