Skip to main content

​
Tables

​
AugustusSwapper_Bought_event

Token swap completion events emitted by ParaSwap’s AugustusSwapper contract recording source and destination token addresses, amounts exchanged, initiator, beneficiary, and referrer. Used for tracking DEX aggregator trade execution and referral attribution.
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
0x9509665d015bfe3c77aa5ad6ca20c8afa1d98989false295mooni0x6b175474e89094c44da98b954eedeac495271d0f117114540xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0x4ce113726e833df237f36291f064306fd58e42765004208008478606740000x4ce113726e833df237f36291f064306fd58e42762021-01-23T11:11:17.000Z0x4db24351b0f7eaa5f3dd40d0e35fa08adf1eba3a9aa70c484660639e67ea0b07495466139453327400000394764410393024219
0x9509665d015bfe3c77aa5ad6ca20c8afa1d98989false244paraswap.io0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee113688900x6b175474e89094c44da98b954eedeac495271d0f0x370de8e14fd6f054b17220a3882bef2960a159f31668327242759435610x370de8e14fd6f054b17220a3882bef2960a159f32020-12-01T20:39:00.000Z0x0b0646f6f2e7480a60fce2f3ed3720406cfda23e211cfc70e1381950529ad752168517903309033900100000000000000000000
0x9509665d015bfe3c77aa5ad6ca20c8afa1d98989false212mooni0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2117534550xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0xdac7a91516112703448b5d1fbc8b679fce838e8a272700000000000000xdac7a91516112703448b5d1fbc8b679fce838e8a2021-01-29T22:23:51.000Z0x8985fcc1a90febc7339f3eaf649459c7c6782e72dab1532f4972a1c21f73221e2700000000000000026930648678207736
Query with partition filter
SELECT *
FROM `tt-contracts.paraswap_v2_ethereum.AugustusSwapper_Bought_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
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
0x9509665d015bfe3c77aa5ad6ca20c8afa1d98989false97YDEX0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee110166320xdac17f958d2ee523a2206206994597c13d831ec70xe5e9b165ba01f3d58815bb6962f374b05f532c9d10000000000000000xe5e9b165ba01f3d58815bb6962f374b05f532c9d2020-10-08T19:00:48.000Z0xc90aa75bd5b15b311fb3ecf716e157ed72617905379ea640761fab9c699b46bd381987381986
0x9509665d015bfe3c77aa5ad6ca20c8afa1d98989false54argent0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee110153660x6b175474e89094c44da98b954eedeac495271d0f0xb8a16cb7981aa45697ac255d61729a39df53ec932500000000000000000xb8a16cb7981aa45697ac255d61729a39df53ec932020-10-08T14:12:11.000Z0x12b6f147fd507b55ae32b178f95907ae194f84f3afc2c80c232c104fde5ada928413534815337208930084558138847610150583
0x9509665d015bfe3c77aa5ad6ca20c8afa1d98989false206argent0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee110155240x0d8775f648430679a709e98d2b0cb6250d2887ef0xb8a16cb7981aa45697ac255d61729a39df53ec931200000000000000000xb8a16cb7981aa45697ac255d61729a39df53ec932020-10-08T14:44:48.000Z0x280789ffdf282d54a10536f75c6dc80cb91e5290cfb00b1f148a3e9c642ec38e190660287251651318700191618379147388247126
Query with partition filter
SELECT *
FROM `tt-contracts.paraswap_v2_ethereum.AugustusSwapper_Swapped_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100