hashflow_v1_polygon

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
0x336bfba2c4d7bda5e1f83069d0a95509ecd5d2b5	0x9534ec3e9129b957982746a5e0deb554cfc67bf1	false	144	38544640	0x48586dbea5a0fded55030240f18ce461b5c12f7d	true	2023-01-26T10:11:18.000Z	0x7e65e05ff19a221a77d7b0f888089a7e5f750cfb002d4682fcc0493fd1b2cdba
0x336bfba2c4d7bda5e1f83069d0a95509ecd5d2b5	0xf81a4a0b10807afbff27dae6e2370ae661aa9aa4	false	29	38544627	0xa4cbfed769eda17eef7206e83d0e408bab3a70ce	true	2023-01-26T10:10:50.000Z	0xc70ddd398ebcf97020f68492f8739db9783b5ca71604eecf1de4fa69581fc907
0x336bfba2c4d7bda5e1f83069d0a95509ecd5d2b5	0xeb3ecdf9a792769c5a1d5f998f70f684e858d30c	false	64	34193700	0x6a04941de896e4215eeb8e6eb1b72ad2904d2402	true	2022-10-11T03:29:49.000Z	0x55f4654d23be429a4948b115f231dad9b9a220692d9428cf81dc403ad62c8ead

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.hashflow_v1_polygon.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
0x55443e8dffb64c5b2127f4211e79460a142cff02	0x0067616e64616c6674686562726f776e67786d786e6900190f010b83e69d0000	false	0xe7a7de1f190306c15b17dab9bd770e5c025fbf36	46	43333605	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0xc2132d05d31c914a87c6611c10748aeb04b58e8f	2023-05-30T16:05:22.000Z	0x1e5db294407528b9eab3f27a78e9da9d8278db3ad36496117d7f94bf51c3ffaa	100000	99957
0x55443e8dffb64c5b2127f4211e79460a142cff02	0x0267616e64616c6674686562726f776e67786d786e6900190ca73dc7e69d0000	false	0xb97cd69145e5a9357b2acd6af6c5076380f17afb	265	43315445	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0x7ceb23fd6bc0add59e62ac25578270cff1b9f619	2023-05-30T05:08:18.000Z	0xc7f0e0692da4689b68c482bc7dde1db9c13bb53ce21b604ecd3bc4d75f041a41	100000000	52650842376871800
0x55443e8dffb64c5b2127f4211e79460a142cff02	0x0267616e64616c6674686562726f776e67786d786e690019104134a8a6360001	false	0x56f9c3982925f3867b1636d4aeb9ca63c9f7b2e3	27	43343305	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0xc2132d05d31c914a87c6611c10748aeb04b58e8f	2023-05-30T21:55:00.000Z	0xde2c90c26a5491446b66e055844669fbd975fff2130dece8294f83f58dedd313	100000000000000000000	90243209

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.hashflow_v1_polygon.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
0x5bbe4ab57b924f6876b992e141bf8766b5441421	0x0067616e64616c6674686562726f776e67786d786e6900155adb182d94d10000	false	0x280620432b2e30a9ee9a5c54c177a23f4651f4a6	15	0x000000000000000000000000d8e13e0e1169f116ea707a4a40455a49a96586e1	36133164	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	1	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	2022-11-27T13:24:01.000Z	0xaf738b7c20f453c76dda06541e439bb31a764b4b7b069b2bcfabb6f05d0ecab2	505000000	504666995
0x5bbe4ab57b924f6876b992e141bf8766b5441421	0x0067616e64616c6674686562726f776e67786d786e6900155aec69f594d10000	false	0x1343c26670625503b33ac805b81e94f2e0bc8c2e	102	0x000000000000000000000000e45c838553c3f3d0ce5e67bf8a6ec8fcfa153c46	36133712	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	4	0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664	2022-11-27T13:42:53.000Z	0xded21dc92992b5a32ea9f43bc8b18b69d116228af75a687e307790210d963508	78657858	78620520
0x5bbe4ab57b924f6876b992e141bf8766b5441421	0x0067616e64616c6674686562726f776e67786d786e6900155befa24a94d10000	false	0xd0bbaa08f0a9a8a18866d8dd7ea74b45c7570671	139	0x000000000000000000000000e45c838553c3f3d0ce5e67bf8a6ec8fcfa153c46	36141257	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	4	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	2022-11-27T18:25:56.000Z	0x911913a2bec902262eb06fa2693f79415186822e77e68ffd733c8da12677a953	1700000	1699065

Example Query

Query with partition filter

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