pooltogether_v4_avalanche

Tables

PrizeDistributor_ClaimedDraw_event

Prize claim events from PoolTogether V4 lottery protocol on Avalanche, recording when users claim winnings from specific draw rounds. Tracks payout amounts per draw ID for analyzing prize distribution patterns and winner 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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_drawId`	`STRING`	Unique identifier for a prize draw in the PoolTogether lottery protocol. Numeric string representing the sequential draw number.
`in_payout`	`STRING`	Payout amount awarded to the player or winner. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_drawId	in_payout	log_index	block_number	block_timestamp	transaction_hash
0x83332f908f403ce795d90f677ce3f382fe73f3d1	0x8eb441e80563e1b400981a2a4bd9678bd703dc31	false	226	4999994	10	16517409	2022-06-25T23:01:03.000Z	0x855aec59323b38908844d0f4671418d6998c1130f7f6841cc7dedd0c199949a7
0x83332f908f403ce795d90f677ce3f382fe73f3d1	0xd4ed9a5861209d4445bc938ff9ebb4cae82537f8	false	247	4999994	31	16501815	2022-06-25T14:20:44.000Z	0x7b8c4347ee278fcc44b8d1e5a210a3c9d59f310ae8904b354d4f41514eaeb11f
0x83332f908f403ce795d90f677ce3f382fe73f3d1	0xd4ed9a5861209d4445bc938ff9ebb4cae82537f8	false	249	4999994	33	16501815	2022-06-25T14:20:44.000Z	0x7b8c4347ee278fcc44b8d1e5a210a3c9d59f310ae8904b354d4f41514eaeb11f

Example Query

Query with partition filter

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

YieldSourcePrizePool_Deposited_event

PoolTogether V4 deposit events recording token contributions to yield-generating prize pools. Captures operator, recipient, token address, and deposit amount for tracking user participation in the no-loss lottery protocol.

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_operator`	`STRING`	Address authorized to execute the operation on behalf of the token owner. 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_token`	`STRING`	Token address involved in 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

in_to	address	removed	in_token	in_amount	log_index	in_operator	block_number	block_timestamp	transaction_hash
0x8755491263b0f40318905cbe3594ba8cd3f95189	0xf830f5cb2422d555ec34178e27094a816c8f95ec	false	0xb27f379c050f6ed0973a01667458af6ecebc1d90	100000000	27	0x8755491263b0f40318905cbe3594ba8cd3f95189	25077469	2023-01-17T23:49:23.000Z	0xd4b6c168d701c378f2965883f50c00b4c0b457ab3272c548a9cdf932ed5d10e2
0xeb7cb9ba24917aa4efae36d292ec11b1f05a91c0	0xf830f5cb2422d555ec34178e27094a816c8f95ec	false	0xb27f379c050f6ed0973a01667458af6ecebc1d90	2000000	19	0xeb7cb9ba24917aa4efae36d292ec11b1f05a91c0	32890624	2023-07-21T13:00:53.000Z	0xdb07135d46f59fa86cee063eb3778f6ce694cd1c4a1b7124d9be37a7673a8c1b
0x86c16f44bc75851a9e2e16e28366add78169fea9	0xf830f5cb2422d555ec34178e27094a816c8f95ec	false	0xb27f379c050f6ed0973a01667458af6ecebc1d90	20192533	24	0x86c16f44bc75851a9e2e16e28366add78169fea9	17612547	2022-07-21T10:18:05.000Z	0xc62ef17c862fb71d7eafb7ccb64ea37e07d71093ed7a45c893b39187d0805458

Example Query

Query with partition filter

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

YieldSourcePrizePool_Withdrawal_event

Withdrawal events from PoolTogether V4 yield source prize pools recording token redemptions and operator-authorized transfers. Tracks user address, token contract, withdrawal amount, and redeemed quantity for prize pool exit operations.

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_operator`	`STRING`	Address authorized to execute the operation on behalf of the token owner. Hex-encoded, 0x-prefixed, 42-character string.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in 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.
`in_redeemed`	`STRING`	Amount of underlying yield-bearing tokens redeemed in the withdrawal operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_from	removed	in_token	in_amount	log_index	in_operator	in_redeemed	block_number	block_timestamp	transaction_hash
0xf830f5cb2422d555ec34178e27094a816c8f95ec	0x3bc1158e5bce8c10e5da0edfbb94b261eec46a76	false	0xb27f379c050f6ed0973a01667458af6ecebc1d90	10000000	70	0x3bc1158e5bce8c10e5da0edfbb94b261eec46a76	10000000	8905449	2021-12-30T09:44:02.000Z	0xeac74fd25e93f9d54c68265165bfbae6614ce53a0732a2caed0bb17005bf6e9d
0xf830f5cb2422d555ec34178e27094a816c8f95ec	0x82195047910c3874731a8e285ebcce4fdc6ffc53	false	0xb27f379c050f6ed0973a01667458af6ecebc1d90	15000000	157	0x82195047910c3874731a8e285ebcce4fdc6ffc53	15000000	8890868	2021-12-30T01:33:29.000Z	0xac0835545da4c4886d023112ee74b3d00a779a042ce89ba5eea739352acaa4a2
0xf830f5cb2422d555ec34178e27094a816c8f95ec	0x4efb6f1ed351526cc0a58aca0cd210dc447ec6f3	false	0xb27f379c050f6ed0973a01667458af6ecebc1d90	100000000	53	0x4efb6f1ed351526cc0a58aca0cd210dc447ec6f3	100000000	8908269	2021-12-30T11:18:34.000Z	0xeff22287c97b97d5765894c3f63fa033cd1254ddab22ed2306a516b4cfbf7a2b

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

PrizeDistributor_ClaimedDraw_event

YieldSourcePrizePool_Deposited_event

YieldSourcePrizePool_Withdrawal_event

​Tables

​PrizeDistributor_ClaimedDraw_event

​YieldSourcePrizePool_Deposited_event

​YieldSourcePrizePool_Withdrawal_event

Tables

PrizeDistributor_ClaimedDraw_event

YieldSourcePrizePool_Deposited_event

YieldSourcePrizePool_Withdrawal_event