compound_v3_optimism

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
0x84e93ec6170ed630f5ebd89a1aae72d4f63f2713	false	2	0x23da01a00c6e25acf2f6c42f677212bc9ec5011f	124858730	0xe36a30d249f7761327fd973001a32010b521b6fd	2024-09-02T22:30:37.000Z	0xea747dba9df22ba03d32acfb05040495c270944f9673107bf88ea60e21ed903b
0x84e93ec6170ed630f5ebd89a1aae72d4f63f2713	false	2	0x5ef4468684907ff594c5602a806b399074d91fbb	125791970	0xe36a30d249f7761327fd973001a32010b521b6fd	2024-09-24T12:58:37.000Z	0x5c75ee919283f528b75cecd3a7ae85f33016fd4f3fa182fbef5f19a12a1ac3be
0x84e93ec6170ed630f5ebd89a1aae72d4f63f2713	false	4	0x72163ab059e4cdecfbe0a8073d01e085c888637e	123973490	0xe36a30d249f7761327fd973001a32010b521b6fd	2024-08-13T10:42:37.000Z	0x1b1746f52ade35f31c72e07b1fe2129bd0d60822edb881cfcfc68e46926e094d

Example Query

Query with partition filter

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

compound_v3_ethereum compound_v3_polygon

⌘I

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Configurator_CometDeployed_event

​Tables

​Configurator_CometDeployed_event

Tables

Configurator_CometDeployed_event