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.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_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. |
in_referrer | STRING | Address that referred the user to the protocol or facilitated the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
Sample Data
Sample Data
| address | removed | log_index | in_referrer | in_srcToken | block_number | in_destToken | in_initiator | in_srcAmount | in_beneficiary | block_timestamp | transaction_hash | in_expectedAmount | in_receivedAmount |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0x86969d29f5fd327e1009ba66072be22db6017cc6 | false | 220 | paraswap.io | 0x2260fac5e5542a773aa44fbcfedf7c193bc2c599 | 10814624 | 0xdac17f958d2ee523a2206206994597c13d831ec7 | 0x132a3643b457db8c20652c0be1810791c070c5f4 | 295903045 | 0x132a3643b457db8c20652c0be1810791c070c5f4 | 2020-09-07T12:50:17.000Z | 0x887946fca7b231ce3b343a1ead4c850eae9612d270dabc56082f25f87894e7b6 | 29153551605 | 29142307289 |
| 0x86969d29f5fd327e1009ba66072be22db6017cc6 | false | 54 | paraswap.io | 0x2260fac5e5542a773aa44fbcfedf7c193bc2c599 | 10814611 | 0xdac17f958d2ee523a2206206994597c13d831ec7 | 0x132a3643b457db8c20652c0be1810791c070c5f4 | 389000000 | 0x132a3643b457db8c20652c0be1810791c070c5f4 | 2020-09-07T12:47:44.000Z | 0xc264514ee0973bc9b6939b7d54b5a024101d152ad3f645af4946710a0a6b8029 | 38502831000 | 38497774000 |
| 0x86969d29f5fd327e1009ba66072be22db6017cc6 | false | 21 | paraswap.io | 0x2260fac5e5542a773aa44fbcfedf7c193bc2c599 | 10812116 | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 0x87b6537ede045d1e9e083911c725b98b4e9a868d | 1013854780 | 0x87b6537ede045d1e9e083911c725b98b4e9a868d | 2020-09-07T03:41:00.000Z | 0x0f04105be3178d346e10f4e72a50ca3dcf08acda69230e161299bfbe0fd666da | 295660858100000000000 | 295424244007676515656 |
Example Query
Example Query
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