ribbon_v2_avalanche

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
0xccf6629aeab734e621cc59ebb0297196774fdb9d	0x0e987cd3a4baa82d79f073ca4b2062ba78891027	false	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	8150000000000000000	9	14095914	2022-04-30T14:13:31.000Z	0x5ed96f70b21dc842fa1b4e0c89606660881e5ec324fc46d6cfa4684dea8defe0
0xccf6629aeab734e621cc59ebb0297196774fdb9d	0x4a678dfa01d3ef6378c99cdcc7eb5fb9defde36f	false	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	6000000000000000000	7	14103656	2022-04-30T18:40:55.000Z	0xa59df984e0059a42d757a33e413f78801576267df0fe608cdf54da237ac0d1cb
0xccf6629aeab734e621cc59ebb0297196774fdb9d	0x4a678dfa01d3ef6378c99cdcc7eb5fb9defde36f	false	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	6875300000000000000	3	14103290	2022-04-30T18:28:12.000Z	0x97d77d8a8d2cbb00b6c6b126a2cb6f42c4dbccacbe23f9b1c3b9a6bb61121285

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ribbon_v2_avalanche.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
0xccf6629aeab734e621cc59ebb0297196774fdb9d	0x6bf686d99a4ce17798c45d09c21181fac29a9fb3	false	0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	81749170273914126854324	1	17653461	2022-07-22T09:10:09.000Z	0x8adc4f220fca1222bf99f4ecbe00663a7c61d6471bed6595acc3324ad4eb6dec
0xccf6629aeab734e621cc59ebb0297196774fdb9d	0x8cef7243992d3f04dc14bf99cd34f337bbdfa59a	false	0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	6199282240657854326525	9	17655469	2022-07-22T10:17:27.000Z	0x7756274b6c504bc4280b6ac828c919660fa62179f6bbddff800dfe771a8fe290
0xccf6629aeab734e621cc59ebb0297196774fdb9d	0x98d03125c62dae2328d9d3cb32b7b969e6a87787	false	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	69140954150001857458587	3	17658523	2022-07-22T11:59:51.000Z	0xd72dd8796736a866fa556c278a9078a3a1ccf440a2bfba38f8f57872bb1ff832

Example Query

Query with partition filter

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

RibbonThetaVaultWithSwap_PerformanceFeeSet_event

Performance fee configuration changes for Ribbon V2 theta vaults on Avalanche. Tracks historical adjustments to vault performance fees (stored as basis points with 8 decimals: 10000000 = 10%) for analyzing fee structure evolution and vault economics.

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_performanceFee`	`STRING`	Previous performance fee rate for the vault. Numeric string representation where the value is basis points divided by 100 to yield the percentage.
`in_newPerformanceFee`	`STRING`	New performance fee rate for the vault. Decimal representation stored as string, where the value divided by 1e10 yields the percentage (e.g., ‘100000000000000000’ equals 10%).

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_performanceFee	in_newPerformanceFee
0x98d03125c62dae2328d9d3cb32b7b969e6a87787	false	8	29568547	2023-05-04T03:51:53.000Z	0xf4f8ba4a02f466183db47264912a2fe8a022b176ea66cd31f47579fc03741f9d	0	10000000
0x98d03125c62dae2328d9d3cb32b7b969e6a87787	false	7	17658044	2022-07-22T11:43:54.000Z	0x4e61d05283fc8d3f8d52249f6b29d9eaa812bd76988f7264ded37287f480dca1	10000000	0
0x9dd6be071b4292cc88b8190ab718329adea3e3a3	false	8	17049528	2022-07-08T07:33:33.000Z	0x07beedf7b1fcc663eda25ce08a255a26f5c5eb583de4217c5f9cefcd8c10ae1f	10000000	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ribbon_v2_avalanche.RibbonThetaVaultWithSwap_PerformanceFeeSet_event`
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	in_feeAmount	block_timestamp	in_sellerAmount	in_signerAmount	in_signerWallet	transaction_hash
0x15988cea1f11d62e63baa02b0e8b3046942983c0	false	235431934	138	6	0xcf12070dd7a51304f8abdc3916998262c26890ca	35509944	1747855693863500000	2023-09-22T10:43:27.000Z	822520326524	13982845550908000000	0xf12e3d50ee7d2a9b79a4f337b0aa63658a1d3268	0xbbd18d06cf2637f2d827652fa485f2c8ab44971edfe6295d5dae3e2f421862ed
0x15988cea1f11d62e63baa02b0e8b3046942983c0	false	841242335	137	4	0xcf12070dd7a51304f8abdc3916998262c26890ca	35509805	2855198176587675000	2023-09-22T10:38:47.000Z	1136397284214	22841585412701400000	0xeb7a22bd0f61fc6e15dc850df4bdc878d231dd3e	0x20231a68f68980e7e1fde541bc1abd01333fe32e7ea26835295479f532f0e481
0x15988cea1f11d62e63baa02b0e8b3046942983c0	false	528906545	118	6	0xcf12070dd7a51304f8abdc3916998262c26890ca	32587312	3298399662396000000	2023-07-14T10:12:27.000Z	824599915599	32159396708361000000	0xf12e3d50ee7d2a9b79a4f337b0aa63658a1d3268	0xea208a2bbce9c65eb04116df118bb7bf451b273c713bdfc5224ff7105c7bebf3

Example Query

Query with partition filter

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

SwapV1_Swap_event

Swap execution events from Ribbon Finance v2 vaults on Avalanche, capturing bilateral token exchanges with signer and seller amounts, nonce tracking, and referral addresses. Used for analyzing vault trading activity, fee structures, and referral-driven swap volume.

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
0x907a3535ee5275e4af7e6c8a642c0f9443da1dc2	false	403382504	5	3	0xcf12070dd7a51304f8abdc3916998262c26890ca	17037236	2022-07-08T00:41:02.000Z	2000000000	200000000000000	0x422f7bb366608723c8fe61ac6d923023dccbc3d7	0x63c67982e0e0d6d9afb048bb8eff7b0000cae54777b192f49d464fa6b5727b4a
0x907a3535ee5275e4af7e6c8a642c0f9443da1dc2	false	606073448	5	3	0xcf12070dd7a51304f8abdc3916998262c26890ca	17037201	2022-07-08T00:39:51.000Z	100000000	10000000000000	0x422f7bb366608723c8fe61ac6d923023dccbc3d7	0xd0ade1ad91feb327a5413d10d884de9e4af28a83b685a391db0514a0e1e1e5ff
0x907a3535ee5275e4af7e6c8a642c0f9443da1dc2	false	629796028	7	3	0xcf12070dd7a51304f8abdc3916998262c26890ca	17058258	2022-07-08T12:26:12.000Z	8590792133875	455311983095375000000	0xce04f810442757d671a40d187929e6a154fe0788	0xc255b0b0a71f5c2ec52af8254ebc20b6cb97859522104aebf93360dc617b5953

Example Query

Query with partition filter

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

ThetaVault_CloseShort_event

Option position closure events from Ribbon Finance v2 Theta Vaults on Avalanche, recording when vaults settle short option positions with withdrawal amounts and option contract addresses. Used for tracking vault performance and options strategy execution cycles.

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 options position when closing the short, denominated in the smallest unit of the underlying token. Values can be zero if no withdrawal occurs or very large integers representing token amounts with native decimals.
`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
0x98d03125c62dae2328d9d3cb32b7b969e6a87787	false	3	0x55e4b3e3226444cd4de09778844453ba9fe9cd7c	0x81f7b436cbb6885921b416bca64f199683c381e1	34072669	2023-08-18T09:10:11.000Z	0xf7b9d43306eab88a7417eb78c84651e12ccb009261306e6d08d00fcd7757e142	11460132496238087000583
0x6bf686d99a4ce17798c45d09c21181fac29a9fb3	false	11	0x55e4b3e3226444cd4de09778844453ba9fe9cd7c	0xc81648deb47236720e75452fa834fc20639efb64	34072669	2023-08-18T09:10:11.000Z	0x2cb035a271270d055c35dfb110fae57880c71458f991c6a189a8502e6ed1e746	8420565242326767107242
0x9dd6be071b4292cc88b8190ab718329adea3e3a3	false	6	0x55e4b3e3226444cd4de09778844453ba9fe9cd7c	0x35b56c8648f973f40867853c7c06707e4c4d2860	13149521	2022-04-08T11:20:36.000Z	0x21ee2b0c61c696dc2f5f660c828440f5c2a53a7128ebfab7825d4e5ce2cc79f8	996069219665

Example Query

Query with partition filter

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

ThetaVault_CollectVaultFees_event

Fee collection events from Ribbon Finance ThetaVault options selling vaults on Avalanche, tracking management and performance fees charged per round. Used for analyzing vault economics, fee recipient changes, and revenue generation across different 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_performanceFee`	`STRING`	Previous performance fee rate for the vault. Numeric string representation where the value is basis points divided by 100 to yield the percentage.
`in_vaultFee`	`STRING`	Management fee amount collected by the Ribbon ThetaVault contract, denominated in the vault’s base token and represented in smallest units (wei). Values are often zero when no fees were charged for that round.
`in_round`	`STRING`	Sequential identifier for vault or auction rounds. Numeric string representing the round number in the protocol’s lifecycle.
`in_feeRecipient`	`STRING`	Address designated to receive fees collected from the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_round	log_index	in_vaultFee	block_number	block_timestamp	in_feeRecipient	transaction_hash	in_performanceFee
0x98d03125c62dae2328d9d3cb32b7b969e6a87787	false	2	102	53233791600000000	8173454	2021-12-13T06:26:57.000Z	0xd4816d144c005b29df24c8eb1865fb8a1e79fdde	0xaf3d2778a2eefb98244f5d27d832bc713d93835bc88a95fb781639293661124f	11000000000000000
0x98d03125c62dae2328d9d3cb32b7b969e6a87787	false	35	1	0	17658567	2022-07-22T12:01:20.000Z	0x939cbb6babaad2b0533c2caca8a4afec3ae06492	0x4c64cd7f75a0cd16161c585bca46cd21e4b74d37c570ca6aab7c3d274f93c341	0
0x98d03125c62dae2328d9d3cb32b7b969e6a87787	false	34	10	0	17653460	2022-07-22T09:10:06.000Z	0x939cbb6babaad2b0533c2caca8a4afec3ae06492	0x0c383fd57a928711b93ea4b89662ad09b29427f69ec4aca477e6659663c55034	0

Example Query

Query with partition filter

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

ThetaVault_Deposit_event

Deposit events from Ribbon Finance ThetaVault options strategy vaults on Avalanche, tracking user capital allocations into vault rounds with depositor addresses and amounts. Used for analyzing vault participation patterns, capital inflows, and user behavior across vault epochs.

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_round`	`STRING`	Sequential identifier for vault or auction rounds. Numeric string representing the round number in the protocol’s lifecycle.

Sample Data

address	removed	in_round	in_amount	in_account	block_number	block_timestamp	transaction_hash
0x6bf686d99a4ce17798c45d09c21181fac29a9fb3	false	42	28123974864814966	0x0ee1470a9f05f402da26c42fd737df66bd41cbb2	23370230	2022-12-08T12:30:40.000Z	0x49fafab9437f85510de19f48e6a2e723244544b6179fe9f23eea957714347e07
0x6bf686d99a4ce17798c45d09c21181fac29a9fb3	false	42	3000000000000	0x0f5d2dc5278b411b4084329eaa122c016a9e8a11	23366181	2022-12-08T10:13:25.000Z	0x4997d5e4cef1f982faaa1efd16aa95f06731d522f08a418fb6dfd3137f6c5992
0x6bf686d99a4ce17798c45d09c21181fac29a9fb3	false	42	90000000000000000	0x73f809c0b3cf18d40463d05ba4b95067cb51393b	23378994	2022-12-08T17:27:07.000Z	0x7fd1e7acc076cc76405955d30ad6882e2efc7f0d36f09933f0035a581753c7c2

Example Query

Query with partition filter

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

ThetaVault_InstantWithdraw_event

Instant withdrawal events from Ribbon Finance V2 ThetaVault options strategy vaults on Avalanche, capturing immediate fund withdrawals with account addresses, amounts, and round numbers. Used for analyzing vault liquidity patterns and user exit behavior across vault epochs.

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_round`	`STRING`	Sequential identifier for vault or auction rounds. Numeric string representing the round number in the protocol’s lifecycle.

Sample Data

address	removed	in_round	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
0x6bf686d99a4ce17798c45d09c21181fac29a9fb3	false	10	1631453049613003121	58	0xc5602f7ab972cd93967c576df6c12f29f941d9c4	13897666	2022-04-25T22:03:02.000Z	0x4e3cfefe62bdeae0826652a78885730df5f003d7c3f3355e15f8cad915bb0b88
0x6bf686d99a4ce17798c45d09c21181fac29a9fb3	false	33	13436577214453633	35	0x0de0c29c82656802874abe625b49ec0bf4fd43aa	20585733	2022-10-03T08:10:57.000Z	0xe96980ef6410c3ad08f614e364238b7e89cb6832d7b313c53ce0a57a9f8c3e4b
0x6bf686d99a4ce17798c45d09c21181fac29a9fb3	false	33	95973570659113558	0	0x92ff9e4b6bafa6b7a5607f1b5ab1795cb15360b1	20598476	2022-10-03T15:30:11.000Z	0x4b15cc9b8a14e24e43ed2627fe3e1b341f69d768faf106b3ce99bed4462e669e

Example Query

Query with partition filter

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

ThetaVault_OpenShort_event

Event logs from Ribbon Finance V2 theta vaults on Avalanche recording short option position openings, capturing vault address, options contract, manager, and deposit amount for tracking covered call and put selling 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_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	in_manager	in_options	block_number	block_timestamp	in_depositAmount	transaction_hash
0x98d03125c62dae2328d9d3cb32b7b969e6a87787	false	0x55e4b3e3226444cd4de09778844453ba9fe9cd7c	0xd329b2f2ab97b56480ae6aa691f63677a8fd3c61	21344781	2022-10-21T09:52:40.000Z	137046924956703952723549	0x9c4c7e2a030b46ac4f233abff40b3fe369a03d178ed5fab6f293326b9956aeb0
0x6bf686d99a4ce17798c45d09c21181fac29a9fb3	false	0x55e4b3e3226444cd4de09778844453ba9fe9cd7c	0x1427086e3237d3bd6da38da3ed9b1a53cec99236	21344782	2022-10-21T09:52:42.000Z	15265651491922872631896	0xd868de311055471202dc060b887ceb89400ec66d73bc16d2361a2263f6667120
0x6bf686d99a4ce17798c45d09c21181fac29a9fb3	false	0x55e4b3e3226444cd4de09778844453ba9fe9cd7c	0x179bcf74fe96c881d08a7cc7dec49a9d3986e1e4	35213769	2023-09-15T10:34:57.000Z	8326169079696981391884	0x3a0a22831b5d5372cca5780a53e80842667374e4fead986007b73dda853dd431

Example Query

Query with partition filter

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

ThetaVault_PerformanceFeeSet_event

Performance fee configuration changes for Ribbon Finance V2 theta vaults on Avalanche. Captures fee adjustments with old and new values (in basis points) for tracking vault economics and 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_performanceFee`	`STRING`	Previous performance fee rate for the vault. Numeric string representation where the value is basis points divided by 100 to yield the percentage.
`in_newPerformanceFee`	`STRING`	New performance fee rate for the vault. Decimal representation stored as string, where the value divided by 1e10 yields the percentage (e.g., ‘100000000000000000’ equals 10%).

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_performanceFee	in_newPerformanceFee
0x9dd6be071b4292cc88b8190ab718329adea3e3a3	false	8	17049528	2022-07-08T07:33:33.000Z	0x07beedf7b1fcc663eda25ce08a255a26f5c5eb583de4217c5f9cefcd8c10ae1f	10000000	0
0x98d03125c62dae2328d9d3cb32b7b969e6a87787	false	7	17658044	2022-07-22T11:43:54.000Z	0x4e61d05283fc8d3f8d52249f6b29d9eaa812bd76988f7264ded37287f480dca1	10000000	0
0x98d03125c62dae2328d9d3cb32b7b969e6a87787	false	8	29568547	2023-05-04T03:51:53.000Z	0xf4f8ba4a02f466183db47264912a2fe8a022b176ea66cd31f47579fc03741f9d	0	10000000

Example Query

Query with partition filter

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

ThetaVault_Withdraw_event

Withdrawal events from Ribbon Finance v2 ThetaVault options strategies on Avalanche, tracking user redemptions with vault share amounts and underlying asset values. Used for analyzing vault liquidity flows and user exit patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_amount	in_shares	log_index	in_account	block_number	block_timestamp	transaction_hash
0x98d03125c62dae2328d9d3cb32b7b969e6a87787	false	14066008127047773056	14322610293855336312	55	0x709c0f8d660406a3e5be1e12ef60da8a71f31a12	10740979	2022-02-10T15:13:59.000Z	0x2e40272518582fcb32f5b8dfaadea3ea83162f78997a0a5952c8cab23bd4a138
0x98d03125c62dae2328d9d3cb32b7b969e6a87787	false	122481532706453792	130556404040533413	397	0x1a247288c2c33701ec69d6e61db10f1d17f7a1a1	29748240	2023-05-08T09:37:08.000Z	0x2f5f4161179291f05dd113aec75375d586ebd2e7d2db2b7879f15d23bfb22abc
0x6bf686d99a4ce17798c45d09c21181fac29a9fb3	false	832418194179504345	957574103485874184	15	0x736766b9a41aceea10c89aa93468d93b1aae1907	29754559	2023-05-08T13:11:58.000Z	0x3094d7e24294d5c3db2bc7215d3c141914fc54bd04ce29beb9dedf56f288c559

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ribbon_v2_avalanche.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

RibbonThetaVaultWithSwap_PerformanceFeeSet_event

Swap_Swap_event

SwapV1_Swap_event

ThetaVault_CloseShort_event

ThetaVault_CollectVaultFees_event

ThetaVault_Deposit_event

ThetaVault_InstantWithdraw_event

ThetaVault_OpenShort_event

ThetaVault_PerformanceFeeSet_event

ThetaVault_Withdraw_event

​Tables

​MarginPool_TransferToPool_event

​MarginPool_TransferToUser_event

​RibbonThetaVaultWithSwap_PerformanceFeeSet_event

​Swap_Swap_event

​SwapV1_Swap_event

​ThetaVault_CloseShort_event

​ThetaVault_CollectVaultFees_event

​ThetaVault_Deposit_event

​ThetaVault_InstantWithdraw_event

​ThetaVault_OpenShort_event

​ThetaVault_PerformanceFeeSet_event

​ThetaVault_Withdraw_event

Tables

MarginPool_TransferToPool_event

MarginPool_TransferToUser_event

RibbonThetaVaultWithSwap_PerformanceFeeSet_event

Swap_Swap_event

SwapV1_Swap_event

ThetaVault_CloseShort_event

ThetaVault_CollectVaultFees_event

ThetaVault_Deposit_event

ThetaVault_InstantWithdraw_event

ThetaVault_OpenShort_event

ThetaVault_PerformanceFeeSet_event

ThetaVault_Withdraw_event