silo_v1_arbitrum

Tables

SiloFactoryV1_NewSiloCreated_event

Silo creation events from the Silo V1 lending protocol factory contract on Arbitrum, capturing each new isolated lending market deployment with its associated collateral asset. Used for tracking Silo protocol expansion and analyzing which assets are being added as collateral 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
0x4166487056a922d784b073d4d928a516b074b719	0xf3fc3812360390f95dd4a57c6bc36498fb44d518	false	0x6c84a8f1c29108f47a79964b5fe888d4f4d0de40	0	1	186071414	2024-03-01T16:37:35.000Z	0x2b6305a0f63badebc524e9fd18b5b0c8d2d9a67a3d4e86a74e0dd998c12f4bef
0x4166487056a922d784b073d4d928a516b074b719	0x4b80a3b80471759bea54f9432ee36b50fe4f945b	false	0x894134a25a5fac1c2c26f1d8fbf05111a3cb9487	6	1	186071442	2024-03-01T16:37:42.000Z	0x138f2049e5617ff5559c721a51206f89d32fdd8d76d13bb8f45be7ff8d5d7c7b
0x4166487056a922d784b073d4d928a516b074b719	0x8922225135acbac6f49aaccc638a8fb79119795c	false	0x371c7ec6d8039ff7933a2aa28eb827ffe1f52f07	0	1	145512307	2023-10-30T20:14:28.000Z	0x466cfdb8564221b40db3ef22456879f1be7d83cb2b66f07342de0d4009445870

Example Query

Query with partition filter

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

SiloIncentivesControllerV1_RewardsClaimed_event

Incentive reward claim events from Silo Finance V1 lending protocol on Arbitrum, tracking when users collect protocol rewards with token amounts and recipient addresses. Used for analyzing reward distribution patterns and user participation in Silo’s incentive programs.

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
0x076a6faed850c0c2b270e7271a526cb26755f14d	0x4999873bf8741bfffb0ec242aaaa7ef1fe74fce8	0x076a6faed850c0c2b270e7271a526cb26755f14d	false	1005131798117708739710	58	0x076a6faed850c0c2b270e7271a526cb26755f14d	83005244	2023-04-22T04:44:12.000Z	0x51fdd7cfc1325b8f82b526e4fc288405ac2750e22140a47a8850f583e665b247
0x295d00c276a22db65c113e15bac40ad76ce9d7cf	0x4999873bf8741bfffb0ec242aaaa7ef1fe74fce8	0x295d00c276a22db65c113e15bac40ad76ce9d7cf	false	140990237600952895604	13	0x295d00c276a22db65c113e15bac40ad76ce9d7cf	82981636	2023-04-22T03:03:13.000Z	0x46be3ee80ba456e6875163b52e8eda99ef9b8124a5bc87c5a09e6302308e4ec8
0x4ce838b36263191b566fc62cbc71795e4fca3273	0x4999873bf8741bfffb0ec242aaaa7ef1fe74fce8	0x4ce838b36263191b566fc62cbc71795e4fca3273	false	294251205813580258193	60	0x4ce838b36263191b566fc62cbc71795e4fca3273	82939150	2023-04-22T00:00:24.000Z	0x244dc6c44c7d00ff393b1db06eaa72c2d16213842179d232d1b3604eb3741b5e

Example Query

Query with partition filter

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

SiloIncentivesControllerV2_RewardsClaimed_event

Incentive reward claims from Silo Finance v1 lending protocol on Arbitrum, capturing when users collect accumulated rewards with claim amounts and recipient addresses. Used for analyzing reward distribution patterns and user engagement with Silo’s incentive programs.

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
0x025baac62941e336d1b68739c058dfcb9db7c15a	0xd592f705bdc8c1b439bd4d665ed99c4faad5a680	0x025baac62941e336d1b68739c058dfcb9db7c15a	false	864574584320171693	4	0x025baac62941e336d1b68739c058dfcb9db7c15a	159190111	2023-12-11T22:31:50.000Z	0x7ce2fbde8a774ab07ad84444164c7d03aee367dbfcea298f2e3dfda399360a8d
0x025baac62941e336d1b68739c058dfcb9db7c15a	0xd592f705bdc8c1b439bd4d665ed99c4faad5a680	0x025baac62941e336d1b68739c058dfcb9db7c15a	false	661201384378711739	4	0x025baac62941e336d1b68739c058dfcb9db7c15a	159100463	2023-12-11T15:57:01.000Z	0x52cc4ac5f24b18ec122091b703434949729e036c38cf84cc759ea489092ad76b
0x025baac62941e336d1b68739c058dfcb9db7c15a	0xd592f705bdc8c1b439bd4d665ed99c4faad5a680	0x025baac62941e336d1b68739c058dfcb9db7c15a	false	2505242342784677342	4	0x025baac62941e336d1b68739c058dfcb9db7c15a	158885848	2023-12-11T00:25:35.000Z	0x2e6a97ff9f08ba589f4b49911fe492167edebf25da5aacdffa0ff349471067ba

Example Query

Query with partition filter

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

SiloV1_Borrow_event

Borrow event logs from Silo V1 lending protocol on Arbitrum, capturing each borrow transaction with borrowed asset address, user address, and amount. Used for analyzing borrowing patterns, utilization rates, and individual borrower behavior across 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
0x7e38a9d2c99caef533e5d692ed8a2ce4b478e585	0x3c117e12f407a295c693d613483e2fc39d1c2925	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	1010000	2	68696002	2023-03-11T01:12:23.000Z	0x5d516df45bf88180caa1f69869038a3660818dd782d2ef46e77acc711802c3bf
0x7e38a9d2c99caef533e5d692ed8a2ce4b478e585	0x7bba51bfce9c65422d9370e9d75ca266fb482d95	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	1070000	1	68936786	2023-03-11T20:05:10.000Z	0x6c78510d04e874c06f5cdadbfeb063968b37ed52e197f592f31fe14efec3da10
0x7e38a9d2c99caef533e5d692ed8a2ce4b478e585	0x93ff5e754c3d981de28a5b76764dc9f87c8bb647	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	1100000	1	68932236	2023-03-11T19:38:37.000Z	0xb7db6cbd21b511a07217e7c817955276feb876e225194ad6109d30f1715376b1

Example Query

Query with partition filter

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

SiloV1_Deposit_event

Deposit events from Silo Finance V1 lending protocol on Arbitrum, recording user deposits of assets into isolated lending markets with depositor addresses, asset addresses, amounts, and collateral-only flags. Used for analyzing lending activity, capital flows, and user behavior across Silo’s isolated market structure.

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
0xe5741b993dbee7b433c1cfd0c885bab901dd406d	false	0x004626a008b1acdc4c74ab51644093b155e59a23	1028949793498682977	4	245228376	0xf1e73f7d7656b9b00d970b58aab3bb19b5518060	2024-08-21T15:41:54.000Z	0x2686bbcb6fd3a47cffb83fe04397d0181cff01f71127ef915d92ca4b1cb9a6c0	false
0xc49b9cb9cce1448e2e5cef86b844980d74cefc64	false	0x02f92800f57bcd74066f5709f1daa1a4302df875	969381823082346326	10	245024186	0xced3fc4610761f79242d7d8a72fe86f3a1c626b4	2024-08-21T01:29:04.000Z	0x83c7a1bdfb01fc3f4efa1c2d9f6269476df5d0f28ef65091ed188a5d72fc874d	true
0xc49b9cb9cce1448e2e5cef86b844980d74cefc64	false	0x02f92800f57bcd74066f5709f1daa1a4302df875	440581050168638818	18	245010643	0xced3fc4610761f79242d7d8a72fe86f3a1c626b4	2024-08-21T00:32:24.000Z	0xcedc3294dc880ac0cbba760857b4fb47b6b0e95b5388ad4697febf66132a5d49	true

Example Query

Query with partition filter

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

SiloV1_Repay_event

Loan repayment events from Silo V1 lending protocol on Arbitrum, tracking when users repay borrowed assets with amount, asset address, and borrower details. Used for analyzing debt management patterns and protocol utilization across isolated 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_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
0xc0ab69fffeb5375235d8caa4f7218097bbcc0a0a	0xb1123f2622d89cc6d597def7354c32c54d450304	false	0x1622bf67e6e5747b81866fe0b85178a93c7f86e3	510000000	2	59320070	2023-02-09T06:11:34.000Z	0x1c72c80efaa2734b3b1b45de6aa50e57dd7f3ff91d201fe26262f167096439a8
0x7e38a9d2c99caef533e5d692ed8a2ce4b478e585	0x588384e142e5e1a841137b3d4e73b16e3858450d	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	14800142450	2	59525462	2023-02-09T22:59:28.000Z	0x2b29719db8d3777520067679c359be386b6a568905aa7faf1b7053a902625576
0xc0ab69fffeb5375235d8caa4f7218097bbcc0a0a	0xcba1a275e2d858ecffaf7a87f606f74b719a8a93	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	2100000000	2	59290246	2023-02-09T03:43:30.000Z	0x4505f6e2000957a5fda88c9431559d680da8242478924cb2eb7eaf4261857731

Example Query

Query with partition filter

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

SiloV1_Withdraw_event

Withdrawal event logs from Silo Finance V1 lending protocol on Arbitrum, tracking asset withdrawals with depositor, receiver, amount, and collateral-only flag. Used for analyzing user withdrawal patterns and protocol liquidity flows.

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
0xf60b7c2d1fb0ba86fe20baf86d04df738acfe577	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	20000000	2	0x9992f660137979c1ca7f8b119cd16361594e3681	55227170	0xdedcf5806c4968c6397eee97e68047bda339d0c1	2023-01-24T21:59:55.000Z	0xafa29087aa08e7e0e6d023e6011bbc1ffe1393091903e78fe27b72e0a577a6e4	false
0xf60b7c2d1fb0ba86fe20baf86d04df738acfe577	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	20000000	2	0x9992f660137979c1ca7f8b119cd16361594e3681	55222883	0xdedcf5806c4968c6397eee97e68047bda339d0c1	2023-01-24T21:34:11.000Z	0x9b74c728e0f84a1cd507df36f90745951fb26ec21eec94ad7e2588c115ec4b43	false
0xf60b7c2d1fb0ba86fe20baf86d04df738acfe577	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	20000000	2	0x9992f660137979c1ca7f8b119cd16361594e3681	55223454	0xdedcf5806c4968c6397eee97e68047bda339d0c1	2023-01-24T21:38:27.000Z	0x133aa7dcb32d44ff2f66472111314c105be99f1926a3609a2db95057656ebeda	false

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

SiloFactoryV1_NewSiloCreated_event

SiloIncentivesControllerV1_RewardsClaimed_event

SiloIncentivesControllerV2_RewardsClaimed_event

SiloV1_Borrow_event

SiloV1_Deposit_event

SiloV1_Repay_event

SiloV1_Withdraw_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​SiloFactoryV1_NewSiloCreated_event

​SiloIncentivesControllerV1_RewardsClaimed_event

​SiloIncentivesControllerV2_RewardsClaimed_event

​SiloV1_Borrow_event

​SiloV1_Deposit_event

​SiloV1_Repay_event

​SiloV1_Withdraw_event

Tables

SiloFactoryV1_NewSiloCreated_event

SiloIncentivesControllerV1_RewardsClaimed_event

SiloIncentivesControllerV2_RewardsClaimed_event

SiloV1_Borrow_event

SiloV1_Deposit_event

SiloV1_Repay_event

SiloV1_Withdraw_event