ribbon_v2_ethereum - Token Terminal Docs

Tables

EarnVault_Approval_event

ERC-20 token approval events from Ribbon Finance v2 Earn Vaults on Ethereum, tracking spending allowances granted by vault token holders to spender addresses. Used for monitoring vault share approvals and transfer authorization patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_spender`	`STRING`	Address authorized to spend tokens on behalf of the owner. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_owner	in_value	log_index	in_spender	block_number	block_timestamp	transaction_hash
0xce5513474e077f5336cf1b33c1347fdd8d48ae8c	false	0xce5513474e077f5336cf1b33c1347fdd8d48ae8c	0	213	0xad4dbd3be46f7bdab82702b581b1d4c5f584741a	16502244	2023-01-28T02:11:47.000Z	0x0ebef5082904e3aa28dcb1b9ac21c19800cb2fd7d77aa0660d1ccd0f9bbdc212
0xce5513474e077f5336cf1b33c1347fdd8d48ae8c	false	0xce5513474e077f5336cf1b33c1347fdd8d48ae8c	15232440878264979	210	0xad4dbd3be46f7bdab82702b581b1d4c5f584741a	16502244	2023-01-28T02:11:47.000Z	0x0ebef5082904e3aa28dcb1b9ac21c19800cb2fd7d77aa0660d1ccd0f9bbdc212
0xce5513474e077f5336cf1b33c1347fdd8d48ae8c	false	0xce5513474e077f5336cf1b33c1347fdd8d48ae8c	17037987184411217	192	0xad4dbd3be46f7bdab82702b581b1d4c5f584741a	16506753	2023-01-28T17:17:11.000Z	0x10c7ff89d4b2fd2340cea7e8c13cd82c61b7a60c26dd62e2304816e590976b59

Example Query

Query with partition filter

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

EarnVault_BorrowerBasketUpdated_event

Events tracking updates to the borrower whitelist and allocation weights in Ribbon V2 Earn Vaults on Ethereum. Records which addresses are authorized borrowers and their relative weight distribution for vault lending 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_borrowers`	`ARRAY<STRING>`	Array of Ethereum addresses designated as approved borrowers in the Ribbon Earn Vault’s updated basket configuration. Can be empty when all borrowers are removed from the vault’s approved list.
`in_borrowerWeights`	`ARRAY<STRING>`	Array of weight values assigned to each corresponding borrower address in the basket, where weights represent allocation percentages (e.g., 100000 = 100%). Can be empty when the borrower basket is cleared.

Sample Data

address	removed	log_index	block_number	in_borrowers	block_timestamp	transaction_hash	in_borrowerWeights
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	290	15408221	[“0x44c8e19bd59a8ea895fff60dbb4e762028f2fb71”]	2022-08-25T09:05:11.000Z	0x3aff3877e1d9d223831c05feb2740545cc79e31dbe26029530a8af2f1d24fdc1	[“50000”]
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	132	15823634	[“0xa1614ec01d13e04522ed0b085c7a178ed9e99bc9”,“0x44c8e19bd59a8ea895fff60dbb4e762028f2fb71”,“0x0aea75705be8281f4c24c3e954d1f8b1d0f8044c”]	2022-10-25T07:34:23.000Z	0x681e015334c13035e1657475972710c24e0d54799f435c969c05ad263116baaa	[“0”,“0”,“100000”]
0xce5513474e077f5336cf1b33c1347fdd8d48ae8c	false	302	16043013	[]	2022-11-24T23:05:59.000Z	0x858a88e37cde8d692cf7059bba377072f4698af722da9e8e12fb550c5a139758	[]

Example Query

Query with partition filter

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

EarnVault_CapSet_event

Deposit capacity limit changes for Ribbon Finance V2 Earn Vaults on Ethereum, recording old and new cap values when vault administrators adjust maximum TVL (Total Value Locked). Used for tracking vault risk management parameters and capacity expansion over time.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_oldCap`	`STRING`	Previous deposit cap value for the Ribbon Earn Vault before the update, denominated in the smallest token unit. This value represents the maximum total deposits allowed in the vault prior to the cap adjustment event.
`in_newCap`	`STRING`	New deposit cap limit for the Ribbon Earn Vault in token wei units. This value represents the maximum Total Value Locked (TVL) allowed after the cap adjustment event.

Sample Data

address	removed	in_newCap	in_oldCap	log_index	block_number	block_timestamp	transaction_hash
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	5000000000000	2500000000000	288	15408221	2022-08-25T09:05:11.000Z	0x3aff3877e1d9d223831c05feb2740545cc79e31dbe26029530a8af2f1d24fdc1
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	25000000000000	5000000000000	34	15623147	2022-09-27T07:17:11.000Z	0x1836deb3b32ebdec633069ab4ee83fb82780573b4facb8bc2577113c1d3c4ed1
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	7500000000000	25000000000000	163	17063961	2023-04-17T03:51:23.000Z	0xad414af593d0641b5a68881be1fdf143807fb1c1b80c4b229c7800f0fca06548

Example Query

Query with partition filter

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

EarnVault_CloseLoan_event

Loan repayment events from Ribbon v2 EarnVault on Ethereum, tracking borrower addresses, principal amounts, and yield generated. Used for analyzing lending activity and borrower behavior in Ribbon’s structured product vaults.

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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_yield`	`STRING`	Yield earned on the loan at closure, denominated in the vault’s base token units. May be zero if the loan is closed early or at breakeven.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_yield	in_amount	log_index	in_borrower	block_number	block_timestamp	transaction_hash
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	0	3920000	444	0x44c8e19bd59a8ea895fff60dbb4e762028f2fb71	15645033	2022-09-30T08:43:47.000Z	0x47f205f9b579a24b372e3342637cfd485e860a2d4200b761fe6f4d466d249bac
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	18080001057	2499520000000	263	0x44c8e19bd59a8ea895fff60dbb4e762028f2fb71	15645068	2022-09-30T08:50:47.000Z	0xac4c823e87a7ea3180167ea88b23f3046ce95deada3e3e4e0061111ab665896a
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	0	2495716778082	332	0xa1614ec01d13e04522ed0b085c7a178ed9e99bc9	15597533	2022-09-23T17:27:47.000Z	0xc46bda343658b08e223435530d88e95c94a6014c9ddc8530f238e0f14d446406

Example Query

Query with partition filter

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

EarnVault_CollectVaultFees_event

Fee collection events from Ribbon V2 earn vaults on Ethereum, capturing performance fees and management fees per vault round. Used to track protocol revenue, vault profitability, and fee distribution to the designated recipient address.

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 vault protocol in the specified round, denominated in the vault’s base token units. Can be zero when no management fees are assessed 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
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	53	36	0	18340577	2023-10-13T09:28:11.000Z	0xdaeada3d210d2f45874724beea03c7d4bbd41674	0x8d2a12cee46caef1af9c26d59b235d85f8b2954782c30972769466162265c7d0	0
0xce5513474e077f5336cf1b33c1347fdd8d48ae8c	false	45	300	0	18340582	2023-10-13T09:29:11.000Z	0xdaeada3d210d2f45874724beea03c7d4bbd41674	0x042068a21786abc9221c16e47a8bc14924e3b12101dbfd5cbce0e0438194e427	0
0xce5513474e077f5336cf1b33c1347fdd8d48ae8c	false	9	233	1162764073551385670	16548228	2023-02-03T12:23:11.000Z	0xdaeada3d210d2f45874724beea03c7d4bbd41674	0xf828cd1300775d9a87be0f9ac002cdea1057ca344a571bc8127e195b32bc2892	1162764073551385670

Example Query

Query with partition filter

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

EarnVault_CommitBorrowerBasket_event

Borrower basket commitment events from Ribbon V2 earn vaults on Ethereum, recording when vault operators allocate or reset borrower weights for capital deployment. Used for tracking vault management decisions and capital allocation strategies across different borrower addresses.

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_totalBorrowerWeight`	`STRING`	Total cumulative weight assigned to borrowers in the basket at commit time, denominated in basis points. A value of 100000 represents 100% weight allocation, while 0 indicates no borrower allocation.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_totalBorrowerWeight
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	22	15647186	2022-09-30T15:56:23.000Z	0x93250a999468003366b1175b6cf6131f057f6b2337c7f5377c69cdbb19c7e593	100000
0xce5513474e077f5336cf1b33c1347fdd8d48ae8c	false	246	18240533	2023-09-29T09:39:11.000Z	0x1700043db67921ee5f9bd57558a456c45a457b67dced9a5d57337bed6062621a	0
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	5	18240541	2023-09-29T09:40:47.000Z	0xb64fd01ded8a2a519c2ca52ceeb2fdb263e8a568b6af21e257c1d9b4fcf4d6e4	100000

Example Query

Query with partition filter

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

EarnVault_Deposit_event

Deposit events from Ribbon Finance v2 Earn Vaults on Ethereum, capturing user deposits with account addresses, deposit amounts, and vault round numbers. Used for tracking capital inflows and analyzing depositor behavior across 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_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
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	19	16867600	30	0xfa2779725822c510cb69ffeee53b812cce33b77d	16638985	2023-02-16T04:43:47.000Z	0xf51509126b09ff7cbf71e497c7130f6a91e2f05486d179ab328eb56daa3a9d44
0xce5513474e077f5336cf1b33c1347fdd8d48ae8c	false	11	99989542095005	378	0x869fe51f843472223dead0920e3cb43c33a9db99	16640205	2023-02-16T08:49:59.000Z	0x995b133027b215b34db428c4807d1623a0c63d07eb69efc434e929f9493bbb2c
0xce5513474e077f5336cf1b33c1347fdd8d48ae8c	false	11	19995997454225452	431	0x019ed608dd806b80193942f2a960e7ac8abb2ee3	16643410	2023-02-16T19:34:11.000Z	0x9c362f4f501cd085a5fca1329973e26737d6b3a2f13b36f56c307873a6008d58

Example Query

Query with partition filter

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

EarnVault_InitiateWithdraw_event

Withdrawal initiation events from Ribbon Finance v2 Earn Vaults on Ethereum, capturing user account addresses, vault share amounts, and round numbers when users queue withdrawals. Used for tracking withdrawal requests and vault liquidity outflows 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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`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.
`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_shares	log_index	in_account	block_number	block_timestamp	transaction_hash
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	8	19698571	122	0x0c057aff99c65850563f2a4c13f24feca525a6b7	16052767	2022-11-26T07:47:47.000Z	0xb8654c2fa6efb8be9adf0199174ddc42f14e5589976218e34699de715140eca6
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	8	4937437725	156	0xffd0b16ad371a90676c4442b4065ea01cf500e11	16051480	2022-11-26T03:29:23.000Z	0xc28b407d87334c6dcd102eeee8479cbb23f0e65ce09ea2734f03ba5cbd355afe
0xce5513474e077f5336cf1b33c1347fdd8d48ae8c	false	28	50076941018400438	230	0xf14729358c35e7a024639ea97aa991b2d577dad5	17484502	2023-06-15T09:49:47.000Z	0x0cbb2d1c2e588c7682ef516b5d1ef36fd65028a3de12b2d846d9668c2ed30391

Example Query

Query with partition filter

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

EarnVault_InstantWithdraw_event

Instant withdrawal events from Ribbon Finance v2 EarnVaults on Ethereum, capturing immediate fund redemptions with account addresses, withdrawal amounts, and vault round numbers. Used for analyzing user exit patterns and liquidity withdrawal behavior 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_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
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	38	500000000	225	0xc0ff2956bb243500ecbba8e61006189915803e75	17565091	2023-06-26T17:30:47.000Z	0x50bb5ca4be8f056fa87aba7a5eab0bbd12c5ce23518f6461879873b2da172934
0xce5513474e077f5336cf1b33c1347fdd8d48ae8c	false	6	2801930808411083008	220	0x92ba20d7077412773ff8d48cc95d4b12e4b5157b	16366593	2023-01-09T03:36:23.000Z	0x53abb21b807f624befa3f7d37e50d0794caa3af292fbddb79d472359a95d998d
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	14	4000000	241	0x47a41d6c5ecb62e916046267e40007f498e97f93	16367698	2023-01-09T07:18:23.000Z	0xda680bf2329707eaeaa06e0bee6a6e7eb2841c935d1bb002f037b0fa5e036d9c

Example Query

Query with partition filter

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

EarnVault_ManagementFeeSet_event

Management fee configuration change events from Ribbon Finance v2 EarnVault contracts on Ethereum, capturing historical updates to vault management fee parameters for tracking fee structure evolution and governance decisions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_managementFee`	`STRING`	Previous management fee value before the update, stored as a string-encoded integer representing basis points (e.g., ‘200’ = 2%). Sample values show ‘0’ indicating no prior fee was set.
`in_newManagementFee`	`STRING`	Updated management fee value for the vault. String-encoded numeric value representing the fee parameter.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	33	16347546	2023-01-06T11:48:47.000Z	0x67702c8e650993313819efd60d9970bdb3fe3b08ce3000934d09e7b13d759747
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	42	15847226	2022-10-28T14:41:59.000Z	0x1e98cc831b4f9205e2a1e9c465c9b347178c8be8168f9d9a6481e7e0a1b8c5cb
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	15	16304716	2022-12-31T12:22:23.000Z	0xa261f2832a56e0cfbc096dc163ed55f6e871dc455dbb9996ac4cb59949c34cdf

Example Query

Query with partition filter

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

EarnVault_NewAllocationSet_event

Allocation rebalancing events from Ribbon Finance v2 Earn Vaults on Ethereum, tracking shifts between option and loan strategies with basis point allocations. Used for analyzing vault strategy changes and capital deployment patterns across DeFi yield products.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_oldLoanAllocation`	`STRING`	Previous loan allocation setting for the vault, expressed in basis points (1/100th of a percent) where 1,000,000 equals 100%. This value represents the allocation percentage before the rebalancing event occurred, with 0 indicating no prior loan allocation.
`in_oldOptionAllocation`	`STRING`	Previous allocation percentage for options strategy before rebalancing, represented in basis points where 10000 equals 100%.
`in_newLoanAllocation`	`STRING`	Updated allocation percentage for loan-based yield strategies after a rebalancing event. Values are basis points (1/10000), where 1000000 represents 100% allocation to loans versus options.
`in_newOptionAllocation`	`STRING`	New allocation percentage for options strategy in basis points (1/10000ths). Values range from 0 to 1000000 (0% to 100%), indicating the portion of vault funds allocated to options-based yield generation.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newLoanAllocation	in_oldLoanAllocation	in_newOptionAllocation	in_oldOptionAllocation
0xce5513474e077f5336cf1b33c1347fdd8d48ae8c	false	82	16148542	2022-12-09T17:09:47.000Z	0x43e95c7183c3c40bd85725c4d3b1ca4022c27b58b1a1bb89163837bea98e6d49	4222	0	5772	0
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	104	15645787	2022-09-30T11:14:59.000Z	0x6e26ad9ebed9c9db379a877af4e2a3fd558634d14c46a74d2387b85dda2ea7c8	4411	992576	4433	995567
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	220	16096900	2022-12-02T11:43:23.000Z	0x002d0d522f186cbce8a78aec208efd6636c3a0d9e449860a802ff7744253c6c9	541	999459	598	999402

Example Query

Query with partition filter

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

EarnVault_NewLoanTermLength_event

Loan term duration parameter changes for Ribbon Finance v2 Earn Vaults on Ethereum, recording updates from old to new term lengths measured in seconds. Used for tracking vault configuration changes and analyzing lending term adjustments over time.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_oldLoanTermLength`	`STRING`	Previous loan term duration in seconds before the parameter change event. Values like 604800 (7 days) and 2419200 (28 days) represent the prior lending period setting for the Ribbon EarnVault contract.
`in_newLoanTermLength`	`STRING`	Duration in seconds of the new loan term length for the Ribbon Earn Vault. Values typically represent standard periods like 604800 (7 days) or 518400 (6 days).

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newLoanTermLength	in_oldLoanTermLength
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	101	16304676	2022-12-31T12:14:23.000Z	0x120785d7351fca0e76bda43c2ad85284c558f601624e1391d9587ceca311d460	518400	604800
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	134	15823634	2022-10-25T07:34:23.000Z	0x681e015334c13035e1657475972710c24e0d54799f435c969c05ad263116baaa	604800	2419200
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	116	16347322	2023-01-06T11:03:47.000Z	0xaf40b7582c4d5c2861a1c791fee567ba20a6a599ee2eb223d040f1b9726ef4f0	604800	518400

Example Query

Query with partition filter

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

EarnVault_OpenLoan_event

Loan origination events from Ribbon v2 Earn Vaults on Ethereum, capturing when borrowers open positions against vault collateral. Used for tracking lending activity, borrower behavior, and capital utilization within Ribbon’s structured product vaults.

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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_amount	log_index	in_borrower	block_number	block_timestamp	transaction_hash
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	4098193572019	26	0x44c8e19bd59a8ea895fff60dbb4e762028f2fb71	15647186	2022-09-30T15:56:23.000Z	0x93250a999468003366b1175b6cf6131f057f6b2337c7f5377c69cdbb19c7e593
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	4098193572019	24	0xa1614ec01d13e04522ed0b085c7a178ed9e99bc9	15647186	2022-09-30T15:56:23.000Z	0x93250a999468003366b1175b6cf6131f057f6b2337c7f5377c69cdbb19c7e593
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	2481439998943	6	0x44c8e19bd59a8ea895fff60dbb4e762028f2fb71	15459541	2022-09-02T13:55:23.000Z	0x8fd9458b2a335a3b0bdf8b34fc6a81c3db854872710860c63f4e9a9c09bffb82

Example Query

Query with partition filter

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

EarnVault_OptionSellerSet_event

Configuration change events tracking option seller contract updates in Ribbon V2 Earn Vaults on Ethereum. Records old and new seller addresses for analyzing vault strategy modifications and counterparty rotations.

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_oldOptionSeller`	`STRING`	Contract address of the previous option seller being replaced in the Ribbon Earn Vault. Hex-encoded, 0x-prefixed 40-character Ethereum address showing the outgoing seller from vault configuration changes.
`in_newOptionSeller`	`STRING`	Contract address of the newly assigned option seller for the Ribbon EarnVault. Hex-encoded, 0x-prefixed 40-character string representing the contract taking over option selling responsibilities from the previous seller.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newOptionSeller	in_oldOptionSeller
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	306	15696778	2022-10-07T14:19:47.000Z	0x97b6ffd270d9304afdc9595e0bd33616b45ecd6d52726c073fb72f0c6a3b4439	0x5dda427bf7db10fbd09eb98dfe7fb20e29428397	0x015b37a1e5dad6259fd623fbb0137b3cf2b435f3
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	159	15696413	2022-10-07T13:06:23.000Z	0x772de7d95f877d47010ba2c7d5e820a2f20b57b229ea8892b184b455710624c1	0x07b6c7bc3d7dc0f36133b542ea51aa7ac560e974	0x015b37a1e5dad6259fd623fbb0137b3cf2b435f3
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	370	17704580	2023-07-16T08:10:47.000Z	0x069d9f833e0f02461bcdeac463a0fabaf551f81beca5277cd58d169263ab0da4	0x54c39a7fa0d8caa251bad55c7abefa43bc8ba749	0xf12e3d50ee7d2a9b79a4f337b0aa63658a1d3268

Example Query

Query with partition filter

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

EarnVault_OwnershipTransferred_event

Ownership transfer events from Ribbon Finance v2 Earn Vaults on Ethereum, tracking administrative control changes between addresses. Useful for monitoring vault governance transitions and identifying current vault operators.

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_previousOwner`	`STRING`	Address of the prior owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string.
`in_newOwner`	`STRING`	Address of the newly assigned owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_newOwner	block_number	block_timestamp	in_previousOwner	transaction_hash
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	75	0x43a43d3404eac5fa1ec4f4bb0879495d500e390b	15974124	2022-11-15T08:03:59.000Z	0x77da011d5314d80be59e939c2f7ec2f702e1dcc4	0x76c2603efb027a91da3519153cf718e89b5f50178119c80d983054d594fc96e3
0xce5513474e077f5336cf1b33c1347fdd8d48ae8c	false	300	0xf8368119bb1073cf01b841848725d81b542a4c19	16043013	2022-11-24T23:05:59.000Z	0x0000000000000000000000000000000000000000	0x858a88e37cde8d692cf7059bba377072f4698af722da9e8e12fb550c5a139758
0xce5513474e077f5336cf1b33c1347fdd8d48ae8c	false	301	0x77da011d5314d80be59e939c2f7ec2f702e1dcc4	16043013	2022-11-24T23:05:59.000Z	0xf8368119bb1073cf01b841848725d81b542a4c19	0x858a88e37cde8d692cf7059bba377072f4698af722da9e8e12fb550c5a139758

Example Query

Query with partition filter

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

EarnVault_PerformanceFeeSet_event

Performance fee configuration changes for Ribbon Finance V2 earn vaults on Ethereum. Tracks historical adjustments to vault performance fees with old and new basis point values for analyzing 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
0xce5513474e077f5336cf1b33c1347fdd8d48ae8c	false	151	17840413	2023-08-04T08:24:59.000Z	0xba2db750b8a5f7dc8a6a5e58497e822683fc21f512a1ea7b621d63bc9d652046	10000000	0
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	243	16197071	2022-12-16T11:50:35.000Z	0x26a6321e93bc83268c9b6af5f233e8da9c9accbe8f8edcb011cd59821a4117ae	15000000	0
0xce5513474e077f5336cf1b33c1347fdd8d48ae8c	false	264	16196510	2022-12-16T09:57:59.000Z	0x02ffa723b28545101cec1dc911fe8296b561e725b63fbf059be7f09baa9863b2	15000000	10000000

Example Query

Query with partition filter

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

EarnVault_Withdraw_event

Withdrawal events from Ribbon Finance V2 Earn Vaults on Ethereum, recording when users redeem vault shares for underlying assets. Contains account addresses, share amounts burned, and corresponding asset amounts received for tracking vault liquidity 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_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
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	25523625000	25000000000	106	0xfed5b6f65d42af35b87795f5c05da2ac07a8aa4e	16598268	2023-02-10T12:10:23.000Z	0xe9329c1e1fe82c46ea6ccbabf4ecf3463a39c4f59d84688311bf092ab62720ef
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	5572969244	5458638070	242	0x80bb991242318b3657773d5d5110531f6ffac130	16598425	2023-02-10T12:41:47.000Z	0xcc452425e9e78e0d799f4c8e472d1294df0d550696b57db59be5b9aae4856f93
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	168100107025	164651481740	264	0x3d42c40770cf7e8ffb9d46d7b2fab712b0d7cc9b	16600830	2023-02-10T20:45:11.000Z	0xe79225c369bc40d9e723201c820708fb895baa917e27f93f65a2c76fbd51125f

Example Query

Query with partition filter

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

GaugeController_NewGauge_event

Gauge creation events from Ribbon Finance v2 protocol on Ethereum, recording when new liquidity gauges are added to the governance system with their addresses, types, and initial voting weights. Used for tracking gauge deployment history and analyzing governance structure 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_addr`	`STRING`	Contract address referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_gauge_type`	`STRING`	Category identifier for the type of gauge being registered. Numeric string value (commonly ‘0’ or ‘1’) that classifies gauges into different groups for governance voting weight allocation.
`in_weight`	`STRING`	Voting power or gauge weight allocated to a pool or account. Numeric string representation of wei-denominated value.

Sample Data

address	in_addr	removed	in_weight	log_index	block_number	block_timestamp	transaction_hash
0x0cb9cc35cefa5622e8d25af36dd56de142ef6415	0xad4dbd3be46f7bdab82702b581b1d4c5f584741a	false	0	39	16125130	2022-12-06T10:23:23.000Z	0xbf1f06e2b53723a1c357d3107ad069e1e515186718241cf2c9c03cb930faa77c
0x0cb9cc35cefa5622e8d25af36dd56de142ef6415	0xa8a9699161f266f7e79080ca0b65210820be8732	false	4991	843	14285671	2022-02-27T02:55:04.000Z	0x19718279a98362c9e27cef4d03812e8232dc4c0c9828e38c7915873cb9a9396c
0x0cb9cc35cefa5622e8d25af36dd56de142ef6415	0x9038403c3f7c6b5ca361c82448daa48780d7c8bd	false	3337	77	14285673	2022-02-27T02:55:48.000Z	0xd20eeb18302b6a9b34ec247d2c2d7938db28a9624184be67a175916a6e9bec1c

Example Query

Query with partition filter

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

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	0xd41509b051200222df4713dfef3cbe53d0105bc4	false	0xa2761b0539374eb7af2155f76eb09864af075250	2433280597270000000000	24	14442497	2022-03-23T12:18:39.000Z	0xad596c8bf86866bee7713f05086b422626426457c45c95ea3fd8e423f243ba3a
0x5934807cc0654d46755ebd2848840b616256c6ef	0x65a833afdc250d9d38f8cd9bc2b1e3132db13b2f	false	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	14164189286	225	13467124	2021-10-22T11:24:10.000Z	0x468fcf70b22d192dd801362b85919e81244769948e64b4f5ff983fc8056e0d16
0x5934807cc0654d46755ebd2848840b616256c6ef	0x8b5876f5b0bf64056a89aa7e97511644758c3e8c	false	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	25963693823	58	13467115	2021-10-22T11:20:45.000Z	0x930c53566227c14eacfc1d8144be8472a967e7ae95416744289e59f59f8f6aff

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ribbon_v2_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	0xf9ec946c7d7fa6189147eee1c2b7bf418e7eb705	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0	3	13769459	2021-12-09T06:23:47.000Z	0xc5e81eae04f1f04334b2d5b50263d82a958e7402633a878f6713d72b70e4435b
0x5934807cc0654d46755ebd2848840b616256c6ef	0x698c3da9e6d2ee600f4ce56ad5b3673f06ab22f9	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	282798497505694129	208	13768473	2021-12-09T02:31:45.000Z	0xae0f5d5c319b74e873e6af9e46ae44233db335d5bd5cac4ddef485cd53da3443
0x5934807cc0654d46755ebd2848840b616256c6ef	0x987bbee511f854c42d744b729f8a8cf4b844b445	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	62500000	1	15196471	2022-07-23T03:17:58.000Z	0x07818530f0b888a4329d0b0f0e476be8efc80792c21afb987fc8c23a897a3745

Example Query

Query with partition filter

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

Minter_Minted_event

Token minting events from Ribbon Finance v2 liquidity gauges on Ethereum, recording reward token distributions to recipients staking in vault gauges. Used for tracking gauge incentive emissions and staker reward allocations across Ribbon’s structured product vaults.

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_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_gauge`	`STRING`	Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.
`in_minted`	`STRING`	Amount of tokens minted and issued to the user. String-encoded integer value representing the quantity in the smallest unit of the token.

Sample Data

address	removed	in_gauge	in_minted	log_index	block_number	in_recipient	block_timestamp	transaction_hash
0x5b0655f938a72052c46d2e94d206ccb6ff625a3a	false	0xa8a9699161f266f7e79080ca0b65210820be8732	5129623523674000526750	99	15107021	0x6f9bb7e454f5b3eb2310343f0e99269dc2bb8a1d	2022-07-09T07:25:16.000Z	0x3f5a2cde63264c1d4fb0aca0bc1d1730c082dcc4adf65a02f93ba971066df53f
0x5b0655f938a72052c46d2e94d206ccb6ff625a3a	false	0x4e079dca26a4fe2586928c1319b20b1bf9f9be72	7960323869237500593742	107	15107021	0x6f9bb7e454f5b3eb2310343f0e99269dc2bb8a1d	2022-07-09T07:25:16.000Z	0xaecbdb4811034b64ffda51024df47f8d34a236410cffcbe10a7372d163e86ddd
0x5b0655f938a72052c46d2e94d206ccb6ff625a3a	false	0x4e079dca26a4fe2586928c1319b20b1bf9f9be72	118911522188293696422	494	15105953	0x611327a78065a38f151d19ed4876610e5b3fa90f	2022-07-09T03:29:45.000Z	0xdb540b1b341ba3958c101a32cb9d1335e9d01e6b6376ff057530d2f930cfb624

Example Query

Query with partition filter

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

Pool_Provided_event

Liquidity provision events from Ribbon Finance v2 structured products on Ethereum, capturing deposit amounts, vault token shares minted, and provider addresses with optional referral tracking. Used for analyzing vault deposit flows, liquidity provider behavior, and referral program effectiveness across Ribbon’s DeFi options vaults.

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_provider`	`STRING`	Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_referral`	`STRING`	Referral code identifier associated with the transaction. Numeric string representation, often ‘0’ when no referral is present.
`in_currencyAmount`	`STRING`	Amount of currency tokens involved in the transaction. Numeric string representation of the token quantity in its smallest unit.
`in_tokens`	`STRING`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.

Sample Data

address	removed	in_tokens	log_index	in_provider	in_referral	block_number	block_timestamp	transaction_hash	in_currencyAmount
0x0aea75705be8281f4c24c3e954d1f8b1d0f8044c	false	1977189	264	0x47a41d6c5ecb62e916046267e40007f498e97f93	0x47a41d6c5ecb62e916046267e40007f498e97f93	16367717	2023-01-09T07:22:11.000Z	0xd30112b209ea174d33436671649d7384640126bdb85dd36173c925ac38885a66	2000000
0x66a693d0fa5bfe1b5a9eb3932ca87c7ce42cbbdd	false	1302956	364	0x76153d209f2e780721c665f24435d54a14315eaa	0x76153d209f2e780721c665f24435d54a14315eaa	16114428	2022-12-04T22:29:11.000Z	0xeb8e5574d3b3c5c41978f7fe809a0dac7dda7d60cf770ae35b2985153d636fd4	1302956
0x0aea75705be8281f4c24c3e954d1f8b1d0f8044c	false	4946438005	215	0x669950f1da362e4f7e5315f9680140aae1d0fc0b	0x669950f1da362e4f7e5315f9680140aae1d0fc0b	16108541	2022-12-04T02:43:59.000Z	0x8ee706c37d5cef6f4d3263ceb00f8a5c7f41407eb56a48cd004a4af3d694cb5d	5000000000

Example Query

Query with partition filter

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

Pool_Redeemed_event

Redemption events from Ribbon V2 structured product vaults on Ethereum, tracking when users withdraw their vault tokens in exchange for underlying currency. Records redeemer addresses, vault token amounts burned, and corresponding currency received for analyzing vault withdrawal patterns and liquidity flows.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_redeemer`	`STRING`	Address of the account that initiated the redemption transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_currencyAmount`	`STRING`	Amount of currency tokens involved in the transaction. Numeric string representation of the token quantity in its smallest unit.
`in_tokens`	`STRING`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.

Sample Data

address	removed	in_tokens	log_index	in_redeemer	block_number	block_timestamp	transaction_hash	in_currencyAmount
0x0aea75705be8281f4c24c3e954d1f8b1d0f8044c	false	787167652575	222	0x8b4bddaa976996f3ee6dd07851095351e23ab90d	16664848	2023-02-19T19:55:47.000Z	0xdf7fff55271efa42abe390b9a0c3ee74d2d877d5b0c1055ca4d912d43df5b333	796249106027
0x0aea75705be8281f4c24c3e954d1f8b1d0f8044c	false	2498200939	281	0x255f4fe4822fe7f1ed1952c7c97dbb78be4410a0	16662898	2023-02-19T13:21:11.000Z	0x0204f2f825b6f8766a1f6bd9d6e1a24cdf0ffb405f86d509c07ec1f610e8a170	2527022364
0x0aea75705be8281f4c24c3e954d1f8b1d0f8044c	false	4999937326	70	0xd36c04f6dc8eb30708cd53527871d82080413c30	15681749	2022-10-05T11:57:59.000Z	0x046664c415813b0d67c71c4cba297c61b11dc6fe38912c473cd3151ab226fb09	5000000846

Example Query

Query with partition filter

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

Pool_RewardWithdrawn_event

Reward withdrawal events from Ribbon V2 liquidity pools on Ethereum, capturing when users claim accrued yield with withdrawal amounts and recipient addresses. Used for tracking reward distribution patterns and user claiming behavior across Ribbon’s structured product vaults.

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.

Sample Data

address	removed	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
0x0aea75705be8281f4c24c3e954d1f8b1d0f8044c	false	3132955363354419309298	297	0x3ec7968d1622d6950db90f7b023477a4f94bcc63	16434549	2023-01-18T15:20:47.000Z	0xc9e6995908da948eb7742a6b9441d4d1e1f01f0ef1d114375662b58f10f055ba
0x0aea75705be8281f4c24c3e954d1f8b1d0f8044c	false	1170385958971757908856	122	0xaebb8fdbd5e52f99630cebb80d0a1c19892eb4c2	16431559	2023-01-18T05:20:23.000Z	0xea0280767788ad2ddb66232528c67c56b392704f159c96b33b069ac3e5f4a039
0x3cd0ecf1552d135b8da61c7f44cefe93485c616d	false	11035478943401898380	386	0xbc20ddb5fcc8920e0f74fcb29b4981d802fef881	16434701	2023-01-18T15:51:23.000Z	0x29f1cc4afce3f399b01a5f3f307a2fb4f17f533beb129afd6fac960ee73041d5

Example Query

Query with partition filter

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

PoolFactory_PoolCreated_event

Pool creation events emitted by factory contracts when new liquidity pools are deployed. Records the pool address, token pair or configuration parameters, and fee structure for tracking pool deployments across decentralized exchange 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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_manager`	`STRING`	Address of the account authorized to manage the pool, vault, or fund. Hex-encoded, 0x-prefixed, 42-character string.
`in_currency`	`STRING`	Contract address of the currency token used in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	in_manager	in_currency	block_number	block_timestamp	transaction_hash
0x312853485a41f76f20a14f927cd0ea676588936c	0x44cbd2f4566beb7d75c1ec2f334f74adbd58ee10	false	210	0x76153d209f2e780721c665f24435d54a14315eaa	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	15607529	2022-09-25T02:54:23.000Z	0xd7ee93ac0ffee622a858c2d565b8fda487ca3291510a3f3e6dcb5f0277337ba4
0x312853485a41f76f20a14f927cd0ea676588936c	0x66a693d0fa5bfe1b5a9eb3932ca87c7ce42cbbdd	false	375	0x54dda22ae140edb605c73073eabb6f4aea2fc237	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	15922191	2022-11-08T02:01:23.000Z	0x4dac874e49f173940190d326452f6c6c883cc08bccbcd6add0c040b92d2418bd
0x312853485a41f76f20a14f927cd0ea676588936c	0x559548340350d4211e637b242da25549337a61df	false	379	0x07b6c7bc3d7dc0f36133b542ea51aa7ac560e974	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	15922191	2022-11-08T02:01:23.000Z	0x4dac874e49f173940190d326452f6c6c883cc08bccbcd6add0c040b92d2418bd

Example Query

Query with partition filter

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

RibbonThetaSTETHVaultV1_PerformanceFeeSet_event

No description available.

Columns

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

No sample data available.

Example Query

Query with partition filter

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

RibbonThetaSTETHVaultV2_PerformanceFeeSet_event

No description available.

Columns

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

No sample data available.

Example Query

Query with partition filter

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

RibbonThetaVaultWithSwapV2_PerformanceFeeSet_event

Performance fee parameter changes for Ribbon V2 theta vaults on Ethereum, capturing old and new fee values when vault administrators adjust fee structures. Useful for tracking vault fee policy changes and analyzing fee evolution across Ribbon’s options-selling vaults.

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
0xe63151a0ed4e5fafdc951d877102cf0977abd365	false	221	13745093	2021-12-05T08:44:31.000Z	0xdb7331c614ea1409b166195839ed52e855d61c6ff550de21025e66d2a080a216	10000000	0
0x65a833afdc250d9d38f8cd9bc2b1e3132db13b2f	false	136	13220035	2021-09-13T22:15:23.000Z	0x90f5495fac8ff4ae587baf8eae79c6576d5fef35a4b5a9cf73da6e99e47a4a08	0	10000000
0x25751853eab4d0eb3652b5eb6ecb102a2789644b	false	26	13220022	2021-09-13T22:12:54.000Z	0x2d08fa032fffef33aca62e36fd2e2ed8bbcd7104a9a122a1a0c9d317e974b3d6	0	10000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ribbon_v2_ethereum.RibbonThetaVaultWithSwapV2_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
0xeb8cab2f4663247db8eafb556f498c861bb4e161	false	413678291	50	38	0xcf12070dd7a51304f8abdc3916998262c26890ca	15458564	10428712	2022-09-02T10:14:59.000Z	36273781338	83429697	0x6b3e1b53507068abbef692f299725ec85fcddc83	0xada61191171ffa2246fd4ef30e42e110a74cc593ee4a2815dfbcec7aed58918a
0xeb8cab2f4663247db8eafb556f498c861bb4e161	false	195926007	52	15	0xcf12070dd7a51304f8abdc3916998262c26890ca	15458641	323363805040000000	2022-09-02T10:34:18.000Z	80840951260	3152797099140000000	0xc38714cb982939ac28cc174346edd9a81da4ad89	0xc97be85a421870eba8982a2ff2520223e2e4fa6cdf34dbf47596e49b802597ca
0xeb8cab2f4663247db8eafb556f498c861bb4e161	false	611570882	54	163	0xcf12070dd7a51304f8abdc3916998262c26890ca	15458703	1957200000000000000	2022-09-02T10:49:12.000Z	489300000000	22507800000000000000	0x3ec3d447b918594eacd88f81e30978682a5d31a4	0x7e30262ccfa1069b20681798dc90fcfd4aa7e458a6e2a16baeb3abc217c17511

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ribbon_v2_ethereum.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 protocol on Ethereum, capturing peer-to-peer token exchanges with signer/seller amounts, nonces, and referrer addresses. Used for analyzing structured product option settlement flows and counter-party trading 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_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	602497126	5	3	0xcf12070dd7a51304f8abdc3916998262c26890ca	14896901	2022-06-03T11:39:41.000Z	56080661887	229930713	0xce04f810442757d671a40d187929e6a154fe0788	0x968acadc064d0c0477312120d5de834b7794938efb881b8a16a7daf16957ab85
0xf0e5c92cedd66c7985c354c35e2bc37e685b99da	false	188843724	2	144	0xcf12070dd7a51304f8abdc3916998262c26890ca	14804976	2022-05-19T12:32:56.000Z	2000000	200	0x422f7bb366608723c8fe61ac6d923023dccbc3d7	0xbbca5d8915053b1aa0a0a86516431d5c123997bb8f4310ffb7da186f025d3f92
0xf0e5c92cedd66c7985c354c35e2bc37e685b99da	false	150901346	1	71	0xcf12070dd7a51304f8abdc3916998262c26890ca	14805645	2022-05-19T15:12:52.000Z	32000000	3200	0x422f7bb366608723c8fe61ac6d923023dccbc3d7	0x458139356e6f72c6288f5ba93594ff9d21d9684ac7011f94c8db92cdc8d5bcb1

Example Query

Query with partition filter

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

ThetaVault_CollectVaultFees_event

Fee collection events from Ribbon Finance v2 ThetaVault options strategy vaults on Ethereum. Records vault management fees and performance fees extracted per round, useful for analyzing protocol revenue 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_vaultFee`	`STRING`	Management fee collected from the vault for the specified round, denominated in the vault’s base asset with decimals (typically 18 for ERC-20 tokens). This fee is separate from performance fees and is transferred to the fee recipient address.
`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
0xe63151a0ed4e5fafdc951d877102cf0977abd365	false	24	2	4407735570041155419	14589411	2022-04-15T10:29:30.000Z	0xdaeada3d210d2f45874724beea03c7d4bbd41674	0x3647c8cdeb47225c21bbf994b3556ea2adb1295e767847f13c1488422677678f	2245600000000000000
0xc0cf10dd710aefb209d9dc67bc746510ffd98a53	false	5	25	63240533208087275886	14589727	2022-04-15T11:39:21.000Z	0xdaeada3d210d2f45874724beea03c7d4bbd41674	0x0ddde7f55d737901c3904dbf1ffeb76c5439f9d8a9765635507a6fbb50148d29	34748980000000000000
0xcc323557c71c0d1d20a1861dc69c06c5f3cc9624	false	18	7	79285691428	14589540	2022-04-15T10:59:34.000Z	0xdaeada3d210d2f45874724beea03c7d4bbd41674	0x21fd589e85e49c406b59124950e2ad904129e15913e8561acf8318130dfca827	35777517665

Example Query

Query with partition filter

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

ThetaVault_Deposit_event

Deposit events from Ribbon Finance V2 ThetaVault options strategy vaults on Ethereum, tracking user deposits by account, amount, and vault round. Used for analyzing capital inflows and vault participation patterns across weekly options 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
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	13	30000000000	167	0x2d77dce83ae7bbd52f0800d617539db4bfc3e97b	16341419	2023-01-05T15:14:59.000Z	0xce1a257de311d37a4c8489d427bed317d526ebb74b8ff3bae2f2cffda66d985c
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	13	24947624	51	0xd2303d59f01006cabda3fa6b9323e8754673a4e9	16339458	2023-01-05T08:40:23.000Z	0xcc45f29be97fb45f1ade7651a3892167f111220906e864ea2e5502a9b0acf906
0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0	false	13	12473814	63	0x9028b66b7ded9a8ba4d3e177aa8381409d7f7614	16339422	2023-01-05T08:33:11.000Z	0x237164cedce0baaae4b0630f37f7b4d7e596b980b4960967c8b5cc8b1791b2e7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ribbon_v2_ethereum.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 theta vaults on Ethereum, capturing user accounts, withdrawal amounts, and vault round numbers when users exit positions without waiting for the weekly cycle. Used for tracking immediate liquidity demands and vault flow analysis across different option-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_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
0x25751853eab4d0eb3652b5eb6ecb102a2789644b	false	50	976432395422214209	137	0x70b1bcb7244fedcaea2c36dc939da3a6f86af793	15342703	2022-08-14T23:41:28.000Z	0x659d242eab1e279ad63e79fac13ba5f7998660e8758cf703858f6f241cc94e48
0xa1da0580fa96129e753d736a5901c31df5ec5edf	false	15	6542605785009941464	207	0x270f7c71e6f56f481baaef9ad149feb9d6624d51	15578890	2022-09-21T02:34:35.000Z	0x9eb080ee6c3e1995828db4f6746e51713e7e0c58e8123b57dafbee6bc5de999f
0xe63151a0ed4e5fafdc951d877102cf0977abd365	false	47	100000000000000000	117	0x33d84d2a77d850b13053a1496d25cc58b145aa13	15580828	2022-09-21T09:18:35.000Z	0x1b27684ca45208466ae0af3eeebfb278dbe8fb630899b11a0002248620cf04c6

Example Query

Query with partition filter

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

ThetaVault_OpenShort_event

Option short position opening events from Ribbon Finance V2 theta vaults on Ethereum, recording manager-initiated options sales with deposit amounts and option contract addresses. Used for tracking vault strategy execution and covered call/put option writing 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_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
0x25751853eab4d0eb3652b5eb6ecb102a2789644b	false	14	0x55e4b3e3226444cd4de09778844453ba9fe9cd7c	0x813931d2a3d4672a2021e9f2136971b6d4e31cec	14274796	2022-02-25T10:50:42.000Z	10494692904166257800723	0x299777de08d5b20c2b8d28e14d4c3fd973810f166b3338c3626899cb09a22e40
0x65a833afdc250d9d38f8cd9bc2b1e3132db13b2f	false	37	0x55e4b3e3226444cd4de09778844453ba9fe9cd7c	0x80312f5e705ce442e651b355db6d7b53a6b2b4e8	14274669	2022-02-25T10:20:04.000Z	30565136144	0x7770243b5ee84ead9d4a7afded686ea24d52844dfc26f9b860011c14e4c6ec20
0x53773e034d9784153471813dacaff53dbbb78e8c	false	10	0x55e4b3e3226444cd4de09778844453ba9fe9cd7c	0xafe51ff14ae7079d520a8649aeed483c0ba2534f	14274760	2022-02-25T10:40:29.000Z	6687199317723676286148	0xd0288c639f2576b200385986224c8c2618077a3b407367ef7af812bfec6a1ea9

Example Query

Query with partition filter

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

ThetaVault_Withdraw_event

Withdrawal events from Ribbon Finance v2 Theta Vaults on Ethereum, recording when users redeem vault shares for underlying assets. Tracks account addresses, share amounts burned, and corresponding asset amounts received for analyzing vault liquidity and redemption 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
0x25751853eab4d0eb3652b5eb6ecb102a2789644b	false	12274075316833165692	11092586175890481224	178	0x144e8fe2e2052b7b6556790a06f001b56ba033b3	14795432	2022-05-17T23:33:39.000Z	0x3cc2b8693da2b0fb7d70951215bbe53d6f49e367dbfc965304f97b280af22d28
0xcc323557c71c0d1d20a1861dc69c06c5f3cc9624	false	66995740062	77943895514	287	0x8c77466881fce81229bdee4993e71781531604d2	14794365	2022-05-17T19:22:10.000Z	0x0c14e17d3e0aacd2301596f38ba8a063876138f9d78c1237109d4dab9356117f
0x65a833afdc250d9d38f8cd9bc2b1e3132db13b2f	false	48694741	44589142	382	0x43bb3e05474fe770a0c885f3b7954837740c27bd	16391889	2023-01-12T16:23:11.000Z	0x5070cfa4eea137aa0af6b2fb3833fd685a056cf700a89ddf4979ed7deb6c5d46

Example Query

Query with partition filter

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

TreasuryVault_CollectManagementFee_event

Management fee collection events from Ribbon Finance v2 treasury vaults on Ethereum, capturing fee amounts, recipient addresses, and round identifiers. Useful for tracking protocol revenue distribution and vault management economics 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_managementFee`	`STRING`	Management fee amount collected by the protocol during this vault round, denominated in the vault’s base token. Value is zero in sample data, indicating potential fee waivers or zero-fee periods for Ribbon V2 vaults.
`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	block_number	block_timestamp	in_feeRecipient	transaction_hash
0xe44edf7ad1d434afe3397687dd0a914674f2e405	false	13	249	16768845	2023-03-06T10:54:11.000Z	0xdaeada3d210d2f45874724beea03c7d4bbd41674	0x825e7fa304efb6a6657dae85643f7f9c2536527f81f1716dc0d07f747e1ef034
0x42cf874bbe5564efcf252bc90829551f4ec639dc	false	9	254	16768643	2023-03-06T10:12:47.000Z	0xdaeada3d210d2f45874724beea03c7d4bbd41674	0x1ecc8362cd33e819d7fa693639904ac83603d1943ec65017ea87f8b87bd5b632
0xe44edf7ad1d434afe3397687dd0a914674f2e405	false	1	189	14159207	2022-02-07T13:32:00.000Z	0xdaeada3d210d2f45874724beea03c7d4bbd41674	0x8f6f087f710ff2d6f9ceb62502db2d94a2595b585bcb12144b6851af426219f0

Example Query

Query with partition filter

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

TreasuryVault_CollectPerformanceFee_event

Performance fee collection events from Ribbon Finance v2 treasury vaults on Ethereum. Records vault addresses, fee amounts, recipients, and round numbers for analyzing protocol revenue and fee distribution 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_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_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	block_number	block_timestamp	in_feeRecipient	transaction_hash	in_performanceFee
0x42cf874bbe5564efcf252bc90829551f4ec639dc	false	1	92	15327940	2022-08-12T16:08:14.000Z	0xdaeada3d210d2f45874724beea03c7d4bbd41674	0x5e9ad2baafa2db8565df202ca4d67c95fd5ef287914df3700ec7bd52e9a90633	270135000
0x2a6b048eb15c7d4ddca27db4f9a454196898a0fe	false	5	93	15848304	2022-10-28T18:18:47.000Z	0xdaeada3d210d2f45874724beea03c7d4bbd41674	0xae2cae6d232cd3075069ea51eab1d4671ea58bc62b5742455dcf77a34dafdd49	2175534566
0xe44edf7ad1d434afe3397687dd0a914674f2e405	false	10	285	15848307	2022-10-28T18:19:23.000Z	0xdaeada3d210d2f45874724beea03c7d4bbd41674	0x3daf73a42c25411b47dc9504483d143b939aec47baf3108fee0db8980b98a234	323611488

Example Query

Query with partition filter

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

TreasuryVault_Deposit_event

Deposit events from Ribbon Finance v2 treasury vaults on Ethereum tracking user contributions by round, account address, and deposited amounts. Used for analyzing capital inflows, vault participation patterns, and round-based deposit 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_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
0xe44edf7ad1d434afe3397687dd0a914674f2e405	false	4	40000000000000000000000	665	0x8a88dfcc83c2999a81634899f55512a88d0d84b2	14677741	2022-04-29T06:54:15.000Z	0x9410bfeeafc3d2d3783ee5042e95b57a8496306f869bee5eb05bece7336ede06
0x2a6b048eb15c7d4ddca27db4f9a454196898a0fe	false	1	110000000000000000000	486	0xd340c943ae137ea0bab682a286d1af65e4e39a6b	15082427	2022-07-05T12:10:07.000Z	0xb165b511ef8b1f8e05f9d1785c7520d58bf028ca5b00b13d6b267a075e0eecc8
0x2a6b048eb15c7d4ddca27db4f9a454196898a0fe	false	1	110000000000000000000	472	0xd340c943ae137ea0bab682a286d1af65e4e39a6b	15082564	2022-07-05T12:38:12.000Z	0xf390cbbb3f01135550ba49a0e7f605fd741edfde6fbaa9991c7cc6edbc8aef65

Example Query

Query with partition filter

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

TreasuryVault_DistributePremium_event

Premium distribution events from Ribbon Finance V2 treasury vaults on Ethereum, recording option premium allocations to multiple recipients per round. Used for tracking vault revenue sharing and stakeholder payout splits across vault operating rounds.

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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_amounts`	`ARRAY<STRING>`	Array of token amounts involved in the operation. String-encoded integers representing amounts in the token’s smallest unit (e.g., wei for ETH).
`in_recipients`	`ARRAY<STRING>`	Array of recipient addresses for fee distribution. Hex-encoded, 0x-prefixed, 42-character strings.
`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_amounts	block_number	in_recipients	block_timestamp	transaction_hash
0x2a6b048eb15c7d4ddca27db4f9a454196898a0fe	false	13	6225920061	236	[“3422373”,“6222497687”]	17619523	[“0xd340c943ae137ea0bab682a286d1af65e4e39a6b”,“0x10a19e7ee7d7f8a52822f6817de8ea18204f2e4f”]	2023-07-04T08:59:11.000Z	0x38680351fd3f05fca0bde823f6a11db20eee6ed1e8354fa555972b12f44827fc
0xe44edf7ad1d434afe3397687dd0a914674f2e405	false	4	47137815059	164	[“43695000”,“34912305001”,“43775763”,“6807249293”,“1310850000”,“524340000”,“3495600000”]	14708240	[“0x422f7bb366608723c8fe61ac6d923023dccbc3d7”,“0xf715be9bdd45d09893ab927aca039de1feed5d59”,“0xee0be8149583d174594614c01d3e984e7439ae86”,“0x4ffef86586e730bd8e848708124c105d8f01ba7d”,“0x26e547a9f3fd90e49a9a85a91001ca3f7ba2c81d”,“0x4d0f1f17d3f8db1697ac186621b582b7e62e99f5”,“0x8a88dfcc83c2999a81634899f55512a88d0d84b2”]	2022-05-04T02:11:04.000Z	0x5294968e32fd52d65a7850b636a863d5e1c9e3216f095a5eed62303f7e6755a7
0xe44edf7ad1d434afe3397687dd0a914674f2e405	false	3	738189407	149	[“739082”,“590526711”,“740448”,“115141711”,“22172467”,“8868986”,“0”]	14679055	[“0x422f7bb366608723c8fe61ac6d923023dccbc3d7”,“0xf715be9bdd45d09893ab927aca039de1feed5d59”,“0xee0be8149583d174594614c01d3e984e7439ae86”,“0x4ffef86586e730bd8e848708124c105d8f01ba7d”,“0x26e547a9f3fd90e49a9a85a91001ca3f7ba2c81d”,“0x4d0f1f17d3f8db1697ac186621b582b7e62e99f5”,“0x8a88dfcc83c2999a81634899f55512a88d0d84b2”]	2022-04-29T11:59:23.000Z	0xe81609a83ef6fa788264f71021334b33939b0cd8fd2a0bc216340c701dd638fb

Example Query

Query with partition filter

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

TreasuryVault_InstantWithdraw_event

Instant withdrawal events from Ribbon Finance v2 treasury vaults on Ethereum, capturing immediate user redemptions with account addresses, withdrawal amounts in wei, and vault round identifiers. Used for tracking liquidity withdrawals and user exit behavior across Ribbon’s DeFi options 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_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
0xe44edf7ad1d434afe3397687dd0a914674f2e405	false	1	500000000000000000408	116	0x422f7bb366608723c8fe61ac6d923023dccbc3d7	14126335	2022-02-02T11:21:40.000Z	0xd6e07d10b38d8b2548814ce337a00c070fa7a4502402cf4bd23daed2c1f9040b
0x270f4a26a3fe5766ccef9608718491bb057be238	false	1	100000000000000000000	109	0xd340c943ae137ea0bab682a286d1af65e4e39a6b	15093951	2022-07-07T07:01:42.000Z	0xa6cf3ff5d63dadba3d923586b2c6b800a76d35e4169c1d18265053a7b178077e
0xe44edf7ad1d434afe3397687dd0a914674f2e405	false	4	40000000000000000000000	152	0x8a88dfcc83c2999a81634899f55512a88d0d84b2	14675610	2022-04-28T22:58:42.000Z	0xb0811598255e4959c1ae7d3e9e6a0eb01360d83c82762224c0bef52948d80621

Example Query

Query with partition filter

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

TreasuryVault_PerformanceFeeSet_event

No description available.

Columns

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

No sample data available.

Example Query

Query with partition filter

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

TreasuryVault_Withdraw_event

Withdrawal events from Ribbon Finance V2 treasury vaults on Ethereum, tracking user redemptions with share amounts burned and underlying tokens received. Used for analyzing vault outflows, redemption patterns, and calculating time-weighted vault participation.

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
0xe44edf7ad1d434afe3397687dd0a914674f2e405	false	15000000000000000000000	15000000000000000000000	74	0x26e547a9f3fd90e49a9a85a91001ca3f7ba2c81d	14854735	2022-05-27T14:50:28.000Z	0x1186d5bc63addfad2205c4a908a309b2d47d3c945ea54afe2df9329ee6256b80
0xe44edf7ad1d434afe3397687dd0a914674f2e405	false	7996000000000000000000	7996000000000000000000	80	0x8a88dfcc83c2999a81634899f55512a88d0d84b2	14459705	2022-03-26T04:28:33.000Z	0x991a778fa1c32c47d266418c4a4c87e45fea58fd1a2058ee6596cb6a9cada4a3
0xe44edf7ad1d434afe3397687dd0a914674f2e405	false	199500000000000000000000	199500000000000000000000	156	0xf715be9bdd45d09893ab927aca039de1feed5d59	15736727	2022-10-13T04:12:11.000Z	0x6dfc7702303a377d45090a974e5c2af1536c5138ab5f2b7cc73ba1d2a109feea

Example Query

Query with partition filter

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

TreasuryVaultPERP_PerformanceFeeSet_event

No description available.

Columns

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

No sample data available.

Example Query

Query with partition filter

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

TreasuryVaultSPELL_PerformanceFeeSet_event

No description available.

Columns

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

No sample data available.

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

​Tables

​EarnVault_Approval_event

​EarnVault_BorrowerBasketUpdated_event

​EarnVault_CapSet_event

​EarnVault_CloseLoan_event

​EarnVault_CollectVaultFees_event

​EarnVault_CommitBorrowerBasket_event

​EarnVault_Deposit_event

​EarnVault_InitiateWithdraw_event

​EarnVault_InstantWithdraw_event

​EarnVault_ManagementFeeSet_event

​EarnVault_NewAllocationSet_event

​EarnVault_NewLoanTermLength_event

​EarnVault_OpenLoan_event

​EarnVault_OptionSellerSet_event

​EarnVault_OwnershipTransferred_event

​EarnVault_PerformanceFeeSet_event

​EarnVault_Withdraw_event

​GaugeController_NewGauge_event

​MarginPool_TransferToPool_event

​MarginPool_TransferToUser_event

​Minter_Minted_event

​Pool_Provided_event

​Pool_Redeemed_event

​Pool_RewardWithdrawn_event

​PoolFactory_PoolCreated_event

​RibbonThetaSTETHVaultV1_PerformanceFeeSet_event

​RibbonThetaSTETHVaultV2_PerformanceFeeSet_event

​RibbonThetaVaultWithSwapV2_PerformanceFeeSet_event

​Swap_Swap_event

​SwapV1_Swap_event

​ThetaVault_CollectVaultFees_event

​ThetaVault_Deposit_event

​ThetaVault_InstantWithdraw_event

​ThetaVault_OpenShort_event

​ThetaVault_Withdraw_event

​TreasuryVault_CollectManagementFee_event

​TreasuryVault_CollectPerformanceFee_event

​TreasuryVault_Deposit_event

​TreasuryVault_DistributePremium_event

​TreasuryVault_InstantWithdraw_event

​TreasuryVault_PerformanceFeeSet_event

​TreasuryVault_Withdraw_event

​TreasuryVaultPERP_PerformanceFeeSet_event

​TreasuryVaultSPELL_PerformanceFeeSet_event

Tables

EarnVault_Approval_event

EarnVault_BorrowerBasketUpdated_event

EarnVault_CapSet_event

EarnVault_CloseLoan_event

EarnVault_CollectVaultFees_event

EarnVault_CommitBorrowerBasket_event

EarnVault_Deposit_event

EarnVault_InitiateWithdraw_event

EarnVault_InstantWithdraw_event

EarnVault_ManagementFeeSet_event

EarnVault_NewAllocationSet_event

EarnVault_NewLoanTermLength_event

EarnVault_OpenLoan_event

EarnVault_OptionSellerSet_event

EarnVault_OwnershipTransferred_event

EarnVault_PerformanceFeeSet_event

EarnVault_Withdraw_event

GaugeController_NewGauge_event

MarginPool_TransferToPool_event

MarginPool_TransferToUser_event

Minter_Minted_event

Pool_Provided_event

Pool_Redeemed_event

Pool_RewardWithdrawn_event

PoolFactory_PoolCreated_event

RibbonThetaSTETHVaultV1_PerformanceFeeSet_event

RibbonThetaSTETHVaultV2_PerformanceFeeSet_event

RibbonThetaVaultWithSwapV2_PerformanceFeeSet_event

Swap_Swap_event

SwapV1_Swap_event

ThetaVault_CollectVaultFees_event

ThetaVault_Deposit_event

ThetaVault_InstantWithdraw_event

ThetaVault_OpenShort_event

ThetaVault_Withdraw_event

TreasuryVault_CollectManagementFee_event

TreasuryVault_CollectPerformanceFee_event

TreasuryVault_Deposit_event

TreasuryVault_DistributePremium_event

TreasuryVault_InstantWithdraw_event

TreasuryVault_PerformanceFeeSet_event

TreasuryVault_Withdraw_event

TreasuryVaultPERP_PerformanceFeeSet_event

TreasuryVaultSPELL_PerformanceFeeSet_event