compound_v3_unichain

Tables

Configurator_CometDeployed_event

Compound V3 Configurator deployment events recording when new Comet implementation contracts are deployed and linked to proxy contracts. Contains addresses for both the newly deployed Comet implementation and its corresponding proxy, enabling tracking of protocol upgrades and deployments.

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_cometProxy`	`STRING`	Contract address of the Comet proxy being deployed or upgraded. Hex-encoded, 0x-prefixed, 42-character string.
`in_newComet`	`STRING`	Contract address of the new Comet implementation being deployed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_newComet	block_number	in_cometProxy	block_timestamp	transaction_hash
0x8df378453ff9deffa513367cdf9b3b53726303e9	false	6	0x0f4b00bb486ecf317bb2b735ef90c0e4c702741a	9170528	0x2c7118c4c88b9841fcf839074c26ae8f035f2921	2025-02-18T22:48:07.000Z	0x870d98a635826264e29b9fcbbcd8b14dda65a580db35aa6f9c9d260e25315923
0x8df378453ff9deffa513367cdf9b3b53726303e9	false	24	0x6bad2334e987106f40c50c7942d794b4e09edfc5	16687383	0x2c7118c4c88b9841fcf839074c26ae8f035f2921	2025-05-16T22:49:02.000Z	0x00bcb3fb7d2c12fc5004eb6280e6c1e5cb5d1f91db32d58513d38135e44915da
0x8df378453ff9deffa513367cdf9b3b53726303e9	false	8	0xdc02b1d2182b7fc5755d491c5bac7954fbfaf8de	16166411	0x6c987dde50db1dcdd32cd4175778c2a291978e2a	2025-05-10T22:06:10.000Z	0xf3c618fa38a68396317f8aa2c89a4cacd079f617089385cb4b5789a1a0f9e9bf

Example Query

Query with partition filter

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

compound_v3_polygon compoundforks_v2_base

⌘I

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Configurator_CometDeployed_event

​Tables

​Configurator_CometDeployed_event

Tables

Configurator_CometDeployed_event