compoundforks_v2_base

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	log_index	block_number	block_timestamp	transaction_hash	in_newLiquidationIncentiveMantissa
0xbae8d153331129eb40e390a7dd485363135fce22	false	63	11839254	2024-03-15T01:57:35.000Z	0xcf0cba383597971d055135c19346c835e3c9dd03b316f8c7e32c7d4595bc497a	1070000000000000000
0x0cdd860ca594982443e737ac7a0b84f18c477e05	false	10	2701534	2023-08-16T13:26:55.000Z	0x3fe04bccc4ee2d3e6d0316608b7c4848c304f9f001aa610d607b9a5bf934a9c4	1080000000000000000
0x67803b6f2db452517d36785e3657abe79ceb0bc3	false	40	6879254	2023-11-21T06:24:15.000Z	0xabd2f9f49ab2ec319e4b2960725e625ea5a9197866f65914eabeff26825ff8e6	1000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.compoundforks_v2_base.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 Base, capturing accumulated interest, total borrows, cash reserves, and borrow index updates for each market. Used for analyzing lending protocol interest rate mechanics and historical APY calculations.

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
0x014e08f05ac11bb532be62774a4c548368f59779	false	64	20018997	58783648331602882240663	1051831078750678736	2024-09-20T10:15:41.000Z	69332976510098073050102	0xbf54bb946a37b7f6e1f9e75f0d1f322b0df443cc73824faefc01818ca07aff0a	125463328473948328
0x014e08f05ac11bb532be62774a4c548368f59779	false	321	20033015	59519214452004905568256	1051922426335962388	2024-09-20T18:02:57.000Z	69338997819139681086729	0x310e529da8b0a8bc098137b6898492fef004803630b3c7086bc4b955db66ebe5	69644548119003151
0x014e08f05ac11bb532be62774a4c548368f59779	false	335	20034209	60405815071079870942178	1051930109843595142	2024-09-20T18:42:45.000Z	69339504288728742601428	0x1ab580301c616c4a1f105079d83b9ca1676e953b8d6920735c54b4efd419d446	436221223403528609

Example Query

Query with partition filter

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

CToken_Borrow_event

Borrow events from Compound protocol forks on Base, recording when users take out loans against their collateral with individual borrow amounts, cumulative account borrows, and protocol-wide total borrows. Used for analyzing lending activity, borrower behavior, and protocol utilization 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
0x225886c9beb5eee254f79d58bbd80cf9f200d4d0	false	36	0x5b9a3e56d777a7f6a93c92ff350563bd76ab496f	7388517	2023-12-03T01:19:41.000Z	50940143609	1816804531885	0x7b0033827624a941565ce53ed3f23f096039a95c2cda4198eaa62b0c12501e98	488626825077
0x225886c9beb5eee254f79d58bbd80cf9f200d4d0	false	8	0xc03ce42b098ea31c9150dfb4b3565fe9de4483a2	7428936	2023-12-03T23:46:59.000Z	420000000	1771929431972	0x3527d7ff1a26dc9bfb2203a226e1407dedae1dd98cd5134e49d34a635c710299	420000000
0x225886c9beb5eee254f79d58bbd80cf9f200d4d0	false	26	0x5b9a3e56d777a7f6a93c92ff350563bd76ab496f	7400231	2023-12-03T07:50:09.000Z	43310315225	1860192237713	0x74eb45eeb3d84be512ee46cae46b1d117a8a3758af97af71602151e38ffe690d	531955264854

Example Query

Query with partition filter

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

CToken_LiquidateBorrow_event

Liquidation events from Compound protocol forks on Base chain, recording when undercollateralized positions are closed by liquidators repaying borrower debt in exchange for collateral tokens. Captures liquidator/borrower addresses, repayment amounts, seized collateral quantities, and cToken contract addresses for analyzing protocol solvency and liquidation bot 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_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 representing the collateral asset being seized in this liquidation event. This is the Compound-style interest-bearing token that the liquidator receives in exchange for repaying the borrower’s debt.
`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
0x3bf93770f2d4a794c3d9ebefbaebae2a8f09a5e5	false	265	0x4203132e29864f7c40281bcbc3b3c114e346d3fa	17986336	0x7233d08b04df8dd6487c8f321257bbb8d8819a38	1137465548610164	26479888565	2024-08-04T09:00:19.000Z	0x2388c5898c1bbfc7b3656a6fc9035e61b550a1c35688ad6a498d0d6b9f593df5	0x73902f619ceb9b31fd8efecf435cbdf89e369ba6
0x703843c3379b52f9ff486c9f5892218d2a065cc8	false	137	0xbdec7287c08c0c153f9843c4796d59e3bf7178e4	18001961	0x7233d08b04df8dd6487c8f321257bbb8d8819a38	89723434	474949219985	2024-08-04T17:41:09.000Z	0x20b6ba54a7357af574d173fd32a1650f440b8b05093bab5e02416f0060df3882	0xedc817a28e8b93b03976fbd4a3ddbc9f7d176c22
0x703843c3379b52f9ff486c9f5892218d2a065cc8	false	53	0x682eb90463116de65252cda7718a949d97b0d8b6	17971958	0x82bb16d3ee46aa93091342bc0cc87c4c0cbf936c	100469	186458	2024-08-04T01:01:03.000Z	0x06752aa1de10b1f8bd281435d2cb5b110851e380df4558acbf4e268790524df3	0x628ff693426583d9a7fb391e54366292f509d457

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.compoundforks_v2_base.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 Base, recording when users deposit underlying assets to receive cTokens (interest-bearing tokens). Used for tracking lending pool deposits, user positions, and total value locked (TVL) analysis.

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
0x0345aa92c7cb97e09b7cc0d55e730cd39c09fa43	false	851	6322683	2023-11-08T09:11:53.000Z	0xfcc80a1473fe8f84ed94776c98fcb2e95e3bd388b5c879810b69d63ba9911561
0x0345aa92c7cb97e09b7cc0d55e730cd39c09fa43	false	299	6317504	2023-11-08T06:19:15.000Z	0x356bc7b8f1510dffe3e0fe884629ab20b8dce32a3102e484d09c72272fe848cc
0x0345aa92c7cb97e09b7cc0d55e730cd39c09fa43	false	856	6316040	2023-11-08T05:30:27.000Z	0xc9e250a1d340d0ceaa71127e79671878401afeb8669b9d3a9037cbe340b1e107

Example Query

Query with partition filter

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

CToken_NewProtocolSeizeShare_event

Protocol seize share parameter changes for Compound-fork lending markets on Base, tracking updates to the protocol’s fee percentage taken during liquidations. Used for monitoring governance changes to liquidation incentive structures 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_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
0x627fe393bc6edda28e99ae648fd6ff362514304b	false	1	6272879	2023-11-07T05:31:45.000Z	0xe5ee722e1c02a6b3e5abec0a92299a347110ce99e070ac8ee4d5fe25a4ad59ab	30000000000000000
0xedc817a28e8b93b03976fbd4a3ddbc9f7d176c22	false	5	3702954	2023-09-08T17:47:35.000Z	0xf934dd416c6698860f1a94a06838529931b8aa8729f2d4360c17686ebd7691d8	30000000000000000
0x2f903de0e30852f413a7cceae9ca45a66010bc6c	false	5	3697576	2023-09-08T14:48:19.000Z	0xa05abb98dd1d7d4763956996b3fdcc4fb70dc5c561ba024368d1738ae3a4b406	30000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.compoundforks_v2_base.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 Base. Tracks protocol fee adjustments (expressed in mantissa format with 18 decimals) for analyzing revenue allocation between lenders and protocol treasury.

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
0xb864ba2aab1f53bc3af7ae49a318202dd3fd54c2	false	19	3307976	2023-08-30T14:21:39.000Z	0xb80897c0cc6c22779ba0b01241f0d1df297f5d39cc20a2e7e93c85ed916b4a1e	130000000000000000	100000000000000000
0x225886c9beb5eee254f79d58bbd80cf9f200d4d0	false	3	3307981	2023-08-30T14:21:49.000Z	0x33529c12e9e5148751943b658476f429ce3a86a5f0b808fe0ebdcd4a3ce3dbf1	130000000000000000	100000000000000000
0x3a0026a76e1ab01b0ae0a25057bf84ff43c5e1ab	false	2	14495952	2024-05-15T13:54:11.000Z	0xb5bb7a6339a2af23b4c67a2696c6bd82759b289f6161c68bffa15df9af08ddc4	200000000000000000	0

Example Query

Query with partition filter

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

CToken_Redeem_event

Redemption events from Compound-compatible lending protocols on Base, recording when users withdraw their supplied assets by burning cTokens (interest-bearing tokens). Captures the redeemer address, cToken amount burned, and underlying asset amount received for analyzing liquidity withdrawals and supply-side 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_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`	Quantity of cTokens (Compound protocol interest-bearing tokens) burned in the redemption transaction. Values are denominated in the smallest unit of the cToken with its native decimal precision.

Sample Data

address	removed	log_index	in_redeemer	block_number	block_timestamp	in_redeeCTokens	in_redeemAmount	transaction_hash
0x225886c9beb5eee254f79d58bbd80cf9f200d4d0	false	29	0xba5e1710d2d08e5f274b054cb977444306132be5	15651449	2024-06-11T07:50:45.000Z	475407794488	100000000	0xee907ae83a3bd49eb22c0bd525826ec58f900493c88d27183d700053c8b77d43
0x225886c9beb5eee254f79d58bbd80cf9f200d4d0	false	289	0x0759d1d8f5a283b1b2e28e237940679d0d791c38	15672679	2024-06-11T19:38:25.000Z	693611594002	145917234	0xba1b779ccb88444215832e50c9ca9deb483c5f8d700dad0bd20e484d1e1d5f2e
0x225886c9beb5eee254f79d58bbd80cf9f200d4d0	false	44	0xba5e1710d2d08e5f274b054cb977444306132be5	15651536	2024-06-11T07:53:39.000Z	9070777850226	1908000000	0xd86d0aed0585305f3ebc0a45656890adf52607c30d28cf91982285a5e6b4936d

Example Query

Query with partition filter

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

CToken_RepayBorrow_event

Loan repayment events from Compound V2 fork markets on Base, capturing when borrowers pay down their debt positions. Tracks repayment amounts, updated borrow balances, and payer/borrower addresses for analyzing deleveraging activity and protocol credit risk.

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
0x225886c9beb5eee254f79d58bbd80cf9f200d4d0	false	0x1c3e01db0d71b8b874bd3a24aefa3b6f161442ad	7	0x1c3e01db0d71b8b874bd3a24aefa3b6f161442ad	7607607	1010659	2023-12-08T03:02:41.000Z	1834744371926	0x505ae48eeafc396fe97eca628f45acca63fbb2eb8b82019ef65a1c55e87b2848
0x225886c9beb5eee254f79d58bbd80cf9f200d4d0	false	0x352d68686d21237582566c6b95dd7edbf04314da	18	0x352d68686d21237582566c6b95dd7edbf04314da	7621900	5000692031	2023-12-08T10:59:07.000Z	1920886991450	0xf9e7181853fc6568f9aa56630f819d38bdfc9ad6a7e6e136f9f24d591fdefadc
0x225886c9beb5eee254f79d58bbd80cf9f200d4d0	false	0x81210106806bcd45df0fead7c5226cdca1b5edab	14	0x81210106806bcd45df0fead7c5226cdca1b5edab	7634940	500000127	2023-12-08T18:13:47.000Z	1901989577866	0x6234846379be1c947e513a6050efa681477a1eb168834e9562248861a49d13fb

Example Query

Query with partition filter

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

CToken_ReservesAdded_event

Reserve addition events from Compound-fork lending markets on Base. Tracks protocol reserve accumulation with benefactor addresses and running reserve totals for analyzing protocol revenue and reserve factor mechanics.

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
0x628ff693426583d9a7fb391e54366292f509d457	false	84	10739081	2488346045658031	0x628ff693426583d9a7fb391e54366292f509d457	2024-02-18T14:45:09.000Z	0xb7ae63527b9011f2138656e8b4c12d77a8faed78a901db602284f54a3d685f30	20312131526832441886
0x628ff693426583d9a7fb391e54366292f509d457	false	85	14387684	6687251509847494	0x628ff693426583d9a7fb391e54366292f509d457	2024-05-13T01:45:15.000Z	0xf6e6d52728f5b22312d4a3da32bddc8f126802f7be36cad6d336e03b4d2e7503	40929409722431004939
0x628ff693426583d9a7fb391e54366292f509d457	false	142	14388959	9676643878541103	0x628ff693426583d9a7fb391e54366292f509d457	2024-05-13T02:27:45.000Z	0x1d383b45294e1deb39ad7bc32e14bfa1fa60fd16551ae20a927fd47ea6a21316	40950243163688837948

Example Query

Query with partition filter

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

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

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