> ## 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.
# shoebill_v1_manta
> Tables in tt-contracts.shoebill_v1_manta
## Tables
### sbEth\_AccrueInterest\_event
Interest accrual events from the sbETH (Shoebill ETH) lending market on Manta, recording accumulated interest, total borrows, borrow index, and available cash per accrual period. Used for tracking lending pool health and calculating real-time interest rates.
| 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 |
| ------------------------------------------ | ------- | ---------- | ------------- | ----------------- | ------------------- | ------------------------ | -------------------- | ------------------------------------------------------------------ | ----------------------- |
| 0xe103f874b2d144c5b327fa3d57069bb19c0779e2 | false | 0 | 906756 | 4585877216154853 | 1001865988341695400 | 2023-12-23T00:31:59.000Z | 18629295900863034328 | 0xdd28e9803607784ec3775948b609392e781d9a78d506150c781689a170b86cb1 | 393139518210182 |
| 0xe103f874b2d144c5b327fa3d57069bb19c0779e2 | false | 0 | 912635 | 25810391370976567 | 1002233761831326075 | 2023-12-23T16:51:49.000Z | 19146142452360646624 | 0x2c3141c7cb5e83c7c3772081892e0a45e490b26ffd499e05d92c247ec2d94d49 | 292320765912345 |
| 0xe103f874b2d144c5b327fa3d57069bb19c0779e2 | false | 0 | 909920 | 10000000079821790 | 1002065894307227249 | 2023-12-23T09:19:19.000Z | 18633013072049177540 | 0xdfc061e4915aa99d1d0066eb02fa9f120ddad9e7519bf10f95c908a036bbeb19 | 162024364631261 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.sbEth_AccrueInterest_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### sbEth\_Borrow\_event
Borrow event logs from Shoebill's sbETH lending market on Manta Network, tracking ETH borrowing activity with individual borrow amounts, cumulative protocol borrows, and per-account debt positions. Used for analyzing borrower behavior, lending market utilization, and debt 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_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 |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------ | --------------------- | ------------------------------------------------------------------ | -------------------- |
| 0xe103f874b2d144c5b327fa3d57069bb19c0779e2 | false | 2 | 0xe8b55fd62045d51274812e5c3ab803055c0e3eaa | 949024 | 2023-12-27T21:56:39.000Z | 210000000000000000 | 115345695450955089983 | 0x043ab996a74d2157a0a52c05f24c2b4ddb86ce9255808f056373c374464c425a | 486573733983646878 |
| 0xe103f874b2d144c5b327fa3d57069bb19c0779e2 | false | 2 | 0x090396a36d1858b62f12f711f4c841c2609a9751 | 944803 | 2023-12-27T10:13:09.000Z | 400000000000000000 | 101776271607034089164 | 0xe9149af99f5da9c964d3b4971082171431b66b275930347fdc54eaf9e6e45925 | 3243886070425799443 |
| 0xe103f874b2d144c5b327fa3d57069bb19c0779e2 | false | 2 | 0x2dc5b4261159fffaa56c4e197605d05a72a7b368 | 943809 | 2023-12-27T07:27:29.000Z | 579554040463424593 | 110914565971860206781 | 0xc446bc9bb307f61dc24d2ac8c4fbbc1e551f1280ed7d8e085c8e5634532f125a | 16820340612092069960 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.sbEth_Borrow_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### sbEth\_Mint\_event
Mint event logs from Shoebill's sbETH liquid staking token contract on Manta network, recording when users deposit ETH to receive sbETH tokens. Contains minter addresses, deposited amounts in wei, and corresponding sbETH tokens issued for tracking staking 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_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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xe103f874b2d144c5b327fa3d57069bb19c0779e2 | false | 0x1fce885c5fc5779f550066da6d77b4a9dd3bdacc | 3 | 1050653 | 10000000000000000 | 49557233 | 2024-01-08T16:14:49.000Z | 0xb2a1a4af86eb298f4eb225a7dfc0b631d7a5821ce956df734fa825a779e62bb6 |
| 0xe103f874b2d144c5b327fa3d57069bb19c0779e2 | false | 0xd28ba186b1c37c00ccb158f2b870bda79370ca3d | 3 | 1053121 | 150000000000000000 | 743251252 | 2024-01-08T23:06:09.000Z | 0xc50c61e8b59a96256367b9950fbb35ed0180a133bc9f5c08b004dee2b9e465b1 |
| 0xe103f874b2d144c5b327fa3d57069bb19c0779e2 | false | 0xa0170b6935fef8ff2c514703fcb2c597a9bc2076 | 3 | 1049589 | 168160854753522525 | 833436898 | 2024-01-08T13:17:29.000Z | 0x7d213917260f53da5d5e23ba6d745a98650bfe0040defd92ca6d501c4b652c62 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.sbEth_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### sbEth\_NewReserveFactor\_event
Reserve factor parameter change events from the Shoebill lending protocol's sbETH market on Manta network. Tracks updates to the protocol's reserve allocation percentage (expressed in mantissa format with 18 decimals) for risk management and protocol fee analysis.
| 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 |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ---------------------------- | ---------------------------- |
| 0xe103f874b2d144c5b327fa3d57069bb19c0779e2 | false | 11 | 858578 | 2023-12-17T10:42:19.000Z | 0xe944df1cae4f14ae5aec9cd3bae2bb47458d8a2bcc8aef79825b263e857bfd34 | 500000000000000000 | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.sbEth_NewReserveFactor_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### sbEth\_Redeem\_event
Redemption events from Shoebill's sbETH liquid staking token contract on Manta, recording when users burn sbETH tokens to withdraw underlying ETH. Contains redeemer addresses, token amounts burned, and corresponding ETH amounts received for analyzing withdrawal patterns and liquidity 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_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 |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------ | ---------------- | ------------------------------------------------------------------ |
| 0xe103f874b2d144c5b327fa3d57069bb19c0779e2 | false | 14 | 0x0c358ac0610eee1298ad312a7b87e04e7e5f7fc0 | 905453 | 2023-12-22T20:54:49.000Z | 44572960035059195 | 222677072 | 0x0e26070d23825c8a0c0b1c03e4363b36017c4de5eb041ca4bcfdc432862d68dd |
| 0xe103f874b2d144c5b327fa3d57069bb19c0779e2 | false | 9 | 0x19f0d344987fe4bae7eebb4958197320187bbcd7 | 901999 | 2023-12-22T11:19:09.000Z | 75000006365687425 | 374723132 | 0x825cad97d27d3da49a10056cb4b38eabfe95763e47f61051c2f18b8ba912bd1e |
| 0xe103f874b2d144c5b327fa3d57069bb19c0779e2 | false | 7 | 0x5075f1939e8f4b9a87714b839f3727724be5fa04 | 899262 | 2023-12-22T03:42:59.000Z | 182023014673998161 | 909515690 | 0xa2711ff511fe7d79333127d99910430df7e332a2e0fbfa9b634f41ae363a25be |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.sbEth_Redeem_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### sbEth\_RepayBorrow\_event
Borrow repayment events from Shoebill lending protocol's sbETH (staked ETH) market on Manta network. Tracks debt repayments with payer, borrower addresses, repayment amounts, and updated account/total borrow balances for monitoring loan 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------- | ------------------------ | --------------------- | ------------------------------------------------------------------ | ------------------- |
| 0xe103f874b2d144c5b327fa3d57069bb19c0779e2 | false | 0xe95fa1f75adbe6341cd0f5c42871f9b73d730990 | 2 | 0xe95fa1f75adbe6341cd0f5c42871f9b73d730990 | 1036459 | 2000000000000000 | 2024-01-07T00:49:09.000Z | 376172574701925135900 | 0x53b49801a013962c7a81e5320b372d32193b50d5f7c9e4bd1dadb783b08d0da6 | 1099721771482856827 |
| 0xe103f874b2d144c5b327fa3d57069bb19c0779e2 | false | 0x4032d91e00d7abdadd1869360f3dbf3d3db5261c | 4 | 0x4032d91e00d7abdadd1869360f3dbf3d3db5261c | 1037564 | 343853205420710576 | 2024-01-07T03:53:19.000Z | 376679744139528722018 | 0xc5ba69861b672f200b56ac9da031dd7ff2d8a1f074c68db5d4b7149f69968f7a | 226822136674 |
| 0xe103f874b2d144c5b327fa3d57069bb19c0779e2 | false | 0x2bcde12eb3cff4866208c975cf01230c6b179521 | 10 | 0x2bcde12eb3cff4866208c975cf01230c6b179521 | 1044263 | 1000000000000000000 | 2024-01-07T22:29:49.000Z | 413017552751800872558 | 0x05f22c7b05e710c951408c807de4ea857cf4cdd1a9b629e7379ba08bdd4dd11d | 1034744783718958776 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.sbEth_RepayBorrow_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### sbStone\_AccrueInterest\_event
Interest accrual events from Shoebill's sbStone lending market on Manta, recording cash reserves, total borrows, accumulated interest, and borrow index updates for monitoring the market's financial state and interest rate 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_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 |
| ------------------------------------------ | ------- | ---------- | ------------- | ----------------------- | ------------------- | ------------------------ | ----------------------- | ------------------------------------------------------------------ | ----------------------- |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 0 | 1049617 | 16865840029375659789210 | 1001685395996838760 | 2024-01-08T13:22:09.000Z | 10062296355346543783665 | 0x11f0df7a10af3f761178212493a3415b687c444d51adcc1c8cd50d27ec0ed90b | 451570214009388 |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 0 | 1052994 | 16847687031032223168267 | 1001715761701791133 | 2024-01-08T22:44:59.000Z | 10072417651177403526678 | 0x99b4c876ca18ffff69f13ffded14c5b9b5653c0ad58a87858bad966cd2d8bb26 | 271318966447523 |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 0 | 1052005 | 16840179630558435998429 | 1001706866306745664 | 2024-01-08T20:00:09.000Z | 10068639899100783495775 | 0x9c29045db89972050d455bd8c689668debd65ace4e583274e66f82318079e477 | 180813710210940 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.sbStone_AccrueInterest_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### sbStone\_Borrow\_event
Borrow event logs from the sbStone lending market on Shoebill protocol (Manta chain), tracking loan originations with borrower addresses, borrowed amounts, and cumulative borrow positions. Used for analyzing borrowing activity, protocol debt levels, and individual account leverage in the Shoebill DeFi lending protocol.
| 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 |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ---------------- | --------------------- | ------------------------------------------------------------------ | ------------------- |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 33 | 0x763a6f008009ee95814c25f7a82019c0d794d0cf | 896998 | 2023-12-21T21:25:39.000Z | 20376482893 | 623021344540922426464 | 0x635052f85032dacb021d13ad0207361b61d7aa8bc91f5c15ffc5d5058e6b8993 | 20376482893 |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 7 | 0x3d728dbd524e574c7830e61364c53bab6d801712 | 890903 | 2023-12-21T04:29:49.000Z | 100000000000000 | 468545190951711557633 | 0x93ada8496e10e8081ad90cf2b762efd6e7445b2206befbd5d072cedb4e8b8271 | 3852946594725771295 |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 16 | 0x74cce10d747714a79ff09b04d3cf4d7a6e430589 | 892427 | 2023-12-21T08:43:49.000Z | 694194601691244 | 521404228919540285810 | 0x2fa96c512bd3211586a783e3f9a7df5f1136115607ab445968a86843406ccac3 | 139994257985087659 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.sbStone_Borrow_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### sbStone\_Mint\_event
Mint events from the sbStone liquid staking token contract on Manta Pacific, recording deposits where users stake assets and receive sbStone tokens in return. Tracks minter addresses, deposit amounts, and corresponding sbStone tokens issued for analyzing staking activity and token supply 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_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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ----------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 0xa720ae34a450691fb29e748b07d7b4d584415c9a | 3 | 1051816 | 42600000000000000 | 212935184 | 2024-01-08T19:28:39.000Z | 0x209dc931e8b3f1fbdb025cdff00a56251b93075fbd3e9ee16e5efac1fff9fca8 |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 0x21a5f09312b5277f1dafd3edb2e3a4f76f235411 | 3 | 1045625 | 1000000000000000 | 4998530 | 2024-01-08T02:16:49.000Z | 0x031d12870776a85ce28aff88542289e939b0668b51627ee8b565a9937abca0ba |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 0x0f94a05b4b6d25df83c6ef3f3631f5f754f0a718 | 3 | 1045575 | 200000000000000 | 999706 | 2024-01-08T02:08:29.000Z | 0x47082532ecdfd738c6e66ce3c1c892f80dff75d1b59bf4f876c6a6008969b31d |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.sbStone_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### sbStone\_NewReserveFactor\_event
Reserve factor adjustment events from the sbStone lending market on Shoebill protocol (Manta chain). Tracks changes to the protocol's reserve percentage (mantissa format: 18 decimals) for analyzing fee structure modifications and protocol treasury accumulation rates.
| 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 |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ---------------------------- | ---------------------------- |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 6 | 858574 | 2023-12-17T10:41:39.000Z | 0xc8522ea277e109303b526c3934420f4b6c20617dee38b22f0c0bf4bb17466074 | 500000000000000000 | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.sbStone_NewReserveFactor_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### sbStone\_Redeem\_event
Redemption events from the Shoebill sbStone token contract on Manta Pacific, recording when users burn sbStone tokens to withdraw underlying assets. Useful for analyzing withdrawal patterns, token supply dynamics, and protocol 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 |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------- | ---------------- | ------------------------------------------------------------------ |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 15 | 0x2198c2e6fa4e49a0b53d90ba216a3d3844fdab40 | 884019 | 2023-12-20T09:22:29.000Z | 27319477020596279 | 136593933 | 0x3e4a815e628f1e4ae9ebf12a098a2ecaface2e9aa6471fb0e33fed678edf7718 |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 27 | 0x2198c2e6fa4e49a0b53d90ba216a3d3844fdab40 | 884012 | 2023-12-20T09:21:19.000Z | 1721687078719070660 | 8608217967 | 0xd66feb4ae20aed0410203c307391895f9ed9e96e49e3af0b7785a10a204d0d20 |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 18 | 0x27bc1907abca3b368eadfdb55b396fdd9aad44aa | 883774 | 2023-12-20T08:41:39.000Z | 11297490473477305 | 56486045 | 0xf6e120665b81ea78d923eaec0ed3c12a8faa3730a4498056b1eb20606f058a28 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.sbStone_Redeem_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### sbStone\_RepayBorrow\_event
Borrow repayment events from the sbStone lending market on Shoebill V1 protocol on Manta Network. Tracks loan repayments with amounts, updated account and total borrow balances for analyzing borrower behavior and protocol debt management.
| 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------- | ------------------------ | ---------------------- | ------------------------------------------------------------------ | ------------------- |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 0x85fbd9edcb1ed855dc5f36a6867b0cd84b0bbeca | 3 | 0x85fbd9edcb1ed855dc5f36a6867b0cd84b0bbeca | 871753 | 460000000000000000 | 2023-12-18T23:18:09.000Z | 129068868338299292640 | 0xa5e5abb186f9d1989c7024c71d3bcab1fc89ef37889a4562f5ebc8becc20e68e | 2997691077736238587 |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 0xcff0e961d0dec9dadf8587f66f158738e1366264 | 7 | 0xcff0e961d0dec9dadf8587f66f158738e1366264 | 868032 | 6929999999999999 | 2023-12-18T12:57:59.000Z | 155582191 | 0x6cc3d25df893b0242a66885e786ffe30204f095ebb01c4e15fa2ce147d05b269 | 155582191 |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 0x18cc393c5384cff103beaba7440a93b342dc47cd | 6 | 0x18cc393c5384cff103beaba7440a93b342dc47cd | 996860 | 9000000000000000000 | 2024-01-02T10:49:19.000Z | 7547196054333037976884 | 0x9176a921082e8d7b3c11d2471aa20d7e144514dbc78937d9d2cb34c953e0be72 | 8005208683047967785 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.sbStone_RepayBorrow_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### sbUsdc\_AccrueInterest\_event
Interest accrual events for the Shoebill USDC lending market on Manta, recording periodic updates to borrow rates, accumulated interest, total borrows, and the borrow index used for calculating user-specific debt. Used for tracking protocol revenue, borrowing costs, and market utilization 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_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 |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------- | ------------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ | ----------------------- |
| 0xff2033181cbf7ee2656d9a527d378930b31c3a42 | false | 0 | 887386 | 1838531386 | 1000200638016949953 | 2023-12-20T18:43:39.000Z | 29214455965 | 0xa101780d37ae50c521339d0eb50b9ef11e580a89977ee76856d59f5091dbe59d | 244802 |
| 0xff2033181cbf7ee2656d9a527d378930b31c3a42 | false | 0 | 885308 | 30053207274 | 1000168137988911409 | 2023-12-20T12:57:19.000Z | 10037399 | 0x262bdcd49be0b80064b2d60b8591bbede6c698e6103a2026652fc7c7092f6a96 | 260 |
| 0xff2033181cbf7ee2656d9a527d378930b31c3a42 | false | 0 | 886377 | 7134531519 | 1000175800461249946 | 2023-12-20T15:55:29.000Z | 23917747450 | 0x20792598fa25c380f9746da2bd8527fa0f6fcf4c781d55c20a4a3e86a76568e0 | 4504 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.sbUsdc_AccrueInterest_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### sbUsdc\_Borrow\_event
Borrow event logs from Shoebill protocol's sbUSDC market on Manta Network, recording when users borrow USDC with borrower address, borrow amount, and updated account and total borrow balances. Used for tracking lending activity, borrower behavior, and protocol utilization 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 |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ---------------- | ---------------- | ------------------------------------------------------------------ | ------------------ |
| 0xff2033181cbf7ee2656d9a527d378930b31c3a42 | false | 6 | 0xa25bdd7578fe8b6d24146a50013663039377ed4e | 991950 | 2024-01-01T21:10:59.000Z | 150000000 | 159180395665 | 0x43abca732d057cbfabd5afe41fcfd9d184451f268b6dd6a026ecf89a673ec6c3 | 351677515 |
| 0xff2033181cbf7ee2656d9a527d378930b31c3a42 | false | 8 | 0x03c45e5676db486c5cb89855645c1cd2756f0317 | 991581 | 2024-01-01T20:09:29.000Z | 15000000 | 159025767702 | 0x49a4f88b8692a80f0a0f62fca47342d7d9ef07dfbdb2df6bb255f295d3a37a3e | 56013638 |
| 0xff2033181cbf7ee2656d9a527d378930b31c3a42 | false | 12 | 0xe063dc804128bcfa468221bf7ceb69bf2728e937 | 985018 | 2024-01-01T01:55:39.000Z | 290000000 | 150978469840 | 0x712efcade41f429c589d8b20b262ae55bafcf7f3b80788171514898e6b79e866 | 1100092694 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.sbUsdc_Borrow_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### sbUsdc\_Mint\_event
Mint events from the Shoebill USDC lending market (sbUSDC) on Manta Pacific, recording when users deposit USDC and receive interest-bearing sbUSDC tokens in return. Tracks depositor addresses, underlying USDC amounts deposited, and corresponding sbUSDC tokens minted for analyzing supply-side lending 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_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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | -------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xff2033181cbf7ee2656d9a527d378930b31c3a42 | false | 0x47e05bb20a14c9a27fa8706af83fff7a480de47f | 6 | 1008226 | 109778463 | 545702003977 | 2024-01-03T18:23:39.000Z | 0x7f23f249353f58446d3f602ac5c456f077a3d421130881b01469b780e10683dc |
| 0xff2033181cbf7ee2656d9a527d378930b31c3a42 | false | 0xa16c76315750bfe8c99f3eab264d384d1eba0883 | 9 | 1009674 | 113591372 | 564618498015 | 2024-01-03T22:24:59.000Z | 0x0158a94b9406f5f5f07a3f0aab5d50f40ac69b620d22b2f02b423ff38b76141f |
| 0xff2033181cbf7ee2656d9a527d378930b31c3a42 | false | 0x8fd1dc051cfa0441e969533e08770fc01afb98ac | 9 | 1004798 | 1253687140 | 6233604961541 | 2024-01-03T08:52:19.000Z | 0xbd18968a543f8fdc2e903c9a29d5a17fce213a3b152bf241316921bdff1d3000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.sbUsdc_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### sbUsdc\_NewReserveFactor\_event
Reserve factor parameter changes for the sbUSDC lending market on Shoebill protocol (Manta chain). Tracks adjustments to the protocol's reserve allocation percentage, useful for monitoring risk parameter governance and protocol fee policy 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_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 |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ---------------------------- | ---------------------------- |
| 0xff2033181cbf7ee2656d9a527d378930b31c3a42 | false | 13 | 859067 | 2023-12-17T12:03:49.000Z | 0x0f7b1ae243e99190567f049c5e9388a3ef0abc704487946c5d48db619e48aff9 | 500000000000000000 | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.sbUsdc_NewReserveFactor_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### sbUsdc\_Redeem\_event
Redemption events from the Shoebill USDC lending market (sbUSDC) on Manta Pacific, recording withdrawals where users burn interest-bearing tokens to receive underlying USDC. Tracks redeemer addresses, token amounts burned, and USDC amounts received for analyzing lending market flows and liquidity 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_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 |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ---------------- | ---------------- | ------------------------------------------------------------------ |
| 0xff2033181cbf7ee2656d9a527d378930b31c3a42 | false | 14 | 0x156519f34007b35c113fa522fd2ea8b17577f1d8 | 985254 | 2024-01-01T02:34:59.000Z | 203796464 | 1014940163738 | 0x68edd49354e1ca89cbbf708cdde4e1f682f715d8b57db8cbe10a07a43ad0142d |
| 0xff2033181cbf7ee2656d9a527d378930b31c3a42 | false | 26 | 0x59734b9ae4211bbd8035f97ed3e2a5aac0a697a5 | 990510 | 2024-01-01T17:10:59.000Z | 50000015 | 248949073183 | 0x888e9f5c680d66567d088ce4a06e8e011f130d2db89deec806671122884bf9fc |
| 0xff2033181cbf7ee2656d9a527d378930b31c3a42 | false | 26 | 0x885a8bd0aed00e5a042e7bb788fa56c9e0fee5a4 | 990079 | 2024-01-01T15:59:09.000Z | 600000736 | 2987437181803 | 0xdcb0358eb1b9e652c0a68fdb20727c5f5876dc50d90ae6e7e5d0b4367a38508e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.sbUsdc_Redeem_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### sbUsdc\_RepayBorrow\_event
Borrow repayment events from Shoebill lending protocol's USDC market on Manta network, tracking when users repay borrowed USDC including repayment amounts, remaining account borrows, and updated total protocol borrows. Used for analyzing debt repayment patterns, liquidation avoidance behavior, and protocol-wide borrow utilization trends.
| 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | --------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ | ------------------ |
| 0xff2033181cbf7ee2656d9a527d378930b31c3a42 | false | 0x12735e3795b65a33b961335d2400b2ce8726ce9b | 26 | 0x12735e3795b65a33b961335d2400b2ce8726ce9b | 979508 | 1310000000 | 2023-12-31T10:37:19.000Z | 146127723136 | 0x822725fecc1b398782e8d415063d1c4bccd1d931473df71a8f3e7a9e78d3df88 | 1626 |
| 0xff2033181cbf7ee2656d9a527d378930b31c3a42 | false | 0x22a0857faf70383ed21b2cb9246a5d220dcf3703 | 28 | 0x22a0857faf70383ed21b2cb9246a5d220dcf3703 | 976487 | 15000000 | 2023-12-31T02:13:49.000Z | 130456134298 | 0x2cc4ea9c400855265e9bb97f38ff050644803330acef186cbc3943fcf0c118ce | 172 |
| 0xff2033181cbf7ee2656d9a527d378930b31c3a42 | false | 0x2fe6c4f6a527d47fa2729254847a0ef04fc7f157 | 17 | 0x2fe6c4f6a527d47fa2729254847a0ef04fc7f157 | 976580 | 2440207347 | 2023-12-31T02:29:19.000Z | 128017492884 | 0xe4943173673b93cfe39bf8e70b4bb2e6bc445a855c6566de1c4bf83b6f180503 | 1620256 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.sbUsdc_RepayBorrow_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### sbwUsdm\_AccrueInterest\_event
Interest accrual event logs from Shoebill's sbwUSDM lending market on Manta, tracking accumulated interest, borrow index updates, cash reserves, and total borrows. Used for analyzing yield generation and borrowing costs in the protocol's stablecoin lending pool.
| 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 |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------- | ------------------- | ------------------------ | ------------------------- | ------------------------------------------------------------------ | ----------------------- |
| 0xc0ef6dea74e54689867fdd5f0ab2202f7d8a0d7b | false | 0 | 959974 | 2667057180255058496740672 | 1000878476945395441 | 2023-12-29T04:21:39.000Z | 1950549239793656744620433 | 0xc76397ab31aaa748a737946d171df7fc27bd67332b84a3640b3f425d5b14ad11 | 181771597277529256 |
| 0xc0ef6dea74e54689867fdd5f0ab2202f7d8a0d7b | false | 0 | 964115 | 2910941437618694063222001 | 1000917021760100456 | 2023-12-29T15:51:49.000Z | 2151427614791101912230001 | 0x65a6c5123121355c80f86b1c8bb4b020aaae80b6e3bb2253e24cbb4fc6923047 | 80352238435874244 |
| 0xc0ef6dea74e54689867fdd5f0ab2202f7d8a0d7b | false | 0 | 967006 | 3278049022176789342261889 | 1000944484900131799 | 2023-12-29T23:53:39.000Z | 2940331679774705532176799 | 0x3bfb4288cbe456ae01ca66715e4745dd20f2477a79c07f951fcbf4fda63165ef | 1166273535996590191 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.sbwUsdm_AccrueInterest_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### sbwUsdm\_Borrow\_event
Borrow event logs from Shoebill wUSDM lending market on Manta network, tracking individual borrow transactions with borrower addresses, amounts, and cumulative account/total borrows. Used for analyzing lending protocol utilization and tracking individual borrowing positions 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_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 |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | --------------------- | ------------------------- | ------------------------------------------------------------------ | --------------------- |
| 0xc0ef6dea74e54689867fdd5f0ab2202f7d8a0d7b | false | 23 | 0x00c674e8327b5a41e291a10dd49b45411d592009 | 1046072 | 2024-01-08T03:31:19.000Z | 550000000000000000000 | 5385473806852204176123302 | 0x0e8d440c4734b8d400c3602edebae4e19e102785da5ff4d26c6380b1da1f2627 | 550044363016339681943 |
| 0xc0ef6dea74e54689867fdd5f0ab2202f7d8a0d7b | false | 25 | 0x00c674e8327b5a41e291a10dd49b45411d592009 | 1046083 | 2024-01-08T03:33:09.000Z | 550000000000000000000 | 5385499324954905871144469 | 0xa549e0dfe1454a0e7b2c22d057f0915c84aef6521ad9ed6db942613e8dca922c | 550000015668894952424 |
| 0xc0ef6dea74e54689867fdd5f0ab2202f7d8a0d7b | false | 28 | 0x04b970b2539e98755438e6da19b204f102dde11e | 1051661 | 2024-01-08T19:02:49.000Z | 450000000000000000000 | 5608506199597123827228838 | 0x6e6e06828c509baa91f796fdcfb21a6f9c9bf6a6a4a17133fcf202664e6e699b | 450000000000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.sbwUsdm_Borrow_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### sbwUsdm\_Mint\_event
Mint events from the Shoebill sbwUSDM token contract on Manta, recording when users deposit collateral to receive minted sbwUSDM tokens. Tracks minter addresses, collateral amounts deposited, and corresponding token shares minted for analyzing supply expansion and user deposits.
| 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ---------------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xc0ef6dea74e54689867fdd5f0ab2202f7d8a0d7b | false | 0x33791caf6f91adc7585860e1472326fdc28af4af | 4 | 993563 | 1646589008688077265481 | 8231015159975 | 2024-01-02T01:39:49.000Z | 0xe8bf0c49070a231534ddea3943c126b1092f489befd20c7db202d8c44e8d8510 |
| 0xc0ef6dea74e54689867fdd5f0ab2202f7d8a0d7b | false | 0x87d637631bf342b4d3ab2b970617758cd51c90c3 | 5 | 993152 | 42790000000000000000 | 213900044412 | 2024-01-02T00:31:19.000Z | 0x18c584912c2127dbd3b9b5aee5383d64851bd9a86fe13d40fc61abf30d626563 |
| 0xc0ef6dea74e54689867fdd5f0ab2202f7d8a0d7b | false | 0x21aded2a66953188009a1529d91803f2f31587b6 | 6 | 1001176 | 175000000000000000000 | 874780340598 | 2024-01-02T22:48:39.000Z | 0x0e190b90bd0afe27f666e7f8147d7bd1269b42cc93f57ce71838f7267a172e5a |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.sbwUsdm_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### sbwUsdm\_NewReserveFactor\_event
Reserve factor configuration changes for the sbwUSDM lending market on Shoebill protocol (Manta chain). Tracks updates to the protocol's reserve percentage (mantissa format: 500000000000000000 = 50%) used for analyzing protocol fee adjustments and governance decisions.
| 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 |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ---------------------------- | ---------------------------- |
| 0xc0ef6dea74e54689867fdd5f0ab2202f7d8a0d7b | false | 13 | 859068 | 2023-12-17T12:03:59.000Z | 0x2d3fbdb796a91156c1e7567661284ee8e3eea0301c2146963bcb6efa2359c327 | 500000000000000000 | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.sbwUsdm_NewReserveFactor_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### sbwUsdm\_Redeem\_event
Redemption events from Shoebill's sbwUSDM wrapped token contract on Manta, tracking when users burn sbwUSDM tokens to withdraw underlying USDM stablecoin. Records the redeemer address, amount of underlying USDM received, and corresponding sbwUSDM tokens burned for analyzing withdrawal patterns 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 |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ---------------------- | ---------------- | ------------------------------------------------------------------ |
| 0xc0ef6dea74e54689867fdd5f0ab2202f7d8a0d7b | false | 32 | 0x06a1d9a9ab8849df575db1b30e8f4cc1df6e5ed6 | 956336 | 2023-12-28T18:15:19.000Z | 7999918937434079204997 | 39993351457395 | 0xc53b0274d73b4ead98f50ad289d11c095c9a8c0894da8d6a8ca9dd9276c22c92 |
| 0xc0ef6dea74e54689867fdd5f0ab2202f7d8a0d7b | false | 42 | 0x075a4bd432e8e862733c8e41efb773d604f35e5c | 955446 | 2023-12-28T15:46:59.000Z | 34000804019609297722 | 169977727593 | 0x7775eb210f84dcdbeefe2b3718f3708851e6945a7f8cffbac263f329fe507996 |
| 0xc0ef6dea74e54689867fdd5f0ab2202f7d8a0d7b | false | 55 | 0x10ea740f5526d7e262beae81a4ec8d944824ef1a | 955663 | 2023-12-28T16:23:09.000Z | 4948616331951304122695 | 24739246304941 | 0xa1629d9a22a42cfa2b7665781dcec9109a2b03284432cc3bca3e6c1562fd38ca |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.sbwUsdm_Redeem_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### sbwUsdm\_RepayBorrow\_event
Borrow repayment events from Shoebill V1 lending protocol's wUSDM market on Manta Pacific. Tracks debt repayments with payer and borrower addresses, repayment amounts, and updated account/total borrow balances for analyzing lending activity and liquidations.
| 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | --------------------- | ------------------------ | ------------------------- | ------------------------------------------------------------------ | --------------------- |
| 0xc0ef6dea74e54689867fdd5f0ab2202f7d8a0d7b | false | 0x1360b179e399ddaa05d42d642f669598a32cce89 | 12 | 0x1360b179e399ddaa05d42d642f669598a32cce89 | 921237 | 13000000000000000000 | 2023-12-24T16:45:29.000Z | 5188072892805187614000814 | 0x069c8093b6a012082fb706752cbd8fb6de6b402242f241984b55d63e1312771d | 13498111816946178922 |
| 0xc0ef6dea74e54689867fdd5f0ab2202f7d8a0d7b | false | 0x39ed125b7b63279b304d75b070b84d43c17fbc17 | 42 | 0x39ed125b7b63279b304d75b070b84d43c17fbc17 | 917020 | 50000000000000000000 | 2023-12-24T05:02:39.000Z | 5136366710648710456981529 | 0x2437ca65385b402d72e182858121f69492a592b007c2945bea91e3862853a85e | 268800062482237048255 |
| 0xc0ef6dea74e54689867fdd5f0ab2202f7d8a0d7b | false | 0x4edc5e546633f22357841b2d23a100a461160e80 | 45 | 0x4edc5e546633f22357841b2d23a100a461160e80 | 920478 | 400024520844779612989 | 2023-12-24T14:38:59.000Z | 5186402618241715464240742 | 0x217d4d8fa119f6e39bc2fe81075c765686550473fb61da1299eaf13efb452384 | 27181657435356 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.sbwUsdm_RepayBorrow_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### stStone\_AccrueInterest\_event
Interest accrual events from the stStone lending market on Manta, tracking borrowing rate updates with cash reserves, total borrows, borrow index, and accumulated interest. Used for analyzing lending market dynamics and interest rate calculations in the Shoebill protocol.
| 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 |
| ------------------------------------------ | ------- | ---------- | ------------- | ----------------------- | ------------------- | ------------------------ | ---------------------- | ------------------------------------------------------------------ | ----------------------- |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 0 | 985533 | 12101850647594416708448 | 1001113219476463318 | 2024-01-01T03:21:29.000Z | 7235747726154240132703 | 0x283ce14cb7ede4232c1432763b3174536840753bfb9e369c1d10d7213e1ca096 | 649688802531088 |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 0 | 988633 | 12330404251154315571079 | 1001141039258809765 | 2024-01-01T11:58:09.000Z | 7306451259212329851688 | 0xd7ec4217237523133f8632f93077b6170f0ac64dd82066f7f2f855fe7bac79e9 | 65495579114638 |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 0 | 987504 | 12300417834923740348909 | 1001130907635457813 | 2024-01-01T08:49:59.000Z | 7288262370446136393817 | 0xb11d427dffba5dbcdf34489fb1d0397aaaed671e7f57735acac4768fc7d84caf | 65331808530514 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.stStone_AccrueInterest_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### stStone\_Borrow\_event
Borrow event logs from the stStone lending market on Shoebill protocol on Manta network, tracking individual borrow transactions with borrower addresses, amounts borrowed, and cumulative account and protocol-wide borrow balances. Used for analyzing borrowing activity, utilization rates, and user leverage patterns in the stStone (staked Stone) money market.
| 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 |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------ | ----------------------- | ------------------------------------------------------------------ | ------------------- |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 3 | 0xd185a341e2d30df901d4792f52af0265b45d7d9c | 1043420 | 2024-01-07T20:09:19.000Z | 346533812824317678 | 10009481683415472711443 | 0x6d334d2b3bdc873fe8ae7360c897bbbd6b914e821666cbba746f1de90f8a88a3 | 346533812824317678 |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 3 | 0x0628e50f2338762ecaccc53506c33bcb5327c964 | 1043216 | 2024-01-07T19:35:19.000Z | 1000000000000000 | 10006465695528576788181 | 0x80ade2df965541da4d5115d0589803b80c2215ac80809278a75fccadaa19b88c | 1582242952023104240 |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 3 | 0xc721b0b9e17b32dc9f981eedbe4f70be04b96415 | 1043281 | 2024-01-07T19:46:09.000Z | 311849999952149679 | 10007471842287197352317 | 0x6233310c907919c0a58d0aa85577fb89212d8fbb21f0124672896213e5fbb4b6 | 311849999952149679 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.stStone_Borrow_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### stStone\_Mint\_event
Mint events for stStone liquid staking token on Manta Pacific, recording user deposits with underlying asset amounts and corresponding stStone tokens received. Used for tracking staking activity, token supply changes, and exchange rate analysis between staked assets and stStone receipt tokens.
| 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 0x3121738175a6516223575230d6518b3e61d17cc6 | 3 | 916930 | 5000000000000000 | 24998161 | 2023-12-24T04:47:39.000Z | 0xd14df22835c79c747b3163626139d3da22ada2e695a2d05f3f341ad1cc0ad02a |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 0x3a5d01b7376c44c26ab8cf5935b22a4eeb948e93 | 3 | 920265 | 398960658126645646 | 1994644767 | 2023-12-24T14:03:29.000Z | 0x7c63b90104672063a99496401c30053c1b1a91b1429b63a1b7ad1229076943de |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 0x345f520edef3cf2df889b190c3ee90301c74e647 | 3 | 915840 | 88822396493455937 | 444080192 | 2023-12-24T01:45:59.000Z | 0x6613dbef6afa7919483441515c253c3ad36ebd821dff1b5ed12e2b3464f989b4 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.stStone_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### stStone\_NewReserveFactor\_event
Reserve factor parameter changes for the stStone lending market on Manta Pacific, tracking adjustments to the protocol's reserve allocation percentage. Used for monitoring protocol governance decisions and risk parameter updates.
| 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 |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ---------------------------- | ---------------------------- |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 6 | 858574 | 2023-12-17T10:41:39.000Z | 0xc8522ea277e109303b526c3934420f4b6c20617dee38b22f0c0bf4bb17466074 | 500000000000000000 | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.stStone_NewReserveFactor_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### stStone\_Redeem\_event
Redemption events from the stStone liquid staking token contract on Manta network, tracking when users convert stStone tokens back to underlying assets. Contains redeemer addresses, token amounts burned, and underlying asset amounts received for analyzing unstaking activity and exchange rates.
| 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 |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------ | ---------------- | ------------------------------------------------------------------ |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 4 | 0xf738a5552fb38da2407dd56b00851399119a472c | 963425 | 2023-12-29T13:56:49.000Z | 250447293347271048 | 1252037210 | 0x006965d47059c34669cb61036b28deeaa4548b5034fdb917ee186c240064ce71 |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 4 | 0x3d5e4af8ef2fb321f4cf35475e75172155bdbfdf | 966055 | 2023-12-29T21:15:09.000Z | 300000000000000000 | 1499754636 | 0x38475b710b9edbefec9d9afa40021a174a7127100faaf2c567afd561f8f89a1c |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 4 | 0x2411cf1a310a35ee5d24988cc1b82993d07478ef | 963440 | 2023-12-29T13:59:19.000Z | 410000000000000000 | 2049673750 | 0x7df9f6f8ee036b2000897cf99f0853ee360be473070275af69346c04d318a319 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.stStone_Redeem_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### stStone\_RepayBorrow\_event
Borrow repayment events from the stStone (staked Stone token) lending market on Shoebill protocol deployed on Manta network. Tracks loan repayments with payer/borrower addresses, repayment amounts, and updated account/total borrow balances for analyzing lending activity and debt management.
| 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------ | ------------------------ | ---------------------- | ------------------------------------------------------------------ | ------------------ |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 0x8d52aa454303601078f8006bdd4fbab99c7dcd8d | 3 | 0x8d52aa454303601078f8006bdd4fbab99c7dcd8d | 975935 | 60000000000000000 | 2023-12-31T00:41:49.000Z | 6473163266147206457783 | 0xd6124116ab8345c10e211fba06cfc0a66e6e1d272d47892d3339f10388d646a1 | 82037320772364246 |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 0x3d5e4af8ef2fb321f4cf35475e75172155bdbfdf | 3 | 0x3d5e4af8ef2fb321f4cf35475e75172155bdbfdf | 976499 | 420000000000000000 | 2023-12-31T02:15:49.000Z | 6514750348421204337699 | 0x1d0f2c5053ce13f84614b44fffe23c267e4bce768e10242b2cd7fc0053287fe6 | 710455874321146906 |
| 0x033f5e084a627cc420980ed9b1476c84a92fc5d4 | false | 0xc80bcc40992543c30ec21536635c07e83e66d618 | 4 | 0xc80bcc40992543c30ec21536635c07e83e66d618 | 976099 | 173255033815611033 | 2023-12-31T01:09:09.000Z | 6475960094501334224514 | 0xe41cda2b853c28720fc69d19d3564d349cb065de5f0b9b971b07205b218b6ca9 | 4659162934 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.shoebill_v1_manta.stStone_RepayBorrow_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***