hashflow_v1_optimism

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
0x246d44b1221e44930b207a1a7e235b616c465158	0xa1399135768e4ffb247dcb3c92146c4956a2f329	false	2	28610350	0x6a04941de896e4215eeb8e6eb1b72ad2904d2402	true	2022-10-11T03:38:10.000Z	0xf32797ff99f98a412216c940eb9f30180a743f301bb7a2098918bf32784c68ad
0x246d44b1221e44930b207a1a7e235b616c465158	0xeaf4e9cd685f346c6380678852d4de3ca4a9a693	false	2	71657142	0x715dd7265661a8b7745636be1d6747c70e895c8c	true	2023-02-01T15:54:20.000Z	0x2c0c20356b5190ffe507e4442a0ae5c770404bb9b2814541d9971c23d0bf9989
0x246d44b1221e44930b207a1a7e235b616c465158	0x3b789208b1294706d96c27d2cef3e86a3508bf85	false	2	71656050	0x715dd7265661a8b7745636be1d6747c70e895c8c	true	2023-02-01T15:49:20.000Z	0xb1f39aaad7673c1b39623bc01108ced0ca8ac1defc52ff61151a7f53d0965df0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.hashflow_v1_optimism.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
0x9b36962c3b2fb8e4a329d3f5aaa50e5991cf332e	0x0067616e64616c6674686562726f776e67786d786e690015d9533b6050210000	false	0x14d15f15f1151d82e0aa5f2443b7da68f981424c	2	53232402	0x7f5c764cbc14f9669b88837ca1490cca17c31607	0x94b008aa00579c1307b0ef2c499ad98a8ce58e58	2022-12-22T02:47:11.000Z	0xde245ae5bcf193050feccf57c218f9319921a65777c69ada9053e7590f62f045	2000000000	1999657604
0x9b36962c3b2fb8e4a329d3f5aaa50e5991cf332e	0x0067616e64616c6674686562726f776e67786d786e690015d91ce7ed50210000	false	0x5805ec51c516e3aa9907d2dbffea7f267b1baa23	2	53212074	0x7f5c764cbc14f9669b88837ca1490cca17c31607	0x94b008aa00579c1307b0ef2c499ad98a8ce58e58	2022-12-22T01:47:54.000Z	0x9a67a6dfcb776083730a4b8ace4f96d91abb0b0c002e5501c8f931b5cf74e84f	1139540285	1139378614
0x9b36962c3b2fb8e4a329d3f5aaa50e5991cf332e	0x0067616e64616c6674686562726f776e67786d786e690015d91f418950210000	false	0x5805ec51c516e3aa9907d2dbffea7f267b1baa23	1	53212754	0x94b008aa00579c1307b0ef2c499ad98a8ce58e58	0x7f5c764cbc14f9669b88837ca1490cca17c31607	2022-12-22T01:50:24.000Z	0xcaaa0e83d49dd80b280b170e3d85182990b38a053b4c91d1e647a8828c584a36	1139378614	1139312400

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.hashflow_v1_optimism.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
0x2c6d381d80fbf86cc747724e67f15a871dd776b0	0x0067616e64616c6674686562726f776e67786d786e690015811bf391c3da0000	false	0x2150dd462b496bd5e4a37b5411c13319427be83e	4	0x0000000000000000000000008c9ce945bf0db0a16dcfd293f1b53dd64beb8121	45451347	0x0000000000000000000000000000000000000000	5	0x7ceb23fd6bc0add59e62ac25578270cff1b9f619	2022-12-04T23:40:07.000Z	0xd2778075c97986df55ebdd48fe428edefde8f4e836be5c16f97bae0b6f3d82c5	20000000000000000	19990000000000000
0x2c6d381d80fbf86cc747724e67f15a871dd776b0	0x0067616e64616c6674686562726f776e67786d786e690015811994f0c3da0000	false	0x2150dd462b496bd5e4a37b5411c13319427be83e	4	0x000000000000000000000000ffe842f6789cdc75b7ae8a447bae9e9a4443ff15	45450911	0x0000000000000000000000000000000000000000	1	0x0000000000000000000000000000000000000000	2022-12-04T23:37:34.000Z	0x781553ddd704e397941af389441af1093ca5a80eab868bc8bb48ede7cd2fd4e7	10000000000000000	9995000000000000
0x2c6d381d80fbf86cc747724e67f15a871dd776b0	0x0067616e64616c6674686562726f776e67786d786e69001720c48160ea8c0000	false	0x82c80d0a27c17027d21f7bcc9ba10b12ca65e3e3	4	0x0000000000000000000000008c9ce945bf0db0a16dcfd293f1b53dd64beb8121	76335062	0x0000000000000000000000000000000000000000	5	0x7ceb23fd6bc0add59e62ac25578270cff1b9f619	2023-02-23T16:46:47.000Z	0xdf0f327e5f8ddaa60c77cb8e6137e2e059903983aff82f517822d05cd9c8dcb5	60000000000000000	59970000000000000

Example Query

Query with partition filter

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