silo_v2_sonic

Tables

Silo1_Borrow_event

Borrow events from Silo v2 lending protocol containing borrower address, borrowed asset amounts, share quantities, and recipient information. Used for tracking debt positions and leverage activity across lending markets.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0x016c306e103fbf48ec24810d078c65ad13c5f11b	false	0x92b36b43ca5beab1dda4abfebfb6b6b741bd3859	2327432719999999999416	0x92b36b43ca5beab1dda4abfebfb6b6b741bd3859	2291363326125531303670	48	0x92b36b43ca5beab1dda4abfebfb6b6b741bd3859	31675186	2025-06-03T23:25:21.000Z	0x3f2db22d981e80893171cb254be37a0ad138577414e9b0ae70c2f27c2da600a7
0x016c306e103fbf48ec24810d078c65ad13c5f11b	false	0x92b36b43ca5beab1dda4abfebfb6b6b741bd3859	195450449300188507593	0x92b36b43ca5beab1dda4abfebfb6b6b741bd3859	192425453880215692501	77	0x92b36b43ca5beab1dda4abfebfb6b6b741bd3859	31650276	2025-06-03T20:41:32.000Z	0xdc7fe64e86422b72413cdfb7a67c8ef99edca1a90bd7f52bd67cd45dbee9c72c
0x016c306e103fbf48ec24810d078c65ad13c5f11b	false	0x92b36b43ca5beab1dda4abfebfb6b6b741bd3859	15975274936283301960	0x92b36b43ca5beab1dda4abfebfb6b6b741bd3859	15730302598857792406	84	0x92b36b43ca5beab1dda4abfebfb6b6b741bd3859	31477834	2025-06-03T03:06:49.000Z	0x1be860773930dccf614937767b07acd986f02b349a5a7653f84bb5618d830642

Example Query

Query with partition filter

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

Silo1_Deposit_event

Deposit events from Silo v2 lending protocol contracts recording asset contributions and corresponding share allocations. Contains sender address, owner address, deposited asset amounts, and minted share quantities for tracking protocol liquidity 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x016c306e103fbf48ec24810d078c65ad13c5f11b	false	0x00dd13e8940de56da13ac5d86f7f58fa8f0ee53e	14345381252425182210	0x00dd13e8940de56da13ac5d86f7f58fa8f0ee53e	14271906588263532014778	19	20151216	2025-04-14T09:02:07.000Z	0x4fef3d97ef61f84ddf59072e717af10fd064adee069b17a0815e6021c9da3ac0
0x016c306e103fbf48ec24810d078c65ad13c5f11b	false	0x3967d78660bcbc95c625d58a40c42ce10bd905d6	2214000000000000000000	0x22aacdec57b13911de9f188cf69633cc537bdb76	2202684387656715366215228	46	20137307	2025-04-14T07:25:36.000Z	0xce40375ccab7625ca530b342084bcf1dd947ca4b139389fc797d39be9c402653
0x016c306e103fbf48ec24810d078c65ad13c5f11b	false	0x5526b05219cec263d41289d217fb87f7fdafbd96	1000000000000000000	0x22aacdec57b13911de9f188cf69633cc537bdb76	994859910504772040898	5	20180417	2025-04-14T12:08:49.000Z	0x7fa961471a6b546e41cdd378f913b70192509ccf1416564ea91f1fec7119c940

Example Query

Query with partition filter

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

Silo1_Repay_event

Loan repayment events from Silo Finance v2 lending protocol containing borrower address, repaid asset amounts, and corresponding debt share reductions. Used for tracking debt reduction activity and calculating repayment flows in lending markets.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x2f5dc399b1e31f9808d1ef1256917abd2447c74f	false	0x31d90934f202aa708ffc094b0658e35121a0af91	1013173945	0x9fa3c1e843d8eb1387827e5d77c07e8bb97b1e50	984243152	48	42573879	2025-08-11T22:27:02.000Z	0x405d5d87ddcc24b1f591a4ac9ff8aab77ebb391df699d058f97041a7e3fdd2cc
0xa18a8f100f2c976044f2f84fae1ee9f807ae7893	false	0xf2e4a05cbae83fb3173becee7a31686e8a6ae3ce	11151141	0x9fa3c1e843d8eb1387827e5d77c07e8bb97b1e50	10565190	73	42576694	2025-08-11T22:55:04.000Z	0xa9cc39c902207658e6eb29198746e1565c81631f6d09e6844a69bc142f8ea3e7
0x47d8490be37adc7af053322d6d779153689e13c1	false	0x752f44dba6c9afcfaaec26f90814411979b5b82f	114000000000000000000	0x9fa3c1e843d8eb1387827e5d77c07e8bb97b1e50	109727778095356789929	69	42576795	2025-08-11T22:56:18.000Z	0x3a1535088e0fd74722cf802b13d0dedf0dccd220319610861c80ca0e925a9565

Example Query

Query with partition filter

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

Silo1_Withdraw_event

Withdrawal events from Silo Protocol version 1 vaults recording asset redemptions from lending positions. Tracks sender, owner, receiver addresses along with withdrawn asset amounts and corresponding share quantities for position reconciliation.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0x112380065a2cb73a5a429d9ba7368cc5e8434595	false	0x048c8b5b66df058b2660f46e9875b6775ce8c3a5	1103756213732523072639	0x048c8b5b66df058b2660f46e9875b6775ce8c3a5	1099473778767987466254298	3	0x048c8b5b66df058b2660f46e9875b6775ce8c3a5	8223460	2025-02-17T06:10:33.000Z	0xef950a29e53069d7803a70ec4ed0652b2a0ddad543d33b652752622971cdb8ba
0x112380065a2cb73a5a429d9ba7368cc5e8434595	false	0x135e26611ec5858d630b21caff15e02c777abffa	3855335768560462428253	0x135e26611ec5858d630b21caff15e02c777abffa	3840195528634157472587082	3	0x135e26611ec5858d630b21caff15e02c777abffa	8253062	2025-02-17T10:41:18.000Z	0xd61d4afbb930d26ccb4d5f5a129249bf3b4da1e54f8b9248869891e7393dc415
0x112380065a2cb73a5a429d9ba7368cc5e8434595	false	0x2a318be0876a44e95fb9433359e2487914e1b42d	39393000000000000000000	0x2a318be0876a44e95fb9433359e2487914e1b42d	39235382092944375385981265	3	0x2a318be0876a44e95fb9433359e2487914e1b42d	8315230	2025-02-17T18:07:16.000Z	0x04be3268bb433ef75acd11a5154128f0cc4e7d4a6f2b4be2fb11a1070da72fa5

Example Query

Query with partition filter

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

Silo1_WithdrawnFees_event

Fee withdrawal events from Silo V2 protocol contracts recording DAO and deployer fee amounts. Contains fee distribution data split between DAO treasury and protocol deployers, with redirection flag indicating alternate deployer fee routing.

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_daoFees`	`STRING`	Amount of fees allocated to the DAO (Decentralized Autonomous Organization). Numeric string representing the fee value in the smallest unit of the token.
`in_deployerFees`	`STRING`	Amount of fees allocated to the protocol deployer. Numeric string representing the fee value in the smallest unit of the token.
`in_redirectedDeployerFees`	`BOOL`	Boolean flag indicating whether deployer fees were redirected to an alternative recipient.

Sample Data

address	removed	log_index	in_daoFees	block_number	block_timestamp	transaction_hash	in_redirectedDeployerFees
0x61ffbead1d4dc9ffba35eb16fd6cadee9b37b2aa	false	3	5174284636	51712389	2025-10-24T03:12:53.000Z	0xb4f622d9b3c67f3310287175ec645b3731ce9cdaec3647af1fbdfa8892c7c836	false
0x6dcac46c125e3f6c9fcdda31c1739022626a7b52	false	106	121036	48946037	2025-10-01T08:33:38.000Z	0x2476a5f8a71ca78c1395253a07656a5a16679712fd0174e55cf63298eef43905	false
0xaf1bdae843d90c546de5001f7b107b46e1a26aa9	false	130	15450945207804742116	48946037	2025-10-01T08:33:38.000Z	0x2476a5f8a71ca78c1395253a07656a5a16679712fd0174e55cf63298eef43905	false

Example Query

Query with partition filter

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

SiloFactory_NewSilo_event

Silo lending market deployment events emitted when new isolated lending pairs are created via the SiloFactory contract. Contains addresses of the two silo contracts (in_silo0, in_silo1), their collateral token pairs (in_token0, in_token1), implementation contract, and configuration settings.

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_implementation`	`STRING`	Contract address of the implementation contract. Hex-encoded, 0x-prefixed, 42-character string.
`in_token0`	`STRING`	Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_token1`	`STRING`	Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_silo0`	`STRING`	Contract address of the first silo in the pair created by the factory. Hex-encoded, 0x-prefixed, 42-character string.
`in_silo1`	`STRING`	Contract address of the second silo in the pair created by the factory. Hex-encoded, 0x-prefixed, 42-character string.
`in_siloConfig`	`STRING`	Contract address of the silo configuration contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_silo0	in_silo1	in_token0	in_token1	log_index	block_number	in_siloConfig	block_timestamp	transaction_hash	in_implementation
0xa42001d6d2237d2c74108fe360403c4b796b7170	false	0x5dfc90275f1f5e04654884532f0fed66bf6d0c07	0x46d2249ed33a2ce6603ab1ce1b33ea2c244b0e86	0xe715cba7b5ccb33790cebff1436809d36cb17e57	0x29219dd400f2bf60e5a23d13be72b486d4038894	52	25070988	0xae5a3b4f482c7dbb219e4ae3e5bb975de3a28d56	2025-05-07T19:00:20.000Z	0xae8354803bfb1ccd3d51c74963718c34c3bbc90eb5cd16361a4fac389c4755f5	0xcfbebcf6bc36f631cbb1011633ffc014db3db22d
0xa42001d6d2237d2c74108fe360403c4b796b7170	false	0x558d6d6d53270ae8ba622daf123983d9f3c21792	0xe6605932e4a686534d19005bb9db0fba1f101272	0x930441aa7ab17654df5663781ca0c02cc17e6643	0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae	14	14850125	0xda6787a3543a01bf770ddf3953be5b9c99c1cbd0	2025-03-20T14:47:18.000Z	0x2f566c78812d7ee52fb977d84185b4f5bd015eaae30faefb2c5e97f6f0da3dfb	0xcfbebcf6bc36f631cbb1011633ffc014db3db22d
0xa42001d6d2237d2c74108fe360403c4b796b7170	false	0x21580de05c4f3d6d6a5345b03a898c33b872ab51	0x016c306e103fbf48ec24810d078c65ad13c5f11b	0xfa85fe5a8f5560e9039c04f2b0a90de1415abd70	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	9	6421625	0x6bdf0d12d4b534d5f46c53a90dddfbe6c0e85dc7	2025-02-03T16:22:41.000Z	0x11477941e2446882a37864df26a75ad36b90fdd67dd0b8a3a6622854603d0032	0xcfbebcf6bc36f631cbb1011633ffc014db3db22d

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Silo1_Borrow_event

Silo1_Deposit_event

Silo1_Repay_event

Silo1_Withdraw_event

Silo1_WithdrawnFees_event

SiloFactory_NewSilo_event

​Tables

​Silo1_Borrow_event

​Silo1_Deposit_event

​Silo1_Repay_event

​Silo1_Withdraw_event

​Silo1_WithdrawnFees_event

​SiloFactory_NewSilo_event

Tables

Silo1_Borrow_event

Silo1_Deposit_event

Silo1_Repay_event

Silo1_Withdraw_event

Silo1_WithdrawnFees_event

SiloFactory_NewSilo_event