Skip to main content

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_token0STRINGContract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
in_token1STRINGContract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
in_feeSTRINGFee 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_tickSpacingINT64Minimum price movement increment between adjacent ticks in a concentrated liquidity pool.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
in_feeaddressin_poolremovedin_token0in_token1log_indexblock_numberin_tickSpacingblock_timestamptransaction_hash
5000x56c2162254b0e4417288786ee402c2b41d4e181e0x6ef05507ccccc97bb676ffc303045e7a07350801false0xcd91716ef98798a85e79048b78287b13ae6b99b20xf417f5a458ec102b90352f697d6e2ac3a3d2851f17790625102023-12-09T13:56:49.000Z0xcf14003caae0c727a9cf2af55347c3eeaadae756acb4111de50b91f37dea7acf
1000x56c2162254b0e4417288786ee402c2b41d4e181e0x897595b108aaaf7f8633799ddaff1ab27a6d9fcefalse0x0dc808adce2099a9f62aa87d9670745aba7417460x20a512dbdc0d006f46e6ca11329034eb3d18c997388728712023-12-20T18:27:09.000Z0x48cd729fb2dcaa575915bc2b56fa6598289e9226e28391c789f9975634695f92
30000x56c2162254b0e4417288786ee402c2b41d4e181e0xfdfffb25aae3d402ce1089658c2cc3207138efdcfalse0x0dc808adce2099a9f62aa87d9670745aba7417460xcd5d6de3fdbce1895f0dac13a065673599ed68063885810602023-12-20T14:20:59.000Z0xed5a0b9fbcb076c714a41e6470e187cb7c3b57b36ff01ed8dcb61539319a66d2
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