hashflow_v1_bsc

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
0xb5574750a786a37e300a916974ecd63f93fc6754	0x2d9db645a8f645e53a17939eec41d7b786238e03	false	210	23110063	0x153d90ec37ffd88d700a656d0a27de08226d8272	true	2022-11-16T16:50:06.000Z	0x77d8e0eafda2c022ae9868bad590ccceb9f47d32f744efb225a38a8f7e31150f
0xb5574750a786a37e300a916974ecd63f93fc6754	0xbbb9847d6f619756b1475ae09ba1a3cfdbbd8b89	false	204	27082403	0x4894891cd3a0399724b0c74f8f81616849198c31	true	2023-04-05T11:11:37.000Z	0x3a49b8a497a1153559f459f3e44e8156f3331f13a941b6f281772b2614eb9f4d
0xb5574750a786a37e300a916974ecd63f93fc6754	0xa97a7a07e063bb812e1ae22a98a18d1dbb5176f4	false	101	22633548	0x8f960152ff7f61a12af9bac01f2e1ce69f115819	true	2022-10-30T21:16:33.000Z	0xd9670464477e5b2b8d82c9aca8a8d67a247b571f5684383da94524219b7b4f33

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.hashflow_v1_bsc.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
0x75cd1617bb1bd1ec0fea557c192f7736dad83780	0x0467616e64616c6674686562726f776e67786d786e690016c109d51fd1870000	false	0xdec876911cbe9428265af0d12132c52ee8642a99	69	25392023	0x55d398326f99059ff775485246999027b3197955	0x0000000000000000000000000000000000000000	2023-02-05T02:38:56.000Z	0x742b19b19fc6fff5f51d88b8a770a7c4b07cc84fda617c2e1f933ce155bf46fc	6000000000000000000	18123263564809696
0x7286f5be4e531f6ea7660c739108d95aa2fef959	0x0267616e64616c6674686562726f776e67786d786e690016c337796a256e0000	false	0x7f9e3430880580713b03670046c7e89a0a91403b	12	25404017	0x55d398326f99059ff775485246999027b3197955	0x0000000000000000000000000000000000000000	2023-02-05T12:48:00.000Z	0xc855c0f9e10ab501a66d79664aca7a1a4cb96489997a26be5cb1962a06169d42	154980306959353440223	466088910048328549
0x75cd1617bb1bd1ec0fea557c192f7736dad83780	0x0067616e64616c6674686562726f776e67786d786e690016c3d1677f97390000	false	0xe4319c445c5641c890791cfdbae872cff7b62600	162	25407326	0x55d398326f99059ff775485246999027b3197955	0x0000000000000000000000000000000000000000	2023-02-05T15:36:11.000Z	0xc3a9565f0c4633f0336e32a2100072a0750913e9758bb06ebdc20ed665a08aec	10000000000000000000	30528245495938980

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.hashflow_v1_bsc.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
0x87ae7acaae8c2ef61f9a8c5017f25f1a4b3dc86b	0x0067616e64616c6674686562726f776e67786d786e69001812f36b32f5060000	false	0x64177643cf0e8e96dd0205983aadeafbd871dfc9	131	0x0000000000000000000000001bc3a6147ca880f28d33b5c4ca6c6a210373d7c0	27260715	0x55d398326f99059ff775485246999027b3197955	1	0x0000000000000000000000000000000000000000	2023-04-11T17:26:19.000Z	0x6a39c2d96320a833afaa06afa2439998a3fe56d9b920afa052c935d08b48c6c2	94936900000000000000	49946999500093057
0xff20c5c4d31c3f9decbcdc4aea9f396b36255843	0x0067616e64616c6674686562726f776e67786d786e6900160bd621582d020000	false	0xb425b695b6c133b48fbc345e1c0d44f21de4e785	147	0x000000000000000000000000d8e13e0e1169f116ea707a4a40455a49a96586e1	24391482	0x55d398326f99059ff775485246999027b3197955	1	0xdac17f958d2ee523a2206206994597c13d831ec7	2022-12-31T22:11:25.000Z	0xc4b95eade3eff47363b6769f73b2f6045499f5ae92a7acc3ba4d227da1d3416b	96537817155000008704	96480929
0xff20c5c4d31c3f9decbcdc4aea9f396b36255843	0x0067616e64616c6674686562726f776e67786d786e6900160a12aeec2d020000	false	0xebedce5c5b720a4b28357b2316cc499bec56a9ee	90	0x000000000000000000000000d8e13e0e1169f116ea707a4a40455a49a96586e1	24381742	0x55d398326f99059ff775485246999027b3197955	1	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	2022-12-31T13:58:21.000Z	0x1374d52920d1fa9e43d1260aa4a2f5911abb70eeb25399cc0b3afe9a6a0f75eb	995761994704086056063	994632792

Example Query

Query with partition filter

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