woofi_v1_avalanche

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
0x3b3e4b4741e91af52d0e9ad8660573e951c88524	false	0x152b9d0fdc40c096757f570a51e494bd4b943e50	300000000	0x697c97a37bc00c2306f2b08ca14f3d55db6ffccd	14	24796984	2023-01-11T09:57:39.000Z	0xef94da698b33d2611b92bad9ca8170d557689af91d2381deffc87db544effe4f
0x3b3e4b4741e91af52d0e9ad8660573e951c88524	false	0x152b9d0fdc40c096757f570a51e494bd4b943e50	2025491001	0xd63009913b652bed61b0a22de305d1812a2347d0	18	24797069	2023-01-11T10:00:40.000Z	0x10aa4531789aeaa7d3f0bbf2642f5fc89029850fa0d5b4c0737c67f346f37fff
0x3b3e4b4741e91af52d0e9ad8660573e951c88524	false	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	26090527814759156310	0xd63009913b652bed61b0a22de305d1812a2347d0	21	24797069	2023-01-11T10:00:40.000Z	0x10aa4531789aeaa7d3f0bbf2642f5fc89029850fa0d5b4c0737c67f346f37fff

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.woofi_v1_avalanche.WooPPV2_Deposit_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
0x3b3e4b4741e91af52d0e9ad8660573e951c88524	false	0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7	100000000000	19	0xd63009913b652bed61b0a22de305d1812a2347d0	29230755	2023-04-26T03:52:56.000Z	0x9ca16a0e295921c296d433d87d9a2866f24fcf8dafeca166346c989f0988e190
0x3b3e4b4741e91af52d0e9ad8660573e951c88524	false	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	150000000000	14	0xd63009913b652bed61b0a22de305d1812a2347d0	29230599	2023-04-26T03:47:39.000Z	0x6acfe749011c984220094eeeeb7782bb9b45a124e2bb2ca4d6f5b4e72f8385f0
0x3b3e4b4741e91af52d0e9ad8660573e951c88524	false	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	100000000000	5	0xd63009913b652bed61b0a22de305d1812a2347d0	34190167	2023-08-21T07:34:05.000Z	0x92a5d5c697f91f02442fbd8066cd2554bc17e93d33651b532905eca36648653b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.woofi_v1_avalanche.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
0x1784b2ff6841d46163fbf817b3feb98a0e163e0f	0x3b3e4b4741e91af52d0e9ad8660573e951c88524	0xd4f65bee477ba1a9b892b23aec3725407035f0a0	false	2	23169	92676866	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	0x0000000000000000000000000000000000000000	92653697	30939788	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	6253231778815055872	2023-06-05T12:06:17.000Z	0xe1f88499a1821e9b4a13dd1cf5d8309ca062638c4e82527c79a52a7760bd7da3
0x1f076a800005c758a505e759720eb6737136e893	0x3b3e4b4741e91af52d0e9ad8660573e951c88524	0xae1e7e4c5743321d2a8ceed179264998a56cf1d9	false	2	1000	4000000	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	0xea8e147bdb3ee3dde2085acb88de826e1a6de37a	2205392524252657	30960423	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	4000000	2023-06-05T23:58:46.000Z	0xdddf8b2fed74b26f881a6eabf1fe92e62a73e0d816232f44e2a2e8b8ccb411b0
0x3895566c6060a9974a880a36d62cd69c7c239e40	0x3b3e4b4741e91af52d0e9ad8660573e951c88524	0xd4f65bee477ba1a9b892b23aec3725407035f0a0	false	2	12098	48393644	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	0x0000000000000000000000000000000000000000	48381546	30954852	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	3480066546467721216	2023-06-05T20:40:00.000Z	0x0974338f2893d2824521698b65f40df3aaa70978f1af265f743d5c12ff308aa3

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

WooPPV2_Deposit_event

WooPPV2_Withdraw_event

WooPPV2_WooSwap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​WooPPV2_Deposit_event

​WooPPV2_Withdraw_event

​WooPPV2_WooSwap_event

Tables

WooPPV2_Deposit_event

WooPPV2_Withdraw_event

WooPPV2_WooSwap_event