aurafinance_v1_optimism

Tables

BaseRewardPool4626_RewardPaid_event

Reward distribution events from Aura Finance BaseRewardPool4626 contracts recording token payouts to staking participants. Contains user address, reward token address, and amount paid for tracking liquidity mining incentives.

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
0x19248c1c4e7e4a285439e681d1b65935b6888e09	0x07468cbcfd720ce686ed5a95048282e40afaf0e9	false	18368436636232200467	236	113919544	2023-12-24T17:11:05.000Z	0xbcf8f3ca297c676ec03269742cd880d88c783380b7981c3effbdb51d9ecc5e3c
0x5a473b418193c6a3967af0913135534b7b3b23e9	0x190ac830b737acfbfa819f1d3ab0a6d702d72147	false	3268775465687251173	5	113907065	2023-12-24T10:15:07.000Z	0x87975c9f1733d257ab77b4f9c40c99bc2c20da0afd93da2b3542961d8b7f90bd
0x61ac9315a1ae71633e95fb35601b59180ec8d61d	0x299d2dfcfaac9f68cd620013b7e1d67587de68a9	false	21863264911268259660	628	113922357	2023-12-24T18:44:51.000Z	0xe17e8b45f211483dee17ddc49ddff2d73af544cdff5258a21040d582d003d5d4

Example Query

Query with partition filter

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

BoosterLite_Deposited_event

Aura Finance BoosterLite contract deposit events emitted when users stake liquidity pool tokens into reward vaults. Records user address, pool identifier, and deposited token amount for tracking staking activity across Aura’s layer-2 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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_poolid`	`STRING`	Identifier for the liquidity pool associated with the deposit operation. Numeric string representation of the pool index.
`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	block_number	block_timestamp	transaction_hash
0x98ef32edd24e2c92525e59afc4475c1242a30184	0x299d2dfcfaac9f68cd620013b7e1d67587de68a9	false	43516563197420155	420	110518697	2023-10-06T23:49:31.000Z	0x929b207d22a24dcb7c6e754e17be0de69763c2c7ba8e6e027c798c2a2be86599
0x98ef32edd24e2c92525e59afc4475c1242a30184	0x299d2dfcfaac9f68cd620013b7e1d67587de68a9	false	29653817342318135	80	110477001	2023-10-06T00:39:39.000Z	0x7c484363831594e9f23e1fcbc3e7f59f832882063dccd6c6a11c3cfa711bb13d
0x98ef32edd24e2c92525e59afc4475c1242a30184	0x299d2dfcfaac9f68cd620013b7e1d67587de68a9	false	2337140355817874690	103	110477001	2023-10-06T00:39:39.000Z	0x7c484363831594e9f23e1fcbc3e7f59f832882063dccd6c6a11c3cfa711bb13d

Example Query

Query with partition filter

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

RewardFactory_RewardPoolCreated_event

Event logs emitted when Aura Finance reward pool contracts are created by the factory, containing pool identifier (PID), deposit token address, and newly deployed reward pool address. Used for tracking reward pool deployments across 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_rewardPool`	`STRING`	Contract address of the reward pool created by the factory. Hex-encoded, 0x-prefixed, 42-character string.
`in__pid`	`STRING`	Pool identifier for the reward pool or staking position. String-encoded integer used to reference specific pools within the protocol.
`in_depositToken`	`STRING`	Contract address of the token being deposited into the reward pool or margin position. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in__pid	removed	log_index	block_number	in_rewardPool	block_timestamp	in_depositToken	transaction_hash
0x2f4cdf0d46f4e3e6d4d37836e73073046138d4f7	17	false	9	113219539	0x84e22f2aa312700dba78abd040844360bc274de2	2023-12-08T12:17:35.000Z	0xf1a407e4fadcc20a4cccbae32c0e1ceb0ff971f6	0x2b5a43c35a087af15d84adcdd00839975cb27fa803203b5a62adca1fe2801403
0x2f4cdf0d46f4e3e6d4d37836e73073046138d4f7	9	false	29	109773494	0x5a473b418193c6a3967af0913135534b7b3b23e9	2023-09-19T17:49:25.000Z	0x5b6ce6a43041deaaff3e76d13f92931b7ea7538b	0xa07e57b160552769e0fd581f32c794af9d9f6195051a607bfebe1360f62daf7c
0x2f4cdf0d46f4e3e6d4d37836e73073046138d4f7	20	false	39	115213921	0x8f28a2126b58bd5dd039444243a80d65ed405f61	2024-01-23T16:16:59.000Z	0x0881086fd26263972266c17ac98d85a374dcaf61	0x3d3d72b0d24fa3f0715fd2e4d9769faa9e23f38845795f06eae318252b4868f7

Example Query

Query with partition filter

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

RewardFactory_TokenRewardPoolCreated_event

Event logs recording the creation of token reward pool contracts by the RewardFactory. Contains the newly deployed reward pool address, associated token, operator authorization, and main rewards contract reference for tracking Aura Finance incentive distribution infrastructure.

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_rewardPool`	`STRING`	Contract address of the reward pool created by the factory. 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_mainRewards`	`STRING`	Contract address of the main rewards contract associated with the reward pool. Hex-encoded, 0x-prefixed, 42-character string.
`in_operator`	`STRING`	Address authorized to execute the operation on behalf of the token owner. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_token	log_index	in_operator	block_number	in_rewardPool	in_mainRewards	block_timestamp	transaction_hash
0x2f4cdf0d46f4e3e6d4d37836e73073046138d4f7	false	0x0b99263de8c508602938b610405479a759794984	13	0xbcb983169f5206e7a01ddb75f22489965fb9ef66	113219539	0x50bdac2885cb76f5f21872d788402875818cf27e	0x84e22f2aa312700dba78abd040844360bc274de2	2023-12-08T12:17:35.000Z	0x2b5a43c35a087af15d84adcdd00839975cb27fa803203b5a62adca1fe2801403
0x2f4cdf0d46f4e3e6d4d37836e73073046138d4f7	false	0x57e90de2ad29919c1f50a2dcf513acb0248f1c94	7	0xe1f394057b7e4a76b1963f48e7766763cfc1e760	110196897	0x5ad208ae071e154e0ae9fe21f6ff036a7ed8dc90	0x5a473b418193c6a3967af0913135534b7b3b23e9	2023-09-29T13:02:51.000Z	0x224a4a5b6100b0cb566f45b4839f9fa5a146a65645d6c88831c5f5b92d0f25c7
0x2f4cdf0d46f4e3e6d4d37836e73073046138d4f7	false	0x3ab8826d263637ba6aad7d65f707ff88cd39d482	33	0xe1f394057b7e4a76b1963f48e7766763cfc1e760	109773494	0x6040423b4687646a38cd19a4d55d83f50154edf8	0x5a473b418193c6a3967af0913135534b7b3b23e9	2023-09-19T17:49:25.000Z	0xa07e57b160552769e0fd581f32c794af9d9f6195051a607bfebe1360f62daf7c

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

BaseRewardPool4626_RewardPaid_event

BoosterLite_Deposited_event

RewardFactory_RewardPoolCreated_event

RewardFactory_TokenRewardPoolCreated_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​BaseRewardPool4626_RewardPaid_event

​BoosterLite_Deposited_event

​RewardFactory_RewardPoolCreated_event

​RewardFactory_TokenRewardPoolCreated_event

Tables

BaseRewardPool4626_RewardPaid_event

BoosterLite_Deposited_event

RewardFactory_RewardPoolCreated_event

RewardFactory_TokenRewardPoolCreated_event