compoundforks_v2_optimism

Tables

Comptroller_NewLiquidationIncentive_event

Comptroller governance event emitted when the liquidation incentive parameter is updated. Records old and new mantissa values (18-decimal scaled integers) representing the bonus percentage liquidators receive for repaying undercollateralized loans in Compound-based 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_oldLiquidationIncentiveMantissa`	`STRING`	Previous liquidation incentive parameter in mantissa format. 18-decimal fixed-point integer representation where 1e18 equals 1.0 (e.g., ‘1080000000000000000’ represents 1.08 or 8% incentive).
`in_newLiquidationIncentiveMantissa`	`STRING`	Updated liquidation incentive parameter in mantissa format. 18-decimal fixed-point integer representation where 1e18 equals 1.0 (e.g., ‘1080000000000000000’ represents 1.08 or 8% incentive).

Sample Data

address	removed	block_number	block_timestamp	transaction_hash	in_newLiquidationIncentiveMantissa
0xe0b57feed45e7d908f2d0dacd26f113cf26715bf	false	12660700	2022-06-22T07:12:00.000Z	0xdd4772093877aaecef3d0b5773117d4d54a347fbac339df28700b9d99a30d3ae	1080000000000000000
0x896aecb9e73bf21c50855b7874729596d0e511cb	false	33038	2021-11-13T02:42:43.000Z	0x15a3935e9a28d405b3bcaf39a7ffc2d09ff5d22b50c111e30ff59ed086abacc8	1080000000000000000
0x60cf091cd3f50420d50fd7f707414d0df4751c58	false	26548059	2022-09-30T17:37:06.000Z	0x2f7ad626143d94e43a130998c28418222271de444252da263e70b10f7b33e5f8	1080000000000000000

Example Query

Query with partition filter

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

CToken_AccrueInterest_event

Interest accrual events from Compound fork lending markets on Optimism, capturing periodic updates to borrow indexes and accumulated interest. Used for analyzing borrowing costs, yield generation, and protocol health 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_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
0x33865e09a572d4f1cc4d75afc9abcc5d3d4d867d	false	67	111632210	24780809214	1088792258990907395	2023-11-01T18:26:37.000Z	4190879835	0x2e36a66d90f4f06adce5e85f780285f52975fe8f899db18f717e98b18cea6560	4322
0x33865e09a572d4f1cc4d75afc9abcc5d3d4d867d	false	155	111636243	24785038317	1088809156623936797	2023-11-01T20:41:03.000Z	4186872609	0xb923092a8caea49018bbda9096b4d59dc3694a79c8f6aa91cc5c2eda6bf26fcc	1465
0x5ff29e4470799b982408130efaabdeeae7f66a10	false	172	111614562	1262683682922	1067136500873011435	2023-11-01T08:38:21.000Z	6983545572197	0x806d6b324f3d28193667fecdfc83b1138a7c4eb2f15e0dc831bb217d345e76d6	80347358

Example Query

Query with partition filter

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

CToken_Borrow_event

Borrow event logs from Compound V2 fork lending markets on Optimism, recording loan originations with borrower address, amount borrowed, and updated account and total borrow balances. Used for tracking lending protocol utilization and individual borrower debt positions 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
0x1d073cf59ae0c169cbc58b6fdd518822ae89173a	false	2	0x6870c0f827522bdf847a11999ac685f71ed4c959	21686350	2022-09-02T13:15:08.000Z	400000000	1420872583295	0x950f216da40a029de3f13b14ffa70bf15ed2f4adcd03a322c53c7201e4db6617	2600363089
0x1d073cf59ae0c169cbc58b6fdd518822ae89173a	false	12	0xffa51a5ec855f8e38dd867ba503c454d8bbc5ab9	21707259	2022-09-02T16:20:40.000Z	283647	1437060180558	0xd2e412cc221f5b08c6903e42e74148fd12532362af3070e13a31606b86985434	1426809581591
0x17533a1bde957979e3977ebbfbc31e6deeb25c7d	false	5	0xffa51a5ec855f8e38dd867ba503c454d8bbc5ab9	21707259	2022-09-02T16:20:40.000Z	2873151575121014	1562474355338269017551	0xd2e412cc221f5b08c6903e42e74148fd12532362af3070e13a31606b86985434	1562410440567775791757

Example Query

Query with partition filter

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

CToken_LiquidateBorrow_event

Liquidation events from Compound V2 forks on Optimism, capturing when undercollateralized positions are liquidated with borrower/liquidator addresses, repayment amounts, and seized collateral tokens. Used for analyzing liquidation activity, liquidator profitability, and protocol risk management across Compound-compatible 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_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_repayAmount`	`STRING`	Amount of debt repaid in the transaction. Denominated in the smallest unit of the underlying token.
`in_CTokenCollateral`	`STRING`	Contract address of the cToken received as collateral during liquidation. This represents the collateral market where seized tokens are transferred from the borrower to the liquidator.
`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.

Sample Data

address	removed	log_index	in_borrower	block_number	in_liquidator	in_repayAmount	in_seizeTokens	block_timestamp	transaction_hash	in_CTokenCollateral
0x8cd6b19a07d754bf36adeee79edf4f2134a8f571	false	12	0x1b56403289ce09ed7afe2e11b220cf373cb043a0	48107899	0x44257b9171d5e3b6c01bb8fd64a617a1b8b71624	18484101104470001051	97990913066	2022-12-11T18:33:09.000Z	0xf371829b0b2befa8bdc1fe5033afc11da9433da8ac428443fa963a9c5bb2cdd4	0x8cd6b19a07d754bf36adeee79edf4f2134a8f571
0x8cd6b19a07d754bf36adeee79edf4f2134a8f571	false	14	0x1b56403289ce09ed7afe2e11b220cf373cb043a0	48139289	0x44257b9171d5e3b6c01bb8fd64a617a1b8b71624	2784191098507206640400	14759675506636	2022-12-11T20:53:25.000Z	0x69e68932304cc4032800638417dd6e3d8e4c790846068b7efacfe30c0860d76a	0x8cd6b19a07d754bf36adeee79edf4f2134a8f571
0x5ff29e4470799b982408130efaabdeeae7f66a10	false	14	0xe2255aea86b7b11ca757f9721478008c599d4014	47787987	0x44257b9171d5e3b6c01bb8fd64a617a1b8b71624	11408950	60620276939	2022-12-11T03:25:11.000Z	0x7076014ec325005ec0cbdc7263aede5770346fa75ea74660d21f0efefa650737	0xd14451e0fa44b18f08aeb1e4a4d092b823caca68

Example Query

Query with partition filter

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

CToken_Mint_event

Mint events from Compound protocol forks on Optimism, recording when users deposit underlying assets to receive cTokens (interest-bearing tokens). Used to track lending pool deposits and liquidity provision across Compound-compatible 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_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	log_index	block_number	block_timestamp	transaction_hash
0x0493bf8b6dbb159ce2db2e0e8403e753abd1235b	false	77	121907700	2024-06-26T15:02:57.000Z	0xd44a31bb30e180fe811573cb258649ca643eb9c2ea94308b5410633e2deee6eb
0x0493bf8b6dbb159ce2db2e0e8403e753abd1235b	false	77	121922142	2024-06-26T23:04:21.000Z	0x9aea13946bcd5a59fc3f95e2117758db3a21d1a8410b05c7971d6c5c298dbd65
0x0493bf8b6dbb159ce2db2e0e8403e753abd1235b	false	414	121919635	2024-06-26T21:40:47.000Z	0x5090886cffa9b2869382727325e1a2e817c6de827d500a38437edb61628d3f59

Example Query

Query with partition filter

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

CToken_NewProtocolSeizeShare_event

Protocol fee parameter updates for liquidation seizures in Compound V2 fork markets on Optimism. Tracks changes to the protocol’s share of collateral seized during liquidations, with mantissa values representing the fee percentage (3% in samples).

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_oldProtocolSeizeShareMantissa`	`STRING`	Previous protocol seize share value in mantissa format. Represented as a string-encoded integer with 18 decimal places of precision.
`in_newProtocolSeizeShareMantissa`	`STRING`	Updated protocol seize share value in mantissa format. Represented as a string-encoded integer with 18 decimal places of precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newProtocolSeizeShareMantissa
0x866b838b97ee43f2c818b3cb5cc77a0dc22003fc	false	47	123647443	2024-08-05T21:34:23.000Z	0x624c6928854fec4de5ab9c345f7dce722fd99febf2112e82ee2caa3c40640b65	30000000000000000
0x181ba797ccf779d8ab339721ed6ee827e758668e	false	54	126545119	2024-10-11T23:23:35.000Z	0x43e2ebed1be884e0f0a26a3c0302e53c657f0f3865a8fe005d4bad72b1edf66c	30000000000000000
0xa3a53899ee8f9f6e963437c5b3f805fec538bf84	false	66	122531557	2024-07-11T01:38:11.000Z	0xc6661dacead95c66be457083985009461056df5da534c647da1a42e489cdfbd9	30000000000000000

Example Query

Query with partition filter

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

CToken_NewReserveFactor_event

Reserve factor parameter changes for Compound-fork lending markets on Optimism, tracking updates to the protocol’s fee percentage stored as mantissa values (e.g., 100000000000000000 = 10%). Used to monitor governance decisions affecting protocol revenue allocation between reserves and lenders.

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
0xe7de932d50efc9ea0a7a409fc015b4f71443528e	false	3	106521586	2023-07-06T11:12:29.000Z	0xf6edbbdb5ca0ab50c6692df2bc682ae252002292674316af2fa70f43eb964bba	200000000000000000
0x9f4089ea33773a090ac514934517990df04ae5a7	false	26	121645139	2024-06-20T13:10:55.000Z	0x044c13bae41921f47b86da41f6837db3ad5f94f7e71aa451c622cbb56e10ed59	100000000000000000
0x53b1d15b24d93330b2fd359c798de7183255e7f2	false	8	121645069	2024-06-20T13:08:35.000Z	0xd4597671c10fef00df4b90c6454a36513ef2414b41cb5acb4bba818b7ea97277	100000000000000000

Example Query

Query with partition filter

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

CToken_Redeem_event

Redemption events from Compound V2 fork lending markets on Optimism, tracking when users withdraw underlying assets by burning cTokens. Used for analyzing withdrawal patterns, liquidity flows, and cToken-to-underlying exchange rates in 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_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_redeeCTokens`	`STRING`	Amount of cTokens (Compound protocol interest-bearing tokens) being redeemed by the user in this transaction. Value is represented in the smallest unit of the cToken (wei-equivalent), and may be null for failed or incomplete redemption events.

Sample Data

address	removed	log_index	in_redeemer	block_number	block_timestamp	in_redeeCTokens	in_redeemAmount	transaction_hash
0x5039cde9ed71256be27a36440380f36cad45d270	false	22		115369217	2024-01-27T06:33:31.000Z			0xbdc8d5b287dd95303b3ad22cf73169d1960dc49f3721d346fd23ed2d8349589a
0x722ef09f933f09069257c68563b715486365b895	false	53		115399927	2024-01-27T23:37:11.000Z			0xe7a1178cf54b6642f90c2346c70fa005ee9c193c341a2f5712a40771a70fbdbd
0x17533a1bde957979e3977ebbfbc31e6deeb25c7d	false	8	0x72195dda0361f43ce544b750f318d04b35836933	115391535	2024-01-27T18:57:27.000Z	960397	99999912385106	0x703a449a1b56c7532c60c38e9a106c2a847830d0c1657d73d42f19faa083a5bd

Example Query

Query with partition filter

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

CToken_RepayBorrow_event

Loan repayment events from Compound Protocol forks on Optimism, tracking when borrowers repay debt against cToken markets. Includes repayment amounts, updated borrow balances, and payer/borrower addresses for analyzing lending activity and debt reduction 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_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
0x8cd6b19a07d754bf36adeee79edf4f2134a8f571	false	0x24dc43d37852e8008a9934c519bb7483dee70cbe	3	0x24dc43d37852e8008a9934c519bb7483dee70cbe	48178944	20000000000000000000	2022-12-12T00:48:59.000Z	1906825217245621139391896	0x59b14db16bc74aaf195a36b4adb0d818c5ba89ebf51fe05226f1cc443338a1ff	63348720634209592322
0x103f2ca2148b863942397dbc50a425cc4f4e9a27	false	0xc473e3e7d305b6f83419565f3aaf0ba9044f8e48	3	0xc473e3e7d305b6f83419565f3aaf0ba9044f8e48	48563713	22469519486	2022-12-12T18:49:07.000Z	8467323578	0x948430c9a5b774c2c6cf645464e7721b11e0f8c4d28a36f1388c4dd73b71c667	7542590159
0xf7b5965f5c117eb1b5450187c9dcfccc3c317e8e	false	0x711c071f1a0c0cc85cafd4120daa7b252533b57e	540	0x711c071f1a0c0cc85cafd4120daa7b252533b57e	48604674	279698228202970255615	2022-12-12T22:22:39.000Z	8812771290616514132954	0x0e0a2c0db54fbed8fd505d7de77935f541e39318ac28b4d423ca28bd7fb4f82e	7377022188187046026536

Example Query

Query with partition filter

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

CToken_ReservesAdded_event

Reserve addition events from Compound V2 fork lending markets on Optimism, tracking when protocol reserves are increased through interest accrual. Used for analyzing protocol revenue accumulation and reserve management 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_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
0xd14451e0fa44b18f08aeb1e4a4d092b823caca68	false	9	74562891	1752112623738001329	0xd14451e0fa44b18f08aeb1e4a4d092b823caca68	2023-02-15T20:55:53.000Z	0x639e65d8a4f86c4c19b25e6697c8274b834ebba17cd2c39ff3fbcc5dc9f82948	213182805763222075822
0xec8fea79026ffed168ccf5c627c7f486d77b765f	false	11	74492271	1370471	0xec8fea79026ffed168ccf5c627c7f486d77b765f	2023-02-15T14:01:02.000Z	0xd291a09496fb39e7fa953d66f5db20e8cc59f697ca6fcc5db74d354fc9069b43	3401010881
0x5569b83de187375d43fbd747598bfe64fc8f6436	false	11	74569990	12454676260386172482566	0x5569b83de187375d43fbd747598bfe64fc8f6436	2023-02-15T21:33:36.000Z	0x34050f03e4f0e04f9dba682d200a870a49ff56d131deb0f731e9ca4ce7a83282	14341860894241141189660

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Comptroller_NewLiquidationIncentive_event

CToken_AccrueInterest_event

CToken_Borrow_event

CToken_LiquidateBorrow_event

CToken_Mint_event

CToken_NewProtocolSeizeShare_event

CToken_NewReserveFactor_event

CToken_Redeem_event

CToken_RepayBorrow_event

CToken_ReservesAdded_event

​Tables

​Comptroller_NewLiquidationIncentive_event

​CToken_AccrueInterest_event

​CToken_Borrow_event

​CToken_LiquidateBorrow_event

​CToken_Mint_event

​CToken_NewProtocolSeizeShare_event

​CToken_NewReserveFactor_event

​CToken_Redeem_event

​CToken_RepayBorrow_event

​CToken_ReservesAdded_event

Tables

Comptroller_NewLiquidationIncentive_event

CToken_AccrueInterest_event

CToken_Borrow_event

CToken_LiquidateBorrow_event

CToken_Mint_event

CToken_NewProtocolSeizeShare_event

CToken_NewReserveFactor_event

CToken_Redeem_event

CToken_RepayBorrow_event

CToken_ReservesAdded_event