ribbon_v1_ethereum

Tables

MarginPool_TransferToPool_event

Asset deposits into Ribbon Finance margin pools emitted when users transfer collateral to the pool contract. Records user address, asset contract address, and deposit amount for tracking collateral movements in options vault 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_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_asset	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x5934807cc0654d46755ebd2848840b616256c6ef	0xe63151a0ed4e5fafdc951d877102cf0977abd365	false	0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9	13719682162537585828170	404	15018098	2022-06-24T11:41:51.000Z	0xae312937c4b14aff9e1561193c9ae241403f1a174dcd7572f1c9382fd9cf5ed5
0x5934807cc0654d46755ebd2848840b616256c6ef	0x65a833afdc250d9d38f8cd9bc2b1e3132db13b2f	false	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	39950841706	97	15018003	2022-06-24T11:16:08.000Z	0x19fa4b17fb284218a6937da4c2e878a52a8fc188c8df1d2b0e0ae088c037cbac
0x5934807cc0654d46755ebd2848840b616256c6ef	0xa1da0580fa96129e753d736a5901c31df5ec5edf	false	0xae78736cd615f374d3085123a210448e74fc6393	207615369667348338407	92	15017881	2022-06-24T10:40:58.000Z	0x15fddbb41e9eaddc76772e01a590623c112e0eac2c0ce1213a1ef269f5e33e0c

Example Query

Query with partition filter

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

MarginPool_TransferToUser_event

Asset transfer events from Ribbon Finance margin pool contracts recording withdrawals to user accounts. Contains user address, asset token address, and transfer amount for tracking collateral movements and liquidity operations.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_asset	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x5934807cc0654d46755ebd2848840b616256c6ef	0x8f7dd610c457fc7cb26b0f9db4e77581f94f70ac	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	600325020393843877	162	11966881	2021-03-03T18:14:18.000Z	0xf1c9ffa62ac7ee25c0655a9fe48618d29bd0e12df45e8ae05bc0849149a13b7f
0x5934807cc0654d46755ebd2848840b616256c6ef	0x685654d53bef389760135c30f91c404eb000f4c5	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	1936478559899605236	222	11967081	2021-03-03T18:59:25.000Z	0x7a3c4a99ccefea9d88a1e91d7507413e237444b0c5442f6b53e57ef82889610e
0x5934807cc0654d46755ebd2848840b616256c6ef	0xdfb66eb0edd03499dac84bf5b770f9ea0e061047	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	2560000000	248	11962562	2021-03-03T02:15:06.000Z	0xe10b9d634d94b8589ad194c611e3dd82610222bc48ab9058bdfedbeaa40d4507

Example Query

Query with partition filter

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

Swap_createOffer_function

Function call records for creating option token swap offers on Ribbon Finance v1 Ethereum protocol. Tracks oToken (option token) auction parameters including total size, minimum price, bidding token, and minimum bid size for analyzing structured product secondary market 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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_oToken`	`STRING`	Contract address of the option token (oToken) being offered for sale in Ribbon Finance’s swap auction. Hex-encoded, 0x-prefixed 40-character Ethereum address representing the specific options contract.
`in_biddingToken`	`STRING`	Contract address of the token accepted for bids in this Ribbon Finance swap offer. Typically WBTC (0x2260fac…) or AAVE (0x7fc66…) tokens on Ethereum.
`in_minPrice`	`STRING`	Minimum price per unit that the offer creator will accept for the oTokens being sold. Denominated in the bidding token with precision matching that token’s decimals.
`in_minBidSize`	`STRING`	Minimum bid size required for participating in the options swap offer, denominated in the smallest unit of the bidding token. Values typically represent token amounts with implicit decimals (e.g., 100000000 for tokens with 8 decimals).
`in_totalSize`	`STRING`	Total size of the option token (oToken) offering being created in the swap auction, denominated in the smallest unit of the oToken. Values typically range from millions to trillions depending on token decimals.
`out_swapId`	`STRING`	Unique identifier assigned to the newly created option token swap offer on the Ribbon protocol. Returned as a string-encoded integer that increments sequentially (e.g., “1”, “2”, “3”).

Sample Data

gas	status	gas_used	in_oToken	signature	out_swapId	to_address	in_minPrice	block_number	from_address	in_totalSize	in_minBidSize	trace_address	block_timestamp	in_biddingToken	transaction_hash
190904	true	119851	0x5a6e0c4f209b6daae966718ec30c22b8ac4c7bfe	0x07a975a1	3	0xf0e5c92cedd66c7985c354c35e2bc37e685b99da	81	14805980	0x422f7bb366608723c8fe61ac6d923023dccbc3d7	32000000	3200000		2022-05-19T16:33:34.000Z	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	0x3ca2d74f5091d81503023454c0373d8ed4e6ac50db4072ca501e2d265f0c160a
442527	true	119851	0xce5c2b42f5384229c7e28aaefb0ca17deb49addd	0x07a975a1	11	0xf0e5c92cedd66c7985c354c35e2bc37e685b99da	322	15018003	0x65a833afdc250d9d38f8cd9bc2b1e3132db13b2f	39950841706	100000000	0,1,4	2022-06-24T11:16:08.000Z	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	0x19fa4b17fb284218a6937da4c2e878a52a8fc188c8df1d2b0e0ae088c037cbac
517340	true	119851	0xe1d7c6f5300ff4d35a7946eda562e04f13362047	0x07a975a1	12	0xf0e5c92cedd66c7985c354c35e2bc37e685b99da	17315090000000	15018098	0xe63151a0ed4e5fafdc951d877102cf0977abd365	1371968216253	137196821625	0,1,4	2022-06-24T11:41:51.000Z	0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9	0xae312937c4b14aff9e1561193c9ae241403f1a174dcd7572f1c9382fd9cf5ed5

Example Query

Query with partition filter

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

Swap_NewOffer_event

Option listing events from Ribbon Finance v1 on Ethereum where vault managers create new swap offers for oTokens (option tokens). Tracks offer parameters including seller address, option token, bidding token, total size, minimum bid size, and minimum price for analyzing vault auction 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_swapId`	`STRING`	Unique identifier for the swap or offer within the protocol. Numeric string representation without leading zeros.
`in_seller`	`STRING`	Address of the account selling tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_oToken`	`STRING`	Contract address of the oToken (Opyn options token) being offered for sale in this swap. Hex-encoded Ethereum address representing the specific options contract with defined strike, expiry, and underlying asset.
`in_biddingToken`	`STRING`	Contract address of the token accepted for bidding in this options swap. Hex-encoded, 0x-prefixed 40-character string representing ERC-20 tokens like WBTC or AAVE used as payment.
`in_minPrice`	`STRING`	Minimum price per unit of the option token (oToken) that the seller will accept in the bidding token. Value is denominated in the smallest unit of the bidding token with precision varying by token decimals.
`in_minBidSize`	`STRING`	Minimum bid size required to participate in this oToken swap offer. Value is denominated in the smallest unit of the bidding token (e.g., satoshis for WBTC).
`in_totalSize`	`STRING`	Total size of options tokens (oTokens) available for sale in this swap offer denominated in the smallest unit of the oToken contract. Values are typically large integers representing raw token amounts before decimal adjustment.

Sample Data

address	removed	in_oToken	in_seller	in_swapId	log_index	in_minPrice	block_number	in_totalSize	in_minBidSize	block_timestamp	in_biddingToken	transaction_hash
0xf0e5c92cedd66c7985c354c35e2bc37e685b99da	false	0x1e88b56334782bff52f3fb104f62241152e2ca90	0x65a833afdc250d9d38f8cd9bc2b1e3132db13b2f	9	304	322	14978789	42593004550	100000000	2022-06-17T10:53:39.000Z	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	0x173ac3d2496fb3884a14c87df1494e44569c0c4191c7af3c3e2ecb5ec801e964
0xf0e5c92cedd66c7985c354c35e2bc37e685b99da	false	0xa63e3b2276434700530c35e1b760116f53628e23	0xe63151a0ed4e5fafdc951d877102cf0977abd365	10	478	17315090000000	14978827	1365351588007	136535158800	2022-06-17T11:01:17.000Z	0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9	0xd232b83325062aea6538a19416104a197c52d6af533dc159d78d4a5f38e7c48e
0xf0e5c92cedd66c7985c354c35e2bc37e685b99da	false	0x5a6e0c4f209b6daae966718ec30c22b8ac4c7bfe	0xb8b7077c46f16d773737fe5e5ea273682c05544f	2	526	81	14798093	2000000	200000	2022-05-18T09:39:36.000Z	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	0x4bf43e932d42a1e88719b8869826ae9947cf4c25b06dfc9e9d61d6a0213ee030

Example Query

Query with partition filter

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

Swap_SettleOffer_event

Swap offer settlement events from Ribbon Finance v1 options vaults on Ethereum, recording when vault option swap offers are finalized. Used for tracking vault option settlement activity and analyzing structured product lifecycle completion.

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_swapId`	`STRING`	Unique identifier for the swap or offer within the protocol. Numeric string representation without leading zeros.

Sample Data

address	removed	in_swapId	log_index	block_number	block_timestamp	transaction_hash
0xf0e5c92cedd66c7985c354c35e2bc37e685b99da	false	2	145	14804976	2022-05-19T12:32:56.000Z	0xbbca5d8915053b1aa0a0a86516431d5c123997bb8f4310ffb7da186f025d3f92
0xf0e5c92cedd66c7985c354c35e2bc37e685b99da	false	1	72	14805645	2022-05-19T15:12:52.000Z	0x458139356e6f72c6288f5ba93594ff9d21d9684ac7011f94c8db92cdc8d5bcb1
0xf0e5c92cedd66c7985c354c35e2bc37e685b99da	false	12	44	15018125	2022-06-24T11:49:22.000Z	0xb979fde9002fb620ccb92ed3185420283b7549831100a6a9b4cb8158bf60ee95

Example Query

Query with partition filter

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

Swap_settleOffer_function

Settlement transactions for Ribbon Finance vault option auctions on Ethereum. Records bid executions with signer addresses, swap amounts, and cryptographic signatures for analyzing auction clearing and participation 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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_swapId`	`STRING`	Unique identifier for the swap or offer within the protocol. Numeric string representation without leading zeros.
`in_bids`	`ARRAY<STRUCT<swapId STRING, nonce STRING, signerWallet STRING, sellAmount STRING, buyAmount STRING, referrer STRING, v INT64, r STRING, s STRING>>`	Array of bid orders submitted to settle this swap, containing cryptographic signatures (v, r, s), trade amounts, and participant wallet addresses. Empty when the transaction fails or no bids were submitted.

Sample Data

gas	status	in_bids	gas_used	in_swapId	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
441046	true	[{“r”:“0xbc185dce0148e3bab2788983a712b1134b6c7829909841557d6336c2b4b001f0”,“s”:“0x064e7b6ae696b9bd84c5e3b325d998aff679685ced40a9db1a4874f7e2d7f4b6”,“v”:28,“nonce”:“625609058”,“swapId”:“7”,“referrer”:“0xcf12070dd7a51304f8abdc3916998262c26890ca”,“buyAmount”:“56230862222”,“sellAmount”:“179938759”,“signerWallet”:“0x57bfaa4781e2f5ad8955fe01e2bb2e5c40f6c354”}]	138472	7	0xd5172fcc	0xf0e5c92cedd66c7985c354c35e2bc37e685b99da	14938051	0x65a833afdc250d9d38f8cd9bc2b1e3132db13b2f	2022-06-10T10:54:05.000Z	0x369b11d2f98cfe3e69c1cd784c9a4ca824cd5852edee1811a5ad68ac2f5f6684
440988	true	[{“r”:“0x8ffdadec8746a1c338a76733b0e17f98674acb6db6c4b736bdd5741ba5e466e1”,“s”:“0x0c711b903d662fb1e6e8f37e4a03ea61a0910789f0a8c727da4f1e974c2d2a20”,“v”:28,“nonce”:“894046714”,“swapId”:“8”,“referrer”:“0xcf12070dd7a51304f8abdc3916998262c26890ca”,“buyAmount”:“1436046552148”,“sellAmount”:“81854653472436000000”,“signerWallet”:“0xce04f810442757d671a40d187929e6a154fe0788”}]	287186	8	0xd5172fcc	0xf0e5c92cedd66c7985c354c35e2bc37e685b99da	14938104	0xe63151a0ed4e5fafdc951d877102cf0977abd365	2022-06-10T11:09:00.000Z	0xf5df38eba47a93fbff48bfb805e7b8ce03a760650c3b639cdcb2b8435f6d497d
440966	true	[{“r”:“0x5aa7ca2557bce536902434b590362306bd0f657c57fa59e3cfacbbd73087d18d”,“s”:“0x3492c8f0b2fbedd2866dc725664e6c2c745784a66998d42c2d36ab7ea1c6098d”,“v”:27,“nonce”:“89008761”,“swapId”:“15”,“referrer”:“0xcf12070dd7a51304f8abdc3916998262c26890ca”,“buyAmount”:“1349060402016”,“sellAmount”:“141651342211680000000”,“signerWallet”:“0x9af83ef76f1e6dcb554064575d4018696451558d”}]	287186	15	0xd5172fcc	0xf0e5c92cedd66c7985c354c35e2bc37e685b99da	15101520	0xe63151a0ed4e5fafdc951d877102cf0977abd365	2022-07-08T11:02:33.000Z	0x1f20f6101ef5ce1b6dfa63b59440f5096491f063555eb1f5d21444da81cf7760

Example Query

Query with partition filter

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

Swap_Swap_event

Executed swap events recording bilateral token exchanges between sender and signer wallets. Contains token addresses, exchange amounts, nonces for replay protection, and optional protocol fees or affiliate compensation depending on contract version.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_swapId`	`STRING`	Unique identifier for the swap or offer within the protocol. Numeric string representation without leading zeros.
`in_nonce`	`STRING`	Unique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.
`in_signerWallet`	`STRING`	Wallet address of the order signer in the swap transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_signerAmount`	`STRING`	Amount of tokens provided by the order signer in the swap. Numeric string representation without decimals, denominated in the smallest unit of the signer token.
`in_sellerAmount`	`STRING`	Amount of tokens provided by the seller in the swap transaction. Numeric string representation without decimals, denominated in the smallest unit of the seller token.
`in_referrer`	`STRING`	Address that referred the user to the protocol or facilitated the transaction. 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	in_nonce	in_swapId	log_index	in_referrer	block_number	block_timestamp	in_sellerAmount	in_signerAmount	in_signerWallet	transaction_hash
0xf0e5c92cedd66c7985c354c35e2bc37e685b99da	false	150901346	1	71	0xcf12070dd7a51304f8abdc3916998262c26890ca	14805645	2022-05-19T15:12:52.000Z	32000000	3200	0x422f7bb366608723c8fe61ac6d923023dccbc3d7	0x458139356e6f72c6288f5ba93594ff9d21d9684ac7011f94c8db92cdc8d5bcb1
0xf0e5c92cedd66c7985c354c35e2bc37e685b99da	false	188843724	2	144	0xcf12070dd7a51304f8abdc3916998262c26890ca	14804976	2022-05-19T12:32:56.000Z	2000000	200	0x422f7bb366608723c8fe61ac6d923023dccbc3d7	0xbbca5d8915053b1aa0a0a86516431d5c123997bb8f4310ffb7da186f025d3f92
0xf0e5c92cedd66c7985c354c35e2bc37e685b99da	false	127995783	9	40	0xcf12070dd7a51304f8abdc3916998262c26890ca	14978816	2022-06-17T10:59:34.000Z	42593004550	134167964	0xce04f810442757d671a40d187929e6a154fe0788	0xf5fbc9d4ec91871be2af3551512abfcdd28819d2cbddd81b96f709a2a2e35232

Example Query

Query with partition filter

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

ThetaVault_CloseShort_event

Option position closure events from Ribbon Finance V1 theta vaults on Ethereum, recording when vault managers close short options positions. Captures withdrawal amounts and option contract addresses for tracking vault strategy execution and performance.

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_options`	`STRING`	Configuration parameters for LayerZero message execution. Hex-encoded byte string specifying gas limits, executor settings, and delivery options for cross-chain message handling.
`in_withdrawAmount`	`STRING`	Amount of collateral withdrawn from the vault when closing a short position, denominated in the vault’s base asset with full decimal precision. Typically represents the remaining collateral after option settlement or buyback.
`in_manager`	`STRING`	Address of the account authorized to manage the pool, vault, or fund. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_manager	in_options	block_number	block_timestamp	transaction_hash	in_withdrawAmount
0x0fabaf48bbf864a3947bdd0ba9d764791a60467a	false	603	0x77da011d5314d80be59e939c2f7ec2f702e1dcc4	0xe2adda534a9871aeeaed542803bae600e71626e5	13466855	2021-10-22T10:18:36.000Z	0xd7740d4213a6519103d5541d5e5d44ac6c9d7d018e9ac5fa0095182e730c0501	12861798128058186221056
0x8b5876f5b0bf64056a89aa7e97511644758c3e8c	false	140	0x77da011d5314d80be59e939c2f7ec2f702e1dcc4	0xc0b74b2d31d4df1549646377af9276348f8b9508	13466849	2021-10-22T10:17:38.000Z	0xed6264768d80f080957e9c13b3753acd61c75519719513e4bafd05299e8fe58b	26468622288
0x8fe74471f198e426e96be65f40eed1f8ba96e54f	false	216	0x77da011d5314d80be59e939c2f7ec2f702e1dcc4	0xf6348688c22e8558907597348e5cfd23fb282a9b	13466881	2021-10-22T10:27:07.000Z	0x4bd92ea9d338d5044517c2717ae4dcd7ba9aca0aeab4fcffc2091ce3c24381b1	41777248376034

Example Query

Query with partition filter

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

ThetaVault_Deposit_event

Deposit events from Ribbon Finance’s Theta Vault (V1) on Ethereum, capturing user contributions with deposited amounts, vault shares minted, and account addresses. Used for tracking vault capital inflows and share price calculations.

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_account`	`STRING`	Account address involved in the transaction 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_share`	`STRING`	Number of shares minted or burned in the vault or liquidity pool operation. String-encoded integer representing share token quantity in smallest denomination.

Sample Data

address	removed	in_share	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
0x16772a7f4a3ca291c21b8ace76f9332ddffbb5ef	false	9927396	10000000	300	0x12fcee56674f0d17edb05a0da149851a9664a505	12413052	2021-05-11T12:07:03.000Z	0x71e68b6958dc94065d7087a0071b93d1fda824547422318318d0821aa7402c43
0x16772a7f4a3ca291c21b8ace76f9332ddffbb5ef	false	9927396	10000000	172	0x4d65151cd05f43f9acbedbe4182b02445a93d7cf	12413222	2021-05-11T12:48:44.000Z	0xee6c77ea22de9f214d9fd549e17fe2f0fe5975639fa96c13269d8ca2ba7a3aeb
0x16772a7f4a3ca291c21b8ace76f9332ddffbb5ef	false	992739658	1000000000	260	0x6c883dc1ed81fc5fa43648c8c03a26373745e1a0	12413503	2021-05-11T13:52:24.000Z	0xb256b38b9c8453c01fb870f2fd6a13601198b19e0a696acb0e75c30fdbb7ec1c

Example Query

Query with partition filter

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

ThetaVault_OpenShort_event

Events capturing when Ribbon Finance ThetaVaults on Ethereum open short option positions, recording the vault address, option contract, deposited collateral amount, and managing address. Used for analyzing vault strategy execution timing, collateral deployment, and covered call writing activity across Ribbon’s automated options 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_options`	`STRING`	Configuration parameters for LayerZero message execution. Hex-encoded byte string specifying gas limits, executor settings, and delivery options for cross-chain message handling.
`in_depositAmount`	`STRING`	Amount of tokens deposited into the liquidity pool or vault. String-encoded integer representing the value in the smallest denomination of the token (wei for ETH, atomic units for other tokens).
`in_manager`	`STRING`	Address of the account authorized to manage the pool, vault, or fund. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_manager	in_options	block_number	block_timestamp	in_depositAmount	transaction_hash
0x0fabaf48bbf864a3947bdd0ba9d764791a60467a	false	244	0x77da011d5314d80be59e939c2f7ec2f702e1dcc4	0xcd8cabd350eb1895e74840fd0e2950d4daf3f4ad	13197693	2021-09-10T11:16:14.000Z	10660905110446301822560	0xb73654393d1fbdfa307e1b2091901910b31f1dc50fae4c991fe76804feca4418
0x8b5876f5b0bf64056a89aa7e97511644758c3e8c	false	136	0x77da011d5314d80be59e939c2f7ec2f702e1dcc4	0xd7ce3e6892dd175d313d59c73ed4a1aba818783f	13197671	2021-09-10T11:12:24.000Z	34071498266	0x23c1f3a5869a369ae2a6e23848b62f25b1a6a3f0dbb537aceab17871040d1d52
0x16772a7f4a3ca291c21b8ace76f9332ddffbb5ef	false	59	0x77da011d5314d80be59e939c2f7ec2f702e1dcc4	0x0d48bde2c32b02cc9bba24641e5e91bd47c031a8	13197698	2021-09-10T11:18:07.000Z	7479193537778	0x6f5a8595e6d2b68f177732ce66faaeb8243af492b7b3bdcb840738c60fb33df9

Example Query

Query with partition filter

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

ThetaVault_Withdraw_event

Withdrawal events from Ribbon Finance v1 Theta Vaults on Ethereum, recording user redemptions of vault shares for underlying assets with associated fees. Contains account addresses, share amounts, withdrawal amounts, and fee data for tracking vault liquidity flows and user 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_account`	`STRING`	Account address involved in the transaction 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_share`	`STRING`	Number of shares minted or burned in the vault or liquidity pool operation. String-encoded integer representing share token quantity in smallest denomination.
`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.

Sample Data

in_fee	address	removed	in_share	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
113785	0x16772a7f4a3ca291c21b8ace76f9332ddffbb5ef	false	10146567	11264714	376	0xa5b3a7aadca7538604feecf36ed53f2ed51ec5c5	14374735	2022-03-12T22:47:23.000Z	0xe270f79e46b668004e24d5a90d72e9de1227bb06ab3fa81b36137de604880316
105234703	0x8fe74471f198e426e96be65f40eed1f8ba96e54f	false	8070352329	10418235597	285	0xc52e5b17933fe77acde812760453fbf97d4cac30	14371325	2022-03-12T10:07:30.000Z	0x945789595484ae4e961eccc30da01f07fbeb8fc9c3e63b10d388ee5ea5d05e65
6142271	0x8b5876f5b0bf64056a89aa7e97511644758c3e8c	false	1208747429	1222311927	222	0xa6a6d246e2e5704d0e9c2dd6d77bbf2ec378cb09	14373302	2022-03-12T17:34:52.000Z	0x7a6267495c9146643dabe76e9eb3d483c1b4331128e88dee16816b78c8e5d95d

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

MarginPool_TransferToPool_event

MarginPool_TransferToUser_event

Swap_createOffer_function

Swap_NewOffer_event

Swap_SettleOffer_event

Swap_settleOffer_function

Swap_Swap_event

ThetaVault_CloseShort_event

ThetaVault_Deposit_event

ThetaVault_OpenShort_event

ThetaVault_Withdraw_event

​Tables

​MarginPool_TransferToPool_event

​MarginPool_TransferToUser_event

​Swap_createOffer_function

​Swap_NewOffer_event

​Swap_SettleOffer_event

​Swap_settleOffer_function

​Swap_Swap_event

​ThetaVault_CloseShort_event

​ThetaVault_Deposit_event

​ThetaVault_OpenShort_event

​ThetaVault_Withdraw_event

Tables

MarginPool_TransferToPool_event

MarginPool_TransferToUser_event

Swap_createOffer_function

Swap_NewOffer_event

Swap_SettleOffer_event

Swap_settleOffer_function

Swap_Swap_event

ThetaVault_CloseShort_event

ThetaVault_Deposit_event

ThetaVault_OpenShort_event

ThetaVault_Withdraw_event