Skip to main content

​
Tables

​
AugustusSwapper_Swapped_event

Token swap execution events emitted by ParaSwap’s AugustusSwapper contract. Contains source and destination token addresses, swap amounts (sent and received versus expected), initiator and beneficiary addresses, and referrer identifier for tracking swap origins across DEX aggregation routes.
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_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.
in_referrerSTRINGAddress that referred the user to the protocol or facilitated the transaction. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedlog_indexin_referrerin_srcTokenblock_numberin_destTokenin_initiatorin_srcAmountin_beneficiaryblock_timestamptransaction_hashin_expectedAmountin_receivedAmount
0x86969d29f5fd327e1009ba66072be22db6017cc6false220paraswap.io0x2260fac5e5542a773aa44fbcfedf7c193bc2c599108146240xdac17f958d2ee523a2206206994597c13d831ec70x132a3643b457db8c20652c0be1810791c070c5f42959030450x132a3643b457db8c20652c0be1810791c070c5f42020-09-07T12:50:17.000Z0x887946fca7b231ce3b343a1ead4c850eae9612d270dabc56082f25f87894e7b62915355160529142307289
0x86969d29f5fd327e1009ba66072be22db6017cc6false54paraswap.io0x2260fac5e5542a773aa44fbcfedf7c193bc2c599108146110xdac17f958d2ee523a2206206994597c13d831ec70x132a3643b457db8c20652c0be1810791c070c5f43890000000x132a3643b457db8c20652c0be1810791c070c5f42020-09-07T12:47:44.000Z0xc264514ee0973bc9b6939b7d54b5a024101d152ad3f645af4946710a0a6b80293850283100038497774000
0x86969d29f5fd327e1009ba66072be22db6017cc6false21paraswap.io0x2260fac5e5542a773aa44fbcfedf7c193bc2c599108121160xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0x87b6537ede045d1e9e083911c725b98b4e9a868d10138547800x87b6537ede045d1e9e083911c725b98b4e9a868d2020-09-07T03:41:00.000Z0x0f04105be3178d346e10f4e72a50ca3dcf08acda69230e161299bfbe0fd666da295660858100000000000295424244007676515656
Query with partition filter
SELECT *
FROM `tt-contracts.paraswap_v1_ethereum.AugustusSwapper_Swapped_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100