1inch_v1_ethereum

Tables

GasRefundProgram_Claimed_event

Gas refund claim events from 1inch v1 DEX aggregator on Ethereum, recording when users claimed rebates on transaction gas costs. Useful for analyzing 1inch’s gas rebate program participation and distribution patterns.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
0xee262adcd9ecc0476452e302cf3c822f634dafaf	false	17127451020222799872	446	0xb67d92dc830f1a24e4bffd1a6794fcf8f497c7de	14054404	2022-01-22T08:48:37.000Z	0x5c569958bffa0aa5ad114aa95cee87992bc715edc572f6a8e7ca16c36ba4c328
0xee262adcd9ecc0476452e302cf3c822f634dafaf	false	17414118969067065344	331	0x5a9dc3f62b089ac07718ad23a0311e1e8283ba72	14053342	2022-01-22T04:47:54.000Z	0x921a083b1d90b5d5185f8564d0be619f015d7c496c3fbd7cd15805c23b1d209e
0xee262adcd9ecc0476452e302cf3c822f634dafaf	false	32714752719784491008	654	0x9db79aa6e0630a6b73c3233b84fe6b2582ad69a8	14053795	2022-01-22T06:23:52.000Z	0x0893c8deff1f30a7565e11c21455b8575976c8f88e7d288e9c325b149032fd01

Example Query

Query with partition filter

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

Mooniswap_Swapped_event

Swap execution events from 1inch’s Mooniswap automated market maker (AMM) on Ethereum. Records token swaps with input/output amounts, pool balances, sender/receiver addresses, and optional referral tracking for analyzing trading volume and liquidity dynamics.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. 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_dstToken`	`STRING`	Contract address of the destination token being received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_result`	`STRING`	Output amount received from the swap operation or boolean flag indicating the enabled state of a token.
`in_srcAdditionBalance`	`STRING`	Pool balance of the source token after adding the input amount from this swap. Denominated in the token’s smallest unit (wei for ETH).
`in_dstRemovalBalance`	`STRING`	Token balance of the destination asset in the Mooniswap pool after the swap execution, denominated in the smallest unit (wei-equivalent). This balance reflects the pool’s liquidity state post-trade for analytical tracking purposes.
`in_referral`	`STRING`	Referral code identifier associated with the transaction. Numeric string representation, often ‘0’ when no referral is present.

Sample Data

address	removed	in_amount	in_result	in_sender	log_index	in_dstToken	in_receiver	in_referral	in_srcToken	block_number	block_timestamp	transaction_hash	in_dstRemovalBalance	in_srcAdditionBalance
0x182c94f010605d34e43593123cec13521ae1df69	false	346000000000000000	1298860834854808658435	0x27239549dd40e1d60f5b80b0c4196923745b1fd2	168	0x0f71b8de197a1c84d31de0f1fa7926c365f052b3	0xb81e739bcea2c980fdd9023c548d2b29fc5b764c	0x0000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000	13521750	2021-10-31T00:51:18.000Z	0x334d5474fcfbc69dcc8fe5ce99c5f03bc16ece92be30a9dd75a34898467c018d	30389583808758108495872	7503755474670567834
0x182c94f010605d34e43593123cec13521ae1df69	false	287000000000000000	1003199923967973008156	0x27239549dd40e1d60f5b80b0c4196923745b1fd2	111	0x0f71b8de197a1c84d31de0f1fa7926c365f052b3	0x58475b4b52ae07c7d1f1bd46a71233400c5652fd	0x0000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000	13525125	2021-10-31T13:42:22.000Z	0x2248d2883b951f711a07041ac684caf25ca96723e41307636a5430f1c14182a3	29296702835948899830265	7888353014411042329
0x182c94f010605d34e43593123cec13521ae1df69	false	453186857719751971	1392103885563768649723	0x91000060399502550000007bbfba0052f47b008a	14	0x0f71b8de197a1c84d31de0f1fa7926c365f052b3	0x1a1fe6f955b6567a75dddec526320a4a1a214fa9	0x0000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000	13522587	2021-10-31T04:02:03.000Z	0x9beb052ab0a924f5bcf3af73f12bbdd073a502e72afdc2b0fa2c6dbbee990185	27722098418961746858303	8251323244670567834

Example Query

Query with partition filter

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

MooniswapFactory_Deployed_event

Liquidity pool deployment events from 1inch’s Mooniswap automated market maker (AMM) factory contract on Ethereum. Records each new pool creation with token pair addresses and deployed pool contract address for tracking AMM expansion.

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_mooniswap`	`STRING`	Contract address of the newly deployed Mooniswap liquidity pool for the token pair. This address represents the AMM (Automated Market Maker) pool contract created by the 1inch Mooniswap factory.
`in_token1`	`STRING`	Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_token2`	`STRING`	Contract address of the second token in the newly deployed Mooniswap liquidity pool. Uses zero address (0x0000000000000000000000000000000000000000) to represent native ETH.

Sample Data

address	removed	in_token1	in_token2	log_index	block_number	in_mooniswap	block_timestamp	transaction_hash
0xbaf9a5d4b0052359326a6cdab54babaa3a3a9643	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0xed30dd7e50edf3581ad970efc5d9379ce2614adb	27	12070956	0xf7c88430faebc9aae3b0c3f61b3898b7906054a5	2021-03-19T18:52:26.000Z	0x4b50a0859c5c23f32a2272fd8b7e7c1af1d52a418e0af778a323ed0693e34358
0xbaf9a5d4b0052359326a6cdab54babaa3a3a9643	false	0xdac17f958d2ee523a2206206994597c13d831ec7	0xed30dd7e50edf3581ad970efc5d9379ce2614adb	104	12071061	0xf15a6db8d536a2b8de10f48f62571905d414c3e1	2021-03-19T19:18:45.000Z	0xa2fd912e786fe3331862c5b1af22c074c83656190de84adb70923a36770acb3e
0xbaf9a5d4b0052359326a6cdab54babaa3a3a9643	false	0x0000000000000000000000000000000000000000	0xd07cda1adbc2cb22d9b321e8ac504745aaa5b9d5	95	12630825	0xd5290af2797f47360429883c4990457a695cf375	2021-06-14T05:59:57.000Z	0x915058dfc9a9fd81e74440fb0bae4610c0092f40bab13fbba286884fefd61063

Example Query

Query with partition filter

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

OneInchExchange_swap_function

Token swap execution records from 1inch v1 DEX aggregator on Ethereum. Contains trade parameters including input/output tokens, amounts, routing paths, and slippage protections for analyzing swap patterns and protocol usage.

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_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromTokenAmount`	`STRING`	Amount of the input token being swapped, denominated in the token’s smallest unit (wei for ETH, base units for ERC20s). Null when swap transaction fails.
`in_minReturnAmount`	`STRING`	Minimum amount of destination tokens required for the swap to execute successfully, denominated in the token’s smallest unit (wei equivalent). Transactions revert if actual output falls below this slippage protection threshold.
`in_guaranteedAmount`	`STRING`	Minimum token amount guaranteed to be received by the swap after accounting for slippage and fees. Specified in the token’s smallest unit (wei for ETH, base units for ERC20 tokens) and often null for failed transactions.
`in_referrer`	`STRING`	Address that referred the user to the protocol or facilitated the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_callAddresses`	`ARRAY<STRING>`	Array of contract addresses called during the 1inch swap routing path, representing intermediate DEX protocols or liquidity sources. Typically contains 1-3 addresses for simple swaps, null for failed transactions.
`in_callDataConcat`	`STRING`	Concatenated calldata for intermediate contract calls executed during the 1inch v1 swap routing. Null for failed transactions; hex-encoded function selectors and parameters for successful multi-hop swaps.
`in_starts`	`ARRAY<STRING>`	Array of byte offsets indicating where each segment of routing data begins in the concatenated calldata. Used by 1inch to parse complex multi-hop swap paths from the callDataConcat field.
`in_gasLimitsAndValues`	`ARRAY<STRING>`	Array of gas limits and ETH values for each routing step in the 1inch swap path. Typically contains two values per step: the gas limit allocated and ETH amount sent with that call.
`out_returnAmount`	`STRING`	Amount of tokens returned by the swap operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

gas	status	gas_used	in_starts	signature	to_address	block_number	from_address	block_timestamp	in_callAddresses	transaction_hash	in_gasLimitsAndValues
911289	false	357569	[]	0xf88309d7	0x11111254369792b2ca5d084ab5eea397ca8fa48b	9347919	0x7294bbe5dab1d41e8b690454ce3e5dd59737ef30	2020-01-25T01:06:44.000Z	[]	0x37f431ebfe2319365216df46f7039a998f2e9720debfebe4aef53e8d14f84b35	[]
2149740	false	1085046	[]	0xf88309d7	0x11111254369792b2ca5d084ab5eea397ca8fa48b	9352124	0x9eaa3d7763e1033f7dad0130d2750a4751e994ca	2020-01-25T16:48:54.000Z	[]	0x1a6b08d5d9c3b103a300300f256f6897f5e40c36b706fe05729940c9aac0b5b8	[]
1926257	false	784927	[]	0xf88309d7	0x11111254369792b2ca5d084ab5eea397ca8fa48b	9351703	0xb7ec3afc8ea5e99686783839a63fb2c4cd58fae2	2020-01-25T15:17:49.000Z	[]	0xb454c503c3f55e500d4490621c25d6cfcb76e3e23074957ad2eaf8d76dd84d9e	[]

Example Query

Query with partition filter

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

OneInchExchange_Swapped_event

Token swap event records from 1inch V1 decentralized exchange aggregator on Ethereum. Contains trade details including input/output token addresses, amounts, fees, and referrer information for analyzing DEX routing patterns and trading volume.

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_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_referrer`	`STRING`	Address that referred the user to the protocol or facilitated the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_referrerFee`	`STRING`	Fee amount paid to the referrer address for facilitating this swap on 1inch v1. Stored as a string to preserve precision; typically zero in most swaps as shown in sample data.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

address	removed	log_index	in_toToken	in_referrer	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x11111254369792b2ca5d084ab5eea397ca8fa48b	false	67	0x0000000000085d4780b73119b644ae5ecd22b376	0x98dca2b9cd7d5ae63f87e36809a352140873ba9d	249995625713867267672	11027288	0xad32a8e6220741182940c5abf610bde99e737b2d	111710199293396111627	2020-10-10T10:48:00.000Z	0xc2f0649ca113d3333fb2238ad8602097610c036a226197705cec07b01b47e86b
0x11111254369792b2ca5d084ab5eea397ca8fa48b	false	29	0x0a51ecf7362ce03f75a20cad7671741953d2d7c8	0x0000000000000000000000000000000000000000	8935284345763902210361	11027912	0x737f98ac8ca59f2c68ad658e3c3d8c8963e40a4c	200000000000000000000000	2020-10-10T13:22:00.000Z	0x611cceaf5fab9b5da3b2775a988d743477c87471482f881725d6e908677e84e9
0x11111254369792b2ca5d084ab5eea397ca8fa48b	false	97	0x0ff6ffcfda92c53f615a4a75d982f399c989366b	0x98dca2b9cd7d5ae63f87e36809a352140873ba9d	1144124975827907191180	11026865	0x6f87d756daf0503d08eb8993686c7fc01dc44fb1	610000000000000000000	2020-10-10T09:12:29.000Z	0x41fff0e820c5ebb9a39a20730987ae95209dcd1ca1a6b8fe520a85e42e32e23c

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

GasRefundProgram_Claimed_event

Mooniswap_Swapped_event

MooniswapFactory_Deployed_event

OneInchExchange_swap_function

OneInchExchange_Swapped_event

​Tables

​GasRefundProgram_Claimed_event

​Mooniswap_Swapped_event

​MooniswapFactory_Deployed_event

​OneInchExchange_swap_function

​OneInchExchange_Swapped_event

Tables

GasRefundProgram_Claimed_event

Mooniswap_Swapped_event

MooniswapFactory_Deployed_event

OneInchExchange_swap_function

OneInchExchange_Swapped_event