silo_v1_ethereum

Tables

SiloFactory_NewSiloCreated_event

Silo protocol factory deployment events on Ethereum tracking creation of new isolated lending markets (silos) for specific collateral assets. Each record captures the silo contract address, underlying asset address, and protocol version for monitoring Silo’s market expansion.

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
0x4d919cecfd4793c0d47866c8d0a02a0950737589	0x465aaace8fa54bef7f6c8c33774f42213b4c5986	false	0x1f9840a85d5af5bf1d1762f925bdaddc4201f984	256	1	15823373	2022-10-25T06:41:59.000Z	0xb9c6d09940300484881b8dcb37a5c12ef80642b48f324128a7d57d8113491579
0x4d919cecfd4793c0d47866c8d0a02a0950737589	0xcb357b59f0711373fe077df1255ecd253ad7d49f	false	0x0f5d2fb29fb7d3cfee444a200298f468908cc942	260	1	15823167	2022-10-25T06:00:23.000Z	0xc2b50c7dfb4e9c18474d377099f87af21665b7a07aadb760fef188069d5c8907
0x4d919cecfd4793c0d47866c8d0a02a0950737589	0x00c64ae39df498b8e77355d2085b8f968f0e3954	false	0xf4d2888d29d722226fafa5d9b24f9164c092421e	263	1	15823133	2022-10-25T05:53:35.000Z	0x5dd31371936d8daa82904cac02fc0990b33279d6e1cd150b7b9289f50a52ba52

Example Query

Query with partition filter

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

SiloFactoryV1_NewSiloCreated_event

Silo Finance protocol factory deployment events on Ethereum, recording each new isolated lending market (silo) created for a specific collateral asset. Tracks silo contract addresses paired with their underlying asset tokens for monitoring protocol expansion and supported collateral types.

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
0x4d919cecfd4793c0d47866c8d0a02a0950737589	0x465aaace8fa54bef7f6c8c33774f42213b4c5986	false	0x1f9840a85d5af5bf1d1762f925bdaddc4201f984	256	1	15823373	2022-10-25T06:41:59.000Z	0xb9c6d09940300484881b8dcb37a5c12ef80642b48f324128a7d57d8113491579
0x4d919cecfd4793c0d47866c8d0a02a0950737589	0xcb357b59f0711373fe077df1255ecd253ad7d49f	false	0x0f5d2fb29fb7d3cfee444a200298f468908cc942	260	1	15823167	2022-10-25T06:00:23.000Z	0xc2b50c7dfb4e9c18474d377099f87af21665b7a07aadb760fef188069d5c8907
0x4d919cecfd4793c0d47866c8d0a02a0950737589	0x00c64ae39df498b8e77355d2085b8f968f0e3954	false	0xf4d2888d29d722226fafa5d9b24f9164c092421e	263	1	15823133	2022-10-25T05:53:35.000Z	0x5dd31371936d8daa82904cac02fc0990b33279d6e1cd150b7b9289f50a52ba52

Example Query

Query with partition filter

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

SiloFactoryV2_NewSiloCreated_event

Silo protocol factory event logs recording creation of new lending markets on Ethereum, with each silo representing an isolated lending pool for a specific asset. Used for tracking Silo market deployments and analyzing protocol growth across different collateral types.

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
0x2c0fa05281730efd3ef71172d8992500b36b56ea	0x076ad078ce2b22f208ded6812e4d5de4a3ee4088	false	0x6dea81c8171d0ba574754ef6f8b412f2ed88c54d	142	1	17818661	2023-08-01T07:29:11.000Z	0x5888900277761e556d965f8dc9d034c806b1cad26331472d4906f85a9773dedc
0x2c0fa05281730efd3ef71172d8992500b36b56ea	0xa56d5162a4e3bc6ed6395b05765e18edaa3cedfe	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	113	1	17821019	2023-08-01T15:22:35.000Z	0x833370b0fcb6d6738e02242ccda52573a20744f8675d70dbcec20ea0606e42d7
0x2c0fa05281730efd3ef71172d8992500b36b56ea	0x5128fb075c5f770bfc53152abb37a62bb9dbf723	false	0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f	102	1	17819835	2023-08-01T11:24:47.000Z	0xde50afefa81c77205975c4d4aeff61b6008e16c6e7bfdffd6e4bf92160c9fe39

Example Query

Query with partition filter

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

SiloFactoryV3_NewSiloCreated_event

New Silo lending market creation events from the Silo Finance protocol factory contract on Ethereum. Records deployment of isolated lending markets with their contract addresses, underlying collateral assets, and version numbers for tracking protocol expansion.

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
0x6d4a256695586f61b77b09bc3d28333a91114d5a	0x339666a930fd79c190e824dd9d9df0393b8bd196	false	0x470f9f350642edf3cb3f2a6eb4569c0219386f0b	118	2	17512368	2023-06-19T07:40:47.000Z	0x8256520455c027ccb76d6e4b336d9d78dfaa9f283b442179b6e6a859b1c2c245
0x6d4a256695586f61b77b09bc3d28333a91114d5a	0x03ff864f65a69e6c025f68f5695fa243f8d2d61b	false	0x041dfd7e8497b3b47b2260fc0ced9443c67c9ed2	83	2	17392944	2023-06-02T12:07:11.000Z	0xa9989118b043a93845d3ac416f07025dc8e8d4f5d7133bafd825a9109daaa137
0x6d4a256695586f61b77b09bc3d28333a91114d5a	0x74a633b156b55711d0c91e64fa7de3b7af87470a	false	0xa600df1fb4c79a668c4d9e3016504d28bfaaff1a	115	2	17393035	2023-06-02T12:25:47.000Z	0xe2611f9636f10dcf61e34a5f8c3dc7e94035693bbf7e4eaa1be845c785343894

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.silo_v1_ethereum.SiloFactoryV3_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 Ethereum, recording when users claim their accumulated rewards with claimer, recipient, and token amount details. Useful 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
0x6a7dbffd83c6808651223efcaf7ea88161290e2b	0x6c1603ab6cecf89dd60c24530dde23f97da3c229	0x6a7dbffd83c6808651223efcaf7ea88161290e2b	false	1247540759546608709102	243	0x6a7dbffd83c6808651223efcaf7ea88161290e2b	18501381	2023-11-04T21:34:59.000Z	0x36d07bca2841ebbc1dba8231ab9944498a6c786bf1ac16724382416ec88c75e8
0xb5be97c440d573e81ea3d2257432eb2ae646e265	0x6c1603ab6cecf89dd60c24530dde23f97da3c229	0xb5be97c440d573e81ea3d2257432eb2ae646e265	false	4235435249148468623793	308	0xb5be97c440d573e81ea3d2257432eb2ae646e265	18501595	2023-11-04T22:18:11.000Z	0xd08d3df2e05446252363f4f0de1ad8e927ba16cadf5bb7417be022959334b5f4
0x9b8b04b6f82cd5e1dae58ca3614d445f93defc5c	0x6c1603ab6cecf89dd60c24530dde23f97da3c229	0x9b8b04b6f82cd5e1dae58ca3614d445f93defc5c	false	5004777753083781490506	125	0x9b8b04b6f82cd5e1dae58ca3614d445f93defc5c	17344460	2023-05-26T16:29:35.000Z	0x825a797ca53fd55daa7f00e84b4f359043dbe963dc7dace36318feb6678f0e5d

Example Query

Query with partition filter

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

SiloIncentivesControllerV2_RewardsClaimed_event

Reward claim events from Silo Finance V2 incentives controller on Ethereum, tracking when users claim incentive tokens with claimer, recipient, and token amounts. Used for analyzing user participation in Silo’s liquidity mining programs and reward distribution 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
0x46a83dc1a264bff133db887023d2884167094837	0x361384a0d755f972e5eea26e4f4efbaf976b6461	0x46a83dc1a264bff133db887023d2884167094837	false	1795526873117402236404	205	0x46a83dc1a264bff133db887023d2884167094837	18492451	2023-11-03T15:32:47.000Z	0x70b339036a863275372a8a25eb43c4a51976d76066be554f36ea3b107a21da06
0x5dd596c901987a2b28c38a9c1dfbf86fffc15d77	0x361384a0d755f972e5eea26e4f4efbaf976b6461	0x5dd596c901987a2b28c38a9c1dfbf86fffc15d77	false	1876277433802470609575	58	0x5dd596c901987a2b28c38a9c1dfbf86fffc15d77	18488794	2023-11-03T03:15:35.000Z	0xbdc60ecb50b5053666e1dea9795df672394970ab01eb403f89d765be759207b0
0xbdfa4f4492dd7b7cf211209c4791af8d52bf5c50	0x361384a0d755f972e5eea26e4f4efbaf976b6461	0xbdfa4f4492dd7b7cf211209c4791af8d52bf5c50	false	248779501435100645408	252	0xbdfa4f4492dd7b7cf211209c4791af8d52bf5c50	18488777	2023-11-03T03:12:11.000Z	0x2be2a760e3c3d7617361b36e0fb1a5088dcdcc7f3655c1abefdc99e803bad205

Example Query

Query with partition filter

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

SiloModule_SiloModuleWithdraw_event

Withdrawal events from Silo Protocol v1 lending markets on Ethereum, recording XAI token amounts withdrawn from specific silo addresses. Used for tracking liquidity removals and user withdrawal patterns across different lending pools.

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_xaiAmount`	`STRING`	Amount of XAI tokens withdrawn from the Silo, denominated in wei (18 decimals). Values typically range from hundreds to millions of tokens in their smallest unit representation.

Sample Data

address	in_silo	removed	log_index	block_number	in_xaiAmount	block_timestamp	transaction_hash
0xb98bc3e3b9ea8d86f6ee321737fa23710737f1af	0x0bce613ef6a197e8c56be525cf173c27b49ac47d	false	248	17478251	150000000000000000000000	2023-06-14T12:42:59.000Z	0x9511775d3fc9314b64ca5b978bbb4f1a1059cb0587d53126965a704a1c16193e
0xb98bc3e3b9ea8d86f6ee321737fa23710737f1af	0xaeafe7ba306ca37cb7c69f6a2822541a28c116e8	false	243	17478251	150000000000000000000000	2023-06-14T12:42:59.000Z	0x9511775d3fc9314b64ca5b978bbb4f1a1059cb0587d53126965a704a1c16193e
0xb98bc3e3b9ea8d86f6ee321737fa23710737f1af	0x4872428c93bc52450c435223bece8b4a622b4252	false	253	17478251	150000000000000000000000	2023-06-14T12:42:59.000Z	0x9511775d3fc9314b64ca5b978bbb4f1a1059cb0587d53126965a704a1c16193e

Example Query

Query with partition filter

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

SiloModule_withdrawRevenue_function

Revenue withdrawal function calls from Silo v1 lending protocol on Ethereum. Tracks attempts to extract protocol fees from individual silo markets, useful for analyzing revenue collection patterns and transaction success rates across different lending pools.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__silo`	`STRING`	Contract address of the specific Silo lending market from which revenue is being withdrawn. Hex-encoded, 0x-prefixed Ethereum address identifying the individual Silo vault instance.

Sample Data

gas	status	gas_used	in__silo	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
7979845	false	549380	0x339666a930fd79c190e824dd9d9df0393b8bd196	0x5e420f4c	0xb98bc3e3b9ea8d86f6ee321737fa23710737f1af	22282975	0xe8e8041cb5e3158a0829a19e014ca1cf91098554	0,4,6	2025-04-16T17:13:23.000Z	0x111b0962040682588ef1ddf68141f6e0d2e23a730d6bc22d3d893db2ee6e5ed5
9448540	false	294821	0xcd888c9bd53c1ca49b9251f74cc93c73e22963fa	0x5e420f4c	0xb98bc3e3b9ea8d86f6ee321737fa23710737f1af	22282975	0xe8e8041cb5e3158a0829a19e014ca1cf91098554	0,4,0	2025-04-16T17:13:23.000Z	0x111b0962040682588ef1ddf68141f6e0d2e23a730d6bc22d3d893db2ee6e5ed5
7300050	false	283120	0x4f5717f1efdec78a960f08871903b394e7ea95ed	0x5e420f4c	0xb98bc3e3b9ea8d86f6ee321737fa23710737f1af	22282975	0xe8e8041cb5e3158a0829a19e014ca1cf91098554	0,4,8	2025-04-16T17:13:23.000Z	0x111b0962040682588ef1ddf68141f6e0d2e23a730d6bc22d3d893db2ee6e5ed5

Example Query

Query with partition filter

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

SiloV1_Borrow_event

Borrow transaction events from Silo Finance V1 lending protocol on Ethereum, tracking user addresses, borrowed asset contracts, and loan amounts. Used for analyzing borrowing activity, position sizes, and asset utilization 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
0x67b2d089c39c59a49f8fbdea43f5878b3a3f65c3	0x1ba67f30e25fc43863b50047d7fd4bd63b9c59ec	false	0xc0c293ce456ff0ed870add98a0828dd4d2903dbf	23000000000000000000000	194	16076568	2022-11-29T15:33:23.000Z	0x9186c482d198f1c11ebdab6df4ba3fe32dbde3b7dda714dc815dbe78bed09f1e
0x67b2d089c39c59a49f8fbdea43f5878b3a3f65c3	0xa68444587ea4d3460bbc11d5aebc1c817518d648	false	0xc0c293ce456ff0ed870add98a0828dd4d2903dbf	1377541172618720641531	97	16078654	2022-11-29T22:33:47.000Z	0x8db54112001f1568aa063c841df179ef076b21380856ca93138cd2bdac5f2c47
0x67b2d089c39c59a49f8fbdea43f5878b3a3f65c3	0xa68444587ea4d3460bbc11d5aebc1c817518d648	false	0xc0c293ce456ff0ed870add98a0828dd4d2903dbf	1114363742309106781462	203	16078669	2022-11-29T22:36:47.000Z	0x7615b7ed0a63eeb2d7ff1c9881f44db8ec2ae6d5f93e7d1a4421924f3e758fb4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.silo_v1_ethereum.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 Ethereum, capturing depositor addresses, asset tokens, amounts, and collateral-only flags. Used for analyzing liquidity provision patterns and user deposit behavior 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_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
0x4f5717f1efdec78a960f08871903b394e7ea95ed	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	13861521768491038097	349	15951786	0x0a4ea2fdfad07d035fa20cf13b7e8813ac5dca22	2022-11-12T05:16:35.000Z	0x28dd4c717f47ff8b5f3111206c756a99cbcf09c0e8548bcf75060efd03ab0039	false
0x4f5717f1efdec78a960f08871903b394e7ea95ed	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	627887125406746499618	236	18555436	0xa53a13a80d72a855481de5211e7654fabdfe3526	2023-11-12T11:08:35.000Z	0x4ea40eaa293f1ba80f9a204738585306f1f2c4beafa7191c7f60b31e8ec4bf5a	true
0x629b9e70a7d32c718318d691dda5da585e468b82	false	0x6dea81c8171d0ba574754ef6f8b412f2ed88c54d	4406081231268679227936	288	18557990	0x357dfdc34f93388059d2eb09996d80f233037cba	2023-11-12T19:42:59.000Z	0x6006b009c840c77b4d36a8943f65f9b13a3f3e796a6eec10a074eb7913ce0736	true

Example Query

Query with partition filter

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

SiloV1_Repay_event

Debt repayment events from Silo Finance V1 lending markets on Ethereum. Tracks borrowers repaying loans with asset address, repaid amount, and associated user for analyzing lending protocol debt management and liquidation avoidance activity.

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
0x92e7e77163ffed918421e3cb6e0a22f2fe8b37fa	0x2bc6ace742d7a1b9ad15d09a150687f042f9f185	false	0xba100000625a3754423978a60c9317c58a424e3d	1270000000000000000000	354	16181156	2022-12-14T06:29:59.000Z	0x91981b9b8b43e7381f7264dad67ae5a5aef34c8b8aa89df55d1d203e44e1fcd8
0x92e7e77163ffed918421e3cb6e0a22f2fe8b37fa	0x2bc6ace742d7a1b9ad15d09a150687f042f9f185	false	0xba100000625a3754423978a60c9317c58a424e3d	220529900747954587607	242	16186240	2022-12-14T23:32:23.000Z	0x3438af1932597525fea88858eb15c02e6c902c219cde3607055df99e0ca12f60
0x2eaf84b425822edf450fc5fdeec085f2e5ada98b	0x791d1ec51d931186c1d4b80e753b7155dd98f741	false	0xbe9895146f7af43049ca1c1ae358b0541ea49704	7010000000000000	121	16183928	2022-12-14T15:48:23.000Z	0xa52c8835db5efbc4a0515b876658107fb79c2a772be6b964cbf89a0b77eed910

Example Query

Query with partition filter

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

SiloV1_Withdraw_event

Withdrawal events from Silo Finance V1 lending markets on Ethereum, tracking asset removals with depositor, receiver, and collateral-only flag distinctions. Used for analyzing liquidity flows and user redemption patterns across isolated lending pools.

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
0xac3333401e69574d433307b31f43a7826eb6f8fd	false	0x4a220e6096b25eadb88358cb44068a3248254675	200000000000000000000	53	0xb2374f84b3ceeff6492943df613c9bcf45322a0c	16189482	0x0ccfaac13324f34d59d63a7578fe3ac3c5734726	2022-12-15T10:25:11.000Z	0x5b5a211e588e86a20bfbadfb467f4c561fc641ae01fc0a6e7cf152a0bd58c522	true
0xac3333401e69574d433307b31f43a7826eb6f8fd	false	0x4a220e6096b25eadb88358cb44068a3248254675	100000000000000000000	130	0xb2374f84b3ceeff6492943df613c9bcf45322a0c	16189158	0x0ccfaac13324f34d59d63a7578fe3ac3c5734726	2022-12-15T09:19:47.000Z	0x3ebc72e6a0a6af80370ccc01f4d1d0e97a8919f0043c58a13ad47c68c0f518ed	true
0xc8cd77d4cd9511f2822f24ad14fe9e3c97c57836	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	75000000000000000000	106	0xb2374f84b3ceeff6492943df613c9bcf45322a0c	16187371	0x2a86d975c2b490cac6cf9259a4e7824bf93ce02d	2022-12-15T03:19:59.000Z	0x14949b8dcc8cf3b61fbcd358a977abf3e6b1b51cc78af66e798f444272732302	true

Example Query

Query with partition filter

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

SiloV2_Borrow_event

Borrow event records from Silo Finance V1 lending protocol on Ethereum, capturing when users borrow assets with borrower address, asset token, and borrowed amount. Used for analyzing borrowing activity, debt positions, and protocol utilization across different 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_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
0x96efdf95cc47fe90e8f63d2f5ef9fb8b180daeb9	0x1e2cd9d97dced12fdd6e09087fdb3ccf82f9a34e	false	0xd533a949740bb3306d119cc777fa900ba034cd52	10000000000000000000000	532	18524137	2023-11-08T02:03:35.000Z	0x3440c1230477ba37ad8512f31eca639c0b7be9d17fbeeb541459e4ba21967922
0x96efdf95cc47fe90e8f63d2f5ef9fb8b180daeb9	0x32d03db62e464c9168e41028ffa6e9a05d8c6451	false	0xf939e0a03fb07f59a73314e73794be0e57ac1b4e	950000000000000000000000	462	18528587	2023-11-08T17:00:11.000Z	0xcf6f23cbdb4375cb2f812b83c2eca86f3bf1c7b8339492b56e03b1c26d063bc0
0x96efdf95cc47fe90e8f63d2f5ef9fb8b180daeb9	0x32d03db62e464c9168e41028ffa6e9a05d8c6451	false	0xf939e0a03fb07f59a73314e73794be0e57ac1b4e	950000000000000000000000	296	18528630	2023-11-08T17:08:47.000Z	0x372694a29f5fcbec1d70a69eda070ee1eaff8cbf9d80565af392505398f19021

Example Query

Query with partition filter

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

SiloV2_Deposit_event

Deposit events from Silo V2 lending protocol on Ethereum, recording asset deposits into lending pools with depositor addresses, asset amounts, and collateral-only flags. Used for analyzing lending behavior, capital flows, and collateral composition 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_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
0xc9ae642d3a2792c429219ba641c4a2a8fb8f7dc5	false	0xd33526068d116ce69f19a9ee46f0bd304f21a51f	2696069919151664566	79	17911273	0x8f0a35f3b9c3afb0ff67af81af67af97e900ea39	2023-08-14T06:24:23.000Z	0xe91a60c5541219540fa2d8862ce6ba7ea7015345397ecdbe456dc1343630944f	true
0x4f11d892fd89cf16651fc1a2526ccfbdded3e616	false	0x1f9840a85d5af5bf1d1762f925bdaddc4201f984	98801656514251587266	81	18401299	0xbb2fee3323bcd5d0d70271585d06567792decb3b	2023-10-21T21:14:47.000Z	0xff1b70197bedf2ae1e4123ecf4ecba7a4f90c5bc718766803d627a4bed9ae032	false
0x96efdf95cc47fe90e8f63d2f5ef9fb8b180daeb9	false	0xf939e0a03fb07f59a73314e73794be0e57ac1b4e	14294881855230299114358	56	18397772	0xe05082b184a34668cd8a904d85fa815802bbb04c	2023-10-21T09:24:35.000Z	0xad7cb699b7f475fe99722a5fba19c624813fdf353a8cc04dbb12fe6da13a9439	false

Example Query

Query with partition filter

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

SiloV2_Repay_event

Debt repayment events from Silo V2 lending protocol on Ethereum, recording when users repay borrowed assets. Useful for tracking loan activity, calculating outstanding debt positions, and analyzing borrower behavior 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_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
0x96efdf95cc47fe90e8f63d2f5ef9fb8b180daeb9	0x62115d7710c22829c8f042a14a4804eb059392e6	false	0xd533a949740bb3306d119cc777fa900ba034cd52	6374356340237082855599	292	18571409	2023-11-14T16:42:47.000Z	0x78d2cdba39c0495e8c685c56259ef77440b21776f48e87bc449bc8d6599407c0
0x96efdf95cc47fe90e8f63d2f5ef9fb8b180daeb9	0x62115d7710c22829c8f042a14a4804eb059392e6	false	0xd533a949740bb3306d119cc777fa900ba034cd52	232979976687255144880646	213	18571385	2023-11-14T16:37:59.000Z	0xd5f62a250b7a3c17147f5541d8cfeec8e7f91c236b6126bfeaf05ea05067eef0
0x96efdf95cc47fe90e8f63d2f5ef9fb8b180daeb9	0x154001a2f9f816389b2f6d9e07563ce0359d813d	false	0xd533a949740bb3306d119cc777fa900ba034cd52	4985370653330795051649	292	18499339	2023-11-04T14:43:11.000Z	0x10caebab472aea602c25343eeafb1dc1e4d7861d9c5e75c5a02f21c5c6387e07

Example Query

Query with partition filter

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

SiloV2_Withdraw_event

Withdrawal events from Silo Finance V2 lending protocol on Ethereum, tracking asset withdrawals with depositor, receiver, amount, and collateral-only flag. Used for analyzing lending activity, user behavior, and protocol liquidity movements.

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
0xb0823c25cdf531a58e581ee14f160c290fef5722	false	0x0bc529c00c6401aef6d220be8c6ea1667f6ad93e	62500000000000000000	151	0xf380f025675a868ed5614a1dd77c6b05f4147004	18416674	0x2f8742738e55b7e15d8c1aa213af1ff9289c7c6b	2023-10-24T00:53:35.000Z	0xf9e72ecd1b34da8870e5127f9c9d5b3ca2d98e711f98d34cd851d40b65410727	true
0x96efdf95cc47fe90e8f63d2f5ef9fb8b180daeb9	false	0xf939e0a03fb07f59a73314e73794be0e57ac1b4e	8000000000000000000000	459	0xf380f025675a868ed5614a1dd77c6b05f4147004	18417701	0x154001a2f9f816389b2f6d9e07563ce0359d813d	2023-10-24T04:21:35.000Z	0x010b6ba8a9fcbc7807645e1f97f447f2f2f301ed3418993ba059883a23dc772f	false
0x96efdf95cc47fe90e8f63d2f5ef9fb8b180daeb9	false	0xf939e0a03fb07f59a73314e73794be0e57ac1b4e	1500000000000000000000000	344	0xf380f025675a868ed5614a1dd77c6b05f4147004	18422026	0xa53a13a80d72a855481de5211e7654fabdfe3526	2023-10-24T18:53:11.000Z	0xb5739d5f93ed3134629bea25503f5539875a2828388d1ddff4724bc33e178696	false

Example Query

Query with partition filter

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

SiloV3_Borrow_event

Borrow event records from Silo V1 lending protocol on Ethereum, capturing user borrowing activity with asset addresses and borrowed amounts. Used to analyze borrowing patterns, debt positions, and liquidity utilization across Silo 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
0x339666a930fd79c190e824dd9d9df0393b8bd196	0xb734ec7a75d65406fde5bcf9156cab673ba1e1c5	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	7000000000000000000	297	17576627	2023-06-28T08:28:11.000Z	0x4a29aa4ee22d57986736fc05841b7a49d78f1e62f9160ab51be6a98471fae5fd
0x74a633b156b55711d0c91e64fa7de3b7af87470a	0xad3d0a6868124f3f28fc746132bc32608f0e6a60	false	0xd7c9f0e536dc865ae858b0c0453fe76d13c3beac	1510000000000000000000	394	17421655	2023-06-06T13:18:59.000Z	0x033144b711aed1bba9b2732309fe07f1262a7a2e73d3fea59dc1e50e83c1a42b
0x03ff864f65a69e6c025f68f5695fa243f8d2d61b	0x2daaf15e6017099a28a64e37d32df5671408a63b	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	40000000000000000000	247	17502472	2023-06-17T22:21:23.000Z	0x8f28176839320a4735cdf75dc14daff10d544e8cbc19bb5cc39860a395199218

Example Query

Query with partition filter

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

SiloV3_Deposit_event

Deposit event logs from Silo Finance V1 lending protocol on Ethereum, capturing asset deposits with amounts, depositor addresses, and collateral-only flags. Used for tracking lending activity, TVL (Total Value Locked) calculations, and analyzing user deposit behavior 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_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
0x339666a930fd79c190e824dd9d9df0393b8bd196	false	0x470f9f350642edf3cb3f2a6eb4569c0219386f0b	31807867524384520000	130	17761053	0x53e213da8c28d85dc6663c3b5e35bb0ffbb05752	2023-07-24T06:03:11.000Z	0x792262afc7763d26a5e454a477e0a0ff7ce125d75351bf722cfe7d6b520b8770	true
0x74a633b156b55711d0c91e64fa7de3b7af87470a	false	0xd7c9f0e536dc865ae858b0c0453fe76d13c3beac	350000000000000000000000	341	17478251	0xb98bc3e3b9ea8d86f6ee321737fa23710737f1af	2023-06-14T12:42:59.000Z	0x9511775d3fc9314b64ca5b978bbb4f1a1059cb0587d53126965a704a1c16193e	false
0x03ff864f65a69e6c025f68f5695fa243f8d2d61b	false	0xd7c9f0e536dc865ae858b0c0453fe76d13c3beac	350000000000000000000000	330	17478251	0xb98bc3e3b9ea8d86f6ee321737fa23710737f1af	2023-06-14T12:42:59.000Z	0x9511775d3fc9314b64ca5b978bbb4f1a1059cb0587d53126965a704a1c16193e	false

Example Query

Query with partition filter

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

SiloV3_Repay_event

Debt repayment events from Silo Finance V3 lending protocol on Ethereum, capturing user addresses, repaid asset addresses, and repayment amounts. Used for analyzing borrower behavior, debt reduction patterns, and protocol repayment 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
0x339666a930fd79c190e824dd9d9df0393b8bd196	0xb734ec7a75d65406fde5bcf9156cab673ba1e1c5	false	0xd7c9f0e536dc865ae858b0c0453fe76d13c3beac	66621848798505970159	297	18266195	2023-10-02T23:40:35.000Z	0xb0a1a78d4e509e634cb04d5421d4cef9f4b925980e5418c32ed7b49a4562a202
0x339666a930fd79c190e824dd9d9df0393b8bd196	0xb734ec7a75d65406fde5bcf9156cab673ba1e1c5	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	12200000000000000	231	18266205	2023-10-02T23:42:35.000Z	0xe59a1f4e9a420d94297a9d57ed034ac7068b496efad484b9dfd0b56768bd8e28
0x339666a930fd79c190e824dd9d9df0393b8bd196	0xb734ec7a75d65406fde5bcf9156cab673ba1e1c5	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	30000000000000000	441	17822350	2023-08-01T19:50:11.000Z	0x6d8bb0a8ceab155708229430960af6b5501eed4e49acdd054fe1c35e6b9bbb44

Example Query

Query with partition filter

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

SiloV3_Withdraw_event

Withdrawal events from Silo Finance V3 lending protocol on Ethereum, tracking asset removals with depositor, receiver, amount, and collateral-only flag. Used for analyzing user withdrawal patterns and liquidity movements 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_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
0x339666a930fd79c190e824dd9d9df0393b8bd196	false	0xd7c9f0e536dc865ae858b0c0453fe76d13c3beac	5008591913990163760292	552	0x8658047e48cc09161f4152c79155dac1d710ff0a	18169224	0x9b8b04b6f82cd5e1dae58ca3614d445f93defc5c	2023-09-19T10:00:11.000Z	0xf8651b01a015a58c12053ee7f1985c1b1993c01b76b05c62e7844cb54395915e	false
0x339666a930fd79c190e824dd9d9df0393b8bd196	false	0x470f9f350642edf3cb3f2a6eb4569c0219386f0b	1200000000000000000	222	0x8658047e48cc09161f4152c79155dac1d710ff0a	17583838	0xad3d0a6868124f3f28fc746132bc32608f0e6a60	2023-06-29T08:42:35.000Z	0x7488271d7c71ba06b92038573ac4e4721c9ae600d5c0433ae26cec45bdd09091	true
0x03ff864f65a69e6c025f68f5695fa243f8d2d61b	false	0x041dfd7e8497b3b47b2260fc0ced9443c67c9ed2	3000000000000000000	360	0x8658047e48cc09161f4152c79155dac1d710ff0a	17583828	0xad3d0a6868124f3f28fc746132bc32608f0e6a60	2023-06-29T08:40:35.000Z	0xa0d03024d725aae5cecb0d289c99a880198bbb138f9d722ec7ca1ab761634c16	true

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

SiloFactory_NewSiloCreated_event

SiloFactoryV1_NewSiloCreated_event

SiloFactoryV2_NewSiloCreated_event

SiloFactoryV3_NewSiloCreated_event

SiloIncentivesControllerV1_RewardsClaimed_event

SiloIncentivesControllerV2_RewardsClaimed_event

SiloModule_SiloModuleWithdraw_event

SiloModule_withdrawRevenue_function

SiloV1_Borrow_event

SiloV1_Deposit_event

SiloV1_Repay_event

SiloV1_Withdraw_event

SiloV2_Borrow_event

SiloV2_Deposit_event

SiloV2_Repay_event

SiloV2_Withdraw_event

SiloV3_Borrow_event

SiloV3_Deposit_event

SiloV3_Repay_event

SiloV3_Withdraw_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​SiloFactory_NewSiloCreated_event

​SiloFactoryV1_NewSiloCreated_event

​SiloFactoryV2_NewSiloCreated_event

​SiloFactoryV3_NewSiloCreated_event

​SiloIncentivesControllerV1_RewardsClaimed_event

​SiloIncentivesControllerV2_RewardsClaimed_event

​SiloModule_SiloModuleWithdraw_event

​SiloModule_withdrawRevenue_function

​SiloV1_Borrow_event

​SiloV1_Deposit_event

​SiloV1_Repay_event

​SiloV1_Withdraw_event

​SiloV2_Borrow_event

​SiloV2_Deposit_event

​SiloV2_Repay_event

​SiloV2_Withdraw_event

​SiloV3_Borrow_event

​SiloV3_Deposit_event

​SiloV3_Repay_event

​SiloV3_Withdraw_event

Tables

SiloFactory_NewSiloCreated_event

SiloFactoryV1_NewSiloCreated_event

SiloFactoryV2_NewSiloCreated_event

SiloFactoryV3_NewSiloCreated_event

SiloIncentivesControllerV1_RewardsClaimed_event

SiloIncentivesControllerV2_RewardsClaimed_event

SiloModule_SiloModuleWithdraw_event

SiloModule_withdrawRevenue_function

SiloV1_Borrow_event

SiloV1_Deposit_event

SiloV1_Repay_event

SiloV1_Withdraw_event

SiloV2_Borrow_event

SiloV2_Deposit_event

SiloV2_Repay_event

SiloV2_Withdraw_event

SiloV3_Borrow_event

SiloV3_Deposit_event

SiloV3_Repay_event

SiloV3_Withdraw_event