aurafinance_v1_arbitrum

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
0x0407e6d2b22fa27d24ad052987cb157c84acea2a	0x141721e19fed0eea9ffbc6c821454e70717257f0	false	2539394177642799646	4	133529222	2023-09-22T13:10:25.000Z	0x2314538ae730053c6706a3e39440313058480c9597f6ece78c765c416b0314b7
0x0407e6d2b22fa27d24ad052987cb157c84acea2a	0x141721e19fed0eea9ffbc6c821454e70717257f0	false	587845993032410086	118	133636182	2023-09-22T21:12:23.000Z	0x7682fe484633d0e57a04e9c326857395d4af8f01e755020df933842e814a10bb
0x0dcb3664bafe8f7afb2174c1ff736fe9011de9ff	0x09f2522360eec32c7d748023df6f87d557a7ccee	false	658673543910838546	11	133504375	2023-09-22T11:24:29.000Z	0x86ae8e3aed055d13ffa4d03cdbe1201919624e6aac1ba12aecbd1780f0641e55

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aurafinance_v1_arbitrum.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	0x92b0525b86badcdfd9543f7eb46e85187c0701ff	false	3780716663563280750	17	118991159	2023-08-07T08:46:28.000Z	0xf95fa6593d818c6353f4bc4db214a985359178b0045ac735637cc95610daf4de
0x98ef32edd24e2c92525e59afc4475c1242a30184	0xb24fa471579829b62f8d86091b0ccd7686fc291f	false	43077732050619067635	17	118916355	2023-08-07T03:23:59.000Z	0xc63f189d156c43c6eaa0b40216d58d76968d2dec6dfd5212df979695590686e3
0x98ef32edd24e2c92525e59afc4475c1242a30184	0xb24fa471579829b62f8d86091b0ccd7686fc291f	false	28167261780859867017	17	119066339	2023-08-07T14:03:04.000Z	0x57349cfd7289efcf8a3c5532db9b3adf5e3afc242497f4f4b313538b73f18fcd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aurafinance_v1_arbitrum.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
0xda2e6ba0b1abbca925b70e9747afbd481c16e7db	64	false	9	215937527	0xa4e8b770b85794beb675e3f59a78a43f7aff8ae2	2024-05-28T14:50:47.000Z	0xc6b98e9b5aa0bbeb7b6a85768eca663ca07a1bbd	0x01340e0621695ff8320e26ab066080960bc61a11fd817a3d9e08332b892d5132
0xda2e6ba0b1abbca925b70e9747afbd481c16e7db	0	false	3	101461134	0x49e998899ff11598182918098588e8b90d7f60d3	2023-06-15T15:33:51.000Z	0x094c6846fb2801b4753182adfac336aae8030a46	0x4e9c1139ca4b766b3dc94fb7216f8298bfa8470491dea5a752d0ab925e9a6f09
0xda2e6ba0b1abbca925b70e9747afbd481c16e7db	1	false	9	101461134	0xa17492d89cb2d0be1ddbd0008f8585edc5b0acf3	2023-06-15T15:33:51.000Z	0x9c779b0cbb42531027e2ec995e97c787125013d0	0x4e9c1139ca4b766b3dc94fb7216f8298bfa8470491dea5a752d0ab925e9a6f09

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aurafinance_v1_arbitrum.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
0xda2e6ba0b1abbca925b70e9747afbd481c16e7db	false	0x5ed3b748bcb61d2728dd806e1229bf1558ade15b	60	0x55dccaff54b17c79d2ea9d8ae0e789e0e14ee8b9	147299326	0xd0a3432a644a0d50d60b9458c8fac9c35a4cdcf1	0x5d4ce85f6a6e176b2e93ab173b46eff0cdb6df26	2023-11-05T07:00:40.000Z	0x51f52941359bdf8ace4d7dbbd5e532eee1b59c730b7983dca06634e4fe613816
0xda2e6ba0b1abbca925b70e9747afbd481c16e7db	false	0x85eb66aa4ee2b0a41996ab63a98b63c07c023172	7	0x2ccbc2a5f21e125f8f16127899e3558e5dde3412	164018275	0xaf8385e0637fc3daf326df30b5e62cbe5a8bea9f	0xa1daa010d5f58622c2f5dde45d9e4a938ce49db6	2023-12-26T18:57:02.000Z	0xa0bafc13f04e36d53fbb50648495d30e18631f565fd16d6abac90cfdbc8ba13d
0xda2e6ba0b1abbca925b70e9747afbd481c16e7db	false	0x4458046b06eeaaa081f5bbb2600acf461c9b6d58	14	0xf03bd83b4ea85934e0fb7ac51114aa81f9cdeaa3	164018275	0xa83e83879856bebf158e115ab70d069ce1f97817	0xe8e1de101836586e9c8e2145038896b5ed55cc40	2023-12-26T18:57:02.000Z	0xa0bafc13f04e36d53fbb50648495d30e18631f565fd16d6abac90cfdbc8ba13d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aurafinance_v1_arbitrum.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