sonne_v1_optimism - Token Terminal Docs

Tables

Comptroller_DistributedBorrowerComp_event

SONNE token reward distribution events for borrowers in the Sonne Finance lending protocol on Optimism. Tracks accrued governance token amounts paid to borrowers per cToken market with corresponding borrow index snapshots for calculating APY and total borrower incentives.

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 SONNE token distribution to borrowers for this specific cToken market. Large integer value increases over time as borrowing rewards accrue, used to calculate individual borrower reward entitlements.

Sample Data

address	removed	in_cToken	log_index	in_borrower	block_number	in_compDelta	block_timestamp	transaction_hash	in_compBorrowIndex
0x60cf091cd3f50420d50fd7f707414d0df4751c58	false	0x8cd6b19a07d754bf36adeee79edf4f2134a8f571	11	0x0296b27c2041d55c7220b05aa2079ef1e8e3b60a	88878749	169681498061166805573	2023-04-11T06:00:15.000Z	0x5a743c4a115a3b6f121f5e92b1fb2602948dbd0ce1b319a952fe452a828e55db	18334649662359215229175561528378123901
0x60cf091cd3f50420d50fd7f707414d0df4751c58	false	0xec8fea79026ffed168ccf5c627c7f486d77b765f	9	0x0296b27c2041d55c7220b05aa2079ef1e8e3b60a	88878749	0	2023-04-11T06:00:15.000Z	0x5a743c4a115a3b6f121f5e92b1fb2602948dbd0ce1b319a952fe452a828e55db	104629655175851070175729281869905512135016295847151
0x60cf091cd3f50420d50fd7f707414d0df4751c58	false	0x8cd6b19a07d754bf36adeee79edf4f2134a8f571	90	0x0296b27c2041d55c7220b05aa2079ef1e8e3b60a	88808698	141895827083109065865	2023-04-11T02:15:38.000Z	0xea5f8506c43c45e6ee6180a009d02966d40d880a7f75d2344602fae43b6940ec	18334275900222825813025855238553954019

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sonne_v1_optimism.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 in the Sonne Finance lending protocol on Optimism. Tracks governance token accruals per cToken market with delta amounts and supply index values for calculating liquidity mining incentives.

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`	Global supply index tracking accumulated SONNE rewards per unit of supplied capital for the cToken market. Stored as a high-precision integer representing the cumulative reward distribution rate since market inception.

Sample Data

address	removed	in_cToken	log_index	in_supplier	block_number	in_compDelta	block_timestamp	transaction_hash	in_compSupplyIndex
0x60cf091cd3f50420d50fd7f707414d0df4751c58	false	0x5569b83de187375d43fbd747598bfe64fc8f6436	2	0x03e8686efe195f036845498aeb2125c626ad949b	116694480	1173236300466201459	2024-02-26T22:48:57.000Z	0x1dd60537bdcb4b00b7c62276a7398991243c06f63cba59de85ee4b9da8dba16d	16775980435170414097998176803292773766201102215
0x60cf091cd3f50420d50fd7f707414d0df4751c58	false	0x5569b83de187375d43fbd747598bfe64fc8f6436	28	0x03e8686efe195f036845498aeb2125c626ad949b	116694480	0	2024-02-26T22:48:57.000Z	0x1dd60537bdcb4b00b7c62276a7398991243c06f63cba59de85ee4b9da8dba16d	16775980435170414097998176803292773766201102215
0x60cf091cd3f50420d50fd7f707414d0df4751c58	false	0x5569b83de187375d43fbd747598bfe64fc8f6436	36	0x03e8686efe195f036845498aeb2125c626ad949b	116694480	0	2024-02-26T22:48:57.000Z	0x1dd60537bdcb4b00b7c62276a7398991243c06f63cba59de85ee4b9da8dba16d	16775980435170414097998176803292773766201102215

Example Query

Query with partition filter

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

soDAI_AccrueInterest_event

Interest accrual events from Sonne Finance’s soDAI lending market on Optimism, recording borrow index updates, total borrows, and accumulated interest. Used for calculating lending rates, tracking protocol revenue, and analyzing DAI 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
0x5569b83de187375d43fbd747598bfe64fc8f6436	false	2	110085006	1949514161995482849808310	1057079815455630099	2023-09-26T22:53:09.000Z	8575860540906048951306262	0xd3184dc76248dad6056d69d1cb174b707eed994bb3e842ed0681e0d37788e57d	209604272274639667613
0x5569b83de187375d43fbd747598bfe64fc8f6436	false	7	110069111	1949236656086846381938093	1057004633132160877	2023-09-26T14:03:19.000Z	8575250602931842677921830	0x6960e3b80c917b3239471bf003c4c983e4648989edc62dbc3d3186fbc2e2c8f9	127110212062920807853
0x5569b83de187375d43fbd747598bfe64fc8f6436	false	11	110065799	1949226656086846381938093	1056988965242172568	2023-09-26T12:12:55.000Z	8575123492719779757113977	0x0c7194fd91b1f9e40c4875f32a881d99a56e0635b19102845fa80a36ebd7984b	78903987494252897451

Example Query

Query with partition filter

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

soDAI_Borrow_event

Borrow events from Sonne Finance’s DAI lending market (soDAI) on Optimism, capturing when users take out DAI loans with individual borrow amounts, cumulative account borrows, and protocol-wide total borrows. Used for analyzing borrowing behavior, debt positions, and DAI utilization on the Sonne 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
0x5569b83de187375d43fbd747598bfe64fc8f6436	false	48	0xf989cc97b3976465fc518a12163a89960735c45f	106528726	2023-07-06T15:10:29.000Z	2500000000000000000000	17412902348417390501321436	0xe20d60a41e7e26fef29df110d4087a516f31d8f79c124a6d7b5cd9facbb12fa7	10001988866575607518360
0x5569b83de187375d43fbd747598bfe64fc8f6436	false	97	0x3be2e55cefa413aff52adc2e94892fd1478d41bb	106518445	2023-07-06T09:27:47.000Z	1430000000000000000000	17409841331869864658364410	0xd923b88c3a8242679e3eff489160ca808034ed349eb65d9f0d40f95dfadbbdfe	11738789268657671866064
0x5569b83de187375d43fbd747598bfe64fc8f6436	false	133	0x79dfa71ad7987b17ee0f0105f3dfed0c2d3f6a2b	112478331	2023-11-21T08:30:39.000Z	10000000000000000000	7510587398683370917007678	0x18023ca98740a7fd9dc7975eb5b015c23fc16cc9f31aa16c914c60866c8c37df	87110917484405903012

Example Query

Query with partition filter

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

soDAI_Mint_event

Mint events for soDAI (Sonne DAI) interest-bearing tokens on Optimism, recording when users deposit DAI to receive soDAI. Used to track supply changes and depositor activity in the Sonne Finance 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_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
0x5569b83de187375d43fbd747598bfe64fc8f6436	false	0x03e8686efe195f036845498aeb2125c626ad949b	78	108491965	16613021533706182607068	80240523785672	2023-08-21T01:51:47.000Z	0x1c78cb5f6548f1aaf270430ac705907b440b9d38891fa71cd75ffb045e72092c
0x5569b83de187375d43fbd747598bfe64fc8f6436	false	0x03e8686efe195f036845498aeb2125c626ad949b	54	108491965	22788781253369408932199	110069305604489	2023-08-21T01:51:47.000Z	0x1c78cb5f6548f1aaf270430ac705907b440b9d38891fa71cd75ffb045e72092c
0x5569b83de187375d43fbd747598bfe64fc8f6436	false	0x03e8686efe195f036845498aeb2125c626ad949b	46	108491965	18289679777464966294460	88338745738603	2023-08-21T01:51:47.000Z	0x1c78cb5f6548f1aaf270430ac705907b440b9d38891fa71cd75ffb045e72092c

Example Query

Query with partition filter

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

soDAI_NewReserveFactor_event

Reserve factor change events for the soDAI lending market on Sonne Finance (Optimism), tracking adjustments to the protocol’s fee allocation percentage. Used for monitoring governance decisions and protocol revenue distribution 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
0x5569b83de187375d43fbd747598bfe64fc8f6436	false	1	26050873	2022-09-28T16:28:29.000Z	0xc96076582b3ac9b1ff69d9dd50c20d0f56d27bab35dca25e0a243f5fb660dc6a	100000000000000000	0

Example Query

Query with partition filter

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

soDAI_Redeem_event

Redeem event logs from Sonne Finance’s soDAI lending market on Optimism, recording withdrawals of underlying DAI tokens in exchange for soDAI interest-bearing tokens. Useful for tracking lending protocol outflows, yield redemptions, and soDAI 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_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
0x5569b83de187375d43fbd747598bfe64fc8f6436	false	96	0x071a922d81d604617ad5276479146bf9d7105efc	30185806	2022-10-19T07:14:54.000Z	10271287004399640001900	51271729652508	0x383956ef0f1fa14ec64e4aa13a0399bf473d761bf70cda1e6067a469cf8e061c
0x5569b83de187375d43fbd747598bfe64fc8f6436	false	5	0x071a922d81d604617ad5276479146bf9d7105efc	30156283	2022-10-19T02:30:47.000Z	40000000000000003872497	199673288939403	0xd03465e59f1e1591b025d8f21835d3c7e9790e1443a303e4281434e76ce865d9
0x5569b83de187375d43fbd747598bfe64fc8f6436	false	5	0x071a922d81d604617ad5276479146bf9d7105efc	30306503	2022-10-19T23:03:13.000Z	1016557846607590875795	5074138559598	0x47af1a94d7584fd6474ad56d9402558326bd5150f5ca8fef5146642a8b0fee4b

Example Query

Query with partition filter

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

soDAI_RepayBorrow_event

Borrow repayment events for the soDAI market on Sonne Finance (Compound v2 fork) on Optimism, tracking DAI debt repayments with updated borrower balances and protocol-wide borrow totals. Used for analyzing lending market activity, debt management patterns, and protocol solvency 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_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
0x5569b83de187375d43fbd747598bfe64fc8f6436	false	0x55b533f484e9aebdc30460b59f1e3ffce06d7942	29	0x55b533f484e9aebdc30460b59f1e3ffce06d7942	110507172	118000000000000000000	2023-10-06T17:25:21.000Z	8641523855603841076946488	0xcb7a4cf5c403e36449dc19d3636eff8cbf06039115c79b3850b03810d9225847	30000280379339102392924
0x5569b83de187375d43fbd747598bfe64fc8f6436	false	0x03e8686efe195f036845498aeb2125c626ad949b	8	0x03e8686efe195f036845498aeb2125c626ad949b	110513977	79933365747096595572201	2023-10-06T21:12:11.000Z	8562556825084623448475181	0x5b784a426c53215b6dd8b7a2e75cdd2acd8eb1804c2d15165de39e0dca8debce	2005210578953853588932689
0x5569b83de187375d43fbd747598bfe64fc8f6436	false	0x03e8686efe195f036845498aeb2125c626ad949b	16	0x03e8686efe195f036845498aeb2125c626ad949b	110513977	88805969345024360350968	2023-10-06T21:12:11.000Z	8473750855739599088124213	0x5b784a426c53215b6dd8b7a2e75cdd2acd8eb1804c2d15165de39e0dca8debce	1916404609608829228581721

Example Query

Query with partition filter

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

soLUSD_AccrueInterest_event

Interest accrual events from Sonne Finance’s LUSD (Liquidity USD) lending market on Optimism, recording periodic updates to borrow index, total borrows, and accumulated interest. Used for tracking lending protocol interest calculations and market health 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_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
0xafdf91f120dec93c65fd63dbd5ec372e5dca5f82	false	4	107394375	354719011083597321017600	1043036280597707106	2023-07-26T16:05:27.000Z	1897974480486185212018195	0xe32ade919bd3600544b79dfa70584f8e05097a12143ed00400e886e05ebfdf97	18128425840380398186
0xafdf91f120dec93c65fd63dbd5ec372e5dca5f82	false	4	107365732	379368687510843978297396	1042852439301522951	2023-07-26T00:10:41.000Z	1882216524053368163994627	0xf3a587c2121df49eff55c771a0264de481cefbc389fcee5c722c0ca02a3dd4ba	666193182156294516
0xafdf91f120dec93c65fd63dbd5ec372e5dca5f82	false	19	107391218	373405814684568297520316	1043013686535080239	2023-07-26T14:20:13.000Z	1881408562395785894241509	0xeee3a4f0760d9e032b531c9a11ff26b57fb6b85062aec70425282db2bb81c2b4	106666472726353390669

Example Query

Query with partition filter

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

soLUSD_Borrow_event

Borrow events for the soLUSD market on Sonne Finance (Optimism lending protocol), recording each time users borrow LUSD stablecoin with borrower address, amount borrowed, and updated account/total borrow balances. Used to analyze borrowing activity, user leverage patterns, and protocol 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_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
0xafdf91f120dec93c65fd63dbd5ec372e5dca5f82	false	3	0x19fe79ba97b7424dc18b00840803b8cffa7c45a0	75130677	2023-02-18T09:36:47.000Z	115255000000000000000	1715886785723382593009681	0x45aea3480d110a508197c4bcab6ab8d2075d5e3cb9ef05a9bda46682440ef148	524097438700964482119
0xafdf91f120dec93c65fd63dbd5ec372e5dca5f82	false	3	0x19fe79ba97b7424dc18b00840803b8cffa7c45a0	75130077	2023-02-18T09:31:57.000Z	192967986758083240000	1715794128498399114867135	0x92fdd98fad571745e51da8de6a0bc50ffc29a51021016d51ac5953599cb63d86	433502149392054231521
0xafdf91f120dec93c65fd63dbd5ec372e5dca5f82	false	3	0x19fe79ba97b7424dc18b00840803b8cffa7c45a0	75129735	2023-02-18T09:29:12.000Z	300544237720090100000	1715659997316543907807272	0xb2436ad07c525ea516efc8277f3ce5db48c0205879b337b2337c896adff3b9c0	300544237720090100000

Example Query

Query with partition filter

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

soLUSD_Mint_event

Mint events for soLUSD (Sonne Finance LUSD market) on Optimism, recording when users deposit LUSD to receive soLUSD tokens. Tracks minter addresses, underlying LUSD amounts, and soLUSD tokens received for analyzing lending pool deposits and liquidity provision.

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
0xafdf91f120dec93c65fd63dbd5ec372e5dca5f82	false	0x27e1114b125da573309f9a9765b833650b930548	89	114647541	1082070304369962873	5146758529	2024-01-10T13:37:39.000Z	0xf7587c4d2da74823adeb91a3d4a93c4cb1b64c968c17805d2e7fcf29fa47ac48
0xafdf91f120dec93c65fd63dbd5ec372e5dca5f82	false	0x27e1114b125da573309f9a9765b833650b930548	33	114643095	142962601157635928	679999022	2024-01-10T11:09:27.000Z	0x4e524855f31446beb37b007a32dfb20235d5e96a24c74978e89f04e8c4ca7120
0xafdf91f120dec93c65fd63dbd5ec372e5dca5f82	false	0x27e1114b125da573309f9a9765b833650b930548	43	114643095	97868149828468466506	465508081772	2024-01-10T11:09:27.000Z	0x4e524855f31446beb37b007a32dfb20235d5e96a24c74978e89f04e8c4ca7120

Example Query

Query with partition filter

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

soLUSD_NewReserveFactor_event

Reserve factor parameter changes for the Sonne Finance LUSD market on Optimism. Captures governance updates to the protocol’s fee structure, tracking old and new reserve factor values (in mantissa format, 18 decimals) for analyzing protocol economics and treasury accrual 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
0xafdf91f120dec93c65fd63dbd5ec372e5dca5f82	false	2	72208443	2023-02-04T07:01:20.000Z	0xd6a5be337f877e2e1a56e606b2b703e8bf921e3269a4e799350835e8ed0d1819	200000000000000000	0

Example Query

Query with partition filter

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

soLUSD_Redeem_event

Redeem events from the soLUSD (Sonne LUSD) market on Optimism, recording when users withdraw underlying LUSD tokens by burning soLUSD tokens. Tracks redeemer addresses, token amounts withdrawn, and soTokens 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
0xafdf91f120dec93c65fd63dbd5ec372e5dca5f82	false	11	0xd0532fc413868abaa09d429de2388a9f155919d5	107884074	2023-08-07T00:08:45.000Z	16472631302278969295	79927708018	0x0706dad9ca0c6fc9dd69894ad97f04b011be99197035c1c3aa956bcecf6598c6
0xafdf91f120dec93c65fd63dbd5ec372e5dca5f82	false	84	0xd0532fc413868abaa09d429de2388a9f155919d5	107883960	2023-08-07T00:04:57.000Z	143769394434350155639	697591075480	0x8f530bd45cdba461d8a71b1376acff1f763f26474196fd08017c0a04677e81b4
0xafdf91f120dec93c65fd63dbd5ec372e5dca5f82	false	22	0x18d35c6df1c32fe1b6286f57c772f2be9efd9ff0	110142962	2023-09-28T07:05:01.000Z	19649317288142498000525	94899803121163	0x32308ade5fd26abf424ca6a1b157fad2da3af91d164c366507d2366edcc75efc

Example Query

Query with partition filter

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

soLUSD_RepayBorrow_event

Borrow repayment events for the soLUSD (Sonne LUSD) lending market on Optimism, tracking payer and borrower addresses, repayment amounts, and updated borrow balances. Used for analyzing loan repayment patterns, liquidation prevention activity, and borrower debt management in Sonne Finance’s LUSD 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_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
0xafdf91f120dec93c65fd63dbd5ec372e5dca5f82	false	0x0a3234a2f7e0026364a6fa61b286c8b107e2cd3c	51	0x0a3234a2f7e0026364a6fa61b286c8b107e2cd3c	107113246	48020457899843098198	2023-07-20T03:54:29.000Z	1910428841520343128576088	0x1863d5543a7b7d3d3f1e0e3df129f73d2900213b7fbf8828207b549139758de7
0xafdf91f120dec93c65fd63dbd5ec372e5dca5f82	false	0x12924049e2d21664e35387c69429c98e9891a820	50	0x12924049e2d21664e35387c69429c98e9891a820	107113167	56021659849604190291	2023-07-20T03:51:51.000Z	1910532005939484496706906	0x1dafd3933495c52f7d8a2f00995220356de70d7af46d909b3477fb194fe18c4f
0xafdf91f120dec93c65fd63dbd5ec372e5dca5f82	false	0x29128e764a3959204bcab02b315ae22e7d1d7bba	109	0x29128e764a3959204bcab02b315ae22e7d1d7bba	107113208	56021661109663337285	2023-07-20T03:53:13.000Z	1910476439726543131687260	0x5e0f1b13bad069bedca42152495bf946807fdbcf81cc6b865dda855f49dc9516

Example Query

Query with partition filter

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

soOP_AccrueInterest_event

Interest accrual events from Sonne Finance’s soOP (Optimism) lending market showing when borrow interest is calculated and added to total borrows. Used for tracking lending pool health metrics and analyzing interest rate accumulation patterns on borrowed assets.

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
0x8cd6b19a07d754bf36adeee79edf4f2134a8f571	false	53030174	417079769734968947887795	1030085064324389260	2022-12-21T14:34:24.000Z	1982243610875542089653170	0x555ec42d94f55ef82cc94ab5e19ba09c3b30cb78f75f642ea07fa7b817122069	1706656172029902230
0x8cd6b19a07d754bf36adeee79edf4f2134a8f571	false	52624834	419631213653100493786307	1029961198298544338	2022-12-21T02:01:05.000Z	1917822055807862549914568	0x795ca745353500350d7955be04dd5dbc904f0001e17354457e3026ee8f6dbf28	357638827394609134
0x8cd6b19a07d754bf36adeee79edf4f2134a8f571	false	52664270	420093817472580253293485	1029973058861719050	2022-12-21T03:13:21.000Z	1969529009861565155616272	0x355902b3a16fbb477d019fbc045496363ed22e3d147c7719da23429f174fe298	1725936106990488312

Example Query

Query with partition filter

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

soOP_Borrow_event

Borrow event logs from Sonne Finance’s soOP (Sonne Optimism) lending market on Optimism, recording each debt position creation or increase with borrower addresses, borrowed amounts, and running totals. Used for tracking borrowing activity, debt accumulation patterns, 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
0x8cd6b19a07d754bf36adeee79edf4f2134a8f571	false	24	0x4d686e47f19f06106802cba5d1c1a9150d8bcf9d	105843816	2023-06-20T18:40:09.000Z	500000000000000000000	2046358614359582774398718	0x0c10cc22e9f7b907c58e144f0afb7a032c05091e22605fd1e89e686f35b776e1	500000000000000000000
0x8cd6b19a07d754bf36adeee79edf4f2134a8f571	false	26	0x505c1010728b7442ef9ff2a23876fe02f05954a1	105833506	2023-06-20T12:56:29.000Z	3939878077073151049628	2906588090332144149282680	0xc25f7f0ec6642df75d60926dff5fad48fd2c41d3b8d4236d2a7b8e7ce4a6bff6	209613417023469706227834
0x8cd6b19a07d754bf36adeee79edf4f2134a8f571	false	18	0x7c930969fcf3e5a5c78bcf2e1cefda3f53e3c8fd	105844635	2023-06-20T19:07:27.000Z	25000000000000000000000	2882889892719754782199899	0xbe5f02b6f1646ec9cda79d0a6082dea69c1df1941dc86a970708e4f8117a6c0d	153177208972126349097573

Example Query

Query with partition filter

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

soOP_Mint_event

Mint events from Sonne Finance’s soOP (Sonne Optimism) lending market on Optimism, recording when users deposit underlying assets to receive soOP tokens in return. Useful for analyzing supply-side liquidity provision and collateral deposits 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_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
0x8cd6b19a07d754bf36adeee79edf4f2134a8f571	false	0x5c70b3f22595caf8314f77dabc628363aaee18ad	3	31561667	386221609600000000000	1920324533553	2022-10-26T04:36:54.000Z	0xeb671ff4c4a6465166a03d65f3e146084e59ca79a4e7066b66d4a32e992f8598
0x8cd6b19a07d754bf36adeee79edf4f2134a8f571	false	0x26f8f1418a8c35c333ad2f473ddc04a3c73c50ab	3	31635468	115000000000000000000	571762112570	2022-10-26T09:55:16.000Z	0x67d6eabf219c24c03e3cfc498c7ee689ae15b70a7a7fa31b816b9c745ae3e137
0x8cd6b19a07d754bf36adeee79edf4f2134a8f571	false	0x5c70b3f22595caf8314f77dabc628363aaee18ad	3	31781560	23760000000187614000000	118119593402939	2022-10-26T21:02:16.000Z	0x8189ce24864702eafcfb34b49740675adf4838b8493e0f9248bfc1583df15839

Example Query

Query with partition filter

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

soOP_NewReserveFactor_event

Reserve factor parameter change events for Sonne Finance’s soOP (Optimism) market on Optimism. Tracks protocol fee adjustments with mantissa-denominated values (18 decimals) for analyzing revenue allocation between lenders and protocol treasury.

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactorMantissa	in_oldReserveFactorMantissa
0x8cd6b19a07d754bf36adeee79edf4f2134a8f571	false	1	26050971	2022-09-28T16:28:44.000Z	0x62bd3128900568cd8e9e3d12a84196cbcf1abee2fda4698b116001dbaebda4e5	200000000000000000	0

Example Query

Query with partition filter

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

soOP_Redeem_event

Redemption events from Sonne Finance’s soOP (Sonne Optimism OP) lending market on Optimism, recording when users withdraw their supplied OP tokens by burning soOP tokens. Tracks redeemer addresses, underlying token amounts withdrawn, and soToken amounts burned for analyzing lending market 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
0x8cd6b19a07d754bf36adeee79edf4f2134a8f571	false	4	0x541dc91d3b6a1a7ca45407a84bfa34fb4ea39530	80187470	2023-03-12T02:02:42.000Z	20000073539790699108565	96107744432578	0xbeb4389bdfb6abc834af5498580c021784fa6b6d478fcf2e7e0e69f6cd822591
0x8cd6b19a07d754bf36adeee79edf4f2134a8f571	false	4	0x541dc91d3b6a1a7ca45407a84bfa34fb4ea39530	80389918	2023-03-12T23:05:25.000Z	20000513549351898392099	96102723134106	0xcafeebba4b17e8758282d75b14329f0d94a381b832d54b5b7fb30cb4c9575afa
0x8cd6b19a07d754bf36adeee79edf4f2134a8f571	false	4	0x86aabcd459587bc1a347ae1e2d15223856354ec9	80323204	2023-03-12T17:10:56.000Z	400000000000000000000	1922043873885	0x6671a145b4a997a898adbb6ed00d162327c7c586ec96cc7a352d4ee7b8cb8173

Example Query

Query with partition filter

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

soOP_RepayBorrow_event

Borrow repayment events from Sonne Finance’s soOP (Sonne Optimism OP token) lending market on Optimism. Tracks individual loan repayments with payer, borrower addresses, repayment amounts, and updated account and total borrow balances for analyzing debt reduction 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
0x8cd6b19a07d754bf36adeee79edf4f2134a8f571	false	0x19232a84442b25892906e24dff91fde494e2fa3a	73	0x19232a84442b25892906e24dff91fde494e2fa3a	109232045	8317576091567768052695	2023-09-07T05:01:07.000Z	1827367961152186387185287	0xa8098bd2f009eb7d93a7aa3c61257975be1db10471f8c4ffc1643526f452db27	96594044899712605363909
0x8cd6b19a07d754bf36adeee79edf4f2134a8f571	false	0x19232a84442b25892906e24dff91fde494e2fa3a	82	0x19232a84442b25892906e24dff91fde494e2fa3a	109232045	12796270910104258542608	2023-09-07T05:01:07.000Z	1814571690242082128642679	0xa8098bd2f009eb7d93a7aa3c61257975be1db10471f8c4ffc1643526f452db27	83797773989608346821301
0x8cd6b19a07d754bf36adeee79edf4f2134a8f571	false	0x19232a84442b25892906e24dff91fde494e2fa3a	91	0x19232a84442b25892906e24dff91fde494e2fa3a	109232045	19686570630929628527089	2023-09-07T05:01:07.000Z	1794885119611152500115590	0xa8098bd2f009eb7d93a7aa3c61257975be1db10471f8c4ffc1643526f452db27	64111203358678718294212

Example Query

Query with partition filter

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

soSNX_AccrueInterest_event

Interest accrual events from the Sonne Finance soSNX (Synthetix) lending market on Optimism, tracking periodic updates to borrow rates, total borrows, and accumulated interest. Used for calculating APY (Annual Percentage Yield), analyzing protocol revenue, and monitoring market health.

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
0xd7daabd899d1fabbc3a9ac162568939cec0393cc	false	66712330	4195893003259308515868	1053607052758683612	2023-01-14T17:49:44.000Z	66641568494775266906684	0x9af7cad2cf7d1193afe41a22a8df830a82fb4feb24aa5c0e023123ea3f790587	60985311311603434
0xd7daabd899d1fabbc3a9ac162568939cec0393cc	false	66543879	436055089161879706725	1052994721446974708	2023-01-14T13:15:55.000Z	68283926180822280528661	0x6a3c835b0ea30155f32bb1b3da95cd6832dac0842e8049a71396456d4d198b50	7568836780054574585
0xd7daabd899d1fabbc3a9ac162568939cec0393cc	false	66350790	43226534171721331792457	1052418124067377953	2023-01-14T08:32:48.000Z	68628293191602673348816	0xfa3fc35f345bf093e5129d5d3897f52c24f6c72d7ababbda7889e730996b5ff3	141988798556717576

Example Query

Query with partition filter

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

soSNX_Borrow_event

Borrow event records from the Sonne Finance soSNX (Synthetix) market on Optimism, tracking loan originations with borrower addresses, borrow amounts, and cumulative debt positions. Used for analyzing borrowing activity, leverage patterns, and account-level debt accumulation in the SNX 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_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
0xd7daabd899d1fabbc3a9ac162568939cec0393cc	false	19	0xfbdd5d203bc991cccc602b54f90d83122f6076b8	112238149	2023-11-15T19:04:35.000Z	15000000000000000000000	180673928839775282194974	0xe87e71fae9a21c157533c1baff7e75305248f2ecd152e9880270fb0fa07a2536	138250662042155006079231
0xd7daabd899d1fabbc3a9ac162568939cec0393cc	false	206	0xfbdd5d203bc991cccc602b54f90d83122f6076b8	112236960	2023-11-15T18:24:57.000Z	25000000000000000000000	165671924857473265525591	0x52dccc811f9e66a707a48ab17dbd0d545436951fe5afbc4945d55bb4392dbfb8	123249171209245000202573
0xd7daabd899d1fabbc3a9ac162568939cec0393cc	false	3	0xed78afd8acba4b56703c4c0ac6cdfa6b7433c1aa	38486858	2022-11-15T17:33:19.000Z	2000000000000000000000	428928484624223951557733	0x3830ea9abd2cf68b7e6e58bef9c4a8707d0c81d5240683c6827395a77df7fefd	35484306357482936921350

Example Query

Query with partition filter

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

soSNX_Mint_event

Mint events from the soSNX (Sonne Finance SNX) lending market on Optimism, recording when users deposit SNX collateral to receive soSNX tokens. Tracks minter addresses, underlying token amounts, and soToken quantities for analyzing lending activity and collateral 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
0xd7daabd899d1fabbc3a9ac162568939cec0393cc	false	0x4f517f2d959478cf4a4cf68c5db2be4c5cf8bdd0	3	79949755	20223295392286570000000	96435159520417	2023-03-11T01:11:09.000Z	0x48b5359d9af9bdfb643513a293497f4a99c19250375439053f3968bd53055a5f
0xd7daabd899d1fabbc3a9ac162568939cec0393cc	false	0x6718e9ca1376fe54e9493bfca0188cd08c396db4	3	79946482	34663425960990290000	165293701222	2023-03-11T00:54:51.000Z	0x6d9b9515828728de565aab2d96637e1da8da74541df8b59a2860fcf11bd01620
0xd7daabd899d1fabbc3a9ac162568939cec0393cc	false	0x8caaf4cb80ba7cbbbb324066bd03eae3fc98f813	3	80107176	400000000000000000000	1907212496894	2023-03-11T15:27:26.000Z	0xdda4f2ad2de956e4adb35915f66d78de42ae12ca0d6241d579a1ba4f34e78efa

Example Query

Query with partition filter

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

soSNX_NewReserveFactor_event

Reserve factor parameter changes for the soSNX (Sonne SNX) lending market on Optimism. Tracks protocol fee adjustments where reserve factor determines the percentage of interest allocated to protocol reserves versus liquidity providers.

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
0xd7daabd899d1fabbc3a9ac162568939cec0393cc	false	2	33495104	2022-11-01T23:01:49.000Z	0xa1793e5de9be31135bcce79b2f3de33bba7b4594820d9eadc1ccd1f84267971e	270000000000000000	0

Example Query

Query with partition filter

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

soSNX_Redeem_event

Redemption events from Sonne Finance’s SNX lending market on Optimism, capturing when users withdraw underlying SNX tokens by burning soSNX (Sonne’s interest-bearing token). Used for analyzing lending market withdrawals, liquidity flows, and soSNX token supply 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_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
0xd7daabd899d1fabbc3a9ac162568939cec0393cc	false	4	0x0877c1e5b0bafff1a79a4f39e1333326a195dff2	92333515	2023-04-19T19:55:36.000Z	1400000000000000000000	6622334524010	0xa936ad52bb73f5d775de0e4140d5dce0d0e6e71e320d28128f4ca33b5f0de38e
0xd7daabd899d1fabbc3a9ac162568939cec0393cc	false	4	0x0877c1e5b0bafff1a79a4f39e1333326a195dff2	92334093	2023-04-19T19:59:40.000Z	1002000000000000000000	4739695611994	0x51c4c6f2e10bb76539d3f9252bda878e6c33ff1dbc7a06bce72acaa6fd15e331
0xd7daabd899d1fabbc3a9ac162568939cec0393cc	false	4	0x0877c1e5b0bafff1a79a4f39e1333326a195dff2	92335572	2023-04-19T20:06:25.000Z	998967018689394378490	4725342621334	0x338fa3a6465a88fe7812929a63aece3024a4c57faa80a8a0ada321938e0986fd

Example Query

Query with partition filter

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

soSNX_RepayBorrow_event

Borrow repayment events for the soSNX (Synthetix) market on Sonne Finance lending protocol on Optimism. Tracks repayment amounts, updated account and total borrow balances for analyzing debt reduction activity 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_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
0xd7daabd899d1fabbc3a9ac162568939cec0393cc	false	0x4334703b0b74e2045926f82f4158a103fce1df4f	3	0x4334703b0b74e2045926f82f4158a103fce1df4f	95539041	150000000000000000000	2023-04-30T16:15:04.000Z	268249967985600062377390	0x6455333f6736adb10ccb1da7758ed62508f876bd3db2a5cd2679d4e45696b92e	4514600114600501795300
0xd7daabd899d1fabbc3a9ac162568939cec0393cc	false	0x4ca06b3e0f13deb1861d60971a45506922f9f4ea	3	0x4ca06b3e0f13deb1861d60971a45506922f9f4ea	95426425	453109779642262747953	2023-04-30T07:28:01.000Z	268351030394815482599417	0xb0bb7bcc7550a6c933be43c10eda381528076b84f9d942fa08f041f74738204a	0
0xd7daabd899d1fabbc3a9ac162568939cec0393cc	false	0x0a3234a2f7e0026364a6fa61b286c8b107e2cd3c	143	0x0a3234a2f7e0026364a6fa61b286c8b107e2cd3c	106862214	35400000000000000414	2023-07-14T08:26:45.000Z	192080628400287597046666	0x85f4afcdbe3acd99dc329f4037df296007b576e649353cef87842ad744ef262a	4636793270308748771

Example Query

Query with partition filter

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

soSUSD_AccrueInterest_event

Interest accrual events from Sonne Finance’s soSUSD lending pool on Optimism, recording cash reserves, total borrows, borrow index, and accumulated interest. Used for tracking yield generation, utilization rates, and interest rate model performance 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
0xd14451e0fa44b18f08aeb1e4a4d092b823caca68	false	84012122	533857840949617229897436	1037403761184722800	2023-03-27T09:19:58.000Z	2435088023311839655249183	0xf97f6710f52eaa06a938d8b1892d4f7a2ff842a931b4c2bea8a4d012b3f7e47c	5062683284123025219
0xd14451e0fa44b18f08aeb1e4a4d092b823caca68	false	84037674	539294636728989715747758	1037425876400546464	2023-03-27T11:48:47.000Z	2429736979438202833413510	0x218797ff5efe6710e206f1534400a3182b35478a35bceff0461b5fb2a3276c90	7813334357959356450
0xd14451e0fa44b18f08aeb1e4a4d092b823caca68	false	84116506	541618804861022371068222	1037475573371940077	2023-03-27T17:30:35.000Z	2432573405846906530381465	0x39be876e781c4f21b089be5b686c832c979d28bf9eeb457c48ad3acdca340d08	6075620117226519319

Example Query

Query with partition filter

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

soSUSD_Borrow_event

Borrow event logs from the soSUSD (Sonne USD) lending market on Optimism, tracking individual borrow transactions with borrower address, borrowed amount, and cumulative account/total borrows. Used for analyzing borrowing patterns, user leverage behavior, and protocol utilization in Sonne Finance’s Compound-fork 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
0xd14451e0fa44b18f08aeb1e4a4d092b823caca68	false	3	0x2ec5a118e3c04342bfcdf7200e86bddcb3cb4bb0	70204681	2023-01-24T22:26:32.000Z	75000000000000000000000	1609039849084031621524707	0x27c4260f70176ba088425a13f9264d97099b0b99415261a2a9b38dd89ec8c202	75000000000000000000000
0xd14451e0fa44b18f08aeb1e4a4d092b823caca68	false	3	0x2ec5a118e3c04342bfcdf7200e86bddcb3cb4bb0	70206120	2023-01-24T22:28:17.000Z	45000000000000000000000	1654040313944650255132116	0x555dd7c0c8c8e235af9eb731bcb75bbc6369886277eba2b48e96677ecb8a3baf	120000021667919795315981
0xd14451e0fa44b18f08aeb1e4a4d092b823caca68	false	3	0x471fc71d72b71a2131c6e1fc5b39fc21d425e653	70036778	2023-01-24T01:46:52.000Z	7391687512608111000	1205879840547658858349946	0xda78bbf6bb73343d170e95cb4fabe523967071149f52c5edfc8370ba8790b253	7391687512608111000

Example Query

Query with partition filter

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

soSUSD_Mint_event

Mint events for the soSUSD (Sonne SUSD) token on Optimism, tracking when users deposit SUSD stablecoins to receive interest-bearing soSUSD tokens. Records include minter address, underlying SUSD amount deposited, and soSUSD tokens minted with exchange rate implied by the ratio between amounts.

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
0xd14451e0fa44b18f08aeb1e4a4d092b823caca68	false	0xff87e22e9b773021c03323f5b19d4f862f4519ba	3	98310858	46000000000000000000	223610060214	2023-05-14T23:36:38.000Z	0x92d12b99e71abe57799ca830da1fc8e19352837c4d51f5f10322437bb65a5262
0xd14451e0fa44b18f08aeb1e4a4d092b823caca68	false	0x65d619d41be19efe6d1f6bfb6bdc43418015b05b	3	98080736	800000000000000000	3889489136	2023-05-14T01:51:11.000Z	0x01c7d6725381341a0d5d3af1cb080de82cfc250990385b12bb6426f080623300
0xd14451e0fa44b18f08aeb1e4a4d092b823caca68	false	0x8a93d3871ec740a365d67802523f2e3c5db37b98	3	98235256	2989961936603773000000	14535497028667	2023-05-14T15:05:36.000Z	0xe995e9a98ab0f6f6aee5fa9f964902cc51379d2104d047d0895791b8e2d0d661

Example Query

Query with partition filter

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

soSUSD_NewReserveFactor_event

Reserve factor parameter changes for Sonne Finance’s soSUSD (synthetic USD) lending market on Optimism. Tracks updates to the protocol’s reserve accumulation rate, specified in mantissa format (18 decimals), used for monitoring risk parameter 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
0xd14451e0fa44b18f08aeb1e4a4d092b823caca68	false	1	26051042	2022-09-28T16:28:59.000Z	0x5644e713dd3665d120271a31a162a6929acfa8407f645759d3cfff0408eacb1f	200000000000000000	0

Example Query

Query with partition filter

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

soSUSD_Redeem_event

Redemption events from Sonne Finance’s soSUSD market on Optimism, recording when users withdraw underlying SUSD tokens by burning soToken shares. Useful for analyzing lending market liquidity withdrawals and tracking supply-side flows 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_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
0xd14451e0fa44b18f08aeb1e4a4d092b823caca68	false	22	0x276467500aea9a9734f55c3b5b7de8a8299b45b0	76543176	2023-02-24T07:15:27.000Z	340294197956884472085	1670993982234	0xd3fa846801a5358182e99aff4c890cbfe30386e2a023685db92a79a21f4ed7a8
0xd14451e0fa44b18f08aeb1e4a4d092b823caca68	false	14	0x276467500aea9a9734f55c3b5b7de8a8299b45b0	76543176	2023-02-24T07:15:27.000Z	486735715039425482613	2390086153841	0xd3fa846801a5358182e99aff4c890cbfe30386e2a023685db92a79a21f4ed7a8
0xd14451e0fa44b18f08aeb1e4a4d092b823caca68	false	30	0x276467500aea9a9734f55c3b5b7de8a8299b45b0	76543176	2023-02-24T07:15:27.000Z	877554276396235974635	4309176952607	0xd3fa846801a5358182e99aff4c890cbfe30386e2a023685db92a79a21f4ed7a8

Example Query

Query with partition filter

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

soSUSD_RepayBorrow_event

Borrow repayment events for soSUSD (Sonne Finance USD stablecoin market) on Optimism, tracking payer and borrower addresses, repayment amounts, and updated borrow balances. Used for analyzing debt repayment patterns and protocol solvency in the Sonne 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_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
0xd14451e0fa44b18f08aeb1e4a4d092b823caca68	false	0x1b89a08d82079337740e1cef68c571069725306e	27	0x1b89a08d82079337740e1cef68c571069725306e	106250187	757732728114031344076	2023-06-30T04:25:51.000Z	1645174209760135295120518	0xba90e53d406764dfbfc53217ce284e1fc7b6e71b4d1e4e6a426ce6140bd99e98	735800920490173853871
0xd14451e0fa44b18f08aeb1e4a4d092b823caca68	false	0x50ed348f85de0772a61ff63bbe33df8db30de1b2	105	0x50ed348f85de0772a61ff63bbe33df8db30de1b2	106257350	107851837534532115939	2023-06-30T08:24:37.000Z	1729595293024644396145338	0xb0b1efa02454bb3f11bf6bce85148a4bcb2e1782d9e9c6a9be56cc01e01db8fa	2383985269304490298019
0xd14451e0fa44b18f08aeb1e4a4d092b823caca68	false	0x52cc1bc45d387a52ce48a9c051614a6265529bba	55	0x52cc1bc45d387a52ce48a9c051614a6265529bba	106275572	19295767855888930117	2023-06-30T18:32:01.000Z	1731397239903409910628259	0xd629983275e380735284bb1458ef3e5c16d616dba23c8d459bfc5fef4deb6505	40752770465028747313

Example Query

Query with partition filter

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

soUSDC_AccrueInterest_event

Interest accrual events from Sonne Finance’s USDC lending market (soUSDC) on Optimism. Tracks periodic interest calculations including accumulated interest, borrow index updates, cash reserves, and total borrows for analyzing lending pool yield and 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_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
0xec8fea79026ffed168ccf5c627c7f486d77b765f	false	98261844	3779665251326	1029096311443561517	2023-05-14T17:20:36.000Z	10947443777320	0xb808d8377d4f237cac255d15c79301d75dc6ef187fcab8c07462169d8e9764d1	2435462
0xec8fea79026ffed168ccf5c627c7f486d77b765f	false	98304834	3720675849767	1029125169114242645	2023-05-14T22:35:55.000Z	11028992202317	0xc1be721a7ab41fcc8cdf8f72ee514e9f7595405ca20df2757755d9ad89a03355	4249717
0xec8fea79026ffed168ccf5c627c7f486d77b765f	false	98310042	3683406892954	1029130055801727086	2023-05-14T23:29:15.000Z	11131088776600	0x8c4ffaf32725fa5be15fd48b51c40220e2dc9655649640da8a8988229e21e499	31014026

Example Query

Query with partition filter

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

soUSDC_Borrow_event

Borrow event logs from Sonne Finance’s USDC money market (soUSDC) on Optimism, capturing loan originations with borrower addresses, borrow amounts (6 decimals), and cumulative protocol/account borrow balances. Used for tracking lending market utilization, borrower behavior, and calculating interest accrual 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
0xec8fea79026ffed168ccf5c627c7f486d77b765f	false	7	0x1b08bc49accb4fb813bc9cb7f3a1f7f93510010e	113352607	2023-12-11T14:13:11.000Z	400000000	7358029747271	0xa8319cc83b3ad0689d6ffa22bde81abd302dd01b2c4f428c64e023b8eef551d1	35916859186
0xec8fea79026ffed168ccf5c627c7f486d77b765f	false	174	0x1b7ea7d42c476a1e2808f23e18d850c5a4692df7	113350905	2023-12-11T13:16:27.000Z	2000000000	7339539705167	0xd8076f4fc83c9989963dcb041b32b1564259e33a333c112a120623ae7e419ed7	52449420781
0xec8fea79026ffed168ccf5c627c7f486d77b765f	false	88	0x1b89a08d82079337740e1cef68c571069725306e	113350801	2023-12-11T13:12:59.000Z	5000000000	7337534374026	0xd47fd7ac7688f29306dfdb5500612cdf0fc0bbb3fc31bbbb8d004ccc96bf579f	53092498745

Example Query

Query with partition filter

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

soUSDC_Mint_event

Mint event logs from Sonne Finance’s soUSDC market on Optimism, tracking when users deposit USDC collateral and receive soUSDC interest-bearing tokens. Records underlying USDC amounts, minted soToken quantities, and minter addresses for analyzing lending protocol deposit activity and token 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_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
0xec8fea79026ffed168ccf5c627c7f486d77b765f	false	0x0c3e20430a51c1727ca8c9d6a07e7e54e31930bc	91	113370270	636769	3042574454	2023-12-12T00:01:57.000Z	0x3fd2e9723de76183e8b861ce74ea6b0d88be4ef988f94a5474a60867cf51698e
0xec8fea79026ffed168ccf5c627c7f486d77b765f	false	0x2eefbb883b6a1b64a75b2aa18cd4dfbe19e684a3	49	113381381	5684724479	27161340757898	2023-12-12T06:12:19.000Z	0x4300bdd5b0babad0bea8301eef1b22da1aa97054a9af73958ddd0d3f0d09f3e3
0xec8fea79026ffed168ccf5c627c7f486d77b765f	false	0x2eefbb883b6a1b64a75b2aa18cd4dfbe19e684a3	545	113402283	28501665333	136168442097463	2023-12-12T17:49:03.000Z	0x635805d8eabf1802144f2706567e0b54c522cef1cff52d85dcd172f505b58964

Example Query

Query with partition filter

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

soUSDC_NewReserveFactor_event

Reserve factor parameter changes for the soUSDC lending market on Sonne Finance (Optimism), tracking protocol fee adjustments where reserve factor determines the percentage of interest allocated to protocol reserves versus liquidity providers.

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
0xec8fea79026ffed168ccf5c627c7f486d77b765f	false	1	26050534	2022-09-28T16:27:44.000Z	0x50c7e383da6778056cd58d67882c6f2d090bcac9d95346b643db1baf96bb882d	100000000000000000	0

Example Query

Query with partition filter

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

soUSDC_Redeem_event

Redeem events from Sonne Finance’s soUSDC market on Optimism, recording when users withdraw underlying USDC by burning soUSDC tokens. Contains redeemer addresses, token amounts burned, and underlying amounts received for analyzing lending protocol withdrawal 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
0xec8fea79026ffed168ccf5c627c7f486d77b765f	false	4	0xd3309c1d9349a9f73e465f101965400b6898860e	108757914	2023-08-27T05:36:45.000Z	3048925	14790008800	0xd49bd13ed49fe91f6f69fcc89fe476c892993c7372b898db8ae1ea1013511d1e
0xec8fea79026ffed168ccf5c627c7f486d77b765f	false	4	0xb24edd8c4be5c8ea70549302e3a72bf72e105149	108766547	2023-08-27T10:24:31.000Z	6100464	29591737343	0x2885b6bc7bef5eb5de98809011fe4e46c082a5e097fbb80f76090f712ff27932
0xec8fea79026ffed168ccf5c627c7f486d77b765f	false	4	0xfcec50e93873f07d3c684f3daacca4f606bf4904	108778017	2023-08-27T16:46:51.000Z	30496414	147923756905	0xcc1f522468aee5255467873aecb0d13e996bd78ba7e04882163ec9ef5a2b9c3c

Example Query

Query with partition filter

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

soUSDC_RepayBorrow_event

Borrow repayment events for the soUSDC market on Sonne Finance (Compound V2 fork) on Optimism, tracking USDC debt reduction with payer, borrower addresses, repayment amounts, and updated account balances.

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
0xec8fea79026ffed168ccf5c627c7f486d77b765f	false	0x1b1b3ee4d70b6cff84fee1c4ce5c5d9b42053e7b	36	0x1b1b3ee4d70b6cff84fee1c4ce5c5d9b42053e7b	114750321	999407453	2024-01-12T22:43:39.000Z	8917148193048	0xd118abe9985769833ee90b6580b88df9dbf07939a5f312dcc6b4596b0b89d566	13446077957
0xec8fea79026ffed168ccf5c627c7f486d77b765f	false	0x1f6b8a669fe3b5ac99eb129af6368bc00e7d867b	13	0x1f6b8a669fe3b5ac99eb129af6368bc00e7d867b	114751050	149919406	2024-01-12T23:07:57.000Z	8913410950636	0x109c1b793338f5e8dee07ee3043105c386af30cb776ade01ff88570057c9402e	154460766738
0xec8fea79026ffed168ccf5c627c7f486d77b765f	false	0x2ba1d521595c5b31b177fd5263f8b002f570e92a	8	0x2ba1d521595c5b31b177fd5263f8b002f570e92a	114744476	1006653967	2024-01-12T19:28:49.000Z	8660372317881	0x9eb1bde4db47d23e98f39aca47a2479675febe22c1f74c48fa9b245b9a95491b	0

Example Query

Query with partition filter

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

soUSDT_AccrueInterest_event

Interest accrual events for the soUSDT (Sonne USDT) lending market on Optimism, tracking accumulated interest, total borrows, cash reserves, and borrow index updates. Used for analyzing lending market dynamics and calculating protocol revenue 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
0x5ff29e4470799b982408130efaabdeeae7f66a10	false	0	108724065	3107976611635	1053809828597705298	2023-08-26T10:48:27.000Z	13254615381594	0x77407dcafb723e174f5c43fac0060168a17d48c8fd837078061633a0d2fa65df	321652
0x5ff29e4470799b982408130efaabdeeae7f66a10	false	0	108733409	2873179449607	1053840891158700339	2023-08-26T15:59:55.000Z	11038136509955	0x05dba0cb0fcd733171e30e8c2d946cf246deb1e25f58265a80b267006a9bcf14	46521345
0x5ff29e4470799b982408130efaabdeeae7f66a10	false	2	108724173	3077976611635	1053810251591676667	2023-08-26T10:52:03.000Z	12927620628862	0xfab50f5854c723cafb8535b3f9e8c696dfe9cef34d60127ab0dc0424d76531cc	297860

Example Query

Query with partition filter

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

soUSDT_Borrow_event

Borrow event records from Sonne Finance’s USDT (soUSDT) lending market on Optimism, capturing when users take out USDT loans with amounts, borrower addresses, and cumulative borrow balances. Used for analyzing borrowing patterns, position tracking, and protocol 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_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
0x5ff29e4470799b982408130efaabdeeae7f66a10	false	52	0xbe9efe8c2f21f71fc8b46442273b386ed4063951	109069477	2023-09-03T10:42:11.000Z	300000000	10327530842422	0x0ccfd2f03f251113d2168d809c9041f31ed0d1f19f8b4ba8e3adb13a27c695b3	1868071681
0x5ff29e4470799b982408130efaabdeeae7f66a10	false	110	0x5052d456ed130196453c037ce450924976b774c1	109066304	2023-09-03T08:56:25.000Z	66021472	10327193830527	0x2d8ca00b705680718bbfe8de9529a8c7f67559387184986a57ff63244385a55c	66021472
0x5ff29e4470799b982408130efaabdeeae7f66a10	false	57	0x2d9f73c98f256870887ecfc2dd9114c9d0f97ae2	109065699	2023-09-03T08:36:15.000Z	200000000	10327108166701	0x619e730acb94de27e7b91edb060462e624fce497a4c149d93db44d1263e24d06	200000000

Example Query

Query with partition filter

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

soUSDT_Mint_event

Mint events from the soUSDT lending market on Sonne Finance (Optimism), recording when users deposit USDT collateral and receive soUSDT interest-bearing tokens. Used for tracking supply-side lending activity and calculating token exchange rates 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
0x5ff29e4470799b982408130efaabdeeae7f66a10	false	0x0a2e33f6bc06bc833175f6d329d30bc18f79d4d7	45	110329753	2023697418	9705141012646	2023-10-02T14:51:23.000Z	0xcdc51f47c3c94ee06884f92f34e2fdbd46dfbea68e2bc268cc75433b4dcdb51c
0x5ff29e4470799b982408130efaabdeeae7f66a10	false	0x0a2e33f6bc06bc833175f6d329d30bc18f79d4d7	42	110318328	75647311	362799895963	2023-10-02T08:30:33.000Z	0xf2cae208e2fdf25481bf4dcb846f234f5a826c5344547364377e05c93e4c2083
0x5ff29e4470799b982408130efaabdeeae7f66a10	false	0x18a1ddfe1b986fce69b9ee0f90c6305f406acde3	41	110303058	138227347	662961435710	2023-10-02T00:01:33.000Z	0x13f617a4687fe00a34d2b5ac32964fd6623cfc973e00d71f2365509d93d57015

Example Query

Query with partition filter

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

soUSDT_NewReserveFactor_event

Reserve factor parameter updates for the soUSDT lending market on Sonne Finance (Optimism). Tracks changes to the protocol’s reserve allocation percentage, with mantissa values representing the fraction of interest retained by the protocol (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
0x5ff29e4470799b982408130efaabdeeae7f66a10	false	1	26050725	2022-09-28T16:27:59.000Z	0xe864f99d715aded4fa3e3868b015ade4c0a08d9650fa61d1df34ed7344f20392	100000000000000000	0

Example Query

Query with partition filter

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

soUSDT_Redeem_event

Redemption events from Sonne Finance’s soUSDT lending market on Optimism, tracking withdrawals of underlying USDT tokens by burning soUSDT receipt tokens. Useful for analyzing lending market liquidity flows 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
0x5ff29e4470799b982408130efaabdeeae7f66a10	false	44	0x2e935e4d9c197daaee6495d652fd472e6e96c68b	106731838	2023-07-11T08:00:53.000Z	99899999	483701435177	0xee54da33782b7c54ddeaf6d826edd70b98f58b9270690d5405ec8aae944cd38a
0x5ff29e4470799b982408130efaabdeeae7f66a10	false	35	0x2e935e4d9c197daaee6495d652fd472e6e96c68b	106747869	2023-07-11T16:55:15.000Z	1798200000	8706223440455	0x2caa9d275aed41c62255fe86132bf97fdcbc6dcfc8714cfec37307bf032cb0bb
0x5ff29e4470799b982408130efaabdeeae7f66a10	false	26	0x2e935e4d9c197daaee6495d652fd472e6e96c68b	106736382	2023-07-11T10:32:21.000Z	499500000	2418475472950	0x542153a0e5ee65c2a0ed6dbd2f7ec633fc6f68c91b5bed80932be7d0c361ec1f

Example Query

Query with partition filter

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

soUSDT_RepayBorrow_event

Loan repayment events from Sonne Finance’s USDT market (soUSDT) on Optimism, tracking when borrowers repay debt with payer, borrower addresses, repayment amounts, and remaining account and total borrows. Used for analyzing lending protocol debt dynamics and borrower repayment 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_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
0x5ff29e4470799b982408130efaabdeeae7f66a10	false	0x0a2e33f6bc06bc833175f6d329d30bc18f79d4d7	67	0x0a2e33f6bc06bc833175f6d329d30bc18f79d4d7	107764321	295350402051	2023-08-04T05:36:59.000Z	15651375241949	0xb6ff31536ce4f63c70b5ca47794c238047413794f52d903168915486df73b2eb	0
0x5ff29e4470799b982408130efaabdeeae7f66a10	false	0x5929cc4d10b6a1acc5bf5d221889f10251c628a1	49	0x5929cc4d10b6a1acc5bf5d221889f10251c628a1	107783298	250000000	2023-08-04T16:09:33.000Z	16293013111521	0xccba519b4be7afbb55c0026c1c3698046d0215cf6d7bc3d0b487d61780227497	751096484
0x5ff29e4470799b982408130efaabdeeae7f66a10	false	0x8074ed7aea09a7f371af44dabd4de6c42839929b	126	0x8074ed7aea09a7f371af44dabd4de6c42839929b	107768461	453563975	2023-08-04T07:54:59.000Z	15651131531295	0x67003e03250647a6cbf1a774d563a6ff235f161c93322b9eef88fa361d80be14	11924825

Example Query

Query with partition filter

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

soWBTC_AccrueInterest_event

Interest accrual events for Sonne Finance’s soWBTC (Wrapped Bitcoin) lending market on Optimism, tracking cash reserves, total borrows, and the borrow index used to calculate interest rates. Used for analyzing WBTC lending pool performance and interest rate 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_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
0x33865e09a572d4f1cc4d75afc9abcc5d3d4d867d	false	104043672	24966777250	1054663468442766151	2023-06-03T04:27:54.000Z	5923072598	0x4282a0c9d67ac3b01a5fa3fb30b03fec4ba2eaa4c4e8376a3acb0936e6d72d18	222559
0x33865e09a572d4f1cc4d75afc9abcc5d3d4d867d	false	104241953	24968216569	1054769824765580601	2023-06-03T16:24:49.000Z	5923669901	0xb70fcfd8bc09b46d5bad74a724fb921414e3f117d2f98950d0d6a67b82a4f0af	20053
0x33865e09a572d4f1cc4d75afc9abcc5d3d4d867d	false	104309423	25008052691	1054816480009515805	2023-06-03T21:39:15.000Z	5933931982	0x81bee049f11ece56d6f210458114ec4b5960024e58b8cf4a9285e095892031b9	24082

Example Query

Query with partition filter

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

soWBTC_Borrow_event

Borrow events from Sonne Finance’s Wrapped Bitcoin (WBTC) lending market on Optimism, capturing loan originations with borrower addresses, borrowed amounts (in WBTC’s 8 decimal format), and cumulative protocol debt. Used for analyzing WBTC borrowing patterns and individual account leverage 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
0x33865e09a572d4f1cc4d75afc9abcc5d3d4d867d	false	3	0x57a7a56aec7faa36334bcc4fa8354dab3a9da05c	74449793	2023-02-15T09:57:14.000Z	62974628	7612722283	0x8eaa453e684414d754476a822b5b178faca9651a422fcf36787007faf0c754e4	1140063910
0x33865e09a572d4f1cc4d75afc9abcc5d3d4d867d	false	3	0x57a7a56aec7faa36334bcc4fa8354dab3a9da05c	74449773	2023-02-15T09:56:59.000Z	435762097	7549747202	0x836a185ebb3c58ed88d30ab1f07b2b8186305a7c6db71a702f2f5eb6251893ad	1077089218
0x33865e09a572d4f1cc4d75afc9abcc5d3d4d867d	false	13	0x57a7a56aec7faa36334bcc4fa8354dab3a9da05c	74396869	2023-02-15T02:32:59.000Z	354408552	7113247805	0xcdbfe18baa1caaba23113b1d27aa33028b8968ba8c50bf2016ba4ac97f48c1ca	641260653

Example Query

Query with partition filter

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

soWBTC_Mint_event

Mint events from Sonne Finance’s soWBTC (interest-bearing Wrapped BTC) lending pool on Optimism, recording deposits of WBTC collateral and issuance of corresponding soWBTC tokens. Used for tracking lending pool supply dynamics and individual depositor 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
0x33865e09a572d4f1cc4d75afc9abcc5d3d4d867d	false	0x01c020c8f90aebc4d8fcac2ea1acec596da4e01b	102	113906288	1281191	62767114	2023-12-24T09:49:13.000Z	0x07c34550920eedca66283711eafc228cc9c19ee99674938a6325bab45f6ddde9
0x33865e09a572d4f1cc4d75afc9abcc5d3d4d867d	false	0x04a31c1a75f944d810f39ba6545f4bdb709a5c0b	38	113888662	333	16314	2023-12-24T00:01:41.000Z	0x786d5fe50ca44a36ddea868c8054becfd8a52c3d154c5ea275f61fbbb4cb6e42
0x33865e09a572d4f1cc4d75afc9abcc5d3d4d867d	false	0x272c39c82ca9f10e5338a6ee75927cfe00c82e2c	21	113921058	322593	15804141	2023-12-24T18:01:33.000Z	0x10f850743580c7a30f4fdf15cf4b4255f7e4a32c9f2bbc05912fdedb373d5057

Example Query

Query with partition filter

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

soWBTC_NewReserveFactor_event

Reserve factor parameter changes for the Sonne Finance soWBTC (Wrapped Bitcoin) lending market on Optimism. Tracks updates to the protocol’s reserve allocation percentage, useful for analyzing risk parameter adjustments and governance actions.

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
0x33865e09a572d4f1cc4d75afc9abcc5d3d4d867d	false	2	45448654	2022-12-04T23:19:50.000Z	0x90ab6fba46d054697f5524bd8e48d8e32ae4ed44e7da2c528614249aaac67af4	200000000000000000	0

Example Query

Query with partition filter

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

soWBTC_Redeem_event

Withdrawal events from Sonne Finance’s Wrapped Bitcoin (soWBTC) lending market on Optimism, recording when users redeem soWBTC tokens for underlying WBTC collateral. Tracks redemption amounts, token quantities, and user addresses for analyzing lending market 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
0x33865e09a572d4f1cc4d75afc9abcc5d3d4d867d	false	18	0x0c3e20430a51c1727ca8c9d6a07e7e54e31930bc	115178189	2024-01-22T20:25:55.000Z	245685	12030672	0x0938501e69fbe0a8e9558ad3775f999d567e53438c5a128154cd4c72631679d3
0x33865e09a572d4f1cc4d75afc9abcc5d3d4d867d	false	25	0x0c3e20430a51c1727ca8c9d6a07e7e54e31930bc	115170562	2024-01-22T16:11:41.000Z	221985	10870161	0x2265f1827349f1ecb6c5bb96c6153aa79cb62822896f45fc37433fca8604a1ab
0x33865e09a572d4f1cc4d75afc9abcc5d3d4d867d	false	35	0x0c3e20430a51c1727ca8c9d6a07e7e54e31930bc	115165273	2024-01-22T13:15:23.000Z	265008	12976933	0x16a824ca6645a481498f0a9f34f92d725b82ebd4fefdff18ecd3520649a942a0

Example Query

Query with partition filter

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

soWBTC_RepayBorrow_event

Borrow repayment events for the Wrapped Bitcoin (WBTC) lending market on Sonne Finance v1 (Optimism). Tracks debt repayments with borrower/payer addresses, repayment amounts, and updated account balances for analyzing lending activity and position 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
0x33865e09a572d4f1cc4d75afc9abcc5d3d4d867d	false	0xe751378ec5e5c0b64c4d16a077e8f11fbcfc958a	4	0xe751378ec5e5c0b64c4d16a077e8f11fbcfc958a	78303012	2000000	2023-03-03T02:22:45.000Z	21864805174	0x017b31bccc7b3607da8eb8d9bbec0e253ac18663de63be0289d92afde04e3e2c	1096784
0x33865e09a572d4f1cc4d75afc9abcc5d3d4d867d	false	0xe751378ec5e5c0b64c4d16a077e8f11fbcfc958a	4	0xe751378ec5e5c0b64c4d16a077e8f11fbcfc958a	78315955	1000000	2023-03-03T03:54:35.000Z	21864324245	0xf2ab9f07e6d7558c143dba4d7fe57efa36c1c527003dc31c08cff35c8ae10ab3	96810
0x33865e09a572d4f1cc4d75afc9abcc5d3d4d867d	false	0x3096d872e1fcc96e5e55f43411971d49bb137b9b	4	0x3096d872e1fcc96e5e55f43411971d49bb137b9b	93720369	360281516	2023-04-24T03:48:58.000Z	10175045469	0xd0ce9d2ef3490fce66537c236bf16ca92689b041a52c228682e2a9d34d76ef14	638604246

Example Query

Query with partition filter

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

soWETH_AccrueInterest_event

Interest accrual events for the soWETH (Sonne WETH) lending market on Optimism, recording cash reserves, total borrows, borrow index updates, and accumulated interest. Used for tracking lending pool performance 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
0xf7b5965f5c117eb1b5450187c9dcfccc3c317e8e	false	80976407	3531820992673938959062	1021143445705226435	2023-03-15T04:12:21.000Z	8562382378431668031164	0x7e1df7a5ab16b2bd38a34536ba4dd2069fba27e4f591f5f80967ecbe149d13ad	4625984460944760
0xf7b5965f5c117eb1b5450187c9dcfccc3c317e8e	false	81217567	3655098404236943912072	1021229595404175921	2023-03-15T21:03:35.000Z	8435570744724787222088	0xc704e7e8d22c84e4aaf481461e20bc03bd8e19a71c2a1aec16cc80675f317218	7617753461175453
0xf7b5965f5c117eb1b5450187c9dcfccc3c317e8e	false	81191618	3652243171891246896516	1021217102281316700	2023-03-15T18:36:11.000Z	8437878595880301526044	0x6f882cec017a229461eb6fee0e7c9afc002545abc8e8d31aa879f0f9e9bac747	11450888132442950

Example Query

Query with partition filter

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

soWETH_Borrow_event

Borrow event logs from Sonne Finance’s WETH (Wrapped Ether) lending market on Optimism, recording when users take out loans with borrowed amounts, cumulative account debt, and protocol-wide total borrows. Used for tracking borrowing activity, debt positions, and lending 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_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
0xf7b5965f5c117eb1b5450187c9dcfccc3c317e8e	false	4	0x606834d476d5c83d5987b001d4c79ad4cda48c8c	43843498	2022-11-30T10:22:26.000Z	151000000000000000	5476707087639976526589	0x941c17334cf1d0ff08ea34385bd265b79ea3df3f91f505b63a5c05d5824f3ba3	151000000000000000
0xf7b5965f5c117eb1b5450187c9dcfccc3c317e8e	false	3	0x73860dc8055a36199fa017e4d9b6584e1497df85	43834678	2022-11-30T09:54:25.000Z	23000000000000000000	5476539407498688885949	0x6855d4dbcd9e7993205a4c5f5bc71d166d9ef0d20a96da634b116e81bfd7d5c6	23000000000000000000
0xf7b5965f5c117eb1b5450187c9dcfccc3c317e8e	false	3	0x6831071861cf14bd7903bd123a95fdc8f6073ef7	43698078	2022-11-30T01:45:59.000Z	40000000000000000	5453316462460848818411	0x1cdc6ff47ff4aece0f141ae03cde218b74f80a6814bbcf4d9837cae69b8ca4ef	668310377838775332

Example Query

Query with partition filter

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

soWETH_Mint_event

Mint events from the Sonne Finance soWETH market on Optimism, capturing when users deposit WETH collateral to receive interest-bearing soWETH tokens. Used for tracking lending protocol deposits, supply growth, and collateral position analysis.

Columns

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

Sample Data

address	removed	in_minter	log_index	block_number	in_mintAmount	in_mintTokens	block_timestamp	transaction_hash
0xf7b5965f5c117eb1b5450187c9dcfccc3c317e8e	false	0x1e18b8b6f27568023e0b577cbee1889391b2f444	3	81042316	197368488925677100	974243737	2023-03-15T09:38:17.000Z	0xfeba878acdc3cfb62afe7a56616033dedf771dc46f089e956cd516b7ec46b8d8
0xf7b5965f5c117eb1b5450187c9dcfccc3c317e8e	false	0x1e18b8b6f27568023e0b577cbee1889391b2f444	3	80987651	1010000000000000000	4985592883	2023-03-15T05:21:35.000Z	0xab928e950fe27300f42665012edc4b517312c81cc4c4458a2abf5d8eff0f9bbd
0xf7b5965f5c117eb1b5450187c9dcfccc3c317e8e	false	0x2719dbf6f9f516e255b84f4d0ae85dadd4f25e57	268	80935170	126544557576417850	624663257	2023-03-15T00:00:35.000Z	0xaf4b85b6d74608d315fdfb047f4a78ca0158c74f2939892a6c33ffb6d9fd5a38

Example Query

Query with partition filter

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

soWETH_NewReserveFactor_event

Reserve factor parameter changes for the soWETH lending market on Sonne Finance (Optimism), tracking protocol fee adjustments where mantissa values represent percentages in 18-decimal format. Used for governance analysis and protocol revenue modeling.

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
0xf7b5965f5c117eb1b5450187c9dcfccc3c317e8e	false	1	26050496	2022-09-28T16:27:29.000Z	0xe6f5b85e1d5e4fba18bde1992226b165e2ab3b096ec0b20c279667546f85cf20	150000000000000000	0

Example Query

Query with partition filter

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

soWETH_Redeem_event

Redemption events from Sonne Finance’s wrapped ETH (WETH) lending market on Optimism, tracking when users withdraw WETH by burning soWETH tokens. Contains redeemer addresses, token amounts burned, and underlying WETH amounts received for analyzing lending protocol withdrawals.

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
0xf7b5965f5c117eb1b5450187c9dcfccc3c317e8e	false	5	0x2719dbf6f9f516e255b84f4d0ae85dadd4f25e57	92324220	2023-04-19T19:00:28.000Z	6661667184492355	32803794	0xa04e3e93adb7bab6e59f2441503534313d0ce94db1d15d068052bbb34413eb46
0xf7b5965f5c117eb1b5450187c9dcfccc3c317e8e	false	35	0x26ff294b8b96acaec5b33be88ac611fd663d1864	92159919	2023-04-19T08:23:24.000Z	2554673466762453814	12580367111	0x4d6b818b6dd7ff6b57739f3096450d3dee426aa162c16a4969d40029795bef28
0xf7b5965f5c117eb1b5450187c9dcfccc3c317e8e	false	4	0x4b8b235c511f0c830264c7761520b1f9ad441716	92226024	2023-04-19T12:09:20.000Z	92506826107255139	455539211	0x9bd9c67e57484b7a32fe9c7af9ba1eb66562f80713a31461be7efd189e97db47

Example Query

Query with partition filter

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

soWETH_RepayBorrow_event

Borrow repayment events for the Sonne Finance WETH (Wrapped Ether) lending market on Optimism. Tracks debt repayments with payer and borrower addresses, repayment amounts, and updated borrow balances for analyzing lending activity and debt management 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_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
0xf7b5965f5c117eb1b5450187c9dcfccc3c317e8e	false	0x052463c5b558f273b69f5d831603a815ae4eea41	3	0x052463c5b558f273b69f5d831603a815ae4eea41	33868370	2967260000000000000	2022-11-03T04:36:31.000Z	4852150300504740133619	0x99a274134c7744a09e3ede0728d4666794e085f5133498a4e2dec19c6d55272c	92191220591641083
0xf7b5965f5c117eb1b5450187c9dcfccc3c317e8e	false	0x052463c5b558f273b69f5d831603a815ae4eea41	3	0x052463c5b558f273b69f5d831603a815ae4eea41	33863538	9000000000000000000	2022-11-03T04:14:28.000Z	4921108939695033583142	0x4cd5566b03544e02c30af7585008a6e6e5725e14c4cc51f09322aa50eefd4947	69059407970396706509
0xf7b5965f5c117eb1b5450187c9dcfccc3c317e8e	false	0x052463c5b558f273b69f5d831603a815ae4eea41	3	0x052463c5b558f273b69f5d831603a815ae4eea41	33824344	10000000000000000000	2022-11-03T00:47:41.000Z	4947026630360267916104	0xfa283ba376aa8aab871c0f4cd93c3b2fccd5197e351b58bbe38770946aedb9fa	95057993069093025278

Example Query

Query with partition filter

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

sowstETH_AccrueInterest_event

Interest accrual events for the soWSTETH lending market on Sonne Finance (Optimism), tracking borrow index updates, total borrows, available cash, and accumulated interest. Used for calculating lending rates, market utilization, and borrower/lender yield analytics.

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
0x26aab17f27cd1c8d06a0ad8e4a1af8b1032171d5	false	86417210	3463582395698509861747	1012893937264157299	2023-04-05T10:04:55.000Z	1386570283237258299129	0x396c5ec1f7c0ab243c70aa9569a173e81cc82b219d08b178c630af24bb6f8bc4	728481483768470
0x26aab17f27cd1c8d06a0ad8e4a1af8b1032171d5	false	86521426	3464025775293648092458	1012969365649662390	2023-04-05T16:33:32.000Z	1475024401504018626088	0x4014b0b244aa9e9c08d31c8540922421fc1a5aa071551912861a62f5b660e3ae	520514548103544
0x26aab17f27cd1c8d06a0ad8e4a1af8b1032171d5	false	86417894	3463688720771288061747	1012894421036079575	2023-04-05T10:07:25.000Z	1386570945482086326192	0x504c2bb3002e396f77211180544d028a10ea71589e2a25ee03b8fde503f594dd	662244828027063

Example Query

Query with partition filter

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

sowstETH_Borrow_event

Borrow event records from Sonne Finance’s wstETH (Wrapped Staked ETH) lending market on Optimism. Tracks individual borrow transactions with amounts borrowed, cumulative account borrows, and total protocol borrows 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_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
0x26aab17f27cd1c8d06a0ad8e4a1af8b1032171d5	false	3	0xfa25c651ae3ceaa04390ce0762891de6cad1b258	79239538	2023-03-08T11:05:01.000Z	16819976827472737071	1984687662718502215528	0xefb7474af76e6d0650e34c3aec63b6821e534642f981b045c5f2ca3f0cede346	266254929800541479010
0x26aab17f27cd1c8d06a0ad8e4a1af8b1032171d5	false	13	0xfa25c651ae3ceaa04390ce0762891de6cad1b258	79334506	2023-03-08T19:38:31.000Z	3712798330503487103	1994476067528989786808	0xed7d189547dc5fe8c017efd9e579ec1d1436f93a51f5fe53088f3b112c643555	270004965938580814699
0x26aab17f27cd1c8d06a0ad8e4a1af8b1032171d5	false	12	0xfa25c651ae3ceaa04390ce0762891de6cad1b258	79230407	2023-03-08T10:09:30.000Z	28037157602414852702	1967838300244163258235	0xe923824371b2762bf38fd6be0b74e242b786418a6006e95ead3d4d162945cf9f	249431228226991192720

Example Query

Query with partition filter

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

sowstETH_Mint_event

Mint events from Sonne Finance’s wrapped staked ETH (wstETH) market on Optimism, recording when users supply wstETH collateral to receive soWSTETH tokens. Tracks minter addresses, underlying wstETH amounts deposited, and soWSTETH tokens minted 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
0x26aab17f27cd1c8d06a0ad8e4a1af8b1032171d5	false	0x0344c4f9985c85877d284bea8ea3df13498af96c	12	115042443	253714000000000000	1252834383	2024-01-19T17:01:03.000Z	0x84d90302359df0ef32e4e2c10e233d5961dfa495a120ca07f02ca22c6a479872
0x26aab17f27cd1c8d06a0ad8e4a1af8b1032171d5	false	0x12d15e0b690c7e198b318b3bf7c00526e38c9676	62	115047546	182177253153527	899585	2024-01-19T19:51:09.000Z	0x40863ec6b64b42ec6b80899919fa915d23662b884bfbb2e84122d8e0c3a0acdf
0x26aab17f27cd1c8d06a0ad8e4a1af8b1032171d5	false	0x12d15e0b690c7e198b318b3bf7c00526e38c9676	53	115047546	1614278485347889388	7971256679	2024-01-19T19:51:09.000Z	0x40863ec6b64b42ec6b80899919fa915d23662b884bfbb2e84122d8e0c3a0acdf

Example Query

Query with partition filter

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

sowstETH_NewReserveFactor_event

Reserve factor update events for Sonne Finance’s wstETH lending market on Optimism, tracking changes to the protocol’s reserve allocation percentage. Used for monitoring governance parameter changes and protocol revenue adjustments 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_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
0x26aab17f27cd1c8d06a0ad8e4a1af8b1032171d5	false	2	75630694	2023-02-20T21:41:28.000Z	0xab79ea2c02980d85c0923fe5d5464286abf956a8ce42b16e99fb3092a69e4ac6	180000000000000000	0

Example Query

Query with partition filter

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

sowstETH_Redeem_event

Redeem events from Sonne Finance’s wrapped stETH (Wrapped Staked ETH) lending market on Optimism, recording when users withdraw their underlying stETH tokens by burning soWSTETH tokens. Tracks redemption amounts in both token units and underlying asset values for analyzing lending market withdrawals and liquidity.

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
0x26aab17f27cd1c8d06a0ad8e4a1af8b1032171d5	false	6	0x848ac158d4af8a753227ad4e955a6ea3b0cbf480	116226746	2024-02-16T02:57:49.000Z	2700000000000000000	13324719463	0xdb9a7da8a53b17546a90eb1eee4a9f0357563b1003009740a93902a79f273724
0x26aab17f27cd1c8d06a0ad8e4a1af8b1032171d5	false	28	0xdc22dc0aa3f56c97a72e71f76c20018d7d9dcbf6	116242245	2024-02-16T11:34:27.000Z	0	0	0x24f902ec2038998acac33fbd0268dba00e0cf935e485c4a0b688ac7c017fd0e4
0x26aab17f27cd1c8d06a0ad8e4a1af8b1032171d5	false	20	0xdc22dc0aa3f56c97a72e71f76c20018d7d9dcbf6	116251269	2024-02-16T16:35:15.000Z	0	0	0x303641a3260952de63a2a4e211dc04253faad6ee022bb9320e3678ce0251ee4f

Example Query

Query with partition filter

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

sowstETH_RepayBorrow_event

Borrow repayment events from the Sonne Finance wstETH lending market on Optimism. Tracks individual debt repayments with payer, borrower, repayment amounts, and updated total borrows for analyzing deleveraging activity and market health.

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
0x26aab17f27cd1c8d06a0ad8e4a1af8b1032171d5	false	0x9f620ccbcb854f15575bcefffc41dac3173f2b48	3	0x9f620ccbcb854f15575bcefffc41dac3173f2b48	93353523	711850075820434509	2023-04-23T00:37:01.000Z	1313999479210632155970	0xacdde79102943989b9cf81ca4ab0b8fa34178ed6c389ba0a11ff2f71fb135b1a	0
0x26aab17f27cd1c8d06a0ad8e4a1af8b1032171d5	false	0x9f620ccbcb854f15575bcefffc41dac3173f2b48	3	0x9f620ccbcb854f15575bcefffc41dac3173f2b48	93556915	207623435408082059	2023-04-23T14:18:57.000Z	1313160543786902490156	0xbef39c33b18f19845d7fbf383f7ab7cb17207b82b42f3ea3b2be4b2349d68f35	0
0x26aab17f27cd1c8d06a0ad8e4a1af8b1032171d5	false	0x9f620ccbcb854f15575bcefffc41dac3173f2b48	3	0x9f620ccbcb854f15575bcefffc41dac3173f2b48	93556675	327359104509992726	2023-04-23T14:17:41.000Z	1313367889346099944892	0xa523e37a52abdd087e4196dc0814590bd879406d50828084aa0897b406fa4336	207623391480099862

Example Query

Query with partition filter

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

WrappedExternalBribe_NotifyReward_event

External bribe reward notifications from Sonne Finance’s veToken voting system on Optimism, tracking token incentives distributed to voters for specific epochs. Used for analyzing vote incentivization patterns and reward distribution in DeFi governance.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
`in_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_from	removed	in_epoch	in_amount	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x6863508158816dd12bd0801db043f14316b92414	0xb3c4e449390ada7985501cf326885bd1083bc79e	false	1677110400	10000000000000000000000	0x3c8b650257cfb5f272f799f5e2b4e65093a11a05	1	76971481	2023-02-25T10:58:54.000Z	0xa20ce3a8ca4f7eb2e21d08a7b6a756a746633c6a9c3fd3b6a142c8d53264a7cb
0x6863508158816dd12bd0801db043f14316b92414	0xfb59ce8986943163f14c590755b29db2998f2322	false	1681948800	118594000000000000000000	0x1db2466d9f5e10d7090e7152b68d62703a2245f0	1	93617153	2023-04-23T18:50:24.000Z	0xe08f3334fda9bc66c2e63d4c6e8a308a2dd962fe2faac4cef6a3280f674264eb
0x6863508158816dd12bd0801db043f14316b92414	0xb074ec6c37659525eef2fb44478077901f878012	false	1686787200	559200000000000000000	0x4200000000000000000000000000000000000042	34	105856345	2023-06-21T01:37:47.000Z	0x050cd0ed61458106c3693fbddd603a3af313bd725221fe2da18b99ff53f31364

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

​Tables

​Comptroller_DistributedBorrowerComp_event

​Comptroller_DistributedSupplierComp_event

​soDAI_AccrueInterest_event

​soDAI_Borrow_event

​soDAI_Mint_event

​soDAI_NewReserveFactor_event

​soDAI_Redeem_event

​soDAI_RepayBorrow_event

​soLUSD_AccrueInterest_event

​soLUSD_Borrow_event

​soLUSD_Mint_event

​soLUSD_NewReserveFactor_event

​soLUSD_Redeem_event

​soLUSD_RepayBorrow_event

​soOP_AccrueInterest_event

​soOP_Borrow_event

​soOP_Mint_event

​soOP_NewReserveFactor_event

​soOP_Redeem_event

​soOP_RepayBorrow_event

​soSNX_AccrueInterest_event

​soSNX_Borrow_event

​soSNX_Mint_event

​soSNX_NewReserveFactor_event

​soSNX_Redeem_event

​soSNX_RepayBorrow_event

​soSUSD_AccrueInterest_event

​soSUSD_Borrow_event

​soSUSD_Mint_event

​soSUSD_NewReserveFactor_event

​soSUSD_Redeem_event

​soSUSD_RepayBorrow_event

​soUSDC_AccrueInterest_event

​soUSDC_Borrow_event

​soUSDC_Mint_event

​soUSDC_NewReserveFactor_event

​soUSDC_Redeem_event

​soUSDC_RepayBorrow_event

​soUSDT_AccrueInterest_event

​soUSDT_Borrow_event

​soUSDT_Mint_event

​soUSDT_NewReserveFactor_event

​soUSDT_Redeem_event

​soUSDT_RepayBorrow_event

​soWBTC_AccrueInterest_event

​soWBTC_Borrow_event

​soWBTC_Mint_event

​soWBTC_NewReserveFactor_event

​soWBTC_Redeem_event

​soWBTC_RepayBorrow_event

​soWETH_AccrueInterest_event

​soWETH_Borrow_event

​soWETH_Mint_event

​soWETH_NewReserveFactor_event

​soWETH_Redeem_event

​soWETH_RepayBorrow_event

​sowstETH_AccrueInterest_event

​sowstETH_Borrow_event

​sowstETH_Mint_event

​sowstETH_NewReserveFactor_event

​sowstETH_Redeem_event

​sowstETH_RepayBorrow_event

​WrappedExternalBribe_NotifyReward_event

Tables

Comptroller_DistributedBorrowerComp_event

Comptroller_DistributedSupplierComp_event

soDAI_AccrueInterest_event

soDAI_Borrow_event

soDAI_Mint_event

soDAI_NewReserveFactor_event

soDAI_Redeem_event

soDAI_RepayBorrow_event

soLUSD_AccrueInterest_event

soLUSD_Borrow_event

soLUSD_Mint_event

soLUSD_NewReserveFactor_event

soLUSD_Redeem_event

soLUSD_RepayBorrow_event

soOP_AccrueInterest_event

soOP_Borrow_event

soOP_Mint_event

soOP_NewReserveFactor_event

soOP_Redeem_event

soOP_RepayBorrow_event

soSNX_AccrueInterest_event

soSNX_Borrow_event

soSNX_Mint_event

soSNX_NewReserveFactor_event

soSNX_Redeem_event

soSNX_RepayBorrow_event

soSUSD_AccrueInterest_event

soSUSD_Borrow_event

soSUSD_Mint_event

soSUSD_NewReserveFactor_event

soSUSD_Redeem_event

soSUSD_RepayBorrow_event

soUSDC_AccrueInterest_event

soUSDC_Borrow_event

soUSDC_Mint_event

soUSDC_NewReserveFactor_event

soUSDC_Redeem_event

soUSDC_RepayBorrow_event

soUSDT_AccrueInterest_event

soUSDT_Borrow_event

soUSDT_Mint_event

soUSDT_NewReserveFactor_event

soUSDT_Redeem_event

soUSDT_RepayBorrow_event

soWBTC_AccrueInterest_event

soWBTC_Borrow_event

soWBTC_Mint_event

soWBTC_NewReserveFactor_event

soWBTC_Redeem_event

soWBTC_RepayBorrow_event

soWETH_AccrueInterest_event

soWETH_Borrow_event

soWETH_Mint_event

soWETH_NewReserveFactor_event

soWETH_Redeem_event

soWETH_RepayBorrow_event

sowstETH_AccrueInterest_event

sowstETH_Borrow_event

sowstETH_Mint_event

sowstETH_NewReserveFactor_event

sowstETH_Redeem_event

sowstETH_RepayBorrow_event

WrappedExternalBribe_NotifyReward_event