silo_v2_ethereum

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
0x4ef4dc9def84e3cc54d7a4aa95877fbd4add36c1	false	0xeb80e76443c1bfa85df46075f52a43ae1572003a	13387000000	0xeb80e76443c1bfa85df46075f52a43ae1572003a	13386999157	34	0xeb80e76443c1bfa85df46075f52a43ae1572003a	22753631	2025-06-21T15:08:23.000Z	0x4cbb10967180f426030a1f116e76e1400a345e63a7e86e0c77c1441dbfa03aaf
0x4ef4dc9def84e3cc54d7a4aa95877fbd4add36c1	false	0xeb80e76443c1bfa85df46075f52a43ae1572003a	16617000000	0xeb80e76443c1bfa85df46075f52a43ae1572003a	16616999649	271	0xeb80e76443c1bfa85df46075f52a43ae1572003a	22753580	2025-06-21T14:57:59.000Z	0x93993bc5ad3e615a25b0617ed5b46f14fcce35a35aa066aca5f15a178194b4d8
0x4ef4dc9def84e3cc54d7a4aa95877fbd4add36c1	false	0xeb80e76443c1bfa85df46075f52a43ae1572003a	18630000000	0xeb80e76443c1bfa85df46075f52a43ae1572003a	18630000000	132	0xeb80e76443c1bfa85df46075f52a43ae1572003a	22753520	2025-06-21T14:45:47.000Z	0x4083ecfb1b2ccbe5a8a337d5bc6e729de64625a21540427a12b3724484b85103

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.silo_v2_ethereum.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
0xce6ab1c71981e79cd30052c521c162674251018a	false	0x62a4a8f9f5f3aae9ee9cee780285a0d501c12d09	10000000	0xedb5176a3e624abbad4ccd91ec71c633cbf7ada0	10000000000	320	22720205	2025-06-16T22:57:35.000Z	0x714af34a746f9fb0e9e59fe13cc2024f7f9527e608e93b230c695a343ac367f9
0x357b9ed947f738af41ef88e8952bf5d91ba3f659	false	0x62a4a8f9f5f3aae9ee9cee780285a0d501c12d09	10000000	0xedb5176a3e624abbad4ccd91ec71c633cbf7ada0	10000000000	315	22720205	2025-06-16T22:57:35.000Z	0x00e54b7ca7f8cb20cf8213892ee56da8dfbce833a74b450ccebe8930774add30
0x7a45ed757ffe34f375187d9cdaa77c4ab75b65cc	false	0x62a4a8f9f5f3aae9ee9cee780285a0d501c12d09	10000000	0xedb5176a3e624abbad4ccd91ec71c633cbf7ada0	10000000000	273	22720206	2025-06-16T22:57:47.000Z	0xf456102662951364a5f67c5a2b43305787d4765454ee6c4056df2e28b8f43cf3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.silo_v2_ethereum.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
0x160287e2d3fdcde9e91317982fc1cc01c1f94085	false	0x791d1ec51d931186c1d4b80e753b7155dd98f741	3211356155724939	0x024b641f3582f5842714a8fd25d62be536560a6f	3211229097994678	251	22775729	2025-06-24T17:18:23.000Z	0xb3e93831726a917ea6c29a40d646cba9698e42f496198063cbe1cb144fc4cb2c
0x160287e2d3fdcde9e91317982fc1cc01c1f94085	false	0x60baf994f44dd10c19c0c47cbfe6048a4ffe4860	32079408564565805608	0x024b641f3582f5842714a8fd25d62be536560a6f	32072433672076549154	285	22790326	2025-06-26T18:12:23.000Z	0xe37c76f6380e6feb1fd39696b10596a1cc6df4af3b701f615d3be807f8f3ddd6
0x5e81803bff86c7073661c47436c4c3092a922c9d	false	0x9ef171a8c62eea6455830bde5de99db5a7ca5119	201782520	0x024b641f3582f5842714a8fd25d62be536560a6f	201607715	156	22800762	2025-06-28T05:11:59.000Z	0x6d3d06099c24f9922c09ebef92ad7dc90bff78ddfbbbe775688beb696f0b8164

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.silo_v2_ethereum.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
0x5ef340c8129fd7f6b7c8900df7c6558e164ef052	false	0x0d2bba9593b9477aa7171de303fb48b2bcd36d29	6000000000000000	0x0d2bba9593b9477aa7171de303fb48b2bcd36d29	6000000000000000000	169	0x0d2bba9593b9477aa7171de303fb48b2bcd36d29	22741193	2025-06-19T21:24:11.000Z	0x607dd5b2916fc7906c2cd30f00e2591eb94e61e6788f25d0f1fdf301439a833e
0x3c8a2750b6cfa89d79fc883a7ba7a86ec5c10693	false	0x62a4a8f9f5f3aae9ee9cee780285a0d501c12d09	10000000	0x62a4a8f9f5f3aae9ee9cee780285a0d501c12d09	10000000000	526	0x62a4a8f9f5f3aae9ee9cee780285a0d501c12d09	22741112	2025-06-19T21:07:59.000Z	0x0df05d0fb50cfcf0f9dfdc14b7113c3de663021266f724511b7720280dc51ded
0x50e9217e7f0845f9dd4cdaaed63a00fc73d5e5d2	false	0x62a4a8f9f5f3aae9ee9cee780285a0d501c12d09	10000000	0x62a4a8f9f5f3aae9ee9cee780285a0d501c12d09	10000000000	400	0x62a4a8f9f5f3aae9ee9cee780285a0d501c12d09	22741084	2025-06-19T21:02:11.000Z	0xcf68814f02743a8060e01d6984658b77e248e4a44331086efcd8045ffb586e12

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.silo_v2_ethereum.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
0x7d9d91b85b0de3ab74007803a601da8c1d277a3a	false	222	126272688	22816294	2025-06-30T09:19:35.000Z	0xcc638e0016443e3ccf3ebe5a7d5f5305b7d4f913841a1a9563442fb8e11465ed	false
0xf887b602a746f932f9bbcb6334d3407b7eec23ce	false	234	147459043	22816294	2025-06-30T09:19:35.000Z	0xcc638e0016443e3ccf3ebe5a7d5f5305b7d4f913841a1a9563442fb8e11465ed	false
0xd38d220b94e35e0ebc952437182f7f3244af97a9	false	230	126227601	22816294	2025-06-30T09:19:35.000Z	0xcc638e0016443e3ccf3ebe5a7d5f5305b7d4f913841a1a9563442fb8e11465ed	false

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.silo_v2_ethereum.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
0x22a3cf6149bfa611bafc89fd721918ec3cf7b581	false	0x62bea6195bd2aca8e2f967730d0a10d9ef4d29c1	0x8cfdd3d38be8f14437003a2c42d45ea72f30a4a8	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	100	22666642	0xba0fe6552fc15177005d4c2817db83cb21f00724	2025-06-09T11:12:11.000Z	0xec5c3ea70a4847cc8c10c075ce1a67b5b5a9fecd55e823876868bd51e3c49681	0xef1bc66e0ea9717a3f2c969633a989d6bf41024b
0x22a3cf6149bfa611bafc89fd721918ec3cf7b581	false	0x5da684d482b75d5ceb42a627b981486806087461	0xa1be362167103bd7c8b414897fd76c240fcf3537	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	22	22645535	0x63a7115ade21898c8bffd3c7bcf1f560eb0e8a5d	2025-06-06T12:25:47.000Z	0x864ab62a6ef66853e70aca3840f78dd1ecd4bcd2b3a7f681ce3a1803d38a4d49	0xef1bc66e0ea9717a3f2c969633a989d6bf41024b
0x22a3cf6149bfa611bafc89fd721918ec3cf7b581	false	0x1eb6cbe26ad0d6e0521b1414dd111f02b56ef936	0x16f3efb9a1b78913d0c5d803083746cd21c37e93	0x66a1e37c9b0eaddca17d3662d6c05f4decf3e110	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	75	22724516	0x8fffbde2e57713b073b9030c98ae3f26085bec91	2025-06-17T13:26:23.000Z	0x5924aa114a077c822aba6f0dc0edf7834fa8e4fe3fe19419a15c2e60bc62dd75	0xef1bc66e0ea9717a3f2c969633a989d6bf41024b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.silo_v2_ethereum.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