compound_v3_ethereum

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
0x420f253087044b8bcf028dd89f8fe83ba6275e84	0xa17581a9e3356d9a858b789d68b4d866e593ae94	0xa397a8c2086c554b531c02e29f3291c9704b00c7	false	4000000000000000000	291	17163564	2023-05-01T04:19:59.000Z	0xbd27fa2d1bd009d5dfdbc9fb763119512aa3728fa3a6a46819d7d04194dc5fe5
0x0c0194e9873278db3d424768f692a94f9f8e7acd	0xc3d688b66703497daa19211eedff47f25384cdc3	0x0c0194e9873278db3d424768f692a94f9f8e7acd	false	3677824229	121	17167158	2023-05-01T16:26:59.000Z	0x457bc03159330c7043ef6f76be33df6e0b46abc210b10f25a1c9df010bf92a29
0x0c8d713694e5741b10929da5b398eed32e968cb3	0xc3d688b66703497daa19211eedff47f25384cdc3	0x0c8d713694e5741b10929da5b398eed32e968cb3	false	4840598359	254	17166058	2023-05-01T12:44:11.000Z	0x684597b35dd09fb580fc62bf6c87e2c9f16d7261e6f9109279385d2a83b250bf

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.compound_v3_ethereum.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
0x73f3869e754a0a9df4bb33bad248c0182dda5175	0xa17581a9e3356d9a858b789d68b4d866e593ae94	0x73f3869e754a0a9df4bb33bad248c0182dda5175	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	2397835486471492481429	352	17280193	2023-05-17T15:20:59.000Z	0x147875ce55c063e9ed320464fe4cc2d911b24f7885ff684cc5e79ae68572a757
0x5ff0dcffb3b12d28aa0cf0bdf1fd2782eca64aa6	0xa17581a9e3356d9a858b789d68b4d866e593ae94	0x5ff0dcffb3b12d28aa0cf0bdf1fd2782eca64aa6	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	27737437833210939798	252	17280329	2023-05-17T15:48:23.000Z	0x2bf4557864a4c9be60e21f810b845fe21988fb3a3e80e9b532f070524d84b9ff
0x7e6f6621388047c8a481d963210b514dbd5ea1b9	0xa17581a9e3356d9a858b789d68b4d866e593ae94	0x7e6f6621388047c8a481d963210b514dbd5ea1b9	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	670841114194996801952	157	17278781	2023-05-17T10:30:47.000Z	0x9e6ad499b4e1ad05fef595ce53a6e0eea4ffc41d87d39b6671b91c26e7a0b614

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.compound_v3_ethereum.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
0xa397a8c2086c554b531c02e29f3291c9704b00c7	0x9f4f18ac9cc9de7c1441ac39ab2dbd7174fa1561	0xa17581a9e3356d9a858b789d68b4d866e593ae94	false	120000000000000000000	324	16595297	2023-02-10T02:13:35.000Z	0xd8a06ac25e49f32daae846285643a79e2972ccd7a30748fb9a5ecca55cfe5645
0xa397a8c2086c554b531c02e29f3291c9704b00c7	0xb4ab9ccc51d5e8532da753aa71aa0bdede948e63	0xa17581a9e3356d9a858b789d68b4d866e593ae94	false	59400058134140366191	313	16595531	2023-02-10T03:00:23.000Z	0x9ebdf0ff1dddb7288f68d00b4578f86026fab62cdc402a6656e808a581eab0f0
0xa397a8c2086c554b531c02e29f3291c9704b00c7	0x420f253087044b8bcf028dd89f8fe83ba6275e84	0xa17581a9e3356d9a858b789d68b4d866e593ae94	false	700000000000000000	253	16599751	2023-02-10T17:08:59.000Z	0x1adb5d7449de8e3cd882f58fe6286021fd747cd60f4e081d222cc45a55bdb948

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.compound_v3_ethereum.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
0x20691f822420b500a3f5f55dd3d631eae7361c31	0x20691f822420b500a3f5f55dd3d631eae7361c31	0xc3d688b66703497daa19211eedff47f25384cdc3	false	0xc00e94cb662c3520282e6f5717214004a7f26888	9695557092455763045	39	15516725	2022-09-11T20:07:29.000Z	0x47dda16f7962357f3317e40a0f537ac4794766e9ab1adf48de31661c82763158
0x3d34026cfe77216f3edbdc5e7506f81e9f18cca7	0x3d34026cfe77216f3edbdc5e7506f81e9f18cca7	0xc3d688b66703497daa19211eedff47f25384cdc3	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	250000000000000000	29	15512010	2022-09-11T01:18:01.000Z	0x9f7aaba32724ec85f732f2846fd61d906d9477c482a1c559d1a230bb1eaadb19
0x74a81f84268744a40febc48f8b812a1f188d80c3	0x3df562d0e553f19e8fed01f30bf6d5f031c78aed	0xc3d688b66703497daa19211eedff47f25384cdc3	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	90000000000000000	369	15516466	2022-09-11T19:04:17.000Z	0x10a215e91f151698874979b0928ef03ff57203a4ac77d2e104ba9e452f63e80d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.compound_v3_ethereum.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
0x3b4feb74a59f70ad45d455be0175827b4570f64c	0x1b0e765f6224c21223aea2af16c1c46e38885a40	false	0xc00e94cb662c3520282e6f5717214004a7f26888	4398875000000000000	284	17938288	0x3b4feb74a59f70ad45d455be0175827b4570f64c	2023-08-18T01:04:47.000Z	0xd58d755af39117fdad347e8349a98ad5ef8202a740310046eb6f6499ab78eac2
0xf8de75c7b95edb6f1e639751318f117663021cf0	0x1b0e765f6224c21223aea2af16c1c46e38885a40	false	0xc00e94cb662c3520282e6f5717214004a7f26888	839500629000000000000	263	17944963	0xf8de75c7b95edb6f1e639751318f117663021cf0	2023-08-18T23:30:59.000Z	0x5993ce83bdeb98d52eabb315e559f79b658a25ce6115040c3c2f0985b346890d
0xb5a9621b0397bfc5b45896cae5998b6111bcdce6	0x1b0e765f6224c21223aea2af16c1c46e38885a40	false	0xc00e94cb662c3520282e6f5717214004a7f26888	1864934000000000000	171	17941719	0xb5a9621b0397bfc5b45896cae5998b6111bcdce6	2023-08-18T12:37:59.000Z	0x2a48f419458f5994d5e516931fcd7f751a4f012560752b73b7f054cf671d2846

Example Query

Query with partition filter

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

CometUSDC_Supply_event

Supply deposit events from Compound v3 USDC market (Comet) on Ethereum mainnet. Captures individual supply transactions with depositor address, recipient, and amounts for tracking lending activity and position changes.

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
0x0524fe637b77a6f5f0b3a024f7fd9fe1e688a291	0xc3d688b66703497daa19211eedff47f25384cdc3	0x0524fe637b77a6f5f0b3a024f7fd9fe1e688a291	false	39582376847	316	15427734	2022-08-28T12:15:04.000Z	0xfff6cf717ce1aedc8cd620796fc380cf2eef4dc45b77c9a9a1a0c2b7cf7c2b9d
0x0524fe637b77a6f5f0b3a024f7fd9fe1e688a291	0xc3d688b66703497daa19211eedff47f25384cdc3	0x0524fe637b77a6f5f0b3a024f7fd9fe1e688a291	false	30000000000	329	15427647	2022-08-28T11:55:12.000Z	0x4a96621e35e54f05ba63c9c9a951e4a97becfaf2d1b7036a39ae68048231bf49
0x0578fe63a40dd249b853487dae3c9eb01957628e	0xc3d688b66703497daa19211eedff47f25384cdc3	0x0578fe63a40dd249b853487dae3c9eb01957628e	false	2719524888	163	15426593	2022-08-28T07:54:03.000Z	0xd420ad0bc7b400cb77b425a8d29909659bf1bce9640ef37ccab1e1afcc5ecb77

Example Query

Query with partition filter

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

CometUSDC_SupplyCollateral_event

Collateral deposit events from Compound V3 (Comet) USDC market on Ethereum, recording when users supply non-USDC assets as collateral. Tracks the depositor address, destination account, collateral asset address, and supplied amount for analyzing borrowing activity and collateral composition.

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
0x544f96434f77437425d5ac40fd4755c0cf39399a	0xa17581a9e3356d9a858b789d68b4d866e593ae94	0x544f96434f77437425d5ac40fd4755c0cf39399a	false	0xbe9895146f7af43049ca1c1ae358b0541ea49704	9382909197946170047	42	16876566	2023-03-21T14:20:35.000Z	0xe10ac943ed594b5fdb3eeb5f1f1d830a61d7ef9e13c2bd132310af1a27ae7648
0x544f96434f77437425d5ac40fd4755c0cf39399a	0xa17581a9e3356d9a858b789d68b4d866e593ae94	0x544f96434f77437425d5ac40fd4755c0cf39399a	false	0xbe9895146f7af43049ca1c1ae358b0541ea49704	10877535540635908238	48	16876527	2023-03-21T14:12:35.000Z	0x6dcc6931f6f27457288074b01abfe64597082c474a0b8dcf5002493c960c7da7
0x544f96434f77437425d5ac40fd4755c0cf39399a	0xa17581a9e3356d9a858b789d68b4d866e593ae94	0x544f96434f77437425d5ac40fd4755c0cf39399a	false	0xbe9895146f7af43049ca1c1ae358b0541ea49704	9888032691173655034	124	16876543	2023-03-21T14:15:47.000Z	0x5d6ade06946ba610a33de7909374f73b51f90ade183364cd5137b134852dba89

Example Query

Query with partition filter

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

CometUSDC_Withdraw_event

Withdrawal events from Compound v3 USDC lending markets (Comet) on Ethereum, tracking collateral and principal removals with source and destination addresses. Used for analyzing user withdrawal patterns, liquidity flows, and protocol utilization across multiple Comet 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_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
0xa397a8c2086c554b531c02e29f3291c9704b00c7	0x96de002f882edc6de8d7d45ae2fcdebcc88d790b	0xa17581a9e3356d9a858b789d68b4d866e593ae94	false	120000000000000000000	220	16939920	2023-03-30T11:59:11.000Z	0x5a8505658f73ea6871ca348d490adda31f39b37e68c51b7d708c7dc6ae06ab5c
0xa397a8c2086c554b531c02e29f3291c9704b00c7	0x7eac9f0dcf81ed413647d2b1c9b02620da298a93	0xa17581a9e3356d9a858b789d68b4d866e593ae94	false	451527730180409334	46	16937297	2023-03-30T03:09:59.000Z	0x6e7266db555f4eeb0207e80f8b089946d51d173ff927c669b1c9cc1585c1613f
0x005e687c58e498bf6e6068868fa6c03d9e806c2c	0x005e687c58e498bf6e6068868fa6c03d9e806c2c	0xc3d688b66703497daa19211eedff47f25384cdc3	false	50030293	165	16939855	2023-03-30T11:45:59.000Z	0x14086b5ab0bba0aeb43f2c1f237d3fdffa1af07c9ebbbe743ddd352da7223242

Example Query

Query with partition filter

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

CometUSDC_WithdrawCollateral_event

Collateral withdrawal events from Compound v3 USDC markets on Ethereum, recording when users remove deposited assets from their lending positions. Used for tracking collateral movements, position changes, and user risk management 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_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
0x8df391a660d68b84fb3920ce5456123d85219f61	0x8df391a660d68b84fb3920ce5456123d85219f61	0xa17581a9e3356d9a858b789d68b4d866e593ae94	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	451634746369774446	65	17057170	2023-04-16T04:41:35.000Z	0x970ab2321fecfbbf9895fb8f69159a3f7b00c8ddf332996319ac452b9e4214d4
0x124c5e21a073fb4694308fbdf72af362451eae12	0x124c5e21a073fb4694308fbdf72af362451eae12	0xc3d688b66703497daa19211eedff47f25384cdc3	false	0x1f9840a85d5af5bf1d1762f925bdaddc4201f984	125793197224978735063	204	17059021	2023-04-16T11:00:47.000Z	0xf66d8ab84158c06198e9adb633f48c78910fd2ec75acffc77ad5cd9f1dbc6c55
0x124c5e21a073fb4694308fbdf72af362451eae12	0x124c5e21a073fb4694308fbdf72af362451eae12	0xc3d688b66703497daa19211eedff47f25384cdc3	false	0x514910771af9ca656af840dff83e8264ecf986ca	34912217391635690439	198	17059016	2023-04-16T10:59:47.000Z	0x92a7c31cc6bfa5c828a3c1dcf24c5607d8ff36a57c590a619ab05e21cac0e530

Example Query

Query with partition filter

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

CometWETH_Supply_event

Supply events from Compound v3’s WETH (Wrapped Ether) market on Ethereum, recording deposits of collateral with sender, recipient addresses, and amounts. Used for tracking liquidity provisioning and position building in the protocol’s 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_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
0x7b3e09123ee9bebf1ae9ba38b691e7aec3c7f827	0xa17581a9e3356d9a858b789d68b4d866e593ae94	0x7b3e09123ee9bebf1ae9ba38b691e7aec3c7f827	false	1000000000000000000000	213	17176959	2023-05-03T01:31:47.000Z	0xe99a144f70ad84cd961a5a94e20a894ac41de8b71cd88c7a69c6ce4e86182639
0xe6b9ac396e0f1a885da06b9a6c21dc7c499b51de	0xa17581a9e3356d9a858b789d68b4d866e593ae94	0xa397a8c2086c554b531c02e29f3291c9704b00c7	false	206000000000000000000	447	17179555	2023-05-03T10:18:23.000Z	0xc57ba4251a8cfba91b09bb561ee9a19c9310ce53e742bf4a5967975492e78426
0x418aa6bf98a2b2bc93779f810330d88cde488888	0xa17581a9e3356d9a858b789d68b4d866e593ae94	0xa397a8c2086c554b531c02e29f3291c9704b00c7	false	2000000000000000000000	313	17176554	2023-05-03T00:09:47.000Z	0x86b848c8cda9fa68c9ea94f2e506cf4b8b31926579945f72921f935f03a3ac5c

Example Query

Query with partition filter

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

CometWETH_SupplyCollateral_event

Collateral deposit events from Compound v3’s WETH market on Ethereum, recording when users supply assets like wstETH or cbETH as collateral to borrow against. Used to track collateralization ratios, asset flows, and borrower positions across Compound v3 WETH lending pools.

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
0x9f4f18ac9cc9de7c1441ac39ab2dbd7174fa1561	0xa17581a9e3356d9a858b789d68b4d866e593ae94	0x9f4f18ac9cc9de7c1441ac39ab2dbd7174fa1561	false	0xbe9895146f7af43049ca1c1ae358b0541ea49704	277337730731724126490	264	17148862	2023-04-29T02:43:59.000Z	0x132cdf269a977e6ad94f45aaa94e46929d9c7d83cb83b2847673449ed310f34e
0x9f4f18ac9cc9de7c1441ac39ab2dbd7174fa1561	0xa17581a9e3356d9a858b789d68b4d866e593ae94	0x9f4f18ac9cc9de7c1441ac39ab2dbd7174fa1561	false	0xbe9895146f7af43049ca1c1ae358b0541ea49704	391575313823995950834	94	17148898	2023-04-29T02:51:11.000Z	0x0779b680b61e17da2bd05310358137171e5de0ec529f63f5416876211914c128
0x9f4f18ac9cc9de7c1441ac39ab2dbd7174fa1561	0xa17581a9e3356d9a858b789d68b4d866e593ae94	0x9f4f18ac9cc9de7c1441ac39ab2dbd7174fa1561	false	0xbe9895146f7af43049ca1c1ae358b0541ea49704	382720451534835412660	48	17148944	2023-04-29T03:00:23.000Z	0xa8318540707ce57227e672d2ed4b0a5f595dfd196d544594c6b0ff6e62e61a7f

Example Query

Query with partition filter

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

CometWETH_Withdraw_event

Withdrawal events from Compound v3’s WETH lending market on Ethereum, capturing the source address, recipient, and amount withdrawn in wei. Used for tracking collateral withdrawals and liquidity movements within the Comet protocol.

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
0x5b03598d528e069d6b635ac55fc680201a1e5b59	0x5b03598d528e069d6b635ac55fc680201a1e5b59	0xa17581a9e3356d9a858b789d68b4d866e593ae94	false	10000000000000000000	65	16989719	2023-04-06T12:59:23.000Z	0x46a0e64d87609540d813cf5bc6a4b01e73a8d12c4a8c67e0b6f8b4c43f9c10e5
0xa397a8c2086c554b531c02e29f3291c9704b00c7	0x373adc79ff63d5076d0685ca35031339d4e0da82	0xa17581a9e3356d9a858b789d68b4d866e593ae94	false	19000000000000000000	59	16992912	2023-04-06T23:51:35.000Z	0x9f4fa99276e653eee4bc6c55e20f8899aabc8465b4aa7331e0f2e4c0ba3e80b2
0xa397a8c2086c554b531c02e29f3291c9704b00c7	0x544f96434f77437425d5ac40fd4755c0cf39399a	0xa17581a9e3356d9a858b789d68b4d866e593ae94	false	850000000000000000	54	16989812	2023-04-06T13:18:59.000Z	0xea3b8ead1c27ba0f2eda921d10e58c14aef59b668a8036338ee3d15f91017bfe

Example Query

Query with partition filter

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

CometWETH_WithdrawCollateral_event

Collateral withdrawal events from Compound v3 WETH market on Ethereum, recording when users remove deposited assets from their lending positions. Tracks withdrawal amounts, asset addresses, and source/destination accounts for analyzing collateral management and position unwinding 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_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
0xf1f304def83d6cf4680a81c49cac184a8119a538	0xf1f304def83d6cf4680a81c49cac184a8119a538	0xa17581a9e3356d9a858b789d68b4d866e593ae94	false	0xbe9895146f7af43049ca1c1ae358b0541ea49704	55000000000000000000	23	17044024	2023-04-14T07:42:11.000Z	0x50d56502935a91660b2e01c3a7671eda304972beff213bc485a356cf578a6d4a
0xa397a8c2086c554b531c02e29f3291c9704b00c7	0xbb6999aa15826029ac631e99028371aef506b702	0xa17581a9e3356d9a858b789d68b4d866e593ae94	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	27474957597672897	285	16521626	2023-01-30T19:07:23.000Z	0xfd5bb6d74dda10eccfa0b21007e1ba894ecefbb6592761644c25ac2c966e8230
0xa397a8c2086c554b531c02e29f3291c9704b00c7	0xe01d0bfc2fd389cc56680969c597e787dc3186a1	0xa17581a9e3356d9a858b789d68b4d866e593ae94	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	7223421575894316193	203	16522615	2023-01-30T22:26:11.000Z	0x01aeee16b70c3cca53c00d6f5586055b017540e6f2518b69f0b74470c501e987

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.compound_v3_ethereum.CometWETH_WithdrawCollateral_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
0x316f9708bb98af7da9c68c1c3b5e79039cd336e3	false	118	0x77708e0fee45cb9d177174b260a04beda47d0495	16520572	0xc3d688b66703497daa19211eedff47f25384cdc3	2023-01-30T15:35:35.000Z	0xf626c068c89b0c32f7475a86a373e801bc2538fbe04250c8f8308ccb3cb4d475
0x316f9708bb98af7da9c68c1c3b5e79039cd336e3	false	169	0x7a1316220a46dce22fd5c6d55a39513367e6c967	17972006	0xa17581a9e3356d9a858b789d68b4d866e593ae94	2023-08-22T18:21:23.000Z	0xf73e5eee743d32947d3683b23861cfc0f5796c20098d8fee3372c2b2ecec9cae
0x316f9708bb98af7da9c68c1c3b5e79039cd336e3	false	123	0xcb005d849f384b64838aad885d5ff150fc8b7904	16983730	0xc3d688b66703497daa19211eedff47f25384cdc3	2023-04-05T16:22:35.000Z	0x36fccaf1118a8fd64e2de7e0a05dc74dd84d825e1718b999f7577fdfb11410f2

Example Query

Query with partition filter

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

CToken_Transfer_event

CToken transfer events from Compound v3 lending protocol on Ethereum, tracking movements of interest-bearing cToken balances between addresses. Used for analyzing lending market supply/withdraw activity, collateral flows, and protocol liquidity patterns.

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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

in_to	address	in_from	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x12392f67bdf24fae0af363c24ac620a2f67dad86	0x12392f67bdf24fae0af363c24ac620a2f67dad86	0xb99cc7e10fe0acc68c50c7829f473d81e23249cc	false	104989501108	583	17767393	2023-07-25T03:20:11.000Z	0x00737eeed66ab284d99cb16fe3603807c9808fa73a08dc192d8539e31cb84877
0xf3ea2100e1b85772b76e342c955e22a01c970b8a	0x35a18000230da775cac24873d00ff85bccded550	0xa7826bb3ffd9628625ca99ad25d2bdc6bf4570f0	false	299738685604	116	17771654	2023-07-25T17:39:23.000Z	0xd23c94b0cb952391cc737135bd277e3a33e25121620e702b3391b59c46bc5d11
0xa0d63127611ad3fc030150a31623dd0a8ffb4c3c	0x39aa39c021dfbae8fac545936693ac917d5e7563	0x49d5df7773936decc72e0e305f28190bc1a13e08	false	56810257244	296	17771855	2023-07-25T18:20:11.000Z	0x4f93e27b0305c20cefc30121fd39a74c9e2618008ae435e4be8c7209c908cf96

Example Query

Query with partition filter

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

CometUSDC_Supply_event

CometUSDC_SupplyCollateral_event

CometUSDC_Withdraw_event

CometUSDC_WithdrawCollateral_event

CometWETH_Supply_event

CometWETH_SupplyCollateral_event

CometWETH_Withdraw_event

CometWETH_WithdrawCollateral_event

Configurator_CometDeployed_event

CToken_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Comet_Supply_event

​Comet_SupplyCollateral_event

​Comet_Withdraw_event

​Comet_WithdrawCollateral_event

​CometRewards_RewardClaimed_event

​CometUSDC_Supply_event

​CometUSDC_SupplyCollateral_event

​CometUSDC_Withdraw_event

​CometUSDC_WithdrawCollateral_event

​CometWETH_Supply_event

​CometWETH_SupplyCollateral_event

​CometWETH_Withdraw_event

​CometWETH_WithdrawCollateral_event

​Configurator_CometDeployed_event

​CToken_Transfer_event

Tables

Comet_Supply_event

Comet_SupplyCollateral_event

Comet_Withdraw_event

Comet_WithdrawCollateral_event

CometRewards_RewardClaimed_event

CometUSDC_Supply_event

CometUSDC_SupplyCollateral_event

CometUSDC_Withdraw_event

CometUSDC_WithdrawCollateral_event

CometWETH_Supply_event

CometWETH_SupplyCollateral_event

CometWETH_Withdraw_event

CometWETH_WithdrawCollateral_event

Configurator_CometDeployed_event

CToken_Transfer_event