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
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_token0 | STRING | Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string. |
in_token1 | STRING | Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string. |
in_fee | STRING | Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency. |
in_tickSpacing | INT64 | Minimum price movement increment between adjacent ticks in a concentrated liquidity pool. |
in_pool | STRING | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string. |
Sample Data
Sample Data
| in_fee | address | in_pool | removed | in_token0 | in_token1 | log_index | block_number | in_tickSpacing | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|
| 500 | 0x56c2162254b0e4417288786ee402c2b41d4e181e | 0x6ef05507ccccc97bb676ffc303045e7a07350801 | false | 0xcd91716ef98798a85e79048b78287b13ae6b99b2 | 0xf417f5a458ec102b90352f697d6e2ac3a3d2851f | 17 | 790625 | 10 | 2023-12-09T13:56:49.000Z | 0xcf14003caae0c727a9cf2af55347c3eeaadae756acb4111de50b91f37dea7acf |
| 100 | 0x56c2162254b0e4417288786ee402c2b41d4e181e | 0x897595b108aaaf7f8633799ddaff1ab27a6d9fce | false | 0x0dc808adce2099a9f62aa87d9670745aba741746 | 0x20a512dbdc0d006f46e6ca11329034eb3d18c997 | 3 | 887287 | 1 | 2023-12-20T18:27:09.000Z | 0x48cd729fb2dcaa575915bc2b56fa6598289e9226e28391c789f9975634695f92 |
| 3000 | 0x56c2162254b0e4417288786ee402c2b41d4e181e | 0xfdfffb25aae3d402ce1089658c2cc3207138efdc | false | 0x0dc808adce2099a9f62aa87d9670745aba741746 | 0xcd5d6de3fdbce1895f0dac13a065673599ed6806 | 3 | 885810 | 60 | 2023-12-20T14:20:59.000Z | 0xed5a0b9fbcb076c714a41e6470e187cb7c3b57b36ff01ed8dcb61539319a66d2 |
Example Query
Example Query
Query with partition filter
SELECT *
FROM `tt-contracts.quickswap_v1_manta.Factory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100