compound_v2_ethereum

Tables

CErc20_AccrueInterest_event

Interest accrual events from Compound v2 ERC-20 token markets on Ethereum, recording borrowIndex updates, total borrows, and accumulated interest per market block-by-block. Used for tracking lending market interest rates and calculating historical borrowing costs across Compound cToken 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_interestAccumulated`	`STRING`	Interest accrued during the period since the last interest calculation. Denominated in the smallest unit of the underlying token.
`in_borrowIndex`	`STRING`	Cumulative borrow interest index for the market. Scaled by 1e18, representing the accumulated interest per unit borrowed since market inception.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	log_index	block_number	in_borrowIndex	block_timestamp	in_totalBorrows	transaction_hash	in_interestAccumulated
0x39aa39c021dfbae8fac545936693ac917d5e7563	false	72	7764695	1002928513332853802	2019-05-15T11:37:56.000Z	2406334354	0xaa6e65720bd6bc297038fc5f579375523f13ef0432ad117224813a6cdd29ab15	225833
0x39aa39c021dfbae8fac545936693ac917d5e7563	false	52	7767071	1003024585968656645	2019-05-15T20:26:58.000Z	4000717318	0x35ded1aaf1fe83d8e231c5163cef2b8dcf448f200e3d1c74d06986f88303bb33	55161
0x39aa39c021dfbae8fac545936693ac917d5e7563	false	107	7766256	1002991832233775807	2019-05-15T17:24:53.000Z	4000586677	0xf134e76d28f55b39bdbe124aa5d2d65652552ff26bc7f7bdf50745ba1eed6139	251972

Example Query

Query with partition filter

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

CErc20_Borrow_event

Borrow events from Compound V2 ERC20 lending markets on Ethereum, tracking when users take out loans against collateral. Records individual borrow transactions with amount borrowed, account debt balances, and protocol-wide total borrows for analyzing lending activity and risk metrics.

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_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrowAmount`	`STRING`	Amount borrowed in the transaction. Denominated in the smallest unit of the underlying token.
`in_accountBorrows`	`STRING`	Total amount currently borrowed by the individual account. Denominated in the smallest unit of the underlying token.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	log_index	in_borrower	block_number	block_timestamp	in_borrowAmount	in_totalBorrows	transaction_hash	in_accountBorrows
0x39aa39c021dfbae8fac545936693ac917d5e7563	false	113	0x0297acbe62ac90c4d79654eece1aeeea3b2bcf9a	12871360	2021-07-21T18:22:16.000Z	53552483625	2926680378917587	0x6e7b94f9f57ea0d40eaf45642184976a9d28851303ee42bc2ac841191ee4068a	98221801809
0x39aa39c021dfbae8fac545936693ac917d5e7563	false	322	0x0439f130c8505637626f88c0a8417a61f9f511ec	12868140	2021-07-21T06:16:51.000Z	20000000000	2938469847747175	0xc851c77fadd76c4c731ee3dd169c4d14c92c726de910f63f2d2b5ba532e93e8f	59117166582
0x39aa39c021dfbae8fac545936693ac917d5e7563	false	118	0x04bd950f42f6e77a394e2dbde19192f478efa5e4	12866615	2021-07-21T00:32:52.000Z	201000000000	2936438374276621	0x8dda45fdd213538fb142b0d292b42b00326d41baa496cbdba8d0237ee4132ef8	201000000000

Example Query

Query with partition filter

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

CErc20_Mint_event

Mint event logs from Compound V2 (version 2) ERC-20 lending markets on Ethereum, capturing when users supply underlying assets and receive cTokens in return. Used for tracking supply-side liquidity flows and cToken mint rate analysis across different 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_minter`	`STRING`	Address authorized to mint tokens in the operation. Hex-encoded, 0x-prefixed, 42-character string for EVM chains; 66-character hex string for Aptos.
`in_mintAmount`	`STRING`	Quantity of underlying asset deposited into the lending protocol. Numeric string representing token amount in smallest denomination.
`in_mintTokens`	`STRING`	Quantity of protocol-specific interest-bearing tokens minted to the depositor. Numeric string representing token amount in smallest denomination.

Sample Data

address	removed	in_minter	log_index	block_number	in_mintAmount	in_mintTokens	block_timestamp	transaction_hash
0x39aa39c021dfbae8fac545936693ac917d5e7563	false	0x1344a36a1b56144c3bc62e7757377d288fde0369	96	14841246	188948448326	835812801920506	2022-05-25T10:02:09.000Z	0x9d6ec6415acc23e17c3aeef6f326cfcc960a674ad8994f6ca0550304de1748e6
0x39aa39c021dfbae8fac545936693ac917d5e7563	false	0x1344a36a1b56144c3bc62e7757377d288fde0369	457	14841912	657224421	2907223098154	2022-05-25T12:39:58.000Z	0xbe89b267472ceaa5d5b4b1a430ade84093fb528c2cc0c36e914648eab6867ef3
0xb3319f5d18bc0d84dd1b4825dcde5d5f7266d407	false	0x1b7a9c831b4f2088fa6eae337088ae2fc9913ef5	118	14839283	93250251520000000000	453124000849	2022-05-25T02:28:54.000Z	0x15a88508bb7e9f69d082023df962884a3135a37fe4dcbb4bf81bcb0281eca554

Example Query

Query with partition filter

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

CErc20_NewReserveFactor_event

Reserve factor parameter changes for Compound V2 cToken markets on Ethereum. Tracks governance adjustments to protocol revenue allocation, with mantissa values representing the percentage of interest reserved for the protocol (e.g., 250000000000000000 = 25%).

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_oldReserveFactorMantissa`	`STRING`	Previous reserve factor for the lending market before the update. 18-decimal fixed-point integer stored as string.
`in_newReserveFactorMantissa`	`STRING`	Updated reserve factor for the lending market. 18-decimal fixed-point integer stored as string.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactorMantissa	in_oldReserveFactorMantissa
0x6c8c6b02e7b2be14d4fa6022dfd6d75921d90e4e	false	157	11438576	2020-12-12T14:10:16.000Z	0x72198c8f10a1958aa97b2f1408700209a14e026e81fabba866e03668e5879c8d	250000000000000000	500000000000000000
0xb3319f5d18bc0d84dd1b4825dcde5d5f7266d407	false	160	11438576	2020-12-12T14:10:16.000Z	0x72198c8f10a1958aa97b2f1408700209a14e026e81fabba866e03668e5879c8d	250000000000000000	500000000000000000
0xc11b1268c1a384e55c48c2391d8d480264a3a7f4	false	154	11438576	2020-12-12T14:10:16.000Z	0x72198c8f10a1958aa97b2f1408700209a14e026e81fabba866e03668e5879c8d	200000000000000000	100000000000000000

Example Query

Query with partition filter

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

CErc20_Redeem_event

Withdrawal events from Compound v2 ERC20 lending markets (cTokens) on Ethereum, capturing when users redeem cTokens for underlying assets with corresponding amounts and exchange rates. Used for tracking liquidity withdrawals, market outflows, and calculating user position changes across Compound 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_redeemer`	`STRING`	Address of the account that initiated the redemption transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_redeemAmount`	`STRING`	Amount of underlying asset tokens withdrawn from the lending pool during redemption.
`in_redeemTokens`	`STRING`	Amount of interest-bearing pool tokens burned during the redemption transaction. String-encoded integer representing the quantity of cTokens or equivalent derivative tokens exchanged for underlying assets.

Sample Data

address	removed	log_index	in_redeemer	block_number	block_timestamp	in_redeemAmount	in_redeemTokens	transaction_hash
0x39aa39c021dfbae8fac545936693ac917d5e7563	false	137	0x10f69553c7b482536155cdc8d904ae833ed55f98	14046573	2022-01-21T03:40:14.000Z	20000000000	89006802040594	0x43f22e9097040dad579030d3b705ca1f3127034276b614644bfef88270e2de94
0x39aa39c021dfbae8fac545936693ac917d5e7563	false	366	0x10f69553c7b482536155cdc8d904ae833ed55f98	14047093	2022-01-21T05:30:31.000Z	30000000000	133509391018304	0x684bba0fac04f7721e518a799e0190310a94d9dfe40cd82f64bf9ce8e2a5c1cc
0x39aa39c021dfbae8fac545936693ac917d5e7563	false	314	0x1344a36a1b56144c3bc62e7757377d288fde0369	14049879	2022-01-21T16:03:30.000Z	91730614886	408216759714205	0x4ff96d450128212700ec6461eeac8500c46a020ac3b900356452b5f6655e0a1e

Example Query

Query with partition filter

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

CErc20_RepayBorrow_event

Borrow repayment events from Compound V2 cToken (CErc20) contracts on Ethereum, recording when users repay ERC-20 token loans. Contains payer and borrower addresses, repayment amounts, and updated total/account borrow balances for analyzing loan lifecycle and debt 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_payer`	`STRING`	Address of the account that provided the funds for the repayment or payment transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_repayAmount`	`STRING`	Amount of debt repaid in the transaction. Denominated in the smallest unit of the underlying token.
`in_accountBorrows`	`STRING`	Total amount currently borrowed by the individual account. Denominated in the smallest unit of the underlying token.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	in_payer	log_index	in_borrower	block_number	in_repayAmount	block_timestamp	in_totalBorrows	transaction_hash
0x39aa39c021dfbae8fac545936693ac917d5e7563	false	0x0f1dfef1a40557d279d0de6e49ab306891a638b8	9	0x0f1dfef1a40557d279d0de6e49ab306891a638b8	17871037	4000131458195	2023-08-08T15:16:11.000Z	239758567848674	0x3f0aa7d209ebba03d2bedb09f6899863f5f41d32630913e33de2c84dc909544b
0x39aa39c021dfbae8fac545936693ac917d5e7563	false	0x171c53d55b1bcb725f660677d9e8bad7fd084282	240	0x171c53d55b1bcb725f660677d9e8bad7fd084282	17873551	1489622170378	2023-08-08T23:44:11.000Z	238402126034054	0x916ebe3f8dfa0c5c891a9e4fde8aa91ac1c1a52029b0ba52187a1123eb0868b6
0x39aa39c021dfbae8fac545936693ac917d5e7563	false	0x6eaba52965fab0b404bebbda594a2ba72bdb6288	68	0x6eaba52965fab0b404bebbda594a2ba72bdb6288	17868630	10722305	2023-08-08T07:11:47.000Z	226752755870044	0xae762a3536793d90c38502dbf0ce94bd10fc4e57e8fefd41e1369d923a67766a

Example Query

Query with partition filter

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

CErc20_ReservesReduced_event

Reserve withdrawal events from Compound V2 cToken (CErc20) contracts on Ethereum, tracking when protocol admins reduce reserve balances. Records admin address, withdrawal amount, and updated total reserves for analyzing protocol treasury management and reserve accumulation 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_admin`	`STRING`	Address of the administrator or privileged account that initiated or authorized the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_reduceAmount`	`STRING`	Amount of reserves withdrawn from the lending market contract. String-encoded integer representing the token amount in smallest denomination.
`in_newTotalReserves`	`STRING`	Updated total reserves held by the lending market contract after reserves are added or reduced. String-encoded integer representing the token amount in smallest denomination.

Sample Data

address	removed	in_admin	log_index	block_number	block_timestamp	in_reduceAmount	transaction_hash	in_newTotalReserves
0x39aa39c021dfbae8fac545936693ac917d5e7563	false	0x6d903f6003cca6255d85cca4d3b5e5146dc33925	83	12140390	2021-03-30T11:38:04.000Z	27000000000	0x88c07d09327092bf912d7ce81846f75293d6d5d0d7e52d2f5f9eaaf23223b0e4	3021200238289
0xf5dce57282a584d2746faf1593d3121fcac444dc	false	0x6d903f6003cca6255d85cca4d3b5e5146dc33925	289	10906967	2020-09-21T16:46:14.000Z	622000000000000000000	0xb69b01e163aac95559e6fc6ffd496820191c0dd40fd6f278da06df78efdb7383	26049791206409313906138
0xf5dce57282a584d2746faf1593d3121fcac444dc	false	0x6d903f6003cca6255d85cca4d3b5e5146dc33925	61	9133215	2019-12-20T00:48:47.000Z	100000000000000000000000	0x0c8054c3c2cc3825cdb5322ef56c95056a86dd458c9921980a135db4e8eba4d8	25770079704105919224120

Example Query

Query with partition filter

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

CErc20Delegator_AccrueInterest_event

Interest accrual events from Compound v2 cToken (CErc20Delegator) markets on Ethereum, recording cash reserves, total borrows, borrow index updates, and accumulated interest per block. Used for tracking lending market state changes and calculating historical interest rates across different asset 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_cashPrior`	`STRING`	Cash balance in the market prior to the interest accrual event. Denominated in the smallest unit of the underlying token.
`in_interestAccumulated`	`STRING`	Interest accrued during the period since the last interest calculation. Denominated in the smallest unit of the underlying token.
`in_borrowIndex`	`STRING`	Cumulative borrow interest index for the market. Scaled by 1e18, representing the accumulated interest per unit borrowed since market inception.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	log_index	block_number	in_cashPrior	in_borrowIndex	block_timestamp	in_totalBorrows	transaction_hash	in_interestAccumulated
0x041171993284df560249b57358f931d9eb7b925d	false	218	18003377	23401597018265512857634	1075360520401864524	2023-08-27T03:40:11.000Z	10111446150582928241691	0x2f08ba84bab40c76f4ef4d094071672a710ecaee104ddf1e93b74005eaa42a8e	3743983019543127905
0x12392f67bdf24fae0af363c24ac620a2f67dad86	false	4	18003717	464799847938657072181167	1107134657141346439	2023-08-27T04:48:11.000Z	417402749090964513734184	0xea940514d410915784a677fc7f0e3d4148dd9c46e3acfef32cd6020a059e37db	132320211377807775149
0x5d3a536e4d6dbd6114cc1ead35777bab948e3643	false	344	18008273	81378393299951854534281414	1184402041074175059	2023-08-27T20:06:59.000Z	136981167615900017517235231	0x9de162bc8839e9b4ff51f745244182cde4f1a893e87c98a568ab8010dcf34074	1437297843119045044475

Example Query

Query with partition filter

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

CErc20Delegator_Borrow_event

Borrow events from Compound v2 cToken (CErc20Delegator) contracts on Ethereum, capturing individual borrow transactions with amounts, borrower addresses, and updated account/total borrow balances. Used for tracking lending market utilization, borrower behavior, and calculating interest accrual across different cToken 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_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrowAmount`	`STRING`	Amount borrowed in the transaction. Denominated in the smallest unit of the underlying token.
`in_accountBorrows`	`STRING`	Total amount currently borrowed by the individual account. Denominated in the smallest unit of the underlying token.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	log_index	in_borrower	block_number	block_timestamp	in_borrowAmount	in_totalBorrows	transaction_hash	in_accountBorrows
0x35a18000230da775cac24873d00ff85bccded550	false	86	0x9f9ebce72c0715cdbad4d589986eb22f6782a1ce	14332079	2022-03-06T07:44:39.000Z	30014618667367800000	639531334787694432551225	0x0677022d10776097396846816635d17c1b040c7fe9434f7fbe38b519c89f6e88	30014618667367800000
0x35a18000230da775cac24873d00ff85bccded550	false	203	0x7da957bfa534a593618ce9a16216a1ea57b8e941	14335675	2022-03-06T21:19:30.000Z	1610652763859425	639577700980817331326894	0xa7a35ce40aae44860131cc12eac7d065ca013e2229301dd2f89379f64dd0735a	67256266784061910118650
0x5d3a536e4d6dbd6114cc1ead35777bab948e3643	false	328	0x3a0dc3fc4b84e2427ced214c9ce858ea218e97d9	14332998	2022-03-06T11:16:12.000Z	6000000000000000000000000	1384732205722478490168839252	0xcb701fa73748c7fcab2a1195dfc6a6579a63c8f0753a8ae0a5cae132286a902b	6000000000000000000000000

Example Query

Query with partition filter

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

CErc20Delegator_Mint_event

Mint event logs from Compound V2 ERC-20 token markets on Ethereum, capturing when users supply underlying assets to receive cTokens (Compound interest-bearing tokens). Used for tracking lending activity, liquidity provision patterns, and calculating market supply metrics.

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_minter`	`STRING`	Address authorized to mint tokens in the operation. Hex-encoded, 0x-prefixed, 42-character string for EVM chains; 66-character hex string for Aptos.
`in_mintAmount`	`STRING`	Quantity of underlying asset deposited into the lending protocol. Numeric string representing token amount in smallest denomination.
`in_mintTokens`	`STRING`	Quantity of protocol-specific interest-bearing tokens minted to the depositor. Numeric string representing token amount in smallest denomination.

Sample Data

address	removed	in_minter	log_index	block_number	in_mintAmount	in_mintTokens	block_timestamp	transaction_hash
0x35a18000230da775cac24873d00ff85bccded550	false	0x17966f7e987a42d00a633fa0219fded049682406	393	13241116	3857265179901801596255	19068123081065	2021-09-17T04:31:59.000Z	0xbc2d6e8bb2cd89a8ed0bf36942ed5a16e136e34f99d6c938c2b124c8fb3dd230
0x35a18000230da775cac24873d00ff85bccded550	false	0xe82bc6a5364d16d23645054cda1e694f8b69f688	341	13242471	100000000000000000	494342181	2021-09-17T09:43:44.000Z	0xe25718c6e42b4fd203a5d4562bac3cb154ba44315aefe189d53b5f37d0b93064
0x35a18000230da775cac24873d00ff85bccded550	false	0x4717867ccaed2718bdac25f3486861ff87b58eff	87	13241441	5073227905950338844	25079139736	2021-09-17T05:44:38.000Z	0xa4896c2523c45dbbbbcab7c8361c09fea97bff72f6fc287e7ef073ac8368e8fd

Example Query

Query with partition filter

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

CErc20Delegator_NewReserveFactor_event

Reserve factor adjustment events for Compound V2 cToken markets on Ethereum, capturing governance changes to protocol fee percentages (mantissa values represent 18-decimal fractions). Used to track historical reserve policy changes 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_oldReserveFactorMantissa`	`STRING`	Previous reserve factor for the lending market before the update. 18-decimal fixed-point integer stored as string.
`in_newReserveFactorMantissa`	`STRING`	Updated reserve factor for the lending market. 18-decimal fixed-point integer stored as string.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactorMantissa
0x70e36f6bf80a52b3b46b3af8e106cc0ed743e8e4	false	97	11072572	2020-10-17T09:17:06.000Z	0xedb643b35ea58bb570489c205ba122ae9d9412ce117714f38507fbb65e784160	200000000000000000
0xccf4429db6322d5c611ee964527d42e5d685dd6a	false	59	12069867	2021-03-19T14:54:14.000Z	0xa9d9a710ec465fb742346bff8169acf3defae1722b6ca61589006dd6b7e9c374	200000000000000000
0xf650c3d88d12db855b8bf7d11be6c55a4e07dcc9	false	111	10316576	2020-06-22T16:11:52.000Z	0x7ce0617eb9476200d145a46a0fec88435a86fba136bfa82723505164a454c4c7	100000000000000000

Example Query

Query with partition filter

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

CErc20Delegator_Redeem_event

Redemption events from Compound V2 cToken (CErc20Delegator) contracts on Ethereum, recording when users withdraw underlying assets by burning cTokens. Contains redeemer addresses, amounts of both cTokens burned and underlying assets received for tracking lending market 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_redeemer`	`STRING`	Address of the account that initiated the redemption transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_redeemAmount`	`STRING`	Amount of underlying asset tokens withdrawn from the lending pool during redemption.
`in_redeemTokens`	`STRING`	Amount of interest-bearing pool tokens burned during the redemption transaction. String-encoded integer representing the quantity of cTokens or equivalent derivative tokens exchanged for underlying assets.

Sample Data

address	removed	log_index	in_redeemer	block_number	block_timestamp	in_redeemAmount	in_redeemTokens	transaction_hash
0x35a18000230da775cac24873d00ff85bccded550	false	186	0xdb0950c877db658e17a8120e89b4f2ffc4dd6e05	14158434	2022-02-07T10:36:41.000Z	6287459552607355910	31054557500	0x8b2fe25ef9ece1bd613bd284419d17896b303c0686b45598aba88dfb27d0d40d
0x35a18000230da775cac24873d00ff85bccded550	false	496	0x11b50686d3983c14c0d0972a5e46e38e0d9b2e14	14158008	2022-02-07T08:58:07.000Z	51000000000000000000000	251895516310271	0xfcec2244946be247d2e26f43b1f2ffc9dbb4ff21468895a4fc3103fb4e69b7cc
0x35a18000230da775cac24873d00ff85bccded550	false	191	0xdb0950c877db658e17a8120e89b4f2ffc4dd6e05	14158434	2022-02-07T10:36:41.000Z	3553464767498317021282	17551011664600	0x8b2fe25ef9ece1bd613bd284419d17896b303c0686b45598aba88dfb27d0d40d

Example Query

Query with partition filter

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

CErc20Delegator_RepayBorrow_event

Borrow repayment events from Compound v2 ERC-20 lending markets on Ethereum, capturing when users pay down debt positions. Contains repayment amounts, borrower addresses, and updated borrow balances for analyzing deleveraging activity and protocol debt dynamics.

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_payer`	`STRING`	Address of the account that provided the funds for the repayment or payment transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_repayAmount`	`STRING`	Amount of debt repaid in the transaction. Denominated in the smallest unit of the underlying token.
`in_accountBorrows`	`STRING`	Total amount currently borrowed by the individual account. Denominated in the smallest unit of the underlying token.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	in_payer	log_index	in_borrower	block_number	in_repayAmount	block_timestamp	in_totalBorrows	transaction_hash	in_accountBorrows
0x5d3a536e4d6dbd6114cc1ead35777bab948e3643	false	0x023746e8dcdc250ebba98aaa82ce81e27597cbbe	74	0x023746e8dcdc250ebba98aaa82ce81e27597cbbe	10235372	775754677053954472356	2020-06-10T02:51:15.000Z	10656149916602067935280555	0x984ea940838c944407f351df7a144e8298636422ca77a37ff7293dd74e2424cf	0
0x5d3a536e4d6dbd6114cc1ead35777bab948e3643	false	0xed92630f3ffeb8630a255c000f6b7d38a078fa16	133	0xed92630f3ffeb8630a255c000f6b7d38a078fa16	10240953	5028733349281949559800	2020-06-10T23:41:40.000Z	10837976035419117217167831	0xe60bfbbbcaf9f3f3590a68625e927d0e0db20eb5704df388a7535e8de1c3e056	0
0x5d3a536e4d6dbd6114cc1ead35777bab948e3643	false	0xba3481444e4d9df34fb9f4c2aed1ee6435d0bb04	106	0xba3481444e4d9df34fb9f4c2aed1ee6435d0bb04	10235830	68108999999999991808	2020-06-10T04:38:07.000Z	10656186595399273999250637	0xc64584b7898ce92cfcd0b9015243f2305702538f8104e6b117a6f887e5512e05	747504992045752

Example Query

Query with partition filter

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

CErc20Delegator_ReservesAdded_event

Reserve accumulation events from Compound V2 cToken markets on Ethereum, tracking protocol fee accrual with amounts and running totals. Used for analyzing protocol revenue and reserve growth across different asset 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_benefactor`	`STRING`	Address of the account that provided or contributed the reserves being added to the lending market contract. Hex-encoded, 0x-prefixed, 42-character string.
`in_addAmount`	`STRING`	Amount of reserves added to the lending market contract. String-encoded integer representing the token amount in smallest denomination.
`in_newTotalReserves`	`STRING`	Updated total reserves held by the lending market contract after reserves are added or reduced. String-encoded integer representing the token amount in smallest denomination.

Sample Data

address	removed	log_index	block_number	in_addAmount	in_benefactor	block_timestamp	transaction_hash	in_newTotalReserves
0xe65cdb6479bac1e22340e4e755fae7e509ecd06c	false	150	15247415	32122984850487352	0xe65cdb6479bac1e22340e4e755fae7e509ecd06c	2022-07-31T01:52:04.000Z	0x6142ea315ab3209b5e301ce5e5378a6b83e18cbda39bfc8e8a4a113ff996574d	141322481826111478747
0xe65cdb6479bac1e22340e4e755fae7e509ecd06c	false	265	15248125	36393735042126379	0xe65cdb6479bac1e22340e4e755fae7e509ecd06c	2022-07-31T04:31:33.000Z	0x53fad23cd11633ae91cbea8c5ebabdef4914172353c88037e0d8fab8d57d4294	141393240703086218771
0x35a18000230da775cac24873d00ff85bccded550	false	297	15248125	450491085473018344	0x35a18000230da775cac24873d00ff85bccded550	2022-07-31T04:31:33.000Z	0xf225182de7134c87d4cbf35af874397d98f64800600a53bf6211ec25a06fc5b9	60806142890095792094830

Example Query

Query with partition filter

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

CErc20Delegator_ReservesReduced_event

Reserve withdrawal events from Compound v2 ERC-20 lending markets on Ethereum, recording when protocol admin reduces reserves from cToken contracts. Tracks reduction amounts and resulting reserve balances for analyzing protocol treasury management and revenue extraction.

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_admin`	`STRING`	Address of the administrator or privileged account that initiated or authorized the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_reduceAmount`	`STRING`	Amount of reserves withdrawn from the lending market contract. String-encoded integer representing the token amount in smallest denomination.
`in_newTotalReserves`	`STRING`	Updated total reserves held by the lending market contract after reserves are added or reduced. String-encoded integer representing the token amount in smallest denomination.

Sample Data

address	removed	in_admin	log_index	block_number	block_timestamp	in_reduceAmount	transaction_hash	in_newTotalReserves
0x5d3a536e4d6dbd6114cc1ead35777bab948e3643	false	0x6d903f6003cca6255d85cca4d3b5e5146dc33925	155	13244962	2021-09-17T18:51:34.000Z	6817797961061626144874170	0xf3074d39296f482e8c8d934e569b02393aab78da90abf98492c3db2e5d7293a8	10896698946415366291589222
0x7713dd9ca933848f6819f38b8352d9a15ea73f67	false	0x6d903f6003cca6255d85cca4d3b5e5146dc33925	31	16195857	2022-12-16T07:46:59.000Z	6324340499474616104642	0xe161f98e4f51f712dceaefd65d8d25641440bd1270dac6dd9fadb51249f6bead	10107112629494332952
0xf650c3d88d12db855b8bf7d11be6c55a4e07dcc9	false	0x6d903f6003cca6255d85cca4d3b5e5146dc33925	52	20139516	2024-06-21T10:31:47.000Z	9500000000	0x7fe4157e4e7fa2d789b7a22d48fe11c84c5545c52eaf18394c8293391c9e235f	4593995273011

Example Query

Query with partition filter

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

CErc20Delegator_seize_function

Collateral seizure function calls from Compound V2 lending protocol on Ethereum, executed during liquidations to transfer cToken collateral from borrowers to liquidators. Used for analyzing liquidation mechanics, collateral transfers, and protocol 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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_liquidator`	`STRING`	Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_seizeTokens`	`STRING`	Quantity of collateral tokens seized from the borrower during liquidation. Numeric string representing the amount in the smallest unit of the collateral token.
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

gas	status	gas_used	signature	to_address	in_borrower	block_number	from_address	in_liquidator	trace_address	in_seizeTokens	block_timestamp	transaction_hash
436757	true	88239	0xb2a02ff1	0x70e36f6bf80a52b3b46b3af8e106cc0ed743e8e4	0x1c230f1b9deb1ce6c68fda7152d6a725ae08b8e2	22287274	0x5d3a536e4d6dbd6114cc1ead35777bab948e3643	0xbfe1364efb0a1e01241f058a6039f43fea88cfc5	4,2,2,0,11	1536308758	2025-04-17T07:38:47.000Z	0x072c27811907039f0bd688f73100f4cb3e8eb54875dfe0a282b2cd9148b09ec8
393371	true	85200	0xb2a02ff1	0x5d3a536e4d6dbd6114cc1ead35777bab948e3643	0x5b99680bbc3045b82cb009332bdb01fcd3deaaef	22285436	0x35a18000230da775cac24873d00ff85bccded550	0xbfe1364efb0a1e01241f058a6039f43fea88cfc5	4,2,2,0,11	49163618410	2025-04-17T01:28:11.000Z	0xdf7c3b0b697da8007e873f19189bd96327e818f8b7947a431ba9057669c76abf
287769	true	85155	0xb2a02ff1	0x5d3a536e4d6dbd6114cc1ead35777bab948e3643	0x152490ebe10209f8a4028b1747406605be2885c2	22286906	0xccf4429db6322d5c611ee964527d42e5d685dd6a	0xbfe1364efb0a1e01241f058a6039f43fea88cfc5	4,2,2,0,11	52999610751	2025-04-17T06:24:59.000Z	0xbf5ebd600b6a7819e34d32b6a77218621144799a8c1b950a78d6ece33dfb9740

Example Query

Query with partition filter

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

CEther_AccrueInterest_event

Interest accrual events from Compound v2’s cETH (Compound Ether) market on Ethereum, capturing when interest is calculated and applied to total borrows. Used for tracking lending pool interest rate mechanics, borrower cost accumulation, and protocol revenue generation over time.

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_interestAccumulated`	`STRING`	Interest accrued during the period since the last interest calculation. Denominated in the smallest unit of the underlying token.
`in_borrowIndex`	`STRING`	Cumulative borrow interest index for the market. Scaled by 1e18, representing the accumulated interest per unit borrowed since market inception.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	log_index	block_number	in_borrowIndex	block_timestamp	in_totalBorrows	transaction_hash	in_interestAccumulated
0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5	false	125	18003413	1125535753398776928	2023-08-27T03:47:23.000Z	8855725295918665264109	0x6ccbbfd36fc8ce361187dcaf4acf05923d02fd04794e20f6d25617fa05becf52	82893797307216846
0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5	false	97	18004619	1125549731627131607	2023-08-27T07:49:23.000Z	8856635281043829686129	0xb93cf80009b1d0f34d436e115b75e64c886ae6199227f9c456b7e465ad43836f	38123587764981608
0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5	false	222	18006104	1125566957712941590	2023-08-27T12:48:47.000Z	8856770828283593529161	0xe47be2deaf57f4b99a53498bc6096faf5f0fcbebf49b2cdad544c53135247c33	0

Example Query

Query with partition filter

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

CEther_Borrow_event

ETH borrow events from Compound V2 protocol on Ethereum, tracking when users take out ETH loans with borrower address, amount borrowed, and cumulative protocol borrow totals. Used for analyzing borrowing activity, leverage trends, and individual account debt positions.

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_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrowAmount`	`STRING`	Amount borrowed in the transaction. Denominated in the smallest unit of the underlying token.
`in_accountBorrows`	`STRING`	Total amount currently borrowed by the individual account. Denominated in the smallest unit of the underlying token.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	log_index	in_borrower	block_number	block_timestamp	in_borrowAmount	in_totalBorrows	transaction_hash	in_accountBorrows
0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5	false	267	0xbbedafd5f399be88dac7222ce1caa9dd7cfd7481	10932342	2020-09-25T14:25:22.000Z	1170000000000000000	73673655047197259012051	0x5fcc1109f1009428c62f7fd2597cff5e29776c5c9dc7498a8a0f8d07a7bb5ba2	1170000000000000000
0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5	false	140	0x7b39d66aa826f025e6f4f8f89df0675fe6e4f59c	10928900	2020-09-25T01:40:35.000Z	4000000000000000000	64930884903654717001510	0xd2c4dc86569fa05c48554fde89a0933ffb1bfc8ed9c58422c5043a8b07458123	4000000000000000000
0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5	false	108	0xd3675438ff47c7812ba5ab17ae1e59533d83578d	10929073	2020-09-25T02:19:13.000Z	4000000000000000000	64932037069497612463956	0x247aa1abdc046ed925cb17dc9b252e8ec00c49315bfcb1e7b47e930d160edcb1	4000000000000000000

Example Query

Query with partition filter

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

CEther_Mint_event

Mint events from Compound V2’s cEther market on Ethereum, recording when users deposit ETH and receive cETH tokens in return. Tracks the minter address, ETH amount supplied, and cTokens minted for analyzing lending activity and market utilization.

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_minter`	`STRING`	Address authorized to mint tokens in the operation. Hex-encoded, 0x-prefixed, 42-character string for EVM chains; 66-character hex string for Aptos.
`in_mintAmount`	`STRING`	Quantity of underlying asset deposited into the lending protocol. Numeric string representing token amount in smallest denomination.
`in_mintTokens`	`STRING`	Quantity of protocol-specific interest-bearing tokens minted to the depositor. Numeric string representing token amount in smallest denomination.

Sample Data

address	removed	in_minter	log_index	block_number	in_mintAmount	in_mintTokens	block_timestamp	transaction_hash
0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5	false	0x0046cfd55e0047d6a7f096efeb3bf0ed00bf8c8c	74	9333000	800000000000000000	3997771011	2020-01-22T18:21:26.000Z	0x73328730f5b38a245bc935490c865e4d6e97764a57d5598065ac9a3f147d3da4
0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5	false	0x22a3d3b69f0e3640acf1d5a2382b9344b7fc5c43	75	9330332	5999000000000000000	29978292306	2020-01-22T08:37:09.000Z	0x6d8aa1f07f446f0a8ce4105b941e598db27c470b0e61b22e643894df45f09848
0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5	false	0x2d19f32620f647d08fa8b9a0fa5206fae15c0ed5	66	9329785	6000000000000000000	29983290812	2020-01-22T06:36:13.000Z	0x15e76b5f9c19322259ebcbf33675b73478b5f5d3da4ffa8403a4a191079f05fd

Example Query

Query with partition filter

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

CEther_NewReserveFactor_event

Reserve factor parameter changes for Compound v2’s cETH market on Ethereum, tracking governance adjustments to the protocol’s reserve allocation percentage. Events show old and new reserve factor values (in mantissa format, 18 decimals) used for analyzing fee structure evolution.

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_oldReserveFactorMantissa`	`STRING`	Previous reserve factor for the lending market before the update. 18-decimal fixed-point integer stored as string.
`in_newReserveFactorMantissa`	`STRING`	Updated reserve factor for the lending market. 18-decimal fixed-point integer stored as string.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactorMantissa	in_oldReserveFactorMantissa
0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5	false	19	7710769	2019-05-07T01:27:33.000Z	0x993f40d11754d20296538074d6ca256f4a7d6b41c1082f9317033ef1df18e5a2	100000000000000000	0
0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5	false	151	11438576	2020-12-12T14:10:16.000Z	0x72198c8f10a1958aa97b2f1408700209a14e026e81fabba866e03668e5879c8d	200000000000000000	100000000000000000
0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5	false	172	23969453	2025-12-08T17:04:11.000Z	0xf79dd9f698bd041f665f19d176ad2b57d9a316099cf523e3818007b2d87a88a2	1000000000000000000	200000000000000000

Example Query

Query with partition filter

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

CEther_Redeem_event

Redemption events from Compound V2’s cETH market on Ethereum, recording when users withdraw ETH by burning cETH tokens. Contains redeemer addresses, underlying ETH amounts, and cToken quantities burned for analyzing lending market withdrawals and liquidity flows.

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_redeemer`	`STRING`	Address of the account that initiated the redemption transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_redeemAmount`	`STRING`	Amount of underlying asset tokens withdrawn from the lending pool during redemption.
`in_redeemTokens`	`STRING`	Amount of interest-bearing pool tokens burned during the redemption transaction. String-encoded integer representing the quantity of cTokens or equivalent derivative tokens exchanged for underlying assets.

Sample Data

address	removed	log_index	in_redeemer	block_number	block_timestamp	in_redeemAmount	in_redeemTokens	transaction_hash
0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5	false	11	0x00000000af5a61acaf76190794e3fdf1289288a1	8830488	2019-10-28T22:47:23.000Z	1299375071750554860	6493640592	0xeab57547ce320c5bdb6309627f2f5f49ec4366c948665b0d0c48aabbdf48694a
0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5	false	21	0x0006e4548aed4502ec8c844567840ce6ef1013f5	8828683	2019-10-28T15:43:09.000Z	460002978472720769043	2298870488641	0x61749db7624f86c223fffb16e7978e2f98673035a13e67f2ff99acd2b0e6fd4d
0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5	false	10	0x08072a5fbc90eed1ca4fb863c1df8aa1fec61cfa	8825720	2019-10-28T04:31:15.000Z	500000000000000000	2498757443	0x29be58dcc6ba954ff0698cfcdc2dba1138869434d74c5b4914e76248ab984e25

Example Query

Query with partition filter

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

CEther_RepayBorrow_event

ETH borrow repayment events from Compound v2 on Ethereum, tracking when users or liquidators repay ETH debts including payer, borrower, repayment amounts, and updated account/total borrow balances.

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_payer`	`STRING`	Address of the account that provided the funds for the repayment or payment transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_repayAmount`	`STRING`	Amount of debt repaid in the transaction. Denominated in the smallest unit of the underlying token.
`in_accountBorrows`	`STRING`	Total amount currently borrowed by the individual account. Denominated in the smallest unit of the underlying token.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	in_payer	log_index	in_borrower	block_number	in_repayAmount	block_timestamp	in_totalBorrows	transaction_hash	in_accountBorrows
0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5	false	0x650858987c1c9dede58db385c50649668e817887	10	0x568238900d9e830fed95610f0c94a029cf18f559	8548213	2439310421227220000	2019-09-14T14:14:24.000Z	7217972913758377534862	0x415bc3394816e3ac73d2110e4f1e83d557e3e163d2a15d7d307208f5a878827d	2439311049613694049
0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5	false	0x9b4e28020b94b28f9f09ede87f588e89c283cffd	92	0x1261cf753c2006ab2455fb8fdf45c549553984d4	8548682	25300000000000000	2019-09-14T16:08:49.000Z	7411100757016080657571	0xea41d0e184a678f40d2826c480bebb04e27bf64cc4f2cecaff2a26542bff2b3c	25903446377444864
0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5	false	0xc479501d96f67c1adc7ed30e0ee5b3ab890a23a8	40	0xc479501d96f67c1adc7ed30e0ee5b3ab890a23a8	8547972	103203980923066949	2019-09-14T13:18:30.000Z	7215391863246833473543	0x4b1b54882c42b443ed43a6e838897fff9aa0570effad6e62512b9adc6e455b0c	0

Example Query

Query with partition filter

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

CEther_ReservesReduced_event

No description available.

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_admin`	`STRING`	Address of the administrator or privileged account that initiated or authorized the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_reduceAmount`	`STRING`	Amount of reserves withdrawn from the lending market contract. String-encoded integer representing the token amount in smallest denomination.
`in_newTotalReserves`	`STRING`	Updated total reserves held by the lending market contract after reserves are added or reduced. String-encoded integer representing the token amount in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Comptroller_DistributedBorrowerComp_event

COMP governance token reward distributions to borrowers on Compound V2 lending markets on Ethereum. Tracks the amount of COMP earned per borrower per cToken market with accumulator index for calculating accrued rewards.

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_cToken`	`STRING`	Contract address of the cToken representing a money market on the Compound protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_compDelta`	`STRING`	Amount of COMP governance tokens distributed to the user in this event. Integer value denominated in the smallest token unit (wei).
`in_compBorrowIndex`	`STRING`	Index representing the cumulative COMP accrued per unit of borrow for the specified cToken market. Used to calculate borrower rewards between distribution events in Compound v2.

Sample Data

address	removed	in_cToken	log_index	in_borrower	block_number	in_compDelta	block_timestamp	transaction_hash	in_compBorrowIndex
0x3d9819210a31b4961b30ef54be2aed79b9c9cd3b	false	0x5d3a536e4d6dbd6114cc1ead35777bab948e3643	239	0x05f67b8b7a2a8bb065d89c9f7fa41775612f683b	14207353	0	2022-02-15T00:01:51.000Z	0x7f7fa8cdaf681e2839db7123f2b98622c8a6b4fd42ceef1b1847c5ff692e7e03	335111019855500552512654688948643
0x3d9819210a31b4961b30ef54be2aed79b9c9cd3b	false	0x39aa39c021dfbae8fac545936693ac917d5e7563	239	0x0b498ff89709d3838a063f1dfa463091f9801c2b	14209705	825649199741700102	2022-02-15T08:42:59.000Z	0x0936a273893d2b2c6bb67d85f2289e1baf31c40aa84d4ba9b3dc35a3786e6dff	411424074130254734654414056028638932869331753
0x3d9819210a31b4961b30ef54be2aed79b9c9cd3b	false	0x39aa39c021dfbae8fac545936693ac917d5e7563	46	0x0b498ff89709d3838a063f1dfa463091f9801c2b	14207449	2346052883620054536	2022-02-15T00:23:38.000Z	0x15d1784fea9ac54066ca24357f00a0e36b8005c670567f1b3369c17834c7aaf3	411305014195130270950341645184619558867834922

Example Query

Query with partition filter

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

Comptroller_DistributedSupplierComp_event

COMP token distribution events to suppliers in Compound v2 lending markets on Ethereum. Tracks governance token rewards earned by liquidity providers, including the reward amount (compDelta), recipient address, and cToken market where interest was supplied.

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_cToken`	`STRING`	Contract address of the cToken representing a money market on the Compound protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_supplier`	`STRING`	Address of the user who supplied assets to the lending protocol and is receiving reward tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_compDelta`	`STRING`	Amount of COMP governance tokens distributed to the user in this event. Integer value denominated in the smallest token unit (wei).
`in_compSupplyIndex`	`STRING`	Index tracking the cumulative COMP token distribution rate per unit of supplied assets in the specified cToken market. This high-precision value is used to calculate individual supplier rewards based on their supply positions.

Sample Data

address	removed	in_cToken	log_index	in_supplier	block_number	in_compDelta	block_timestamp	transaction_hash	in_compSupplyIndex
0x3d9819210a31b4961b30ef54be2aed79b9c9cd3b	false	0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5	19	0x6455c07be90f40d51b041e128b2c4b00c56de508	10592955	258534692643135	2020-08-04T11:22:12.000Z	0x03fcec10885cb9d4ea5350790f1886c49158fa8a4410dab1c6d37be38dfafc88	244722432943830496904295216782290748317551
0x3d9819210a31b4961b30ef54be2aed79b9c9cd3b	false	0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5	220	0xea19eed544377de75dfd5b9dc59811e70b7b8963	10595099	100713363188126090	2020-08-04T19:10:36.000Z	0xf4be2551938ca934a9935a0ef549465108c9bcc78b32ce471cac6cf6ea23b93e	247203120636515185431469202914689361907823
0x3d9819210a31b4961b30ef54be2aed79b9c9cd3b	false	0x5d3a536e4d6dbd6114cc1ead35777bab948e3643	44	0x58a51ef05523a03924be1d223718709d4249d9db	10592929	709758998118375	2020-08-04T11:16:32.000Z	0xb8fbf49e5d0a089e824f478cce0e93517b618d5a057d1f505c7bde65fc2d6b2f	13441549588364783416262368837879314974155

Example Query

Query with partition filter

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

Comptroller_MarketEntered_event

Event logs emitted when an account enters a lending market in a Compound-based protocol, enabling the account to use deposited assets as collateral for borrowing. Records the account address and market token address (cToken, mToken, or vToken) for tracking collateral activation across lending protocols.

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_cToken`	`STRING`	Contract address of the cToken representing a money market on the Compound protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_cToken	log_index	in_account	block_number	block_timestamp	transaction_hash
0x3d9819210a31b4961b30ef54be2aed79b9c9cd3b	false	0x158079ee67fce2f58472a96584a73c7ab9ac95c1	8	0xd3b1e0e3f28b362267e2e555c70947e3125264d1	11327719	2020-11-25T13:17:55.000Z	0xdc75e17ee8c646529a63978615766a2ae277dcaef45937685d44aab498258b1a
0x3d9819210a31b4961b30ef54be2aed79b9c9cd3b	false	0x35a18000230da775cac24873d00ff85bccded550	329	0xf9f3f6a90c6630f22c631b5e4caf56c5c011044c	11324923	2020-11-25T02:43:27.000Z	0x70521425d6eafdcdb0dbf3a4e8e65e9b87f083a07e6bde74516f35e7277efc3f
0x3d9819210a31b4961b30ef54be2aed79b9c9cd3b	false	0x35a18000230da775cac24873d00ff85bccded550	96	0x2a69ad681b4914d0401a764745b057fee6f1abed	11330392	2020-11-25T23:07:39.000Z	0xadab43bf9c3cd69cddd7484b6ed4af79f3df3e765a0cf4872ed867bf0bb570af

Example Query

Query with partition filter

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

Comptroller_MarketExited_event

Event logs recording when an account exits a lending market in the Comptroller contract. Contains account address and corresponding token market (cToken or vToken) that was exited.

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_cToken`	`STRING`	Contract address of the cToken representing a money market on the Compound protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_cToken	log_index	in_account	block_number	block_timestamp	transaction_hash
0x3d9819210a31b4961b30ef54be2aed79b9c9cd3b	false	0xccf4429db6322d5c611ee964527d42e5d685dd6a	311	0x5d5f7249db5f5fe6dba66bbe378695ccabd188a0	14675971	2022-04-29T00:13:34.000Z	0x23f0390d54b5f222d5abfaa2c9b5a49b6962155d2830c9f9db97318d20944353
0x3d9819210a31b4961b30ef54be2aed79b9c9cd3b	false	0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5	198	0xdd34e8b806de4f98309bb272eca1c36c6ddcf3b8	14681596	2022-04-29T21:22:13.000Z	0x785223f47fe82a52eb0ddf2e93cb790f563559d5fb253b85d2f9bdee479d35ce
0x3d9819210a31b4961b30ef54be2aed79b9c9cd3b	false	0x35a18000230da775cac24873d00ff85bccded550	469	0x491766626a77edf814f8ec13bb41372552621918	13700888	2021-11-28T06:45:03.000Z	0x7411fd63cdf92bc7c630eb8402a21ea4d72c1e7c64ccc880c5acfe8d16278081

Example Query

Query with partition filter

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

CToken_Transfer_event

cToken transfer events from Compound V2 lending protocol on Ethereum, tracking movements of interest-bearing tokens (cDAI, cUSDC, etc.) between addresses. Used for analyzing lending positions, collateral movements, and liquidity provider 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_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
0x0af5d0723708587ff94ad29f937d6da5d357748f	0x5d3a536e4d6dbd6114cc1ead35777bab948e3643	0x307d2635ce077719364d572239459d142a8e78c3	false	174859748432	228	10959086	2020-09-29T18:58:39.000Z	0x84e831e7141e44082622e122fe816b47ddc9be7a5ddc60e9e8f68159fca18981
0x0cfe7968e7c34a51217a7c9b9dc1690f416e027e	0x5d3a536e4d6dbd6114cc1ead35777bab948e3643	0x213353406af8bc04023e497a9997903509615718	false	369267838967537	151	10957400	2020-09-29T12:24:28.000Z	0x18159d6eae915a1d22253ad67f6d55dc075eca2c1e598ffeb267683ff4ba5f6e
0x0cfe7968e7c34a51217a7c9b9dc1690f416e027e	0x5d3a536e4d6dbd6114cc1ead35777bab948e3643	0x213353406af8bc04023e497a9997903509615718	false	787055882252398	224	10957140	2020-09-29T11:30:13.000Z	0x7a50e08ad1a26a7949f072960ad18524490c90ab5025a1cb886e5f360e8b59f6

Example Query

Query with partition filter

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

CTokenCollateral_Transfer_event

Transfer events of cToken collateral in Compound v2 lending protocol on Ethereum, tracking movement of interest-bearing tokens between addresses. Used for analyzing collateral flows, liquidations, and lending 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_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
0xe67fc443fa1d4927bd9611b8cf50745618b12a04	0x0000000000085d4780b73119b644ae5ecd22b376	0x1bac08001d761c303901d5e32273a24c07d3f3da	false	1000000000000000000000	322	17720065	2023-07-18T12:17:47.000Z	0xa506c08210c0f587dab28f3cdfb2451d87989bd1153aa8636acb9b6683714b4d
0x39529e96c28807655b5856b3d342c6225111770e	0x0000000000085d4780b73119b644ae5ecd22b376	0x22f9dcf4647084d6c31b2765f6910cd85c178c18	false	1202556696358138135117	13	17722897	2023-07-18T21:51:11.000Z	0x2f7f680baacd72cb8d74a968aa1cb493b6ab82d4815b483ae1a2535ea700c943
0x22f9dcf4647084d6c31b2765f6910cd85c178c18	0x0000000000085d4780b73119b644ae5ecd22b376	0x18fe535e28888754720e1aec1443c7a736961823	false	1202556696358138135117	10	17722897	2023-07-18T21:51:11.000Z	0x2f7f680baacd72cb8d74a968aa1cb493b6ab82d4815b483ae1a2535ea700c943

Example Query

Query with partition filter

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

Liquidator_setTreasuryPercent_function

Administrative function calls to adjust treasury fee percentages on Compound V2 Ethereum liquidator contracts. Used for tracking governance changes to protocol revenue allocation from liquidation events.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_newTreasuryPercentMantissa`	`STRING`	New treasury percentage value being set, expressed in mantissa format (scaled by 1e18) where 100 represents 100e-18 or 0.0000000000000001%. Specified as input parameter when updating the protocol’s treasury fee allocation.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash	in_newTreasuryPercentMantissa
978808	true	5466	0x89a2bc25	0x2f6081e3552b1c86ce4479b80062a1dda8ef23e3	11808856	0x89a359a3d37c3a857e62cde9715900441b47acec		2021-02-07T10:59:02.000Z	0x37b0be2c439b030bd736f3387dd9b54b22201c65a8ed2606346111fc816318e9	0
960830	true	2698	0x89a2bc25	0xdc170f6d2d09dec9e10f3b9dfd053e2d7b35f864	11808856	0x2f6081e3552b1c86ce4479b80062a1dda8ef23e3	0	2021-02-07T10:59:02.000Z	0x37b0be2c439b030bd736f3387dd9b54b22201c65a8ed2606346111fc816318e9	0
28248	true	11764	0x89a2bc25	0x2c196bd817134696f23ebf6a7368527cc59b658f	15364782	0xc2c3b789dcabe082c7e37029a847acd8301b8f04		2022-08-18T11:38:38.000Z	0x86a939d18aaa146e9ccc39635fe7831d54dd19883468fa45c60ac74f0682b937	100

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

CErc20_AccrueInterest_event

CErc20_Borrow_event

CErc20_Mint_event

CErc20_NewReserveFactor_event

CErc20_Redeem_event

CErc20_RepayBorrow_event

CErc20_ReservesReduced_event

CErc20Delegator_AccrueInterest_event

CErc20Delegator_Borrow_event

CErc20Delegator_Mint_event

CErc20Delegator_NewReserveFactor_event

CErc20Delegator_Redeem_event

CErc20Delegator_RepayBorrow_event

CErc20Delegator_ReservesAdded_event

CErc20Delegator_ReservesReduced_event

CErc20Delegator_seize_function

CEther_AccrueInterest_event

CEther_Borrow_event

CEther_Mint_event

CEther_NewReserveFactor_event

CEther_Redeem_event

CEther_RepayBorrow_event

CEther_ReservesReduced_event

Comptroller_DistributedBorrowerComp_event

Comptroller_DistributedSupplierComp_event

Comptroller_MarketEntered_event

Comptroller_MarketExited_event

CToken_Transfer_event

CTokenCollateral_Transfer_event

Liquidator_setTreasuryPercent_function

​Tables

​CErc20_AccrueInterest_event

​CErc20_Borrow_event

​CErc20_Mint_event

​CErc20_NewReserveFactor_event

​CErc20_Redeem_event

​CErc20_RepayBorrow_event

​CErc20_ReservesReduced_event

​CErc20Delegator_AccrueInterest_event

​CErc20Delegator_Borrow_event

​CErc20Delegator_Mint_event

​CErc20Delegator_NewReserveFactor_event

​CErc20Delegator_Redeem_event

​CErc20Delegator_RepayBorrow_event

​CErc20Delegator_ReservesAdded_event

​CErc20Delegator_ReservesReduced_event

​CErc20Delegator_seize_function

​CEther_AccrueInterest_event

​CEther_Borrow_event

​CEther_Mint_event

​CEther_NewReserveFactor_event

​CEther_Redeem_event

​CEther_RepayBorrow_event

​CEther_ReservesReduced_event

​Comptroller_DistributedBorrowerComp_event

​Comptroller_DistributedSupplierComp_event

​Comptroller_MarketEntered_event

​Comptroller_MarketExited_event

​CToken_Transfer_event

​CTokenCollateral_Transfer_event

​Liquidator_setTreasuryPercent_function

Tables

CErc20_AccrueInterest_event

CErc20_Borrow_event

CErc20_Mint_event

CErc20_NewReserveFactor_event

CErc20_Redeem_event

CErc20_RepayBorrow_event

CErc20_ReservesReduced_event

CErc20Delegator_AccrueInterest_event

CErc20Delegator_Borrow_event

CErc20Delegator_Mint_event

CErc20Delegator_NewReserveFactor_event

CErc20Delegator_Redeem_event

CErc20Delegator_RepayBorrow_event

CErc20Delegator_ReservesAdded_event

CErc20Delegator_ReservesReduced_event

CErc20Delegator_seize_function

CEther_AccrueInterest_event

CEther_Borrow_event

CEther_Mint_event

CEther_NewReserveFactor_event

CEther_Redeem_event

CEther_RepayBorrow_event

CEther_ReservesReduced_event

Comptroller_DistributedBorrowerComp_event

Comptroller_DistributedSupplierComp_event

Comptroller_MarketEntered_event

Comptroller_MarketExited_event

CToken_Transfer_event

CTokenCollateral_Transfer_event

Liquidator_setTreasuryPercent_function