woofi_v1_bsc

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
0xec054126922a9a1918435c9072c32f1b60cb2b90	false	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	400000000000000000000	0x438baaff63af83549020fead36c7de167384463a	92	26219334	2023-03-06T03:46:20.000Z	0x64ee1ea1b9d25567711be2f6ada9e4151d5382d475620ae57fd8ea2202ca226e
0xec054126922a9a1918435c9072c32f1b60cb2b90	false	0xe9e7cea3dedca5984780bafc599bd69add087d56	50000000000000000000000	0x2caa3e79bc0e23abf31dfbcebae992bcad4e7c7a	120	24937803	2023-01-20T02:15:04.000Z	0xd335492d7f36784347b0e87f41ab0a346bd4f297a8a18841bf4a8726680f3376
0xec054126922a9a1918435c9072c32f1b60cb2b90	false	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	300000000000000000000	0x438baaff63af83549020fead36c7de167384463a	67	26674054	2023-03-22T03:00:17.000Z	0x919965af4bd1fb2c8a79534c4226d00777e08c7169b1154731df06430471c3e1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.woofi_v1_bsc.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
0xec054126922a9a1918435c9072c32f1b60cb2b90	false	0x2170ed0880ac9a755fd29b2688956bd959f933f8	16946300320261895081	338	0xa0fa9c6fa8a5dad6beff9f12ead2e7d5e8d14e2c	27274959	2023-04-12T05:30:04.000Z	0xfc4d2c1a11c6baf9bee9c914583f4f4ddfe2c837fdfaf36ff60074518d569010
0xec054126922a9a1918435c9072c32f1b60cb2b90	false	0x4691937a7508860f876c9c0a2a617e7d9e945d4b	661647710870709105855617	33	0xa0fa9c6fa8a5dad6beff9f12ead2e7d5e8d14e2c	27274934	2023-04-12T05:28:49.000Z	0xb64d5236beaa84a0a1d2781283474c2b57c9468a7354ada32e28ae4e3b96fd3e
0xec054126922a9a1918435c9072c32f1b60cb2b90	false	0x55d398326f99059ff775485246999027b3197955	229681382807197615098451	174	0xa0fa9c6fa8a5dad6beff9f12ead2e7d5e8d14e2c	27274924	2023-04-12T05:28:19.000Z	0x015a24b9ec960bf53d50d5aefd84328443e8b77128eacf337f454783f84ce2b2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.woofi_v1_bsc.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
0x18101ac1d35230f1a3c005e2abaaeb25cae79e7f	0xec054126922a9a1918435c9072c32f1b60cb2b90	0xc90bfe9951a4efbf20aca5ecd9966b2bf8a01294	false	35	1002950988591312	4011803954365248841	0xe9e7cea3dedca5984780bafc599bd69add087d56	0x910bf2d50fa5e014fd06666f456182d4ab7c8bd2	4010801003376657529	24778651	0x2170ed0880ac9a755fd29b2688956bd959f933f8	2626462578947645	2023-01-14T12:13:35.000Z	0x71aac3dbfda1b4c0732a27ca7f5c5c75b03326e14a6c5ff679830a13ccc7550b
0x2c69fa8557edb5f115a7ed14dfb9febcb36196a6	0xec054126922a9a1918435c9072c32f1b60cb2b90	0xdec876911cbe9428265af0d12132c52ee8642a99	false	70	114929981562333577	459719926249334310000	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	0x353c1f0bc78fbbc245b3c93ef77b1dcc5b77d2a0	1511899836582406470	24787539	0x2170ed0880ac9a755fd29b2688956bd959f933f8	300000000000000000	2023-01-14T19:42:49.000Z	0x444e4579f26f68493011a287ccfd8ebb377532078454493c0793dc3e89a6b0c6
0x884be30e2c95b9cfed614ad2b5edf40af2a144ad	0xec054126922a9a1918435c9072c32f1b60cb2b90	0xdec876911cbe9428265af0d12132c52ee8642a99	false	94	38299536217182240	153198144868728960000	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	0x353c1f0bc78fbbc245b3c93ef77b1dcc5b77d2a0	505209087514333012	24786396	0x2170ed0880ac9a755fd29b2688956bd959f933f8	100000000000000000	2023-01-14T18:44:55.000Z	0x911c9150f911d1c8c961bc63db7de618b003309a4cb04e8e1b08a273b34a0778

Example Query

Query with partition filter

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