silo_v2_arbitrum

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
0x2433d6ac11193b4695d9ca73530de93c538ad18a	false	0x6254c113eb743b13b7ca8d267c52c39ab9141db9	400000000000	0x6254c113eb743b13b7ca8d267c52c39ab9141db9	399805669833	14	0x6254c113eb743b13b7ca8d267c52c39ab9141db9	347800593	2025-06-16T01:59:49.000Z	0x76e45c779440a6606bba7eda1d3c5ac4087bd1f20b56ed649e80a9cdf16806e5
0x2433d6ac11193b4695d9ca73530de93c538ad18a	false	0x6254c113eb743b13b7ca8d267c52c39ab9141db9	1000000000000	0x6254c113eb743b13b7ca8d267c52c39ab9141db9	999302501259	41	0x6254c113eb743b13b7ca8d267c52c39ab9141db9	348161351	2025-06-17T03:05:59.000Z	0x0e823fa5fe1c96eda35d0e0249bc4b7990dedee2d777b7bd2f0180f45839af1d
0x86b1c293e56cbac04d9c15a1af2ef1d2050ff6cd	false	0x7545fdfb02adfc734811367fc06fa7dd5909d698	100020000	0x7545fdfb02adfc734811367fc06fa7dd5909d698	99893298	4	0x7545fdfb02adfc734811367fc06fa7dd5909d698	344490467	2025-06-06T11:16:55.000Z	0xa385fc3415839393a9b0340212a5e7a67fbda1e1f6707233ce3dc79fa89ec116

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.silo_v2_arbitrum.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
0x8a19707948e40b5c0b4a2de154afbf001a78e3bb	false	0xa521e425f37acc731651565b41ce3e5022274f4f	20000000	0xd039005e47fc31605192b6bcc1a4803a3abdf623	20000000000	10	343849016	2025-06-04T14:33:11.000Z	0x7ab29bff9631a4b65d9fb91c9521cec80833d12444b80e67a4288fcf754a4eb7
0x2433d6ac11193b4695d9ca73530de93c538ad18a	false	0x2ba39e5388ac6c702cb29aea78d52aa66832f1ee	16570664685	0x2ba39e5388ac6c702cb29aea78d52aa66832f1ee	16567546328742	13	347450450	2025-06-15T01:35:41.000Z	0xaf0a72581418e5c06c249f3019ae15665cbf82b74ef6c552ebd68fe21ff5b9a8
0x2433d6ac11193b4695d9ca73530de93c538ad18a	false	0x2ba39e5388ac6c702cb29aea78d52aa66832f1ee	2325082700	0x2ba39e5388ac6c702cb29aea78d52aa66832f1ee	2324549932617	13	347550704	2025-06-15T08:34:58.000Z	0x27894d4b594ab7d2c1d989cf7321d4cf90f05b9ac25ebb52c5662316fc4c0277

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.silo_v2_arbitrum.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
0x86b1c293e56cbac04d9c15a1af2ef1d2050ff6cd	false	0xc8842a6ae1fdeab2213821b5267d072547aa7a1f	5001901806	0xd039005e47fc31605192b6bcc1a4803a3abdf623	4985762604	6	347655809	2025-06-15T15:53:47.000Z	0x9cbaa8117567dbde49508326e26c14087245816669cfd37059d753ad47b29204
0x86b1c293e56cbac04d9c15a1af2ef1d2050ff6cd	false	0xc8842a6ae1fdeab2213821b5267d072547aa7a1f	5000000000	0xd039005e47fc31605192b6bcc1a4803a3abdf623	4984509337	7	347243605	2025-06-14T11:09:50.000Z	0x59de9d534d673904eef806ffc943a046c82610b1be82d652136ab4940e6ad817
0x86b1c293e56cbac04d9c15a1af2ef1d2050ff6cd	false	0x068cdf0b3c2f3949ae7f24016ba50ce58b8f1a14	200283032	0xd039005e47fc31605192b6bcc1a4803a3abdf623	199718196	15	346419622	2025-06-12T01:50:08.000Z	0x9fe99e51e1bc386980e36de8b24472f654cd96523dfb539f134bba9120993caa

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.silo_v2_arbitrum.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
0x65d5eebe8270237d6a257b7fa6c61f6078a7de96	false	0xdedcf5806c4968c6397eee97e68047bda339d0c1	5000000	0xdedcf5806c4968c6397eee97e68047bda339d0c1	5000000000	2	0xdedcf5806c4968c6397eee97e68047bda339d0c1	339687536	2025-05-23T12:24:29.000Z	0xa9365f606d49fee5d7783fee656d002b3700aa669c575ae65c9f05f648d136b0
0x2433d6ac11193b4695d9ca73530de93c538ad18a	false	0x2ba39e5388ac6c702cb29aea78d52aa66832f1ee	25000048004	0x2ba39e5388ac6c702cb29aea78d52aa66832f1ee	24977520364460	3	0x2ba39e5388ac6c702cb29aea78d52aa66832f1ee	349408831	2025-06-20T18:08:13.000Z	0xe737cdd5f998884fef679f9ff33febcac3b458623156f3272e3b69f54e7848db
0x2433d6ac11193b4695d9ca73530de93c538ad18a	false	0x2ba39e5388ac6c702cb29aea78d52aa66832f1ee	25000048355	0x2ba39e5388ac6c702cb29aea78d52aa66832f1ee	24977519869612	3	0x2ba39e5388ac6c702cb29aea78d52aa66832f1ee	349408927	2025-06-20T18:08:37.000Z	0x9442c9ede54fa96e820f5a4fab8f4ee47d46536001e7e20ede51b4934c3711b3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.silo_v2_arbitrum.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
0x2433d6ac11193b4695d9ca73530de93c538ad18a	false	29	32523256682	384880921	2025-10-01T08:17:43.000Z	0x2f39a8cd78407ff051f02e45bd915bf4556fb8809c250427f99fcb4034c3c9c6	false
0x3a52dd6fa7881fc6cd3da9a6e776ff748a2bc636	false	36	213140943276002695	384880921	2025-10-01T08:17:43.000Z	0x2f39a8cd78407ff051f02e45bd915bf4556fb8809c250427f99fcb4034c3c9c6	false
0xa9a4bd976dbcfc2b89f554467ac85e2c758e2618	false	59	16989832	384880921	2025-10-01T08:17:43.000Z	0x2f39a8cd78407ff051f02e45bd915bf4556fb8809c250427f99fcb4034c3c9c6	false

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.silo_v2_arbitrum.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
0x384dc7759d35313f0b567d42bf2f611b285b657c	false	0xed029b1624e50e5379499ca7ab6505c2b88d6017	0x66844c9bce0dae0edac29055ae5fe7bdb3dbb6ec	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0xaf88d065e77c8cc2239327c5edb3a432268e5831	12	336270178	0x9607783e0901ee781397d1a1bf407e5c1737b50d	2025-05-13T13:42:39.000Z	0x7e393e2d328c722e4b2f467ad85727314f94f6e0a345805f2fc5433b8f313351	0xc216dfac5e29eafc4ed826a3bb79db72e1ac2535
0x384dc7759d35313f0b567d42bf2f611b285b657c	false	0x174c493399aaa0a954578b00b83ed81aa0c6bcfe	0xab9c406559c8321b182de83be8204a1cc259d3f0	0xd3443ee1e91af28e5fb858fbd0d72a63ba8046e0	0xaf88d065e77c8cc2239327c5edb3a432268e5831	80	344466204	0xd10705eab606360147c022e4aea6470d9ec4efce	2025-06-06T09:35:22.000Z	0x844a90ee2165ef3c51ef2a38fc09852dc4c651c9c58e4cc02e123b0a7fd7bbfc	0x9b550bf0351986342959d4447c5851e570766238
0x384dc7759d35313f0b567d42bf2f611b285b657c	false	0x3dda706384597e8ce0f94c06e90c7ad900621685	0x942da67dfc79dee4aefaa1cfc30dee33937c0e1b	0x20d419a8e12c45f88fda7c5760bb6923cee27f98	0xaf88d065e77c8cc2239327c5edb3a432268e5831	12	344464393	0xc8ab9444d717fae2d66f7669fd3fb726f56b6341	2025-06-06T09:27:50.000Z	0x31fb9988c9112eb1d4665d9c9264aba06bb32c9dc26aacec58526e80a11915a7	0x9b550bf0351986342959d4447c5851e570766238

Example Query

Query with partition filter

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