compound_v3_polygon

Tables

Comet_Supply_event

Supply events from Compound v3 Comet protocol containing originating address, destination address, and supplied token amount. Used for tracking lending protocol deposits and liquidity provision activity.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_dst`	`STRING`	Address of the account receiving tokens or assets in the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_dst	address	in_from	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x052f01c2ea10af00892a34a466171408980f7cb6	0xf25212e676d1f7f89cd72ffee66158f541246445	0x052f01c2ea10af00892a34a466171408980f7cb6	false	3422841	942	64792577	2024-11-27T12:26:01.000Z	0xb84c4dbbc9710e06b69c83ce819a8b6f7aeeb7d8897659d20bd2ebc651c19862
0x052f01c2ea10af00892a34a466171408980f7cb6	0xf25212e676d1f7f89cd72ffee66158f541246445	0x052f01c2ea10af00892a34a466171408980f7cb6	false	103123345	340	64784003	2024-11-27T07:21:14.000Z	0xe48033c57bb7c976203cda492cee0695d0b3244a2a8c9401c46b5c855da5a749
0x052f01c2ea10af00892a34a466171408980f7cb6	0xf25212e676d1f7f89cd72ffee66158f541246445	0x052f01c2ea10af00892a34a466171408980f7cb6	false	6502820	406	64783662	2024-11-27T07:09:08.000Z	0xf3dc44b3a38e84db15182d81b5eb112be89959d3350aa470421ef5d984ac7a60

Example Query

Query with partition filter

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

Comet_SupplyCollateral_event

Collateral deposit events from Compound V3 Comet contracts recording asset supplies to lending positions. Contains supplier address, recipient account, collateral asset contract, and deposit amount for tracking lending protocol activity.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_dst`	`STRING`	Address of the account receiving tokens or assets in the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_dst	address	in_from	removed	in_asset	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x05d3f996a17e78b067d5e2e4150aac83dfb52643	0xf25212e676d1f7f89cd72ffee66158f541246445	0x59e242d352ae13166b4987ae5c990c232f7f7cd6	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	2000000000000000000	199	40784291	2023-03-26T08:51:58.000Z	0x0c3d5a9805d318cf189699e06f481b41ae4d4f260dbe4045e1dcc4858af59dea
0xd40515d9a6521b579491db5b4c295069f2049d40	0xf25212e676d1f7f89cd72ffee66158f541246445	0x59e242d352ae13166b4987ae5c990c232f7f7cd6	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	10000000000000000000	107	40794235	2023-03-26T16:07:52.000Z	0xa4195829ef271a3720e8e2667d8995e005493dc7bffe740dd875dc40ac46a71e
0x05d3f996a17e78b067d5e2e4150aac83dfb52643	0xf25212e676d1f7f89cd72ffee66158f541246445	0x59e242d352ae13166b4987ae5c990c232f7f7cd6	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	1000000000000000000	208	40784148	2023-03-26T08:46:54.000Z	0x40a1dd7c16af1441a14b550d6cb4af3e591a542370cee360537794748106f4a3

Example Query

Query with partition filter

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

Comet_Withdraw_event

Withdrawal events from Compound v3 (Comet) lending markets containing source account, destination address, and withdrawal amount. Used for tracking asset outflows from lending positions across collateral and base asset withdrawals.

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_src`	`STRING`	Address of the account from which tokens or assets are being withdrawn or transferred. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_to	in_src	address	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x0055f458035d698a9a1faad4e945ef99d1e12936	0x0055f458035d698a9a1faad4e945ef99d1e12936	0xf25212e676d1f7f89cd72ffee66158f541246445	false	99999	341	45213863	2023-07-18T04:34:56.000Z	0x1f995bf57ff35df48b8943bce883e6cb9ba285dcf58d71035b17083b0253e1c3
0x0c3b6ce9c63567fcd0069388856e778885266e3e	0x0c3b6ce9c63567fcd0069388856e778885266e3e	0xf25212e676d1f7f89cd72ffee66158f541246445	false	748277	248	45229854	2023-07-18T14:25:20.000Z	0xd9dcb233eb13077647bb1a5a0d76d8ee056efc3f09b12c0a1260648acaabed33
0x2bffa4b20253c8644bf0c9f1ab737ea398ea5298	0x2bffa4b20253c8644bf0c9f1ab737ea398ea5298	0xf25212e676d1f7f89cd72ffee66158f541246445	false	11012437	480	45219312	2023-07-18T07:55:03.000Z	0xae9dc560b555c1cb1aab38e177230d29b915a96d928d9da9349e5022d5c44b2e

Example Query

Query with partition filter

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

Comet_WithdrawCollateral_event

Collateral withdrawal events from Compound v3 Comet markets containing source account, recipient address, asset contract, and withdrawal amount. Used for tracking collateral reduction and position management across lending markets.

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_src`	`STRING`	Address of the account from which tokens or assets are being withdrawn or transferred. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_to	in_src	address	removed	in_asset	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x1177e23637f4a35244fb9cf124663f3e1ecd7287	0x1177e23637f4a35244fb9cf124663f3e1ecd7287	0xf25212e676d1f7f89cd72ffee66158f541246445	false	0x3a58a54c066fdc0f2d55fc9c89f0415c92ebf3c4	170779435307927234031221	269	59741772	2024-07-24T06:56:34.000Z	0xd558ff0ecfbc1c42e6dd0449e6788fcb8e1f32ae2026b7229dd4eff62377392f
0x19a8be9065a32687b6ca56a1cd4df99e5cbade2d	0x19a8be9065a32687b6ca56a1cd4df99e5cbade2d	0xf25212e676d1f7f89cd72ffee66158f541246445	false	0xfa68fb4628dff1028cfec22b4162fccd0d45efb6	36824567035484612860733	318	59752109	2024-07-24T13:09:48.000Z	0x0bda48d7e99da275d77a4856d091bdf8cf8a95168cf6e67f3fcd1851374f10b3
0x3dc892aa768fe4823b4b4d3d56f730e1ac434adb	0x3dc892aa768fe4823b4b4d3d56f730e1ac434adb	0xf25212e676d1f7f89cd72ffee66158f541246445	false	0x7ceb23fd6bc0add59e62ac25578270cff1b9f619	399999925943031848	3324	59751648	2024-07-24T12:53:30.000Z	0xbc902efc6a8bc2caefac3939d5ffb937f9e9f018e11738e5de74efb7f20a435c

Example Query

Query with partition filter

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

CometRewards_RewardClaimed_event

Compound V3 CometRewards contract events emitted when users claim accrued COMP token rewards from lending positions. Contains source account, recipient address, token contract, and claimed amount for tracking reward distributions across Comet markets.

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_src`	`STRING`	Address of the account from which tokens or assets are being withdrawn or transferred. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_src	address	removed	in_token	in_amount	log_index	block_number	in_recipient	block_timestamp	transaction_hash
0x12a7208e7dde0f0da75b109eb53b1b07482dc075	0x45939657d1ca34a8fa39a924b71d28fe8431e581	false	0x8505b9d2254a7ae468c0e9dd10ccea3a837aef5c	143000000000000	565	51654687	0x12a7208e7dde0f0da75b109eb53b1b07482dc075	2023-12-28T10:36:58.000Z	0x52b02d27630683b108e4863bc0fc4fe5b3bc000573338c3419c983424a6dbc7d
0x12a7208e7dde0f0da75b109eb53b1b07482dc075	0x45939657d1ca34a8fa39a924b71d28fe8431e581	false	0x8505b9d2254a7ae468c0e9dd10ccea3a837aef5c	334000000000000	342	51648954	0x12a7208e7dde0f0da75b109eb53b1b07482dc075	2023-12-28T07:06:24.000Z	0x9cb9b060074e1e8de27289871556cc972699c3354cfdf82d8aa607c1000ac302
0x12a7208e7dde0f0da75b109eb53b1b07482dc075	0x45939657d1ca34a8fa39a924b71d28fe8431e581	false	0x8505b9d2254a7ae468c0e9dd10ccea3a837aef5c	206000000000000	392	51663235	0x12a7208e7dde0f0da75b109eb53b1b07482dc075	2023-12-28T15:41:39.000Z	0x11a53950bf9f3b5c740a398e2cffb3b67feef1dc76932e0bfdeb79d023aecc59

Example Query

Query with partition filter

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

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
0x83e0f742cacbe66349e3701b171ee2487a26e738	false	289	0x822fa132a3d3d496bb5c4cbfe533a5a1180a14ba	72292926	0xaeb318360f27748acb200ce616e389a6c9409a07	2025-06-03T00:40:46.000Z	0x0655b34dc10eb7ca25663b9db2f7d0bc9af2cc3883be8f764a1c18d8d04d3a9b
0x83e0f742cacbe66349e3701b171ee2487a26e738	false	282	0x7ea1db6c6cfa873adaab12608c06b4bf60732048	72292926	0xf25212e676d1f7f89cd72ffee66158f541246445	2025-06-03T00:40:46.000Z	0x0655b34dc10eb7ca25663b9db2f7d0bc9af2cc3883be8f764a1c18d8d04d3a9b
0x83e0f742cacbe66349e3701b171ee2487a26e738	false	155	0xf7afbb8933fb0de22311f1954d226f98e598cc30	70366310	0xf25212e676d1f7f89cd72ffee66158f541246445	2025-04-16T09:12:38.000Z	0x20d546e3dc20e999309c4a2c5b2563bc6920769ad14d4056a995119e65d44e1f

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Comet_Supply_event

Comet_SupplyCollateral_event

Comet_Withdraw_event

Comet_WithdrawCollateral_event

CometRewards_RewardClaimed_event

Configurator_CometDeployed_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Comet_Supply_event

​Comet_SupplyCollateral_event

​Comet_Withdraw_event

​Comet_WithdrawCollateral_event

​CometRewards_RewardClaimed_event

​Configurator_CometDeployed_event

Tables

Comet_Supply_event

Comet_SupplyCollateral_event

Comet_Withdraw_event

Comet_WithdrawCollateral_event

CometRewards_RewardClaimed_event

Configurator_CometDeployed_event