> ## 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.
# origin_v1_ethereum
> Tables in tt-contracts.origin_v1_ethereum
## Tables
### Flipper\_buyOusdWithDai\_function
DAI-to-OUSD swap transactions through Origin Protocol's Flipper contract on Ethereum, recording input amounts and execution status. Used for analyzing OUSD minting activity and stablecoin conversion 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| gas | value | status | gas\_used | in\_amount | signature | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | transaction\_hash |
| ------- | ----- | ------ | --------- | ---------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 2561866 | 0 | true | 66968 | 3550335464330122756096 | 0x5981c746 | 0xcecad69d7d4ed6d52efcfa028af8732f27e08f70 | 21351925 | 0x2593154f192f46f65a4a0315a5d77556d5d3d264 | 0,3,3 | 2024-12-07T16:52:23.000Z | 0x24d37ec8a82f7bc180698ca536717065ead954a93c774a2bc4d3cfae4eea7da5 |
| 93451 | 0 | false | 29314 | | 0x5981c746 | 0xcecad69d7d4ed6d52efcfa028af8732f27e08f70 | 13197738 | 0x8e09f821a8cb0af0cb95fbe1324ff1ca81fc660f | | 2021-09-10T11:28:12.000Z | 0xfd2a4c2d532dd8068dd73da3b30184f2aec906a241a15c3b1e2d851f78b93ceb |
| 93451 | 0 | true | 92165 | 1020980826000000000000 | 0x5981c746 | 0xcecad69d7d4ed6d52efcfa028af8732f27e08f70 | 13197735 | 0x8e09f821a8cb0af0cb95fbe1324ff1ca81fc660f | | 2021-09-10T11:27:55.000Z | 0x9f14df573a75ccb3757bc105f851b0b9a4d758c284624abb95d1b84e83e57e5b |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.Flipper_buyOusdWithDai_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Flipper\_buyOusdWithUsdc\_function
USDC to OUSD (Origin Dollar) swap transactions executed through the Flipper contract on Ethereum. Tracks individual purchases of OUSD stablecoin with input amounts, transaction status, and gas costs for analyzing trading volume and user adoption.
| Column | Type | Description |
| ------------------ | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| gas | value | status | gas\_used | in\_amount | signature | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | transaction\_hash |
| ------ | ----- | ------ | --------- | ---------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 110520 | 0 | true | 104445 | 1000000000000000000000 | 0xbfc11ffd | 0xcecad69d7d4ed6d52efcfa028af8732f27e08f70 | 13603462 | 0x10171a0c4a0d0f6be35ee7129d738519670515b4 | | 2021-11-12T20:33:46.000Z | 0x42737916a2fc199d15df13ef5b4ffcabb85d0f5de390c659acdd9821097d4da6 |
| 110532 | 0 | true | 104457 | 2487354327000000000000 | 0xbfc11ffd | 0xcecad69d7d4ed6d52efcfa028af8732f27e08f70 | 13602952 | 0xc918beff9e3302a5cbca2ef219d99d20859cc0c1 | | 2021-11-12T18:38:51.000Z | 0xdcd53affef0b9dcc80d39fac3bb9f8a814871e13c22cd67e6a9e84d372d69031 |
| 110532 | 0 | true | 109257 | 7500000000000000000000 | 0xbfc11ffd | 0xcecad69d7d4ed6d52efcfa028af8732f27e08f70 | 14887688 | 0x4b2696ffd61447f5d32be7439f434aed8e634527 | | 2022-06-01T23:33:20.000Z | 0x7ca52fdd4f6459083d3aba42315ae9aeb1583a7973157c60527da99b974f2f7e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.Flipper_buyOusdWithUsdc_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Flipper\_buyOusdWithUsdt\_function
Function call records for USDT-to-OUSD (Origin Dollar) swaps through the Flipper contract on Ethereum. Used to analyze stablecoin arbitrage activity and OUSD acquisition patterns with input amounts denominated in 18-decimal precision.
| Column | Type | Description |
| ------------------ | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| gas | value | status | gas\_used | in\_amount | signature | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | transaction\_hash |
| ------ | ----- | ------ | --------- | ---------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 84343 | 0 | true | 78815 | 1078362711000000000000 | 0x35aa0b96 | 0xcecad69d7d4ed6d52efcfa028af8732f27e08f70 | 14627696 | 0x25faf04c86f59e4e5f640a1a84432bedb3bed6b7 | | 2022-04-21T10:07:32.000Z | 0x9ca95c8db27e380fd2be215faa144defbcef2eadecbedced077d019bf5ab1642 |
| 101978 | 0 | true | 100703 | 1000000000000000000000 | 0x35aa0b96 | 0xcecad69d7d4ed6d52efcfa028af8732f27e08f70 | 13651279 | 0x9f705ff1da72ed334f0e80f90aae5644f5cd7784 | | 2021-11-20T10:07:38.000Z | 0x16abece471a86e3b0e2ee1cb7d64722eadad7e4c45f4f94d52180e8fb336575f |
| 84319 | 0 | true | 78791 | 960000000000000000000 | 0x35aa0b96 | 0xcecad69d7d4ed6d52efcfa028af8732f27e08f70 | 15082795 | 0x0633a6b20f1541681466eff9cca3618cc318d722 | | 2022-07-05T13:29:53.000Z | 0xe00156b7f41fe30252036524cea57c6e2835c26cb5197ef9ddc6a961433d57a8 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.Flipper_buyOusdWithUsdt_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Flipper\_sellOusdForDai\_function
Function call records for swapping Origin Dollar (OUSD) to DAI through the Flipper contract on Ethereum. Tracks exchange amounts, transaction outcomes, and gas costs for analyzing OUSD redemption activity 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| gas | value | status | gas\_used | in\_amount | signature | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | transaction\_hash |
| ------ | ----- | ------ | --------- | ----------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 78920 | 0 | true | 78014 | 10026749985000000000000 | 0x8a095a0f | 0xcecad69d7d4ed6d52efcfa028af8732f27e08f70 | 14044251 | 0x0f1d772fdc9434aaf203a773a86d3b15badbf1f3 | | 2022-01-20T19:01:31.000Z | 0x77f5200c433f70b4218a627a4968a19fbf7d5b9aeb7cb34231a44cb506612c29 |
| 262222 | 0 | true | 50007 | 104949069881878385284 | 0x8a095a0f | 0xcecad69d7d4ed6d52efcfa028af8732f27e08f70 | 22105199 | 0x22a956c4755d8c4294b358dc346e74250e175622 | 0,2,1 | 2025-03-22T21:46:47.000Z | 0xe137d53957b649c1b161cae79b59062b617ad65c5213b3fe0ce3e2ecf3a79be2 |
| 78920 | 0 | true | 78014 | 17857540265000000000000 | 0x8a095a0f | 0xcecad69d7d4ed6d52efcfa028af8732f27e08f70 | 13974616 | 0x9ef66c27c4e9aa7433dc2480756e59084ea1537a | | 2022-01-10T00:41:03.000Z | 0xf8b28aef8b145ad34887d77cfcddbdb598236a70d811a9e2d383ec1ab241b0ef |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.Flipper_sellOusdForDai_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Flipper\_sellOusdForUsdc\_function
Origin Protocol Flipper contract function calls that swap OUSD (Origin Dollar) stablecoin for USDC on Ethereum. Tracks swap amounts, execution status, and gas consumption for analyzing Origin's automated market operations and stablecoin liquidity management.
| Column | Type | Description |
| ------------------ | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| gas | value | status | gas\_used | in\_amount | signature | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | transaction\_hash |
| ------ | ----- | ------ | --------- | ----------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 109796 | 0 | true | 108890 | 1109400325057850288396 | 0xc6b68169 | 0xcecad69d7d4ed6d52efcfa028af8732f27e08f70 | 15885706 | 0x31c4295e963c0c5b960c11f95412b08f8652ee02 | | 2022-11-02T23:46:23.000Z | 0xab3457bbbe57d15e7f8673e89fee475e1df821431b5cd9a276847a97e31ed317 |
| 109772 | 0 | true | 108866 | 1000000000000000000000 | 0xc6b68169 | 0xcecad69d7d4ed6d52efcfa028af8732f27e08f70 | 15301364 | 0x42aabd3a2f2b64a44b99e0ab025657ba73b871a2 | | 2022-08-08T11:42:47.000Z | 0xc377412da610421263c29301cb56c246b6ef8b8c3b7c0417bddca71b2eab5087 |
| 92684 | 0 | true | 91778 | 20000000000000000000000 | 0xc6b68169 | 0xcecad69d7d4ed6d52efcfa028af8732f27e08f70 | 13538885 | 0x5af776fc4321f55a9e518eef7db133fa7c833556 | | 2021-11-02T17:36:16.000Z | 0xe6867855963f52aa8bd688cd594c9d2c548c8cf9e733c65d8c4212036cbb0d3c |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.Flipper_sellOusdForUsdc_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Flipper\_sellOusdForUsdt\_function
Function calls to Origin Protocol's Flipper contract that swap OUSD (Origin Dollar) stablecoin for USDT on Ethereum. Used for analyzing OUSD liquidity management and redemption activity within the Origin ecosystem.
| Column | Type | Description |
| ------------------ | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| gas | value | status | gas\_used | in\_amount | signature | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | transaction\_hash |
| ------ | ----- | ------ | --------- | ----------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 88461 | 0 | true | 87542 | 25000000000000000000000 | 0xcb939053 | 0xcecad69d7d4ed6d52efcfa028af8732f27e08f70 | 12442483 | 0x84411e36f57516f3b359d9afbcada418f07bbccc | | 2021-05-16T01:07:08.000Z | 0x0f2c4b6708ff2f973c458e770a7d09ee1a61511f83fbcb576629bf1e9a007868 |
| 88449 | 0 | true | 87530 | 1493000000000000000000 | 0xcb939053 | 0xcecad69d7d4ed6d52efcfa028af8732f27e08f70 | 12558735 | 0x84411e36f57516f3b359d9afbcada418f07bbccc | | 2021-06-03T02:00:45.000Z | 0x045becbeb5761d0bfa80c868750c693e2e2fbb4f09976a23f02b66d50126fe7c |
| 105177 | 0 | true | 99471 | 993065124928273044753 | 0xcb939053 | 0xcecad69d7d4ed6d52efcfa028af8732f27e08f70 | 17846277 | 0xb39aa2cd75d9ac4ee292427324e73f4ea08f6b1f | | 2023-08-05T04:06:35.000Z | 0x7b81605cb72afd59f7b2632fba7bafd1aec1128a3c1bb19a7b6d0521ffaae2ee |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.Flipper_sellOusdForUsdt_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LidoARM\_ClaimLidoWithdrawals\_event
Lido ARM (Automated Redemption Manager) withdrawal claim events on Ethereum, recording batched stETH withdrawal request IDs processed through the ARM contract. Used for tracking withdrawal fulfillment and ARM liquidity management 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_requestIds` | `ARRAY` | Array of Lido withdrawal request IDs being claimed in this transaction. Each ID corresponds to a separate stETH unstaking request that has completed its withdrawal period. |
| address | removed | log\_index | block\_number | in\_requestIds | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x85b78aca6deae198fbf201c82daf6ca21942acc6 | false | 326 | 21493772 | \["65435","65436","65469","65471","65475","65476","65477","65480","65488","65494","65495","65496","65497","65498"] | 2024-12-27T12:23:59.000Z | 0x9ae98cf78315437697e541c4cc808cb720974b286a98a4e6e888a830d88ab6f8 |
| 0x85b78aca6deae198fbf201c82daf6ca21942acc6 | false | 68 | 21128621 | \["57089","57098","57099","57106","57110","57115","57123"] | 2024-11-06T12:30:35.000Z | 0xdd7fce530e743c6d8c2d915bd30a450a2a153a4a9a5112a904c18759e6e7322f |
| 0x85b78aca6deae198fbf201c82daf6ca21942acc6 | false | 223 | 21880394 | \["71826","71827","71828","71829","71830","71831","71832","71833","71834","71835","71836","71837","71838","71839","71840","71841","71842","71843","71844","71845","71846","71847","71848","71880"] | 2025-02-19T12:24:59.000Z | 0x49f6fc6b1c864a634e466f5c5e0eb0b0b1e548ac74c68a5de98c1dbdd753db12 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.LidoARM_ClaimLidoWithdrawals_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LidoARM\_Deposit\_event
Deposit events from Origin Protocol's LidoARM (Automated Redemption Manager) vault on Ethereum, tracking user deposits with asset amounts and share allocations. Records vault ownership transfers where depositors receive shares representing their proportional claim on the underlying Lido stETH-based liquidity pool.
| 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_assets` | `STRING` | Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol's accounting system. |
| `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\_owner | in\_assets | in\_shares | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | --------------------- | --------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x85b78aca6deae198fbf201c82daf6ca21942acc6 | false | 0xe677a2e88cc62b5b50c72b01821b3b4186526689 | 12000000000000000000 | 11983515873170619702 | 541 | 21041495 | 2024-10-25T08:40:35.000Z | 0x63d796fe9502f1eb30cb65e7227a57bfeb4a965bb6cbb36d8a5c47687c7e4226 |
| 0x85b78aca6deae198fbf201c82daf6ca21942acc6 | false | 0x67068f70088f214c0ca03a3934d384a0308da355 | 220000000000000000000 | 219696446484626094995 | 387 | 21044580 | 2024-10-25T18:59:47.000Z | 0xf4b65b388e16d100b5a83bd67f4b9ca6cc6d3e5fab35b9f8e5b8c80c7245f58c |
| 0x85b78aca6deae198fbf201c82daf6ca21942acc6 | false | 0x4626c2d1312aaadb658ab0d547b6cedc2e8857d5 | 806000000000000000 | 796151891477650640 | 200 | 21462029 | 2024-12-23T01:52:35.000Z | 0xed655477c8a109d20392f6270d34dbc2d62a1cd06ac90e8c87e82a8d49f8451a |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.LidoARM_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LidoARM\_FeeCollected\_event
Fee collection events from Origin Protocol's Lido ARM (Automated Redemption Manager) contract on Ethereum. Records fee amounts and collector addresses for tracking protocol revenue distribution.
| 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_feeCollector` | `STRING` | Address of the account designated to receive collected fees. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_fee` | `STRING` | Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency. |
| in\_fee | address | removed | log\_index | block\_number | block\_timestamp | in\_feeCollector | transaction\_hash |
| ------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ |
| 62160844372808028 | 0x85b78aca6deae198fbf201c82daf6ca21942acc6 | false | 252 | 21124791 | 2024-11-05T23:40:35.000Z | 0xf14bbdf064e3f67f51cd9bd646ae3716ad938fdc | 0x8603eb6bb43c8cc7fa3ee5a6a5cb5d7bb15f47b4c6acbe2169b89f970470eb07 |
| 460921680380858232 | 0x85b78aca6deae198fbf201c82daf6ca21942acc6 | false | 262 | 21486650 | 2024-12-26T12:30:35.000Z | 0xf14bbdf064e3f67f51cd9bd646ae3716ad938fdc | 0xbee353884fb7d1366e5d76b00ee59e334379b56b366febb02618597b3c2a933b |
| 26196979220303547 | 0x85b78aca6deae198fbf201c82daf6ca21942acc6 | false | 96 | 22159737 | 2025-03-30T12:30:35.000Z | 0x4ff1b9d9ba8558f5eafcec096318ea0d8b541971 | 0xdc8658089389cb93560f8afad6270a977cb72127a283a0d119bc6a0617ae6861 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.LidoARM_FeeCollected_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LidoARM\_FeeUpdated\_event
Fee parameter changes for the Lido Automated Redemption Manager (ARM) on Ethereum, tracking updates to the swap fee rate (in\_fee) measured in basis points. Used for monitoring fee adjustments and protocol economics analysis.
| 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_fee` | `STRING` | Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency. |
| in\_fee | address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------- | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 2000 | 0x85b78aca6deae198fbf201c82daf6ca21942acc6 | false | 59 | 20987226 | 2024-10-17T18:58:35.000Z | 0x6529b3f7e9082549ff132432c75fd574241f431a5f885a2b27fc7930fd5be93c |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.LidoARM_FeeUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LidoARM\_RedeemClaimed\_event
Redemption claim events from Origin Protocol's Lido Automated Redemption Manager (ARM) on Ethereum, tracking when users claim their withdrawn stETH assets. Records include request IDs, asset amounts in wei, and withdrawer addresses for monitoring ARM redemption fulfillment.
| 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_withdrawer` | `STRING` | Address of the account receiving the withdrawn assets. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_requestId` | `STRING` | Unique identifier for an asynchronous request or operation. String-encoded integer that tracks requests across submission, fulfillment, cancellation, or claim events. |
| `in_assets` | `STRING` | Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol's accounting system. |
| address | removed | in\_assets | log\_index | block\_number | in\_requestId | in\_withdrawer | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | --------------------- | ---------- | ------------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x85b78aca6deae198fbf201c82daf6ca21942acc6 | false | 12023159507873632952 | 537 | 21114734 | 9 | 0xe677a2e88cc62b5b50c72b01821b3b4186526689 | 2024-11-04T13:58:35.000Z | 0xc6cdb7802de5ab7c720a21325fe3596c407762f4c874deee21addb5ddc1c8dfa |
| 0x85b78aca6deae198fbf201c82daf6ca21942acc6 | false | 299999999999999999724 | 294 | 21795251 | 25 | 0xe32e3bd2ec560513cab4757564ca50d13caf9f7f | 2025-02-07T14:32:59.000Z | 0x594bc81b5117542405009b48eeed3e9742cd1a01401c0ac0727e5d160c691972 |
| 0x85b78aca6deae198fbf201c82daf6ca21942acc6 | false | 20999999999999999989 | 324 | 21867156 | 40 | 0xfda1215797d29414e588b2e62fc390ee2949aaaa | 2025-02-17T16:01:35.000Z | 0x6f315ffb5a0f25852b86008891ab74daa24073f0beb7dc8d3c633be148b56787 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.LidoARM_RedeemClaimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LidoARM\_RedeemRequested\_event
Redemption request events from Origin Protocol's Lido ARM (Automated Redemption Manager) contract on Ethereum, tracking withdrawal requests for liquid staking tokens with request IDs, asset amounts, queue positions, and claim timestamps. Used for analyzing redemption queue dynamics and withdrawal patterns in Origin's Lido integration.
| 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_withdrawer` | `STRING` | Address of the account receiving the withdrawn assets. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_requestId` | `STRING` | Unique identifier for an asynchronous request or operation. String-encoded integer that tracks requests across submission, fulfillment, cancellation, or claim events. |
| `in_assets` | `STRING` | Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol's accounting system. |
| `in_queued` | `STRING` | Total amount of assets currently queued for withdrawal in the Lido ARM contract at time of this redemption request. Value denominated in wei (smallest unit), typically representing staked ETH or liquid staking tokens. |
| `in_claimTimestamp` | `STRING` | Unix timestamp indicating when the requested redemption becomes claimable by the withdrawer. Represents the future date after which the user can complete their withdrawal from the Lido ARM contract. |
| address | removed | in\_assets | in\_queued | log\_index | block\_number | in\_requestId | in\_withdrawer | block\_timestamp | transaction\_hash | in\_claimTimestamp |
| ------------------------------------------ | ------- | --------------------- | ---------------------- | ---------- | ------------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------ |
| 0x85b78aca6deae198fbf201c82daf6ca21942acc6 | false | 80345207794655604897 | 2447009773500784414645 | 363 | 21888462 | 42 | 0xb8e12daf63314a9baa71b1e39baa4538637bf138 | 2025-02-20T15:28:59.000Z | 0x481b3c76952be15f22c30f1fe46089c804b21d7eae0f57d00a028c7b2395ce1a | 1740065939 |
| 0x85b78aca6deae198fbf201c82daf6ca21942acc6 | false | 9066112249999999996 | 2456075885750784414641 | 362 | 21889137 | 43 | 0x6c2693f5a936f37ed03cfa8465bf2d8beff19a0f | 2025-02-20T17:45:23.000Z | 0x9a7b261a75896c796454fb94757dc06126bc41a1b49d96dabfb49053453fd6df | 1740074123 |
| 0x85b78aca6deae198fbf201c82daf6ca21942acc6 | false | 100019461571072744326 | 1928848842564195300286 | 245 | 21808877 | 29 | 0x610795c27ef8bee6c041f5a0055f40991012bd18 | 2025-02-09T12:12:23.000Z | 0x47739d15dbf514bad40e0a7344f0d24adb6722237f867732324c40c8d4b8bdef | 1739103743 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.LidoARM_RedeemRequested_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LidoARM\_RequestLidoWithdrawals\_event
Withdrawal request events from the Origin Protocol Lido ARM (Automated Redemption Manager) contract on Ethereum, capturing stETH unstaking requests submitted to Lido with request IDs and amounts in wei. Used for tracking ARM liquidity management operations and Lido withdrawal queue positions.
| 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_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_requestIds` | `ARRAY` | Array of Lido withdrawal request identifiers submitted in this transaction, corresponding sequentially to the amounts in in\_amounts. Each request ID is unique and tracks a specific stETH unstaking request through Lido's withdrawal queue. |
| address | removed | log\_index | in\_amounts | block\_number | in\_requestIds | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | -------------------------------------------------- | ------------- | ------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x85b78aca6deae198fbf201c82daf6ca21942acc6 | false | 61 | \["300000000000000000000","263480567970731079450"] | 21487845 | \["65475","65476"] | 2024-12-26T16:30:35.000Z | 0xe0376f86b334740f2804a46d06c0236f7491ac06719e033aae4f19ccd8842c6c |
| 0x85b78aca6deae198fbf201c82daf6ca21942acc6 | false | 196 | \["300000000000000000000","139665503867758103333"] | 21486774 | \["65435","65436"] | 2024-12-26T12:55:35.000Z | 0x91c209ce60f13310399925332bbe7ecd15434250e3d27e774f8b6518d462c00b |
| 0x85b78aca6deae198fbf201c82daf6ca21942acc6 | false | 328 | \["200883621146466226364"] | 21487546 | \["65469"] | 2024-12-26T15:30:35.000Z | 0x60544e682ea1be55e79459983b9ee689d6a3441f8b5618e1f6d47683c98a0217 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.LidoARM_RequestLidoWithdrawals_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LidoARM\_totalAssets\_function
Historical queries to the totalAssets() function on Origin Protocol's Lido ARM (Automated Redemption Manager) contract on Ethereum, tracking total asset values held by the ARM over time. Used for monitoring ARM liquidity and reserve balances across Origin's stablecoin 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. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `out_anon0` | `STRING` | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
| gas | value | status | gas\_used | out\_anon0 | signature | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | transaction\_hash |
| ------ | ----- | ------ | --------- | ---------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 35572 | 0 | true | 10154 | 8139101229776313866877 | 0x01e1d114 | 0x85b78aca6deae198fbf201c82daf6ca21942acc6 | 21994287 | 0xf54ebff575f699d281645c6f14fe427dffe629cf | 1,0,3,0,0 | 2025-03-07T10:04:35.000Z | 0xbf2eac733ddaeb09825fdc5bc40ad0703f6cb1eef6d2958952575855781a0b76 |
| 33806 | 0 | true | 10154 | 8111301220612798612609 | 0x01e1d114 | 0x85b78aca6deae198fbf201c82daf6ca21942acc6 | 21993693 | 0xf54ebff575f699d281645c6f14fe427dffe629cf | 0,3,0,0 | 2025-03-07T08:04:59.000Z | 0x59f5a886c8c11bc787c723c3d172e04ffa67f1958042a43fc9294cd388d45a2a |
| 120012 | 0 | true | 10154 | 3271058796969563588308 | 0x01e1d114 | 0x85b78aca6deae198fbf201c82daf6ca21942acc6 | 21596519 | 0xf54ebff575f699d281645c6f14fe427dffe629cf | 0,0,1,0,3,0,0 | 2025-01-10T20:38:59.000Z | 0xb1fc91586ec5919e3ae79c2e98f2aded36fc2a8740ced51bed6f3023201aeb0e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.LidoARM_totalAssets_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### OETH\_TotalSupplyUpdatedHighres\_event
Origin OETH rebasing token supply snapshots on Ethereum, capturing total supply changes with associated rebasing credits and exchange rate updates. Used for tracking OETH yield accrual mechanics and analyzing the token's rebasing credit system 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_totalSupply` | `STRING` | Total supply of the pool or vault token after the event. Numeric string representation of token quantity in smallest denomination. |
| `in_rebasingCredits` | `STRING` | Total rebasing credits allocated to addresses participating in the rebasing mechanism. Numeric string representation of the aggregate credit balance used to calculate proportional token distributions during rebase events. |
| `in_rebasingCreditsPerToken` | `STRING` | Exchange rate between rebasing credits and tokens in the rebasing mechanism. Numeric string representation of the credits-per-token ratio used to convert between credit balances and actual token amounts during rebase calculations. |
| address | removed | log\_index | block\_number | in\_totalSupply | block\_timestamp | transaction\_hash | in\_rebasingCredits | in\_rebasingCreditsPerToken |
| ------------------------------------------ | ------- | ---------- | ------------- | ----------------------- | ------------------------ | ------------------------------------------------------------------ | -------------------------------- | --------------------------- |
| 0x856c4efb76c1d1ae02e20ceb03a2a6a08b0b8dc3 | false | 144 | 20968167 | 31218366981019263255518 | 2024-10-15T03:05:35.000Z | 0x73c0f95c8d072d67db1efc7b244cbbe03e4aeb6a1ce6cd538667cd5d550ce6c9 | 23297842743748618925813402941235 | 903014556692733305540350006 |
| 0x856c4efb76c1d1ae02e20ceb03a2a6a08b0b8dc3 | false | 308 | 20969337 | 31220333372333309837918 | 2024-10-15T07:00:35.000Z | 0x0052b435fa000325c5f7d9c0c031a618f759e64a97062d1503b5ddf3524682a7 | 23297571387879307623647825189551 | 902959499722875598721215236 |
| 0x856c4efb76c1d1ae02e20ceb03a2a6a08b0b8dc3 | false | 115 | 20973884 | 31216334058116946214155 | 2024-10-15T22:15:59.000Z | 0x13dc47d326a02460c047ecb6c77d4213795b2206140fdbcb5ce1b24c2a70fb0f | 23290712331719367502213750027293 | 902959464319410086123727704 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.OETH_TotalSupplyUpdatedHighres_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### OETHVault\_Mint\_event
OETH (Origin Ether) vault mint events on Ethereum recording when users deposit assets to receive OETH tokens, with minting amounts and recipient addresses. Used for tracking OETH supply changes and user deposit activity in the Origin Protocol yield-bearing stablecoin vault.
| 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` | Address of the user or account associated with the vault mint or redemption operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__value` | `STRING` | Amount transferred, approved, deposited, or withdrawn in the transaction. String-encoded integer representing token quantity in smallest denomination (wei for ETH, base units for ERC20 tokens). |
| address | removed | in\_\_addr | in\_\_value | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x39254033945aa2e4809cc2977e7087bee48bd7ab | false | 0x9858e47bcbbe6fbac040519b02d7cd4b2c470c66 | 1000000000000000 | 190 | 19820666 | 2024-05-07T20:46:35.000Z | 0xf4aaaa9c44dea20743c8bd46576b90ef707fd924c2fe4d00c381f86bb3ad8f99 |
| 0x39254033945aa2e4809cc2977e7087bee48bd7ab | false | 0x9858e47bcbbe6fbac040519b02d7cd4b2c470c66 | 1000000000000000 | 340 | 19820904 | 2024-05-07T21:34:35.000Z | 0x820507a034fd551b4236f5efcbfb7c73c61f214f1097b05b49b57fb6f6b3c4a1 |
| 0x39254033945aa2e4809cc2977e7087bee48bd7ab | false | 0x9858e47bcbbe6fbac040519b02d7cd4b2c470c66 | 3500000000000000000 | 91 | 20190465 | 2024-06-28T13:24:35.000Z | 0xd27b81fd8e1bcca63f6f5b4c11df9a0cf9e888e7a0ec7487ecb5be7296044f36 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.OETHVault_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### OETHVault\_Redeem\_event
OETH (Origin Ether) vault redemption events on Ethereum, recording when users burn OETH tokens to withdraw underlying assets with redemption amounts and recipient addresses. Used for tracking vault outflows and analyzing user withdrawal patterns from the Origin Protocol yield-bearing token.
| 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` | Address of the user or account associated with the vault mint or redemption operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__value` | `STRING` | Amount transferred, approved, deposited, or withdrawn in the transaction. String-encoded integer representing token quantity in smallest denomination (wei for ETH, base units for ERC20 tokens). |
| address | removed | in\_\_addr | in\_\_value | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | --------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x39254033945aa2e4809cc2977e7087bee48bd7ab | false | 0x42c6c52b686e3845f9d5dee93dc213a3826214a9 | 2033478394248985543 | 433 | 19958045 | 2024-05-27T01:52:23.000Z | 0xdd8c03d29916b48b108888b8a40fb656296339de2ef967ac9ca0f5b0c933e433 |
| 0x39254033945aa2e4809cc2977e7087bee48bd7ab | false | 0x4ff1b9d9ba8558f5eafcec096318ea0d8b541971 | 996744339413761817808 | 320 | 22079300 | 2025-03-19T07:02:59.000Z | 0x0ae71224f7f3799834c46e4336bf262c04c8288ba122fafa9c12e544edfdcf58 |
| 0x39254033945aa2e4809cc2977e7087bee48bd7ab | false | 0x4ff1b9d9ba8558f5eafcec096318ea0d8b541971 | 996687729620510999908 | 382 | 22078989 | 2025-03-19T06:00:35.000Z | 0xe4e60c3e7e6173edcb5eb7c62206d64fbf3bc14920ca7b6375fd255524a91701 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.OETHVault_Redeem_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### OETHVault\_RedeemFeeUpdated\_event
Event log tracking redemption fee changes for Origin Ether (OETH) vault on Ethereum, where fees are denominated in basis points (bps). Used for monitoring fee parameter adjustments and governance decisions affecting withdrawal costs.
| 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__redeemFeeBps` | `STRING` | Redemption fee rate expressed in basis points (bps). Integer string where 1 bps equals 0.01%. |
| address | removed | log\_index | block\_number | block\_timestamp | in\_\_redeemFeeBps | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------ | ------------------------------------------------------------------ |
| 0x39254033945aa2e4809cc2977e7087bee48bd7ab | false | 36 | 19473003 | 2024-03-20T02:40:35.000Z | 10 | 0x10951b3b452a50642f5d54bf82becd9b65080149be60bbf34a424125b9f436f1 |
| 0x39254033945aa2e4809cc2977e7087bee48bd7ab | false | 99 | 17067180 | 2023-04-17T14:47:47.000Z | 50 | 0x56e34d9065d7fb47edadf5cdb02edbf2f55e51443363bdb1e2bc9755b44fd76a |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.OETHVault_RedeemFeeUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### OETHVault\_YieldDistribution\_event
Yield distribution events from the Origin Ether (OETH) vault on Ethereum, recording yield generation amounts and protocol fees paid to recipient addresses. Used for tracking vault performance, fee collection patterns, and yield generation 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__to` | `STRING` | Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__yield` | `STRING` | Yield amount generated or distributed by the vault. Numeric string denominated in wei (10^18 smallest units). |
| `in__fee` | `STRING` | Fee amount charged for the transaction or operation. Numeric string representing the fee in the smallest denomination or basis points. |
| in\_\_to | address | in\_\_fee | removed | in\_\_yield | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------------------ | ------- | ------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xfd6c58850cacf9ccf6e8aee479bfb4df14a362d2 | 0x39254033945aa2e4809cc2977e7087bee48bd7ab | 461610489159358798 | false | 2308052445796793990 | 33 | 19609324 | 2024-04-08T06:59:47.000Z | 0x2c57d6ef6b92d541a56fc4bfe9e6383733419e759402a6c88c0c9d44779dbd1c |
| 0xfd6c58850cacf9ccf6e8aee479bfb4df14a362d2 | 0x39254033945aa2e4809cc2977e7087bee48bd7ab | 678207458463980350 | false | 3391037292319901751 | 385 | 19973886 | 2024-05-29T06:59:59.000Z | 0x119453fe3904e2fd8d84c6f1ffd7554169d6027b732f83b212fcdc9e838e9621 |
| 0xfd6c58850cacf9ccf6e8aee479bfb4df14a362d2 | 0x39254033945aa2e4809cc2977e7087bee48bd7ab | 257045196867153492 | false | 1285225984335767460 | 64 | 21692561 | 2025-01-24T06:26:47.000Z | 0x74caae729dd2182ad214e16c0ec9031c25555ea9cf6dd82486e44fd9da0a4ea8 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.OETHVault_YieldDistribution_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### OETHZapper\_Zap\_event
OETH (Origin Ether) token minting events through the Zapper contract on Ethereum, capturing ETH deposits converted to OETH with amounts and user addresses. Used for analyzing OETH token issuance and user adoption 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_minter` | `STRING` | Address authorized to mint tokens in the operation. Hex-encoded, 0x-prefixed, 42-character string for EVM chains; 66-character hex string for Aptos. |
| `in_asset` | `STRING` | Contract address of the asset or token. 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\_asset | in\_amount | in\_minter | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ------------------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x9858e47bcbbe6fbac040519b02d7cd4b2c470c66 | false | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 1230000000000000 | 0x3b9b6e7f3124d32e793668b86a59e916883675d3 | 395 | 18186425 | 2023-09-21T19:46:59.000Z | 0x010aa9719f1490ffabeeb5a5d135f29abd3ca3f75711197b7288f63d951557dd |
| 0x9858e47bcbbe6fbac040519b02d7cd4b2c470c66 | false | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 100000000000000 | 0xd6415162f48140d6090959cb8068174c68e81705 | 370 | 17194833 | 2023-05-05T13:49:23.000Z | 0xc1140c4438eb91327c50fb5948731202488ed697332d959d651b286d9bb30ad3 |
| 0x9858e47bcbbe6fbac040519b02d7cd4b2c470c66 | false | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 3000000000000000000 | 0xd985591993fa6e42f4355cef80ccbaff6a5eba60 | 191 | 17463839 | 2023-06-12T11:59:59.000Z | 0x7a74f1a651d71576f6c73fbef6b3388b313dc39db30eaa07894a6b739b328e5c |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.OETHZapper_Zap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### OUSD\_TotalSupplyUpdatedHighres\_event
Origin Dollar (OUSD) rebasing token supply update events on Ethereum, tracking total supply changes with high-resolution rebasing credits and credits-per-token ratios. Used for analyzing OUSD's elastic supply mechanics and rebase 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_totalSupply` | `STRING` | Total supply of the pool or vault token after the event. Numeric string representation of token quantity in smallest denomination. |
| `in_rebasingCredits` | `STRING` | Total rebasing credits allocated to addresses participating in the rebasing mechanism. Numeric string representation of the aggregate credit balance used to calculate proportional token distributions during rebase events. |
| `in_rebasingCreditsPerToken` | `STRING` | Exchange rate between rebasing credits and tokens in the rebasing mechanism. Numeric string representation of the credits-per-token ratio used to convert between credit balances and actual token amounts during rebase calculations. |
| address | removed | log\_index | block\_number | in\_totalSupply | block\_timestamp | transaction\_hash | in\_rebasingCredits | in\_rebasingCreditsPerToken |
| ------------------------------------------ | ------- | ---------- | ------------- | -------------------------- | ------------------------ | ------------------------------------------------------------------ | ----------------------------------- | --------------------------- |
| 0x2a8e1e676ec238d8a992307b495b45b3feaa5e86 | false | 281 | 21872029 | 9550336381256228497834621 | 2025-02-18T08:20:47.000Z | 0x7b0fec09ce1dc88a50df09bb79d4dd2218f42c6f3a4045d484d6d6c5289b94bb | 5339233627365779997566073959287182 | 656443696467984839454369491 |
| 0x2a8e1e676ec238d8a992307b495b45b3feaa5e86 | false | 146 | 21876651 | 9551221205041557717846528 | 2025-02-18T23:50:35.000Z | 0x9a651feb748c2beef79a65565969ff1a10caed5adb7598b2ace569285d47b6bf | 5339308268798384896887696726235409 | 656386572423297902809291405 |
| 0x2a8e1e676ec238d8a992307b495b45b3feaa5e86 | false | 72 | 16902853 | 33981342514895163211894540 | 2023-03-25T06:59:59.000Z | 0x438c48a7d020d554b1a4e015ff4b7edeed5b7b17ceacf482a9f1abe9d4400b51 | 12630941441520393174983934852111577 | 763221271641305496617285434 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.OUSD_TotalSupplyUpdatedHighres_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Staking\_Reward\_event
Staking reward distribution events from the Origin Protocol (OUSD) on Ethereum, recording when users receive yield payments. Contains recipient addresses and reward amounts for tracking staking returns and protocol yield 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_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\_amount | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ----------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x0c4576ca1c365868e162554af8e385dc3e7c66d9 | 0x0633a6b20f1541681466eff9cca3618cc318d722 | false | 14324297676238706366759 | 307 | 19027063 | 2024-01-17T13:59:59.000Z | 0x80d8a9d570d5a53a069186d4e80c5c2622410c9e46de9e4614f9d1cd21125f19 |
| 0x0c4576ca1c365868e162554af8e385dc3e7c66d9 | 0x5059102ebdcf4e9f4000e2244d1ed50968dae9ee | false | 61673284531159000400999 | 274 | 19029550 | 2024-01-17T22:23:23.000Z | 0x8ce716bc07688a1292593f21b3210d83d0fab34f581cdf91882ffbd64bb9415a |
| 0x0c4576ca1c365868e162554af8e385dc3e7c66d9 | 0x4ae331b66678d617a33962d9efef44cd34b7a2f5 | false | 5273940158845792758123 | 188 | 19027111 | 2024-01-17T14:09:35.000Z | 0x233332f7a107f00f3b820aa901aae3994d3d33cba59f96a971412c3c1625da42 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.Staking_Reward_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Vault\_Mint\_event
Mint events from Origin Protocol's OUSD vault contract on Ethereum, recording when users deposit stablecoins to mint OUSD tokens. Tracks minting addresses and token amounts for analyzing OUSD supply growth and user deposit 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__addr` | `STRING` | Address of the user or account associated with the vault mint or redemption operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__value` | `STRING` | Amount transferred, approved, deposited, or withdrawn in the transaction. String-encoded integer representing token quantity in smallest denomination (wei for ETH, base units for ERC20 tokens). |
| address | removed | in\_\_addr | in\_\_value | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ----------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xe75d77b1865ae93c7eaa3040b038d7aa7bc02f70 | false | 0x135199e8646853898a42ecd3f0d8494b0911930d | 88858881600000000000 | 234 | 11683338 | 2021-01-19T03:39:59.000Z | 0xdc4f917ec7c2070ecc464e749c7a1f890681c3994bfce0bb79b76160fbcb356a |
| 0xe75d77b1865ae93c7eaa3040b038d7aa7bc02f70 | false | 0xea2f87d1afd323035e82a409e522625e1399f947 | 20329210452536013470000 | 53 | 11687131 | 2021-01-19T17:34:52.000Z | 0x7e7d5f28dea70d0b74ed6ded789080ab6962c47318d5aef5ce5c7d536958803c |
| 0xe75d77b1865ae93c7eaa3040b038d7aa7bc02f70 | false | 0x96feb7b6f808dd2bbd09c9e5ccde77cabd58d019 | 13743724667158994400000 | 13 | 11688821 | 2021-01-19T23:44:24.000Z | 0x246b6535ed1924e5b1c0bfeff215041f3c933147b033b613abcf06932a6b198b |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.Vault_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Vault\_Redeem\_event
Redemption events from the Origin Protocol vault contract on Ethereum, recording when users withdraw their vault shares for underlying assets. Captures the redeeming address and token amount for analyzing vault outflows and user withdrawal 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__addr` | `STRING` | Address of the user or account associated with the vault mint or redemption operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__value` | `STRING` | Amount transferred, approved, deposited, or withdrawn in the transaction. String-encoded integer representing token quantity in smallest denomination (wei for ETH, base units for ERC20 tokens). |
| address | removed | in\_\_addr | in\_\_value | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ------------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xe75d77b1865ae93c7eaa3040b038d7aa7bc02f70 | false | 0x66b870ddf78c975af5cd8edc6de25eca81791de1 | 3008596650721000000000000 | 43 | 14182890 | 2022-02-11T05:36:09.000Z | 0xfd00278b0a2617da4be429219935b9b936aae45c608bb4b960d1e47cb49eb79c |
| 0xe75d77b1865ae93c7eaa3040b038d7aa7bc02f70 | false | 0xb2f6129b4b2fa2061bbf6d136bee016a66d821fb | 15000000000000000000 | 142 | 11835214 | 2021-02-11T12:20:14.000Z | 0x3bb3d4c593fed40eaa62ba07de0fb91e55e1af4bec786c3298fef0b015c89ed1 |
| 0xe75d77b1865ae93c7eaa3040b038d7aa7bc02f70 | false | 0x66b870ddf78c975af5cd8edc6de25eca81791de1 | 3010204547625000000000000 | 128 | 14339539 | 2022-03-07T11:54:19.000Z | 0xfb4b86ec19fd34634698430fcde229bf77e0e0094c3c517fa56bcb353e075b75 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.Vault_Redeem_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Vault\_RedeemFeeUpdated\_event
Historical events tracking changes to redemption fees for Origin Protocol vaults on Ethereum, with fee rates expressed in basis points (BPS). Used for analyzing fee structure evolution and vault economic parameters 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__redeemFeeBps` | `STRING` | Redemption fee rate expressed in basis points (bps). Integer string where 1 bps equals 0.01%. |
| address | removed | log\_index | block\_number | block\_timestamp | in\_\_redeemFeeBps | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------ | ------------------------------------------------------------------ |
| 0xe75d77b1865ae93c7eaa3040b038d7aa7bc02f70 | false | 188 | 11551887 | 2020-12-29T23:35:55.000Z | 50 | 0x10c9f13780f4d23c38d599eaecdd80a9990a794f27ef3135cd59cf4a2e8dc080 |
| 0xe75d77b1865ae93c7eaa3040b038d7aa7bc02f70 | false | 157 | 14040628 | 2022-01-20T05:48:46.000Z | 25 | 0x0d30086adcf8deb8145bcd0a76fb49803b5bfc7777b340b575821edb38bf1c00 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.Vault_RedeemFeeUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Vault\_YieldDistribution\_event
Yield distribution events from Origin Protocol's OUSD vault on Ethereum, tracking rewards and fees paid to recipient addresses. Used to analyze vault performance, fee structures, and reward distributions 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__to` | `STRING` | Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__yield` | `STRING` | Yield amount generated or distributed by the vault. Numeric string denominated in wei (10^18 smallest units). |
| `in__fee` | `STRING` | Fee amount charged for the transaction or operation. Numeric string representing the fee in the smallest denomination or basis points. |
| in\_\_to | address | in\_\_fee | removed | in\_\_yield | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | --------------------- | ------- | ---------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xd7b28d06365b85933c64e11e639ea0d3bc0e3bab | 0xe75d77b1865ae93c7eaa3040b038d7aa7bc02f70 | 386632118192617221239 | false | 1933160590963086106195 | 46 | 19759339 | 2024-04-29T06:59:47.000Z | 0x37114b5c9d94f02f6f1f5a0b46a9c944f2c24ae254a8cd04fb977e91fba4aed7 |
| 0xd7b28d06365b85933c64e11e639ea0d3bc0e3bab | 0xe75d77b1865ae93c7eaa3040b038d7aa7bc02f70 | 271291127463593348880 | false | 1356455637317966744400 | 129 | 18668494 | 2023-11-28T06:59:47.000Z | 0x892816e6c67818a310b909d2acb08085fa178a04d066157e83b2e3519c325171 |
| 0x6c5cdfb47150efc52072cb93eea1e0f123529748 | 0xe75d77b1865ae93c7eaa3040b038d7aa7bc02f70 | 103032280075920551434 | false | 1030322800759205514341 | 37 | 15623062 | 2022-09-27T06:59:59.000Z | 0x8b5e62fb3b523518117dc062206e2147557f3c5d037169eee864491e21e748da |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.Vault_YieldDistribution_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### xOGNStaking\_Reward\_event
Staking reward distribution events from the xOGN (staked Origin Token) contract on Ethereum. Tracks reward amounts paid to individual stakers for analyzing yield distribution and staking program 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_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\_amount | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x63898b3b6ef3d39332082178656e9862bee45c57 | 0x68d63d3c296b49446989478d1986f1f27489f9aa | false | 1224830247872877 | 261 | 20381532 | 2024-07-25T05:40:11.000Z | 0x8d325dfe71c98a05f2ea9beeaa4ce1259b89d6dda19e285547ef3e9cd7307133 |
| 0x63898b3b6ef3d39332082178656e9862bee45c57 | 0x902f00fb4d78f3f0d93baddfe3ac34865cbcde35 | false | 1255320487859034691341 | 385 | 20385791 | 2024-07-25T19:56:23.000Z | 0x8c7c60fcb9153432b55091b273a70047bfc78e7481decfac0ca8eb8f768f3ab6 |
| 0x63898b3b6ef3d39332082178656e9862bee45c57 | 0x6ab791754298d6d6d7c182dc1572126b4ed24897 | false | 14661110349268975367 | 212 | 20018870 | 2024-06-04T13:51:23.000Z | 0x383737d411dd3226ecc033c3ab19732d2f2eaf1f18532b2be299c66e82fad3cd |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.xOGNStaking_Reward_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ZapperLidoARM\_Zap\_event
Zap transaction events from the ZapperLidoARM contract on Ethereum, recording conversions between assets (ETH/stETH) and protocol shares with exchange rates. Tracks user deposits into the Lido Automated Rebalancing Module (ARM) for analyzing liquidity provision 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_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_assets` | `STRING` | Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol's accounting system. |
| `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\_assets | in\_sender | in\_shares | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------- | ------------------------------------------ | ------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x01f30b7358ba51f637d1aa05d9b4a60f76dad680 | false | 133543909036000 | 0x9b4792ee64e831201096ca4097e49a9b96312df3 | 132916249747231 | 290 | 21159820 | 2024-11-10T21:00:23.000Z | 0x1f1540a9fc2427c2908c4f39ea9f8adf89a86e98fe5341d69af16bf94b6f3182 |
| 0x01f30b7358ba51f637d1aa05d9b4a60f76dad680 | false | 500000000000000000 | 0xd85a569f3c26f81070544451131c742283360400 | 485664376348023009 | 250 | 22014226 | 2025-03-10T04:56:47.000Z | 0x1a70fa708a4a50e3260eb00d4eb6bddd2299cda315d6c6d5b80c0dffbb23b433 |
| 0x01f30b7358ba51f637d1aa05d9b4a60f76dad680 | false | 1000000000000000000 | 0x7be0c422b61142e84ddb902e6b4d0a73848e64f3 | 983807658948481390 | 171 | 21611408 | 2025-01-12T22:30:59.000Z | 0x6625e3966f86b8767728ab41b0155299a0c239929cac4eebdbbad7b6e4333b11 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.origin_v1_ethereum.ZapperLidoARM_Zap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***