silo_v1_optimism

Tables

Silo_Borrow_event

Borrow transaction events from Silo Finance lending protocol on Optimism, recording user addresses, borrowed asset contracts, and borrow amounts. Used to analyze borrowing patterns, asset utilization, and user leverage activity across different Silo 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_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_asset	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x03d0b417b7bcd0c399f1db3321985353a515b2b8	0x03673e5131103e54b713f537554ae597c3edcf57	false	0x4200000000000000000000000000000000000006	266000000000000000	2	122122002	2024-07-01T14:06:21.000Z	0x0bfc22f0cb8f83e6ae259c6ed00e9fc98b41c199346a919207e8734fce63d791
0x03d0b417b7bcd0c399f1db3321985353a515b2b8	0xb37d9b6688cc192a8f117755458f3da006c26edd	false	0x4200000000000000000000000000000000000006	2960000000000000000	10	122120305	2024-07-01T13:09:47.000Z	0x9129bf90ed2ebf08a4a23318cd9a2b383412ac433fdeab687960a21945530324
0x03d0b417b7bcd0c399f1db3321985353a515b2b8	0xb37d9b6688cc192a8f117755458f3da006c26edd	false	0x4200000000000000000000000000000000000006	5810000000000000000	24	122109476	2024-07-01T07:08:49.000Z	0xea245f2eee5bcb4b830adb26e484a30ece545eb173b66f20891acee574af2035

Example Query

Query with partition filter

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

Silo_Deposit_event

Deposit events from Silo Finance lending markets on Optimism, capturing when users supply assets with depositor address, asset contract, amount, and collateral status. Used for tracking lending pool liquidity flows and user deposit behavior across different asset silos.

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_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_depositor`	`STRING`	Address of the user who initiated the deposit or cross-chain transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_collateralOnly`	`BOOL`	Boolean flag indicating whether the deposited or withdrawn asset is restricted to use as collateral only and cannot be borrowed against.

Sample Data

address	removed	in_asset	in_amount	log_index	block_number	in_depositor	block_timestamp	transaction_hash	in_collateralOnly
0x03d0b417b7bcd0c399f1db3321985353a515b2b8	false	0x0b2c639c533813f4aa9d7837caf62653d097ff85	73093441406	149	125203633	0x24a44aef48aeb27c7708dabfccda14b41fbf0ae1	2024-09-10T22:07:23.000Z	0x253788e042d763d4ac54d1e413306664f27a79cb61c811808afee1f5bdc0bead	false
0x03d0b417b7bcd0c399f1db3321985353a515b2b8	false	0x0b2c639c533813f4aa9d7837caf62653d097ff85	1001756844	112	125187234	0x869921f41af38fe397c8309d3d1885809508b723	2024-09-10T13:00:45.000Z	0x818db2adc8a3502ca0ef4420a165c3572c2e2ca8049766bfab31e94bfd96fa47	false
0x03d0b417b7bcd0c399f1db3321985353a515b2b8	false	0x0b2c639c533813f4aa9d7837caf62653d097ff85	1500977000	20	125178353	0x869921f41af38fe397c8309d3d1885809508b723	2024-09-10T08:04:43.000Z	0x0f66952d52b1f59f7a01831d1ad2d3895f00b725d91753c2e6622da075668092	false

Example Query

Query with partition filter

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

Silo_Repay_event

Loan repayment events from Silo Finance isolated lending markets on Optimism, capturing user addresses, repaid asset contracts, and repayment amounts. Used for analyzing debt paydown activity and borrower behavior across different Silo market deployments.

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_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_asset	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x03d0b417b7bcd0c399f1db3321985353a515b2b8	0x4a1b88c916aa34fec3210b88e31a248caac15535	false	0x0b2c639c533813f4aa9d7837caf62653d097ff85	202532067	24	126457546	2024-10-09T22:44:29.000Z	0x2af326ce14d2b6441e7680f37340f7c5c61057805a7cc130569845f37f1e3722
0x03d0b417b7bcd0c399f1db3321985353a515b2b8	0x4a1b88c916aa34fec3210b88e31a248caac15535	false	0x0b2c639c533813f4aa9d7837caf62653d097ff85	24688072	2	126457218	2024-10-09T22:33:33.000Z	0xe2795ffbc4beb9f765af2dd72df9986c434cd81edd5b1553f88f8f0f7249f6ed
0x12ee4be944b993c81b6840e088ba1dcc57f07b1d	0x949b365bddeb0a8a0add854f79b0472064c4f9c2	false	0x0b2c639c533813f4aa9d7837caf62653d097ff85	8532721	9	126433066	2024-10-09T09:08:29.000Z	0xdf93fbd5b8984912bb7015da9c40360bcf9e93afab32c568f104ccd26bb5803a

Example Query

Query with partition filter

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

Silo_Withdraw_event

Withdrawal events from Silo Finance lending protocol on Optimism, capturing asset withdrawals with depositor, receiver, amounts, and collateral status. Used for analyzing user withdrawal behavior and liquidity movements across different asset 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_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_depositor`	`STRING`	Address of the user who initiated the deposit or cross-chain transfer. 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_collateralOnly`	`BOOL`	Boolean flag indicating whether the deposited or withdrawn asset is restricted to use as collateral only and cannot be borrowed against.

Sample Data

address	removed	in_asset	in_amount	log_index	in_receiver	block_number	in_depositor	block_timestamp	transaction_hash	in_collateralOnly
0x03d0b417b7bcd0c399f1db3321985353a515b2b8	false	0x0b2c639c533813f4aa9d7837caf62653d097ff85	27278104755	442	0xc66d2a90c37c873872281a05445ec0e9e82c76a9	126761671	0x4e42acaec7379db6c9325b5b11f4bcd7f373652a	2024-10-16T23:41:59.000Z	0x4c941340d75fce23cf2ec97aca1aae2837bdf939dda9b28542b66f74e8edd8aa	false
0x03d0b417b7bcd0c399f1db3321985353a515b2b8	false	0x0b2c639c533813f4aa9d7837caf62653d097ff85	50000000	7	0xc66d2a90c37c873872281a05445ec0e9e82c76a9	126733552	0x45064c44d3e650176fb63ec25c27352e41d481f2	2024-10-16T08:04:41.000Z	0x8373c9981f6d6be1259ca49f511119dc282f3205a7ae87a0f8bf7e559be66806	false
0x03d0b417b7bcd0c399f1db3321985353a515b2b8	false	0x4200000000000000000000000000000000000006	17218582203856814813	348	0xc66d2a90c37c873872281a05445ec0e9e82c76a9	126748456	0x6dd8b1bd490e14bf3da72450d6d6112276ac986e	2024-10-16T16:21:29.000Z	0x08e886b5267963d6b5b1a9813adff05f054084f426b64aee870e17682efbc901	false

Example Query

Query with partition filter

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

SiloFactory_NewSiloCreated_event

Silo creation events from the Silo Finance v1 factory contract on Optimism, recording each new isolated lending market deployed for a specific collateral asset. Used to track the expansion of Silo’s isolated lending pools and identify which assets have dedicated Silo 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_silo`	`STRING`	Contract address of the Silo instance. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

address	in_silo	removed	in_asset	log_index	in_version	block_number	block_timestamp	transaction_hash
0x6b14c4450a29dd9562c20259ebff67a577b540b9	0x5a68c626c4e2c698ad89e1165d3242d97176ab6f	false	0x9e1028f5f1d5ede59748ffcee5532509976840e0	2	1	120684314	2024-05-29T07:23:25.000Z	0x4767522f13ef6f2a2f34cea79feac38691b0b1d0f73f079f39a6338b7ffee679
0x6b14c4450a29dd9562c20259ebff67a577b540b9	0x1ebf59146ccdc4650044fc70cafac298a6083f5f	false	0x1f32b1c2345538c0c6f582fcb022739c4a194ebb	4	1	120694508	2024-05-29T13:03:13.000Z	0x5995d1cbb067155753ad809e6d2b9915dc85f8925338064cf16317b75f977dbd
0x6b14c4450a29dd9562c20259ebff67a577b540b9	0x2039c051cdad90c9685dc932b5e35de2b525cc0f	false	0x5a7facb970d094b6c7ff1df0ea68d99e6e73cbff	114	1	121524307	2024-06-17T18:03:11.000Z	0x4a5a27f9b34f9905a54ab6858391b3243c56787a5a4594a1d5ac67a70dd861c8

Example Query

Query with partition filter

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

SiloIncentivesController_RewardsClaimed_event

Reward claim events from Silo Finance lending protocol on Optimism, capturing user incentive withdrawals with claimer address, recipient, and token amounts. Used for analyzing protocol incentive distribution and user reward harvesting 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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_claimer`	`STRING`	Address of the account initiating the claim transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_to	address	in_user	removed	in_amount	log_index	in_claimer	block_number	block_timestamp	transaction_hash
0x00005ff7b4e62b6b868d36809f8a30c85a6d0000	0x847d9420643e117798e803d9c5f0e406277cb622	0x00005ff7b4e62b6b868d36809f8a30c85a6d0000	false	39390164178370141005	63	0x00005ff7b4e62b6b868d36809f8a30c85a6d0000	122233292	2024-07-04T03:56:01.000Z	0x887e860118ab48b3922a71b18f376b15b316a5ba267f7db84c662cde88abdfc3
0x00005ff7b4e62b6b868d36809f8a30c85a6d0000	0x847d9420643e117798e803d9c5f0e406277cb622	0x00005ff7b4e62b6b868d36809f8a30c85a6d0000	false	38775506203526878145	90	0x00005ff7b4e62b6b868d36809f8a30c85a6d0000	122254795	2024-07-04T15:52:47.000Z	0x980f87a68671a61b8283106884349657c0a45722edcfb52bf37f120886b3330c
0x170b6ee0387762acb551310e817febe5f98157bd	0x847d9420643e117798e803d9c5f0e406277cb622	0x170b6ee0387762acb551310e817febe5f98157bd	false	12276658818217924131	66	0x170b6ee0387762acb551310e817febe5f98157bd	122231864	2024-07-04T03:08:25.000Z	0x83dd260e9459af713cc1ffbf856db5d8952e5af60948e3cc46ff87ac65f79105

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Silo_Borrow_event

Silo_Deposit_event

Silo_Repay_event

Silo_Withdraw_event

SiloFactory_NewSiloCreated_event

SiloIncentivesController_RewardsClaimed_event

​Tables

​Silo_Borrow_event

​Silo_Deposit_event

​Silo_Repay_event

​Silo_Withdraw_event

​SiloFactory_NewSiloCreated_event

​SiloIncentivesController_RewardsClaimed_event

Tables

Silo_Borrow_event

Silo_Deposit_event

Silo_Repay_event

Silo_Withdraw_event

SiloFactory_NewSiloCreated_event

SiloIncentivesController_RewardsClaimed_event