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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`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.

Sample Data

gas	status	gas_used	in_amount	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
2561866	true	66968	3550335464330122756096	0x5981c746	0xcecad69d7d4ed6d52efcfa028af8732f27e08f70	21351925	0x2593154f192f46f65a4a0315a5d77556d5d3d264	0,3,3	2024-12-07T16:52:23.000Z	0x24d37ec8a82f7bc180698ca536717065ead954a93c774a2bc4d3cfae4eea7da5
93451	false	29314		0x5981c746	0xcecad69d7d4ed6d52efcfa028af8732f27e08f70	13197738	0x8e09f821a8cb0af0cb95fbe1324ff1ca81fc660f		2021-09-10T11:28:12.000Z	0xfd2a4c2d532dd8068dd73da3b30184f2aec906a241a15c3b1e2d851f78b93ceb
93451	true	92165	1020980826000000000000	0x5981c746	0xcecad69d7d4ed6d52efcfa028af8732f27e08f70	13197735	0x8e09f821a8cb0af0cb95fbe1324ff1ca81fc660f		2021-09-10T11:27:55.000Z	0x9f14df573a75ccb3757bc105f851b0b9a4d758c284624abb95d1b84e83e57e5b

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`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.

Sample Data

gas	status	gas_used	in_amount	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
110520	true	104445	1000000000000000000000	0xbfc11ffd	0xcecad69d7d4ed6d52efcfa028af8732f27e08f70	13603462	0x10171a0c4a0d0f6be35ee7129d738519670515b4	2021-11-12T20:33:46.000Z	0x42737916a2fc199d15df13ef5b4ffcabb85d0f5de390c659acdd9821097d4da6
110532	true	104457	2487354327000000000000	0xbfc11ffd	0xcecad69d7d4ed6d52efcfa028af8732f27e08f70	13602952	0xc918beff9e3302a5cbca2ef219d99d20859cc0c1	2021-11-12T18:38:51.000Z	0xdcd53affef0b9dcc80d39fac3bb9f8a814871e13c22cd67e6a9e84d372d69031
110532	true	109257	7500000000000000000000	0xbfc11ffd	0xcecad69d7d4ed6d52efcfa028af8732f27e08f70	14887688	0x4b2696ffd61447f5d32be7439f434aed8e634527	2022-06-01T23:33:20.000Z	0x7ca52fdd4f6459083d3aba42315ae9aeb1583a7973157c60527da99b974f2f7e

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`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.

Sample Data

gas	status	gas_used	in_amount	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
84343	true	78815	1078362711000000000000	0x35aa0b96	0xcecad69d7d4ed6d52efcfa028af8732f27e08f70	14627696	0x25faf04c86f59e4e5f640a1a84432bedb3bed6b7	2022-04-21T10:07:32.000Z	0x9ca95c8db27e380fd2be215faa144defbcef2eadecbedced077d019bf5ab1642
101978	true	100703	1000000000000000000000	0x35aa0b96	0xcecad69d7d4ed6d52efcfa028af8732f27e08f70	13651279	0x9f705ff1da72ed334f0e80f90aae5644f5cd7784	2021-11-20T10:07:38.000Z	0x16abece471a86e3b0e2ee1cb7d64722eadad7e4c45f4f94d52180e8fb336575f
84319	true	78791	960000000000000000000	0x35aa0b96	0xcecad69d7d4ed6d52efcfa028af8732f27e08f70	15082795	0x0633a6b20f1541681466eff9cca3618cc318d722	2022-07-05T13:29:53.000Z	0xe00156b7f41fe30252036524cea57c6e2835c26cb5197ef9ddc6a961433d57a8

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`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.

Sample Data

gas	status	gas_used	in_amount	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
78920	true	78014	10026749985000000000000	0x8a095a0f	0xcecad69d7d4ed6d52efcfa028af8732f27e08f70	14044251	0x0f1d772fdc9434aaf203a773a86d3b15badbf1f3		2022-01-20T19:01:31.000Z	0x77f5200c433f70b4218a627a4968a19fbf7d5b9aeb7cb34231a44cb506612c29
262222	true	50007	104949069881878385284	0x8a095a0f	0xcecad69d7d4ed6d52efcfa028af8732f27e08f70	22105199	0x22a956c4755d8c4294b358dc346e74250e175622	0,2,1	2025-03-22T21:46:47.000Z	0xe137d53957b649c1b161cae79b59062b617ad65c5213b3fe0ce3e2ecf3a79be2
78920	true	78014	17857540265000000000000	0x8a095a0f	0xcecad69d7d4ed6d52efcfa028af8732f27e08f70	13974616	0x9ef66c27c4e9aa7433dc2480756e59084ea1537a		2022-01-10T00:41:03.000Z	0xf8b28aef8b145ad34887d77cfcddbdb598236a70d811a9e2d383ec1ab241b0ef

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`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.

Sample Data

gas	status	gas_used	in_amount	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
109796	true	108890	1109400325057850288396	0xc6b68169	0xcecad69d7d4ed6d52efcfa028af8732f27e08f70	15885706	0x31c4295e963c0c5b960c11f95412b08f8652ee02	2022-11-02T23:46:23.000Z	0xab3457bbbe57d15e7f8673e89fee475e1df821431b5cd9a276847a97e31ed317
109772	true	108866	1000000000000000000000	0xc6b68169	0xcecad69d7d4ed6d52efcfa028af8732f27e08f70	15301364	0x42aabd3a2f2b64a44b99e0ab025657ba73b871a2	2022-08-08T11:42:47.000Z	0xc377412da610421263c29301cb56c246b6ef8b8c3b7c0417bddca71b2eab5087
92684	true	91778	20000000000000000000000	0xc6b68169	0xcecad69d7d4ed6d52efcfa028af8732f27e08f70	13538885	0x5af776fc4321f55a9e518eef7db133fa7c833556	2021-11-02T17:36:16.000Z	0xe6867855963f52aa8bd688cd594c9d2c548c8cf9e733c65d8c4212036cbb0d3c

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`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.

Sample Data

gas	status	gas_used	in_amount	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
88461	true	87542	25000000000000000000000	0xcb939053	0xcecad69d7d4ed6d52efcfa028af8732f27e08f70	12442483	0x84411e36f57516f3b359d9afbcada418f07bbccc	2021-05-16T01:07:08.000Z	0x0f2c4b6708ff2f973c458e770a7d09ee1a61511f83fbcb576629bf1e9a007868
88449	true	87530	1493000000000000000000	0xcb939053	0xcecad69d7d4ed6d52efcfa028af8732f27e08f70	12558735	0x84411e36f57516f3b359d9afbcada418f07bbccc	2021-06-03T02:00:45.000Z	0x045becbeb5761d0bfa80c868750c693e2e2fbb4f09976a23f02b66d50126fe7c
105177	true	99471	993065124928273044753	0xcb939053	0xcecad69d7d4ed6d52efcfa028af8732f27e08f70	17846277	0xb39aa2cd75d9ac4ee292427324e73f4ea08f6b1f	2023-08-05T04:06:35.000Z	0x7b81605cb72afd59f7b2632fba7bafd1aec1128a3c1bb19a7b6d0521ffaae2ee

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

in_fee	address	removed	log_index	block_number	block_timestamp	transaction_hash
2000	0x85b78aca6deae198fbf201c82daf6ca21942acc6	false	59	20987226	2024-10-17T18:58:35.000Z	0x6529b3f7e9082549ff132432c75fd574241f431a5f885a2b27fc7930fd5be93c

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`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.

Sample Data

gas	status	gas_used	out_anon0	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
35572	true	10154	8139101229776313866877	0x01e1d114	0x85b78aca6deae198fbf201c82daf6ca21942acc6	21994287	0xf54ebff575f699d281645c6f14fe427dffe629cf	1,0,3,0,0	2025-03-07T10:04:35.000Z	0xbf2eac733ddaeb09825fdc5bc40ad0703f6cb1eef6d2958952575855781a0b76
33806	true	10154	8111301220612798612609	0x01e1d114	0x85b78aca6deae198fbf201c82daf6ca21942acc6	21993693	0xf54ebff575f699d281645c6f14fe427dffe629cf	0,3,0,0	2025-03-07T08:04:59.000Z	0x59f5a886c8c11bc787c723c3d172e04ffa67f1958042a43fc9294cd388d45a2a
120012	true	10154	3271058796969563588308	0x01e1d114	0x85b78aca6deae198fbf201c82daf6ca21942acc6	21596519	0xf54ebff575f699d281645c6f14fe427dffe629cf	0,0,1,0,3,0,0	2025-01-10T20:38:59.000Z	0xb1fc91586ec5919e3ae79c2e98f2aded36fc2a8740ced51bed6f3023201aeb0e

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in__redeemFeeBps`	`STRING`	Redemption fee rate expressed in basis points (bps). Integer string where 1 bps equals 0.01%.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	in_user	removed	in_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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in__redeemFeeBps`	`STRING`	Redemption fee rate expressed in basis points (bps). Integer string where 1 bps equals 0.01%.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	in_user	removed	in_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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Flipper_buyOusdWithDai_function

Flipper_buyOusdWithUsdc_function

Flipper_buyOusdWithUsdt_function

Flipper_sellOusdForDai_function

Flipper_sellOusdForUsdc_function

Flipper_sellOusdForUsdt_function

LidoARM_ClaimLidoWithdrawals_event

LidoARM_Deposit_event

LidoARM_FeeCollected_event

LidoARM_FeeUpdated_event

LidoARM_RedeemClaimed_event

LidoARM_RedeemRequested_event

LidoARM_RequestLidoWithdrawals_event

LidoARM_totalAssets_function

OETH_TotalSupplyUpdatedHighres_event

OETHVault_Mint_event

OETHVault_Redeem_event

OETHVault_RedeemFeeUpdated_event

OETHVault_YieldDistribution_event

OETHZapper_Zap_event

OUSD_TotalSupplyUpdatedHighres_event

Staking_Reward_event

Vault_Mint_event

Vault_Redeem_event

Vault_RedeemFeeUpdated_event

Vault_YieldDistribution_event

xOGNStaking_Reward_event

ZapperLidoARM_Zap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Flipper_buyOusdWithDai_function

​Flipper_buyOusdWithUsdc_function

​Flipper_buyOusdWithUsdt_function

​Flipper_sellOusdForDai_function

​Flipper_sellOusdForUsdc_function

​Flipper_sellOusdForUsdt_function

​LidoARM_ClaimLidoWithdrawals_event

​LidoARM_Deposit_event

​LidoARM_FeeCollected_event

​LidoARM_FeeUpdated_event

​LidoARM_RedeemClaimed_event

​LidoARM_RedeemRequested_event

​LidoARM_RequestLidoWithdrawals_event

​LidoARM_totalAssets_function

​OETH_TotalSupplyUpdatedHighres_event

​OETHVault_Mint_event

​OETHVault_Redeem_event

​OETHVault_RedeemFeeUpdated_event

​OETHVault_YieldDistribution_event

​OETHZapper_Zap_event

​OUSD_TotalSupplyUpdatedHighres_event

​Staking_Reward_event

​Vault_Mint_event

​Vault_Redeem_event

​Vault_RedeemFeeUpdated_event

​Vault_YieldDistribution_event

​xOGNStaking_Reward_event

​ZapperLidoARM_Zap_event

Tables

Flipper_buyOusdWithDai_function

Flipper_buyOusdWithUsdc_function

Flipper_buyOusdWithUsdt_function

Flipper_sellOusdForDai_function

Flipper_sellOusdForUsdc_function

Flipper_sellOusdForUsdt_function

LidoARM_ClaimLidoWithdrawals_event

LidoARM_Deposit_event

LidoARM_FeeCollected_event

LidoARM_FeeUpdated_event

LidoARM_RedeemClaimed_event

LidoARM_RedeemRequested_event

LidoARM_RequestLidoWithdrawals_event

LidoARM_totalAssets_function

OETH_TotalSupplyUpdatedHighres_event

OETHVault_Mint_event

OETHVault_Redeem_event

OETHVault_RedeemFeeUpdated_event

OETHVault_YieldDistribution_event

OETHZapper_Zap_event

OUSD_TotalSupplyUpdatedHighres_event

Staking_Reward_event

Vault_Mint_event

Vault_Redeem_event

Vault_RedeemFeeUpdated_event

Vault_YieldDistribution_event

xOGNStaking_Reward_event

ZapperLidoARM_Zap_event