> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# ribbon_v2_ethereum
> Tables in tt-contracts.ribbon_v2_ethereum
## 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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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` | 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` | 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. |
| 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 | \[] |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| address | removed | log\_index | block\_number | block\_timestamp | in\_managementFee | transaction\_hash | in\_newManagementFee |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ----------------- | ------------------------------------------------------------------ | -------------------- |
| 0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0 | false | 33 | 16347546 | 2023-01-06T11:48:47.000Z | 0 | 0x67702c8e650993313819efd60d9970bdb3fe3b08ce3000934d09e7b13d759747 | 0 |
| 0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0 | false | 42 | 15847226 | 2022-10-28T14:41:59.000Z | 0 | 0x1e98cc831b4f9205e2a1e9c465c9b347178c8be8168f9d9a6481e7e0a1b8c5cb | 0 |
| 0x84c2b16fa6877a8ff4f3271db7ea837233dfd6f0 | false | 15 | 16304716 | 2022-12-31T12:22:23.000Z | 0 | 0xa261f2832a56e0cfbc096dc163ed55f6e871dc455dbb9996ac4cb59949c34cdf | 0 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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). |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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%). |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| address | in\_addr | removed | in\_weight | log\_index | block\_number | in\_gauge\_type | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ---------- | ------------- | --------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x0cb9cc35cefa5622e8d25af36dd56de142ef6415 | 0xad4dbd3be46f7bdab82702b581b1d4c5f584741a | false | 0 | 39 | 16125130 | 0 | 2022-12-06T10:23:23.000Z | 0xbf1f06e2b53723a1c357d3107ad069e1e515186718241cf2c9c03cb930faa77c |
| 0x0cb9cc35cefa5622e8d25af36dd56de142ef6415 | 0xa8a9699161f266f7e79080ca0b65210820be8732 | false | 4991 | 843 | 14285671 | 0 | 2022-02-27T02:55:04.000Z | 0x19718279a98362c9e27cef4d03812e8232dc4c0c9828e38c7915873cb9a9396c |
| 0x0cb9cc35cefa5622e8d25af36dd56de142ef6415 | 0x9038403c3f7c6b5ca361c82448daa48780d7c8bd | false | 3337 | 77 | 14285673 | 0 | 2022-02-27T02:55:48.000Z | 0xd20eeb18302b6a9b34ec247d2c2d7938db28a9624184be67a175916a6e9bec1c |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.*
| 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%). |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.*
| 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%). |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.
| 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%). |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| address | removed | in\_nonce | in\_swapId | log\_index | in\_referrer | block\_number | in\_feeAmount | block\_timestamp | in\_sellerAmount | in\_signerAmount | in\_signerWallet | transaction\_hash |
| ------------------------------------------ | ------- | --------- | ---------- | ---------- | ------------------------------------------ | ------------- | ------------- | ------------------------ | ---------------- | ---------------- | ------------------------------------------ | ------------------------------------------------------------------ |
| 0xf0e5c92cedd66c7985c354c35e2bc37e685b99da | false | 602497126 | 5 | 3 | 0xcf12070dd7a51304f8abdc3916998262c26890ca | 14896901 | 0 | 2022-06-03T11:39:41.000Z | 56080661887 | 229930713 | 0xce04f810442757d671a40d187929e6a154fe0788 | 0x968acadc064d0c0477312120d5de834b7794938efb881b8a16a7daf16957ab85 |
| 0xf0e5c92cedd66c7985c354c35e2bc37e685b99da | false | 188843724 | 2 | 144 | 0xcf12070dd7a51304f8abdc3916998262c26890ca | 14804976 | 0 | 2022-05-19T12:32:56.000Z | 2000000 | 200 | 0x422f7bb366608723c8fe61ac6d923023dccbc3d7 | 0xbbca5d8915053b1aa0a0a86516431d5c123997bb8f4310ffb7da186f025d3f92 |
| 0xf0e5c92cedd66c7985c354c35e2bc37e685b99da | false | 150901346 | 1 | 71 | 0xcf12070dd7a51304f8abdc3916998262c26890ca | 14805645 | 0 | 2022-05-19T15:12:52.000Z | 32000000 | 3200 | 0x422f7bb366608723c8fe61ac6d923023dccbc3d7 | 0x458139356e6f72c6288f5ba93594ff9d21d9684ac7011f94c8db92cdc8d5bcb1 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| address | removed | in\_round | log\_index | block\_number | block\_timestamp | in\_feeRecipient | in\_managementFee | transaction\_hash |
| ------------------------------------------ | ------- | --------- | ---------- | ------------- | ------------------------ | ------------------------------------------ | ----------------- | ------------------------------------------------------------------ |
| 0xe44edf7ad1d434afe3397687dd0a914674f2e405 | false | 13 | 249 | 16768845 | 2023-03-06T10:54:11.000Z | 0xdaeada3d210d2f45874724beea03c7d4bbd41674 | 0 | 0x825e7fa304efb6a6657dae85643f7f9c2536527f81f1716dc0d07f747e1ef034 |
| 0x42cf874bbe5564efcf252bc90829551f4ec639dc | false | 9 | 254 | 16768643 | 2023-03-06T10:12:47.000Z | 0xdaeada3d210d2f45874724beea03c7d4bbd41674 | 0 | 0x1ecc8362cd33e819d7fa693639904ac83603d1943ec65017ea87f8b87bd5b632 |
| 0xe44edf7ad1d434afe3397687dd0a914674f2e405 | false | 1 | 189 | 14159207 | 2022-02-07T13:32:00.000Z | 0xdaeada3d210d2f45874724beea03c7d4bbd41674 | 0 | 0x8f6f087f710ff2d6f9ceb62502db2d94a2595b585bcb12144b6851af426219f0 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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` | 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` | 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.*
| 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%). |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.*
| 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%). |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.*
| 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%). |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.ribbon_v2_ethereum.TreasuryVaultSPELL_PerformanceFeeSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***