paraswap_v4_ethereum

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.

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_referrer`	`STRING`	Address that referred the user to the protocol or facilitated the transaction. Hex-encoded, 0x-prefixed, 42-character string.

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_receivedAmount
0x1bd435f3c054b6e901b7b108a0ab7617c808677b	false	62	GPv2	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	13043662	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0x9008d19f58aabd9ed0d60971565aa8510560ab41	80365335280	0x9008d19f58aabd9ed0d60971565aa8510560ab41	2021-08-17T15:58:14.000Z	0xea98b6cc70bcd35d5414beadfc9d024a0fd1166fcd709aac19ab8f30fcd80fdc	25330000000000000000
0x1bd435f3c054b6e901b7b108a0ab7617c808677b	false	118	GPv2	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	12732262	0xdac17f958d2ee523a2206206994597c13d831ec7	0x3328f5f2cecaf00a2443082b657cedeaf70bfaef	10013503500	0x3328f5f2cecaf00a2443082b657cedeaf70bfaef	2021-06-30T00:49:22.000Z	0xad5998e9f15b0f0120dc3f6a281fc422cf0c47954c051a13d8f85dd48ae41d5d	10000000000
0x1bd435f3c054b6e901b7b108a0ab7617c808677b	false	63	GPv2	0xd533a949740bb3306d119cc777fa900ba034cd52	13170008	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x9008d19f58aabd9ed0d60971565aa8510560ab41	28800754419112369106200	0x9008d19f58aabd9ed0d60971565aa8510560ab41	2021-09-06T04:17:40.000Z	0x9819ffcd57c72819668f8e0f1d32cb16638b328452ead81aefd0375d672e6419	74643809706

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v4_ethereum.AugustusSwapper_Bought_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AugustusSwapper_buyOnUniswap_function

ParaSwap V4 buyOnUniswap function calls on Ethereum, capturing exact-output swaps through Uniswap with multi-hop token paths and maximum input amounts. Used for analyzing ParaSwap routing decisions and slippage protection across Uniswap liquidity pools.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_amountInMax`	`STRING`	Maximum amount of input tokens allowed to be spent for the swap. Numeric string representing the token quantity in its smallest denomination.
`in_amountOut`	`STRING`	Amount of output tokens received from the swap. Numeric string representing the token quantity in its smallest denomination.
`in_path`	`ARRAY<STRING>`	Ordered sequence of token contract addresses representing the swap route from input token to output token. Array of hex-encoded, 0x-prefixed, 42-character addresses.
`in_referrer`	`INT64`	Address that referred the user to the protocol or facilitated the transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

gas	status	in_path	gas_used	signature	to_address	block_number	from_address	in_amountOut	trace_address	in_amountInMax	block_timestamp	transaction_hash
200947	true	[“0xdac17f958d2ee523a2206206994597c13d831ec7”,“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“0x990f341946a3fdb507ae7e52d17851b87168017c”]	135321	0xf9355f72	0x1bd435f3c054b6e901b7b108a0ab7617c808677b	12763798	0x3328f5f2cecaf00a2443082b657cedeaf70bfaef	100000000000000000000	3	23423104539	2021-07-04T22:40:30.000Z	0x8ad4be033619512c1022ab3227c97cb857d14313b7282bb54bc12ad11913ec4b
221591	true	[“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“0xb20043f149817bff5322f1b928e89abfc65a9925”]	151764	0xf9355f72	0x1bd435f3c054b6e901b7b108a0ab7617c808677b	12761289	0x3328f5f2cecaf00a2443082b657cedeaf70bfaef	30000000000000	3	2189742593	2021-07-04T13:28:57.000Z	0xc29e9fa76b5a75bcf937f82b8f76596e2ca51107e66db796b11e0976f0fd5687
231788	true	[“0x249e38ea4102d0cf8264d3701f1a0e39c4f2dc3b”,“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“0xdac17f958d2ee523a2206206994597c13d831ec7”]	154163	0xf9355f72	0x1bd435f3c054b6e901b7b108a0ab7617c808677b	12759518	0x3328f5f2cecaf00a2443082b657cedeaf70bfaef	11000000000	4	7990476419343851433000000000	2021-07-04T06:44:20.000Z	0x05a0edf6ae392701edfd5a6deaa8804214bc971bc2540735ab326d4df07e5440

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v4_ethereum.AugustusSwapper_buyOnUniswap_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AugustusSwapper_buyOnUniswapFork_function

ParaSwap V4 AugustusSwapper contract function calls for buying exact token amounts on Uniswap fork DEXs on Ethereum. Records swap paths, factory addresses, maximum input amounts, and referrer data for analyzing DEX aggregation routing strategies.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_factory`	`STRING`	Contract address of the factory that deployed or created the associated resource. Hex-encoded, 0x-prefixed, 42-character string.
`in_initCode`	`STRING`	Keccak-256 hash of the initialization code used by the factory to compute pair addresses. 66-character hex string including 0x prefix.
`in_amountInMax`	`STRING`	Maximum amount of input tokens allowed to be spent for the swap. Numeric string representing the token quantity in its smallest denomination.
`in_amountOut`	`STRING`	Amount of output tokens received from the swap. Numeric string representing the token quantity in its smallest denomination.
`in_path`	`ARRAY<STRING>`	Ordered sequence of token contract addresses representing the swap route from input token to output token. Array of hex-encoded, 0x-prefixed, 42-character addresses.
`in_referrer`	`INT64`	Address that referred the user to the protocol or facilitated the transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

gas	status	in_path	gas_used	signature	in_factory	to_address	in_initCode	block_number	from_address	in_amountOut	trace_address	in_amountInMax	block_timestamp	transaction_hash
231375	true	[“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“0xca3fe04c7ee111f0bbb02c328c699226acf9fd33”]	153040	0x33635226	0xc0aee478e3658e2610c5f7a4a2e1777ce9e4f2ac	0x1bd435f3c054b6e901b7b108a0ab7617c808677b	0xe18a34eb0e04b04f7a0ac29a6e80748dca96319b42c54d679cb821dca90c6303	12787901	0x3328f5f2cecaf00a2443082b657cedeaf70bfaef	123000000000000000000	3	500749593	2021-07-08T16:57:43.000Z	0x09f67fd3154e14755cbc65834aa0a3ce5aa136963608380ebc9b9e54be26646b
645211	true	[“0xfca59cd816ab1ead66534d82bc21e7515ce441cf”,“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”]	91051	0x33635226	0xc0aee478e3658e2610c5f7a4a2e1777ce9e4f2ac	0x1bd435f3c054b6e901b7b108a0ab7617c808677b	0xe18a34eb0e04b04f7a0ac29a6e80748dca96319b42c54d679cb821dca90c6303	13123480	0x9008d19f58aabd9ed0d60971565aa8510560ab41	800000000000000000	4	86576294751123626157	2021-08-29T23:52:27.000Z	0x14f999c097359167e9d375264436031e66cf543d1bb6be33d7a0c64a41006a90
237236	true	[“0x25f8087ead173b73d6e8b84329989a8eea16cf73”,“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”]	162958	0x33635226	0xc0aee478e3658e2610c5f7a4a2e1777ce9e4f2ac	0x1bd435f3c054b6e901b7b108a0ab7617c808677b	0xe18a34eb0e04b04f7a0ac29a6e80748dca96319b42c54d679cb821dca90c6303	13234607	0x9008d19f58aabd9ed0d60971565aa8510560ab41	11818000000	3	1869083742238681632044	2021-09-16T04:26:00.000Z	0x3b39b088ef7f2909388dfed26d8658a9a2b58fe5bf118be8fa930f26c13839ea

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v4_ethereum.AugustusSwapper_buyOnUniswapFork_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AugustusSwapper_swapOnUniswap_function

Uniswap swap function calls executed through ParaSwap v4’s AugustusSwapper contract on Ethereum, recording token swap attempts with input amounts, minimum output constraints, and swap paths. Used for analyzing ParaSwap routing through Uniswap and tracking failed versus successful swap executions.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_amountIn`	`STRING`	Amount of input tokens being swapped or deposited in the transaction. Numeric string representing the token quantity in its smallest denomination.
`in_amountOutMin`	`STRING`	Minimum acceptable output amount for the swap or transfer operation. Numeric string representation of token quantity in smallest denomination.
`in_path`	`ARRAY<STRING>`	Ordered sequence of token contract addresses representing the swap route from input token to output token. Array of hex-encoded, 0x-prefixed, 42-character addresses.
`in_referrer`	`INT64`	Address that referred the user to the protocol or facilitated the transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

gas	value	status	in_path	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
159130	0	false	[]	31104	0x58b9d179	0x1bd435f3c054b6e901b7b108a0ab7617c808677b	12735944	0x1c1bb05837e89dd248878b410e36dcfb3a4a63f1	2021-06-30T14:40:03.000Z	0x7ec193d4a7359d02a311fd850a8f3ad8fd8c18bb80be035238e5fe0f775946f9
146465	50000000000000000	false	[]	129143	0x58b9d179	0x1bd435f3c054b6e901b7b108a0ab7617c808677b	12734020	0xc8f1fb7645bd7b002e0a1c41b2386eb2dedcb46b	2021-06-30T07:33:44.000Z	0x38f92accb4a4e32b644c8d8059f246171c6364de183c9d476d5a6c460ab62229
159144	1000000000000000000	false	[]	129894	0x58b9d179	0x1bd435f3c054b6e901b7b108a0ab7617c808677b	12738019	0x8ec87a8cb2bc183d13a923197c75bfbc7cff8c22	2021-06-30T22:13:01.000Z	0xae7e2b075cb6ab1ad399427753af0cb080dceae571cfa6f792a104dba2529bfa

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v4_ethereum.AugustusSwapper_swapOnUniswap_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AugustusSwapper_swapOnUniswapFork_function

Function call records for ParaSwap v4’s swapOnUniswapFork method on Ethereum, routing token swaps through Uniswap v2 fork DEXs (Sushiswap, Shibaswap). Captures swap parameters including token paths, amounts, factory addresses, and execution status for analyzing DEX aggregator routing decisions.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_factory`	`STRING`	Contract address of the factory that deployed or created the associated resource. Hex-encoded, 0x-prefixed, 42-character string.
`in_initCode`	`STRING`	Keccak-256 hash of the initialization code used by the factory to compute pair addresses. 66-character hex string including 0x prefix.
`in_amountIn`	`STRING`	Amount of input tokens being swapped or deposited in the transaction. Numeric string representing the token quantity in its smallest denomination.
`in_amountOutMin`	`STRING`	Minimum acceptable output amount for the swap or transfer operation. Numeric string representation of token quantity in smallest denomination.
`in_path`	`ARRAY<STRING>`	Ordered sequence of token contract addresses representing the swap route from input token to output token. Array of hex-encoded, 0x-prefixed, 42-character addresses.
`in_referrer`	`INT64`	Address that referred the user to the protocol or facilitated the transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

gas	value	status	in_path	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
65143	0	false	[]	64451	0x0863b7ac	0x1bd435f3c054b6e901b7b108a0ab7617c808677b	12810008	0x1c1bb05837e89dd248878b410e36dcfb3a4a63f1	2021-07-12T03:20:23.000Z	0xf2b56959ee68d8576987e403fe6eff6c9ba8ada1cf03a77e6c78ec4bd3748167
159831	0	false	[]	157963	0x0863b7ac	0x1bd435f3c054b6e901b7b108a0ab7617c808677b	12809413	0x2d8f76ae3f884b2b9eb7837e1060801568ad352d	2021-07-12T01:01:00.000Z	0xbc483499374e105cad7258d9f91c1ea37ca3649635b0652be7c191a2aa14ba11
169291	9000000000000000000	false	[]	138879	0x0863b7ac	0x1bd435f3c054b6e901b7b108a0ab7617c808677b	12813848	0x6ed1a5b3f62868b95ad763496bdafc7f018a55a8	2021-07-12T17:37:04.000Z	0x11d7295600151617462d69f6e39ec282ebacf3e322271fd71ede5bd2b61e35ec

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v4_ethereum.AugustusSwapper_swapOnUniswapFork_function`
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.

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

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
0x1bd435f3c054b6e901b7b108a0ab7617c808677b	false	176	argent	0x0391d2021f89dc339f60fff84546ea23e337750f	14601588	0xd13c7342e1ef687c5ad21b27c2b65d772cab5c8c	0x828b2d29d2b5f009c59115fdca8bf37ad738a64c	225536107491375561972	0x828b2d29d2b5f009c59115fdca8bf37ad738a64c	2022-04-17T07:54:02.000Z	0xd6f96a07ac3faf68e9070769aad7116a05b35b55c6e33f631814a62196aeb0b9	18397720	18397720
0x1bd435f3c054b6e901b7b108a0ab7617c808677b	false	124	argent	0x18aaa7115705e8be94bffebde57af9bfc265b998	14599818	0x3432b6a60d23ca0dfca7761b7ab56459d9c964d0	0x1964e27bfe413d3c4213898e7e65099d08cc87cc	833523954757465133880	0x1964e27bfe413d3c4213898e7e65099d08cc87cc	2022-04-17T01:19:22.000Z	0x7eedf9e9e3dec6d0fd86471aa80224c973f0d213113943d7ac7ec88b68a1c2f6	38450718033183755638	38450718033183755638
0x1bd435f3c054b6e901b7b108a0ab7617c808677b	false	249	argent	0x3506424f91fd33084466f402d5d97f05f8e3b4af	14605546	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x3bec257ac82937f390e4bbfd63ac1ca051627d41	9779757566527134371613	0x3bec257ac82937f390e4bbfd63ac1ca051627d41	2022-04-17T22:51:50.000Z	0x347c5b71ed0b36e86baf3fa9fa4b1efae2b4de9f3f3679c58e95c714350fdab2	2261274808	2261274808

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.paraswap_v4_ethereum.AugustusSwapper_Swapped_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

AugustusSwapper_Bought_event

AugustusSwapper_buyOnUniswap_function

AugustusSwapper_buyOnUniswapFork_function

AugustusSwapper_swapOnUniswap_function

AugustusSwapper_swapOnUniswapFork_function

AugustusSwapper_Swapped_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AugustusSwapper_Bought_event

​AugustusSwapper_buyOnUniswap_function

​AugustusSwapper_buyOnUniswapFork_function

​AugustusSwapper_swapOnUniswap_function

​AugustusSwapper_swapOnUniswapFork_function

​AugustusSwapper_Swapped_event

Tables

AugustusSwapper_Bought_event

AugustusSwapper_buyOnUniswap_function

AugustusSwapper_buyOnUniswapFork_function

AugustusSwapper_swapOnUniswap_function

AugustusSwapper_swapOnUniswapFork_function

AugustusSwapper_Swapped_event