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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_cashPrior`	`STRING`	Cash balance in the market prior to the interest accrual event. Denominated in the smallest unit of the underlying token.
`in_interestAccumulated`	`STRING`	Interest accrued during the period since the last interest calculation. Denominated in the smallest unit of the underlying token.
`in_borrowIndex`	`STRING`	Cumulative borrow interest index for the market. Scaled by 1e18, representing the accumulated interest per unit borrowed since market inception.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	block_number	in_cashPrior	in_borrowIndex	block_timestamp	in_totalBorrows	transaction_hash	in_interestAccumulated
0xe103f874b2d144c5b327fa3d57069bb19c0779e2	false	906756	4585877216154853	1001865988341695400	2023-12-23T00:31:59.000Z	18629295900863034328	0xdd28e9803607784ec3775948b609392e781d9a78d506150c781689a170b86cb1	393139518210182
0xe103f874b2d144c5b327fa3d57069bb19c0779e2	false	912635	25810391370976567	1002233761831326075	2023-12-23T16:51:49.000Z	19146142452360646624	0x2c3141c7cb5e83c7c3772081892e0a45e490b26ffd499e05d92c247ec2d94d49	292320765912345
0xe103f874b2d144c5b327fa3d57069bb19c0779e2	false	909920	10000000079821790	1002065894307227249	2023-12-23T09:19:19.000Z	18633013072049177540	0xdfc061e4915aa99d1d0066eb02fa9f120ddad9e7519bf10f95c908a036bbeb19	162024364631261

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrowAmount`	`STRING`	Amount borrowed in the transaction. Denominated in the smallest unit of the underlying token.
`in_accountBorrows`	`STRING`	Total amount currently borrowed by the individual account. Denominated in the smallest unit of the underlying token.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	log_index	in_borrower	block_number	block_timestamp	in_borrowAmount	in_totalBorrows	transaction_hash	in_accountBorrows
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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_minter`	`STRING`	Address authorized to mint tokens in the operation. Hex-encoded, 0x-prefixed, 42-character string for EVM chains; 66-character hex string for Aptos.
`in_mintAmount`	`STRING`	Quantity of underlying asset deposited into the lending protocol. Numeric string representing token amount in smallest denomination.
`in_mintTokens`	`STRING`	Quantity of protocol-specific interest-bearing tokens minted to the depositor. Numeric string representing token amount in smallest denomination.

Sample Data

address	removed	in_minter	log_index	block_number	in_mintAmount	in_mintTokens	block_timestamp	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_oldReserveFactorMantissa`	`STRING`	Previous reserve factor for the lending market before the update. 18-decimal fixed-point integer stored as string.
`in_newReserveFactorMantissa`	`STRING`	Updated reserve factor for the lending market. 18-decimal fixed-point integer stored as string.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactorMantissa	in_oldReserveFactorMantissa
0xe103f874b2d144c5b327fa3d57069bb19c0779e2	false	11	858578	2023-12-17T10:42:19.000Z	0xe944df1cae4f14ae5aec9cd3bae2bb47458d8a2bcc8aef79825b263e857bfd34	500000000000000000	0

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_redeemer`	`STRING`	Address of the account that initiated the redemption transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_redeemAmount`	`STRING`	Amount of underlying asset tokens withdrawn from the lending pool during redemption.
`in_redeemTokens`	`STRING`	Amount of interest-bearing pool tokens burned during the redemption transaction. String-encoded integer representing the quantity of cTokens or equivalent derivative tokens exchanged for underlying assets.

Sample Data

address	removed	log_index	in_redeemer	block_number	block_timestamp	in_redeemAmount	in_redeemTokens	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_payer`	`STRING`	Address of the account that provided the funds for the repayment or payment transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_repayAmount`	`STRING`	Amount of debt repaid in the transaction. Denominated in the smallest unit of the underlying token.
`in_accountBorrows`	`STRING`	Total amount currently borrowed by the individual account. Denominated in the smallest unit of the underlying token.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	in_payer	log_index	in_borrower	block_number	in_repayAmount	block_timestamp	in_totalBorrows	transaction_hash	in_accountBorrows
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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_cashPrior`	`STRING`	Cash balance in the market prior to the interest accrual event. Denominated in the smallest unit of the underlying token.
`in_interestAccumulated`	`STRING`	Interest accrued during the period since the last interest calculation. Denominated in the smallest unit of the underlying token.
`in_borrowIndex`	`STRING`	Cumulative borrow interest index for the market. Scaled by 1e18, representing the accumulated interest per unit borrowed since market inception.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	block_number	in_cashPrior	in_borrowIndex	block_timestamp	in_totalBorrows	transaction_hash	in_interestAccumulated
0x033f5e084a627cc420980ed9b1476c84a92fc5d4	false	1049617	16865840029375659789210	1001685395996838760	2024-01-08T13:22:09.000Z	10062296355346543783665	0x11f0df7a10af3f761178212493a3415b687c444d51adcc1c8cd50d27ec0ed90b	451570214009388
0x033f5e084a627cc420980ed9b1476c84a92fc5d4	false	1052994	16847687031032223168267	1001715761701791133	2024-01-08T22:44:59.000Z	10072417651177403526678	0x99b4c876ca18ffff69f13ffded14c5b9b5653c0ad58a87858bad966cd2d8bb26	271318966447523
0x033f5e084a627cc420980ed9b1476c84a92fc5d4	false	1052005	16840179630558435998429	1001706866306745664	2024-01-08T20:00:09.000Z	10068639899100783495775	0x9c29045db89972050d455bd8c689668debd65ace4e583274e66f82318079e477	180813710210940

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrowAmount`	`STRING`	Amount borrowed in the transaction. Denominated in the smallest unit of the underlying token.
`in_accountBorrows`	`STRING`	Total amount currently borrowed by the individual account. Denominated in the smallest unit of the underlying token.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	log_index	in_borrower	block_number	block_timestamp	in_borrowAmount	in_totalBorrows	transaction_hash	in_accountBorrows
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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_minter`	`STRING`	Address authorized to mint tokens in the operation. Hex-encoded, 0x-prefixed, 42-character string for EVM chains; 66-character hex string for Aptos.
`in_mintAmount`	`STRING`	Quantity of underlying asset deposited into the lending protocol. Numeric string representing token amount in smallest denomination.
`in_mintTokens`	`STRING`	Quantity of protocol-specific interest-bearing tokens minted to the depositor. Numeric string representing token amount in smallest denomination.

Sample Data

address	removed	in_minter	log_index	block_number	in_mintAmount	in_mintTokens	block_timestamp	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_oldReserveFactorMantissa`	`STRING`	Previous reserve factor for the lending market before the update. 18-decimal fixed-point integer stored as string.
`in_newReserveFactorMantissa`	`STRING`	Updated reserve factor for the lending market. 18-decimal fixed-point integer stored as string.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactorMantissa	in_oldReserveFactorMantissa
0x033f5e084a627cc420980ed9b1476c84a92fc5d4	false	6	858574	2023-12-17T10:41:39.000Z	0xc8522ea277e109303b526c3934420f4b6c20617dee38b22f0c0bf4bb17466074	500000000000000000	0

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_redeemer`	`STRING`	Address of the account that initiated the redemption transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_redeemAmount`	`STRING`	Amount of underlying asset tokens withdrawn from the lending pool during redemption.
`in_redeemTokens`	`STRING`	Amount of interest-bearing pool tokens burned during the redemption transaction. String-encoded integer representing the quantity of cTokens or equivalent derivative tokens exchanged for underlying assets.

Sample Data

address	removed	log_index	in_redeemer	block_number	block_timestamp	in_redeemAmount	in_redeemTokens	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_payer`	`STRING`	Address of the account that provided the funds for the repayment or payment transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_repayAmount`	`STRING`	Amount of debt repaid in the transaction. Denominated in the smallest unit of the underlying token.
`in_accountBorrows`	`STRING`	Total amount currently borrowed by the individual account. Denominated in the smallest unit of the underlying token.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	in_payer	log_index	in_borrower	block_number	in_repayAmount	block_timestamp	in_totalBorrows	transaction_hash	in_accountBorrows
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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_cashPrior`	`STRING`	Cash balance in the market prior to the interest accrual event. Denominated in the smallest unit of the underlying token.
`in_interestAccumulated`	`STRING`	Interest accrued during the period since the last interest calculation. Denominated in the smallest unit of the underlying token.
`in_borrowIndex`	`STRING`	Cumulative borrow interest index for the market. Scaled by 1e18, representing the accumulated interest per unit borrowed since market inception.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	block_number	in_cashPrior	in_borrowIndex	block_timestamp	in_totalBorrows	transaction_hash	in_interestAccumulated
0xff2033181cbf7ee2656d9a527d378930b31c3a42	false	887386	1838531386	1000200638016949953	2023-12-20T18:43:39.000Z	29214455965	0xa101780d37ae50c521339d0eb50b9ef11e580a89977ee76856d59f5091dbe59d	244802
0xff2033181cbf7ee2656d9a527d378930b31c3a42	false	885308	30053207274	1000168137988911409	2023-12-20T12:57:19.000Z	10037399	0x262bdcd49be0b80064b2d60b8591bbede6c698e6103a2026652fc7c7092f6a96	260
0xff2033181cbf7ee2656d9a527d378930b31c3a42	false	886377	7134531519	1000175800461249946	2023-12-20T15:55:29.000Z	23917747450	0x20792598fa25c380f9746da2bd8527fa0f6fcf4c781d55c20a4a3e86a76568e0	4504

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrowAmount`	`STRING`	Amount borrowed in the transaction. Denominated in the smallest unit of the underlying token.
`in_accountBorrows`	`STRING`	Total amount currently borrowed by the individual account. Denominated in the smallest unit of the underlying token.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	log_index	in_borrower	block_number	block_timestamp	in_borrowAmount	in_totalBorrows	transaction_hash	in_accountBorrows
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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_minter`	`STRING`	Address authorized to mint tokens in the operation. Hex-encoded, 0x-prefixed, 42-character string for EVM chains; 66-character hex string for Aptos.
`in_mintAmount`	`STRING`	Quantity of underlying asset deposited into the lending protocol. Numeric string representing token amount in smallest denomination.
`in_mintTokens`	`STRING`	Quantity of protocol-specific interest-bearing tokens minted to the depositor. Numeric string representing token amount in smallest denomination.

Sample Data

address	removed	in_minter	log_index	block_number	in_mintAmount	in_mintTokens	block_timestamp	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_oldReserveFactorMantissa`	`STRING`	Previous reserve factor for the lending market before the update. 18-decimal fixed-point integer stored as string.
`in_newReserveFactorMantissa`	`STRING`	Updated reserve factor for the lending market. 18-decimal fixed-point integer stored as string.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactorMantissa	in_oldReserveFactorMantissa
0xff2033181cbf7ee2656d9a527d378930b31c3a42	false	13	859067	2023-12-17T12:03:49.000Z	0x0f7b1ae243e99190567f049c5e9388a3ef0abc704487946c5d48db619e48aff9	500000000000000000	0

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_redeemer`	`STRING`	Address of the account that initiated the redemption transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_redeemAmount`	`STRING`	Amount of underlying asset tokens withdrawn from the lending pool during redemption.
`in_redeemTokens`	`STRING`	Amount of interest-bearing pool tokens burned during the redemption transaction. String-encoded integer representing the quantity of cTokens or equivalent derivative tokens exchanged for underlying assets.

Sample Data

address	removed	log_index	in_redeemer	block_number	block_timestamp	in_redeemAmount	in_redeemTokens	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_payer`	`STRING`	Address of the account that provided the funds for the repayment or payment transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_repayAmount`	`STRING`	Amount of debt repaid in the transaction. Denominated in the smallest unit of the underlying token.
`in_accountBorrows`	`STRING`	Total amount currently borrowed by the individual account. Denominated in the smallest unit of the underlying token.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	in_payer	log_index	in_borrower	block_number	in_repayAmount	block_timestamp	in_totalBorrows	transaction_hash	in_accountBorrows
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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_cashPrior`	`STRING`	Cash balance in the market prior to the interest accrual event. Denominated in the smallest unit of the underlying token.
`in_interestAccumulated`	`STRING`	Interest accrued during the period since the last interest calculation. Denominated in the smallest unit of the underlying token.
`in_borrowIndex`	`STRING`	Cumulative borrow interest index for the market. Scaled by 1e18, representing the accumulated interest per unit borrowed since market inception.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	block_number	in_cashPrior	in_borrowIndex	block_timestamp	in_totalBorrows	transaction_hash	in_interestAccumulated
0xc0ef6dea74e54689867fdd5f0ab2202f7d8a0d7b	false	959974	2667057180255058496740672	1000878476945395441	2023-12-29T04:21:39.000Z	1950549239793656744620433	0xc76397ab31aaa748a737946d171df7fc27bd67332b84a3640b3f425d5b14ad11	181771597277529256
0xc0ef6dea74e54689867fdd5f0ab2202f7d8a0d7b	false	964115	2910941437618694063222001	1000917021760100456	2023-12-29T15:51:49.000Z	2151427614791101912230001	0x65a6c5123121355c80f86b1c8bb4b020aaae80b6e3bb2253e24cbb4fc6923047	80352238435874244
0xc0ef6dea74e54689867fdd5f0ab2202f7d8a0d7b	false	967006	3278049022176789342261889	1000944484900131799	2023-12-29T23:53:39.000Z	2940331679774705532176799	0x3bfb4288cbe456ae01ca66715e4745dd20f2477a79c07f951fcbf4fda63165ef	1166273535996590191

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrowAmount`	`STRING`	Amount borrowed in the transaction. Denominated in the smallest unit of the underlying token.
`in_accountBorrows`	`STRING`	Total amount currently borrowed by the individual account. Denominated in the smallest unit of the underlying token.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	log_index	in_borrower	block_number	block_timestamp	in_borrowAmount	in_totalBorrows	transaction_hash	in_accountBorrows
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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_minter`	`STRING`	Address authorized to mint tokens in the operation. Hex-encoded, 0x-prefixed, 42-character string for EVM chains; 66-character hex string for Aptos.
`in_mintAmount`	`STRING`	Quantity of underlying asset deposited into the lending protocol. Numeric string representing token amount in smallest denomination.
`in_mintTokens`	`STRING`	Quantity of protocol-specific interest-bearing tokens minted to the depositor. Numeric string representing token amount in smallest denomination.

Sample Data

address	removed	in_minter	log_index	block_number	in_mintAmount	in_mintTokens	block_timestamp	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_oldReserveFactorMantissa`	`STRING`	Previous reserve factor for the lending market before the update. 18-decimal fixed-point integer stored as string.
`in_newReserveFactorMantissa`	`STRING`	Updated reserve factor for the lending market. 18-decimal fixed-point integer stored as string.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactorMantissa	in_oldReserveFactorMantissa
0xc0ef6dea74e54689867fdd5f0ab2202f7d8a0d7b	false	13	859068	2023-12-17T12:03:59.000Z	0x2d3fbdb796a91156c1e7567661284ee8e3eea0301c2146963bcb6efa2359c327	500000000000000000	0

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_redeemer`	`STRING`	Address of the account that initiated the redemption transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_redeemAmount`	`STRING`	Amount of underlying asset tokens withdrawn from the lending pool during redemption.
`in_redeemTokens`	`STRING`	Amount of interest-bearing pool tokens burned during the redemption transaction. String-encoded integer representing the quantity of cTokens or equivalent derivative tokens exchanged for underlying assets.

Sample Data

address	removed	log_index	in_redeemer	block_number	block_timestamp	in_redeemAmount	in_redeemTokens	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_payer`	`STRING`	Address of the account that provided the funds for the repayment or payment transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_repayAmount`	`STRING`	Amount of debt repaid in the transaction. Denominated in the smallest unit of the underlying token.
`in_accountBorrows`	`STRING`	Total amount currently borrowed by the individual account. Denominated in the smallest unit of the underlying token.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	in_payer	log_index	in_borrower	block_number	in_repayAmount	block_timestamp	in_totalBorrows	transaction_hash	in_accountBorrows
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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_cashPrior`	`STRING`	Cash balance in the market prior to the interest accrual event. Denominated in the smallest unit of the underlying token.
`in_interestAccumulated`	`STRING`	Interest accrued during the period since the last interest calculation. Denominated in the smallest unit of the underlying token.
`in_borrowIndex`	`STRING`	Cumulative borrow interest index for the market. Scaled by 1e18, representing the accumulated interest per unit borrowed since market inception.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	block_number	in_cashPrior	in_borrowIndex	block_timestamp	in_totalBorrows	transaction_hash	in_interestAccumulated
0x033f5e084a627cc420980ed9b1476c84a92fc5d4	false	985533	12101850647594416708448	1001113219476463318	2024-01-01T03:21:29.000Z	7235747726154240132703	0x283ce14cb7ede4232c1432763b3174536840753bfb9e369c1d10d7213e1ca096	649688802531088
0x033f5e084a627cc420980ed9b1476c84a92fc5d4	false	988633	12330404251154315571079	1001141039258809765	2024-01-01T11:58:09.000Z	7306451259212329851688	0xd7ec4217237523133f8632f93077b6170f0ac64dd82066f7f2f855fe7bac79e9	65495579114638
0x033f5e084a627cc420980ed9b1476c84a92fc5d4	false	987504	12300417834923740348909	1001130907635457813	2024-01-01T08:49:59.000Z	7288262370446136393817	0xb11d427dffba5dbcdf34489fb1d0397aaaed671e7f57735acac4768fc7d84caf	65331808530514

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrowAmount`	`STRING`	Amount borrowed in the transaction. Denominated in the smallest unit of the underlying token.
`in_accountBorrows`	`STRING`	Total amount currently borrowed by the individual account. Denominated in the smallest unit of the underlying token.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	log_index	in_borrower	block_number	block_timestamp	in_borrowAmount	in_totalBorrows	transaction_hash	in_accountBorrows
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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_minter`	`STRING`	Address authorized to mint tokens in the operation. Hex-encoded, 0x-prefixed, 42-character string for EVM chains; 66-character hex string for Aptos.
`in_mintAmount`	`STRING`	Quantity of underlying asset deposited into the lending protocol. Numeric string representing token amount in smallest denomination.
`in_mintTokens`	`STRING`	Quantity of protocol-specific interest-bearing tokens minted to the depositor. Numeric string representing token amount in smallest denomination.

Sample Data

address	removed	in_minter	log_index	block_number	in_mintAmount	in_mintTokens	block_timestamp	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_oldReserveFactorMantissa`	`STRING`	Previous reserve factor for the lending market before the update. 18-decimal fixed-point integer stored as string.
`in_newReserveFactorMantissa`	`STRING`	Updated reserve factor for the lending market. 18-decimal fixed-point integer stored as string.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactorMantissa	in_oldReserveFactorMantissa
0x033f5e084a627cc420980ed9b1476c84a92fc5d4	false	6	858574	2023-12-17T10:41:39.000Z	0xc8522ea277e109303b526c3934420f4b6c20617dee38b22f0c0bf4bb17466074	500000000000000000	0

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_redeemer`	`STRING`	Address of the account that initiated the redemption transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_redeemAmount`	`STRING`	Amount of underlying asset tokens withdrawn from the lending pool during redemption.
`in_redeemTokens`	`STRING`	Amount of interest-bearing pool tokens burned during the redemption transaction. String-encoded integer representing the quantity of cTokens or equivalent derivative tokens exchanged for underlying assets.

Sample Data

address	removed	log_index	in_redeemer	block_number	block_timestamp	in_redeemAmount	in_redeemTokens	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_payer`	`STRING`	Address of the account that provided the funds for the repayment or payment transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_repayAmount`	`STRING`	Amount of debt repaid in the transaction. Denominated in the smallest unit of the underlying token.
`in_accountBorrows`	`STRING`	Total amount currently borrowed by the individual account. Denominated in the smallest unit of the underlying token.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	in_payer	log_index	in_borrower	block_number	in_repayAmount	block_timestamp	in_totalBorrows	transaction_hash	in_accountBorrows
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

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

sbEth_AccrueInterest_event

sbEth_Borrow_event

sbEth_Mint_event

sbEth_NewReserveFactor_event

sbEth_Redeem_event

sbEth_RepayBorrow_event

sbStone_AccrueInterest_event

sbStone_Borrow_event

sbStone_Mint_event

sbStone_NewReserveFactor_event

sbStone_Redeem_event

sbStone_RepayBorrow_event

sbUsdc_AccrueInterest_event

sbUsdc_Borrow_event

sbUsdc_Mint_event

sbUsdc_NewReserveFactor_event

sbUsdc_Redeem_event

sbUsdc_RepayBorrow_event

sbwUsdm_AccrueInterest_event

sbwUsdm_Borrow_event

sbwUsdm_Mint_event

sbwUsdm_NewReserveFactor_event

sbwUsdm_Redeem_event

sbwUsdm_RepayBorrow_event

stStone_AccrueInterest_event

stStone_Borrow_event

stStone_Mint_event

stStone_NewReserveFactor_event

stStone_Redeem_event

stStone_RepayBorrow_event

​Tables

​sbEth_AccrueInterest_event

​sbEth_Borrow_event

​sbEth_Mint_event

​sbEth_NewReserveFactor_event

​sbEth_Redeem_event

​sbEth_RepayBorrow_event

​sbStone_AccrueInterest_event

​sbStone_Borrow_event

​sbStone_Mint_event

​sbStone_NewReserveFactor_event

​sbStone_Redeem_event

​sbStone_RepayBorrow_event

​sbUsdc_AccrueInterest_event

​sbUsdc_Borrow_event

​sbUsdc_Mint_event

​sbUsdc_NewReserveFactor_event

​sbUsdc_Redeem_event

​sbUsdc_RepayBorrow_event

​sbwUsdm_AccrueInterest_event

​sbwUsdm_Borrow_event

​sbwUsdm_Mint_event

​sbwUsdm_NewReserveFactor_event

​sbwUsdm_Redeem_event

​sbwUsdm_RepayBorrow_event

​stStone_AccrueInterest_event

​stStone_Borrow_event

​stStone_Mint_event

​stStone_NewReserveFactor_event

​stStone_Redeem_event

​stStone_RepayBorrow_event

Tables

sbEth_AccrueInterest_event

sbEth_Borrow_event

sbEth_Mint_event

sbEth_NewReserveFactor_event

sbEth_Redeem_event

sbEth_RepayBorrow_event

sbStone_AccrueInterest_event

sbStone_Borrow_event

sbStone_Mint_event

sbStone_NewReserveFactor_event

sbStone_Redeem_event

sbStone_RepayBorrow_event

sbUsdc_AccrueInterest_event

sbUsdc_Borrow_event

sbUsdc_Mint_event

sbUsdc_NewReserveFactor_event

sbUsdc_Redeem_event

sbUsdc_RepayBorrow_event

sbwUsdm_AccrueInterest_event

sbwUsdm_Borrow_event

sbwUsdm_Mint_event

sbwUsdm_NewReserveFactor_event

sbwUsdm_Redeem_event

sbwUsdm_RepayBorrow_event

stStone_AccrueInterest_event

stStone_Borrow_event

stStone_Mint_event

stStone_NewReserveFactor_event

stStone_Redeem_event

stStone_RepayBorrow_event