hashflow_v1_arbitrum

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
0xe43632337d3f9a52ffd098fe71a57cc5961c041f	0x58a17639d60131d6c490c8bf8f35fb6a2ef3f110	false	2	30601191	0xe68ca421f6fc38ebf9643644adde654f5cc59a4c	false	2022-10-17T13:49:57.000Z	0x3a18725f4ee62aacf0433b2594bc59769b1715e73a37da282e12e6ea3a826051
0xe43632337d3f9a52ffd098fe71a57cc5961c041f	0xdd1fd9c6bd6613873396a6995a5ce856feae461c	false	2	62757996	0xa4cbfed769eda17eef7206e83d0e408bab3a70ce	true	2023-02-20T12:31:17.000Z	0x5e83b68c81458080821e9996389cf112882346d7c7c85871bcb34c548226727a
0xe43632337d3f9a52ffd098fe71a57cc5961c041f	0x26999fce35de4c374411cf2a00441e961c90ebc0	false	2	107075037	0x111bb8c3542f2b92fb41b8d913c01d3788431111	true	2023-07-02T09:28:55.000Z	0xf8af8fe47be533280db6ff29a97f7bff98d46809d053abc67a76b4e32f0d8c7b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.hashflow_v1_arbitrum.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
0xb5c23bcdccd7b1fe93385387fa539d123f243ec8	0x0067616e64616c6674686562726f776e67786d786e69001572f1cb147ccb0000	false	0xcb0d2c2730e26e917400bb0ef7c8cfb8469136f9	2	42894083	0x0000000000000000000000000000000000000000	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	2022-12-02T05:39:33.000Z	0xc60346dda478bc36beeccc8112d97d17465496fe509552146fdd2f26731de304	786440541	1
0xb5c23bcdccd7b1fe93385387fa539d123f243ec8	0x0567616e64616c6674686562726f776e67786d786e69001574650d9c7e450000	false	0xf66b8965260cb265ddf6bffe70a3da9243b72bad	2	42978400	0x0000000000000000000000000000000000000000	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	2022-12-02T12:25:09.000Z	0x5a79c0ffab4ab215fb91a15aa919641c477f8f2f576e5fc163ea6d1892876a48	1000000000000	1288
0xb5c23bcdccd7b1fe93385387fa539d123f243ec8	0x0067616e64616c6674686562726f776e67786d786e69001573f735177e450000	false	0x7eb493137b6dcfacc7be5cad2c9268564573148d	2	42952614	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	2022-12-02T10:25:17.000Z	0xdb5bef41d8f6fff6ad0e5bb325ec382734e6ef450fdb8b3001a6e4c562267178	10000	9999

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

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