aurafinance_v1_base

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
0x6c03c044c307ecde1d4cbbffb6327bdef07edfcf	0x126ff8fabec84ef8a96f25dd0c2668fb9b7e7088	false	25918136220702040368	53	10103001	2024-02-03T21:22:29.000Z	0x2931575fcd2e3a4e4bdee91e444a1a1459da1f3d2c466541d1cec0887579eff7
0xee374580bff150be6b955954ac3b9899d890cb57	0x1fd2978ac57fb2f459ef1ab7812b58f29ab437ba	false	58298021292798487160	40	10074909	2024-02-03T05:46:05.000Z	0xceb63ced313f178bf0889979260abdddca3d7344b0e2cad0b439515425cb67f9
0xee374580bff150be6b955954ac3b9899d890cb57	0xd307152387a276dc3b21a78b2784debf8555e40e	false	4876719624730798255	21	10094967	2024-02-03T16:54:41.000Z	0x888c27d81f8c60159d302153e93f5bb2d758283138608e46353c37f52c59f468

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aurafinance_v1_base.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	0x3452045ed4f521c8d4638c1bb82b7cd666cb6593	false	6627445528072890026502	15	5860612	2023-10-28T16:29:31.000Z	0x7ab251ae151b67c178b570bce1a9475f55b874cf3655542eb770441e88839b5c
0x98ef32edd24e2c92525e59afc4475c1242a30184	0x794783dcfcac8c1944727057a3208d8f8bb91506	false	3573193494014587229797	24	5847074	2023-10-28T08:58:15.000Z	0x136ed4d9e60bdf9aec34d9fb221f7d4c31a838a6a75656898b8ad9beaaaad720
0x98ef32edd24e2c92525e59afc4475c1242a30184	0x3452045ed4f521c8d4638c1bb82b7cd666cb6593	false	6627445528072890026503	25	5861940	2023-10-28T17:13:47.000Z	0x0887bc685e51e3173eaa2cfa3edf9196f800405abfd580c742627736394bd47d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aurafinance_v1_base.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
0x334df252cc0c44c37ba85dbeaa9c230c3f22f6b0	6	false	35	6680353	0x331a1213953e324955b2a121079d8ffd08eae9fd	2023-11-16T15:54:13.000Z	0x81765a6df6279564b30292a509bdf0d45bfc4ac4	0x83e91a880dfc162e7b7bead25510c73dff20dbb779f3d9e959a96969e5bd1b11
0x334df252cc0c44c37ba85dbeaa9c230c3f22f6b0	5	false	28	6680353	0xde18d8129ef4b9032e2df26c5d4f3ed31bfbf7cd	2023-11-16T15:54:13.000Z	0xf80cf4aa1228c6cfa863c2ffe303cc9e05322b1f	0x83e91a880dfc162e7b7bead25510c73dff20dbb779f3d9e959a96969e5bd1b11
0x334df252cc0c44c37ba85dbeaa9c230c3f22f6b0	4	false	36	6030923	0x35f398f2dbcadf1cddde9602192233715277a7ee	2023-11-01T15:06:33.000Z	0x4c7e79c921144ebf7ebdbf0d3156bf192cdbe5f5	0x4970d418a2470631d6da964b35e5f3c2614b37f69cbb97dbdd076afeaa039836

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aurafinance_v1_base.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
0x334df252cc0c44c37ba85dbeaa9c230c3f22f6b0	false	0x2a899dd4226515ef2e3eda6d0972b3b7d77ed86e	8	0x417d097d504e5adedb441238f92f1b2c9b38900f	5997917	0xa731662d082867eaf74c80474530c3ebd19104cf	0x8db6a97aeea09f37b45c9703c3542087151aadd5	2023-10-31T20:46:21.000Z	0xa3bb35672a03b2541a21300e82d555e847210bdf7e25d36dc71b1efdee7451bf
0x334df252cc0c44c37ba85dbeaa9c230c3f22f6b0	false	0x9f3b7f627e42dbca8cf644a46e3fce1c2a13ff59	2	0xe2f2499474b4bef0a7320c1d2b0feffd5430acf8	6595152	0x842b57206cee2cb10195bd2c1680be3db04c62d3	0x6c03c044c307ecde1d4cbbffb6327bdef07edfcf	2023-11-14T16:34:11.000Z	0x50add297e3dd317cf343ed8fa1271f483c12040e21f1fa7bcd47575b1c3daf3e
0x334df252cc0c44c37ba85dbeaa9c230c3f22f6b0	false	0x6335a59b6192309a7b434f58a3a5d23dadff8f1a	4	0xff58d6fb1ffd4cb2ed226e25ce55b219c414ccc7	6595152	0xd25e33439132a0ee8eeb4e854e2fa5b482b5c72a	0xee374580bff150be6b955954ac3b9899d890cb57	2023-11-14T16:34:11.000Z	0x50add297e3dd317cf343ed8fa1271f483c12040e21f1fa7bcd47575b1c3daf3e

Example Query

Query with partition filter

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