silo_v2_avalanche

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
0x1ce6845b2996e4b0dcba0af7daae5454e2c43f6a	false	0x5020c6eb0fe5321071942847b56349a68c7342dd	25000000000	0x5020c6eb0fe5321071942847b56349a68c7342dd	25000000000	10	0x5020c6eb0fe5321071942847b56349a68c7342dd	64462482	2025-06-25T19:17:44.000Z	0x39d7cad46bd531b4e826a6b0fc43a390174b0339d686731fcfe6daeb139ebe4a
0x1ce6845b2996e4b0dcba0af7daae5454e2c43f6a	false	0x5020c6eb0fe5321071942847b56349a68c7342dd	277583000000	0x5020c6eb0fe5321071942847b56349a68c7342dd	277580352586	6	0x5020c6eb0fe5321071942847b56349a68c7342dd	64467651	2025-06-25T21:24:43.000Z	0xdcac283771972e08ced1c9f1066b811aee8b8a7703f9aabea58c66e10894db05
0x1ce6845b2996e4b0dcba0af7daae5454e2c43f6a	false	0x5020c6eb0fe5321071942847b56349a68c7342dd	254086000000	0x5020c6eb0fe5321071942847b56349a68c7342dd	254083408597	4	0x5020c6eb0fe5321071942847b56349a68c7342dd	64467849	2025-06-25T21:30:43.000Z	0x8a97beaab532ffb0d264526c7658a3b9915e784d3e6149d81f063fd34599b11d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.silo_v2_avalanche.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
0x2ac4cb8a1754d54baca3a4d32adf7e3fa45d31ce	false	0x6508e3236423adb6c3e13285957431865e4108c2	5000000	0x4576fa3e2e061376431619b5631c25c99ffa27bd	5000000000	82	64131766	2025-06-19T19:48:52.000Z	0xf7aa8bb0365de6907db2371a61e8ac7648a3413811ced9614277e6486e573c9c
0x5510dcaa66d2683155d2d422d8013c1bb987a055	false	0xb247080599844fb79c95d5bed3f0b40685dd199f	10000000	0x4576fa3e2e061376431619b5631c25c99ffa27bd	10000000000	15	64233397	2025-06-21T13:56:36.000Z	0xbe1ed7b71ad70f6169cab0535e5b78d743e32b997d7441a3a15f8db563cbe45f
0x15b65209c8b513fcd06e80cefb5bf1181efcdca0	false	0xb247080599844fb79c95d5bed3f0b40685dd199f	10000000	0x4576fa3e2e061376431619b5631c25c99ffa27bd	10000000000	133	64233421	2025-06-21T13:57:09.000Z	0x533f61e82c0e704e95b69f8a4bbacf4b84b9b122283678d6a35f457023910525

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.silo_v2_avalanche.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
0x1ce6845b2996e4b0dcba0af7daae5454e2c43f6a	false	0x5020c6eb0fe5321071942847b56349a68c7342dd	393734423666	0x4576fa3e2e061376431619b5631c25c99ffa27bd	393663792600	12	64514306	2025-06-26T18:28:23.000Z	0x848989f8f1a91f74bb63f4eedb5ab8fa2d2e4111db27ff0706df40c97e7db472
0x1ce6845b2996e4b0dcba0af7daae5454e2c43f6a	false	0x5020c6eb0fe5321071942847b56349a68c7342dd	12948850677	0x4576fa3e2e061376431619b5631c25c99ffa27bd	12946514627	22	64514621	2025-06-26T18:35:09.000Z	0x2f26bc239031df11f984dfd5aa0177ae4a4a4efb933b07528df40277ffde3761
0x1ce6845b2996e4b0dcba0af7daae5454e2c43f6a	false	0xbce83d5060a7d7007fd7ca17301c1e5131b2d50e	26265486050	0x4576fa3e2e061376431619b5631c25c99ffa27bd	26263928603	18	64479545	2025-06-26T02:43:52.000Z	0xc153525e477b1e7adb563d0a937ca5378fdbad090bb5e98028ddfd364661a5b6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.silo_v2_avalanche.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
0x0faf5e53b8ec087f1719b97f5c09780f0aba5a9e	false	0x4dc1ce9b9f9ef00c144bfad305f16c62293dc0e8	19999927000	0x4dc1ce9b9f9ef00c144bfad305f16c62293dc0e8	19999927000000	17	0x4dc1ce9b9f9ef00c144bfad305f16c62293dc0e8	64455362	2025-06-25T16:27:03.000Z	0x011373f63c920fda7e462801dea3c848e2b492699aa336c91a3f5be8f8b61b3b
0x0faf5e53b8ec087f1719b97f5c09780f0aba5a9e	false	0x4dc1ce9b9f9ef00c144bfad305f16c62293dc0e8	21027312106	0x4dc1ce9b9f9ef00c144bfad305f16c62293dc0e8	21027312106000	17	0x4dc1ce9b9f9ef00c144bfad305f16c62293dc0e8	64455465	2025-06-25T16:30:02.000Z	0xd53e95589aab25e9acb0eb5a933050a99c1961ff316a206b734707f9cb0d49bc
0x15b65209c8b513fcd06e80cefb5bf1181efcdca0	false	0x4dc1ce9b9f9ef00c144bfad305f16c62293dc0e8	2181158168	0x4dc1ce9b9f9ef00c144bfad305f16c62293dc0e8	2181158168000	11	0x4dc1ce9b9f9ef00c144bfad305f16c62293dc0e8	64467563	2025-06-25T21:22:25.000Z	0x701a577bd6a5df09504b2b9db65d34cce570f685f3e6d79329ca0007be125204

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.silo_v2_avalanche.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
0xd1dd7f8affbdef3594d84245eadac0940d9394c3	false	114	1914875001	69584838	2025-10-01T08:25:42.000Z	0xf7b3ae307c8d14a17dc2ef8191b4aee3a1de47d8c9f6f95463f9d116dd0c6da8	false
0x9c4d4800b489d217724155399cd64d07eae603f3	false	110	852993948	69584838	2025-10-01T08:25:42.000Z	0xf7b3ae307c8d14a17dc2ef8191b4aee3a1de47d8c9f6f95463f9d116dd0c6da8	false
0x224c4a79f016ef09e3c9c0f187a3db24d1dc0f21	false	87	3233181194390055708	69584838	2025-10-01T08:25:42.000Z	0xf7b3ae307c8d14a17dc2ef8191b4aee3a1de47d8c9f6f95463f9d116dd0c6da8	false

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.silo_v2_avalanche.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
0x92cecb67ed267ff98026f814d813fdf3054c6ff9	false	0x0f2b1bdddcd29692169e2bdedfdacd2311aba951	0x1ce6845b2996e4b0dcba0af7daae5454e2c43f6a	0x06d47f3fb376649c3a9dafe069b3d6e35572219e	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	59	64174996	0x4b56f4be99fa320557860844d19af68b636de3ce	2025-06-20T13:28:15.000Z	0x1a65920ecbbc2fe657f0d1ef9dac34a7f1a006f22b35b8510a04a1a1412db163	0x2c7e816323b2e3894eb98d53b2cbec659ae26441
0x92cecb67ed267ff98026f814d813fdf3054c6ff9	false	0xd621624900c66373bbf0352a21204ad975e674d5	0x5510dcaa66d2683155d2d422d8013c1bb987a055	0xb57b25851fe2311cc3fe511c8f10e868932e0680	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	35	64159371	0xcf2a7db4fead6b38dcda7c3da665eedf98973716	2025-06-20T06:56:34.000Z	0x00c284f11fcdf3fff0697b32bf7afc7d61623d583f021ad74ef39495c1c93533	0x2c7e816323b2e3894eb98d53b2cbec659ae26441
0x92cecb67ed267ff98026f814d813fdf3054c6ff9	false	0xa487c4f2017a2d674302a70f8df4c0803ca3601a	0xd8a26dfeba3e9b558bd79d10722636dfb4dc2bf4	0x649342c6bff544d82df1b2ba3c93e0c22cdeba84	0x152b9d0fdc40c096757f570a51e494bd4b943e50	35	64157601	0x6137dc2e437747e51dd786a9f350063c6189cdeb	2025-06-20T06:14:41.000Z	0x08735890087b9ad44d3ed417948c31ae603418f270fe056d3e0a9658b8505d49	0x2c7e816323b2e3894eb98d53b2cbec659ae26441

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Silo1_Borrow_event

Silo1_Deposit_event

Silo1_Repay_event

Silo1_Withdraw_event

Silo1_WithdrawnFees_event

SiloFactory_NewSilo_event

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