1inch_v1_bsc

Tables

Mooniswap_Swapped_event

Token swap events from 1inch’s Mooniswap automated market maker (AMM) protocol on Binance Smart Chain. Contains source and destination token addresses, swap amounts, liquidity balance changes, and optional referral tracking for analyzing decentralized exchange activity.

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 source token after the swap was executed, denominated in the smallest token unit (wei for native tokens). Represents the updated liquidity state following the addition of the input token to the pool.
`in_dstRemovalBalance`	`STRING`	Pool balance of destination token after removal, denominated in the token’s smallest unit. Represents the remaining liquidity of the output token in the Mooniswap pool following the swap.
`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
0x06783bbef1770ca264b208e84ee03a4367ee7387	false	70872043475187782	1159	0xbaf9a5d4b0052359326a6cdab54babaa3a3a9643	629	0x0000000000004946c0e9f43f4dee607b0ef1fa1c	0x0fee58edb904b4b32c1fb2714454fbefd8981fc9	0x0000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000	16888629	2022-04-12T18:40:48.000Z	0xb39497fb6208d973a21b452504ce330a9c1862e65ba5bc5bf6810901d542e6d4	6383960	386431179302713019925
0x386d4fbc23727bb947a15751a5c11e84013de6d5	false	61581815801360068958	2460	0x9c4350f527ff7f96b650ee894ae9103bdfec0432	6	0x0000000000004946c0e9f43f4dee607b0ef1fa1c	0x1111111254fb6c44bac0bed2854e76f90643097d	0x0000000000000000000000000000000000000000	0x55d398326f99059ff775485246999027b3197955	16890866	2022-04-12T20:32:39.000Z	0xe478813fa81667c549c824d4b16c6c99fd0cd05ba49e05f96aafe626c2de43bf	907024	22327478545292785273792
0x06783bbef1770ca264b208e84ee03a4367ee7387	false	100000000000000000	1650	0x9c4350f527ff7f96b650ee894ae9103bdfec0432	286	0x0000000000004946c0e9f43f4dee607b0ef1fa1c	0x1111111254fb6c44bac0bed2854e76f90643097d	0x0000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000	16885468	2022-04-12T16:00:28.000Z	0x53ac70ad130280310795c40c898a84c17166b37ff3a750649283352295e1e85f	6410143	384831179302713019925

Example Query

Query with partition filter

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

MooniswapFactory_Deployed_event

Mooniswap liquidity pool deployment events from 1inch v1 protocol on BSC, recording the creation of new automated market maker (AMM) pools with their token pairs and contract addresses. Used to track pool creation history and identify available trading pairs in the 1inch DEX ecosystem.

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 specified token pair. This hex-encoded address represents the pool instance created by the factory contract.
`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 liquidity pool pair being deployed. Uses 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee or 0x0000000000000000000000000000000000000000 to represent native BNB.

Sample Data

address	removed	in_token1	in_token2	log_index	block_number	in_mooniswap	block_timestamp	transaction_hash
0xd41b24bba51fac0e4827b6f94c0d6ddeb183cd64	false	0x7e624fa0e1c4abfd309cc15719b7e2580887f570	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	4	12081678	0xec8d8e40b6715113b63ef658881ac701f19911eb	2021-10-25T15:22:08.000Z	0x095c2e56ca60222a02dd3a04738836f9056d265bbd3d4457b3dad339ad5aec75
0xd41b24bba51fac0e4827b6f94c0d6ddeb183cd64	false	0x1002d9f872e87090b67ea0242e1a3af2164a3732	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	295	6021653	0x73c80709e86329f61d0c1924f4e805a7209ee560	2021-03-26T16:00:43.000Z	0xaf87f3f4852d7794452cd47375a28ddf227f878f55d9f58cdd5a822b453cc3b4
0xd41b24bba51fac0e4827b6f94c0d6ddeb183cd64	false	0xe9e7cea3dedca5984780bafc599bd69add087d56	0xf0b9c0e5b47d6dd30e73dcf4cddae644078f508e	207	6013252	0x9b696253bea6d56cae0caf9c46b3468e0232f86d	2021-03-26T08:55:08.000Z	0x19ba75913e37f6de360d27b5b1d91396f6541679305f9b83d2722fd3ecd7276b

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Mooniswap_Swapped_event

MooniswapFactory_Deployed_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Mooniswap_Swapped_event

​MooniswapFactory_Deployed_event

Tables

Mooniswap_Swapped_event

MooniswapFactory_Deployed_event