origin_v1_sonic

Tables

OETHVault_Mint_event

OETH (Origin Ether) vault mint event logs from Sonic chain, recording when users deposit assets to receive OETH tokens. Tracks minting amounts and recipient addresses for analyzing vault deposits and OETH token issuance 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__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
0xa3c0eca00d2b76b4d1f170b0ab3fdea16c180186	false	0xe25a2b256ffb3ad73678d5e80de8d2f6022fab21	123456789000000000	3	4733875	2025-01-20T21:31:03.000Z	0x2fd9c7a4e8b6143d6dc5eb7b396c68ebfed280ef98df22097ac7c1a69d6d517d
0xa3c0eca00d2b76b4d1f170b0ab3fdea16c180186	false	0x04e7ce6e7c581bc5c00ed390f8161783ab0fa906	11478444473835396681	0	5935220	2025-01-30T20:07:26.000Z	0x9c31eac64515960378a473c8cee1578f657fa5478cfd8716c66880bb6b95cdd4
0xa3c0eca00d2b76b4d1f170b0ab3fdea16c180186	false	0x07b96c7464571db496e446a6df5e896082c31df8	300000000000000000000	0	5841791	2025-01-30T00:50:56.000Z	0x7fe672aeb2ce1b81a64b9b36d87a777bd10754fe3a14a5183947e596be74e024

Example Query

Query with partition filter

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

OETHVault_Redeem_event

Redemption events from Origin Ether (OETH) vault on Sonic, recording when users withdraw their vault shares for underlying assets. Contains redeemer addresses and withdrawal amounts for tracking vault outflows and user redemption patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in__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
0xa3c0eca00d2b76b4d1f170b0ab3fdea16c180186	false	0xbe19cc5654e30daf04ad3b5e06213d70f4e882ee	198084545906772278517094	21	47938240	2025-09-23T18:35:45.000Z	0x8b7f3dd5fe697eefc377021443b1f66512ab762850053e0c653f231e7fa3dd5e
0xa3c0eca00d2b76b4d1f170b0ab3fdea16c180186	false	0xbe19cc5654e30daf04ad3b5e06213d70f4e882ee	170154466477917490092456	21	47961996	2025-09-23T23:35:05.000Z	0x28c897fe64645c6594715f784d08cf0c188fda15bd1167969bbbc5119aa7597a
0xa3c0eca00d2b76b4d1f170b0ab3fdea16c180186	false	0xbe19cc5654e30daf04ad3b5e06213d70f4e882ee	165020074518041130621377	22	48044231	2025-09-24T15:43:05.000Z	0xf4210a8971e8f1a504be579acf3d4c91dab570ffdcaebdad67e63c2de80b92e3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.origin_v1_sonic.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 the Origin Ether (OETH) vault on Sonic, recording the fee in basis points (bps) where 10 bps equals 0.1%. Used to monitor fee adjustments and their timing for governance analysis and user cost tracking.

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
0xa3c0eca00d2b76b4d1f170b0ab3fdea16c180186	false	22	12805932	2025-03-10T08:21:18.000Z	10	0x68a50a6155f0668ae3d603b43d269a7edf22e03352128d7936744af96d77b116

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.origin_v1_sonic.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 Sonic, recording when yield is distributed to recipients with the total yield amount and protocol fee deducted. Used for tracking vault revenue generation and fee collection 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__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
0x63cdd3072f25664eec6faeff6daeb668ea4de94a	0xa3c0eca00d2b76b4d1f170b0ab3fdea16c180186	86869506882236286140	false	868695068822362861407	2	14825230	2025-03-20T11:50:29.000Z	0x2d2bd90b233dfb6031d7918054c86dddedf4a020a4f421b4a005e54a06b3b3ba
0x63cdd3072f25664eec6faeff6daeb668ea4de94a	0xa3c0eca00d2b76b4d1f170b0ab3fdea16c180186	5053448047309863100	false	50534480473098631008	2	14926512	2025-03-20T23:50:27.000Z	0xc64cb4694bc4e60830cf3403040a0fa924d868ecae3c58ff33ec439753ffb06f
0x63cdd3072f25664eec6faeff6daeb668ea4de94a	0xa3c0eca00d2b76b4d1f170b0ab3fdea16c180186	303354133928340310018	false	3033541339283403100187	2	14802143	2025-03-20T09:05:56.000Z	0x134ce5d737ef2b4c70a68681fffc4f334210127396563bd18a4021011e6f8873

Example Query

Query with partition filter

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

OS_TotalSupplyUpdatedHighres_event

High-frequency total supply snapshots for Origin Protocol’s rebasing token (OUSD) on Sonic, capturing supply changes, rebasing credits, and exchange rate updates. Used for tracking yield distribution mechanics and analyzing rebase events at second-level granularity.

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
0xb1e25689d55734fd3fffc939c4c3eb52dff8a794	false	3	10371305	38258942946994991870513683	2025-02-26T20:00:59.000Z	0x051c23898ad2f95f13dbf88df6b12b9b5acb142948709ed85123863b57435d31	20736320392493256331238372819602409	986956993182223861402744496
0xb1e25689d55734fd3fffc939c4c3eb52dff8a794	false	3	10321566	38015918531739646659126349	2025-02-26T15:14:31.000Z	0xa7040eab2e26d9d753cae8a23c0780f183af5bb5931b1c06cefdd920c7d778c0	20240731349999977117335628042791769	987007914505434788417567038
0xb1e25689d55734fd3fffc939c4c3eb52dff8a794	false	3	10373264	38260238596008469495548728	2025-02-26T20:12:28.000Z	0x73fa096be81fe53b48f63bcd9a3e935b79f13a04478f607e5ba82cceb0237440	20734382438459484492221439801003177	986955274493942629910979039

Example Query

Query with partition filter

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

OSVault_Mint_event

Mint events from the Origin Protocol OSVault contract on Sonic, recording deposit transactions where users receive vault shares in exchange for underlying assets. Used for tracking vault deposit activity, user positions, and total value locked (TVL) changes 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__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	block_number	block_timestamp	transaction_hash
0xa3c0eca00d2b76b4d1f170b0ab3fdea16c180186	false	0x1563c4751ad2be48fd17464b73585b6ba8b6a5f0	50000000000000000000	5789866	2025-01-29T15:31:46.000Z	0xcd21cb60bfd5ae5844b80e33827e92a46be5dac560202a7452527606ae08c3c0
0xa3c0eca00d2b76b4d1f170b0ab3fdea16c180186	false	0x1563c4751ad2be48fd17464b73585b6ba8b6a5f0	50000000000000000000	5791823	2025-01-29T16:01:23.000Z	0xe8f7c2be38d3772b31fa386019a731ba70eaabf770a6d76a3fb6195a41ff02b3
0xa3c0eca00d2b76b4d1f170b0ab3fdea16c180186	false	0x5d7959294819c9373da0c4d4d98b4d5e6be75ec0	44216039037121298233	5747821	2025-01-29T05:25:06.000Z	0x28cd2ada49764bab52f460697ab44083b876192e1a4729187c3898e12d8633fc

Example Query

Query with partition filter

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

OSVault_Redeem_event

Redemption events from Origin Protocol’s OSVault contract on Sonic, recording withdrawal transactions where users redeem vault shares for underlying assets. Useful for tracking vault outflows, redemption patterns, and user withdrawal 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
0xa3c0eca00d2b76b4d1f170b0ab3fdea16c180186	false	0xbe19cc5654e30daf04ad3b5e06213d70f4e882ee	198084545906772278517094	21	47938240	2025-09-23T18:35:45.000Z	0x8b7f3dd5fe697eefc377021443b1f66512ab762850053e0c653f231e7fa3dd5e
0xa3c0eca00d2b76b4d1f170b0ab3fdea16c180186	false	0xbe19cc5654e30daf04ad3b5e06213d70f4e882ee	170154466477917490092456	21	47961996	2025-09-23T23:35:05.000Z	0x28c897fe64645c6594715f784d08cf0c188fda15bd1167969bbbc5119aa7597a
0xa3c0eca00d2b76b4d1f170b0ab3fdea16c180186	false	0xbe19cc5654e30daf04ad3b5e06213d70f4e882ee	165020074518041130621377	22	48044231	2025-09-24T15:43:05.000Z	0xf4210a8971e8f1a504be579acf3d4c91dab570ffdcaebdad67e63c2de80b92e3

Example Query

Query with partition filter

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

OSVault_RedeemFeeUpdated_event

Events tracking redemption fee changes for Origin Protocol vaults on Sonic chain, recording when vault administrators modify the fee charged to users withdrawing assets (measured in basis points).

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
0xa3c0eca00d2b76b4d1f170b0ab3fdea16c180186	false	22	12805932	2025-03-10T08:21:18.000Z	10	0x68a50a6155f0668ae3d603b43d269a7edf22e03352128d7936744af96d77b116

Example Query

Query with partition filter

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

OSVault_YieldDistribution_event

Yield distribution events from Origin Protocol’s OSVault (Origin Staked ETH Vault) on Sonic, recording yield and fee amounts paid to recipient addresses. Used for tracking vault performance, fee collection patterns, and beneficiary 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
0x63cdd3072f25664eec6faeff6daeb668ea4de94a	0xa3c0eca00d2b76b4d1f170b0ab3fdea16c180186	246972172886886908686	false	2469721728868869086861	2	13415953	2025-03-13T08:57:04.000Z	0x8ce22b512e9047efed0d3a6508777710292a6d00f5ae9a4b5a1bed8715aeb42d
0x63cdd3072f25664eec6faeff6daeb668ea4de94a	0xa3c0eca00d2b76b4d1f170b0ab3fdea16c180186	5478818292083287584	false	54788182920832875848	3	13495299	2025-03-13T17:02:47.000Z	0x764bffc8132e856093149317105c9b01927164b5bc5d507d92e20d321782f8aa
0x63cdd3072f25664eec6faeff6daeb668ea4de94a	0xa3c0eca00d2b76b4d1f170b0ab3fdea16c180186	55150729946591790738	false	551507299465917907386	5	13359076	2025-03-13T01:27:00.000Z	0xb855344673f7dfee360e6844b8beeb76d8526f156c6dcb7a16e267a82d57631e

Example Query

Query with partition filter

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

OSZapper_Zap_event

Zap transaction events from Origin Protocol’s OSZapper contract on Sonic, recording users converting assets (primarily native tokens) into Origin-wrapped positions. Useful for tracking user deposit flows and analyzing capital inflows into Origin’s liquid staking or yield products.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0xe25a2b256ffb3ad73678d5e80de8d2f6022fab21	false	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	70000000000000000000000	0x15ff3859af506d6e4d7e5fdf335628fc1e3ef1ce	3	4217097	2025-01-17T01:40:54.000Z	0xa2c32d43a36e5c3f5c5c831b7d7effce087a73da22d818453ad55032ad0bad86
0xe25a2b256ffb3ad73678d5e80de8d2f6022fab21	false	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	5000000000000000000	0x15ff3859af506d6e4d7e5fdf335628fc1e3ef1ce	0	4215199	2025-01-17T01:22:14.000Z	0xcc21d4887a653403371c44db2d0599324473b7ef834fbc7abb388721b4dc8369
0xe25a2b256ffb3ad73678d5e80de8d2f6022fab21	false	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	277946335254072713	0x7d585b0e27bbb3d981b7757115ec11f47c476994	19	17702039	2025-04-02T14:34:19.000Z	0x5555f8d5d8818ef5f4ae3f3c93048985037e9f32c1d84b983e12d3bf0ecf7042

Example Query

Query with partition filter

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

wOSStrategy_Deposit_event

Deposit events from the wrapped Origin Strategy (wOSStrategy) contract on Sonic, tracking asset deposits with amounts and recipient platform token (pToken) addresses. Used for monitoring Origin Protocol vault deposit activity and liquidity flows.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in__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
0x596b0401479f6dfe1caf8c12838311fee742b95c	false	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	10	8015040000000000000000	0x0000000000000000000000000000000000000000	7113330	2025-02-09T07:38:06.000Z	0xceeeda74eee2927dfd68f64a0d3e568b5e14f7e348608655ff30b9ce3648a62d
0x596b0401479f6dfe1caf8c12838311fee742b95c	false	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	10	8903070000000000000000	0x0000000000000000000000000000000000000000	7113244	2025-02-09T07:36:59.000Z	0x24aa4516d09ed06b83e2d5b6c69254aeb458775aceb1dd5d96eebe46ebbbb85e
0x596b0401479f6dfe1caf8c12838311fee742b95c	false	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	10	7215120000000000000000	0x0000000000000000000000000000000000000000	7113431	2025-02-09T07:39:35.000Z	0x00a20c71387d4ad42f3d1687cf365fede1af95df5ff949d9eeb02e1f47d25386

Example Query

Query with partition filter

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

wOSStrategy_Withdrawal_event

Withdrawal events from the wOSStrategy contract on Sonic (Origin v1), capturing asset and amount data when users withdraw from the yield strategy. Used for tracking fund outflows and strategy redemption patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in__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
0x596b0401479f6dfe1caf8c12838311fee742b95c	false	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	9	2000000000000000000000000	0x0000000000000000000000000000000000000000	15659234	2025-03-24T13:49:14.000Z	0xd2619f4d02bbc173b67d65d733e760c2e2098997e99f9c5be1cab023ac10170e
0x596b0401479f6dfe1caf8c12838311fee742b95c	false	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	4	1500000000000000000000000	0x0000000000000000000000000000000000000000	15656062	2025-03-24T13:29:20.000Z	0x8db4f29a7e318ce1411174715a486ee06e4be10eddb533ff5673da3db8bb29c0
0x596b0401479f6dfe1caf8c12838311fee742b95c	false	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	4	4000000000000000000000000	0x0000000000000000000000000000000000000000	17970955	2025-04-03T19:26:39.000Z	0x1ec04d1465420515aad7938c8021c44ba50da3e09b32b6a854f0c55173a66e55

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

OETHVault_Mint_event

OETHVault_Redeem_event

OETHVault_RedeemFeeUpdated_event

OETHVault_YieldDistribution_event

OS_TotalSupplyUpdatedHighres_event

OSVault_Mint_event

OSVault_Redeem_event

OSVault_RedeemFeeUpdated_event

OSVault_YieldDistribution_event

OSZapper_Zap_event

wOSStrategy_Deposit_event

wOSStrategy_Withdrawal_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​OETHVault_Mint_event

​OETHVault_Redeem_event

​OETHVault_RedeemFeeUpdated_event

​OETHVault_YieldDistribution_event

​OS_TotalSupplyUpdatedHighres_event

​OSVault_Mint_event

​OSVault_Redeem_event

​OSVault_RedeemFeeUpdated_event

​OSVault_YieldDistribution_event

​OSZapper_Zap_event

​wOSStrategy_Deposit_event

​wOSStrategy_Withdrawal_event

Tables

OETHVault_Mint_event

OETHVault_Redeem_event

OETHVault_RedeemFeeUpdated_event

OETHVault_YieldDistribution_event

OS_TotalSupplyUpdatedHighres_event

OSVault_Mint_event

OSVault_Redeem_event

OSVault_RedeemFeeUpdated_event

OSVault_YieldDistribution_event

OSZapper_Zap_event

wOSStrategy_Deposit_event

wOSStrategy_Withdrawal_event