woofi_v1_optimism

Tables

WooPPV2_Deposit_event

Token deposit events emitted by WooFi V2 liquidity pool contracts (WooPPV2). Contains sender address, deposited token address, and deposit amount for tracking liquidity provider contributions.

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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_token	in_amount	in_sender	log_index	block_number	block_timestamp	transaction_hash
0xd1778f9df3eee5473a9640f13682e3846f61febc	false	0x7f5c764cbc14f9669b88837ca1490cca17c31607	35000000000	0x758231b7d5204d08634dd3f9fcdf49fc17355d33	13	68816390	2023-01-18T02:32:10.000Z	0xe3b0d528d56df5d0f8c00ab52f9dacf05f6ab86eb0848e3a0354fb50d0e39494
0xd1778f9df3eee5473a9640f13682e3846f61febc	false	0x4200000000000000000000000000000000000006	17000000000000000000	0x1ddd225ef26714bb8055ddceaee2589ba09c89ed	13	68817787	2023-01-18T02:40:56.000Z	0x565b978026f336da5c7f3abc385081719047c1f01837a605325b8947b897f8ba
0xd1778f9df3eee5473a9640f13682e3846f61febc	false	0x4200000000000000000000000000000000000006	15000000000000000000	0x1ddd225ef26714bb8055ddceaee2589ba09c89ed	13	72666665	2023-02-07T02:18:41.000Z	0xc4cf94b2d6a1893466c40beb1552030ca05b8a9fb768d13ab57c3b2361f21f19

Example Query

Query with partition filter

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

WooPPV2_FeeAddrUpdated_event

Fee address configuration change events from WOO Finance V2 perpetuals protocol (WooPPV2) on Optimism. Tracks updates to the fee collection address for protocol revenue monitoring and governance 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_newFeeAddr`	`STRING`	New fee recipient address set in the WooPPV2 contract update event. Hex-encoded, 0x-prefixed 40-character Ethereum address on Optimism receiving protocol fees.

Sample Data

address	removed	log_index	block_number	in_newFeeAddr	block_timestamp	transaction_hash
0xd1778f9df3eee5473a9640f13682e3846f61febc	false	0	43779410	0xa058798cd293f5acb4e7757b08c960a79f527699	2022-11-30T07:00:49.000Z	0x2e4eedb9a2811f53f0fc5de2655008181a10aa4f75dded3fcd94b0b8a3b23dfd

Example Query

Query with partition filter

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

WooPPV2_Withdraw_event

WOO Protocol Pool Version 2 withdraw events emitted when tokens are withdrawn from liquidity pools. Contains token address, withdrawal amount in smallest denomination, and recipient address for tracking pool outflows and liquidity removal.

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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. 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_token	in_amount	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0xd1778f9df3eee5473a9640f13682e3846f61febc	false	0x4200000000000000000000000000000000000006	630936649356757484	13	0x1ddd225ef26714bb8055ddceaee2589ba09c89ed	114547338	2024-01-08T05:57:33.000Z	0x419369a5ecbe24b3ac0bdcdd89f4f6c778c18899f42a1b424d63ca0e42d4f5e5
0xd1778f9df3eee5473a9640f13682e3846f61febc	false	0x7f5c764cbc14f9669b88837ca1490cca17c31607	7994980160	38	0x758231b7d5204d08634dd3f9fcdf49fc17355d33	114547348	2024-01-08T05:57:53.000Z	0xb9ce35f14f105de2516238345fb57242cf508e6660fb8b7eff81568b4ca4289b
0xd1778f9df3eee5473a9640f13682e3846f61febc	false	0x7f5c764cbc14f9669b88837ca1490cca17c31607	200000000000	186	0x309adf99af00d4a68b58df1d894369009314d880	116322910	2024-02-18T08:23:17.000Z	0xca92c983a0df235b225037de8f3f96753d07f50af8a557868a9d8d920779febf

Example Query

Query with partition filter

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

WooPPV2_WooSwap_event

WooSwap event logs emitted by WooPPV2 contracts recording token swap transactions. Contains sender and recipient addresses, token pair details, swap amounts, fees, and optional rebate recipient for tracking DEX trading 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_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_rebateTo`	`STRING`	Address designated to receive swap fee rebates. Hex-encoded, 0x-prefixed, 42-character string or zero address if no rebate recipient.
`in_swapVol`	`STRING`	Total swap volume for the transaction denominated in the quote token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_swapFee`	`STRING`	Fee charged for executing the swap transaction. String-encoded integer value representing the fee amount in the smallest denomination of the token.

Sample Data

in_to	address	in_from	removed	log_index	in_swapFee	in_swapVol	in_toToken	in_rebateTo	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x0469bfa9580a895be4d5a2c81df5a4a2aa149e2a	0xd1778f9df3eee5473a9640f13682e3846f61febc	0xeaf1ac8e89ea0ae13e0f03634a4ff23502527024	false	7	4923	98464848	0x94b008aa00579c1307b0ef2c499ad98a8ce58e58	0x0469bfa9580a895be4d5a2c81df5a4a2aa149e2a	98470832	115437474	0x0b2c639c533813f4aa9d7837caf62653d097ff85	98450088	2024-01-28T20:28:45.000Z	0x0e759b9b9e491dd347f9f68cb7aceee5eedda27c4d99c39a40682c239b72d87c
0x07e7c6c2c6165f10159a93683fa2c9d41a80e837	0xd1778f9df3eee5473a9640f13682e3846f61febc	0xeaf1ac8e89ea0ae13e0f03634a4ff23502527024	false	36	23823	476471692	0x94b008aa00579c1307b0ef2c499ad98a8ce58e58	0x07e7c6c2c6165f10159a93683fa2c9d41a80e837	476513592	115413288	0x0b2c639c533813f4aa9d7837caf62653d097ff85	476387857	2024-01-28T07:02:33.000Z	0x42c04f856466ef6aa265d111be7ca953fadc5ee246dfd546a50d72d7c08be43a
0x0825b2f46dbba2d05cfc1879fe91e2b360733766	0xd1778f9df3eee5473a9640f13682e3846f61febc	0x0825b2f46dbba2d05cfc1879fe91e2b360733766	false	6	6358	127176309	0x7f5c764cbc14f9669b88837ca1490cca17c31607	0x0771483e9ad0d8c452efbca3451e4e56249b64bd	127169951	115430543	0x0b2c639c533813f4aa9d7837caf62653d097ff85	127145353	2024-01-28T16:37:43.000Z	0xafe2e70f40e13542a9b1dbd89574b4c33ee5d49bc81d3693067c60395fdbdd26

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

WooPPV2_Deposit_event

WooPPV2_FeeAddrUpdated_event

WooPPV2_Withdraw_event

WooPPV2_WooSwap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​WooPPV2_Deposit_event

​WooPPV2_FeeAddrUpdated_event

​WooPPV2_Withdraw_event

​WooPPV2_WooSwap_event

Tables

WooPPV2_Deposit_event

WooPPV2_FeeAddrUpdated_event

WooPPV2_Withdraw_event

WooPPV2_WooSwap_event