woofi_v1_fantom

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
0x286ab107c5e9083dbed35a2b5fb0242538f4f9bf	false	0x6626c47c00f1d87902fc13eecfac3ed06d5e8d8a	700000000000000000000000	0x620678ee4ff042f148579fcfc74870244f0fef89	1	57498395	2023-03-13T07:54:11.000Z	0xaee3c12bfcdfb42c4036541c4ac6dec0fc93da1f435d741ccc5b35d0d7181e02
0x286ab107c5e9083dbed35a2b5fb0242538f4f9bf	false	0x04068da6c83afcfa0e13ba15a6696662335d5b75	20000000000	0x05c97e74ad8d84ef457994b9b394d0cc46ee6e76	7	63804302	2023-06-09T03:54:09.000Z	0x68da9077a92382f70a0a5952ca76248c68ac44e712e281d63b59c4d46208215f
0x286ab107c5e9083dbed35a2b5fb0242538f4f9bf	false	0x04068da6c83afcfa0e13ba15a6696662335d5b75	25000000000	0x05c97e74ad8d84ef457994b9b394d0cc46ee6e76	20	63802538	2023-06-09T02:48:13.000Z	0xcf45f2b5540bd200f910afc48de1fb34096e5cbceaef7d6aa226bfd2a716f170

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.woofi_v1_fantom.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
0x286ab107c5e9083dbed35a2b5fb0242538f4f9bf	false	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	2340000000000000000000	2	0xea02dcc6fe3ec1f2a433ff8718677556a3bb3618	53534029	2023-01-10T12:10:48.000Z	0xeff488e317a976da882355c42e2bd8472d7807cd7a8dbf59ee7fceb710b11ab8
0x286ab107c5e9083dbed35a2b5fb0242538f4f9bf	false	0x74b23882a30290451a17c44f4f05243b6b58c76d	70000000000000000	2	0xea02dcc6fe3ec1f2a433ff8718677556a3bb3618	53534070	2023-01-10T12:12:47.000Z	0x3abaf829cb646e45d727115d4af90bf73ee92285991b31ad8c666d703b2d7af2
0x286ab107c5e9083dbed35a2b5fb0242538f4f9bf	false	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	350000000000000000000	2	0xea02dcc6fe3ec1f2a433ff8718677556a3bb3618	53534115	2023-01-10T12:14:34.000Z	0x35e7fb0c78fde51c14c83cd8637e5a3fddb70e1ac4dfb1a205824e843ae080b3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.woofi_v1_fantom.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
0x0433305ae161d28ed1408d11581610339dfc9be4	0x286ab107c5e9083dbed35a2b5fb0242538f4f9bf	0x3319161b131401124e61ffcdff0aa7f6fdcbbfed	false	195	2065	8263516	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	0x3319161b131401124e61ffcdff0aa7f6fdcbbfed	19895241790702257009	57555948	0x04068da6c83afcfa0e13ba15a6696662335d5b75	8263516	2023-03-14T08:10:06.000Z	0x4ea67f9487d6011cb68deb09cddb8c29fb78622859e7defc585b3731842d4b52
0x0433305ae161d28ed1408d11581610339dfc9be4	0x286ab107c5e9083dbed35a2b5fb0242538f4f9bf	0x3319161b131401124e61ffcdff0aa7f6fdcbbfed	false	2	1821	7284582	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	0x3319161b131401124e61ffcdff0aa7f6fdcbbfed	17303671076695023662	57550535	0x04068da6c83afcfa0e13ba15a6696662335d5b75	7284582	2023-03-14T05:46:24.000Z	0x690dccefa833f32b8c877f4661b38da06120f90028ec1630d39eb9aea8404a66
0x054ed3a0202bad05999f5f3887a84e1a8032e8f9	0x286ab107c5e9083dbed35a2b5fb0242538f4f9bf	0x3319161b131401124e61ffcdff0aa7f6fdcbbfed	false	3	623	2495554	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	0x3319161b131401124e61ffcdff0aa7f6fdcbbfed	6051851071774621545	57558476	0x04068da6c83afcfa0e13ba15a6696662335d5b75	2495554	2023-03-14T09:32:07.000Z	0xbd3199aaf1a33ffb0bd1ffd1e96f6ac37df1c06b6a7fa4b50da21cf1f982ca0f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.woofi_v1_fantom.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