sonne_v1_base

Tables

Comptroller_DistributedBorrowerComp_event

SONNE protocol borrower reward distribution events on Base, recording when borrowers receive SONNE governance tokens as incentives. Tracks reward amounts (compDelta), per-market borrow indices, and recipient addresses for analyzing protocol incentive distribution and yield farming 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_cToken`	`STRING`	Contract address of the cToken representing a money market on the Compound protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_compDelta`	`STRING`	Amount of COMP governance tokens distributed to the user in this event. Integer value denominated in the smallest token unit (wei).
`in_compBorrowIndex`	`STRING`	Cumulative index tracking COMP (or equivalent governance token) reward accrual for borrowers of the specific cToken market. Large integer values represent the scaled index used to calculate individual borrower rewards over time.

Sample Data

address	removed	in_cToken	log_index	in_borrower	block_number	in_compDelta	block_timestamp	transaction_hash	in_compBorrowIndex
0x1db2466d9f5e10d7090e7152b68d62703a2245f0	false	0x5f5c479fe590cd4442a05ae4a941dd991a633b8e	29	0x02e7b714fae84e4ba80f3cda5508553e7cf5042a	6040611	757702968912285065	2023-11-01T20:29:29.000Z	0x4b100e7385c72cd36a929ccf2ed3f393b4911ae8ab1650cc1f5dc709ee257e63	298647936191035599017246895926030992326
0x1db2466d9f5e10d7090e7152b68d62703a2245f0	false	0x5f5c479fe590cd4442a05ae4a941dd991a633b8e	14	0x02e7b714fae84e4ba80f3cda5508553e7cf5042a	6024102	6026730080358295703	2023-11-01T11:19:11.000Z	0xe128ed0b6b41c293c7271c3c4413d71e1f305ee5a9591863abf1423f28a7e250	296645707657053907790526269831376020930
0x1db2466d9f5e10d7090e7152b68d62703a2245f0	false	0x5f5c479fe590cd4442a05ae4a941dd991a633b8e	160	0x02e7b714fae84e4ba80f3cda5508553e7cf5042a	6024498	18369249613676234	2023-11-01T11:32:23.000Z	0x8ff82357274d17760b6f3440acb75c2e5c42eb33742a18ae82ab786c483c29b3	296693797729809899607847027678021643548

Example Query

Query with partition filter

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

Comptroller_DistributedSupplierComp_event

SONNE token reward distribution events for suppliers on Sonne Finance lending protocol on Base. Tracks reward amounts and supply index updates for each cToken market and supplier address.

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_cToken`	`STRING`	Contract address of the cToken representing a money market on the Compound protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_supplier`	`STRING`	Address of the user who supplied assets to the lending protocol and is receiving reward tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_compDelta`	`STRING`	Amount of COMP governance tokens distributed to the user in this event. Integer value denominated in the smallest token unit (wei).
`in_compSupplyIndex`	`STRING`	Cumulative index tracking the accrued SONNE governance tokens per unit of supply for this cToken market. The index increases over time as rewards accumulate, represented as a high-precision integer value.

Sample Data

address	removed	in_cToken	log_index	in_supplier	block_number	in_compDelta	block_timestamp	transaction_hash	in_compSupplyIndex
0x1db2466d9f5e10d7090e7152b68d62703a2245f0	false	0xfd68f92b45b633bbe0f475294c1a86aecd62985a	22	0x029339add846102f847b409ca425f232b60f0a80	10560107	3236174233523	2024-02-14T11:19:21.000Z	0xd5944518641058d86634c34ec4e4f57396116fc80d191c4e5d933907222b572f	26473233529586804615890194821699901443538553
0x1db2466d9f5e10d7090e7152b68d62703a2245f0	false	0xfd68f92b45b633bbe0f475294c1a86aecd62985a	36	0x029339add846102f847b409ca425f232b60f0a80	10560094	0	2024-02-14T11:18:55.000Z	0x24968fb2f15ff84045c260adbdc3ec4b21f18a23ee34943a7bf91e62d12d94ab	26473180916161439909129527372041561176309760
0x1db2466d9f5e10d7090e7152b68d62703a2245f0	false	0x6c91beeceedda2089307fab818e12757948bf489	44	0x0748677149c4ac8c822abb066ed224db083a9741	10540917	0	2024-02-14T00:39:41.000Z	0x58948bcfbe07323ee3d9a7fc4ca4e87069bb519452812bbdc8364336d4d17565	46211998388166437586154804794911766237175460351

Example Query

Query with partition filter

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

sobcbETH_AccrueInterest_event

Interest accrual events from Sonne Finance’s cbETH (Coinbase Wrapped Staked ETH) lending market on Base, tracking accumulated interest, total borrows, and borrow index updates. Used for analyzing lending market interest rate dynamics and borrowing activity 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
0x6c91beeceedda2089307fab818e12757948bf489	false	6423200	414373160148350312644	1001529193513524137	2023-11-10T17:02:27.000Z	224569439066215614997	0xa6a9e3157f70d36e8b14a3090c285505bd7f881b30ee486f37bbc928ece932bd	4638022637591356
0x6c91beeceedda2089307fab818e12757948bf489	false	6406420	384107935579472380941	1001402303802601884	2023-11-10T07:43:07.000Z	251552661053138086237	0x8a94154ed9f262bd59db1dc55d47fa6b16971a90a6e65552d5c667281a8ea3a6	90074748255560
0x6c91beeceedda2089307fab818e12757948bf489	false	6426314	427411788577004032187	1001552737679177047	2023-11-10T18:46:15.000Z	224574718293329711992	0x8518dfdde7eb985fc3b7e0f8ef6101947686f0a8b7f3e0c00bc4d8551b958835	18311359548995

Example Query

Query with partition filter

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

sobcbETH_Borrow_event

Borrow event logs from the Sonne Finance cbETH (Coinbase Wrapped Staked ETH) lending market on Base, tracking when users borrow cbETH with individual borrow amounts, account-level borrows, and protocol-wide total borrows. Used for analyzing borrowing activity, debt accumulation patterns, and market 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
0x6c91beeceedda2089307fab818e12757948bf489	false	36	0x6c37eeadb3ec0a623b7f8690c6343a68f38b0b87	7270747	2023-11-30T07:54:01.000Z	2593800523266620	301307785724533012527	0xf5e0625c32a6241c993dfe5aa73383097a83c03adbf15ada8f5172d1a67f261c	2593800523266620
0x6c91beeceedda2089307fab818e12757948bf489	false	6	0xc64a0fd9099213f80d83579655635e0841218139	7273895	2023-11-30T09:38:57.000Z	1722934779606763	301312463382709021499	0xb37e426a4832d4d2d0ea69478f17432293d75e0879295d465711a12412142a4f	1722934779606763
0x6c91beeceedda2089307fab818e12757948bf489	false	11	0x2add46ae7602443f60afa93d7597735f1ac805c3	8701683	2024-01-02T10:51:53.000Z	48319006320398940	337074046267900970859	0xc844bdc037825d3806ba9eee31cd1eeac982eb824b190312fa4ac92fc16d7b42	48319006320398940

Example Query

Query with partition filter

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

sobcbETH_Mint_event

Mint events for the Sonne Finance sobcbETH lending market on Base, recording deposits of cbETH (Coinbase Wrapped ETH) and issuance of corresponding soToken receipts. Used to track supply-side activity and exchange rates between underlying assets and interest-bearing 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
0x6c91beeceedda2089307fab818e12757948bf489	false	0x8b9f26cc87e564e609e70d74a569c6c83bbd680a	3	8685251	78025235110002000	388621143	2024-01-02T01:44:09.000Z	0xae4ac2111205af4cce905c2fdaf9ebf19dc4d268ebf9186c8ac440014212f0ac
0x6c91beeceedda2089307fab818e12757948bf489	false	0xfa1661f691676b656974914027bf1a84b7de72ff	11	8693086	1662500000000000000	8280331522	2024-01-02T06:05:19.000Z	0xa9cb2ed519cbd00d78d0d499ab8986cdd041a65afd3f02fb31bb7561fe6524b8
0x6c91beeceedda2089307fab818e12757948bf489	false	0x6be348a1e34342ca2de1a77382fbd7306ee42feb	4	8689500	2093729000000000000	10428190372	2024-01-02T04:05:47.000Z	0x30b5b768cb85f0bc9b2383279136d2db3af3e360b3d90cce1f82cc240fe2466b

Example Query

Query with partition filter

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

sobcbETH_NewReserveFactor_event

Reserve factor adjustment events for Sonne Finance’s cbETH (Coinbase Wrapped Staked ETH) lending market on Base. Tracks changes to the protocol’s reserve percentage used for risk management and treasury allocation.

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
0x6c91beeceedda2089307fab818e12757948bf489	false	23	6021424	2023-11-01T09:49:55.000Z	0x3662abe9c28218ffcab6a86575f11ba5b26f72db4ac4ab3178f2e0b232e7b356	180000000000000000	0

Example Query

Query with partition filter

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

sobcbETH_Redeem_event

Redeem event logs from Sonne Finance’s cbETH (Coinbase Wrapped Staked ETH) lending market on Base, recording withdrawals of underlying cbETH assets in exchange for soCbETH tokens. Tracks redeemer addresses, redemption amounts, and corresponding token quantities for analyzing lending pool liquidity and user withdrawal 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
0x6c91beeceedda2089307fab818e12757948bf489	false	10	0x84823d74a30321b9316bd3f7caa1e2809aaf2a9b	8001352	2023-12-17T05:47:31.000Z	3509007869294919	17494448	0x4946c5bff13e0a2f141bcb4a941ed12089145c4462780795aeed7d57f56760f5
0x6c91beeceedda2089307fab818e12757948bf489	false	21	0x155fcf481e6df9b42072ade56b4c220ce2d16af8	8014293	2023-12-17T12:58:53.000Z	1880959875389876	9377491	0x90d746c124c3bba4c16378061edb7974a85a1606b34b92f1b5ab4ce2eb5bdbac
0x6c91beeceedda2089307fab818e12757948bf489	false	30	0x8f7d775c74e8511d1812751011be3eba042c6f78	8027311	2023-12-17T20:12:49.000Z	269557685664833882	1343847582	0x6731e544dc0e9a50c24aaf66b5d8bc40ab1ff2a4ed8ab61146aee9de5644b16c

Example Query

Query with partition filter

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

sobcbETH_RepayBorrow_event

Borrow repayment events from Sonne Finance’s cbETH (Coinbase Wrapped Staked ETH) lending market on Base. Tracks repayment amounts, payer and borrower addresses, and updated borrow balances for analyzing debt reduction activity and liquidation patterns.

Columns

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

Sample Data

address	removed	in_payer	log_index	in_borrower	block_number	in_repayAmount	block_timestamp	in_totalBorrows	transaction_hash	in_accountBorrows
0x6c91beeceedda2089307fab818e12757948bf489	false	0x32eb2fa64138a631250f9fe917ee68e7b6db3f41	44	0x32eb2fa64138a631250f9fe917ee68e7b6db3f41	9482531	35250676156500000	2024-01-20T12:40:09.000Z	338686605194647678193	0x2a24c165539a2f82d49479e0cb3bc9e6cd93d7031679e2b8351be91bca75e11e	7429447463
0x6c91beeceedda2089307fab818e12757948bf489	false	0x5c333c355385e1e0fa7228782d96bb5cf12f0044	8	0x5c333c355385e1e0fa7228782d96bb5cf12f0044	9479885	65138958385811000	2024-01-20T11:11:57.000Z	338679610611900453262	0xefd35664376bdb1cb5c777eeaf8b11ef596d6d2e3101c97453f5e40a779f7b60	13220886565
0x6c91beeceedda2089307fab818e12757948bf489	false	0x7ac424085d1e4000b37273a170e04bdea958b5f5	11	0x7ac424085d1e4000b37273a170e04bdea958b5f5	9495031	31900000000000000	2024-01-20T19:36:49.000Z	338720458272829711334	0x8ba25f26a9255e0b35d58da59f1f4609c4210626c7f1d4581624806a27105ae0	4173652407

Example Query

Query with partition filter

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

sobDAI_AccrueInterest_event

Interest accrual events for the Sonne Finance DAI market (sobDAI) on Base, tracking borrow index updates, accumulated interest, cash reserves, and total borrows. Used for calculating lending rates, monitoring protocol health, and analyzing yield generation in the DAI 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	log_index	block_number	in_cashPrior	in_borrowIndex	block_timestamp	in_totalBorrows	transaction_hash	in_interestAccumulated
0xb864ba2aab1f53bc3af7ae49a318202dd3fd54c2	false	4	4565001	2029559717140298122618815	1003170748632005072	2023-09-28T16:42:29.000Z	3023690985537214119314565	0x22b3b2832cdb8860532da99517df25cb994027e4a85a1088c706d120bb9df47f	32738964238081778736
0xb864ba2aab1f53bc3af7ae49a318202dd3fd54c2	false	4	4560437	2034941938934465330077681	1003159886817282191	2023-09-28T14:10:21.000Z	3023658246572976037535829	0x1dbad26292f07e6f450e9591781429b9e25779136454988f59355cd102987e72	30568294103107467665
0xb864ba2aab1f53bc3af7ae49a318202dd3fd54c2	false	6	4540800	2056332123024849764790605	1003113400611853382	2023-09-28T03:15:47.000Z	3023518130924170877515632	0x11b9d6786f2c2ea2a287d9ff17f67d1a31f06fa8316719c9dcc7e4afecb5b556	49408679864400886803

Example Query

Query with partition filter

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

sobDAI_Borrow_event

Borrow event logs from Sonne Finance’s DAI lending market (soDAI) on Base, capturing when users take out DAI loans against their collateral. Records individual borrow transactions with borrower addresses, borrowed amounts, and cumulative account/total borrow balances for tracking lending protocol activity and user debt positions.

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
0xb864ba2aab1f53bc3af7ae49a318202dd3fd54c2	false	28	0xdfcdad3b0ff31cbba124ca232bcdbf05b3912ce4	10420270	2024-02-11T05:38:07.000Z	40000000000000000	2025938395436650417798850	0x32412c8ffa20884a2944b28f4cad50a2db95a4accff8207b36332d2ef4713d13	40000000000000000
0xb864ba2aab1f53bc3af7ae49a318202dd3fd54c2	false	3	0x6cc19692eabf3dae59e3eeea81dcb9340f159506	6301732	2023-11-07T21:33:31.000Z	2038050932938109300000	2723857824543709409124679	0xede09d16075ac7e86a174a7b58b1363e1bae5d74e4f6bc63596e1a8183e10acf	5056159780663109031421
0xb864ba2aab1f53bc3af7ae49a318202dd3fd54c2	false	4	0x6cc19692eabf3dae59e3eeea81dcb9340f159506	6301939	2023-11-07T21:40:25.000Z	2038032703433405000000	2723859407705995084448166	0x1f217319a63a6f7774c696d6757fe9c745c6a0476a4a7a128857215726d20744	5056143795639535478698

Example Query

Query with partition filter

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

sobDAI_Mint_event

Mint events from the sobDAI lending market on Sonne Finance protocol (Base), recording when users supply DAI collateral to receive soDAI interest-bearing tokens. Useful for analyzing supply-side liquidity flows and calculating the DAI-to-soDAI exchange rate 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_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
0xb864ba2aab1f53bc3af7ae49a318202dd3fd54c2	false	0x096a11f594767e372cc41bc4db94fd9fa3bb4214	9	4632260	57204958834408666000000	285505107592676	2023-09-30T06:04:27.000Z	0x880fb08f076a66031d7872e80d9402c5e5ab9d5d96f9227daa7f7c01ec0aab36
0xb864ba2aab1f53bc3af7ae49a318202dd3fd54c2	false	0x0c97ee1aa06ec8f9a910c77f54c109d58490225d	53	4655092	167498751057002357982	835942362083	2023-09-30T18:45:31.000Z	0x8b1f18396052a7174c8ffcf5f35c4d42f25e6d91dd735216f389fb8203dc23e2
0xb864ba2aab1f53bc3af7ae49a318202dd3fd54c2	false	0x0c97ee1aa06ec8f9a910c77f54c109d58490225d	52	4649113	50386334430622857366	251467340562	2023-09-30T15:26:13.000Z	0x05af9a9d56ef9fb0fc45333870800757ffa45271efccdd9448126a880e5d1005

Example Query

Query with partition filter

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

sobDAI_NewReserveFactor_event

Reserve factor parameter changes for the Sonne Finance DAI lending market (sobDAI) on Base. Tracks governance-initiated adjustments to the protocol’s revenue retention rate, with mantissa values representing the fraction of interest allocated to reserves.

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactorMantissa	in_oldReserveFactorMantissa
0xb864ba2aab1f53bc3af7ae49a318202dd3fd54c2	false	19	2494518	2023-08-11T18:26:23.000Z	0x36090d85200b729abce51d86197d164dddc9562905776e1f8f2b79a99346ce22	100000000000000000	0
0xb864ba2aab1f53bc3af7ae49a318202dd3fd54c2	false	19	3307976	2023-08-30T14:21:39.000Z	0xb80897c0cc6c22779ba0b01241f0d1df297f5d39cc20a2e7e93c85ed916b4a1e	130000000000000000	100000000000000000

Example Query

Query with partition filter

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

sobDAI_Redeem_event

Redemption events from Sonne Finance’s DAI lending market (soDAI) on Base, recording when users withdraw their supplied DAI collateral in exchange for their soDAI tokens. Used for analyzing lending pool liquidity withdrawals and user redemption 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
0xb864ba2aab1f53bc3af7ae49a318202dd3fd54c2	false	8	0x0edd42c2888d9ecd7fbc11c657354953f33eef67	5790480	2023-10-27T01:31:47.000Z	32108394372216382962283	159948282912115	0x32771542e290e82a57cb1732b4a451d5e4fbe51529255f3e8093f3290c441305
0xb864ba2aab1f53bc3af7ae49a318202dd3fd54c2	false	5	0x0edd42c2888d9ecd7fbc11c657354953f33eef67	5789071	2023-10-27T00:44:49.000Z	9000000000000000000000	44833700062252	0x3f43b959d1a751e0e5d5235a809d19a57c4b3a6b7d7c4d2ba418a06a3dc6251a
0xb864ba2aab1f53bc3af7ae49a318202dd3fd54c2	false	22	0x0edd42c2888d9ecd7fbc11c657354953f33eef67	5790462	2023-10-27T01:31:11.000Z	30500000000000000000000	151936055288631	0xa7814936ddeb02d1e2b2d4ea7718f513c9f769f1c055d2af2ae27340925097e1

Example Query

Query with partition filter

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

sobDAI_RepayBorrow_event

DAI loan repayment events from Sonne Finance (soDAI market) on Base, recording when borrowers repay debt with payer address, repayment amount, and updated borrow balances. Used for analyzing lending protocol activity, debt management patterns, and calculating outstanding loan positions.

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
0xb864ba2aab1f53bc3af7ae49a318202dd3fd54c2	false	0x18d35c6df1c32fe1b6286f57c772f2be9efd9ff0	3	0x18d35c6df1c32fe1b6286f57c772f2be9efd9ff0	3419665	9517368718334730147035	2023-09-02T04:24:37.000Z	2349513680652874601606379	0x9090f697ab09ec160d0c6a3e65fe6a47704714184454e6648ff64de9df9377d2	148565537936982977683728
0xb864ba2aab1f53bc3af7ae49a318202dd3fd54c2	false	0x18d35c6df1c32fe1b6286f57c772f2be9efd9ff0	3	0x18d35c6df1c32fe1b6286f57c772f2be9efd9ff0	3419620	8380009088544635733192	2023-09-02T04:23:07.000Z	2359030520426653523857378	0xd3c57916f4be4fd5b329f89488df3b00fa5acc856adffc2f716f92edf1e323d3	158082871209793214477073
0xb864ba2aab1f53bc3af7ae49a318202dd3fd54c2	false	0x18d35c6df1c32fe1b6286f57c772f2be9efd9ff0	8	0x18d35c6df1c32fe1b6286f57c772f2be9efd9ff0	3421061	20173282344490879040677	2023-09-02T05:11:09.000Z	2286426239368995165010243	0x8ac8a4866b4ef621adfc73aa74efbd8a59b76ef135e4ae4d33edd91c4a8378ad	85462585248184343418730

Example Query

Query with partition filter

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

sobUSDbC_AccrueInterest_event

Interest accrual events from Sonne Finance’s sobUSDbC (USD Base Coin) lending market on Base, recording cash reserves, total borrows, borrow index, and accumulated interest. Used for tracking lending market dynamics and calculating time-weighted borrowing costs.

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
0x225886c9beb5eee254f79d58bbd80cf9f200d4d0	false	4546478	2066064768460	1003671484194272064	2023-09-28T06:25:03.000Z	3001440202322	0x5c7d581796572ee524ce63e9c0e164584511170af8e4e44781eee90479595a9a	13654976
0x225886c9beb5eee254f79d58bbd80cf9f200d4d0	false	4575421	2032824905521	1003740130455890503	2023-09-28T22:29:49.000Z	3017369495311	0xfe09dbf0ebbce47528d909110f7409298e781e1165d17d18fbdc50b3074c9d33	1901656
0x225886c9beb5eee254f79d58bbd80cf9f200d4d0	false	4546490	2066364589736	1003671512480934193	2023-09-28T06:25:27.000Z	3001440286912	0xf4b4b736be15a9e0e9d537e9729a771409435434c569234bdc5cd4b350628b42	84590

Example Query

Query with partition filter

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

sobUSDbC_Borrow_event

Borrow event logs from the Sonne Finance sobUSDbC (bridged USDC) lending market on Base. Tracks borrowing activity including borrowed amounts, account-level and protocol-level debt totals for analyzing lending market utilization and borrower behavior.

Columns

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

Sample Data

address	removed	log_index	in_borrower	block_number	block_timestamp	in_borrowAmount	in_totalBorrows	transaction_hash	in_accountBorrows
0x225886c9beb5eee254f79d58bbd80cf9f200d4d0	false	3	0x0edd42c2888d9ecd7fbc11c657354953f33eef67	6090399	2023-11-03T00:09:05.000Z	14000000000	3683063060869	0xdbda5f3aa2c2bc57a53f3627d1fddc4b9f9fc7c837eb0c43074556be98423f37	157257487087
0x225886c9beb5eee254f79d58bbd80cf9f200d4d0	false	3	0x0edd42c2888d9ecd7fbc11c657354953f33eef67	6090538	2023-11-03T00:13:43.000Z	13900000000	3696964708735	0xc00c3c1bbabafca87fb61533692729e39981f9de61c5eb99057d67ed9c0fbc20	171157557446
0x225886c9beb5eee254f79d58bbd80cf9f200d4d0	false	13	0x32e3df7bc12770fd56cf984ecfa50e4892ee00a3	6097764	2023-11-03T04:14:35.000Z	186775553	3696881390715	0xe780897b218aa42cbbfd7501ea9c08b4b32a9c079d72b1c6697071850af6f983	231657395

Example Query

Query with partition filter

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

sobUSDbC_Mint_event

Mint events from the Sonne Finance sobUSDbC (USDbC) lending market on Base, recording when users deposit USDbC and receive soTokens in return. Tracks depositor addresses, underlying asset amounts, and soToken amounts minted for analyzing lending market activity and collateral positions.

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
0x225886c9beb5eee254f79d58bbd80cf9f200d4d0	false	0x1bb216120e8f939f520c610bdc3c88adac4b06f7	15	6462737	141173	701353331	2023-11-11T15:00:21.000Z	0x38bd62de0931fb273b89329a12e47718294ab2d495fc5298ac5c6abef081427d
0x225886c9beb5eee254f79d58bbd80cf9f200d4d0	false	0x1fdd6ff2d4611f0a18ff9c7586176b1b914e386f	28	6478911	130745150	649512312025	2023-11-11T23:59:29.000Z	0x7345e49673aa42710b419bb4db9e4e01b90b15d79a90ae5ed420279ce66b6731
0x225886c9beb5eee254f79d58bbd80cf9f200d4d0	false	0x4e9aad8ec54d61ae1c8af3eab8adfa953db3ab2e	5	6451009	3697600096	18370595003670	2023-11-11T08:29:25.000Z	0x300567266671f36642ec49cfdb45c543e8938621e2d79913d111a691aea643d9

Example Query

Query with partition filter

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

sobUSDbC_NewReserveFactor_event

Reserve factor parameter changes for the Sonne Finance sobUSDbC market on Base. Tracks adjustments to the protocol’s fee structure, with mantissa values representing the percentage of interest allocated to reserves (e.g., 100000000000000000 = 10%).

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
0x225886c9beb5eee254f79d58bbd80cf9f200d4d0	false	3	3307981	2023-08-30T14:21:49.000Z	0x33529c12e9e5148751943b658476f429ce3a86a5f0b808fe0ebdcd4a3ce3dbf1	130000000000000000	100000000000000000
0x225886c9beb5eee254f79d58bbd80cf9f200d4d0	false	43	2494521	2023-08-11T18:26:29.000Z	0xcc64030a85275746341e782ada55f82b7d5c2a8b9e565ce16a3a31ba968a72d5	100000000000000000	0

Example Query

Query with partition filter

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

sobUSDbC_Redeem_event

Redemption events from Sonne Finance’s soUSDBC (bridged USDC) lending market on Base, recording when users withdraw underlying USDC by burning soUSDBC tokens. Tracks redeemer addresses, underlying amounts withdrawn, and soToken amounts burned for analyzing supply-side lending market activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_redeemer`	`STRING`	Address of the account that initiated the redemption transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_redeemAmount`	`STRING`	Amount of underlying asset tokens withdrawn from the lending pool during redemption.
`in_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
0x225886c9beb5eee254f79d58bbd80cf9f200d4d0	false	4	0x0edd42c2888d9ecd7fbc11c657354953f33eef67	5834095	2023-10-28T01:45:37.000Z	7323000000	36438174325948	0x77c7f119ad12cd61c61ee2dd7f04ef982dd3a9292e9fe0399da6cb0c23ccc14e
0x225886c9beb5eee254f79d58bbd80cf9f200d4d0	false	5	0x0edd42c2888d9ecd7fbc11c657354953f33eef67	5866375	2023-10-28T19:41:37.000Z	13000000000	64680167835221	0xa9080d053317b21de1c3fdaef335c3efef741f1fead24dd057021e290be5b81b
0x225886c9beb5eee254f79d58bbd80cf9f200d4d0	false	6	0x0edd42c2888d9ecd7fbc11c657354953f33eef67	5866346	2023-10-28T19:40:39.000Z	11000000000	54729376421497	0xf19f9c0fe7af742c3bff4fe176b8d5da8e5724c9b882164b24a8c065e5477f37

Example Query

Query with partition filter

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

sobUSDbC_RepayBorrow_event

Borrow repayment events from Sonne Finance’s USD Base Coin (USDbC) lending market on Base. Tracks individual loan repayments with amount, borrower/payer addresses, and updated total borrow balances for analyzing repayment activity and debt positions.

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
0x225886c9beb5eee254f79d58bbd80cf9f200d4d0	false	0x9516dfea7bcf5dc1bad2e2e2c84f5094408a92a9	14	0x9516dfea7bcf5dc1bad2e2e2c84f5094408a92a9	8030868	4688145	2023-12-17T22:11:23.000Z	1672735907981	0xf1b59b9f39d33fa68215578d27807194dcdeb73fd8d336851b9d1bd57e89afd6	0
0x225886c9beb5eee254f79d58bbd80cf9f200d4d0	false	0x9cbf099ff424979439dfba03f00b5961784c06ce	7	0x9cbf099ff424979439dfba03f00b5961784c06ce	8019509	142210355254	2023-12-17T15:52:45.000Z	1641296658905	0xd5a843988533b07ab394944e267d712458e756891685136a21998e026621645b	0
0x225886c9beb5eee254f79d58bbd80cf9f200d4d0	false	0x9cbf099ff424979439dfba03f00b5961784c06ce	3	0x9cbf099ff424979439dfba03f00b5961784c06ce	7999298	20000000000	2023-12-17T04:39:03.000Z	1750700873157	0x1c1d9fa2c6b0d52ddfde0e35c782771456ab6982d0b094f7053810ee192aeb83	142189530326

Example Query

Query with partition filter

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

sobUSDC_AccrueInterest_event

Interest accrual events from Sonne Finance’s USDC lending market (sobUSDC) on Base, capturing cash reserves, borrow index updates, total borrows, and accumulated interest per block. Used for tracking lending pool health, interest rate calculations, and borrower cost 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_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
0xfd68f92b45b633bbe0f475294c1a86aecd62985a	false	4711463	979149457356	1002456284648536352	2023-10-02T02:04:33.000Z	3797338090864	0x1b97b04fd18746e4a831b51202780bd34407a32b934f9649f4ceba5c1677bd0d	3363102
0xfd68f92b45b633bbe0f475294c1a86aecd62985a	false	4711182	980399457356	1002455396825747795	2023-10-02T01:55:11.000Z	3796084727762	0xbae92a05a9373b654801e9d7fe782489ff8cf0171fc939c414a4fe48119aa6c8	12749792
0xfd68f92b45b633bbe0f475294c1a86aecd62985a	false	4717025	981014043342	1002473867786079912	2023-10-02T05:09:57.000Z	3920605004345	0x7acf9b7f6ec3a87fe0f870db33bab21499a4b72969cbe344d1c69eae2f1c1ec1	9238439

Example Query

Query with partition filter

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

sobUSDC_Borrow_event

Borrow event logs from Sonne Finance’s soUSDC market (Compound V2 fork) on Base, tracking USDC borrowing activity with borrower addresses, borrowed amounts, and running totals. Used for analyzing lending protocol utilization and individual borrower behavior.

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
0xfd68f92b45b633bbe0f475294c1a86aecd62985a	false	22	0xc204c2567732c87035ccd27b1f673dc9fc41d5e7	4088401	2023-09-17T15:55:49.000Z	857471669	1057473520	0x2da0256f815983976b4980b8394a3a87a86710e1ca9337db7f490f7e41ebbf35	857471669
0xfd68f92b45b633bbe0f475294c1a86aecd62985a	false	14	0xb4a3c2debfc033ee3399ad6adf0b4fc74db92baa	4068317	2023-09-17T04:46:21.000Z	801000000	1001001090	0x0810d4fc3bfaa0515d354a57052cbbeee9d2e4f737b2dbaf873ecd50a91f72a2	801000000
0xfd68f92b45b633bbe0f475294c1a86aecd62985a	false	33	0x29dc80bcd28e91c9f4ce4c24a8cb42333641818c	4093936	2023-09-17T19:00:19.000Z	50000000	250002103	0x4fa728d7d72f7df83bf447416b4776881370b7a09e017679c5a5459f5742e9c0	50000000

Example Query

Query with partition filter

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

sobUSDC_Mint_event

Mint events for the soUSDC token (Sonne Finance’s interest-bearing USDC) on Base, recording deposits where users supply USDC to receive soUSDC tokens. Useful for tracking lending protocol supply activity and calculating total value locked growth.

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
0xfd68f92b45b633bbe0f475294c1a86aecd62985a	false	0x18f580129709d1d84ad25de2436467246ca9875c	16	9559071	948912	4657267902	2024-01-22T07:11:29.000Z	0x9662d19492f3d4cc6ca2655e40b6700822592dcb461253da1fba9f06d0ddf359
0xfd68f92b45b633bbe0f475294c1a86aecd62985a	false	0x2820cdea9d8a42043f6382565b91f3621434e111	8	9571525	348590937	1710836058466	2024-01-22T14:06:37.000Z	0x3956e224e5444e6e6455579d3072f6a7550065a325d2715c8bac074d5266c24c
0xfd68f92b45b633bbe0f475294c1a86aecd62985a	false	0x2820cdea9d8a42043f6382565b91f3621434e111	21	9571461	414249480	2033079412754	2024-01-22T14:04:29.000Z	0x4d1fb591db289136f8067d6593a42b369ca7adf96e740ac263044d88249ce323

Example Query

Query with partition filter

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

sobUSDC_NewReserveFactor_event

Reserve factor parameter changes for Sonne Finance’s sobUSDC lending market on Base. Tracks protocol fee adjustments where reserve factor determines the percentage of interest allocated to protocol reserves versus lenders.

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactorMantissa	in_oldReserveFactorMantissa
0xfd68f92b45b633bbe0f475294c1a86aecd62985a	false	14	3996592	2023-09-15T12:55:31.000Z	0xfae99e83b6ccee15c8af2397dd61f7a2f47885cb7133883186e5440292381716	130000000000000000	0

Example Query

Query with partition filter

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

sobUSDC_Redeem_event

Redemption events from Sonne Finance’s soUSDC lending market on Base, recording when users withdraw USDC by burning soUSDC tokens. Tracks the redeemer address, underlying USDC amount redeemed, and soUSDC tokens burned for analyzing lending market withdrawals 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
0xfd68f92b45b633bbe0f475294c1a86aecd62985a	false	7	0x0edd42c2888d9ecd7fbc11c657354953f33eef67	4412872	2023-09-25T04:11:31.000Z	1200000000	5993957404032	0x16a41ed3421de5b51d441ec8480e089dadfd74c9dc8fc0fec5fa877e5e67481a
0xfd68f92b45b633bbe0f475294c1a86aecd62985a	false	8	0x11bcb66a295aeba152666e511ae052609bda0a84	4411179	2023-09-25T03:15:05.000Z	1004693779	5018435181298	0x783d80a70aa7fdeb2e68328912cebffe807a637a82bf93fa399ea47eb65898cf
0xfd68f92b45b633bbe0f475294c1a86aecd62985a	false	8	0x177a6a32d73372911f772d050368a4512e021998	4441372	2023-09-25T20:01:31.000Z	9000000	44951492443	0xfb4ccf1159f3269380fc5519eb672833c023191d5184ba5e00d86384d9190963

Example Query

Query with partition filter

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

sobUSDC_RepayBorrow_event

Borrow repayment events from Sonne Finance’s oUSDC lending market on Base. Tracks debt repayments with payer/borrower addresses, repayment amounts, and updated account/protocol-level 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
0xfd68f92b45b633bbe0f475294c1a86aecd62985a	false	0x52c75f75362d334cff94904517be6642afdbeb61	5	0x52c75f75362d334cff94904517be6642afdbeb61	9768795	336008561	2024-01-27T03:42:17.000Z	2732211072991	0x91e098dc2a0392cdbd170acab25c777bbd54cc3b71b2632e7996633da0a53739	0
0xfd68f92b45b633bbe0f475294c1a86aecd62985a	false	0x846a48e08ccce0a3ac7358ca80bf5b1a3c143eee	20	0x846a48e08ccce0a3ac7358ca80bf5b1a3c143eee	9800663	61415740	2024-01-27T21:24:33.000Z	2732541855504	0x282c5f011f83380d56729410375fe39a9605b8e8689c94431ad043e4757f7f30	0
0xfd68f92b45b633bbe0f475294c1a86aecd62985a	false	0x55e3fa39c80356a11f124adaf9d26a49e08801df	25	0x55e3fa39c80356a11f124adaf9d26a49e08801df	9782605	132269540	2024-01-27T11:22:37.000Z	2732354415648	0xdf020cc6bf259a2e990379b0dba09f149c8b3f93270cdb62c9bd078ce084fb97	15

Example Query

Query with partition filter

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

sobWETH_AccrueInterest_event

Interest accrual events from Sonne Finance’s Wrapped Ether (WETH) lending market on Base, tracking accumulated interest, borrow index updates, cash reserves, and total borrowed amounts. Used for analyzing lending protocol interest rate dynamics 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	log_index	block_number	in_cashPrior	in_borrowIndex	block_timestamp	in_totalBorrows	transaction_hash	in_interestAccumulated
0x5f5c479fe590cd4442a05ae4a941dd991a633b8e	false	0	4016136	1141325481189973419279	1008357717898564767	2023-09-15T23:46:59.000Z	1057728808147486783319	0xd60186e2fc36277ce170ef8cad4198d9f03d2ba7fe7e09b2972ad1b248c2f2cd	2615466120886525
0x5f5c479fe590cd4442a05ae4a941dd991a633b8e	false	0	3997683	1147344307640060067071	1008174536762294228	2023-09-15T13:31:53.000Z	1062536657378211618718	0x6410862aa706853b0c0f255527a9529a6f1b5901ca73af89634bd954259d4f04	230208350895239
0x5f5c479fe590cd4442a05ae4a941dd991a633b8e	false	2	3997698	1142344307640060067071	1008174685986445900	2023-09-15T13:32:23.000Z	1062536814648729308879	0x0777d4fd7010b13ee92f4b68819da967f39da0c7e329fbb11681ff00cc5d2159	157270517690161

Example Query

Query with partition filter

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

sobWETH_Borrow_event

Borrow events from Sonne Finance’s Wrapped Ether (WETH) lending market on Base, tracking individual borrow transactions with amounts, borrower addresses, and running account/total borrow balances. Used for analyzing lending activity, borrower behavior, and WETH liquidity utilization in the 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
0x5f5c479fe590cd4442a05ae4a941dd991a633b8e	false	16	0x02e7b714fae84e4ba80f3cda5508553e7cf5042a	6024102	2023-11-01T11:19:11.000Z	23671953645925980	534292104880637637885	0xe128ed0b6b41c293c7271c3c4413d71e1f305ee5a9591863abf1423f28a7e250	390797338911607768
0x5f5c479fe590cd4442a05ae4a941dd991a633b8e	false	162	0x02e7b714fae84e4ba80f3cda5508553e7cf5042a	6024498	2023-11-01T11:32:23.000Z	5900000000000000	534299211704178245007	0x8ff82357274d17760b6f3440acb75c2e5c42eb33742a18ae82ab786c483c29b3	396698221618696075
0x5f5c479fe590cd4442a05ae4a941dd991a633b8e	false	24	0x4b26b230c8492f1ec73564cdd7f771c69d279827	6044521	2023-11-01T22:39:49.000Z	30000000000000000	535655890543706377568	0x7acce27462b0fa100f3aaebcc17890e2bb0390090b59e1ea67cde08e1e434325	30000000000000000

Example Query

Query with partition filter

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

sobWETH_Mint_event

Mint events for the Sonne Finance soWETH lending market token on Base, tracking deposits where users supply WETH collateral and receive soWETH (Sonne interest-bearing tokens). Includes underlying WETH amounts and minted soToken quantities for analyzing lending protocol supply 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
0x5f5c479fe590cd4442a05ae4a941dd991a633b8e	false	0x12459450097d43560379514b5cb2341443bf9f0a	25	8827485	5250000500000000000	25946236693	2024-01-05T08:45:17.000Z	0x6e8b19b02a42b713179751d99064908854eab0052252fb0b5c7858f54e4aa339
0x5f5c479fe590cd4442a05ae4a941dd991a633b8e	false	0x3c57cb6c743b190cec13cd804afd753531b94ea8	38	8833923	10000000000000000000	49420897839	2024-01-05T12:19:53.000Z	0x64b4a29a50f4985cbe811990b96d1ffd03c97ffc9204f3a4dba74e69072b4162
0x5f5c479fe590cd4442a05ae4a941dd991a633b8e	false	0x3c57cb6c743b190cec13cd804afd753531b94ea8	42	8834961	10016005571271983104	49499918715	2024-01-05T12:54:29.000Z	0xaa3e291c8d7b98ea957531c701d8f516d678581f761f732b79098e511389895b

Example Query

Query with partition filter

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

sobWETH_NewReserveFactor_event

Reserve factor parameter changes for the Sonne Finance WETH lending market on Base. Tracks adjustments to the protocol’s reserve allocation percentage (expressed in mantissa format with 18 decimals) used for analyzing protocol revenue parameters 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
0x5f5c479fe590cd4442a05ae4a941dd991a633b8e	false	16	2494525	2023-08-11T18:26:37.000Z	0x613afe3939e57d1331984f3bd0722802cf6f731a547705a157f410cdf33559bb	150000000000000000	0

Example Query

Query with partition filter

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

sobWETH_Redeem_event

Redemption events from the Sonne Finance sobWETH (soToken Wrapped ETH) lending market on Base, tracking when users withdraw underlying WETH by burning soTokens. Records the redeemer address, amount of underlying assets withdrawn, and corresponding soTokens burned for analyzing lending market utilization.

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
0x5f5c479fe590cd4442a05ae4a941dd991a633b8e	false	15	0x79dfa71ad7987b17ee0f0105f3dfed0c2d3f6a2b	2866847	2023-08-20T09:17:21.000Z	1999999805541020	9999999	0x7a2f24eb93c85c3d3a46809fa426b01b3e1010837c987b2151f0896c92b13c25
0x5f5c479fe590cd4442a05ae4a941dd991a633b8e	false	4	0x347d5a58aa5c2d3790fde1b4732a45fb7ff50c5d	4711747	2023-10-02T02:14:01.000Z	1250001440431652701	6220141676	0x6c9ef56d2897c47a781e1dea1a7a009cdb0653c2a318b6f944f45231d39346f4
0x5f5c479fe590cd4442a05ae4a941dd991a633b8e	false	4	0xbe026ae67432efa9ad85b897a70e0bab0dcb1cea	4713266	2023-10-02T03:04:39.000Z	220000000000000000	1094740407	0xe7b9c9039369b5b9dc9809bf2fd8d32bcae8da5e87276255df41c19cb2a92d9d

Example Query

Query with partition filter

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

sobWETH_RepayBorrow_event

Wrapped Ether (WETH) loan repayment events from Sonne Finance’s lending protocol on Base. Tracks borrower repayments with amount, updated borrow balances, and protocol-wide debt positions for analyzing leverage 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
0x5f5c479fe590cd4442a05ae4a941dd991a633b8e	false	0x74b3bb13ee674428795877742148c97124ee7358	7	0x74b3bb13ee674428795877742148c97124ee7358	6862729	3465730323912432586	2023-11-20T21:13:25.000Z	408221076540957764175	0x79e69599f4dec43b34f0e19616181377d358b9d17feef0bfc1c5af706199be4a	22223512658310035246
0x5f5c479fe590cd4442a05ae4a941dd991a633b8e	false	0xc2de99748f2f95297dcca77446a0c05f5d6fcdf2	54	0xc2de99748f2f95297dcca77446a0c05f5d6fcdf2	6851920	56614789304291640	2023-11-20T15:13:07.000Z	411658575574783521051	0x7786e6cb5cda2e0d88eaa05484221065c7f159eef973ce632d34e7ae564d3782	101354267236625087510
0x5f5c479fe590cd4442a05ae4a941dd991a633b8e	false	0xc2de99748f2f95297dcca77446a0c05f5d6fcdf2	88	0xc2de99748f2f95297dcca77446a0c05f5d6fcdf2	6851919	4114505942581129468	2023-11-20T15:13:05.000Z	411715187769896898545	0xcf75ac62581b52cb3aa324600cccee2130e6fde678423a697e9e7631dc740af3	101410881386945938921

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Comptroller_DistributedBorrowerComp_event

Comptroller_DistributedSupplierComp_event

sobcbETH_AccrueInterest_event

sobcbETH_Borrow_event

sobcbETH_Mint_event

sobcbETH_NewReserveFactor_event

sobcbETH_Redeem_event

sobcbETH_RepayBorrow_event

sobDAI_AccrueInterest_event

sobDAI_Borrow_event

sobDAI_Mint_event

sobDAI_NewReserveFactor_event

sobDAI_Redeem_event

sobDAI_RepayBorrow_event

sobUSDbC_AccrueInterest_event

sobUSDbC_Borrow_event

sobUSDbC_Mint_event

sobUSDbC_NewReserveFactor_event

sobUSDbC_Redeem_event

sobUSDbC_RepayBorrow_event

sobUSDC_AccrueInterest_event

sobUSDC_Borrow_event

sobUSDC_Mint_event

sobUSDC_NewReserveFactor_event

sobUSDC_Redeem_event

sobUSDC_RepayBorrow_event

sobWETH_AccrueInterest_event

sobWETH_Borrow_event

sobWETH_Mint_event

sobWETH_NewReserveFactor_event

sobWETH_Redeem_event

sobWETH_RepayBorrow_event

​Tables

​Comptroller_DistributedBorrowerComp_event

​Comptroller_DistributedSupplierComp_event

​sobcbETH_AccrueInterest_event

​sobcbETH_Borrow_event

​sobcbETH_Mint_event

​sobcbETH_NewReserveFactor_event

​sobcbETH_Redeem_event

​sobcbETH_RepayBorrow_event

​sobDAI_AccrueInterest_event

​sobDAI_Borrow_event

​sobDAI_Mint_event

​sobDAI_NewReserveFactor_event

​sobDAI_Redeem_event

​sobDAI_RepayBorrow_event

​sobUSDbC_AccrueInterest_event

​sobUSDbC_Borrow_event

​sobUSDbC_Mint_event

​sobUSDbC_NewReserveFactor_event

​sobUSDbC_Redeem_event

​sobUSDbC_RepayBorrow_event

​sobUSDC_AccrueInterest_event

​sobUSDC_Borrow_event

​sobUSDC_Mint_event

​sobUSDC_NewReserveFactor_event

​sobUSDC_Redeem_event

​sobUSDC_RepayBorrow_event

​sobWETH_AccrueInterest_event

​sobWETH_Borrow_event

​sobWETH_Mint_event

​sobWETH_NewReserveFactor_event

​sobWETH_Redeem_event

​sobWETH_RepayBorrow_event

Tables

Comptroller_DistributedBorrowerComp_event

Comptroller_DistributedSupplierComp_event

sobcbETH_AccrueInterest_event

sobcbETH_Borrow_event

sobcbETH_Mint_event

sobcbETH_NewReserveFactor_event

sobcbETH_Redeem_event

sobcbETH_RepayBorrow_event

sobDAI_AccrueInterest_event

sobDAI_Borrow_event

sobDAI_Mint_event

sobDAI_NewReserveFactor_event

sobDAI_Redeem_event

sobDAI_RepayBorrow_event

sobUSDbC_AccrueInterest_event

sobUSDbC_Borrow_event

sobUSDbC_Mint_event

sobUSDbC_NewReserveFactor_event

sobUSDbC_Redeem_event

sobUSDbC_RepayBorrow_event

sobUSDC_AccrueInterest_event

sobUSDC_Borrow_event

sobUSDC_Mint_event

sobUSDC_NewReserveFactor_event

sobUSDC_Redeem_event

sobUSDC_RepayBorrow_event

sobWETH_AccrueInterest_event

sobWETH_Borrow_event

sobWETH_Mint_event

sobWETH_NewReserveFactor_event

sobWETH_Redeem_event

sobWETH_RepayBorrow_event