hashflow_v1_avalanche

Tables

HashflowFactoryV2_CreatePool_event

Pool creation events emitted by Hashflow V2 factory contracts. Records the deployed pool address, associated operations contract, and privacy status for tracking liquidity pool initialization.

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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_operations`	`STRING`	Contract address of the operations controller for the pool. Hex-encoded, 0x-prefixed, 42-character string.
`in_privatePool`	`BOOL`	Boolean flag indicating whether the pool is restricted to authorized participants or publicly accessible.

Sample Data

address	in_pool	removed	log_index	block_number	in_operations	in_privatePool	block_timestamp	transaction_hash
0x05fb0089bec6d00b2f01f4096eb0e0488c79cd91	0x7a2428c8a108a02e36408098171b7fd5234cc570	false	2	20916059	0x424be4e9295e1917971f2080aea11ac2f960c731	true	2022-10-11T06:14:33.000Z	0x65627fa7161d032d850a4e054ca168079991f8caed965c25acc68be083c8918c
0x05fb0089bec6d00b2f01f4096eb0e0488c79cd91	0x17e85ca901629709112a35c46e9872fc14d5912c	false	2	20911491	0x6a04941de896e4215eeb8e6eb1b72ad2904d2402	true	2022-10-11T03:37:06.000Z	0x65b7a2373c3b6df43ed8e18d3884854f30b7add41fb43a1da516eb29e1a17502
0x05fb0089bec6d00b2f01f4096eb0e0488c79cd91	0xe45c838553c3f3d0ce5e67bf8a6ec8fcfa153c46	false	2	20949185	0xe68ca421f6fc38ebf9643644adde654f5cc59a4c	false	2022-10-12T01:09:31.000Z	0x8f6599b43eba1432044be1a1079eb9b22eabe799e021b42b4f0198f0d940a53e

Example Query

Query with partition filter

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

PoolV2_Trade_event

Trade execution events from Hashflow PoolV2 contracts containing trader address, base/quote token addresses, exchange amounts, and protocol transaction identifier. Used for tracking DEX swap activity and volume analytics across Request-for-Quote (RFQ) based trades.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_txid`	`STRING`	Unique identifier for the trade operation within the Hashflow protocol. 66-character hex string including 0x prefix.
`in_baseToken`	`STRING`	Contract address of the base token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_quoteToken`	`STRING`	Contract address of the quote token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_baseTokenAmount`	`STRING`	Amount of base tokens involved in the operation. String-encoded integer representing the token quantity in its smallest denomination.
`in_quoteTokenAmount`	`STRING`	Amount of quote tokens involved in the operation. String-encoded integer representing the token quantity in its smallest denomination.

Sample Data

address	in_txid	removed	in_trader	log_index	block_number	in_baseToken	in_quoteToken	block_timestamp	transaction_hash	in_baseTokenAmount	in_quoteTokenAmount
0x7a2428c8a108a02e36408098171b7fd5234cc570	0x2867616e64616c6674686562726f776e67786d786e69001a14fa26f92dc10000	false	0xc590175e458b83680867afd273527ff58f74c02b	20	32848071	0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7	0x0000000000000000000000000000000000000000	2023-07-20T12:58:16.000Z	0x7fd4f8ee5a8191508a0da5d90699020d7669d4180db19d9e0d88a718f6e32c99	2000000	140732484434000000
0x7a2428c8a108a02e36408098171b7fd5234cc570	0x0067616e64616c6674686562726f776e67786d786e69001a16992ebd79670000	false	0x77ece26552523e4be93037e871db25d2d33db9a9	19	32861538	0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7	0x0000000000000000000000000000000000000000	2023-07-20T20:31:38.000Z	0x514f6728509ed5561ccfc346bc7362e3b03b958985b89b703704240ae7377535	2300000	166775143020399968
0x7a2428c8a108a02e36408098171b7fd5234cc570	0x0067616e64616c6674686562726f776e67786d786e69001a151c733d2dc10000	false	0x8446fe588dd81865fa837ee2ab6edfb3d31fa8f4	15	32849180	0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7	0x0000000000000000000000000000000000000000	2023-07-20T13:35:45.000Z	0xeb74211c93f3935421f8287c6a72f588e392e2ddee21a5cf29480f5032069c4d	1420862	99769938090364688

Example Query

Query with partition filter

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

PoolV2_XChainTrade_event

Cross-chain trade events from Hashflow Protocol V2 pools containing token swap parameters and destination chain routing information. Records trader address, base and quote token addresses with amounts, destination chain ID (LayerZero), destination pool address, and protocol-specific transaction identifier for tracking bridge transfers across blockchain networks.

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_dstChainId`	`STRING`	Destination chain identifier for cross-chain operations. String-encoded integer representing the target blockchain in LayerZero’s chain ID system.
`in_dstPool`	`STRING`	Contract address of the destination pool for cross-chain trades. Hex-encoded, 66-character string with 24 leading zeros before the pool address.
`in_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_txid`	`STRING`	Unique identifier for the trade operation within the Hashflow protocol. 66-character hex string including 0x prefix.
`in_baseToken`	`STRING`	Contract address of the base token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_quoteToken`	`STRING`	Contract address of the quote token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_baseTokenAmount`	`STRING`	Amount of base tokens involved in the operation. String-encoded integer representing the token quantity in its smallest denomination.
`in_quoteTokenAmount`	`STRING`	Amount of quote tokens involved in the operation. String-encoded integer representing the token quantity in its smallest denomination.

Sample Data

address	in_txid	removed	in_trader	log_index	in_dstPool	block_number	in_baseToken	in_dstChainId	in_quoteToken	block_timestamp	transaction_hash	in_baseTokenAmount	in_quoteTokenAmount
0xe45c838553c3f3d0ce5e67bf8a6ec8fcfa153c46	0x0967616e64616c6674686562726f776e67786d786e690016f2859dca98d00000	false	0xfcad316549d9dea45cc91a56d72a23485fee9a38	42	0x0000000000000000000000005bbe4ab57b924f6876b992e141bf8766b5441421	26255103	0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664	5	0xc2132d05d31c914a87c6611c10748aeb04b58e8f	2023-02-14T17:15:26.000Z	0x25054c8cc4292f129363eb626d799e0b970f852e4e5c347a68b10fad2177ec15	102324263	102158862
0xe45c838553c3f3d0ce5e67bf8a6ec8fcfa153c46	0x0067616e64616c6674686562726f776e67786d786e690016f3ee5d3427d20000	false	0x0087ab85c2af7dfaa677c0a53fcc9fd9f22e8b41	14	0x000000000000000000000000ff20c5c4d31c3f9decbcdc4aea9f396b36255843	26266729	0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7	6	0x55d398326f99059ff775485246999027b3197955	2023-02-14T23:49:39.000Z	0xe6d8056599931e8b370414d21537394525a0cd756a4300d03c6c3807b150a544	89936852	89841576939531175330
0xe45c838553c3f3d0ce5e67bf8a6ec8fcfa153c46	0x0067616e64616c6674686562726f776e67786d786e690016184bea9b2d020000	false	0x8e547006ba6f3305ff0a32390bdacb524115e936	4	0x000000000000000000000000ff20c5c4d31c3f9decbcdc4aea9f396b36255843	24457909	0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7	6	0x55d398326f99059ff775485246999027b3197955	2023-01-03T08:15:26.000Z	0x626dd7872bf5c4f7fe6244db214a98e2e29f9d2887a815be54f4cd182cdff9b7	100000000	99954449128733171682

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

HashflowFactoryV2_CreatePool_event

PoolV2_Trade_event

PoolV2_XChainTrade_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​HashflowFactoryV2_CreatePool_event

​PoolV2_Trade_event

​PoolV2_XChainTrade_event

Tables

HashflowFactoryV2_CreatePool_event

PoolV2_Trade_event

PoolV2_XChainTrade_event