pooltogether_v4_ethereum

Tables

PrizeDistributor_ClaimedDraw_event

Prize claim events from PoolTogether V4 on Ethereum recording when users collect winnings from specific draw IDs. Used for analyzing prize distribution patterns, winner behavior, and payout amounts across lottery draws.

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
0xb9a179dca5a7bf5f8b9e088437b3a85ebb495efe	0xa8b5c87a0566539bb954254d2e7fcc63b43ef5d6	false	104	999998	84	14274732	2022-02-25T10:34:00.000Z	0x89289c214d1a4d5aa9cb168de1b6fe77a17c404d88f67dd9c6c8295b4db948c4
0xb9a179dca5a7bf5f8b9e088437b3a85ebb495efe	0x20b54a8fa6713adb32c097e3401ed48454ae1b08	false	674	99999984	186	18167312	2023-09-19T03:34:23.000Z	0x6f645aabab17e121498c945f4ad75fea8ad99738ad7013520170c7277474d313
0xb9a179dca5a7bf5f8b9e088437b3a85ebb495efe	0x21b65759c6309e000703c918d146c4a6fd3c6af9	false	663	99999984	150	18167163	2023-09-19T03:04:11.000Z	0xb921b33b20589205f800fba216dd2ce191eb02af8a273a407d84f6f046105f86

Example Query

Query with partition filter

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

Rewards_Claimed_event

Reward claim events from PoolTogether V4 prize savings protocol on Ethereum, tracking user addresses and token amounts distributed. Contains block-level transaction data for analyzing prize distribution patterns and claiming behavior across the protocol’s no-loss lottery system.

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_newTokens`	`STRING`	Amount of tokens claimed by the user in the event. Integer value stored as string representing the smallest token unit.

Sample Data

address	in_user	removed	log_index	block_number	in_newTokens	block_timestamp	transaction_hash
0x9a29401ef1856b669f55ae5b24505b3b6faeb370	0xbd5361a94c803d26240a6b5586710ab48ed1d9dd	false	126	13658636	20842719424062494753	2021-11-21T14:10:34.000Z	0x82b42f78feb8465eaaaf999b02064d9bea13913da78cc7815d1b4a1fa42ee21f
0x30430419b86e9512e6d93fc2b0791d98dbeb637b	0xaa9e424439209e642b52d3af8c875d8340566ac4	false	528	13657230	17010363103787964530	2021-11-21T08:58:55.000Z	0x0327da9246b16b7026e7cac7c34acd49c23bcf4c9c7289c2a1eb68a3fe480409
0x9a29401ef1856b669f55ae5b24505b3b6faeb370	0x21d4e34b6469a885b8c4f220df24af0f8a654d4d	false	46	16017974	160824028817012292923	2022-11-21T11:05:11.000Z	0x89e41e5ee47875c556bab80ec43e20c0f26955867110341ba0abe1f2313f8aaa

Example Query

Query with partition filter

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

TokenFaucet_Claimed_event

Token reward claims from PoolTogether V4 faucet contracts on Ethereum, recording when users claim accrued incentive tokens with claim amounts and faucet addresses. Used for analyzing reward distribution patterns and user engagement with liquidity mining programs.

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_newTokens`	`STRING`	Amount of tokens claimed by the user in the event. Integer value stored as string representing the smallest token unit.

Sample Data

address	in_user	removed	log_index	block_number	in_newTokens	block_timestamp	transaction_hash
0xbd537257fad96e977b9e545be583bbf7028f30b9	0x122cedcbeea359a03b9e5c22ff17d171d585eb1d	false	232	16462795	115071250871903639	2023-01-22T13:59:23.000Z	0xa0383f5deb1e7775aaf258e3c92e8329d4993f3f0dce1b5b5e299af9184d7045
0xf362ce295f2a4eae4348ffc8cdbce8d729ccb8eb	0x96c28f1bc8e4f08a5e98c402a9d9750517c4301b	false	240	13557972	301282724884490710000	2021-11-05T17:31:16.000Z	0x3bfcba18f8d81014c94faf7af1df5ae2bff631e1d21d20bc6d3a87508f33902d
0x72f06a78bbaac0489067a1973b0cef61841d58bc	0xabba3179bd6dc2e5d4e15278a7903a5208395ae7	false	76	13556479	19178445111999575	2021-11-05T12:01:24.000Z	0x0698eb1f47c796b2767fb61b4c31d82d3a92dcbe3a6bb385db34d1b2370439d3

Example Query

Query with partition filter

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

TokenFaucetFactory_ProxyCreated_event

Factory deployment events for PoolTogether V4 token faucet proxies on Ethereum. Records proxy contract addresses created by the factory for tracking drip distribution contract deployments.

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_proxy`	`STRING`	Contract address of the newly created proxy contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_proxy	log_index	block_number	block_timestamp	transaction_hash
0xe19fe7a9aa49585510041ecde274f6926c212c43	false	0xbd537257fad96e977b9e545be583bbf7028f30b9	137	11876980	2021-02-17T22:08:49.000Z	0x288342cd3fee03b989ded4debd9e933f21eb795378302225543f5761656c7c73
0xe19fe7a9aa49585510041ecde274f6926c212c43	false	0xf362ce295f2a4eae4348ffc8cdbce8d729ccb8eb	250	11876960	2021-02-17T22:05:52.000Z	0xb9bfcf1e28d18180445a17fc7f78000d90048dad10aff22767e0250f16da5b29
0xe19fe7a9aa49585510041ecde274f6926c212c43	false	0x72f06a78bbaac0489067a1973b0cef61841d58bc	203	11877020	2021-02-17T22:19:55.000Z	0xc3a899171867a294fb23521597ac71693646cbd133b6feb509b60f81536dd1da

Example Query

Query with partition filter

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

TokenFaucetFactoryV2_ProxyCreated_event

Factory deployment events for PoolTogether V4 token faucet proxies on Ethereum, capturing each new faucet instance creation with its proxy contract address. Used for tracking the expansion of reward distribution infrastructure across different prize pools.

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_proxy`	`STRING`	Contract address of the newly created proxy contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_proxy	log_index	block_number	block_timestamp	transaction_hash
0xe4e9cdb3e139d7e8a41172c20b6ed17b6750f117	false	0xddcf915656471b7c44217fb8c51f9888701e759a	88	12603518	2021-06-10T00:20:20.000Z	0x99b98a07c28d433a8e71ca1321d397d8d6745c970e38b14217e330b66036af6c
0xe4e9cdb3e139d7e8a41172c20b6ed17b6750f117	false	0x30430419b86e9512e6d93fc2b0791d98dbeb637b	284	12077246	2021-03-20T18:13:55.000Z	0x5c969885d5ce90dd66f37e046b0575178652431a6908df616d110bda4078208e
0xe4e9cdb3e139d7e8a41172c20b6ed17b6750f117	false	0xa8094ace7c4114db99f6c2a3bd01eaa883199569	371	12788874	2021-07-08T20:32:07.000Z	0x707af11bd342450bc3e942473ae5a7dc58fbce2dce25e15eb48f30e16727890c

Example Query

Query with partition filter

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

TokenFaucetV2_Claimed_event

Token reward claim events from PoolTogether V4 on Ethereum, recording when users claim accrued tokens through the protocol’s faucet mechanism. Contains user addresses, claimed token amounts (in wei), and transaction metadata for analyzing reward distribution and user engagement 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_newTokens`	`STRING`	Amount of tokens claimed by the user in the event. Integer value stored as string representing the smallest token unit.

Sample Data

address	in_user	removed	log_index	block_number	in_newTokens	block_timestamp	transaction_hash
0x30430419b86e9512e6d93fc2b0791d98dbeb637b	0x02fb37f0c8d6ebd4e2726e7914e20bb648c62418	false	2	15761104	3872975059920666217	2022-10-16T13:54:11.000Z	0x127ed389fab01648a840e2a3441bb609327d0053978f9121743a8cd31d3ffcb8
0x30430419b86e9512e6d93fc2b0791d98dbeb637b	0x8522885d735f75b3faeea5cd39ab3d1291da2c77	false	257	12305696	2680732642861883382	2021-04-24T22:39:01.000Z	0x97bf5be398129f8069908d7d3d58b5a5d4ae56e2e2734795b4974e942548b009
0x30430419b86e9512e6d93fc2b0791d98dbeb637b	0xbd6c934afa35452c30b833533a59d4986031085c	false	291	12303335	4986564536394987875	2021-04-24T14:00:11.000Z	0x7f8b9ef1734d5ba5ee8d5ea963427459e1f92cc70f8f161653f2c32de88503e0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pooltogether_v4_ethereum.TokenFaucetV2_Claimed_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
0x761d584f1c2d43cbc3f42ecd739701a36dffaa31	0xd89a09084555a7d0abe7b111b1f78dfeddd638be	false	0xdd4d117723c257cee402285d3acf218e9a8236e1	10400000	229	0x761d584f1c2d43cbc3f42ecd739701a36dffaa31	15604869	2022-09-24T17:59:35.000Z	0x03615dbfc82c5063978b52c48d663d9dab965974322a0469c63a58fdbb46fc2c
0x2d4e519634cd0887de24cb853a76036484928341	0xd89a09084555a7d0abe7b111b1f78dfeddd638be	false	0xdd4d117723c257cee402285d3acf218e9a8236e1	9870000	185	0x2d4e519634cd0887de24cb853a76036484928341	15599891	2022-09-24T01:20:11.000Z	0x0a4a87b1f36ad5ed5f7ee1e12474be36fc9fbd6db2361096d005191564562b7a
0xc59292b1caf144f2877a88b120b4e71e48385569	0xd89a09084555a7d0abe7b111b1f78dfeddd638be	false	0xdd4d117723c257cee402285d3acf218e9a8236e1	50000000	226	0xc59292b1caf144f2877a88b120b4e71e48385569	15605191	2022-09-24T19:05:35.000Z	0x379f85ed419a1c02dba3526d05c4321c93ba8206d492fe3f186063af250c15a2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pooltogether_v4_ethereum.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
0xd89a09084555a7d0abe7b111b1f78dfeddd638be	0xa5c3a513645a9a00cb561fed40438e9dfe0d6a69	false	0xdd4d117723c257cee402285d3acf218e9a8236e1	1000000000	285	0xa5c3a513645a9a00cb561fed40438e9dfe0d6a69	1000000000	15224931	2022-07-27T13:56:33.000Z	0x210f222e12900bbbb56c69abf2a5e3d35cbb8ac23e267f3e4f1eea26ca1ce2ba
0xd89a09084555a7d0abe7b111b1f78dfeddd638be	0x208b3cd5166df7ac646ca6e9393f336d3e4c4c51	false	0xdd4d117723c257cee402285d3acf218e9a8236e1	10000000000	160	0x208b3cd5166df7ac646ca6e9393f336d3e4c4c51	10000000000	15222696	2022-07-27T05:50:38.000Z	0x38c04fb7d738e2c9025f2f4a48d113957c4abf782ae20b5d18ffa1bda3d7b7fe
0xd89a09084555a7d0abe7b111b1f78dfeddd638be	0xf63f5fcc54f5fd11f3c098053f330e032e4d9259	false	0xdd4d117723c257cee402285d3acf218e9a8236e1	1656075000000	244	0xf63f5fcc54f5fd11f3c098053f330e032e4d9259	1656075000000	15793096	2022-10-21T01:08:35.000Z	0xd49c72d7e8a0819fdd9c6d2f30d7fcbe822fe9bd79b89e160ac14ef6356b6e75

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

PrizeDistributor_ClaimedDraw_event

Rewards_Claimed_event

TokenFaucet_Claimed_event

TokenFaucetFactory_ProxyCreated_event

TokenFaucetFactoryV2_ProxyCreated_event

TokenFaucetV2_Claimed_event

YieldSourcePrizePool_Deposited_event

YieldSourcePrizePool_Withdrawal_event

​Tables

​PrizeDistributor_ClaimedDraw_event

​Rewards_Claimed_event

​TokenFaucet_Claimed_event

​TokenFaucetFactory_ProxyCreated_event

​TokenFaucetFactoryV2_ProxyCreated_event

​TokenFaucetV2_Claimed_event

​YieldSourcePrizePool_Deposited_event

​YieldSourcePrizePool_Withdrawal_event

Tables

PrizeDistributor_ClaimedDraw_event

Rewards_Claimed_event

TokenFaucet_Claimed_event

TokenFaucetFactory_ProxyCreated_event

TokenFaucetFactoryV2_ProxyCreated_event

TokenFaucetV2_Claimed_event

YieldSourcePrizePool_Deposited_event

YieldSourcePrizePool_Withdrawal_event