compound_v3_arbitrum

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
0x8ff5d3d060f2d21a15961bf1e5d700fb9b3494e1	0x9c4ec768c28520b50860ea7a15bd7213a9ff58bf	0x8ff5d3d060f2d21a15961bf1e5d700fb9b3494e1	false	4000042	1	140829307	2023-10-15T14:10:10.000Z	0xf85f0fdb5fded6afedcaccc7a067a62e0c8ba9991a1ae1d286577e8dbdeb7b0b
0x021901b0679979963a1cfceaaf142faa2bb7f389	0x9c4ec768c28520b50860ea7a15bd7213a9ff58bf	0x021901b0679979963a1cfceaaf142faa2bb7f389	false	25001228	1	140723210	2023-10-15T05:29:35.000Z	0x690d0e2923d79648f9809cf12264c69dda62135fcea595ffbd980166ec752253
0x1d5d3c315824519b5e5c72a85994e42b90228aae	0x9c4ec768c28520b50860ea7a15bd7213a9ff58bf	0x1d5d3c315824519b5e5c72a85994e42b90228aae	false	553140000	1	140879090	2023-10-15T18:17:33.000Z	0x76f3676a36afb74ef27f72aa15c50e44ba91f603f20331cf45b22c334389a456

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.compound_v3_arbitrum.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
0x002fb0c5d1209f8f5616ba3d211be36c4d237d55	0x9c4ec768c28520b50860ea7a15bd7213a9ff58bf	0x002fb0c5d1209f8f5616ba3d211be36c4d237d55	false	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	35361906	13	247095319	2024-08-27T01:48:04.000Z	0x2ea2e0155ff40e5a88c7a9b57ca2782fa8662e1a0ea3c053ac9b6bc5ef8f9e9d
0x002fb0c5d1209f8f5616ba3d211be36c4d237d55	0x9c4ec768c28520b50860ea7a15bd7213a9ff58bf	0x002fb0c5d1209f8f5616ba3d211be36c4d237d55	false	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	14987410	47	247096984	2024-08-27T01:55:01.000Z	0x1bbc6015efd87294be6af69637f474f61a41d4250a1b69a106a3b2ae44a69233
0x002fb0c5d1209f8f5616ba3d211be36c4d237d55	0x9c4ec768c28520b50860ea7a15bd7213a9ff58bf	0x002fb0c5d1209f8f5616ba3d211be36c4d237d55	false	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	11254851	6	247098143	2024-08-27T01:59:51.000Z	0x66733fd1c9ee9cf781b3158d1a8a107091e72b1d24ae31ab401ed3d04aa7546f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.compound_v3_arbitrum.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
0xa11cba2199d349c35f4c4ef6a4760406c69f9f79	0xa11cba2199d349c35f4c4ef6a4760406c69f9f79	0x9c4ec768c28520b50860ea7a15bd7213a9ff58bf	false	3700000000	1	179498655	2024-02-11T01:06:04.000Z	0xbc0f242478e9e47cb4c1f48c865371aa3bc07e8e79455dd1a5a2f13b7f2fef33
0x393130055722bcc91d5e6c488c3c513c92487775	0x393130055722bcc91d5e6c488c3c513c92487775	0x9c4ec768c28520b50860ea7a15bd7213a9ff58bf	false	12000000000	1	179602190	2024-02-11T08:25:06.000Z	0x7edf458e494592c14d3aef33c1fa12c708bad23338167c34a4a248ac4bcbfea2
0xb8804cf174805d96e0425bf765d8958d3bcf3069	0xb8804cf174805d96e0425bf765d8958d3bcf3069	0x9c4ec768c28520b50860ea7a15bd7213a9ff58bf	false	5500000000	1	179766330	2024-02-11T20:06:10.000Z	0xc5b0725a23d1332823fe28afae1b73b2410d10ca98bf0a8d0e94fb98000837bc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.compound_v3_arbitrum.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
0xc8254414210372e5dcd8b7a2e0f73536d6de1d30	0xc8254414210372e5dcd8b7a2e0f73536d6de1d30	0x9c4ec768c28520b50860ea7a15bd7213a9ff58bf	false	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	403	16	209484445	2024-05-09T13:55:57.000Z	0x564df5f5c5b90551d89589cf95e1ab3c01ce3f832f5e7c86b5136709fe3bbd24
0xc8254414210372e5dcd8b7a2e0f73536d6de1d30	0xc8254414210372e5dcd8b7a2e0f73536d6de1d30	0x9c4ec768c28520b50860ea7a15bd7213a9ff58bf	false	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	538	21	209437456	2024-05-09T10:39:09.000Z	0xc3f00c4c8e05fa4109d71bf5ad059f0850458fcdbff5afe65682265a9603f941
0x6cae28b3d09d8f8fc74ccd496ac986fc84c0c24e	0xe9a6df5134dfab4a8001831722b026e3b95784de	0x9c4ec768c28520b50860ea7a15bd7213a9ff58bf	false	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	58017	24	209476303	2024-05-09T13:21:28.000Z	0xee032a61bd3c6bba7827597f8666517cd2f2f3663b3ab821044748617cb73ff0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.compound_v3_arbitrum.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
0x534eb79737248d02fd8bc4e4da81679fd714bd74	0x88730d254a2f7e6ac8388c3198afd694ba9f7fae	false	0x354a6da3fcde098f8389cad84b0182725c6c91de	175745000000000000	1	132066669	0x534eb79737248d02fd8bc4e4da81679fd714bd74	2023-09-18T01:20:49.000Z	0x56119ebd4993874f4bba679c7dd34de44affb974494b3e99686dc1891d7c2f49
0x8c2b499b4c80ac483f67e720541d0a46133e1cce	0x88730d254a2f7e6ac8388c3198afd694ba9f7fae	false	0x354a6da3fcde098f8389cad84b0182725c6c91de	2633000000000000	1	210912246	0x8c2b499b4c80ac483f67e720541d0a46133e1cce	2024-05-13T17:58:55.000Z	0xc7831ba316f05308f2c947c695f3c6430f4b4f950fccb2a95bf8f4a284363f5d
0x8c2b499b4c80ac483f67e720541d0a46133e1cce	0x88730d254a2f7e6ac8388c3198afd694ba9f7fae	false	0x354a6da3fcde098f8389cad84b0182725c6c91de	3846000000000000	1	210665004	0x8c2b499b4c80ac483f67e720541d0a46133e1cce	2024-05-13T00:27:52.000Z	0xdae31bdff5c95197d4fd16fbc8da4ecd3baa66ca2ab2a05da75e1b6af9bac70b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.compound_v3_arbitrum.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
0xb21b06d71c75973babde35b49ffdac3f82ad3775	false	24	0x11bbb9e926f07fd55a328bee34cce96dc9ea3f15	235468800	0x9c4ec768c28520b50860ea7a15bd7213a9ff58bf	2024-07-24T06:20:35.000Z	0x805e30624030c3914e1b2a215999f7c5d6f61f1d9b0a50cf1403be134f7bbc43
0xb21b06d71c75973babde35b49ffdac3f82ad3775	false	13	0x1bfe8eb709b2e6bdf6a9763d4906c335a46f2772	242315431	0x6f7d514bbd4aff3bcd1140b7344b32f063dee486	2024-08-13T04:06:34.000Z	0x28041911addf015445e893856f3167bf183fb06c156fa7e7c35d1b6c40bc4f68
0xb21b06d71c75973babde35b49ffdac3f82ad3775	false	2	0x9a2643b248772264989a6a7e52982549edae3520	195068610	0x9c4ec768c28520b50860ea7a15bd7213a9ff58bf	2024-03-28T10:54:38.000Z	0x35316f932c1441c286ffb9885e18a1c961e639c29a6483716267ea09defcdbfa

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.compound_v3_arbitrum.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