> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# compound_v2_ethereum
> Tables in tt-contracts.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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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%).
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| address | removed | in\_payer | log\_index | in\_borrower | block\_number | in\_repayAmount | block\_timestamp | in\_totalBorrows | transaction\_hash | in\_accountBorrows |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | --------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ | ------------------ |
| 0x39aa39c021dfbae8fac545936693ac917d5e7563 | false | 0x0f1dfef1a40557d279d0de6e49ab306891a638b8 | 9 | 0x0f1dfef1a40557d279d0de6e49ab306891a638b8 | 17871037 | 4000131458195 | 2023-08-08T15:16:11.000Z | 239758567848674 | 0x3f0aa7d209ebba03d2bedb09f6899863f5f41d32630913e33de2c84dc909544b | 0 |
| 0x39aa39c021dfbae8fac545936693ac917d5e7563 | false | 0x171c53d55b1bcb725f660677d9e8bad7fd084282 | 240 | 0x171c53d55b1bcb725f660677d9e8bad7fd084282 | 17873551 | 1489622170378 | 2023-08-08T23:44:11.000Z | 238402126034054 | 0x916ebe3f8dfa0c5c891a9e4fde8aa91ac1c1a52029b0ba52187a1123eb0868b6 | 0 |
| 0x39aa39c021dfbae8fac545936693ac917d5e7563 | false | 0x6eaba52965fab0b404bebbda594a2ba72bdb6288 | 68 | 0x6eaba52965fab0b404bebbda594a2ba72bdb6288 | 17868630 | 10722305 | 2023-08-08T07:11:47.000Z | 226752755870044 | 0xae762a3536793d90c38502dbf0ce94bd10fc4e57e8fefd41e1369d923a67766a | 0 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_newReserveFactorMantissa | in\_oldReserveFactorMantissa |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ---------------------------- | ---------------------------- |
| 0x70e36f6bf80a52b3b46b3af8e106cc0ed743e8e4 | false | 97 | 11072572 | 2020-10-17T09:17:06.000Z | 0xedb643b35ea58bb570489c205ba122ae9d9412ce117714f38507fbb65e784160 | 200000000000000000 | 0 |
| 0xccf4429db6322d5c611ee964527d42e5d685dd6a | false | 59 | 12069867 | 2021-03-19T14:54:14.000Z | 0xa9d9a710ec465fb742346bff8169acf3defae1722b6ca61589006dd6b7e9c374 | 200000000000000000 | 0 |
| 0xf650c3d88d12db855b8bf7d11be6c55a4e07dcc9 | false | 111 | 10316576 | 2020-06-22T16:11:52.000Z | 0x7ce0617eb9476200d145a46a0fec88435a86fba136bfa82723505164a454c4c7 | 100000000000000000 | 0 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| gas | value | status | gas\_used | out\_anon0 | signature | to\_address | in\_borrower | block\_number | from\_address | in\_liquidator | trace\_address | in\_seizeTokens | block\_timestamp | transaction\_hash |
| ------ | ----- | ------ | --------- | ---------- | ---------- | ------------------------------------------ | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------------------------ | -------------- | --------------- | ------------------------ | ------------------------------------------------------------------ |
| 436757 | 0 | true | 88239 | 0 | 0xb2a02ff1 | 0x70e36f6bf80a52b3b46b3af8e106cc0ed743e8e4 | 0x1c230f1b9deb1ce6c68fda7152d6a725ae08b8e2 | 22287274 | 0x5d3a536e4d6dbd6114cc1ead35777bab948e3643 | 0xbfe1364efb0a1e01241f058a6039f43fea88cfc5 | 4,2,2,0,11 | 1536308758 | 2025-04-17T07:38:47.000Z | 0x072c27811907039f0bd688f73100f4cb3e8eb54875dfe0a282b2cd9148b09ec8 |
| 393371 | 0 | true | 85200 | 0 | 0xb2a02ff1 | 0x5d3a536e4d6dbd6114cc1ead35777bab948e3643 | 0x5b99680bbc3045b82cb009332bdb01fcd3deaaef | 22285436 | 0x35a18000230da775cac24873d00ff85bccded550 | 0xbfe1364efb0a1e01241f058a6039f43fea88cfc5 | 4,2,2,0,11 | 49163618410 | 2025-04-17T01:28:11.000Z | 0xdf7c3b0b697da8007e873f19189bd96327e818f8b7947a431ba9057669c76abf |
| 287769 | 0 | true | 85155 | 0 | 0xb2a02ff1 | 0x5d3a536e4d6dbd6114cc1ead35777bab948e3643 | 0x152490ebe10209f8a4028b1747406605be2885c2 | 22286906 | 0xccf4429db6322d5c611ee964527d42e5d685dd6a | 0xbfe1364efb0a1e01241f058a6039f43fea88cfc5 | 4,2,2,0,11 | 52999610751 | 2025-04-17T06:24:59.000Z | 0xbf5ebd600b6a7819e34d32b6a77218621144799a8c1b950a78d6ece33dfb9740 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| gas | value | status | gas\_used | signature | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | transaction\_hash | in\_newTreasuryPercentMantissa |
| ------ | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------ |
| 978808 | 0 | true | 5466 | 0x89a2bc25 | 0x2f6081e3552b1c86ce4479b80062a1dda8ef23e3 | 11808856 | 0x89a359a3d37c3a857e62cde9715900441b47acec | | 2021-02-07T10:59:02.000Z | 0x37b0be2c439b030bd736f3387dd9b54b22201c65a8ed2606346111fc816318e9 | 0 |
| 960830 | 0 | true | 2698 | 0x89a2bc25 | 0xdc170f6d2d09dec9e10f3b9dfd053e2d7b35f864 | 11808856 | 0x2f6081e3552b1c86ce4479b80062a1dda8ef23e3 | 0 | 2021-02-07T10:59:02.000Z | 0x37b0be2c439b030bd736f3387dd9b54b22201c65a8ed2606346111fc816318e9 | 0 |
| 28248 | 0 | true | 11764 | 0x89a2bc25 | 0x2c196bd817134696f23ebf6a7368527cc59b658f | 15364782 | 0xc2c3b789dcabe082c7e37029a847acd8301b8f04 | | 2022-08-18T11:38:38.000Z | 0x86a939d18aaa146e9ccc39635fe7831d54dd19883468fa45c60ac74f0682b937 | 100 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.compound_v2_ethereum.Liquidator_setTreasuryPercent_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***