baryon_v2_viction

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
0xfe48a2e66ee2f90334d3565e56e0c9d0081447e8	0x91fc5458849d081fe9cad6bf888c58be59545a23	false	89	0x81ff373139f243977e683a68bd328a74615742db	0xc054751bdbd24ae713ba3dc9bd9434abe2abc1ce	1	78589858	2024-04-17T20:17:00.000Z	0xb10efff68b298c9a55e0553579b152071bae7b484a2017f7708ac2013d659280
0xfe48a2e66ee2f90334d3565e56e0c9d0081447e8	0xb0dd185277b4c76cb8f550bfb421380940650a33	false	88	0xa8ddf7389924a700f3f483730e85c993ffbe8452	0xc054751bdbd24ae713ba3dc9bd9434abe2abc1ce	1	78583019	2024-04-17T16:04:56.000Z	0x0deeb248459100759d44a72d49589a1ff25cf7c79d47d5a3a8320718b48b397e
0xfe48a2e66ee2f90334d3565e56e0c9d0081447e8	0x07262b1ff028fea0aa2b01a0bf91ce10b4efa11c	false	90	0x8103bb77ed2035b5da9a3a65d9c313cb6ee41dbd	0xc054751bdbd24ae713ba3dc9bd9434abe2abc1ce	7	78593159	2024-04-17T22:15:52.000Z	0x4511fa1470dd841c94bd575133dc3d6997d03eb31cb221cab3158a5d59942c3d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.baryon_v2_viction.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
0x9a07e483cd8c6b7cd621b65ac5466ff34d754957	0xdd685bb1bd52a54cc1b50248e801356e6c07175d	false	0x9a07e483cd8c6b7cd621b65ac5466ff34d754957	6	9509255324309296870	1911143351036154	73438585	2023-12-12T14:38:39.000Z	0x265f71b33df47459f9fcd41c950c8c38774493e835f6a1440784295f0982dfb3
0x1a0a0dcff85672131d241888dbf4c24fec69513e	0x5f3a2c62c298fee372d1b243390f32f063e8b8eb	false	0x063b706c0e1e0aa83ae6cc237e9c0780fa784d83	6	12833381573281847	50691515391991995885	90590244	2025-02-18T15:59:46.000Z	0x02cb23646285b0cdfcb19784b6fea479423a8dd6c5ce0d66244352ce92c14895
0xaf80785aa3819f4681bb883ebc64eff3ed582522	0x3d67d097bb013d18d74a272dada6e5f25744ee25	false	0x063b706c0e1e0aa83ae6cc237e9c0780fa784d83	6	99999999999990000	999999999999900	90575124	2025-02-18T06:50:11.000Z	0x535336d56c4c46837369c58b183ce07206ddb3896b89b68bef094067980e876b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.baryon_v2_viction.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
0xa2ada382c4967117ea84ee702082ae14244a6cb2	false	0x063b706c0e1e0aa83ae6cc237e9c0780fa784d83	13	117000330958705230000	3491150040999999196761	75941383	2024-02-12T01:02:29.000Z	0x5adbf045c3b1e71cc4e4ad142fff918f1acb61d81615391cf0113794488a5708
0xc6ccf9e10401d069b56b1ad2990cae29c9622bac	false	0x7bd3af01619a729f963edc6df2893652a2a0989e	17	1000000000000000000	960000000000	88273982	2024-12-20T08:57:06.000Z	0x6b11e07a373888a76ee06ae0f4217740d3566d7fac14bdc1b7a5d76334908ed4
0xee5b638af41641251c294d57321247564b199246	false	0x063b706c0e1e0aa83ae6cc237e9c0780fa784d83	10	200089156312266	19999999999999998	88291971	2024-12-20T19:57:40.000Z	0xee1e061748ea0af88ff66f434f10483dae3bb95f6ed98f3f3f4b9295c930fa59

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.baryon_v2_viction.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_amount1Out	block_timestamp	transaction_hash
0x950d0273acd1e4810e84723dcd368bb49ecbf2da	0xa2ada382c4967117ea84ee702082ae14244a6cb2	false	0x063b706c0e1e0aa83ae6cc237e9c0780fa784d83	5	84490380	4000000000000000000000	313561363332228984616133	2024-09-15T21:12:05.000Z	0x36df7467239f07975e4b2e99ca5c9c1a165f8e8f812eeb3403efde2a6fe86443
0x0fe183babc16456c1a47592a64d05d3eabb62433	0xb8d2a9a988a413970dff7066bf7b8a170d12ee05	false	0x90ff92592ee0bee0caaa3ccca5dd718b32dba96c	4	86947626	691453365512392068207104	5243137464626769939	2024-11-17T10:19:11.000Z	0x041a6395cc693aa11d87d273c0885558167620f409a22a024676ac173d8f1ff5
0x87453093f18420eed8bb19ac185d7053bf8cfabd	0xb8d2a9a988a413970dff7066bf7b8a170d12ee05	false	0x90ff92592ee0bee0caaa3ccca5dd718b32dba96c	4	86934264	4682088249118167833361726	28683224517906495897	2024-11-17T02:26:30.000Z	0xa51f81754daa62c6fe85104cd5f6efc1a5d64d3a5d4182a6ce6b5f9d1a7239e3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.baryon_v2_viction.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
0x8c37c63f19f69199b077789471f1d9893caf0c82	false	5	2060352192095278227462	157114962369261707600830992600002	72973432	2023-12-01T07:58:49.000Z	0x55fb7f65dd58a7de67e3241e8fa45d2f3c1d8a8b6558de3fdff2e4c2daddd201
0x5128d86f1aec0af304a8bdf3279db5a7642d4fd6	false	4	745013288001301304834	361241547655325433271899606221432	72978675	2023-12-01T11:02:45.000Z	0xad91e9c1563c72562e9d94098800ce75660f472cfb9ba1642d965cde4a7240bd
0xd0b032c5d8dae291e55c5d4d5129dd793e3e8be3	false	7	309993844722217397046	44267007929236137912	72978686	2023-12-01T11:03:07.000Z	0x7162bc1cf22451f6f3e2274cbde6f5e8cf569d2ba0c9eb3591c1dc509f512705

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.baryon_v2_viction.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
0x5a6f59e9a43dcb0cd989e5f3224ad81dbfefb229	0xa2ada382c4967117ea84ee702082ae14244a6cb2	0x0000000000000000000000000000000000000000	false	557273249514799828543	11	77300815	2024-03-16T14:43:46.000Z	0x7bb238cd88586979c489aa515db9fecd353a91eac18735ef8e32a2fcf8d850c6
0xc50ceb622ce62d8568c0fb9ac5ca2c796968f5b9	0x2af2d47978191a1b3ade42e1472f206f194548c1	0x0000000000000000000000000000000000000000	false	34415822247176	7	84658314	2024-09-20T07:59:08.000Z	0xa0f4d20eae3dffbb2159d93e47dd63266ce7afd2db5dd6f82deb1dc1094a5ccf
0xfa10f98acae7aedb267cad43e0d4738dcc085d65	0xbed32fb3272eb319428fc95867bd9c0a5f5c4c71	0x0000000000000000000000000000000000000000	false	27734106962383648667	5	84665197	2024-09-20T14:00:47.000Z	0xd51b50182805e0fdb7cd62312bb516cd6e273a4bb5396d1e23e2baf4417ecc51

Example Query

Query with partition filter

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