inkyswap_v2_ink

Tables

Factory_PairCreated_event

Decentralized exchange (DEX) liquidity pool creation events emitted by Automated Market Maker (AMM) factory contracts. Records new trading pair deployments with token addresses, deployed pair contract address, and creation sequence number for tracking pool instantiation across DEX protocols.

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_token0`	`STRING`	Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_token1`	`STRING`	Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_pair`	`STRING`	Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_anon3`	`STRING`	Sequential counter tracking the total number of pairs created by the factory contract.

Sample Data

address	in_pair	removed	in_anon3	in_token0	in_token1	log_index	block_number	block_timestamp	transaction_hash
0x458c5d5b75ccba22651d2c5b61cb1ea1e0b0f95d	0x42640a5fdb78dfd376cd3fc99882ae52667715bb	false	156	0x1514c65c751d16bf253a9e82715771c5557e568b	0x896bde845201ec44867c61db4caaa50db5a84aee	1	5595675	2025-02-09T09:41:26.000Z	0x44e7c57557e755f0c9c8127d73deffdd7c8d3a59e989be4e92a8d9563a753383
0x458c5d5b75ccba22651d2c5b61cb1ea1e0b0f95d	0x9d33b5d89d0a627f3789b03c9db9dd2bcfb28a47	false	70	0xc73e0b7f73fc5a1dc6c5e52e95c79273695e993e	0xd642b49d10cc6e1bc1c6945725667c35e0875f22	0	3944195	2025-01-21T06:56:46.000Z	0x1a5af3ee0ca2edf1eabfa03bb9010f60c50c91009103955929f0d652b1d3fb32
0x458c5d5b75ccba22651d2c5b61cb1ea1e0b0f95d	0xe83b0b0f03e69663ec92fc62873ea236132ef092	false	73	0xc73e0b7f73fc5a1dc6c5e52e95c79273695e993e	0xe169c0cad1f9e5884c30db1976a39ebc40f8865f	0	3973189	2025-01-21T15:00:00.000Z	0xb5805fe71ac1f87e766c064fa6dd0b7b72a690718ff24afd644a185a01f0ea54

Example Query

Query with partition filter

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

Pair_Burn_event

Liquidity removal events from DEX (Decentralized Exchange) trading pairs recording amounts of both tokens withdrawn when liquidity providers burn LP tokens. Used for tracking liquidity provision activity and calculating total value locked (TVL) changes in automated market maker (AMM) 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.
`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_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0xa8c1c38ff57428e5c3a34e0899be5cb385476507	0x578accaf5d5306edcdf1cd365b99b7669a8a858b	false	0xa8c1c38ff57428e5c3a34e0899be5cb385476507	8	10636168142815508436047	1100989590096389	3193687	2025-01-12T14:28:18.000Z	0x03fe192a7102774c0081938079641597cb7c4c2fc1139ac9bf8ff71c275218c5
0xa8c1c38ff57428e5c3a34e0899be5cb385476507	0x578accaf5d5306edcdf1cd365b99b7669a8a858b	false	0xa8c1c38ff57428e5c3a34e0899be5cb385476507	7	5127791356813534207158	516606486503020	3167108	2025-01-12T07:05:19.000Z	0x66c11f4ec43758029d11f77d2e0856e4cd8925cbb40e920deead1d6b97c25c25
0xa8c1c38ff57428e5c3a34e0899be5cb385476507	0xeaac4a3d63649a2c82433b3e2ad972cc6ba51d13	false	0xa8c1c38ff57428e5c3a34e0899be5cb385476507	7	430300420345009689756256	57279669342614188	3172520	2025-01-12T08:35:31.000Z	0xeb1f75714362448087eed239e45d688f857edf4c94ad034c7735f80ab4f8582b

Example Query

Query with partition filter

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

Pair_Mint_event

Liquidity provision events emitted when users add tokens to a DEX pair contract. Records sender address and token amounts deposited for liquidity pool operations.

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_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x962deabf477f3e81adaa716d7f942dd8be083f3f	false	0xa8c1c38ff57428e5c3a34e0899be5cb385476507	4	17000000000000000000	20000000000000000000	3649729	2025-01-17T21:09:00.000Z	0xcb2e28b7fd7b88cb8a5f3b4973a116285589d9b6c61a3cbf4e3521357e1a8366
0xeaac4a3d63649a2c82433b3e2ad972cc6ba51d13	false	0xa8c1c38ff57428e5c3a34e0899be5cb385476507	4	9287292418221329270341	997101088489066	3647589	2025-01-17T20:33:20.000Z	0x0736bdf9191381c0d60d9abcd8e4c2b4945859ccfebe2c535c9f496e75b6d550
0x155da551c997175f5120076eccf8adcab8aa49d1	false	0xa8c1c38ff57428e5c3a34e0899be5cb385476507	5	10975125357900267736	129999999999999999988	3649547	2025-01-17T21:05:58.000Z	0x4a2a80f68307ce4c0586df57b1527eaec27233b14bd65c94b76b8e66a5acfb93

Example Query

Query with partition filter

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

Pair_Swap_event

Token swap events from decentralized exchange (DEX) liquidity pairs recording input and output amounts for both tokens. Primary source for tracking DEX trading activity and price discovery.

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_amount0In`	`STRING`	Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1In`	`STRING`	Amount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount0Out`	`STRING`	Amount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1Out`	`STRING`	Amount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	block_number	in_amount0In	in_amount1In	in_amount0Out	in_amount1Out	block_timestamp	transaction_hash
0x000000000006a4ae738bc2f1bb5675c720fbe3df	0xf32ce231a1ecf0fceeddda0d69d971c8de13a443	false	0x000000000006a4ae738bc2f1bb5675c720fbe3df	9	3834490	4507380864121738472605951	0	0	10808480273453	2025-01-20T00:28:21.000Z	0x999597850cc623a387b4324abdaa963e0c9be599dcca531075d48430eccf4393
0x578accaf5d5306edcdf1cd365b99b7669a8a858b	0x19e23f382a00529d24bcf3b6c70cc45ffe338b09	false	0x000000000006a4ae738bc2f1bb5675c720fbe3df	9	3918112	0	508760081865279861421	150006472751537159084	0	2025-01-20T23:42:03.000Z	0x409abdbbb9822ecdaba2cece9cd91849f0d129f3d23c16ff852ea26df33566c1
0x578accaf5d5306edcdf1cd365b99b7669a8a858b	0xfa50ac3c8b2bac45eb7a8e2fffdda9298b4a9282	false	0x000000000006a4ae738bc2f1bb5675c720fbe3df	6	3872069	577369053704505128559	0	0	47819913917315244456	2025-01-20T10:54:40.000Z	0xb4a18749c41494913ac2ed15ad0be3eab0f25ace4f8211f1d89d1268a164a345

Example Query

Query with partition filter

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

Pair_Sync_event

Liquidity pair reserve synchronization events emitted after each swap, mint, or burn operation. Contains updated reserve balances for both tokens in AMM (Automated Market Maker) pools, enabling real-time price calculation and liquidity tracking.

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_reserve0`	`STRING`	Reserve amount of the first token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.
`in_reserve1`	`STRING`	Reserve amount of the second token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.

Sample Data

address	removed	log_index	in_reserve0	in_reserve1	block_number	block_timestamp	transaction_hash
0x05407d2bcef84ebaedd54dba1c0a868e1686caa7	false	2	10022857401162294409	64716026199027091212899150	4089639	2025-01-22T23:20:50.000Z	0x0daa729c5e7e705da6362b611abd3e862ca34c908f595b913f0d10b941ef6d7c
0x05407d2bcef84ebaedd54dba1c0a868e1686caa7	false	2	10028144032816089833	64682011535736799971402692	4089641	2025-01-22T23:20:52.000Z	0x646c5c426cace2b312c8f3c761ec47d83b72f6f34a6c4a9732a32eb3ae439d97
0x05407d2bcef84ebaedd54dba1c0a868e1686caa7	false	2	10039483090691787625	64606343208075180450266623	4089261	2025-01-22T23:14:32.000Z	0xfe752b29c6ea25fabf10c1cd08d29a4afe1432e92ff6dce2612296d39d5c8ce6

Example Query

Query with partition filter

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

Pair_Transfer_event

ERC20 Transfer events emitted by liquidity pair contracts in automated market maker (AMM) decentralized exchanges (DEXs). Records minting, burning, and transfer of LP (liquidity provider) tokens representing ownership shares in trading pairs.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

in_to	address	in_from	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0xef9fdfaa4b48dba7e1e3a4c927341a417ea029ec	0x0501124a49e490680db092b96b0153e5b96198c6	0x0000000000000000000000000000000000000000	false	155207390443467811	16	4697058	2025-01-30T00:04:29.000Z	0x371b259908ace30db3883ea3dbe1a287cd278a7a3542b643605841a62bb0bd2b
0x0589e804cddc4ce56acfd7869286682a01971611	0x0501124a49e490680db092b96b0153e5b96198c6	0x0000000000000000000000000000000000000000	false	157207169343701176	17	4697058	2025-01-30T00:04:29.000Z	0x371b259908ace30db3883ea3dbe1a287cd278a7a3542b643605841a62bb0bd2b
0x0589e804cddc4ce56acfd7869286682a01971611	0x0501124a49e490680db092b96b0153e5b96198c6	0x0000000000000000000000000000000000000000	false	67100621061324879	3	4697938	2025-01-30T00:19:09.000Z	0xeb8bc6dc308f9d545f8ff8ba1bc85b0b80144aa3d29745d992103d478ad738bc

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PairCreated_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PairCreated_event

​Pair_Burn_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

Tables

Factory_PairCreated_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event