seamlessprotocol_v1_base - Token Terminal Docs

Tables

AToken_Initialized_event

Aave V3 AToken initialization events emitted when new interest-bearing token markets are deployed. Contains AToken metadata (name, symbol, decimals), configuration references (pool, treasury, incentives controller), and the underlying asset address being wrapped.

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_underlyingAsset`	`STRING`	Contract address of the underlying asset represented by the AToken. Hex-encoded, 0x-prefixed, 42-character string.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_treasury`	`STRING`	Contract address of the Aave protocol treasury. Hex-encoded, 0x-prefixed, 42-character string.
`in_incentivesController`	`STRING`	Contract address of the incentives controller managing reward distribution for the token. Hex-encoded, 0x-prefixed, 42-character string.
`in_aTokenDecimals`	`INT64`	Number of decimal places for the AToken. Integer value representing the divisibility of the token amount.
`in_aTokenName`	`STRING`	Human-readable name of the AToken being initialized in the Aave protocol. String value identifying the token, typically following the pattern “Aave [Chain] [Asset]” or “[Protocol] [Asset]”.
`in_aTokenSymbol`	`STRING`	Trading symbol for the AToken being initialized in the Aave protocol. String value representing the ticker symbol, following patterns like “aArb[Asset]”, “aEth[Asset]”, “aBnb[Asset]”, or protocol-specific variants.
`in_params`	`STRING`	Additional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.

Sample Data

address	in_pool	removed	in_params	log_index	in_treasury	block_number	in_aTokenName	block_timestamp	in_aTokenSymbol	transaction_hash	in_aTokenDecimals	in_underlyingAsset	in_incentivesController
0x513f1b208f980d1694e161f3e5bcccfe49a8850e	0x8f44fd754285aa6a2b8b9b97739b79746e0475a7	false	0x	328	0x982f3a0e3183896f9970b8a9ea6b69cd53af1089	18384544	Seamless rUSDC	2024-08-13T14:13:55.000Z	srUSDC	0xf1dda98bc073b34f1a3a4a45bd139630405bc2b18b555b87c3d71cc44b556f66	6	0x9660af3b1955648a72f5c958e80449032d645755	0x91ac2fff8cbef5859eaa6dda661febd533cd3780
0x67368df7734aee0bc65a845ac6d73974626b7a34	0x8f44fd754285aa6a2b8b9b97739b79746e0475a7	false	0x	195	0x982f3a0e3183896f9970b8a9ea6b69cd53af1089	13344367	Seamless SEAM	2024-04-18T22:08:01.000Z	sSEAM	0xf17fa7d5cfc161d6f3544a2c9e49d43d552128b47906088c09fbaa54862aa085	18	0x1c7a460413dd4e964f96d8dfc56e7223ce88cd85	0x91ac2fff8cbef5859eaa6dda661febd533cd3780
0xc52d72b89931fda7c7b7b13cc3359ef6207d4638	0x8f44fd754285aa6a2b8b9b97739b79746e0475a7	false	0x	191	0x982f3a0e3183896f9970b8a9ea6b69cd53af1089	13344367	Seamless rWETH	2024-04-18T22:08:01.000Z	srWETH	0xf17fa7d5cfc161d6f3544a2c9e49d43d552128b47906088c09fbaa54862aa085	18	0x3e8707557d4ad25d6042f590bcf8a06071da2c5f	0x91ac2fff8cbef5859eaa6dda661febd533cd3780

Example Query

Query with partition filter

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

LendingPool_Borrow_event

Borrow events emitted by Aave lending pool contracts capturing loan originations with borrower address, reserve asset, loan amount, interest rate, and rate mode (stable or variable). Used for tracking DeFi lending activity and calculating protocol borrowing metrics.

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_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. 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_onBehalfOf`	`STRING`	Address of the account receiving the benefit of the 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.
`in_interestRateMode`	`INT64`	Interest rate mode for the lending operation. Integer value where 0 indicates no interest rate mode, 1 indicates stable rate, and 2 indicates variable rate.
`in_borrowRate`	`STRING`	Annual interest rate applied to the borrowed amount in the lending pool. Numeric string representation expressed in ray units (27 decimal places).
`in_referralCode`	`STRING`	Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.

Sample Data

address	in_user	removed	in_amount	log_index	in_reserve	block_number	in_borrowRate	in_onBehalfOf	block_timestamp	transaction_hash	in_interestRateMode
0x8f44fd754285aa6a2b8b9b97739b79746e0475a7	0x6547442d90217424a3df11142d17d4d18e7d57f4	false	800000000000000000	297	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	16029322	27881668823326568404799871	0x6547442d90217424a3df11142d17d4d18e7d57f4	2024-06-20T01:46:31.000Z	0xfb2d3db34b82163bc496686e5e33cbcc14541b4c73c1eac51d78a23d6aeca790	2
0x8f44fd754285aa6a2b8b9b97739b79746e0475a7	0xee9ef0af2c97b5affd685fb5ef9125bf88d7055f	false	416850000000000000	197	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	16042297	27791906538176261202258307	0xee9ef0af2c97b5affd685fb5ef9125bf88d7055f	2024-06-20T08:59:01.000Z	0xa154f09f05677628f8368463d766efca3b5395af44a413387bdd95dbaf071e94	2
0x8f44fd754285aa6a2b8b9b97739b79746e0475a7	0x4af0f92607e006ef59e6bc6a12ae910d25421c87	false	410000000000000000	440	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	16066213	29209728873344109038687978	0x4af0f92607e006ef59e6bc6a12ae910d25421c87	2024-06-20T22:16:13.000Z	0xd710ed9aed02ecafd7ce6f37dfceefad2990e289a6fe20ebb105b0b2900b41bb	2

Example Query

Query with partition filter

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

LendingPool_FlashLoan_event

Flash loan events from Aave and Aave-forked lending protocols containing borrowed asset, amount, initiator, recipient, and premium fee charged. Used for tracking uncollateralized borrowing activity and arbitrage transactions.

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_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_initiator`	`STRING`	Address of the account that initiated the flash loan operation. 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_interestRateMode`	`INT64`	Interest rate mode for the lending operation. Integer value where 0 indicates no interest rate mode, 1 indicates stable rate, and 2 indicates variable rate.
`in_premium`	`STRING`	Fee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
`in_referralCode`	`STRING`	Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.

Sample Data

address	removed	in_asset	in_amount	in_target	log_index	in_premium	block_number	in_initiator	block_timestamp	transaction_hash
0x8f44fd754285aa6a2b8b9b97739b79746e0475a7	false	0x50c5725949a6f0c72e6c4a641f24049a917db0cb	178880484735432916992	0xca1f59b6f5d84984d99b0b1712803fccdbc8f57c	182	71552193894173167	15728701	0xca1f59b6f5d84984d99b0b1712803fccdbc8f57c	2024-06-13T02:45:49.000Z	0x19817b5cfe677ef2665e7092af2f778b5cca6aa08d05654178941fce03732db1
0x8f44fd754285aa6a2b8b9b97739b79746e0475a7	false	0x4200000000000000000000000000000000000006	170694969226225	0x6d381fc17cb7baf46bca0c8889b1da8dd6f46c8f	38	68277987690	11375344	0x6d381fc17cb7baf46bca0c8889b1da8dd6f46c8f	2024-03-04T08:13:55.000Z	0x8c25e06333d7eefc0fe4f964bf9b45d530361aefae68bf52cb6aab4157a0b361
0x8f44fd754285aa6a2b8b9b97739b79746e0475a7	false	0x4200000000000000000000000000000000000006	1882835579088305	0x6d381fc17cb7baf46bca0c8889b1da8dd6f46c8f	32	753134231635	11394695	0x6d381fc17cb7baf46bca0c8889b1da8dd6f46c8f	2024-03-04T18:58:57.000Z	0x92c00f805feb254a1b7e0b46710ae5e1230261a88d382c7e40560df64c71aa79

Example Query

Query with partition filter

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

LendingPool_LiquidationCall_event

Liquidation events from Aave-compatible lending protocols when undercollateralized positions are closed. Records liquidator, borrower, debt repaid, collateral seized, and asset addresses for tracking protocol risk and liquidation bot 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_collateralAsset`	`STRING`	Contract address of the asset being seized as collateral during a liquidation. Hex-encoded, 0x-prefixed, 42-character string.
`in_debtAsset`	`STRING`	Contract address of the debt asset being repaid during liquidation. 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_debtToCover`	`STRING`	Amount of debt being repaid during the liquidation operation. String-encoded integer representing the quantity in the debt asset’s smallest unit.
`in_liquidatedCollateralAmount`	`STRING`	Amount of collateral seized from the liquidated position. String-encoded integer representing the quantity in the collateral asset’s smallest unit.
`in_liquidator`	`STRING`	Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiveAToken`	`BOOL`	Boolean flag indicating whether the liquidator receives aTokens instead of the underlying collateral asset during liquidation.

Sample Data

address	in_user	removed	log_index	block_number	in_debtAsset	in_liquidator	in_debtToCover	block_timestamp	in_receiveAToken	transaction_hash	in_collateralAsset	in_liquidatedCollateralAmount
0x8f44fd754285aa6a2b8b9b97739b79746e0475a7	0x774c24a48d26cf565f78f3811eef01e69a8456fb	false	131	15072838	0x4200000000000000000000000000000000000006	0xca1f59b6f5d84984d99b0b1712803fccdbc8f57c	1021127883872019	2024-05-28T22:23:43.000Z	false	0x8b9da0adc702a4f3322d44b89044e150321dd72d4916f246758ee137c9961642	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	4133729
0x8f44fd754285aa6a2b8b9b97739b79746e0475a7	0x53fe73a960c67022de328a4f631d46b10b8e680f	false	251	20903076	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	0x36817c561e2017587329537d7160da3badaee673	155269	2024-10-10T21:24:59.000Z	false	0x3e81697d8f0db072be16beb60d38259ff4a4c788716f8fbfe78504c219aa0969	0x4200000000000000000000000000000000000006	68921847811967
0x8f44fd754285aa6a2b8b9b97739b79746e0475a7	0xb1f876dfa59e0fe54412959ab6f240e15feb6564	false	343	20897852	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	0x36817c561e2017587329537d7160da3badaee673	433776	2024-10-10T18:30:51.000Z	false	0x88e5a1908634ffaf1152a08129e0e9c8c5c9dfabeb9fc25b7708ee54318c73f8	0x4200000000000000000000000000000000000006	195292529635463

Example Query

Query with partition filter

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

LendingPool_MintedToTreasury_event

Aave V3 protocol event recording interest-bearing token mints to the treasury reserve. Contains reserve address, amount minted, and transaction identifiers for tracking protocol fee accumulation.

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_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountMinted`	`STRING`	Amount of interest-bearing tokens minted to the protocol treasury. String representation of an unsigned integer value.

Sample Data

address	removed	log_index	in_reserve	block_number	block_timestamp	in_amountMinted	transaction_hash
0x8f44fd754285aa6a2b8b9b97739b79746e0475a7	false	310	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	21419101	2024-10-22T20:05:49.000Z	4682880810	0xc776fc90c059b1dcbc9847b1abd9bb8bda005886a4a504ab34b52b39612180de
0x8f44fd754285aa6a2b8b9b97739b79746e0475a7	false	319	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	21419101	2024-10-22T20:05:49.000Z	39598526019483457	0xc776fc90c059b1dcbc9847b1abd9bb8bda005886a4a504ab34b52b39612180de
0x8f44fd754285aa6a2b8b9b97739b79746e0475a7	false	315	0x4200000000000000000000000000000000000006	21419101	2024-10-22T20:05:49.000Z	3142295571699829608	0xc776fc90c059b1dcbc9847b1abd9bb8bda005886a4a504ab34b52b39612180de

Example Query

Query with partition filter

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

LendingPool_Repay_event

Loan repayment events from Aave-based lending protocols containing borrower address, repayer address, reserve asset, and repayment amount. Used for tracking debt reduction and loan lifecycle analysis across DeFi 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_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. 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_repayer`	`STRING`	Address of the account that executed the repayment 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_useATokens`	`BOOL`	Boolean flag indicating whether aTokens (interest-bearing deposit tokens) were used to repay the debt instead of the underlying reserve asset.

Sample Data

address	in_user	removed	in_amount	log_index	in_repayer	in_reserve	block_number	in_useATokens	block_timestamp	transaction_hash
0x8f44fd754285aa6a2b8b9b97739b79746e0475a7	0x36d206bdaee30c298dec463a219d3138d7af9592	false	112612265448453490	42	0x36d206bdaee30c298dec463a219d3138d7af9592	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	10390980	false	2024-02-10T13:21:47.000Z	0x4cd1190e82b1626ba717ab329b4e0bdbab58e233124ef6921be82c2b590848ca
0x8f44fd754285aa6a2b8b9b97739b79746e0475a7	0x5866b8e89058ccf1d92fecc0a1b4fd2695e6c446	false	3850252879823283593	46	0x5866b8e89058ccf1d92fecc0a1b4fd2695e6c446	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	10388548	false	2024-02-10T12:00:43.000Z	0xca789c40cafe176e0831beccc4d1e4fc8ed0cfe70367e78ffd87bec6e21cad5f
0x8f44fd754285aa6a2b8b9b97739b79746e0475a7	0x5eaceeb491b703e22b34f8088bd2b517a6d2164b	false	1323274190652365902	35	0x5eaceeb491b703e22b34f8088bd2b517a6d2164b	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	10402990	false	2024-02-10T20:02:07.000Z	0xf74bd4aef9dd357714d40a27ba9577aea6598e44c67a162cd6675dd443c2f466

Example Query

Query with partition filter

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

LendingPool_Supply_event

Aave V3 Supply events emitted when users deposit assets into lending pools. Records depositor address, reserve token, deposit amount, beneficiary, and optional referral code for tracking liquidity provision across DeFi lending protocols.

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_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. 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_onBehalfOf`	`STRING`	Address of the account receiving the benefit of the 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.
`in_referralCode`	`STRING`	Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.

Sample Data

address	in_user	removed	in_amount	log_index	in_reserve	block_number	in_onBehalfOf	block_timestamp	transaction_hash
0x8f44fd754285aa6a2b8b9b97739b79746e0475a7	0xaa3163db743b6000d70439a0d410d24a8f9d172d	false	118293096669855588	84	0x1c7a460413dd4e964f96d8dfc56e7223ce88cd85	15124629	0xaa3163db743b6000d70439a0d410d24a8f9d172d	2024-05-30T03:10:05.000Z	0x31d8231d17958ed80a280c48a708f9b005d136ff40ebe8471ce063a875603d0a
0x8f44fd754285aa6a2b8b9b97739b79746e0475a7	0x1e65647bc43b5f864ba6286c934d85fdbbfc591f	false	14073715337716076	123	0x1c7a460413dd4e964f96d8dfc56e7223ce88cd85	15160182	0x1e65647bc43b5f864ba6286c934d85fdbbfc591f	2024-05-30T22:55:11.000Z	0x1498396b98814815e7ee9ab9ce14b9b9c27d7cda9c1e01bb3ba16fc41945478e
0x8f44fd754285aa6a2b8b9b97739b79746e0475a7	0xa274fd0d003f10b739462bbd926bcdb483c23654	false	746831074092853174	199	0x1c7a460413dd4e964f96d8dfc56e7223ce88cd85	15121577	0xa274fd0d003f10b739462bbd926bcdb483c23654	2024-05-30T01:28:21.000Z	0x080a6de2c0dda769946e1a618b7cba85c480515cf1a524df513abfae58b0680e

Example Query

Query with partition filter

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

LendingPool_Withdraw_event

Aave LendingPool withdrawal events recording asset removals from lending positions. Contains user address, reserve token address, withdrawal amount, and recipient address for tracking collateral and liquidity movements across Aave V2 and V3 deployments.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. 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_to`	`STRING`	Destination address receiving tokens or assets in the 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

in_to	address	in_user	removed	in_amount	log_index	in_reserve	block_number	block_timestamp	transaction_hash
0x23727b54163f63cffdd8b7769e0ecb13df253b4e	0x8f44fd754285aa6a2b8b9b97739b79746e0475a7	0x23727b54163f63cffdd8b7769e0ecb13df253b4e	false	27981262721876265485	39	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	13021194	2024-04-11T10:35:35.000Z	0xda227d95ae3146ddc5344baaeef32a13f084af096bf137abfb68367ee81861f9
0x330be1c3a2b5a4e999ccad4efe820a2839165e5c	0x8f44fd754285aa6a2b8b9b97739b79746e0475a7	0x330be1c3a2b5a4e999ccad4efe820a2839165e5c	false	3644000057638771	130	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	13020958	2024-04-11T10:27:43.000Z	0x5d561c948ebbd6923f88ec80ac7398435f713305e0b53608ab3eabdd266386df
0x33bd0e5b33bc65489c77dc53affd3e3df2240e27	0x8f44fd754285aa6a2b8b9b97739b79746e0475a7	0x33bd0e5b33bc65489c77dc53affd3e3df2240e27	false	186386751009842614	163	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	13007812	2024-04-11T03:09:31.000Z	0xfe6916446c7743b582f7bae45e1fbd0d41ddbf86a739ae4449e0921eeca30ff1

Example Query

Query with partition filter

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

LendingPoolConfigurator_CollateralConfigurationChanged_event

Collateral parameter update events from lending protocol configurator contracts, recording changes to loan-to-value (LTV), liquidation threshold, and liquidation bonus for specific assets. Used for tracking risk parameter adjustments in 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_ltv`	`STRING`	Loan-to-value ratio for the collateral asset. Numeric string representing basis points where 10000 equals 100%.
`in_liquidationThreshold`	`STRING`	Liquidation threshold at which a position becomes eligible for liquidation. Numeric string representing basis points where 10000 equals 100%.
`in_liquidationBonus`	`STRING`	Liquidation bonus awarded to liquidators for purchasing collateral during liquidation. Numeric string representing basis points where 10000 equals 100%.

Sample Data

in_ltv	address	removed	in_asset	log_index	block_number	block_timestamp	transaction_hash	in_liquidationBonus	in_liquidationThreshold
7700	0x7b08a77539a50218c8fb4b706b87fb799d3505a0	false	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	2	3318677	2023-08-30T20:18:21.000Z	0x5ca600417e1be8c2550dbdb0cb3b6e1b3bc7c753f38c8f4fc0db1aa5afc27543	10500	8000
7500	0x7b08a77539a50218c8fb4b706b87fb799d3505a0	false	0x4200000000000000000000000000000000000006	6	3318677	2023-08-30T20:18:21.000Z	0x5ca600417e1be8c2550dbdb0cb3b6e1b3bc7c753f38c8f4fc0db1aa5afc27543	10500	8000
3000	0x7b08a77539a50218c8fb4b706b87fb799d3505a0	false	0x940181a94a35a4569e4529a3cdfb74e38fd98631	8	14691577	2024-05-20T02:35:01.000Z	0x6ed562d55efd24fc0ac32fbfdee43d76cfeee36cac878f2c713d24f9a038b2c2	11000	4000

Example Query

Query with partition filter

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

LendingPoolConfigurator_FlashloanPremiumToProtocolUpdated_event

Aave V3 LendingPoolConfigurator event emitted when the protocol’s share of flash loan fees is updated, recording both old and new premium values in basis points. Used for tracking protocol fee parameter changes and governance decisions.

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_oldFlashloanPremiumToProtocol`	`STRING`	Previous flashloan premium allocated to the protocol treasury before the update. String-encoded integer representing basis points (0.01%), where 4 equals 0.04% and 10000 equals 100%.
`in_newFlashloanPremiumToProtocol`	`STRING`	Updated flashloan premium allocated to the protocol treasury. String-encoded integer representing basis points (0.01%), where 4 equals 0.04% and 10000 equals 100%.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newFlashloanPremiumToProtocol	in_oldFlashloanPremiumToProtocol
0x7b08a77539a50218c8fb4b706b87fb799d3505a0	false	10	3318615	2023-08-30T20:16:17.000Z	0x8b446ed6a73b9b0ab6ecc5ebd5fa75b9a582217536a44932107db3b63c86d292	4	0
0x7b08a77539a50218c8fb4b706b87fb799d3505a0	false	8	7639888	2023-12-08T20:58:43.000Z	0xb3debda80dd60cc8aaad1f51bdf9e7ab79c9aac5b27a7d7ad637d87e3ac66c32	0	4

Example Query

Query with partition filter

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

LendingPoolConfigurator_FlashloanPremiumTotalUpdated_event

Aave V3 protocol configuration event tracking changes to flash loan premium rates. Contains old and new premium values in basis points for protocol fee analysis and governance monitoring.

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_oldFlashloanPremiumTotal`	`STRING`	Previous total flash loan premium fee rate expressed in basis points.
`in_newFlashloanPremiumTotal`	`STRING`	Updated total flash loan premium fee rate expressed in basis points.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newFlashloanPremiumTotal	in_oldFlashloanPremiumTotal
0x7b08a77539a50218c8fb4b706b87fb799d3505a0	false	42	3318612	2023-08-30T20:16:11.000Z	0xa8e9f0c99e9dd5379e39abfdaace47fde892328bc5e062cc60c12d9476cd6b99	5	0
0x7b08a77539a50218c8fb4b706b87fb799d3505a0	false	7	7639888	2023-12-08T20:58:43.000Z	0xb3debda80dd60cc8aaad1f51bdf9e7ab79c9aac5b27a7d7ad637d87e3ac66c32	4	5

Example Query

Query with partition filter

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

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

Aave V3 LendingPoolConfigurator event capturing changes to liquidation protocol fee parameters. Records the asset address, previous fee value, and new fee value for each configuration update.

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_oldFee`	`STRING`	Previous liquidation protocol fee before the change. Numeric string representing basis points where 1000 equals 10%.
`in_newFee`	`STRING`	Updated liquidation protocol fee. Numeric string representing basis points where 1000 equals 10%.

Sample Data

address	removed	in_asset	log_index	block_number	block_timestamp	transaction_hash
0x7b08a77539a50218c8fb4b706b87fb799d3505a0	false	0x50c5725949a6f0c72e6c4a641f24049a917db0cb	12	7611589	2023-12-08T05:15:25.000Z	0x1f86d3f88bf5fafda3835ee867abc78784fc70d6ef412c81490af7a3f927684f
0x7b08a77539a50218c8fb4b706b87fb799d3505a0	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	20	7611575	2023-12-08T05:14:57.000Z	0x9400c876b3be7e992c43eaa9672088ac04a43dc7baa82e5fe876eba3591317fd
0x7b08a77539a50218c8fb4b706b87fb799d3505a0	false	0xc1cba3fcea344f92d9239c08c0568f6f2f0ee452	28	10068047	2024-02-03T01:57:21.000Z	0xf97277ebfb77038b19bd2af084cbe394b7bb9b58f1b80cc5058634747a51887e

Example Query

Query with partition filter

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

LendingPoolConfigurator_ReserveFactorChanged_event

Events emitted when the reserve factor parameter is modified for a lending pool asset, capturing the asset address, old factor, and new factor values. Used to track protocol fee adjustments in Aave-based lending protocols.

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_oldReserveFactor`	`STRING`	Previous reserve factor value for the asset in the lending pool before the change. Numeric string representing basis points where 10000 equals 100%.
`in_newReserveFactor`	`STRING`	Updated reserve factor value for the asset in the lending pool. Numeric string representing basis points where 10000 equals 100%.

Sample Data

address	removed	in_asset	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactor	in_oldReserveFactor
0x7b08a77539a50218c8fb4b706b87fb799d3505a0	false	0xc1cba3fcea344f92d9239c08c0568f6f2f0ee452	26	10068047	2024-02-03T01:57:21.000Z	0xf97277ebfb77038b19bd2af084cbe394b7bb9b58f1b80cc5058634747a51887e	0	0
0x7b08a77539a50218c8fb4b706b87fb799d3505a0	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	159	23320114	2024-12-05T20:12:55.000Z	0x7ae3dba030c0a9aecc9e230027fec907031fa12417b541393043ff7ad441d2a0	1000	500
0x7b08a77539a50218c8fb4b706b87fb799d3505a0	false	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	157	23320114	2024-12-05T20:12:55.000Z	0x7ae3dba030c0a9aecc9e230027fec907031fa12417b541393043ff7ad441d2a0	2500	1500

Example Query

Query with partition filter

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

LendingPoolConfigurator_ReserveInitialized_event

Aave protocol events emitted when new lending reserves are initialized in the LendingPoolConfigurator contract, recording the deployed aToken, stable debt token, variable debt token, and interest rate strategy addresses for each asset.

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_aToken`	`STRING`	Contract address of the aToken associated with the reserve. Hex-encoded, 0x-prefixed, 42-character string.
`in_stableDebtToken`	`STRING`	Contract address of the stable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
`in_variableDebtToken`	`STRING`	Contract address of the variable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
`in_interestRateStrategyAddress`	`STRING`	Contract address of the interest rate strategy contract for the reserve. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_asset	in_aToken	log_index	block_number	block_timestamp	transaction_hash	in_stableDebtToken	in_variableDebtToken	in_interestRateStrategyAddress
0x7b08a77539a50218c8fb4b706b87fb799d3505a0	false	0x44b74efddd5f6a2d13a529cb45d861c58d805beb	0xbd1a085ea96045654add8261be355c1db094f86b	1021	22856175	2024-11-25T02:28:17.000Z	0x48ea1d3f188b580eabc6459950348c6bf832563e03b8a19aa10a58997c7bc887	0x4ddaa75cb4d43e4e583002705b433ede602049e6	0x827ca14618c59361643f40a798d378ac7319db78	0x4c1345dc4267d56c0f7ae996611482f655f1af5a
0x7b08a77539a50218c8fb4b706b87fb799d3505a0	false	0xc9ae3b5673341859d3ac55941d27c8be4698c9e4	0xb01c5c4eb40d2f2b64daa3170f89849d00ea6b44	26	10888116	2024-02-22T01:32:59.000Z	0x517999aca10d9c1ed966fe324d82ace981e3ac513c2d453c86d10c36159c28aa	0x3eb1ae14baedcc443229913c90b0c014dec87768	0xf2306020be299477fdd387befd47c6140b03e195	0xced653f5c689ec80881b1a8b9ab2b64df2b963bd
0x7b08a77539a50218c8fb4b706b87fb799d3505a0	false	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	0x13a13869b814be8f13b86e9875ab51bda882e391	23	3318672	2023-08-30T20:18:11.000Z	0xcef54385e7487729c5b2f00cae8b7592465772421f164c5eef7e3c7df732b95e	0x18927a44e185cbf8719c4def5fb069f2b807af5b	0x326441fa5016d946e6e82e807875fdfdc3041b3b	0x0ffc5886d69cc3c432ed421515c2a3b831db9210

Example Query

Query with partition filter

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

LeverageManager_ManagementFeeCharged_event

Management fee events from Seamless Protocol’s leverage token manager on Base, recording fees charged in shares for each leveraged position token. Used for tracking protocol revenue and fee accrual across different leverage products.

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_leverageToken`	`STRING`	Contract address of the leverage token for which the management fee was charged on Seamless Protocol. Hex-encoded, 0x-prefixed 40-character string representing the EVM token contract on Base chain.
`in_sharesFee`	`STRING`	Number of shares taken as a management fee from the leverage token position. Denominated in the leverage token’s share units; sample data shows zero fees, indicating fee collection may be periodic or conditional.

Sample Data

address	removed	log_index	block_number	block_timestamp	in_leverageToken	transaction_hash
0x38ba21c6bf31df1b1798fced07b4e9b07c5ec3a8	false	325	32390388	2025-07-03T19:15:23.000Z	0xa2fceeae99d2caeee978da27be2d95b0381dbb8c	0x1b9a7c537b738017a118560ae4ea989cac5f51a7f7c85f55e7055a4d22492446
0x38ba21c6bf31df1b1798fced07b4e9b07c5ec3a8	false	3748	32391810	2025-07-03T20:02:47.000Z	0xa2fceeae99d2caeee978da27be2d95b0381dbb8c	0x2640851a226e592172b174b17ecd5cd46b1ab51605e33aeffa4453e1f2669415
0x38ba21c6bf31df1b1798fced07b4e9b07c5ec3a8	false	152	31651208	2025-06-16T16:36:03.000Z	0xa2fceeae99d2caeee978da27be2d95b0381dbb8c	0x3cb7f94ea6bef45ded50a98f1dbce79d30a84b59ace946e00ac8ef9bc60791f8

Example Query

Query with partition filter

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

LeverageManager_Mint_event

Leveraged position mint events from Seamless Protocol v1 on Base, capturing debt issuance, collateral deposits, equity contributions, and share allocations when users open or increase leveraged positions. Used for tracking leverage utilization, position sizing, and protocol TVL (Total Value Locked) growth.

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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_actionData`	`STRUCT<collateral STRING, debt STRING, equity STRING, shares STRING, tokenFee STRING, treasuryFee STRING>`	Structured data containing financial metrics for the leverage operation. Fields include collateral, debt, shares, tokenFee, and treasuryFee amounts as numeric strings representing token quantities in smallest denomination.

Sample Data

address	removed	in_token	in_sender	log_index	block_number	in_actionData	block_timestamp	transaction_hash
0x38ba21c6bf31df1b1798fced07b4e9b07c5ec3a8	false	0xa2fceeae99d2caeee978da27be2d95b0381dbb8c	0xdba92fc3dc10a17b96b6e807a908155c389a887c	155	31731214	{“debt”:“38361393654852501660”,“equity”:“2249999999999997996”,“shares”:“2212924635077182793”,“tokenFee”:“0”,“collateral”:“38099514596742693894”,“treasuryFee”:“0”}	2025-06-18T13:02:55.000Z	0xeafda0ddee95fc990deacc8fc68cbaf8de460a9e8f9a3369cfa4fbe445108d0e
0x38ba21c6bf31df1b1798fced07b4e9b07c5ec3a8	false	0xa2fceeae99d2caeee978da27be2d95b0381dbb8c	0xdba92fc3dc10a17b96b6e807a908155c389a887c	50	31731796	{“debt”:“182440691524788722643”,“equity”:“10700605847316776840”,“shares”:“10524315745065372386”,“tokenFee”:“0”,“collateral”:“181195199779527043694”,“treasuryFee”:“0”}	2025-06-18T13:22:19.000Z	0x67de5d13ee71e2900d62909f59b8675788c4ae6d3be52ed35bc7b57304c3acb4
0x38ba21c6bf31df1b1798fced07b4e9b07c5ec3a8	false	0xa2fceeae99d2caeee978da27be2d95b0381dbb8c	0xdba92fc3dc10a17b96b6e807a908155c389a887c	225	31745255	{“debt”:“17032469640259”,“equity”:“999999997998”,“shares”:“982533871237”,“tokenFee”:“0”,“collateral”:“16916104134601”,“treasuryFee”:“0”}	2025-06-18T20:50:57.000Z	0x5f3c23e12fc2b0a76b75f04ce8fbbcc1bef86faa1ccc8d1e673cd5f633f38e8d

Example Query

Query with partition filter

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

LeverageManager_Rebalance_event

Rebalance events from Seamless Protocol’s Leverage Manager on Base, recording adjustments to leveraged positions. Captures before/after position states including debt, equity, and collateral ratios, plus the specific actions taken (borrow/repay indicated by actionType) for analyzing automated leverage maintenance strategies.

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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_stateBefore`	`STRUCT<collateralInDebtAsset STRING, debt STRING, equity STRING, collateralRatio STRING>`	Position state snapshot before the rebalancing operation, including debt balance, equity value, collateral ratio, and total collateral value denominated in the debt asset. All monetary values are in wei (18 decimals).
`in_stateAfter`	`STRUCT<collateralInDebtAsset STRING, debt STRING, equity STRING, collateralRatio STRING>`	Position state snapshot after the rebalance action, including debt, equity, collateral ratio, and collateral value denominated in the debt asset. Values are wei-denominated (18 decimals) and capture the leveraged position’s financial status post-execution.
`in_actions`	`ARRAY<STRUCT<actionType INT64, amount STRING>>`	Array of leverage actions executed during the rebalance, where actionType 0 represents collateral deposits and actionType 2 represents debt borrows, with amounts specified in wei. Each rebalance typically includes paired actions to adjust the position’s collateral ratio.

Sample Data

address	removed	in_token	in_sender	log_index	in_actions	block_number	in_stateAfter	in_stateBefore	block_timestamp	transaction_hash
0x38ba21c6bf31df1b1798fced07b4e9b07c5ec3a8	false	0xa2fceeae99d2caeee978da27be2d95b0381dbb8c	0xa530e6ea09eb118a1549aca73731379ba546dd32	321	[{“amount”:“1941222808559226837”,“actionType”:0},{“amount”:“2076791679515269768”,“actionType”:2}]	31568477	{“debt”:“326989528258465105389”,“equity”:“20451239306549952901”,“collateralRatio”:“1062544019117286552”,“collateralInDebtAsset”:“347440767565015058290”}	{“debt”:“324912736578949835621”,“equity”:“20451267576750694200”,“collateralRatio”:“1062943877768796808”,“collateralInDebtAsset”:“345364004155700529821”}	2025-06-14T18:38:21.000Z	0xfd24aa05221927ac11be0487e051fe3a8fae310bdb16022fc9d80ccaddcfedbc
0x38ba21c6bf31df1b1798fced07b4e9b07c5ec3a8	false	0xa2fceeae99d2caeee978da27be2d95b0381dbb8c	0xa530e6ea09eb118a1549aca73731379ba546dd32	371	[{“amount”:“1374848520404712075”,“actionType”:0},{“amount”:“1471526705028740386”,“actionType”:2}]	31827722	{“debt”:“732801370127578631531”,“equity”:“46014611519508344508”,“collateralRatio”:“1062792747660252507”,“collateralInDebtAsset”:“778815981647086976039”}	{“debt”:“731329843422549891145”,“equity”:“46014678134389331898”,“collateralRatio”:“1062919185574384986”,“collateralInDebtAsset”:“777344521556939223043”}	2025-06-20T18:39:51.000Z	0x28e3b958912eda23e9bb1a3db8effc8500b0a41885bab6575ce8c0a8dc028776
0x38ba21c6bf31df1b1798fced07b4e9b07c5ec3a8	false	0xa2fceeae99d2caeee978da27be2d95b0381dbb8c	0xa530e6ea09eb118a1549aca73731379ba546dd32	901	[{“amount”:“34807975292940599”,“actionType”:0},{“amount”:“37226230358524438”,“actionType”:2}]	31352453	{“debt”:“5788707041008643516”,“equity”:“362375340823784906”,“collateralRatio”:“1062600393880123431”,“collateralInDebtAsset”:“6151082381832428422”}	{“debt”:“5751480810650119078”,“equity”:“362375847563587198”,“collateralRatio”:“1063005660540946152”,“collateralInDebtAsset”:“6113856658213706276”}	2025-06-09T18:37:33.000Z	0x9598ae45e4fed0849bef3defec7e3bb725b96ef4f1d5e9125931706b2a2e1716

Example Query

Query with partition filter

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

LeverageManager_Redeem_event

Leverage position redemption events from Seamless Protocol v1 lending protocol on Base, capturing position closures with debt repayment, equity withdrawal, collateral release, and fee calculations. Used for analyzing leveraged position management, redemption patterns, and protocol fee collection.

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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_actionData`	`STRUCT<collateral STRING, debt STRING, equity STRING, shares STRING, tokenFee STRING, treasuryFee STRING>`	Structured data containing financial metrics for the leverage operation. Fields include collateral, debt, shares, tokenFee, and treasuryFee amounts as numeric strings representing token quantities in smallest denomination.

Sample Data

address	removed	in_token	in_sender	log_index	block_number	in_actionData	block_timestamp	transaction_hash
0x38ba21c6bf31df1b1798fced07b4e9b07c5ec3a8	false	0xa2fceeae99d2caeee978da27be2d95b0381dbb8c	0xdba92fc3dc10a17b96b6e807a908155c389a887c	269	31746224	{“debt”:“350718008990978”,“equity”:“20591008731839”,“shares”:“20251718635226”,“tokenFee”:“20591008732”,“collateral”:“348321776587619”,“treasuryFee”:“0”}	2025-06-18T21:23:15.000Z	0xde8f0a561bb320c7ee851e4e0c08bcf3e6e0e16ec3eb6937b262acf8efc794b9
0x38ba21c6bf31df1b1798fced07b4e9b07c5ec3a8	false	0xa2fceeae99d2caeee978da27be2d95b0381dbb8c	0xdba92fc3dc10a17b96b6e807a908155c389a887c	56	31745518	{“debt”:“169617106335083”,“equity”:“9958438852313”,“shares”:“9794304219207”,“tokenFee”:“9958438853”,“collateral”:“168458267990263”,“treasuryFee”:“0”}	2025-06-18T20:59:43.000Z	0x4beb35c8aca1461d8320ad8705778b64c9461f1f8442289bee23afc6841bf5dd
0x38ba21c6bf31df1b1798fced07b4e9b07c5ec3a8	false	0xa2fceeae99d2caeee978da27be2d95b0381dbb8c	0xdba92fc3dc10a17b96b6e807a908155c389a887c	155	31745487	{“debt”:“169617071980058”,“equity”:“9958438902316”,“shares”:“9794302358352”,“tokenFee”:“9958438903”,“collateral”:“168458235936985”,“treasuryFee”:“0”}	2025-06-18T20:58:41.000Z	0xda8789584769e762a090f6e84957618a6c79cdcaed5984e43833d14ae6d85364

Example Query

Query with partition filter

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

LeverageToken_Approval_event

ERC-20 token approval events from Seamless Protocol leverage tokens on Base, recording when token holders authorize spenders to transfer specified amounts on their behalf. Used for tracking delegation permissions and analyzing protocol interaction 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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_spender`	`STRING`	Address authorized to spend tokens on behalf of the owner. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_owner	in_value	log_index	in_spender	block_number	block_timestamp	transaction_hash
0xa2fceeae99d2caeee978da27be2d95b0381dbb8c	false	0x7b5a3297c0f37484e2ca7956aec068778cb021ed	913925043231016	114	0xdba92fc3dc10a17b96b6e807a908155c389a887c	31948150	2025-06-23T13:34:07.000Z	0xbc90f583286e66ee554c6330c547a4e8908be273a6dd871aec5cd1af731466be
0xa2fceeae99d2caeee978da27be2d95b0381dbb8c	false	0xda7a1ab9fbc0c41f0210f5cceb56b0527b61af5d	9897004645068056	484	0xdba92fc3dc10a17b96b6e807a908155c389a887c	31485225	2025-06-12T20:23:17.000Z	0xf9f7eb13904149ed24e630e4af8ddfb6e0903c689e203c611f8e9b1f380192c4
0xa2fceeae99d2caeee978da27be2d95b0381dbb8c	false	0xda7a1ab9fbc0c41f0210f5cceb56b0527b61af5d	9910884913077670	108	0xdba92fc3dc10a17b96b6e807a908155c389a887c	31480323	2025-06-12T17:39:53.000Z	0xeab9a4af5771c3964409e1695355345c547307f8eeec4d5208f2f919205950b8

Example Query

Query with partition filter

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

LeverageToken_Initialized_event

Initialization events for leverage token contracts deployed on Seamless Protocol V1 on Base chain. Records contract deployment addresses and timestamps for tracking new leveraged position token launches.

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_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

address	removed	log_index	in_version	block_number	block_timestamp	transaction_hash
0xa2fceeae99d2caeee978da27be2d95b0381dbb8c	false	694	1	31052857	2025-06-02T20:11:01.000Z	0x1150276740a310b6bf1edaa4b8bf5c76bfe4effa2103802f1c29ea1ea604f8cd

Example Query

Query with partition filter

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

LeverageToken_LeverageTokenInitialized_event

Initialization events for Seamless Protocol leverage tokens on Base, recording when new leveraged token products (e.g., weETH/WETH 17x) are created with their trading symbols and contract addresses. Used for tracking the deployment and configuration of leveraged trading products in the protocol.

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_name`	`STRING`	Name or label identifier for the entity being created, registered, or updated in the event.
`in_symbol`	`STRING`	Symbol of the token involved in the transaction or event.

Sample Data

address	in_name	removed	in_symbol	log_index	block_number	block_timestamp	transaction_hash
0xa2fceeae99d2caeee978da27be2d95b0381dbb8c	weETH / WETH 17x Leverage Token	false	WEETH-WETH-17x	693	31052857	2025-06-02T20:11:01.000Z	0x1150276740a310b6bf1edaa4b8bf5c76bfe4effa2103802f1c29ea1ea604f8cd

Example Query

Query with partition filter

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

LeverageToken_Transfer_event

Transfer events for leveraged token positions in Seamless Protocol on Base, capturing mints, burns, and transfers between addresses. Useful for tracking leverage token issuance and holder activity across the protocol.

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_from`	`STRING`	Address originating the transfer or 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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

in_to	address	in_from	removed	log_index	block_number	block_timestamp	transaction_hash
0x639d2dd24304ac2e6a691d8c1cff4a2665925fee	0xa2fceeae99d2caeee978da27be2d95b0381dbb8c	0x0000000000000000000000000000000000000000	false	699	32530122	2025-07-07T00:53:11.000Z	0x83877f2b8ca5a34c297f7796b068a8b00ead6ef55327a9a828022b59813ea0cb
0x639d2dd24304ac2e6a691d8c1cff4a2665925fee	0xa2fceeae99d2caeee978da27be2d95b0381dbb8c	0x0000000000000000000000000000000000000000	false	696	32530122	2025-07-07T00:53:11.000Z	0x83877f2b8ca5a34c297f7796b068a8b00ead6ef55327a9a828022b59813ea0cb
0x639d2dd24304ac2e6a691d8c1cff4a2665925fee	0xa2fceeae99d2caeee978da27be2d95b0381dbb8c	0x0000000000000000000000000000000000000000	false	1007	32530143	2025-07-07T00:53:53.000Z	0x95a85f2f9df3f2bc6d1addcc259cc41a697e12384235ff36b3093486f875be2e

Example Query

Query with partition filter

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

LeverageTokenFactory_BeaconProxyCreated_event

Beacon proxy deployment events from Seamless Protocol’s leverage token factory on Base, capturing when new leveraged position proxies are created with their addresses and initialization data. Used for tracking leverage token contract deployments and analyzing protocol growth.

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_proxy`	`STRING`	Contract address of the newly created proxy contract. Hex-encoded, 0x-prefixed, 42-character string.
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.
`in_baseSalt`	`STRING`	Base salt value used as input to deterministically generate the proxy contract address. Hex-encoded 32-byte value, typically zero for default deployments as seen in sample data.

Sample Data

address	in_data	removed	in_proxy	log_index	in_baseSalt	block_number	block_timestamp	transaction_hash
0xe0b2e40edeb53b96c923381509a25a615c1abe57	0x9065714700000000000000000000000038ba21c6bf31df1b1798fced07b4e9b07c5ec3a8000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000001f7765455448202f205745544820313778204c6576657261676520546f6b656e00000000000000000000000000000000000000000000000000000000000000000e57454554482d574554482d313778000000000000000000000000000000000000	false	0xa2fceeae99d2caeee978da27be2d95b0381dbb8c	695	0x0000000000000000000000000000000000000000000000000000000000000000	31052857	2025-06-02T20:11:01.000Z	0x1150276740a310b6bf1edaa4b8bf5c76bfe4effa2103802f1c29ea1ea604f8cd

Example Query

Query with partition filter

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

MetaMorphoV1_AccrueInterest_event

Interest accrual events from MetaMorpho vaults on Seamless Protocol (Base), recording fee share allocations and total asset updates. Used for tracking vault performance, fee generation, and asset growth over time.

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_newTotalAssets`	`STRING`	Updated total asset value in the vault after interest accrual. Numeric string representation of the asset quantity in the vault’s base denomination.
`in_feeShares`	`STRING`	Number of fee shares minted to the protocol during the interest accrual event. Numeric string representation of share quantity.

Sample Data

address	removed	log_index	block_number	in_feeShares	block_timestamp	transaction_hash	in_newTotalAssets
0x27d8c7273fd3fcc6956a0b370ce5fd4a7fc65c18	false	325	26470070	513351025628	2025-02-16T18:11:27.000Z	0x1237da9d6b5635af81f6f057a0026c1b6a55885b9fc1c4f6376f4d49d8623002	4070771080971240285
0x27d8c7273fd3fcc6956a0b370ce5fd4a7fc65c18	false	397	26443960	12561737697	2025-02-16T03:41:07.000Z	0x735f0926214286a30f7846b0d283afc5ee76494aef649a304bd6076944cec34f	5600676815636392
0x27d8c7273fd3fcc6956a0b370ce5fd4a7fc65c18	false	166	26469329	17959636443730	2025-02-16T17:46:45.000Z	0xc4d5da79d3c1f29a969162953524e4cfa444dcae3458813ace046013fd9c58ac	4410719564766518123

Example Query

Query with partition filter

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

MetaMorphoV1_Approval_event

ERC-20 token approval events from Seamless Protocol’s MetaMorpho vault contracts on Base, recording owner addresses granting spending allowances to spender addresses. Used for tracking vault share approvals and delegated access 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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_spender`	`STRING`	Address authorized to spend tokens on behalf of the owner. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_owner	in_value	log_index	in_spender	block_number	block_timestamp	transaction_hash
0x5a47c803488fe2bb0a0eaaf346b420e4df22f3c7	false	0x166ce42df5f4baa94abc5b62c60dab1b3c73d2a3	499890552250199954	412	0x23055618898e202386e6c13955a58d3c68200bfb	26282700	2025-02-12T10:05:47.000Z	0x7620dde91e91f03a8b151f4649a1c540959d1ecc7f5ac331e8cef3122da8a7a5
0x5a47c803488fe2bb0a0eaaf346b420e4df22f3c7	false	0x166ce42df5f4baa94abc5b62c60dab1b3c73d2a3	2499441710828389554	271	0x23055618898e202386e6c13955a58d3c68200bfb	26295423	2025-02-12T17:09:53.000Z	0x376b5c79ac1b1264dc1f37a4451fd2e5a57adfe6b557fc7de75e4316246e8966
0x5a47c803488fe2bb0a0eaaf346b420e4df22f3c7	false	0x166ce42df5f4baa94abc5b62c60dab1b3c73d2a3	999781062190964127	76	0x23055618898e202386e6c13955a58d3c68200bfb	26288864	2025-02-12T13:31:15.000Z	0x29d63cc02732969b44b1272d677082dbe50de0443b738d0719a0ef5c4e635712

Example Query

Query with partition filter

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

MetaMorphoV1_Deposit_event

Deposit events from MetaMorpho V1 vaults on Seamless Protocol (Base), capturing asset deposits with corresponding share issuance, sender and owner addresses. Used for tracking vault inflows, share-to-asset conversion rates, and user deposit behavior.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x27d8c7273fd3fcc6956a0b370ce5fd4a7fc65c18	false	0x752809e236a5dd4ef83b34f138200d7c05cacebc	442793692654301	0x23055618898e202386e6c13955a58d3c68200bfb	442774343557651	406	26371275	2025-02-14T11:18:17.000Z	0x783daf7db3a2e3db2d1ed468e09dc267b33a90a72177050ee34067c37d8ad80a
0x27d8c7273fd3fcc6956a0b370ce5fd4a7fc65c18	false	0x752809e236a5dd4ef83b34f138200d7c05cacebc	300000000000000	0x23055618898e202386e6c13955a58d3c68200bfb	299981153896886	1060	26391693	2025-02-14T22:38:53.000Z	0x367321b4516bdb05653f65e112c32f4dbf3669aee56e86c0fbb829c7dd5ea3ed
0x27d8c7273fd3fcc6956a0b370ce5fd4a7fc65c18	false	0x752809e236a5dd4ef83b34f138200d7c05cacebc	500000000000000	0x23055618898e202386e6c13955a58d3c68200bfb	499968272605158	382	26392327	2025-02-14T23:00:01.000Z	0xb41433c4146135b15bf3fdca34372e0650501ac605b570b922dee7ae22fa9ecb

Example Query

Query with partition filter

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

MetaMorphoV1_Transfer_event

ERC-20 token transfer events from MetaMorpho vault contracts on Seamless Protocol (Base), tracking share token mints, burns, and transfers between depositor addresses. Used for analyzing vault deposit/withdrawal activity and share token holder 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_from`	`STRING`	Address originating the transfer or 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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

in_to	address	in_from	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0xd6dcf20e30c1a897d2a30ddda0206e09d8fe0329	0x5a47c803488fe2bb0a0eaaf346b420e4df22f3c7	0x0000000000000000000000000000000000000000	false	690452664812563870	294	26178667	2025-02-10T00:18:01.000Z	0xa6f8a26bcca86a60c5794aca9811a37e33f4fde51ea8aec2f50f36c398640d0f
0x82c30b9db2e3b92ace4e1593b32890dcf8612d03	0x5a47c803488fe2bb0a0eaaf346b420e4df22f3c7	0x0000000000000000000000000000000000000000	false	12587639538419	291	26178667	2025-02-10T00:18:01.000Z	0xa6f8a26bcca86a60c5794aca9811a37e33f4fde51ea8aec2f50f36c398640d0f
0xebd65d1b26f715fc87caf1c12f0cad36ce44fdf5	0x5a47c803488fe2bb0a0eaaf346b420e4df22f3c7	0x0000000000000000000000000000000000000000	false	104899923886797416	596	26179126	2025-02-10T00:33:19.000Z	0xa36002d209c0525d31767f326141abe48c8b93f229c79ce49cde9334a3addc38

Example Query

Query with partition filter

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

MetaMorphoV1_UpdateLastTotalAssets_event

Total asset value updates from MetaMorpho vault contracts on Seamless Protocol (Base), tracking vault balance changes over time. Used for monitoring vault performance and asset under management (AUM) trends.

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_updatedTotalAssets`	`STRING`	Updated total value of assets managed by the vault after a state change. String-encoded numeric value representing the total asset amount.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_updatedTotalAssets
0x616a4e1db48e22028f6bbf20444cd3b8e3273738	false	197	25223987	2025-01-18T21:55:21.000Z	0x0ced843b63f32d6333f15728d70ea57723fb216337c59a37a9a6538e07577bf5	26668441988
0x616a4e1db48e22028f6bbf20444cd3b8e3273738	false	186	25223987	2025-01-18T21:55:21.000Z	0x0ced843b63f32d6333f15728d70ea57723fb216337c59a37a9a6538e07577bf5	26667441988
0x616a4e1db48e22028f6bbf20444cd3b8e3273738	false	102	25224056	2025-01-18T21:57:39.000Z	0x330e730b1baea35e8bb34cb6df725320686045f902433e1cd49888802641e58c	26669450375

Example Query

Query with partition filter

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

MetaMorphoV1_UpdateLostAssets_event

MetaMorpho vault lost asset update events from Seamless Protocol on Base, recording changes to unrecoverable asset amounts in lending vaults. Tracks vault risk management actions for monitoring protocol health and liquidation scenarios.

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_newLostAssets`	`STRING`	Updated amount of lost assets in the MetaMorpho vault. String-encoded integer representing the new total value of assets considered permanently lost or irrecoverable.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x27d8c7273fd3fcc6956a0b370ce5fd4a7fc65c18	false	46	26445343	2025-02-16T04:27:13.000Z	0xf1791b3c7eb392800810698a70feffbd6ade87b54442c00089b1e69499009b6c
0x27d8c7273fd3fcc6956a0b370ce5fd4a7fc65c18	false	323	26470070	2025-02-16T18:11:27.000Z	0x1237da9d6b5635af81f6f057a0026c1b6a55885b9fc1c4f6376f4d49d8623002
0x27d8c7273fd3fcc6956a0b370ce5fd4a7fc65c18	false	395	26443960	2025-02-16T03:41:07.000Z	0x735f0926214286a30f7846b0d283afc5ee76494aef649a304bd6076944cec34f

Example Query

Query with partition filter

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

MetaMorphoV1_Withdraw_event

Withdrawal events from MetaMorpho V1 vaults on Seamless Protocol (Base), recording when users redeem vault shares for underlying assets. Tracks share-to-asset conversion rates for analyzing vault redemptions and 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_sender`	`STRING`	Address that initiated the transaction or operation. 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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0x616a4e1db48e22028f6bbf20444cd3b8e3273738	false	0x08dc2df1f028ea34ba1e1bdc91666fda11554c72	50000011	0x08dc2df1f028ea34ba1e1bdc91666fda11554c72	49845838938345474302	417	0x08dc2df1f028ea34ba1e1bdc91666fda11554c72	25957983	2025-02-04T21:41:53.000Z	0xf40da1c15f7b4713c9f8de63d99cfe5a0f888fb9f230f143b610eb3790806ded
0x616a4e1db48e22028f6bbf20444cd3b8e3273738	false	0x09d4e55b40e645ec08bdfb06b5072d952d30e60d	50032810	0x09d4e55b40e645ec08bdfb06b5072d952d30e60d	49882751153979409987	494	0x09d4e55b40e645ec08bdfb06b5072d952d30e60d	25926357	2025-02-04T04:07:41.000Z	0x760cbdc9e5be613249ff299b4f0c6ad668334eeedd3d2d4846e5b798ba99f5b1
0x616a4e1db48e22028f6bbf20444cd3b8e3273738	false	0x0c27a77697e045be095df18221b2a601ab8afeab	111085595668	0x0c27a77697e045be095df18221b2a601ab8afeab	110754845256032568052748	264	0x0c27a77697e045be095df18221b2a601ab8afeab	25918997	2025-02-04T00:02:21.000Z	0x9cf099d279c237a60089705b23f770085a7b9f073166ec761a912e2aed46c49d

Example Query

Query with partition filter

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

RewardsController_Accrued_event

Reward accrual events from Seamless Protocol lending markets on Base, tracking incremental rewards earned by users for depositing or borrowing specific assets. Used for analyzing liquidity mining incentive distribution and user reward accumulation over time.

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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. 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_assetIndex`	`STRING`	Index tracking the cumulative reward distribution state for the specified asset at the time of accrual. Updates with each reward calculation to determine newly accrued rewards since the last user interaction.
`in_userIndex`	`STRING`	User’s current reward index position for the specified asset-reward pair. Tracks the user’s accrual state using a high-precision integer representing their index in the rewards distribution calculation.
`in_rewardsAccrued`	`STRING`	Cumulative amount of rewards accrued to the user for the specific asset-reward pair at the time of the event. Denominated in the smallest unit of the reward token, with values ranging from zero to billions.

Sample Data

address	in_user	removed	in_asset	in_reward	log_index	block_number	in_userIndex	in_assetIndex	block_timestamp	transaction_hash	in_rewardsAccrued
0x91ac2fff8cbef5859eaa6dda661febd533cd3780	0x44bcaf5bb272726188f5d07552a27b5010e4fb09	false	0x48bf8fcd44e2977c8a9a744658431a8e6c0d866c	0x998e44232bef4f8b033e5a5175bdc97f2b10d5e5	62	17494940	55269279050868997267412007413	55269279050868997267412007413	2024-07-24T00:00:27.000Z	0xf2326bb2cd7b476f54c68ff3332513b79f365ec409939d2b47eebb60df20c6cd	56210982
0x91ac2fff8cbef5859eaa6dda661febd533cd3780	0x44bcaf5bb272726188f5d07552a27b5010e4fb09	false	0x48bf8fcd44e2977c8a9a744658431a8e6c0d866c	0x1c7a460413dd4e964f96d8dfc56e7223ce88cd85	61	17494940	9026716392188690051752000169	9026716392188690051752000169	2024-07-24T00:00:27.000Z	0xf2326bb2cd7b476f54c68ff3332513b79f365ec409939d2b47eebb60df20c6cd	3012618
0x91ac2fff8cbef5859eaa6dda661febd533cd3780	0x8ab99568516898927ccddcc96680729b54430261	false	0x48bf8fcd44e2977c8a9a744658431a8e6c0d866c	0x998e44232bef4f8b033e5a5175bdc97f2b10d5e5	154	17494962	55269365918846960057207359222	55269365918846960057207359222	2024-07-24T00:01:11.000Z	0x31019ec97f69085f005e100295da31f7279cc960f6f876769216e145a9832b5a	0

Example Query

Query with partition filter

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

RewardsController_AccruedIndexChange_event

Reward accrual index updates for user positions in Seamless Protocol lending markets on Base. Tracks changes to user-specific reward indexes and accumulated rewards across different assets and reward tokens for analyzing incentive distribution.

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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. 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_oldUserIndex`	`STRING`	User’s previous reward accrual index value for the asset-reward pair before this update. Stored as a high-precision integer representing the rewards calculation state; zero indicates first-time accrual tracking.
`in_oldRewardsAccrued`	`STRING`	Previous cumulative amount of rewards accrued to the user for this asset-reward pair before the index update. Typically starts at ‘0’ for first-time interactions and updates as rewards accumulate over time.
`in_newUserIndex`	`STRING`	Updated reward index for the user’s position in the specified asset after this accrual event. High-precision decimal value scaled by 10^27, representing the cumulative reward calculation factor.
`in_newRewardsAccrued`	`STRING`	Updated quantity of reward tokens accrued by the user for this asset-reward pair after the index change. Represented as a large integer string, commonly ‘0’ when only index positions are being updated without immediate reward accumulation.

Sample Data

address	in_user	removed	in_asset	in_reward	log_index	block_number	block_timestamp	in_newUserIndex	transaction_hash
0x91ac2fff8cbef5859eaa6dda661febd533cd3780	0xcd07da92d4be4a79baa895a0cd58a2ff1ef949bb	false	0x2c159a183d9056e29649ce7e56e59ca833d32624	0x5607718c64334eb5174cb2226af891a6ed82c7c6	587	15507757	2024-06-08T00:01:01.000Z	481650752587620048237758000000000	0x72ba4b8a6ebe34c6af985f3ab50062b0a5d4e3e5019412ad7732635cb1364fd6
0x91ac2fff8cbef5859eaa6dda661febd533cd3780	0xcd07da92d4be4a79baa895a0cd58a2ff1ef949bb	false	0x2c159a183d9056e29649ce7e56e59ca833d32624	0x1c7a460413dd4e964f96d8dfc56e7223ce88cd85	586	15507757	2024-06-08T00:01:01.000Z	10373358532354090920000000000	0x72ba4b8a6ebe34c6af985f3ab50062b0a5d4e3e5019412ad7732635cb1364fd6
0x91ac2fff8cbef5859eaa6dda661febd533cd3780	0xcdf48aa018dc19b5a2a047a980b6b3fbf6f77e52	false	0x51fb9021d61c464674b419c0e3082b5b9223fc17	0x998e44232bef4f8b033e5a5175bdc97f2b10d5e5	622	15507757	2024-06-08T00:01:01.000Z	6946794172472281918000000000	0x72ba4b8a6ebe34c6af985f3ab50062b0a5d4e3e5019412ad7732635cb1364fd6

Example Query

Query with partition filter

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

RewardsController_AssetConfigUpdated_event

Reward distribution configuration changes for Seamless Protocol lending markets on Base, tracking emission rate and distribution period updates for incentivized assets. Used to monitor protocol incentive adjustments and reward program modifications 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_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
`in_oldEmission`	`STRING`	Previous emission rate per second for the reward token before this configuration update. Denominated in the smallest unit of the reward token (e.g., wei for ERC20), may be zero for new reward configurations.
`in_newEmission`	`STRING`	Token emission rate after the configuration update, measured in smallest token units per second distributed to this asset.
`in_oldDistributionEnd`	`STRING`	Previous Unix timestamp when the rewards distribution for this asset configuration was scheduled to end. Typically changes when reward parameters are updated or extended.
`in_newDistributionEnd`	`STRING`	Updated Unix timestamp (in seconds) indicating when the reward distribution period ends for this asset configuration. Typically set to future dates like February-March 2025 in sample data.
`in_assetIndex`	`STRING`	Index value tracking the reward accumulation state for this specific asset-reward pair. Used internally by Seamless Protocol’s rewards controller to calculate accrued rewards over time.

Sample Data

address	removed	in_asset	in_reward	log_index	block_number	in_newEmission	in_oldEmission	block_timestamp	transaction_hash	in_newDistributionEnd	in_oldDistributionEnd
0x91ac2fff8cbef5859eaa6dda661febd533cd3780	false	0xaffdd26fb0ca4dc43432f810f5fd6f6cec84f795	0x1c7a460413dd4e964f96d8dfc56e7223ce88cd85	243	25911749	11574074074074	11574074074074	2025-02-03T20:00:45.000Z	0x4e354352472e343fcb28e3f26f68c37c9097bd5eea3372a4443dc3c6fd7d7c2c	1740859200	1740859200
0x91ac2fff8cbef5859eaa6dda661febd533cd3780	false	0xaffdd26fb0ca4dc43432f810f5fd6f6cec84f795	0x1c7a460413dd4e964f96d8dfc56e7223ce88cd85	224	25911749	11574074074074	0	2025-02-03T20:00:45.000Z	0x4e354352472e343fcb28e3f26f68c37c9097bd5eea3372a4443dc3c6fd7d7c2c	1740859200	0
0x91ac2fff8cbef5859eaa6dda661febd533cd3780	false	0xaffdd26fb0ca4dc43432f810f5fd6f6cec84f795	0x1c7a460413dd4e964f96d8dfc56e7223ce88cd85	273	25911749	11574074074074	11574074074074	2025-02-03T20:00:45.000Z	0x4e354352472e343fcb28e3f26f68c37c9097bd5eea3372a4443dc3c6fd7d7c2c	1740859200	1740859200

Example Query

Query with partition filter

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

RewardsController_ClaimerSet_event

No description available.

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_claimer`	`STRING`	Address of the account initiating the claim transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

RewardsController_RewardOracleUpdated_event

Oracle price feed updates for reward tokens in Seamless Protocol v1 on Base. Tracks when reward token price oracles are configured or changed, useful for analyzing incentive program configurations and oracle dependencies.

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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
`in_rewardOracle`	`STRING`	Contract address of the oracle providing price data for the reward token. Hex-encoded, 0x-prefixed 40-character string on Base chain.

Sample Data

address	removed	in_reward	log_index	block_number	block_timestamp	in_rewardOracle	transaction_hash
0x91ac2fff8cbef5859eaa6dda661febd533cd3780	false	0x1c7a460413dd4e964f96d8dfc56e7223ce88cd85	465	16054925	2024-06-20T15:59:57.000Z	0x602823807c919a92b63cf5c126387c4759976072	0xf71a6539da55aa93dc167dd01883e0558e4f662c7fb8e95b3df425f14e07223d
0x91ac2fff8cbef5859eaa6dda661febd533cd3780	false	0x998e44232bef4f8b033e5a5175bdc97f2b10d5e5	467	16054925	2024-06-20T15:59:57.000Z	0x602823807c919a92b63cf5c126387c4759976072	0xf71a6539da55aa93dc167dd01883e0558e4f662c7fb8e95b3df425f14e07223d
0x91ac2fff8cbef5859eaa6dda661febd533cd3780	false	0x998e44232bef4f8b033e5a5175bdc97f2b10d5e5	463	16054925	2024-06-20T15:59:57.000Z	0x602823807c919a92b63cf5c126387c4759976072	0xf71a6539da55aa93dc167dd01883e0558e4f662c7fb8e95b3df425f14e07223d

Example Query

Query with partition filter

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

RewardsController_RewardsClaimed_event

Reward claim events from Seamless Protocol v1 lending platform on Base, tracking user reward redemptions with token addresses and claimed amounts. Used for analyzing incentive program participation and reward distribution across different asset 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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. 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	in_reward	log_index	in_claimer	block_number	block_timestamp	transaction_hash
0x0303c6ca7ad3b0a9c0dfc4693262d95f77803af7	0x91ac2fff8cbef5859eaa6dda661febd533cd3780	0x0303c6ca7ad3b0a9c0dfc4693262d95f77803af7	false	0	0x5607718c64334eb5174cb2226af891a6ed82c7c6	329	0x0303c6ca7ad3b0a9c0dfc4693262d95f77803af7	19416906	2024-09-06T11:45:59.000Z	0x8a39a74c9e447399e6a317e32205bbbc221ccc08d13c4aedb6efc8b9825fb05a
0x0303c6ca7ad3b0a9c0dfc4693262d95f77803af7	0x91ac2fff8cbef5859eaa6dda661febd533cd3780	0x0303c6ca7ad3b0a9c0dfc4693262d95f77803af7	false	0	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	341	0x0303c6ca7ad3b0a9c0dfc4693262d95f77803af7	19416906	2024-09-06T11:45:59.000Z	0x8a39a74c9e447399e6a317e32205bbbc221ccc08d13c4aedb6efc8b9825fb05a
0x0303c6ca7ad3b0a9c0dfc4693262d95f77803af7	0x91ac2fff8cbef5859eaa6dda661febd533cd3780	0x0303c6ca7ad3b0a9c0dfc4693262d95f77803af7	false	1724779955548099249	0x998e44232bef4f8b033e5a5175bdc97f2b10d5e5	338	0x0303c6ca7ad3b0a9c0dfc4693262d95f77803af7	19416906	2024-09-06T11:45:59.000Z	0x8a39a74c9e447399e6a317e32205bbbc221ccc08d13c4aedb6efc8b9825fb05a

Example Query

Query with partition filter

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

RewardsController_TemporaryOverrideAdminSet_event

Administrative permission changes in Seamless Protocol’s rewards controller on Base, tracking temporary admin role assignments and revocations. Used for monitoring governance actions and access control modifications in the lending protocol’s incentive system.

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_previousAdmin`	`STRING`	Address of the admin being replaced in this temporary override event for the Seamless Protocol rewards controller. Contains the zero address (0x000…000) when no previous admin existed, or a valid address when an existing admin is being changed.
`in_newAdmin`	`STRING`	Address of the newly assigned administrator. Hex-encoded, 0x-prefixed, 42-character string representing the Ethereum address that will receive admin privileges.

Sample Data

address	removed	log_index	in_newAdmin	block_number	block_timestamp	in_previousAdmin	transaction_hash
0x91ac2fff8cbef5859eaa6dda661febd533cd3780	false	232	0xa1b5f2cc9b407177cd8a4acf1699fa0b99955a22	15455541	2024-06-06T19:00:29.000Z	0x0000000000000000000000000000000000000000	0x3d306288ded9122955e94b742bcd10ad6f26bc60a023d3cc97879b719fb2c8fb
0x91ac2fff8cbef5859eaa6dda661febd533cd3780	false	262	0x0000000000000000000000000000000000000000	15723754	2024-06-13T00:00:55.000Z	0xa1b5f2cc9b407177cd8a4acf1699fa0b99955a22	0xa65d8f72eca48235d557fcaefc24cecc38143244724094b08a3e07cc34d9168e

Example Query

Query with partition filter

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

RewardsController_TransferStrategyInstalled_event

Configuration events recording transfer strategy assignments for reward tokens in Seamless Protocol on Base. Used for tracking reward distribution mechanism changes and governance updates to the protocol’s incentive system.

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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
`in_transferStrategy`	`STRING`	Contract address of the transfer strategy implementation being installed for reward distribution. Defines the mechanism through which rewards are transferred to users in the Seamless Protocol rewards controller.

Sample Data

address	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash	in_transferStrategy
0x91ac2fff8cbef5859eaa6dda661febd533cd3780	false	0x998e44232bef4f8b033e5a5175bdc97f2b10d5e5	127	16965723	2024-07-11T17:59:53.000Z	0xa9ecf76a8d9eb6cb1bfa03c101094f03d26b01521e0f0e365fce0004a892a5e8	0x2181be388ced00754e7c1ee33dbcf78397dd89ac
0x91ac2fff8cbef5859eaa6dda661febd533cd3780	false	0x998e44232bef4f8b033e5a5175bdc97f2b10d5e5	125	16965723	2024-07-11T17:59:53.000Z	0xa9ecf76a8d9eb6cb1bfa03c101094f03d26b01521e0f0e365fce0004a892a5e8	0x2181be388ced00754e7c1ee33dbcf78397dd89ac
0x91ac2fff8cbef5859eaa6dda661febd533cd3780	false	0x998e44232bef4f8b033e5a5175bdc97f2b10d5e5	251	21584601	2024-10-26T16:02:29.000Z	0x7e0da5d55b77859ff0c87aa1965074a3801df660247ad8ab6b982a1eb5ae8cf2	0x2181be388ced00754e7c1ee33dbcf78397dd89ac

Example Query

Query with partition filter

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

SToken_Burn_event

Stable rate debt token burn events from Aave-based lending protocols, emitted when borrowers repay stable-rate debt positions. Records the burn amount, user balance changes, average stable rate, and updated total supply for tracking debt repayments and interest accrual.

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_from`	`STRING`	Address originating the transfer or 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.
`in_currentBalance`	`STRING`	User’s current stable debt balance after accrued interest. Numeric string representation of token quantity in smallest denomination.
`in_balanceIncrease`	`STRING`	Accrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
`in_avgStableRate`	`STRING`	Average stable borrow rate across all borrowers for the reserve. Numeric string representation in ray units (27 decimals).
`in_newTotalSupply`	`STRING`	Updated total supply of stable debt tokens after the operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

SToken_Mint_event

Stable debt token minting events from Aave protocol lending pools. Captures stable-rate borrowing activity including borrowed amount, interest rate calculations, borrower address, and updated pool totals.

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_onBehalfOf`	`STRING`	Address of the account receiving the benefit of the 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.
`in_currentBalance`	`STRING`	User’s current stable debt balance after accrued interest. Numeric string representation of token quantity in smallest denomination.
`in_balanceIncrease`	`STRING`	Accrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
`in_newRate`	`STRING`	Updated stable borrow rate for the user after the mint operation. Numeric string representation in ray units (27 decimals).
`in_avgStableRate`	`STRING`	Average stable borrow rate across all borrowers for the reserve. Numeric string representation in ray units (27 decimals).
`in_newTotalSupply`	`STRING`	Updated total supply of stable debt tokens after the operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

VToken_Burn_event

Variable debt token burn events emitted when borrowers repay debt in Aave-based lending protocols. Contains user address, repayment amount, updated interest index, and accrued interest since last interaction for tracking debt position changes.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_balanceIncrease`	`STRING`	Accrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

address	in_from	removed	in_index	in_value	in_target	log_index	block_number	block_timestamp	transaction_hash	in_balanceIncrease
0x1c4384366b6694dff3997d5033fc7ffcb2e3d8a7	0x87c7e8468c5d88ef3205a72043c432291d206443	false	1176815047158652376956193525	1999679422330517210561	0x0000000000000000000000000000000000000000	184	22516164	2024-11-17T05:34:35.000Z	0xa040d6f4536163bbc187408f8dc44fbc9a1fd1ff03ab3443b5b41cea320cb8a5	332578642396589071
0x1c4384366b6694dff3997d5033fc7ffcb2e3d8a7	0x604696f3d241398609b7bbe430b32865462344d5	false	1176861510851191019929663129	3600000000000000000	0x0000000000000000000000000000000000000000	583	22522276	2024-11-17T08:58:19.000Z	0x6b57f9ef52241a65185016ce48379b960d74ac85d64eacc6d20783830606dace	7144685954769962
0x1c4384366b6694dff3997d5033fc7ffcb2e3d8a7	0x047b031f72210f85f58a43615cff23ce4755890d	false	1176938138186949618349729036	4481014620539680876	0x0000000000000000000000000000000000000000	373	22532513	2024-11-17T14:39:33.000Z	0xdc714749b6989f617942779d4c905d2699be9cc1fdd943a17a14794feb2b8f27	4095259834079344

Example Query

Query with partition filter

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

VToken_Mint_event

Variable rate debt token mint events from lending protocols. Records debt token issuance with borrower address, borrowed amount, interest rate index, and accrued interest at the time of minting.

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_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_onBehalfOf`	`STRING`	Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_balanceIncrease`	`STRING`	Accrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

address	removed	in_index	in_value	in_caller	log_index	block_number	in_onBehalfOf	block_timestamp	transaction_hash
0x51fb9021d61c464674b419c0e3082b5b9223fc17	false	1011479945104763293533970154	100000000000000000	0x4d7ce42984e20da443cb060d46b62cfaf4078ed8	157	19979295	0x4d7ce42984e20da443cb060d46b62cfaf4078ed8	2024-09-19T12:12:17.000Z	0x4ca83d6dd59e0fd12bcc6723a17f7074a7f2d90cbd53798d66b3239a8e26df8a
0x51fb9021d61c464674b419c0e3082b5b9223fc17	false	1011479975318742828521503836	140579751784476164	0x3110d396395a39e85b5558acd924dcfbd342eadf	36	19980346	0x3110d396395a39e85b5558acd924dcfbd342eadf	2024-09-19T12:47:19.000Z	0x77ba7f50e9321d3dc7628db5045efcbfd2577f6e004451048b95b669fe543da6
0x51fb9021d61c464674b419c0e3082b5b9223fc17	false	1011479975318742828521503836	130455173472989176	0xa6845d1a22177a31e46b6d76188d0cb9089f4582	19	19980346	0xa6845d1a22177a31e46b6d76188d0cb9089f4582	2024-09-19T12:47:19.000Z	0x03569f8530eafb6241acac53f78df7110973bf535f94dcdda182252f8789fdeb

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

​Tables

​AToken_Initialized_event

​LendingPool_Borrow_event

​LendingPool_FlashLoan_event

​LendingPool_LiquidationCall_event

​LendingPool_MintedToTreasury_event

​LendingPool_Repay_event

​LendingPool_Supply_event

​LendingPool_Withdraw_event

​LendingPoolConfigurator_CollateralConfigurationChanged_event

​LendingPoolConfigurator_FlashloanPremiumToProtocolUpdated_event

​LendingPoolConfigurator_FlashloanPremiumTotalUpdated_event

​LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

​LendingPoolConfigurator_ReserveFactorChanged_event

​LendingPoolConfigurator_ReserveInitialized_event

​LeverageManager_ManagementFeeCharged_event

​LeverageManager_Mint_event

​LeverageManager_Rebalance_event

​LeverageManager_Redeem_event

​LeverageToken_Approval_event

​LeverageToken_Initialized_event

​LeverageToken_LeverageTokenInitialized_event

​LeverageToken_Transfer_event

​LeverageTokenFactory_BeaconProxyCreated_event

​MetaMorphoV1_AccrueInterest_event

​MetaMorphoV1_Approval_event

​MetaMorphoV1_Deposit_event

​MetaMorphoV1_Transfer_event

​MetaMorphoV1_UpdateLastTotalAssets_event

​MetaMorphoV1_UpdateLostAssets_event

​MetaMorphoV1_Withdraw_event

​RewardsController_Accrued_event

​RewardsController_AccruedIndexChange_event

​RewardsController_AssetConfigUpdated_event

​RewardsController_ClaimerSet_event

​RewardsController_RewardOracleUpdated_event

​RewardsController_RewardsClaimed_event

​RewardsController_TemporaryOverrideAdminSet_event

​RewardsController_TransferStrategyInstalled_event

​SToken_Burn_event

​SToken_Mint_event

​VToken_Burn_event

​VToken_Mint_event

Tables

AToken_Initialized_event

LendingPool_Borrow_event

LendingPool_FlashLoan_event

LendingPool_LiquidationCall_event

LendingPool_MintedToTreasury_event

LendingPool_Repay_event

LendingPool_Supply_event

LendingPool_Withdraw_event

LendingPoolConfigurator_CollateralConfigurationChanged_event

LendingPoolConfigurator_FlashloanPremiumToProtocolUpdated_event

LendingPoolConfigurator_FlashloanPremiumTotalUpdated_event

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

LeverageManager_ManagementFeeCharged_event

LeverageManager_Mint_event

LeverageManager_Rebalance_event

LeverageManager_Redeem_event

LeverageToken_Approval_event

LeverageToken_Initialized_event

LeverageToken_LeverageTokenInitialized_event

LeverageToken_Transfer_event

LeverageTokenFactory_BeaconProxyCreated_event

MetaMorphoV1_AccrueInterest_event

MetaMorphoV1_Approval_event

MetaMorphoV1_Deposit_event

MetaMorphoV1_Transfer_event

MetaMorphoV1_UpdateLastTotalAssets_event

MetaMorphoV1_UpdateLostAssets_event

MetaMorphoV1_Withdraw_event

RewardsController_Accrued_event

RewardsController_AccruedIndexChange_event

RewardsController_AssetConfigUpdated_event

RewardsController_ClaimerSet_event

RewardsController_RewardOracleUpdated_event

RewardsController_RewardsClaimed_event

RewardsController_TemporaryOverrideAdminSet_event

RewardsController_TransferStrategyInstalled_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event