raft_v1_ethereum

Tables

PositionManager_CollateralChanged_event

Collateral deposit and withdrawal events from Raft Protocol’s PositionManager contract on Ethereum, tracking changes to user position collateral with wstETH token amounts and directional flags. Used for analyzing collateralization ratio changes and liquidation risk 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_position`	`STRING`	Address of the position or market contract being traded or operated on. Hex-encoded, 0x-prefixed, 42-character string.
`in_collateralToken`	`STRING`	Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_collateralAmount`	`STRING`	Amount of collateral tokens involved in the operation. Decimal-encoded string representing the quantity in the token’s base units.
`in_isCollateralIncrease`	`BOOL`	Boolean flag indicating whether collateral was added to or removed from the position. True represents a collateral increase (deposit), false represents a collateral decrease (withdrawal).

Sample Data

address	removed	log_index	in_position	block_number	block_timestamp	transaction_hash	in_collateralToken	in_collateralAmount	in_isCollateralIncrease
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	418	0x8f9503e6cb6a1a1f2f62088e1d1913a6ef6e1fa4	17486047	2023-06-15T15:03:11.000Z	0x010b1ce81e8e05eb28cbd62be6f32ce602fad3d267df916899d0d3a9de25cde9	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	2392543500714855223	true
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	336	0x6c673e2ffe8970d7e561230ccc95a88325a63bdc	17486015	2023-06-15T14:56:47.000Z	0x89b5a873b063d0593cbb75a717c0b4f8e96a4b235e3b2d20b60bdb1a0b26d26a	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	2392810531571432113	false
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	158	0x6c673e2ffe8970d7e561230ccc95a88325a63bdc	17482913	2023-06-15T04:26:59.000Z	0x682bfcf626d66187e546ef6095a9ec61d6ff2f92b2e12295f868a444fc4124b1	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	2392810531571432113	true

Example Query

Query with partition filter

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

PositionManager_CollateralTokenAdded_event

Events emitted when new collateral tokens are registered in Raft protocol’s Position Manager on Ethereum, capturing the collateral token address, associated debt token (R stablecoin), price feed oracle, and wrapped collateral token for CDP (Collateralized Debt Position) management.

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_collateralToken`	`STRING`	Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_raftCollateralToken`	`STRING`	Contract address of the Raft-wrapped collateral token minted to represent deposited collateral in the Raft protocol. This is the protocol’s internal representation of the underlying collateral asset specified in `in_collateralToken`.
`in_raftDebtToken`	`STRING`	Contract address of the Raft debt token issued when users borrow against their collateral in the position. Hex-encoded, 0x-prefixed 40-character Ethereum address representing the debt instrument.
`in_priceFeed`	`STRING`	Contract address of the oracle price feed used to value the collateral token being added to the Raft protocol. Hex-encoded, 0x-prefixed 40-character Ethereum address that provides real-time pricing data for position management.

Sample Data

address	removed	log_index	block_number	in_priceFeed	block_timestamp	in_raftDebtToken	transaction_hash	in_collateralToken	in_raftCollateralToken
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	143	18356835	0xec06375d9c8bc60d0caa76b060439ed245f29ffe	2023-10-15T16:01:23.000Z	0xaee0ef7a8559c401ac827c5f5cb9bc483149dde8	0x40ef24f16ea18b40837393b6c6781f6bda2c9711db9584040c82d8416fcdde98	0xe899603576967180c7594bd5a1cad898a3e3daf3	0x72e692a3d7b8a653daccbedd85917d5182fedb88
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	121	18128521	0xa5041273cfc09235007e8bfc3304288a58b0e46c	2023-09-13T16:18:23.000Z	0x508d93785d4ce31a0f6ff257df53c9a6c3b79f39	0x74a544de591d5970fe27e56eaa144a7be6261de474f3af7cc39be0283ffb4523	0x9ab6b21cdf116f611110b048987e58894786c244	0x6c6492779dcdd070f7a5c3d246af4794ea102f59
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	254	17318123	0xdb5de0a34b29ffdeec61e2d8ab4db63f6641c730	2023-05-22T23:33:35.000Z	0x1c1d49d8f601f19d2fa88b14bef491759aaaf5d8	0xbc5ff22a897b0896d017f5dbc1893f383a3c15fa3c783d1f22165426508fce97	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	0xa7820009f79687d39f51909a01e7fd4b4d0663f8

Example Query

Query with partition filter

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

PositionManager_CollateralTokenModified_event

Event logs tracking changes to accepted collateral tokens in Raft protocol’s Position Manager contract on Ethereum. Records when collateral tokens are enabled or disabled for use in the protocol, useful for monitoring supported asset configuration 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_collateralToken`	`STRING`	Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_isEnabled`	`BOOL`	Indicates whether the collateral token was enabled or disabled in the Raft protocol’s PositionManager contract. Boolean flag where true means the token was enabled for use as collateral, false means it was disabled.

Sample Data

address	removed	log_index	block_number	in_isEnabled	block_timestamp	transaction_hash	in_collateralToken
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	175	18063309	false	2023-09-04T13:07:11.000Z	0xf7fc54c8e6125474c8f599295e08120fe964a38824b2d858022c4fad89022877	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	174	18063309	false	2023-09-04T13:07:11.000Z	0xf7fc54c8e6125474c8f599295e08120fe964a38824b2d858022c4fad89022877	0xb69e35fb4a157028b92f42655090b984609ae598

Example Query

Query with partition filter

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

PositionManager_DebtChanged_event

Debt modification events from Raft Protocol’s PositionManager contract on Ethereum, tracking collateralized debt position (CDP) changes including borrow and repayment amounts with associated collateral tokens. Used for analyzing leverage behavior and loan position management 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_position`	`STRING`	Address of the position or market contract being traded or operated on. Hex-encoded, 0x-prefixed, 42-character string.
`in_collateralToken`	`STRING`	Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_debtAmount`	`STRING`	Amount of debt denominated in the smallest unit of the token. Represented as a numeric string without decimal formatting.
`in_isDebtIncrease`	`BOOL`	Boolean flag indicating whether the debt change represents an increase (true) or decrease (false) in the position’s borrowed amount. Determines the direction of the debt modification event for the collateralized position.

Sample Data

address	removed	log_index	in_position	block_number	in_debtAmount	block_timestamp	transaction_hash	in_isDebtIncrease	in_collateralToken
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	207	0xb93f66a8a607699710625e9ff7752df31e4fa253	17631986	3028637719520232561939	2023-07-06T02:58:23.000Z	0xd9cf5455a9a68ed90e38fb959fcdf915b061bc81396129e5db5b20306457dde5	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	239	0x773bebb637690d3da39ba8b89c97a7602cb1ca1c	17635952	3028902384555865427271	2023-07-06T16:20:59.000Z	0x1a6d64e683f4d4a30eac8e0a174511acedf1e222dc4b4cdc652eb886317b46f9	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	343	0xa53a13a80d72a855481de5211e7654fabdfe3526	17635649	1253240607594647121539407	2023-07-06T15:19:35.000Z	0x9f512cf1d55af13852796ea8e32a384001d7ab9ce0442e86a636a960e5a50cf8	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0

Example Query

Query with partition filter

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

PositionManager_Liquidation_event

Liquidation events from Raft protocol’s position manager on Ethereum, recording collateralized debt position (CDP) liquidations with debt repaid, collateral seized, and liquidator rewards. Used for analyzing protocol health, liquidation efficiency, and keeper profitability 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_liquidator`	`STRING`	Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_position`	`STRING`	Address of the position or market contract being traded or operated on. Hex-encoded, 0x-prefixed, 42-character string.
`in_collateralToken`	`STRING`	Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_debtLiquidated`	`STRING`	Amount of debt token repaid during the liquidation event, denominated in the smallest unit (wei) of the debt token. Typically represents stablecoin debt (e.g., USDC or DAI) being closed out when a position becomes undercollateralized.
`in_collateralLiquidated`	`STRING`	Amount of collateral token liquidated from the position, denominated in the token’s smallest unit (wei for ETH-based tokens). This raw value typically includes both the collateral sent to the liquidator and the liquidation fee.
`in_collateralSentToLiquidator`	`STRING`	Amount of collateral tokens transferred to the liquidator as compensation for liquidating the undercollateralized position. Denominated in the smallest unit of the collateral token (wei for ERC-20 tokens), typically slightly less than the total collateral liquidated due to liquidation fees.
`in_collateralLiquidationFeePaid`	`STRING`	Amount of collateral paid as a liquidation fee to the protocol during the liquidation event. Value is zero when full liquidation occurs without penalty, measured in the smallest denomination of the collateral token.
`in_isRedistribution`	`BOOL`	Indicates whether the liquidation was a redistribution event where debt and collateral were redistributed among remaining positions rather than settled directly with a liquidator. Values are consistently false in normal liquidations with identified liquidators.

Sample Data

address	removed	log_index	in_position	block_number	in_liquidator	block_timestamp	transaction_hash	in_debtLiquidated	in_collateralToken	in_isRedistribution	in_collateralLiquidated	in_collateralSentToLiquidator	in_collateralLiquidationFeePaid
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	236	0xafd0659e7993bd4d820f17a2bb2e79205feaf9b9	17428950	0x346d859a0b57b2b771a9b3afd414757780e104eb	2023-06-07T14:00:23.000Z	0xb551ce9e8eda5ce4a51ae51371cb483d767dfef33aa37eac72c7b30053b5e84a	3000300000892273878000	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	false	1569717610987250740	1569717457062329351	153924921389
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	67	0xafd0659e7993bd4d820f17a2bb2e79205feaf9b9	17428653	0x346d859a0b57b2b771a9b3afd414757780e104eb	2023-06-07T13:00:23.000Z	0x626c8cf653765ad0246732674e3c6c5ce416ef138144a260c2de55db11c975af	3000300000919304097000	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	false	1565371819533588088	1565371668592936636	150940651452
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	182	0xafd0659e7993bd4d820f17a2bb2e79205feaf9b9	17429170	0xdbec19d2429cc5f1022c09617c9dee7b25911f3f	2023-06-07T14:45:23.000Z	0x917217cf21ebb4eb7719767787a7bcff69b018d0b829da139992d0d16291a8d3	3000300000850341387000	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	false	1570693196823787254	1570693058444126602	138379660652

Example Query

Query with partition filter

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

PositionManager_PositionCreated_event

Position creation events from Raft protocol’s PositionManager contract on Ethereum, tracking collateralized debt position (CDP) openings with associated collateral token addresses. Used for analyzing Raft lending activity and monitoring new position creation across different collateral types like wstETH.

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_position`	`STRING`	Address of the position or market contract being traded or operated on. Hex-encoded, 0x-prefixed, 42-character string.
`in_collateralToken`	`STRING`	Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_position	block_number	block_timestamp	transaction_hash	in_collateralToken
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	201	0x0b17837db96070fc89baa37cf07ba20d34265d3f	17676954	2023-07-12T10:42:11.000Z	0x4e2a5bff507c311d01024a6eb081c92981abf5fdcae4165f3610bee1f3d619c6	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	206	0x0b17837db96070fc89baa37cf07ba20d34265d3f	17676266	2023-07-12T08:22:35.000Z	0xa77cd73beedf5cd7ed22b98a706ae561c71dab04980ced7a1a05a96d4a1e552e	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	406	0x0b17837db96070fc89baa37cf07ba20d34265d3f	17676134	2023-07-12T07:55:35.000Z	0x081c69d0c09c9545508c5614cb34194991cbff3375c76ad0ff4f8d31ea600ce1	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0

Example Query

Query with partition filter

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

PositionManager_RBorrowingFeePaid_event

Borrowing fee payment events from Raft Protocol’s PositionManager contract on Ethereum, recording R token (Raft’s stablecoin) fees charged on collateralized debt positions. Tracks fee amounts, associated position addresses, and collateral token types for analyzing protocol revenue and user borrowing costs.

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_collateralToken`	`STRING`	Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_position`	`STRING`	Address of the position or market contract being traded or operated on. Hex-encoded, 0x-prefixed, 42-character string.
`in_feeAmount`	`STRING`	Fee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.

Sample Data

address	removed	log_index	in_position	block_number	in_feeAmount	block_timestamp	transaction_hash	in_collateralToken
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	365	0x234ccbab6f78ea6e8bf84406dabb4f29e641e661	17726119	15000187216416381000	2023-07-19T08:42:23.000Z	0x247c42367b5d4f6e0891ea42eb61c537047d6ad4d758b600791eb0f3c0724a18	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	293	0x27e4cd5d95a8def1d6d0ef6eaff0fe3f3cc46a1a	17724546	15000253294904847000	2023-07-19T03:23:59.000Z	0x66ac746f0db7c7b4b03e34d5534e36bfa2a1d6e5f7c132d8b1cc8908127f0937	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	319	0x2e48875613bc94d991eddd2d0c7cda5641dccf5e	17726938	15000159873316551000	2023-07-19T11:28:23.000Z	0x34be3c1fd58d5ea4c88df7483604f22a7cd7ab0ecea6346ff03ec3d6ff744d19	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0

Example Query

Query with partition filter

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

PositionManager_Redemption_event

Redemption events from Raft protocol’s PositionManager contract on Ethereum, capturing when users redeem stablecoin positions for underlying collateral. Records redeemer addresses, redemption amounts, fees charged, rebates issued, and collateral returned for analyzing protocol redemption activity and pricing dynamics.

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_redeemer`	`STRING`	Address of the account that initiated the redemption 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_collateralSent`	`STRING`	Amount of collateral tokens sent to the redeemer in exchange for the stablecoin redemption, denominated in the smallest unit (wei). This represents the value received by the user after accounting for fees and rebates.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_rebate`	`STRING`	Amount of redemption fee rebated back to the redeemer, denominated in the smallest unit of the protocol’s debt token. Typically represents half of the total redemption fee charged, as shown in the sample data.

Sample Data

in_fee	address	removed	in_amount	in_rebate	log_index	in_redeemer	block_number	block_timestamp	transaction_hash	in_collateralSent
3038885022583	0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	420690000000000000	1519442511291	285	0xac1aa53108712d7f38093a67d380ad54b562a650	17529004	2023-06-21T15:43:47.000Z	0x12e7e8dbf850a21823f30bba2c4a38e1251657080ce1fcee7d079aa136cf1ceb	202590235748754
62994890331498	0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	8720742025564826439	31497445165749	389	0x79138a2a4dd7085e5497d743abca97bfee9bfd2d	17528986	2023-06-21T15:40:11.000Z	0x79adcdf1382727141de98fc70698432a55f8b24cc03a54f523d1e8c0b2109dd1	4199617730070233
379428173369525406	0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	49576455310403110621173	189714086684762703	84	0xed035c0f68a514ec1c121accfe00b88de6b894ec	17809522	2023-07-31T00:50:23.000Z	0x91f9922f704cab3f4d04faad322c4e067509038c6b9408250a1ce7ea0bfd247b	23518832551953767779

Example Query

Query with partition filter

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

PositionManager_RedemptionRebateUpdated_event

Redemption rebate parameter updates for Raft protocol’s PositionManager contract on Ethereum, tracking changes to the rebate rate offered during debt redemptions. Values are in wei (18 decimals), with typical rates ranging from 0 to 1 ETH (100% rebate).

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_redemptionRebate`	`STRING`	The updated redemption rebate rate for the Raft protocol position, expressed as a wei-denominated value where 1e18 represents 100%. Common values include 1e18 (full rebate), 5e17 (50% rebate), and 0 (no rebate).

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_redemptionRebate
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	119	18128521	2023-09-13T16:18:23.000Z	0x74a544de591d5970fe27e56eaa144a7be6261de474f3af7cc39be0283ffb4523	1000000000000000000
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	195	18048519	2023-09-02T11:25:47.000Z	0x50d2fa64313badd4ead708bf1c127b20daae79e1de2ea3c1ad50c983c38325d8	1000000000000000000
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	141	18356835	2023-10-15T16:01:23.000Z	0x40ef24f16ea18b40837393b6c6781f6bda2c9711db9584040c82d8416fcdde98	1000000000000000000

Example Query

Query with partition filter

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

PositionManager_RedemptionSpreadUpdated_event

Event log tracking redemption spread parameter changes for collateral tokens in the Raft protocol on Ethereum. Records governance updates to redemption fees, enabling analysis of risk parameter adjustments across different collateral types like wstETH and other liquid staking derivatives.

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_collateralToken`	`STRING`	Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_redemptionSpread`	`STRING`	Fee percentage charged when users redeem collateral from the Raft protocol for the specified token, expressed in wei (18 decimal places). Values typically range from 0.5% (5000000000000000) to 100% (1000000000000000000).

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_collateralToken	in_redemptionSpread
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	29	17470291	2023-06-13T09:49:47.000Z	0x2791c0e98e5ba4241b1d3d7b36b19e0694869c83d50c75327506766286b80eab	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	5000000000000000
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	200	17570155	2023-06-27T10:36:47.000Z	0x5b5c3358908f23310457213a0682561be079aa821edb59c1b09b0a3ed0d2a598	0xb69e35fb4a157028b92f42655090b984609ae598	5000000000000000
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	60	17570081	2023-06-27T10:21:59.000Z	0x033a9d946544ebfec6b3095e26cda8529d0c5673ecc5eb132f595e98b16c4978	0xb69e35fb4a157028b92f42655090b984609ae598	1000000000000000000

Example Query

Query with partition filter

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

PositionMangaer_CollateralChanged_event

Collateral deposits and withdrawals for leveraged positions on Raft protocol (Ethereum), tracking token amounts added or removed from positions. Used for monitoring position health, liquidation risk, and capital flow patterns in the stablecoin CDP 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_position`	`STRING`	Address of the position or market contract being traded or operated on. Hex-encoded, 0x-prefixed, 42-character string.
`in_collateralToken`	`STRING`	Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_collateralAmount`	`STRING`	Amount of collateral tokens involved in the operation. Decimal-encoded string representing the quantity in the token’s base units.
`in_isCollateralIncrease`	`BOOL`	Indicates whether the collateral change was an increase (true) or decrease (false) for the position. All sample transactions show both deposits and withdrawals occurring in the Raft protocol.

Sample Data

address	removed	log_index	in_position	block_number	block_timestamp	transaction_hash	in_collateralToken	in_collateralAmount	in_isCollateralIncrease
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	147	0x1bfa548c8e8848b46b2835c407d6870d74f2fb94	17517529	2023-06-20T01:05:23.000Z	0xc8e0306efb27f32b1fa81705a5fba95d2935d624d6b2285c49bbfdc13d4484f2	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	17751012735313917168	false
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	220	0x1bfa548c8e8848b46b2835c407d6870d74f2fb94	17523163	2023-06-20T20:04:59.000Z	0xda7098e81ff3651964241b06ee4073c3bafa788163b8e6262f29c54d001eddcf	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	17751740871130784967	false
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	256	0xccfa0530b9d52f970d1a2daea670ce58e4176389	17522760	2023-06-20T18:42:47.000Z	0x8ba08416c5d6c2c22b815f2d9647c406a39f465d690092450af31b995db2a6de	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	500000000000000000000	false

Example Query

Query with partition filter

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

PositionMangaer_CollateralTokenAdded_event

Event logs tracking when new collateral types are added to Raft protocol’s Position Manager on Ethereum, linking collateral tokens to their wrapped versions (raftCollateralToken), debt tokens, and price feed oracles. Used for monitoring supported collateral additions and protocol configuration 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_collateralToken`	`STRING`	Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_raftCollateralToken`	`STRING`	Contract address of the Raft-wrapped collateral token (R-token) representing deposited collateral in the protocol. This is the receipt token minted to users when they deposit the corresponding base collateral token into Raft’s Position Manager.
`in_raftDebtToken`	`STRING`	Contract address of the Raft debt token (stablecoin) minted against the collateral in this position. Represents the synthetic asset borrowed by users when opening leveraged positions in the Raft protocol.
`in_priceFeed`	`STRING`	Contract address of the price feed oracle used to determine the value of the collateral token. Hex-encoded, 0x-prefixed Ethereum address that provides real-time pricing data for collateral valuation.

Sample Data

address	removed	log_index	block_number	in_priceFeed	block_timestamp	in_raftDebtToken	transaction_hash	in_collateralToken	in_raftCollateralToken
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	63	17570081	0x62ac8d1ebf61636e17d92ec3b24e8e03fb853cda	2023-06-27T10:21:59.000Z	0xf22cd22b5cf439825c6b75c816a4daf8fb44375b	0x033a9d946544ebfec6b3095e26cda8529d0c5673ecc5eb132f595e98b16c4978	0xb69e35fb4a157028b92f42655090b984609ae598	0xc38a040fac5769bded5dda8dea1aef609e755363
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	254	17318123	0xdb5de0a34b29ffdeec61e2d8ab4db63f6641c730	2023-05-22T23:33:35.000Z	0x1c1d49d8f601f19d2fa88b14bef491759aaaf5d8	0xbc5ff22a897b0896d017f5dbc1893f383a3c15fa3c783d1f22165426508fce97	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	0xa7820009f79687d39f51909a01e7fd4b4d0663f8

Example Query

Query with partition filter

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

PositionMangaer_DebtChanged_event

Debt position change events from Raft Protocol’s PositionManager contract on Ethereum, tracking borrowing and repayment activities with collateral token addresses and position identifiers. Used for analyzing leverage positions, loan origination patterns, and debt management behavior in the stablecoin 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_position`	`STRING`	Address of the position or market contract being traded or operated on. Hex-encoded, 0x-prefixed, 42-character string.
`in_collateralToken`	`STRING`	Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_debtAmount`	`STRING`	Amount of debt denominated in the smallest unit of the token. Represented as a numeric string without decimal formatting.
`in_isDebtIncrease`	`BOOL`	Boolean flag indicating whether the debt was increased (true) or decreased (false) for the position. Used to distinguish between borrowing and repayment events in Raft protocol positions.

Sample Data

address	removed	log_index	in_position	block_number	in_debtAmount	block_timestamp	transaction_hash	in_isDebtIncrease	in_collateralToken
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	355	0xf93a5f0a4925eec32cd585641c88a498523f383c	17501799	6005000000000000000000	2023-06-17T20:05:59.000Z	0x964013815d4a9ae1c616a959518eec3a5ddfcd05339e40185c385a55a879b14d	true	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	13	0xb932e9dd1b48ce5895a3511d8be0169fb0e41323	17498911	120050540000000000000000	2023-06-17T10:23:59.000Z	0x55c14f111de33ac87ccdfa5e0837751977c867436ce42d1554c59758c1d0e111	true	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	62	0x3df26f581227c13a1a69ef16582270319aecd356	17496292	4220970000000000000000	2023-06-17T01:35:47.000Z	0xf273758e47b47322b16fb57e86dbb5ae8310a8755d20cbbf5b8c8aa1e32fafee	true	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0

Example Query

Query with partition filter

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

PositionMangaer_Liquidation_event

Liquidation events from Raft Protocol’s Position Manager on Ethereum, recording when undercollateralized debt positions are closed by liquidators. Contains debt amounts, collateral tokens (primarily wstETH), liquidation fees, and redistribution flags for analyzing protocol risk and liquidator profitability.

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_liquidator`	`STRING`	Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_position`	`STRING`	Address of the position or market contract being traded or operated on. Hex-encoded, 0x-prefixed, 42-character string.
`in_collateralToken`	`STRING`	Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_debtLiquidated`	`STRING`	Amount of debt repaid during the liquidation event, denominated in the protocol’s debt token (likely stablecoin). Value is in wei (smallest token unit), so 18 decimals for standard ERC20 tokens.
`in_collateralLiquidated`	`STRING`	Total amount of collateral liquidated from the undercollateralized position. Denominated in the smallest unit of the collateral token (wei-equivalent), representing the full collateral seized before fees or redistribution.
`in_collateralSentToLiquidator`	`STRING`	Amount of collateral transferred to the liquidator’s address after the liquidation, denominated in the smallest unit of the collateral token (wei-equivalent). This value excludes the liquidation fee and may equal zero when fees consume the entire collateral amount.
`in_collateralLiquidationFeePaid`	`STRING`	Amount of collateral paid as liquidation fee to the protocol. Value is in the smallest token unit (wei) and may be zero if no fee is assessed for the liquidation.
`in_isRedistribution`	`BOOL`	Boolean flag indicating whether the liquidated collateral was redistributed among remaining borrowers rather than sent directly to the liquidator. When false, liquidator receives the collateral; when true, collateral is redistributed across the protocol’s other positions.

Sample Data

address	removed	log_index	in_position	block_number	in_liquidator	block_timestamp	transaction_hash	in_debtLiquidated	in_collateralToken	in_isRedistribution	in_collateralLiquidated	in_collateralSentToLiquidator	in_collateralLiquidationFeePaid
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	236	0xafd0659e7993bd4d820f17a2bb2e79205feaf9b9	17428950	0x346d859a0b57b2b771a9b3afd414757780e104eb	2023-06-07T14:00:23.000Z	0xb551ce9e8eda5ce4a51ae51371cb483d767dfef33aa37eac72c7b30053b5e84a	3000300000892273878000	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	false	1569717610987250740	1569717457062329351	153924921389
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	67	0xafd0659e7993bd4d820f17a2bb2e79205feaf9b9	17428653	0x346d859a0b57b2b771a9b3afd414757780e104eb	2023-06-07T13:00:23.000Z	0x626c8cf653765ad0246732674e3c6c5ce416ef138144a260c2de55db11c975af	3000300000919304097000	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	false	1565371819533588088	1565371668592936636	150940651452
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	182	0xafd0659e7993bd4d820f17a2bb2e79205feaf9b9	17429170	0xdbec19d2429cc5f1022c09617c9dee7b25911f3f	2023-06-07T14:45:23.000Z	0x917217cf21ebb4eb7719767787a7bcff69b018d0b829da139992d0d16291a8d3	3000300000850341387000	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	false	1570693196823787254	1570693058444126602	138379660652

Example Query

Query with partition filter

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

PositionMangaer_PositionCreated_event

Position creation events from Raft Protocol’s Position Manager contract on Ethereum, tracking new collateralized debt positions with their associated collateral tokens. Used for monitoring position openings and analyzing which collateral types users deploy for minting Raft’s R stablecoin.

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_position`	`STRING`	Address of the position or market contract being traded or operated on. Hex-encoded, 0x-prefixed, 42-character string.
`in_collateralToken`	`STRING`	Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_position	block_number	block_timestamp	transaction_hash	in_collateralToken
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	270	0x093d4c33391c15dc2d941be2937ada9926996113	17470725	2023-06-13T11:18:11.000Z	0x1c4e3639e9b923735c0dcf769eb2a8f4b1d1062920fb48a7894590eb5156765e	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	355	0x107d233544cee392d60e7321070f69f42c7cd569	17470701	2023-06-13T11:13:11.000Z	0x7573a2287f1b287a9bd357975c8fa0d47fddebec9f581f933f131fd051369918	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	183	0x10f711e9aa39e5b7f85ede6586815078f2120b1a	17468101	2023-06-13T02:25:59.000Z	0x3e7a765a5e0685cfb64ab61ad801c8f20ead9eb91b81c24fd1e4031c11600748	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0

Example Query

Query with partition filter

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

PositionMangaer_RBorrowingFeePaid_event

Borrowing fee payment events from Raft Protocol’s Position Manager contract on Ethereum, tracking interest charges on collateralized debt positions (CDPs). Used for analyzing borrowing costs, position profitability, and protocol revenue from R token (Raft’s stablecoin) loans against collateral assets like wstETH.

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_collateralToken`	`STRING`	Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_position`	`STRING`	Address of the position or market contract being traded or operated on. Hex-encoded, 0x-prefixed, 42-character string.
`in_feeAmount`	`STRING`	Fee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.

Sample Data

address	removed	log_index	in_position	block_number	in_feeAmount	block_timestamp	transaction_hash	in_collateralToken
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	112	0xbccd7bc75220f2b14eedc7a83746297d97306c92	17562822	50000065486374270000	2023-06-26T09:50:47.000Z	0x47283d6c448ae3d072713cc4988f6d4a37ff47e18707e7e11db8481bf5ad1fc5	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	76	0xb0720a40d6335df0ac90ff9e4b755217632ca78c	17562872	15000019457687691000	2023-06-26T10:00:59.000Z	0x50e29e56469ce671eb968502c55ec4e18c3d35297c6336e29b35bcacc6cd5038	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	179	0x4179284c327b35ef08016f9112b8a4867207e79a	17565790	15000011015285892000	2023-06-26T19:53:11.000Z	0xf39bc2199a443e47610147571f54dc0ee836393da954c9db9a32acb3c395523c	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0

Example Query

Query with partition filter

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

PositionMangaer_Redemption_event

Redemption events from Raft Protocol’s Position Manager contract on Ethereum, recording when users redeem stablecoin for collateral with associated fees and rebates. Tracks redemption amounts, collateral returned, and fee structures for analyzing protocol redemption activity and user 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_redeemer`	`STRING`	Address of the account that initiated the redemption 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_collateralSent`	`STRING`	Amount of collateral sent to the redeemer in exchange for debt tokens, denominated in the smallest unit of the collateral token (wei-equivalent). This represents the actual collateral transferred during the redemption process after accounting for fees and rebates.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_rebate`	`STRING`	Portion of the redemption fee returned to the redeemer as an incentive, denominated in the smallest unit of the collateral token. Typically represents 50% of the total fee based on sample values.

Sample Data

in_fee	address	removed	in_amount	in_rebate	log_index	in_redeemer	block_number	block_timestamp	transaction_hash	in_collateralSent
231333619806384	0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	32755405618416980583	115666809903192	262	0xec3688a6790fe1c5b1e30fb42aa0a3924573d6df	17539818	2023-06-23T04:10:59.000Z	0x66ee9ac6d9cf9e78fc107af515caa663dae8a1163c4f9f9c29bf22bcd9bbe257	15421647579741939
810428214452928	0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	1698514741096344051	810428214452928	119	0xafd0659e7993bd4d820f17a2bb2e79205feaf9b9	17385006	2023-06-01T09:14:47.000Z	0xe42b5599d165c53626d67f37fc311e966324565554ae43e8cba7e8250aaad2f6	810428214452928
1813252217709163	0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	250000000000000000000	906626108854581	330	0xcc0fac1f6299886e9406b1532bc82e63c555bf30	17581050	2023-06-28T23:19:11.000Z	0xe4acc92eef6faf1e99826c0bace2519997d0165980fffb82f3f6269c06096d97	120852206982254612

Example Query

Query with partition filter

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

PositionMangaer_RedemptionRebateUpdated_event

Event logs tracking redemption rebate parameter changes in the Raft protocol’s Position Manager contract on Ethereum. Records updates to the rebate rate (in wei) applied when users redeem collateral, useful for analyzing protocol fee structure evolution.

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_redemptionRebate`	`STRING`	The updated redemption rebate value for the position, expressed in wei (1e18 = 100% rebate). Sample values like ‘1000000000000000000’ represent a 100% rebate, while ‘500000000000000000’ represents a 50% rebate.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_redemptionRebate
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	252	17318123	2023-05-22T23:33:35.000Z	0xbc5ff22a897b0896d017f5dbc1893f383a3c15fa3c783d1f22165426508fce97	1000000000000000000
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	30	17470291	2023-06-13T09:49:47.000Z	0x2791c0e98e5ba4241b1d3d7b36b19e0694869c83d50c75327506766286b80eab	500000000000000000
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	61	17570081	2023-06-27T10:21:59.000Z	0x033a9d946544ebfec6b3095e26cda8529d0c5673ecc5eb132f595e98b16c4978	1000000000000000000

Example Query

Query with partition filter

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

PositionMangaer_RedemptionSpreadUpdated_event

Redemption spread parameter updates from the Raft protocol’s Position Manager contract on Ethereum, tracking fee adjustments for different collateral tokens. Used for monitoring protocol governance changes and understanding redemption cost dynamics across 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_collateralToken`	`STRING`	Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_redemptionSpread`	`STRING`	Redemption spread parameter for the collateral token, represented as a wei-denominated value (18 decimals). Sample values range from 0.005 to 1.0 when converted from wei, indicating the spread percentage applied during redemption operations.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_collateralToken	in_redemptionSpread
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	115	17435579	2023-06-08T12:25:23.000Z	0x79a2eb12062a98b67d7fd78b08239a80291c91fef51afc147f31eef85b08229b	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	15000000000000000
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	251	17318123	2023-05-22T23:33:35.000Z	0xbc5ff22a897b0896d017f5dbc1893f383a3c15fa3c783d1f22165426508fce97	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	1000000000000000000
0x5f59b322eb3e16a0c78846195af1f588b77403fc	false	200	17570155	2023-06-27T10:36:47.000Z	0x5b5c3358908f23310457213a0682561be079aa821edb59c1b09b0a3ed0d2a598	0xb69e35fb4a157028b92f42655090b984609ae598	5000000000000000

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

PositionManager_CollateralChanged_event

PositionManager_CollateralTokenAdded_event

PositionManager_CollateralTokenModified_event

PositionManager_DebtChanged_event

PositionManager_Liquidation_event

PositionManager_PositionCreated_event

PositionManager_RBorrowingFeePaid_event

PositionManager_Redemption_event

PositionManager_RedemptionRebateUpdated_event

PositionManager_RedemptionSpreadUpdated_event

PositionMangaer_CollateralChanged_event

PositionMangaer_CollateralTokenAdded_event

PositionMangaer_DebtChanged_event

PositionMangaer_Liquidation_event

PositionMangaer_PositionCreated_event

PositionMangaer_RBorrowingFeePaid_event

PositionMangaer_Redemption_event

PositionMangaer_RedemptionRebateUpdated_event

PositionMangaer_RedemptionSpreadUpdated_event

​Tables

​PositionManager_CollateralChanged_event

​PositionManager_CollateralTokenAdded_event

​PositionManager_CollateralTokenModified_event

​PositionManager_DebtChanged_event

​PositionManager_Liquidation_event

​PositionManager_PositionCreated_event

​PositionManager_RBorrowingFeePaid_event

​PositionManager_Redemption_event

​PositionManager_RedemptionRebateUpdated_event

​PositionManager_RedemptionSpreadUpdated_event

​PositionMangaer_CollateralChanged_event

​PositionMangaer_CollateralTokenAdded_event

​PositionMangaer_DebtChanged_event

​PositionMangaer_Liquidation_event

​PositionMangaer_PositionCreated_event

​PositionMangaer_RBorrowingFeePaid_event

​PositionMangaer_Redemption_event

​PositionMangaer_RedemptionRebateUpdated_event

​PositionMangaer_RedemptionSpreadUpdated_event

Tables

PositionManager_CollateralChanged_event

PositionManager_CollateralTokenAdded_event

PositionManager_CollateralTokenModified_event

PositionManager_DebtChanged_event

PositionManager_Liquidation_event

PositionManager_PositionCreated_event

PositionManager_RBorrowingFeePaid_event

PositionManager_Redemption_event

PositionManager_RedemptionRebateUpdated_event

PositionManager_RedemptionSpreadUpdated_event

PositionMangaer_CollateralChanged_event

PositionMangaer_CollateralTokenAdded_event

PositionMangaer_DebtChanged_event

PositionMangaer_Liquidation_event

PositionMangaer_PositionCreated_event

PositionMangaer_RBorrowingFeePaid_event

PositionMangaer_Redemption_event

PositionMangaer_RedemptionRebateUpdated_event

PositionMangaer_RedemptionSpreadUpdated_event