Skip to main content

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.
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_cometProxySTRINGContract address of the Comet proxy being deployed or upgraded. Hex-encoded, 0x-prefixed, 42-character string.
in_newCometSTRINGContract address of the new Comet implementation being deployed. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedlog_indexin_newCometblock_numberin_cometProxyblock_timestamptransaction_hash
0x84e93ec6170ed630f5ebd89a1aae72d4f63f2713false20x23da01a00c6e25acf2f6c42f677212bc9ec5011f1248587300xe36a30d249f7761327fd973001a32010b521b6fd2024-09-02T22:30:37.000Z0xea747dba9df22ba03d32acfb05040495c270944f9673107bf88ea60e21ed903b
0x84e93ec6170ed630f5ebd89a1aae72d4f63f2713false20x5ef4468684907ff594c5602a806b399074d91fbb1257919700xe36a30d249f7761327fd973001a32010b521b6fd2024-09-24T12:58:37.000Z0x5c75ee919283f528b75cecd3a7ae85f33016fd4f3fa182fbef5f19a12a1ac3be
0x84e93ec6170ed630f5ebd89a1aae72d4f63f2713false40x72163ab059e4cdecfbe0a8073d01e085c888637e1239734900xe36a30d249f7761327fd973001a32010b521b6fd2024-08-13T10:42:37.000Z0x1b1746f52ade35f31c72e07b1fe2129bd0d60822edb881cfcfc68e46926e094d
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