pooltogether_v4_optimism

Tables

PrizeDistributor_ClaimedDraw_event

Prize claim events from PoolTogether V4 lottery protocol on Optimism, recording when users claim winnings from specific draw rounds. Tracks individual prize payouts with draw identifiers and user addresses for analyzing winner distribution and claim patterns.

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
0x722e9bfc008358ac2d445a8d892cf7b62b550f3f	0x6b44862103b8a45f5ec701b69ec28a5d6d304950	false	698	99999980	5	109599784	2023-09-15T17:19:05.000Z	0x7e5a5917c899ab5d8be84279d714795e44da8268eeef43627a411d73b892528b
0x722e9bfc008358ac2d445a8d892cf7b62b550f3f	0x93146d9978d286ee085ba68ee1786a0b6eda64ec	false	646	9999993	15	109598043	2023-09-15T16:21:03.000Z	0x8552539786c11b09ea33e08884b03d64a40b891c816ac38ea56ef501e83fbc9f
0x722e9bfc008358ac2d445a8d892cf7b62b550f3f	0x93146d9978d286ee085ba68ee1786a0b6eda64ec	false	673	9999993	17	109598043	2023-09-15T16:21:03.000Z	0x8552539786c11b09ea33e08884b03d64a40b891c816ac38ea56ef501e83fbc9f

Example Query

Query with partition filter

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

TwabRewards_RewardsClaimed_event

Reward claim events from PoolTogether V4’s TWAB (Time-Weighted Average Balance) rewards system on Optimism, tracking token distributions to depositors across promotional campaigns and epoch periods. Used for analyzing incentive program participation and payout patterns.

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_promotionId`	`STRING`	Identifier for the specific PoolTogether reward promotion from which tokens are being claimed. Numeric string values (e.g., “7”, “8”) distinguish different promotional campaigns offering rewards to depositors.
`in_epochIds`	`ARRAY<INT64>`	Array of epoch identifiers for which rewards are being claimed in this transaction. Each promotion is divided into time-based epochs, and users can claim accumulated rewards across multiple epochs simultaneously.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol 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	in_user	removed	in_amount	log_index	in_epochIds	block_number	in_promotionId	block_timestamp	transaction_hash
0x1470c87e2db5247a36c60de3d65d7c972c62ea0f	0x244ec27908974162dee23fe96b6f1fe9b6ea2809	false	192700533981597829	2	[0,1,2,3,4,5,6,7]	114957133	7	2024-01-17T17:37:23.000Z	0x48042385a4b0dfea1c56f3584d644820dbef8d978010eb50af24bc9c3666ee82
0x1470c87e2db5247a36c60de3d65d7c972c62ea0f	0x7b5de5e29c5c1ddf4f8e15d93d0afc4f8fc6002c	false	11801972497108879	119	[7]	114950119	7	2024-01-17T13:43:35.000Z	0xd25afa7c0b88f170de2e84e0f1ff4abd921316e852702c28f77eef6399628504
0x1470c87e2db5247a36c60de3d65d7c972c62ea0f	0xd0d3c22129c9d53c6c5f0bda74c46e2c4ffbff5a	false	144142881806223088	526	[0,1,2,3,4,5,6,7]	114952219	7	2024-01-17T14:53:35.000Z	0x8baa21c037ce94b229610486430f3f0fa61f0bb73a0b53ef8e1b0e650d59ccf6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pooltogether_v4_optimism.TwabRewards_RewardsClaimed_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
0x2f36fb6ec203c701fa786e737be8b0f6e651fd67	0x79bc8bd53244bc8a9c8c27509a2d573650a83373	false	0x62bb4fc73094c83b5e952c2180b23fa7054954c4	2000000	14	0x2f36fb6ec203c701fa786e737be8b0f6e651fd67	72328964	2023-02-05T00:59:07.000Z	0x703a82e72a3e35b68a5ec94e54d21e08175bf238a61c6fa4f3acb413a71267ce
0x77df96e69ad2aaf27766b72fe9b15fe17be7f9fa	0x79bc8bd53244bc8a9c8c27509a2d573650a83373	false	0x62bb4fc73094c83b5e952c2180b23fa7054954c4	2000000	14	0x77df96e69ad2aaf27766b72fe9b15fe17be7f9fa	72435246	2023-02-05T17:13:12.000Z	0x70cd65df229b79384763095f2715f3ecba4e471d44e7a60d25c4fd74b2154314
0x9425129bc5ec9b4f385303b77215cac44727479e	0x79bc8bd53244bc8a9c8c27509a2d573650a83373	false	0x62bb4fc73094c83b5e952c2180b23fa7054954c4	2000000	14	0x9425129bc5ec9b4f385303b77215cac44727479e	72345227	2023-02-05T04:06:12.000Z	0xaea21cece8b74b1600d9d1ffa26f0cbe8f90517496fd198e6ced8e693996e19a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pooltogether_v4_optimism.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
0x79bc8bd53244bc8a9c8c27509a2d573650a83373	0x251f12b82ea9d6eef3b2210891a34a3c21b5a081	false	0x62bb4fc73094c83b5e952c2180b23fa7054954c4	4300000	11	0x251f12b82ea9d6eef3b2210891a34a3c21b5a081	4300000	18065845	2022-08-06T14:14:42.000Z	0x6c8beb0b84467fae1a78bf841d8df6cac459e633912a0b58cf147f975a152f7a
0x79bc8bd53244bc8a9c8c27509a2d573650a83373	0xe302b0fd3c0da272dfa99abd91b69566c63252c4	false	0x62bb4fc73094c83b5e952c2180b23fa7054954c4	70000000	11	0xe302b0fd3c0da272dfa99abd91b69566c63252c4	70000000	17980437	2022-08-06T00:16:28.000Z	0x1e1f2e0528b58a86c63727c6fe3e3e365ee57083c009adea917db8de2e4071ed
0x79bc8bd53244bc8a9c8c27509a2d573650a83373	0xa7ed40bb516d24cdbb334e92f09e9a8367205a55	false	0x62bb4fc73094c83b5e952c2180b23fa7054954c4	70000000	11	0xa7ed40bb516d24cdbb334e92f09e9a8367205a55	70000000	18023790	2022-08-06T07:42:35.000Z	0xcf4d31b6148ba5416dfd92778bef6208e19b09fdcf5a2f8e7a1a95cac9a86841

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

PrizeDistributor_ClaimedDraw_event

TwabRewards_RewardsClaimed_event

YieldSourcePrizePool_Deposited_event

YieldSourcePrizePool_Withdrawal_event

​Tables

​PrizeDistributor_ClaimedDraw_event

​TwabRewards_RewardsClaimed_event

​YieldSourcePrizePool_Deposited_event

​YieldSourcePrizePool_Withdrawal_event

Tables

PrizeDistributor_ClaimedDraw_event

TwabRewards_RewardsClaimed_event

YieldSourcePrizePool_Deposited_event

YieldSourcePrizePool_Withdrawal_event