aragon_v1_ethereum

Tables

AntBptRewards_RewardPaid_event

Reward claim events from Aragon’s ANT-BPT (Balancer Pool Token) liquidity mining program on Ethereum. Tracks individual reward payouts to liquidity providers with user addresses and reward amounts for analyzing incentive distribution 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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x7f2b9e4134ba2f7e99859ae40436cbe888e86b79	0x12bb2d969b59ff2830c1c6d760a2b87e8204109c	false	4503832634	140	11276842	2020-11-17T17:37:30.000Z	0xe65ddbfbc09a05bf62bb815b07d6eff687ae51d5bcb6d204ea6c05b11b9688b3
0x7f2b9e4134ba2f7e99859ae40436cbe888e86b79	0x6f69286d7c51de0f0cf5f3c03c8ca3eda8a322f9	false	7387426	178	11466700	2020-12-16T21:48:08.000Z	0x825f9416660d363608771c8dd36cc96c9c26bc4881d2fd842b83674a55d39812
0x7f2b9e4134ba2f7e99859ae40436cbe888e86b79	0xbd1f7d88c76a86c60d41bddd4819fae404e7151e	false	9783484	182	11266422	2020-11-16T03:11:48.000Z	0x5a5dcde6eee177304006b66952a9c2b0304c35b7f368fb3b1d345d88c60b9d11

Example Query

Query with partition filter

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

AntUniRewards_RewardPaid_event

Reward distribution events from Aragon’s ANT-UNI liquidity mining program on Ethereum, tracking token payouts to individual stakers. Used for analyzing liquidity provider returns and reward claim patterns in Aragon’s Uniswap incentive mechanism.

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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x37b7870148b4b815cb6a4728a84816cc1150e3aa	0xe8adaea0ba507a28d1309051beceb4db7fe377af	false	108967045608681752	268	11214567	2020-11-08T04:13:05.000Z	0x7ac226270fbe5aa11014cc9b31962031ce88127471168c7dacd2321b7d04db12
0x37b7870148b4b815cb6a4728a84816cc1150e3aa	0xaf4cecd76e37eae3ec942de9a86aa3a0e683c384	false	51232800072959991	62	11285080	2020-11-19T00:13:50.000Z	0xebf49e2270ddf98d4d474970828c8981e55ac1dd2e1277996ce0d68258ed891e
0x37b7870148b4b815cb6a4728a84816cc1150e3aa	0xbec73ba0817403cd11c11be891d671ea30443562	false	879725222357863452	265	11207836	2020-11-07T03:22:49.000Z	0xe8b96ff18e23c6af1e0abddb152f2d9f11a0dbee594ac7dfbbaeb97eddde4dcf

Example Query

Query with partition filter

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

Unipool_RewardPaid_event

RewardPaid events from Aragon v1 Unipool liquidity mining contracts on Ethereum, capturing reward token distributions to staking participants. Used for analyzing reward claim patterns, participant behavior, and incentive program effectiveness.

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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0xea4d68cf86bce59bf2bfa039b97794ce2c43debc	0xe5767ade043d95c35e9723f7a463d25278ce6d4b	false	124041930616904089	214	10558696	2020-07-30T03:51:27.000Z	0x4423be0233b5bfb583ddaef66e5cb68032389d2bc754b2b4f8621ae6050de94c
0xea4d68cf86bce59bf2bfa039b97794ce2c43debc	0xa26ebb8b409a8596f9bb5ae0711c661a3e16abb7	false	10535200863298681951	182	10561175	2020-07-30T13:24:05.000Z	0x628dff8598b0ea8133aba25f6c9314b796f85b6e954faae15f934354e7b1bc74
0xea4d68cf86bce59bf2bfa039b97794ce2c43debc	0x0285c10aa06ac166f2576ab2d3473fc42cefb933	false	51320865703553205235	250	10562850	2020-07-30T19:40:51.000Z	0x9d27eff84c3c4a015155cd2995dfbf6172ed386957ea63b4c109d966a9677741

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AntBptRewards_RewardPaid_event

AntUniRewards_RewardPaid_event

Unipool_RewardPaid_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AntBptRewards_RewardPaid_event

​AntUniRewards_RewardPaid_event

​Unipool_RewardPaid_event

Tables

AntBptRewards_RewardPaid_event

AntUniRewards_RewardPaid_event

Unipool_RewardPaid_event