Skip to main content

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_uuidSTRINGUnique identifier for the swap operation. 32-character hex string without 0x prefix.
in_partnerSTRINGAddress of the partner or referral entity associated with the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_feePercentSTRINGFee percentage charged for the swap transaction. String-encoded 256-bit integer used in Paraswap protocol fee calculations.
in_initiatorSTRINGAddress of the account that initiated the flash loan operation. Hex-encoded, 0x-prefixed, 42-character string.
in_beneficiarySTRINGAddress that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_srcTokenSTRINGContract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
in_destTokenSTRINGContract address of the destination token received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
in_srcAmountSTRINGAmount 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_receivedAmountSTRINGActual 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_expectedAmountSTRINGExpected amount of destination tokens for the swap operation. String-encoded integer representing token units in the destination token’s smallest denomination.
addressin_uuidremovedlog_indexin_partnerin_srcTokenblock_numberin_destTokenin_initiatorin_srcAmountin_feePercentin_beneficiaryblock_timestamptransaction_hashin_expectedAmountin_receivedAmount
0xdef171fe48cf0115b1d80b88dc8eab59176fee570x3bfa9b03bd964f33a7f82b4dca896910false60x08a3c2a819e3de7aca384c798269b3ce1cd0e4370xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee745199560x42000000000000000000000000000000000000420xba6de53ecca06c7b41cbbfd8d59a62f7acc5a5d432192888590420894523128485832663883733241601901871400518358776001584532791311875309106954240xba6de53ecca06c7b41cbbfd8d59a62f7acc5a5d42023-02-15T16:47:15.000Z0xbece504c0f9b87c27145803f342122ed8c21108e9d4f7788b39947abb27174d732192888590420892000000000000000000
0xdef171fe48cf0115b1d80b88dc8eab59176fee570xdc3f36ac9c8d4086bd7b2b94e1c0a3dffalse70x1a00e1e311009e56e3b0b9ed6f86f5ce128a1c010xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee744406120x42000000000000000000000000000000000000420xe7294495206c1f5223d7f0c59b004ce97176054115337693555744104523128485832663883733241601901871400518358776001584532791311875309107118080xe7294495206c1f5223d7f0c59b004ce9717605412023-02-15T08:50:41.000Z0xb259d7f454086f6cf18c8a54a8e8e60e8d9764662450a75f4c1ae984d954a65215340023973265731000000000000000000
0xdef171fe48cf0115b1d80b88dc8eab59176fee570x68f54da9caba451c8fc1b43debdc20a5false100x9abf798f5314bfd793a9e57a654bed35af4a1d600x4200000000000000000000000000000000000006744059340x7f5c764cbc14f9669b88837ca1490cca17c316070x66d340eb9d3dce0f78e813e2f991b7ce54a1a28c38507569101249788204523128485832663883733241601901871400518358776001584532791311875309106954240x66d340eb9d3dce0f78e813e2f991b7ce54a1a28c2023-02-15T03:57:22.000Z0x72b32af17cc96f6e01f04da652c67d1d8e9c89cd71f9b886fa2ce38f2da9df4938603945850903488005958370506
Query with partition filter
SELECT *
FROM `tt-contracts.paraswap_v5_optimism.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_uuidSTRINGUnique identifier for the swap operation. 32-character hex string without 0x prefix.
in_partnerSTRINGAddress of the partner or referral entity associated with the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_feePercentSTRINGFee percentage charged for the swap transaction. String-encoded 256-bit integer used in Paraswap protocol fee calculations.
in_initiatorSTRINGAddress of the account that initiated the flash loan operation. Hex-encoded, 0x-prefixed, 42-character string.
in_kindINT64Swap 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_beneficiarySTRINGAddress that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_srcTokenSTRINGContract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
in_destTokenSTRINGContract address of the destination token received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
in_srcAmountSTRINGAmount 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_receivedAmountSTRINGActual 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_expectedAmountSTRINGExpected amount of destination tokens for the swap operation. String-encoded integer representing token units in the destination token’s smallest denomination.
addressin_kindin_uuidremovedlog_indexin_partnerin_srcTokenblock_numberin_destTokenin_initiatorin_srcAmountin_feePercentin_beneficiaryblock_timestamptransaction_hashin_expectedAmountin_receivedAmount
0xdef171fe48cf0115b1d80b88dc8eab59176fee5700x71a32f49bddf4e3490a2ba78dc1a2c9afalse670x00000000000000000000000000000000000000000xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee1197906720x0994206dfe8de6ec6920ff4d779b0d950605fb530x0fd66c3121d1d85972c50fdd7679237359128bca390000000000000004523128485832663883733241601901871400518358776001584532791311875309106790400x0fd66c3121d1d85972c50fdd7679237359128bca2024-05-08T14:55:21.000Z0x0133e303ccd755d8fba0fa966c711813a595191544e09748fe16e963cc8d457e280492117925350595610280492117925350595610
0xdef171fe48cf0115b1d80b88dc8eab59176fee5700x132a3ebc525343308c090283b9d22315false1490x00000000000000000000000000000000000000000xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee1197908320x0994206dfe8de6ec6920ff4d779b0d950605fb530x0fd66c3121d1d85972c50fdd7679237359128bca390000000000000004523128485832663883733241601901871400518358776001584532791311875309106790400x0fd66c3121d1d85972c50fdd7679237359128bca2024-05-08T15:00:41.000Z0x1abd2120ab623a4bf75e40b2794dc7a7357cd5a68ff4d1d408e9f0132285f2fb280143848710909079100280143848710909079100
0xdef171fe48cf0115b1d80b88dc8eab59176fee5700xb5c02f0fad884d9bb366a2f0ee9ec1fafalse190x00000000000000000000000000000000000000000xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee1197908590x0994206dfe8de6ec6920ff4d779b0d950605fb530x0fd66c3121d1d85972c50fdd7679237359128bca390000000000000004523128485832663883733241601901871400518358776001584532791311875309106790400x0fd66c3121d1d85972c50fdd7679237359128bca2024-05-08T15:01:35.000Z0x542c34e5374eceb6c5dd257c4ea0e32ba9296f2d55d8c01ec12f5007d1a05ba7280504585231273107756280504585231273107756
Query with partition filter
SELECT *
FROM `tt-contracts.paraswap_v5_optimism.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_uuidSTRINGUnique identifier for the swap operation. 32-character hex string without 0x prefix.
in_partnerSTRINGAddress of the partner or referral entity associated with the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_feePercentSTRINGFee percentage charged for the swap transaction. String-encoded 256-bit integer used in Paraswap protocol fee calculations.
in_initiatorSTRINGAddress of the account that initiated the flash loan operation. Hex-encoded, 0x-prefixed, 42-character string.
in_beneficiarySTRINGAddress that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_srcTokenSTRINGContract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
in_destTokenSTRINGContract address of the destination token received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
in_srcAmountSTRINGAmount 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_receivedAmountSTRINGActual 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_expectedAmountSTRINGExpected amount of destination tokens for the swap operation. String-encoded integer representing token units in the destination token’s smallest denomination.
addressin_uuidremovedlog_indexin_partnerin_srcTokenblock_numberin_destTokenin_initiatorin_srcAmountin_feePercentin_beneficiaryblock_timestamptransaction_hashin_expectedAmountin_receivedAmount
0xdef171fe48cf0115b1d80b88dc8eab59176fee570xdde8b3f8680a49dcb246016b886b65ecfalse50x00000000000000000000000000000000000000000x0b2c639c533813f4aa9d7837caf62653d097ff851111045920x7f5c764cbc14f9669b88837ca1490cca17c316070x0422ce9671929182528f7c437545820308ec2be956006711404523128485832663883733241601901871400518358776001584532791311875309106790400x0422ce9671929182528f7c437545820308ec2be92023-10-20T13:19:21.000Z0xd01cf4616f53ebe201d77762944381ff8033ee12c95cde5be5d2099f6bd76fa755998312515599831251
0xdef171fe48cf0115b1d80b88dc8eab59176fee570x8ff37f71c6ed499ebb5461f467cf925efalse320x08a3c2a819e3de7aca384c798269b3ce1cd0e4370x0b2c639c533813f4aa9d7837caf62653d097ff851111016930xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0x1233961119095b0aa2e413401a21c007e98360be4681083804523128485832663883733241601901871400518358776001584532791311875309108642640x1233961119095b0aa2e413401a21c007e98360be2023-10-20T11:42:43.000Z0x33ebdbddb42c70ede8205c16724352c9f64ed27c14447c4ab07a26416db3da5d289598556252317033289662642493108518
0xdef171fe48cf0115b1d80b88dc8eab59176fee570x23f7cbe79a3b4e278993f7f74265d2fcfalse270x00000000000000000000000000000000000000000x0b2c639c533813f4aa9d7837caf62653d097ff851110858870x1e925de1c68ef83bd98ee3e130ef14a50309c01b0x5929cc4d10b6a1acc5bf5d221889f10251c628a1550000004523128485832663883733241601901871400518358776001584532791311875309106790400x5929cc4d10b6a1acc5bf5d221889f10251c628a12023-10-20T02:55:51.000Z0x4f89b095fd6fe11c8183ca61d3b50fa6d294e8f57f65aad0e63cc6cfee2af36b4128922326248941820441289223262489419239
Query with partition filter
SELECT *
FROM `tt-contracts.paraswap_v5_optimism.AugustusSwapper_SwappedV3_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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in__claimantSTRINGAddress of the account claiming the tokens or rewards. Hex-encoded, 0x-prefixed, 42-character string.
in__balanceSTRINGToken amount represented in smallest denomination. String-encoded integer value without decimal places.
addressremovedlog_indexin__balanceblock_numberin__claimantblock_timestamptransaction_hash
0xd57fd755f53666ce2d3ed8c862a8d06e38c21ce6false9185235829654754000331142672300xb728311c5557f82050cda1bbe98dff6595be969a2024-01-01T18:20:37.000Z0xcce85ede01a9fee5d1bb1046d0dcbed849c559c08ee9da0bf7b2b3a0c82a2340
0xd57fd755f53666ce2d3ed8c862a8d06e38c21ce6false221629971222661765756211142699320x8e100ca591bba6ce8b1d174f14312d3dbc066c3c2024-01-01T19:50:41.000Z0xedc9f8f309cfad302189976d0c1f993d0ca06974f3035e9cd97e35fdb660a0a1
0xd57fd755f53666ce2d3ed8c862a8d06e38c21ce6false71937250058584636108191142731270xb4d502361a3c6f823eeb9a99af09e110382206ee2024-01-01T21:37:11.000Z0xda5984cc8b249e863bd85f156f89845b97e9c80277a64bde718d65fce73b9cc7
Query with partition filter
SELECT *
FROM `tt-contracts.paraswap_v5_optimism.MerkleRedeem_Claimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_idSTRINGUnique identifier for the position, record, or entity within the protocol. Numeric string representation.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_idaddressin_userremovedin_amountlog_indexblock_numberblock_timestamptransaction_hash
00x8c934b7dbc782568d14ceabbeaedf37cb63486150x3e00aee52066ee270f8badf0b5bb41993f057321false19784286135899370856661143831362024-01-04T10:44:09.000Z0xbb19f4faaa076afd1283f8a0e5a111f428d44a3d56fe348a9bf17bc501048d85
00x8c934b7dbc782568d14ceabbeaedf37cb63486150xa622e0787dfc88b50b836e62b114d74fd866fdecfalse2508526350129643519844771401143662052024-01-04T01:19:47.000Z0xaad36996fe0230b8eea5bc9ababc3644faf091355ab5d3de3ece3638c61f7635
00x8c934b7dbc782568d14ceabbeaedf37cb63486150x9bdb2b0a575e210563c5487adae844eb7f5e5c3afalse332221890535601544632101162150562024-02-15T20:28:09.000Z0x8b1e9ea51b37e79aa6e31c67ab0021b2a9bf47006c095f47cb1374a4df020c1c
Query with partition filter
SELECT *
FROM `tt-contracts.paraswap_v5_optimism.sePSP1_RequestedUnlocking_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_idSTRINGUnique identifier for the position, record, or entity within the protocol. Numeric string representation.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_idaddressin_userremovedin_amountlog_indexblock_numberblock_timestamptransaction_hash
00x26ee65874f5dbefa629eb103e7bbb2deaf4fb2c80x95b0cb330519db2bcaf74b90c1bde3d62f673718false26277029359618737759821158213162024-02-06T17:43:29.000Z0x94dd28f7c1dd636827d61b1ccf722479896756d6b9116e4e7769cf7a3595bb6c
00x26ee65874f5dbefa629eb103e7bbb2deaf4fb2c80x4c45758bf15af0714e4cc44c4efd177e209c2890false9252930175387906434521157924242024-02-06T01:40:25.000Z0xa120c3a440f744a5f1d4d8c78fb21c1021d0892c5c4f14809618972e0b70eb87
00x26ee65874f5dbefa629eb103e7bbb2deaf4fb2c80xc29ffb23abae4d7950d7f1e008019caf513f5078false61666415314703741026811158183302024-02-06T16:03:57.000Z0x40fd57494abdac9b0b649ac0e7ec08e7976ba1540a81514f8a9130c47e848ef6
Query with partition filter
SELECT *
FROM `tt-contracts.paraswap_v5_optimism.sePSP2_RequestedUnlocking_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100