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
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
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 | 0x3bfa9b03bd964f33a7f82b4dca896910 | false | 6 | 0x08a3c2a819e3de7aca384c798269b3ce1cd0e437 | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 74519956 | 0x4200000000000000000000000000000000000042 | 0xba6de53ecca06c7b41cbbfd8d59a62f7acc5a5d4 | 3219288859042089 | 452312848583266388373324160190187140051835877600158453279131187530910695424 | 0xba6de53ecca06c7b41cbbfd8d59a62f7acc5a5d4 | 2023-02-15T16:47:15.000Z | 0xbece504c0f9b87c27145803f342122ed8c21108e9d4f7788b39947abb27174d7 | 3219288859042089 | 2000000000000000000 |
| 0xdef171fe48cf0115b1d80b88dc8eab59176fee57 | 0xdc3f36ac9c8d4086bd7b2b94e1c0a3df | false | 7 | 0x1a00e1e311009e56e3b0b9ed6f86f5ce128a1c01 | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 74440612 | 0x4200000000000000000000000000000000000042 | 0xe7294495206c1f5223d7f0c59b004ce971760541 | 1533769355574410 | 452312848583266388373324160190187140051835877600158453279131187530910711808 | 0xe7294495206c1f5223d7f0c59b004ce971760541 | 2023-02-15T08:50:41.000Z | 0xb259d7f454086f6cf18c8a54a8e8e60e8d9764662450a75f4c1ae984d954a652 | 1534002397326573 | 1000000000000000000 |
| 0xdef171fe48cf0115b1d80b88dc8eab59176fee57 | 0x68f54da9caba451c8fc1b43debdc20a5 | false | 10 | 0x9abf798f5314bfd793a9e57a654bed35af4a1d60 | 0x4200000000000000000000000000000000000006 | 74405934 | 0x7f5c764cbc14f9669b88837ca1490cca17c31607 | 0x66d340eb9d3dce0f78e813e2f991b7ce54a1a28c | 3850756910124978820 | 452312848583266388373324160190187140051835877600158453279131187530910695424 | 0x66d340eb9d3dce0f78e813e2f991b7ce54a1a28c | 2023-02-15T03:57:22.000Z | 0x72b32af17cc96f6e01f04da652c67d1d8e9c89cd71f9b886fa2ce38f2da9df49 | 3860394585090348800 | 5958370506 |
Example Query
Example Query
Query with partition filter
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
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
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 | 0x71a32f49bddf4e3490a2ba78dc1a2c9a | false | 67 | 0x0000000000000000000000000000000000000000 | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 119790672 | 0x0994206dfe8de6ec6920ff4d779b0d950605fb53 | 0x0fd66c3121d1d85972c50fdd7679237359128bca | 39000000000000000 | 452312848583266388373324160190187140051835877600158453279131187530910679040 | 0x0fd66c3121d1d85972c50fdd7679237359128bca | 2024-05-08T14:55:21.000Z | 0x0133e303ccd755d8fba0fa966c711813a595191544e09748fe16e963cc8d457e | 280492117925350595610 | 280492117925350595610 |
| 0xdef171fe48cf0115b1d80b88dc8eab59176fee57 | 0 | 0x132a3ebc525343308c090283b9d22315 | false | 149 | 0x0000000000000000000000000000000000000000 | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 119790832 | 0x0994206dfe8de6ec6920ff4d779b0d950605fb53 | 0x0fd66c3121d1d85972c50fdd7679237359128bca | 39000000000000000 | 452312848583266388373324160190187140051835877600158453279131187530910679040 | 0x0fd66c3121d1d85972c50fdd7679237359128bca | 2024-05-08T15:00:41.000Z | 0x1abd2120ab623a4bf75e40b2794dc7a7357cd5a68ff4d1d408e9f0132285f2fb | 280143848710909079100 | 280143848710909079100 |
| 0xdef171fe48cf0115b1d80b88dc8eab59176fee57 | 0 | 0xb5c02f0fad884d9bb366a2f0ee9ec1fa | false | 19 | 0x0000000000000000000000000000000000000000 | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 119790859 | 0x0994206dfe8de6ec6920ff4d779b0d950605fb53 | 0x0fd66c3121d1d85972c50fdd7679237359128bca | 39000000000000000 | 452312848583266388373324160190187140051835877600158453279131187530910679040 | 0x0fd66c3121d1d85972c50fdd7679237359128bca | 2024-05-08T15:01:35.000Z | 0x542c34e5374eceb6c5dd257c4ea0e32ba9296f2d55d8c01ec12f5007d1a05ba7 | 280504585231273107756 | 280504585231273107756 |
Example Query
Example Query
Query with partition filter
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
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
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 | 0xdde8b3f8680a49dcb246016b886b65ec | false | 5 | 0x0000000000000000000000000000000000000000 | 0x0b2c639c533813f4aa9d7837caf62653d097ff85 | 111104592 | 0x7f5c764cbc14f9669b88837ca1490cca17c31607 | 0x0422ce9671929182528f7c437545820308ec2be9 | 5600671140 | 452312848583266388373324160190187140051835877600158453279131187530910679040 | 0x0422ce9671929182528f7c437545820308ec2be9 | 2023-10-20T13:19:21.000Z | 0xd01cf4616f53ebe201d77762944381ff8033ee12c95cde5be5d2099f6bd76fa7 | 5599831251 | 5599831251 |
| 0xdef171fe48cf0115b1d80b88dc8eab59176fee57 | 0x8ff37f71c6ed499ebb5461f467cf925e | false | 32 | 0x08a3c2a819e3de7aca384c798269b3ce1cd0e437 | 0x0b2c639c533813f4aa9d7837caf62653d097ff85 | 111101693 | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 0x1233961119095b0aa2e413401a21c007e98360be | 468108380 | 452312848583266388373324160190187140051835877600158453279131187530910864264 | 0x1233961119095b0aa2e413401a21c007e98360be | 2023-10-20T11:42:43.000Z | 0x33ebdbddb42c70ede8205c16724352c9f64ed27c14447c4ab07a26416db3da5d | 289598556252317033 | 289662642493108518 |
| 0xdef171fe48cf0115b1d80b88dc8eab59176fee57 | 0x23f7cbe79a3b4e278993f7f74265d2fc | false | 27 | 0x0000000000000000000000000000000000000000 | 0x0b2c639c533813f4aa9d7837caf62653d097ff85 | 111085887 | 0x1e925de1c68ef83bd98ee3e130ef14a50309c01b | 0x5929cc4d10b6a1acc5bf5d221889f10251c628a1 | 55000000 | 452312848583266388373324160190187140051835877600158453279131187530910679040 | 0x5929cc4d10b6a1acc5bf5d221889f10251c628a1 | 2023-10-20T02:55:51.000Z | 0x4f89b095fd6fe11c8183ca61d3b50fa6d294e8f57f65aad0e63cc6cfee2af36b | 41289223262489418204 | 41289223262489419239 |
Example Query
Example Query
Query with partition filter
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
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
Sample Data
| address | removed | log_index | in__balance | block_number | in__claimant | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|
| 0xd57fd755f53666ce2d3ed8c862a8d06e38c21ce6 | false | 9 | 18523582965475400033 | 114267230 | 0xb728311c5557f82050cda1bbe98dff6595be969a | 2024-01-01T18:20:37.000Z | 0xcce85ede01a9fee5d1bb1046d0dcbed849c559c08ee9da0bf7b2b3a0c82a2340 |
| 0xd57fd755f53666ce2d3ed8c862a8d06e38c21ce6 | false | 22 | 162997122266176575621 | 114269932 | 0x8e100ca591bba6ce8b1d174f14312d3dbc066c3c | 2024-01-01T19:50:41.000Z | 0xedc9f8f309cfad302189976d0c1f993d0ca06974f3035e9cd97e35fdb660a0a1 |
| 0xd57fd755f53666ce2d3ed8c862a8d06e38c21ce6 | false | 7 | 193725005858463610819 | 114273127 | 0xb4d502361a3c6f823eeb9a99af09e110382206ee | 2024-01-01T21:37:11.000Z | 0xda5984cc8b249e863bd85f156f89845b97e9c80277a64bde718d65fce73b9cc7 |
Example Query
Example Query
Query with partition filter
sePSP1_RequestedUnlocking_event
Unlock requests from ParaSwap’s Safety Module staking contract (sePSP1) on Optimism, tracking when users initiate the withdrawal process for staked PSP tokens. Used to analyze staking behavior, liquidity exit patterns, and protocol participation metrics.Columns
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_id | STRING | Unique identifier for the position, record, or entity within the protocol. Numeric string representation. |
in_user | STRING | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_amount | STRING | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
Sample Data
Sample Data
| in_id | address | in_user | removed | in_amount | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0 | 0x8c934b7dbc782568d14ceabbeaedf37cb6348615 | 0x3e00aee52066ee270f8badf0b5bb41993f057321 | false | 197842861358993708566 | 6 | 114383136 | 2024-01-04T10:44:09.000Z | 0xbb19f4faaa076afd1283f8a0e5a111f428d44a3d56fe348a9bf17bc501048d85 |
| 0 | 0x8c934b7dbc782568d14ceabbeaedf37cb6348615 | 0xa622e0787dfc88b50b836e62b114d74fd866fdec | false | 250852635012964351984477 | 140 | 114366205 | 2024-01-04T01:19:47.000Z | 0xaad36996fe0230b8eea5bc9ababc3644faf091355ab5d3de3ece3638c61f7635 |
| 0 | 0x8c934b7dbc782568d14ceabbeaedf37cb6348615 | 0x9bdb2b0a575e210563c5487adae844eb7f5e5c3a | false | 332221890535601544632 | 10 | 116215056 | 2024-02-15T20:28:09.000Z | 0x8b1e9ea51b37e79aa6e31c67ab0021b2a9bf47006c095f47cb1374a4df020c1c |
Example Query
Example Query
Query with partition filter
sePSP2_RequestedUnlocking_event
Unlock request events from ParaSwap’s sePSP2 staking contract on Optimism, capturing when users initiate withdrawals of their staked PSP (ParaSwap token). Used for analyzing staking exit behavior and unlock timing patterns.Columns
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_id | STRING | Unique identifier for the position, record, or entity within the protocol. Numeric string representation. |
in_user | STRING | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_amount | STRING | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
Sample Data
Sample Data
| in_id | address | in_user | removed | in_amount | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0 | 0x26ee65874f5dbefa629eb103e7bbb2deaf4fb2c8 | 0x95b0cb330519db2bcaf74b90c1bde3d62f673718 | false | 262770293596187377598 | 2 | 115821316 | 2024-02-06T17:43:29.000Z | 0x94dd28f7c1dd636827d61b1ccf722479896756d6b9116e4e7769cf7a3595bb6c |
| 0 | 0x26ee65874f5dbefa629eb103e7bbb2deaf4fb2c8 | 0x4c45758bf15af0714e4cc44c4efd177e209c2890 | false | 9252930175387906434 | 52 | 115792424 | 2024-02-06T01:40:25.000Z | 0xa120c3a440f744a5f1d4d8c78fb21c1021d0892c5c4f14809618972e0b70eb87 |
| 0 | 0x26ee65874f5dbefa629eb103e7bbb2deaf4fb2c8 | 0xc29ffb23abae4d7950d7f1e008019caf513f5078 | false | 616664153147037410268 | 1 | 115818330 | 2024-02-06T16:03:57.000Z | 0x40fd57494abdac9b0b649ac0e7ec08e7976ba1540a81514f8a9130c47e848ef6 |
Example Query
Example Query
Query with partition filter