aurafinance_v1_gnosis

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
0x112ea63d3a70bb7926f95da81eadf71aba0f0955	0x851ef0a28922435675c77d505601e625f65ff088	false	2587588165721436397	2506	30278163	2023-10-03T14:58:30.000Z	0x1b533d2ffb507f4731237f8599b0286b3edf0c907ed74d417f2c5e3cdd851e19
0xf4116f1be90057e6f85b0dcc14c47c84cc4575da	0x851ef0a28922435675c77d505601e625f65ff088	false	467000327339695219	2511	30278163	2023-10-03T14:58:30.000Z	0x1b533d2ffb507f4731237f8599b0286b3edf0c907ed74d417f2c5e3cdd851e19
0x7e6ccd111b56dd650af9d598e23f0cb0da7e59e7	0x4ffad6ac852c0af0aa301376f4c5dea3a928b120	false	779945928749363839	512	30274074	2023-10-03T08:51:35.000Z	0x7d513783b565acc5acd84df7f8e6814d7743fe9723752a2dcb2704a42a9301ae

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aurafinance_v1_gnosis.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	0xddd6cf8d3e028c37bf88bb173624ded9689657cb	false	299068578403055307	29	29547265	2023-08-20T00:48:40.000Z	0x0c0124f85adf47df1bca97629914d46f797799d1790f3b027424f74beea38d61
0x98ef32edd24e2c92525e59afc4475c1242a30184	0x1cb5b6f11f0607da5a2871b9c6d83d10b93c4c84	false	3481885489290299021	91	29552760	2023-08-20T08:45:25.000Z	0xf1721d400b60e5d0b02b40e9ab792665b6c38a7e5156ae41120ac861e2676c3c
0x98ef32edd24e2c92525e59afc4475c1242a30184	0x026d163c28cc7dbf57d6ed57f14208ee412ca526	false	25880723454586768139	38	29559974	2023-08-20T19:13:45.000Z	0x04a71025b01fcd43bf01cfcf3d860f111a70178e0476af250544ae2fa89dfb01

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aurafinance_v1_gnosis.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
0x0f641b291ba374ec9b17a878c54b98005a0bacae	17	false	32	30289826	0x51867537e5532186e76ba5380235512a9a4ca52a	2023-10-04T08:15:15.000Z	0xf1a407e4fadcc20a4cccbae32c0e1ceb0ff971f6	0x3c9a4a7c920b6428ff2232bf89973ee7aea915ce4d4c5f3767569996fb26f5a9
0x0f641b291ba374ec9b17a878c54b98005a0bacae	18	false	2521	30519617	0xde151980d461696543aa07a19bbe2603b20ecbae	2023-10-18T14:05:35.000Z	0xb77e2724eade603d244c5bcc0188dcd3267a265e	0x98d40de18e0d8a71175a2275c345e5968cfafa679f7aeaa832f8db267ca9c77c
0x0f641b291ba374ec9b17a878c54b98005a0bacae	14	false	5	29822581	0xf4116f1be90057e6f85b0dcc14c47c84cc4575da	2023-09-05T13:48:50.000Z	0xae291a217d5e21ff6bb9f22fec1cf60137ba10ff	0xef24c89530881803fad3c6208495bab21bc45a03b49c3621e2d2a25df7b363a8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aurafinance_v1_gnosis.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
0x0f641b291ba374ec9b17a878c54b98005a0bacae	false	0x806a269611b1577e1884b44c31df6ec9a6a52b78	10	0xe3dcf4c47f5cda5df66ca66f4016d93f2a3e8ba6	29602058	0xd9d09f226cf4b6292abcec179cc1fc3a1579097f	0xb26baaf9fb85e925a8a38ecbcffe1b23b199afd7	2023-08-23T07:44:55.000Z	0x0738a7c657090971024c9b14588ac5ec2f3bfc9b138fb87d22e4a8efc340155d
0x0f641b291ba374ec9b17a878c54b98005a0bacae	false	0x9f3b7f627e42dbca8cf644a46e3fce1c2a13ff59	6	0xe2f2499474b4bef0a7320c1d2b0feffd5430acf8	29602058	0xaaa92dcb82a1560841594ca3fcace2243e75feaa	0x026d163c28cc7dbf57d6ed57f14208ee412ca526	2023-08-23T07:44:55.000Z	0x0738a7c657090971024c9b14588ac5ec2f3bfc9b138fb87d22e4a8efc340155d
0x0f641b291ba374ec9b17a878c54b98005a0bacae	false	0xa1ce54017a98a59b4561b1620be306191cbc6afd	11	0x429dc5616f9c78131a4bb592b1a0eb6f5e996c0e	29602058	0xd871eb794d1baf6b102e854e072cf455657ded0b	0x7e6ccd111b56dd650af9d598e23f0cb0da7e59e7	2023-08-23T07:44:55.000Z	0x0738a7c657090971024c9b14588ac5ec2f3bfc9b138fb87d22e4a8efc340155d

Example Query

Query with partition filter

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