origin_v1_base

Tables

superOETHb_burn_function

Token burn events from the superOETHb (Super Origin Ether Base) contract on Base, recording when tokens are destroyed from holder accounts. Tracks burn amounts, affected accounts, and transaction details for analyzing superOETHb token supply reduction and holder 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.
`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__account`	`STRING`	Account address that received or was affected by the token operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).

Sample Data

gas	status	gas_used	signature	in__amount	to_address	in__account	block_number	from_address	trace_address	block_timestamp	transaction_hash
353604	true	34243	0x9dc29fac	16234691430000000000	0xdbfefd2e8460a6ee4955a68582f85708baea60a3	0x423f27b55fa88256ff80b68c09133858501803af	32902803	0x98a0cbef61bd2d21435f433be4cd42b56b38cc93	0,0	2025-07-15T15:55:53.000Z	0xa34f3c13937ef3ce015b6579582c281b2f3bb90d268742e6691b4d6231176464
353610	true	34243	0x9dc29fac	11220327654722982504	0xdbfefd2e8460a6ee4955a68582f85708baea60a3	0x25404102dc567f28a64ada2cce5790c3508f0004	32913758	0x98a0cbef61bd2d21435f433be4cd42b56b38cc93	0,0	2025-07-15T22:01:03.000Z	0xaef61b62eb3adca286f48747c34f8d19675944d95b075af45dd7260d454d097e
260225	true	9608	0x9dc29fac	7215514351477202854484	0xdbfefd2e8460a6ee4955a68582f85708baea60a3	0xf611cc500eee7e4e4763a05fe623e2363c86d2af	32904862	0x98a0cbef61bd2d21435f433be4cd42b56b38cc93	0,0,2,2,0,0,0,0,11,0,0	2025-07-15T17:04:31.000Z	0x509e74133536b4cd28c351fe4d1201044e05d82d068b6e8864d0a95766f8c7ac

Example Query

Query with partition filter

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

superOETHb_mint_function

Mint function calls for the superOETHb token contract on Base, recording token issuance events with recipient accounts and minted amounts. Used for tracking superOETHb supply expansion and 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.
`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__account`	`STRING`	Account address that received or was affected by the token operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).

Sample Data

gas	status	gas_used	signature	in__amount	to_address	in__account	block_number	from_address	trace_address	block_timestamp	transaction_hash
178598	true	30407	0x40c10f19	394459711736054400	0xdbfefd2e8460a6ee4955a68582f85708baea60a3	0xbb077e716a5f1f1b63ed5244ebff5214e50fec8c	32631891	0x98a0cbef61bd2d21435f433be4cd42b56b38cc93	0,2,0,9	2025-07-09T09:25:29.000Z	0xb160f1e44207125081cc6f0ab8304c1a489f0dc0278ec0eeeb55f2b21a7b8299
178598	true	30407	0x40c10f19	102833455406746404	0xdbfefd2e8460a6ee4955a68582f85708baea60a3	0xbb077e716a5f1f1b63ed5244ebff5214e50fec8c	32653490	0x98a0cbef61bd2d21435f433be4cd42b56b38cc93	0,2,0,9	2025-07-09T21:25:27.000Z	0xc95d919316a33d9f70d3952a59bd7cebe66187df446b4852e29e7b5dcfb4c1a9
182937	true	30407	0x40c10f19	27922634224279036	0xdbfefd2e8460a6ee4955a68582f85708baea60a3	0xbb077e716a5f1f1b63ed5244ebff5214e50fec8c	32633420	0x98a0cbef61bd2d21435f433be4cd42b56b38cc93	0,10	2025-07-09T10:16:27.000Z	0xefcdd90b06f25d075f3a329756d631700969796380074c6d21485e896dec7149

Example Query

Query with partition filter

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

superOETHb_TotalSupplyUpdatedHighres_event

High-frequency supply updates for Super Origin Ether (superOETHb) rebasing token on Base, tracking total supply, rebasing credits, and credits per token ratio. Used for analyzing yield accrual mechanics and token supply changes in the Origin Protocol 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.
`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
0xdbfefd2e8460a6ee4955a68582f85708baea60a3	false	190	23821977	164932875184973909137197	2024-12-17T11:01:41.000Z	0x5dd4319c26ea032efcad51ab8bd8cce2ab86ecf8eb717426e5a19d40833e41f4	40435276187053204770682854062572	966152144008503940907046578
0xdbfefd2e8460a6ee4955a68582f85708baea60a3	false	198	23806600	164921147113281583988008	2024-12-17T02:29:07.000Z	0xc2c63f7acf49eb47ff237563c48526cda2498cb015e61f2688a812ebc0f6dcce	40427085319647746874881173447375	966223545737925050789488914
0xdbfefd2e8460a6ee4955a68582f85708baea60a3	false	216	23824042	164963988110904424371317	2024-12-17T12:10:31.000Z	0x97b5d5e8e1fcc6ea067e580c50803acc20dda65e76f69330b47b34507d4a03e6	40462793902257154630251491061776	966144925067637488973927874

Example Query

Query with partition filter

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

superOETHbDripper_collectAndRebase_function

Function call records for collectAndRebase operations on the superOETHb Dripper contract on Base, tracking automated yield collection and token rebase events. Used for monitoring Origin Protocol’s yield distribution mechanism and rebase frequency 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.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
400000	true	240207	0x73796297	0x02f2c609950e90934ce99e58b4d7326ad0d7f8d6	38053491	0xc0d6fa24d135c006de5b8b2955935466a03d920a	2025-11-11T21:25:29.000Z	0x9df8def29864ea3d18af8fadc6a71dd0daebc73b37ac3693a8f697b5f6be1032
400000	true	240207	0x73796297	0x02f2c609950e90934ce99e58b4d7326ad0d7f8d6	38031891	0xc0d6fa24d135c006de5b8b2955935466a03d920a	2025-11-11T09:25:29.000Z	0x88c07c48e9eb11ed6effcd844c6b470c280a218d3e236090e371baacd75dd3a9
400000	true	215224	0x73796297	0x02f2c609950e90934ce99e58b4d7326ad0d7f8d6	28851892	0xc0d6fa24d135c006de5b8b2955935466a03d920a	2025-04-12T21:25:31.000Z	0x98f4dc3a4fdbb5ddd5ae9c810008ab4efaed4995d0d7b1d61be60951eb5bb4c8

Example Query

Query with partition filter

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

superOETHbVault_Mint_event

Mint event logs from the Super OETH vault contract on Base, recording deposit transactions where users receive vault shares. Tracks user addresses and token amounts deposited, useful for analyzing vault TVL growth and depositor behavior.

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
0x98a0cbef61bd2d21435f433be4cd42b56b38cc93	false	0x80c864704dd06c3693ed5179190786ee38acf835	629301454277932545760	286	28395106	2025-04-02T07:39:19.000Z	0x4c03d867adfcd05acdf9401720facbbe7367e9597cb08423207ab3fc32f87f2b
0x98a0cbef61bd2d21435f433be4cd42b56b38cc93	false	0x3b56c09543d3068f8488ed34e6f383c3854d2bc1	2100000000000000000	169	28396096	2025-04-02T08:12:19.000Z	0xd8168513736c130c7ab5a4d8bda144acd2404b7ae5f8335f3ecbd8812d735ccc
0x98a0cbef61bd2d21435f433be4cd42b56b38cc93	false	0x3b56c09543d3068f8488ed34e6f383c3854d2bc1	365135833302747629	274	28422026	2025-04-02T22:36:39.000Z	0x10cc9375f44c56d46b1a1e7571e4bbc30b5d0d464c630349dcd8fd8e6a20fab7

Example Query

Query with partition filter

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

superOETHbVault_rebase_function

Rebase function call records for the Super OETH vault on Base, tracking yield distribution events executed by the protocol controller. Used for monitoring vault rebalancing operations and analyzing gas costs associated with yield accrual mechanisms.

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.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
336586	true	167028	0xaf14052c	0x98a0cbef61bd2d21435f433be4cd42b56b38cc93	26437040	0x02f2c609950e90934ce99e58b4d7326ad0d7f8d6	0,2	2025-02-15T23:50:27.000Z	0x0bc9f2f6beba0bb081608e4fe4ec60ac97412e5c0519ae5a14d9cf0a8a17b7c6
342108	true	196296	0xaf14052c	0x98a0cbef61bd2d21435f433be4cd42b56b38cc93	32761491	0x02f2c609950e90934ce99e58b4d7326ad0d7f8d6	0,2	2025-07-12T09:25:29.000Z	0x0a64429314516647b89f9a13fa1f2f52d495ab1f46e19c51863f37e6b68ef5a2
342108	true	196296	0xaf14052c	0x98a0cbef61bd2d21435f433be4cd42b56b38cc93	32783090	0x02f2c609950e90934ce99e58b4d7326ad0d7f8d6	0,2	2025-07-12T21:25:27.000Z	0x603b679d5993dbfe14bbd506fa94467a4c56d7adfe58db8d1b56221b852e0486

Example Query

Query with partition filter

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

superOETHbVault_Redeem_event

Redemption events from Origin Protocol’s Super OETH vault on Base, recording when users withdraw their staked positions. Contains user addresses and withdrawal amounts in wei for tracking vault outflows and user exit behavior.

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
0x98a0cbef61bd2d21435f433be4cd42b56b38cc93	false	0x4ff1b9d9ba8558f5eafcec096318ea0d8b541971	1002883592438134246324	391	31154779	2025-06-05T04:48:25.000Z	0x59f7c3a8380dcabb58f6a80376f63315a132beec1e6d545515afa84b8ecb63ef
0x98a0cbef61bd2d21435f433be4cd42b56b38cc93	false	0xf611cc500eee7e4e4763a05fe623e2363c86d2af	85965537958017082652	423	26599439	2025-02-19T18:03:45.000Z	0xbf2b630d98d53c97f25b04a61067bd44624f81bd362c1b4afabb55d2cdd22763
0x98a0cbef61bd2d21435f433be4cd42b56b38cc93	false	0xf611cc500eee7e4e4763a05fe623e2363c86d2af	19739567241476948391885	409	26599439	2025-02-19T18:03:45.000Z	0xbf2b630d98d53c97f25b04a61067bd44624f81bd362c1b4afabb55d2cdd22763

Example Query

Query with partition filter

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

superOETHbVault_RedeemFeeUpdated_event

No description available.

Columns

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

Sample Data

No sample data available.

Example Query

Query with partition filter

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

superOETHbVault_WithdrawalClaimed_event

Withdrawal claim events from the Super Origin Ether (superOETH) vault on Base, recording when users complete their withdrawal requests by claiming requested amounts. Tracks withdrawer addresses, request IDs, and claimed token amounts for analyzing vault redemption patterns and user behavior.

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 user claiming the withdrawal from the superOETHb vault contract. Hex-encoded, 0x-prefixed 40-character Ethereum address representing the beneficiary receiving the withdrawn tokens.
`in__requestId`	`STRING`	Unique identifier for the withdrawal request being claimed from the SuperOETHb vault. Sequential numeric value stored as string, incrementing with each new withdrawal request.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).

Sample Data

address	removed	log_index	in__amount	block_number	in__requestId	in__withdrawer	block_timestamp	transaction_hash
0x98a0cbef61bd2d21435f433be4cd42b56b38cc93	false	196	215148731077259210595	23553895	51	0x1c6586f4895a569d9efac5abd231b79e0d47caad	2024-12-11T06:05:37.000Z	0x88deb0a680b68f0cf99adb22e16818da613f4a442f0da09276960613975b8777
0x98a0cbef61bd2d21435f433be4cd42b56b38cc93	false	453	9616418803421495	23577644	49	0xf69696da236cff4a67c4b03fdbf82e592725ff09	2024-12-11T19:17:15.000Z	0xce05db69e44f6faa829939ccb2ee9a6507aa71322f53e2de65205b71e644fdc3
0x98a0cbef61bd2d21435f433be4cd42b56b38cc93	false	619	20974509237995209424	27152170	137	0x25404102dc567f28a64ada2cce5790c3508f0004	2025-03-04T13:08:07.000Z	0x749d81dcf841e2b73c95a9451582bd6b287db95a25fe4e475523113cd7e362f2

Example Query

Query with partition filter

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

superOETHbVault_YieldDistribution_event

Yield distribution events from Origin Protocol’s Super OETH vault on Base, recording amounts distributed to recipients with associated fees. Used for tracking vault yield payouts and fee collection 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	removed	in__yield	log_index	block_number	block_timestamp	transaction_hash
0x4ff1b9d9ba8558f5eafcec096318ea0d8b541971	0x98a0cbef61bd2d21435f433be4cd42b56b38cc93	false	1900504712395531018	72	29111091	2025-04-18T21:25:29.000Z	0x894f8e747066b00cdfc43d553857d72d85ca50614a92646876a8127a4959ae96
0x4ff1b9d9ba8558f5eafcec096318ea0d8b541971	0x98a0cbef61bd2d21435f433be4cd42b56b38cc93	false	819827544550465097	73	29089491	2025-04-18T09:25:29.000Z	0x5096ecdd0854cafeb942c173033d3b7c5f96923c79ff6901e42b2d9287b1009f
0x4ff1b9d9ba8558f5eafcec096318ea0d8b541971	0x98a0cbef61bd2d21435f433be4cd42b56b38cc93	false	363869213996518652	363	24831595	2025-01-09T19:55:37.000Z	0x2937f8d1ac326782ecca38484c1da5d7d6140c8f745e74cdb06eed293aacca32

Example Query

Query with partition filter

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

superOETHbZapper_Zap_event

Zap events from the SuperOETH zapper contract on Base, recording deposits of WETH (0x4200…0006) and native ETH (0xeeee…eeee) into the yield-bearing token. Used for tracking user minting activity, deposit flows, and zapper contract usage 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
0x3b56c09543d3068f8488ed34e6f383c3854d2bc1	false	0x4200000000000000000000000000000000000006	16895937832702304318	0x960f2c32866db1351b38b14103a0be72c5cd1e30	206	21668758	2024-10-28T14:47:43.000Z	0xc36e0ff4b057ea1444263140874c977b3641e16bdc0b94ead33af3d4f649dee7
0x3b56c09543d3068f8488ed34e6f383c3854d2bc1	false	0x4200000000000000000000000000000000000006	68000000000000000	0x439fc2c6b9fcc0e767cbc61008b5e9f91e6d0bd2	392	21648735	2024-10-28T03:40:17.000Z	0x97c5ee6b1215514838228b9d8986a97eb407c397129d739fba69f7c4a97f4f62
0x3b56c09543d3068f8488ed34e6f383c3854d2bc1	false	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	10000000000000000	0x04aee59de73f6812f389203c6d6b25ffd9dbeb79	238	21659300	2024-10-28T09:32:27.000Z	0x3e3e397eac2db078d60646dc5b8a2698414fbcd719624bcabb1c4686fe00ee4a

Example Query

Query with partition filter

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

wOETHStrategy_Deposit_event

Deposit events from the wOETH (Wrapped Origin Ether) yield strategy contract on Base, recording asset deposits with amounts, principal token addresses, and underlying asset addresses. Used for tracking capital inflows into Origin Protocol’s ETH staking strategy and analyzing 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__asset`	`STRING`	Contract address of the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__pToken`	`STRING`	Contract address of the platform token received in exchange for the deposited asset. Hex-encoded, 0x-prefixed, 42-character string or zero address (0x0000000000000000000000000000000000000000) when no platform token is involved.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).

Sample Data

address	removed	in__asset	log_index	in__amount	in__pToken	block_number	block_timestamp	transaction_hash
0x80c864704dd06c3693ed5179190786ee38acf835	false	0x4200000000000000000000000000000000000006	338	992236886015420579474	0xd8724322f44e5c58d7a815f542036fb17dbbf839	23680384	2024-12-14T04:21:55.000Z	0xc8f038d0bdce1de36dbd7a42bb405cefb6ecdf51b9260f2915df4aad067b6c61
0x80c864704dd06c3693ed5179190786ee38acf835	false	0x4200000000000000000000000000000000000006	375	994497316411463434312	0xd8724322f44e5c58d7a815f542036fb17dbbf839	23599615	2024-12-12T07:29:37.000Z	0x720192317354d4667e747553ca8ba446195e897ed76501a4b4cdd6dc511cd9b2
0x80c864704dd06c3693ed5179190786ee38acf835	false	0x4200000000000000000000000000000000000006	155	857947895353420405296	0xd8724322f44e5c58d7a815f542036fb17dbbf839	31456570	2025-06-12T04:28:07.000Z	0x99cfbd17455d158f9e402b708f1f98f2e0447e44cfc017f0c523269aadee0805

Example Query

Query with partition filter

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

wOETHStrategy_Withdrawal_event

Withdrawal events from the wOETH (Wrapped Origin Ether) yield strategy on Base, tracking asset withdrawals with corresponding platform token (pToken) burns and withdrawal amounts. Used for analyzing strategy redemption patterns and liquidity management in the Origin Protocol 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.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in__asset`	`STRING`	Contract address of the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__pToken`	`STRING`	Contract address of the platform token received in exchange for the deposited asset. Hex-encoded, 0x-prefixed, 42-character string or zero address (0x0000000000000000000000000000000000000000) when no platform token is involved.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).

Sample Data

address	removed	in__asset	log_index	in__amount	in__pToken	block_number	block_timestamp	transaction_hash
0x80c864704dd06c3693ed5179190786ee38acf835	false	0x4200000000000000000000000000000000000006	724	991631016799909201687	0xd8724322f44e5c58d7a815f542036fb17dbbf839	25933548	2025-02-04T08:07:23.000Z	0xcb3580e28509410d95488e282026300c9e17334b207ea67674c13d7bd8f36b58
0x80c864704dd06c3693ed5179190786ee38acf835	false	0x4200000000000000000000000000000000000006	1088	991684068693513212378	0xd8724322f44e5c58d7a815f542036fb17dbbf839	25935999	2025-02-04T09:29:05.000Z	0x1ca796b41eed26a0fecb89d0936ca67fac914f163aa82da189546349a25adc3d
0x80c864704dd06c3693ed5179190786ee38acf835	false	0x4200000000000000000000000000000000000006	252	450000000000000000000	0xd8724322f44e5c58d7a815f542036fb17dbbf839	27115775	2025-03-03T16:54:57.000Z	0x1a235a54cfedc3bea1f79f9beb973aba92e381e7c1993269e8e215b4bc538d61

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

superOETHb_burn_function

superOETHb_mint_function

superOETHb_TotalSupplyUpdatedHighres_event

superOETHbDripper_collectAndRebase_function

superOETHbVault_Mint_event

superOETHbVault_rebase_function

superOETHbVault_Redeem_event

superOETHbVault_RedeemFeeUpdated_event

superOETHbVault_WithdrawalClaimed_event

superOETHbVault_YieldDistribution_event

superOETHbZapper_Zap_event

wOETHStrategy_Deposit_event

wOETHStrategy_Withdrawal_event

​Tables

​superOETHb_burn_function

​superOETHb_mint_function

​superOETHb_TotalSupplyUpdatedHighres_event

​superOETHbDripper_collectAndRebase_function

​superOETHbVault_Mint_event

​superOETHbVault_rebase_function

​superOETHbVault_Redeem_event

​superOETHbVault_RedeemFeeUpdated_event

​superOETHbVault_WithdrawalClaimed_event

​superOETHbVault_YieldDistribution_event

​superOETHbZapper_Zap_event

​wOETHStrategy_Deposit_event

​wOETHStrategy_Withdrawal_event

Tables

superOETHb_burn_function

superOETHb_mint_function

superOETHb_TotalSupplyUpdatedHighres_event

superOETHbDripper_collectAndRebase_function

superOETHbVault_Mint_event

superOETHbVault_rebase_function

superOETHbVault_Redeem_event

superOETHbVault_RedeemFeeUpdated_event

superOETHbVault_WithdrawalClaimed_event

superOETHbVault_YieldDistribution_event

superOETHbZapper_Zap_event

wOETHStrategy_Deposit_event

wOETHStrategy_Withdrawal_event