hashflow_v1_ethereum

Tables

Factory_PoolCreated_event

Factory contract event emitted when a new liquidity pool is created, recording token pairs and pool configuration parameters. Used for tracking DEX pool deployments and liquidity market 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_operations`	`STRING`	Contract address of the operations controller for the pool. Hex-encoded, 0x-prefixed, 42-character string.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_privPool`	`BOOL`	Indicates whether the newly created pool is a private pool with restricted access. True for private pools that require permission to trade, false for public pools open to all users.

Sample Data

address	in_pool	removed	log_index	in_privPool	block_number	in_operations	block_timestamp	transaction_hash
0x63ae536fec0b57bdeb1fd6a893191b4239f61bff	0x7249515c6c9173800de0e9a8d0fc667e13e887de	false	29	true	14073596	0x98c37cefb4193ce2ed107e7dec408a3276cf2e67	2022-01-25T08:11:07.000Z	0xb92e3df2d8ad09bf02cb9574cf6c27e1c851a8a73e1941d372fdad31eadae8d0
0x63ae536fec0b57bdeb1fd6a893191b4239f61bff	0x191295dca6de687d262b32d8e8005828b533ecb4	false	166	true	14074903	0x4894891cd3a0399724b0c74f8f81616849198c31	2022-01-25T13:02:34.000Z	0xa6ab7620faa9cccced6699a01012161422f0c176dab046fe029697b5e894de0a
0x63ae536fec0b57bdeb1fd6a893191b4239f61bff	0x22a0bb96541ea6d03553c858a6eb7ca1198b4968	false	154	true	14014187	0x428700e86c104f4ee8139a69ecdca09e843f6297	2022-01-16T03:52:13.000Z	0xc47c7722d7ff1ce64b1cb7d6b012d3974a79b790879ceb917c3891242ff3b623

Example Query

Query with partition filter

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

HashflowFactory_PoolCreated_event

Pool creation events from the Hashflow V1 factory contract on Ethereum, recording new liquidity pool deployments with their pool addresses, operations addresses, and privacy settings. Useful for tracking Hashflow pool launches and analyzing the growth of public versus private pools over time.

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_operations`	`STRING`	Contract address of the operations controller for the pool. Hex-encoded, 0x-prefixed, 42-character string.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_privPool`	`BOOL`	Indicates whether the newly created pool is a private pool with restricted access. Boolean flag is false for public pools accessible to all users, true for private pools.

Sample Data

address	in_pool	removed	log_index	in_privPool	block_number	in_operations	block_timestamp	transaction_hash
0xc11a1e6fde432df9467d6d1a5454b54a63b86c8c	0xfe895436dbbdf64930c4480136f851e41d7db948	false	57	false	14711478	0x0bf0e31ab9d32c7fd064afc710d98164d7cbb31d	2022-05-04T14:25:36.000Z	0x363ca9d7bd974f608349aca4d075e3d2fc803afae8a535347df3be7125fd1577
0xc11a1e6fde432df9467d6d1a5454b54a63b86c8c	0xe794ffecc16a8e5f5c7d7818322ba7fe41a63f72	false	122	true	14665053	0x5d2f2d966af70114903b341b3378379eef59cd27	2022-04-27T07:06:39.000Z	0x009df0e5f20443db0895884b93a7af6a474d5d203aaaa121f3259b9ecfdcd95f
0xc11a1e6fde432df9467d6d1a5454b54a63b86c8c	0x5e885af879c13b8413eb22adefa061f914347dec	false	303	true	15403646	0x2150dd462b496bd5e4a37b5411c13319427be83e	2022-08-24T15:19:46.000Z	0xc6795d5499e519b06e31150879d8d9af9a092cbc531c8e05171cc679c59902a4

Example Query

Query with partition filter

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

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
0x596d32f9b7c1f2e73f5071c66b5e336e27d00da4	0x1bc3a6147ca880f28d33b5c4ca6c6a210373d7c0	false	10	16685900	0x153d90ec37ffd88d700a656d0a27de08226d8272	true	2023-02-22T18:57:35.000Z	0x467cd12f9d7f8a36acdbe43eb9d870eec16d7ec71ab58efdf040bc55f0cc4fd3
0x596d32f9b7c1f2e73f5071c66b5e336e27d00da4	0x5e1fed30b85fcfcd725902bb5de0d50901faa70d	false	281	15863523	0x8f960152ff7f61a12af9bac01f2e1ce69f115819	true	2022-10-30T21:19:47.000Z	0xcd88a27dfc8b20f0de69c9627cd717c3504be6bbcf5cac62b74d8b53a4d85af0
0x596d32f9b7c1f2e73f5071c66b5e336e27d00da4	0x4306aefe6c0e605f22207a43203ae7d7e4fb42c9	false	263	17363490	0xfc68e9b0d3497db6dc1ce68d25d45315b8cc3076	true	2023-05-29T08:34:47.000Z	0x3e8e10654fa681a114131f22883a69ea0015a4b49bd03b1427d6be373e2ec6ae

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.hashflow_v1_ethereum.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
0x46c7ac58cff631cd57aeb249a1213dff062f146b	0x0067616e64616c6674686562726f776e67786d786e69001961223b4d91750000	false	0x8fecfddf796b39ff3d83ee217d19fa3c22f9f1ba	109	17485985	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0xdac17f958d2ee523a2206206994597c13d831ec7	2023-06-15T14:50:35.000Z	0x37f044a7b3e43ccd0fc65d0c1bc770d6960a4d8feea526c4a51badc5b7bc1f6a	26000000000000000000	42838216235
0x4ba77325aa4452602ceef86fee44df9cdb050289	0x0267616e64616c6674686562726f776e67786d786e6900196105752cf3530000	false	0xda63a326d2c3c09586676a036e79af2e3c524090	18	17485830	0xdac17f958d2ee523a2206206994597c13d831ec7	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	2023-06-15T14:19:11.000Z	0x1125f3da7e696a4885942de6ce4fa8871e659e777741ce84f2b857de5a252b8a	1900000000	7572007
0x4ba77325aa4452602ceef86fee44df9cdb050289	0x1067616e64616c6674686562726f776e67786d786e690019613a3986e39c0000	false	0xe789c5566b53546d46a0af48a4bd3f062d1fefd1	139	17486113	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0x4e15361fd6b4bb609fa63c81a2be19d873717870	2023-06-15T15:16:35.000Z	0x4c924ad571e9119e2fbcd89dfaa02b61f201289f44574f91cfddc948a61dd17c	500000000000000000	3222582985275393179648

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.hashflow_v1_ethereum.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
0x1bc3a6147ca880f28d33b5c4ca6c6a210373d7c0	0x0067616e64616c6674686562726f776e67786d786e69001aaee7414200240000	false	0xbaf11ff31528778efba48b692c1ae92850491db2	301	0x000000000000000000000000ed02cf21eb148fbf87f859efdf04b1c276858f73	17948181	0x0000000000000000000000000000000000000000	5	0xc2132d05d31c914a87c6611c10748aeb04b58e8f	2023-08-19T10:19:23.000Z	0x84bda4d42531bd9330fea71bfe915fe0388c26926f36f8a1a7a949152a91671b	70000000000000000	116385220
0x1bc3a6147ca880f28d33b5c4ca6c6a210373d7c0	0x0067616e64616c6674686562726f776e67786d786e69001ab0e6aca200240000	false	0x62604a3ea88c7c74168db8ac7d414ef9399f0d0f	358	0x000000000000000000000000ed02cf21eb148fbf87f859efdf04b1c276858f73	17950951	0x0000000000000000000000000000000000000000	5	0xc2132d05d31c914a87c6611c10748aeb04b58e8f	2023-08-19T19:38:11.000Z	0x3612dc3e2cc322eb7f05bec4515f68cab3c0009f1a127053d543251260e8e280	1000000000000	1679
0x1bc3a6147ca880f28d33b5c4ca6c6a210373d7c0	0x0067616e64616c6674686562726f776e67786d786e69001aae39cdcc00240000	false	0xfa15f74278466dcfba6a8efd2aa8e1b235bccce4	150	0x000000000000000000000000ed02cf21eb148fbf87f859efdf04b1c276858f73	17947243	0x0000000000000000000000000000000000000000	5	0xc2132d05d31c914a87c6611c10748aeb04b58e8f	2023-08-19T07:09:59.000Z	0x42bd5017d0750101b42f2e3c46a58ceebe3076d8151d7f31549d2dcdff9415c2	50000000000000000	82750150

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PoolCreated_event

HashflowFactory_PoolCreated_event

HashflowFactoryV2_CreatePool_event

PoolV2_Trade_event

PoolV2_XChainTrade_event

​Tables

​Factory_PoolCreated_event

​HashflowFactory_PoolCreated_event

​HashflowFactoryV2_CreatePool_event

​PoolV2_Trade_event

​PoolV2_XChainTrade_event

Tables

Factory_PoolCreated_event

HashflowFactory_PoolCreated_event

HashflowFactoryV2_CreatePool_event

PoolV2_Trade_event

PoolV2_XChainTrade_event