silo_v1_base

Tables

Silo_Borrow_event

Borrow events from Silo Finance lending protocol on Base, recording when users take out loans against collateral with borrower address, asset borrowed, and amount. Used for analyzing borrowing activity, protocol utilization, and debt positions 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
0x839aa8b0641b77db2c9effec724dd2df46290fa2	0xc693b4ffb338579467a541b2bf267b1955870920	false	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	1600000000000000000	562	22986717	2024-11-28T02:59:41.000Z	0xe392b232c2bf8fc38aa8650937788be4531df43c4b7f774346be03b0b17f24dd
0x839aa8b0641b77db2c9effec724dd2df46290fa2	0xe56cfad394121c46e908f33533a9c15de430bb55	false	0x4200000000000000000000000000000000000006	1700000000000000000	147	23011247	2024-11-28T16:37:21.000Z	0x603ecd7497c211716caaaf2fe76f10ddd5b45c1638fd3ae0e43c5b65667f2153
0x839aa8b0641b77db2c9effec724dd2df46290fa2	0xe56cfad394121c46e908f33533a9c15de430bb55	false	0x4200000000000000000000000000000000000006	1500000000000000000	580	23011348	2024-11-28T16:40:43.000Z	0x78822a8bcd8c43f135c0bec880fa40d1efc1d56a85c000ae03b4654d3c4623d2

Example Query

Query with partition filter

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

Silo_Deposit_event

Deposit events from Silo Finance lending protocol on Base, capturing user deposits of collateral assets with depositor addresses, amounts, and collateral-only flags. Used for tracking lending market supply activity and user position building.

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
0x8095806d8753c0443c118d1c5e5eec472e30bfec	false	0x04c0599ae5a44757c0af6f9ec3b93da8976c150a	37668908306193	337	24386561	0x1cda722859e128dcf40141bc7f06ada4b6f967f0	2024-12-30T12:41:09.000Z	0xac344323f34537ed9b1e973e61c9ecc01b1b0b4a5cddcd9c2f78a827f9a36b80	false
0x8095806d8753c0443c118d1c5e5eec472e30bfec	false	0x04c0599ae5a44757c0af6f9ec3b93da8976c150a	391912041293048727	214	24391471	0x983601f85a8f842b549110d4349a5fc3fdef4360	2024-12-30T15:24:49.000Z	0x08c2a4cab1a0e4ec790ef55ff560700568e8e4887a39a6e1cffefbd77a6ebee0	false
0xd54a83d47934d889364dd5af2d6855dcf05745c3	false	0x2416092f143378750bb29b79ed961ab195cceea5	485546454544488857	175	24385719	0xb44e0a5d944a05e86ee3fa9469f186b083cf5504	2024-12-30T12:13:05.000Z	0xa074890208c203e5bce0e5657882a9ae005cf63f3be38108235a132cfe916a81	false

Example Query

Query with partition filter

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

Silo_Repay_event

Loan repayment events from Silo Finance lending protocol on Base, recording borrower addresses, repaid asset tokens, and repayment amounts. Used for tracking debt reduction activity and analyzing borrower 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_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
0x839aa8b0641b77db2c9effec724dd2df46290fa2	0x136ea1a4965fbe2587cfdb26d08c7afdee0da608	false	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	330000000000000000	82	19889680	2024-09-17T10:25:07.000Z	0x344ef04ed1935db152c63fe7b1940aafb8562f7d4fd11ca411e55d73446d70e2
0x839aa8b0641b77db2c9effec724dd2df46290fa2	0x136ea1a4965fbe2587cfdb26d08c7afdee0da608	false	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	7000018677844237	155	19889812	2024-09-17T10:29:31.000Z	0x381eb481d68596e928ef8afa2df9322a0dd10974cc6280b3791e1823a576e36b
0x839aa8b0641b77db2c9effec724dd2df46290fa2	0xb12728628ca10cf6a582c7162877a4233288dee9	false	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	524080375945185860	40	19874303	2024-09-17T01:52:33.000Z	0xd6c708d7ca309ab5bbfc118cc5fc7a5425cf45c14f5b835ad6216ed54e38b04a

Example Query

Query with partition filter

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

Silo_Withdraw_event

Withdrawal event records from Silo lending protocol on Base, capturing asset withdrawals with depositor, receiver, amount, and collateral-only flag. Used to track user fund movements, lending position changes, 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
0x190e5c6aabb2bec4eb0b9b2274e9b62cdaedf356	false	0x4200000000000000000000000000000000000006	413087369784374	887	0x3e698a1fafb1a57750d49bc3e3d7c460e0733811	21714141	0x3e698a1fafb1a57750d49bc3e3d7c460e0733811	2024-10-29T16:00:29.000Z	0x1506f3cf8967d105200995e9e6f347f27aef9a4a4f9e062f769a4e3d8b944dfd	false
0x190e5c6aabb2bec4eb0b9b2274e9b62cdaedf356	false	0x4200000000000000000000000000000000000006	248359592011535	17	0x3e698a1fafb1a57750d49bc3e3d7c460e0733811	21688395	0x3e698a1fafb1a57750d49bc3e3d7c460e0733811	2024-10-29T01:42:17.000Z	0x01c369116fb1995a230c05cda88a5da429cbfa087bae5bd8e61886f18c8f6f29	false
0x190e5c6aabb2bec4eb0b9b2274e9b62cdaedf356	false	0x4200000000000000000000000000000000000006	2630574664770624024	625	0x757748e1a208f23bfeb08b925fac64971ef0584e	21695945	0x621b099df65461a15ad50946e5ed1b60ad075a9f	2024-10-29T05:53:57.000Z	0x6189af279f197a83856dd7c2f7e3e63de6ad51a5051f154eab380cc019f12407	false

Example Query

Query with partition filter

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

SiloFactory_NewSiloCreated_event

Silo lending market deployment events from Silo Finance protocol on Base, recording each new isolated lending market (silo) created for a specific collateral asset. Used to track protocol expansion and identify available lending markets by asset and version.

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
0x408822e4e8682413666809b0655161093cd36f2b	0x63617ef707843cde49ccb2dec7ad62b8e7976f5c	false	0xcc7ff230365bd730ee4b352cc2492cedac49383e	313	1	20750057	2024-10-07T08:24:21.000Z	0x8793804939f887a2b2b5898e856973a36aadceac93a32972e17192b3fc8b66c2
0x408822e4e8682413666809b0655161093cd36f2b	0x190e5c6aabb2bec4eb0b9b2274e9b62cdaedf356	false	0x7fcd174e80f264448ebee8c88a7c4476aaf58ea6	108	1	20775705	2024-10-07T22:39:17.000Z	0x171413d354a217db7a96135c94717a36ff4580afa76767590df11dfa4ba9dffd
0x408822e4e8682413666809b0655161093cd36f2b	0x459b353da108851ea3779c5399f3148a45e1bb90	false	0xe31ee12bdfdd0573d634124611e85338e2cbf0cf	343	1	20750046	2024-10-07T08:23:59.000Z	0x60e01352fc5fe2f568f81f25dfa448e63e6e2f78a65c5ec8d6e05c2b72bd8773

Example Query

Query with partition filter

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

SiloIncentivesController_RewardsClaimed_event

Incentive reward claim events from Silo Finance lending protocol on Base, tracking when users claim accumulated rewards with claimer, recipient, and token amount details. Used for analyzing reward distribution patterns and user claim behavior in Silo’s liquidity mining 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
0x085413dea073999c9f75c66ac519ce8cc34ff235	0x626e6a8d4eb33d77a8b631abfe2e98da69e3100e	0x085413dea073999c9f75c66ac519ce8cc34ff235	false	6938272276584633597	229	0x085413dea073999c9f75c66ac519ce8cc34ff235	23642980	2024-12-13T07:35:07.000Z	0xff09d95821908047a9be939d0793721626461f34240a33ec0afd5dac861a6630
0x1cda722859e128dcf40141bc7f06ada4b6f967f0	0x626e6a8d4eb33d77a8b631abfe2e98da69e3100e	0x1cda722859e128dcf40141bc7f06ada4b6f967f0	false	2971174377900325648	269	0x1cda722859e128dcf40141bc7f06ada4b6f967f0	23655791	2024-12-13T14:42:09.000Z	0x58d4dac92fd8f3f4d3109ad0f531f237f5d044523fbe836125adb62d57a634fe
0x236b8c9b10f31e40947088b56f5209f8b23047f1	0x626e6a8d4eb33d77a8b631abfe2e98da69e3100e	0x236b8c9b10f31e40947088b56f5209f8b23047f1	false	14432992906408582	42	0x236b8c9b10f31e40947088b56f5209f8b23047f1	23636877	2024-12-13T04:11:41.000Z	0x338a2e2d26af6a2fd23f339eb787b68afe71e5e47707f94715f3930e93de9cb3

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Silo_Borrow_event

Silo_Deposit_event

Silo_Repay_event

Silo_Withdraw_event

SiloFactory_NewSiloCreated_event

SiloIncentivesController_RewardsClaimed_event

​Tables

​Silo_Borrow_event

​Silo_Deposit_event

​Silo_Repay_event

​Silo_Withdraw_event

​SiloFactory_NewSiloCreated_event

​SiloIncentivesController_RewardsClaimed_event

Tables

Silo_Borrow_event

Silo_Deposit_event

Silo_Repay_event

Silo_Withdraw_event

SiloFactory_NewSiloCreated_event

SiloIncentivesController_RewardsClaimed_event