> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# silo_v1_optimism

> Tables in tt-contracts.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.

<Accordion title="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.                      |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.silo_v1_optimism.Silo_Borrow_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.             |
</Accordion>

<Accordion title="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              |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.silo_v1_optimism.Silo_Deposit_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                      |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.silo_v1_optimism.Silo_Repay_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.             |
</Accordion>

<Accordion title="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              |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.silo_v1_optimism.Silo_Withdraw_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                         |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.silo_v1_optimism.SiloFactory_NewSiloCreated_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                      |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.silo_v1_optimism.SiloIncentivesController_RewardsClaimed_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***