aurafinance_v1_polygon

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
0x0584e40da9ce45850d15c82743f8db96216b4ccb	0x7ec016febb4d0c91734eaedfc0d86203c1cddce0	false	39176370846922394600	302	50861923	2023-12-07T19:44:33.000Z	0x8fc4ccb3509adf95b12aeb63b1e02f6691f6cb1ba9f5bdd0a2db24f20a43f379
0x0584e40da9ce45850d15c82743f8db96216b4ccb	0x44791b9c211ede531d80c544d015ac904c5684f5	false	984895732075996128	626	50840927	2023-12-07T07:16:09.000Z	0x3fa180f2d9b1291b0053a56b2fd1e777b8d377aab695f1dcc031b066a292a0ef
0x0ce870b89e4522ee6e0a8a7134ecd39c409bfecc	0x20d61737f972eecb0af5f0a85ab358cd083dd56a	false	3917201672185148946	392	50831328	2023-12-07T01:29:41.000Z	0xc51ef242e870e2506a46b00a7a316b7d32b740acf5dc4927df01862bdf8e4764

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aurafinance_v1_polygon.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	in_poolid	log_index	block_number	block_timestamp	transaction_hash
0x98ef32edd24e2c92525e59afc4475c1242a30184	0xf4d348e3d74300fcf35766b31b5ddab4c1dbc94b	false	65864702890787512636	12	269	73337680	2025-06-28T20:01:45.000Z	0x379bfd44a1f3fdecfcef545876b6d8ddf09e0355c983825974dbe908e44eef7e
0x98ef32edd24e2c92525e59afc4475c1242a30184	0xf4d348e3d74300fcf35766b31b5ddab4c1dbc94b	false	70094639538579402989	12	884	73321889	2025-06-28T10:42:10.000Z	0x5ca56191e2d08141cd78a41a77cc5d19e8bd9f1b0bee5acc0a80b89eb6595271
0x98ef32edd24e2c92525e59afc4475c1242a30184	0x39ee6fb813052e67260a3f95d3739b336aabd2c6	false	103753439825007434118	12	1037	73321298	2025-06-28T10:21:14.000Z	0x7002adcba9f26e2565b78c20d137db32f65fe210864eb4aee391eff344fecf08

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aurafinance_v1_polygon.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
0xb292be31649a0b079dbdb772fcf5c7a02a6e0144	1	false	311	45431772	0xd90b5275b98d4865712487637b9266336b36ff0e	2023-07-23T18:15:36.000Z	0x9c779b0cbb42531027e2ec995e97c787125013d0	0x7cf83005437cb6e309b136483563c399265982c7114ef3ef19b23a997a32e213
0xb292be31649a0b079dbdb772fcf5c7a02a6e0144	2	false	317	45431772	0xe44e433326a698dd5be83ffbcd36b849dc0f4582	2023-07-23T18:15:36.000Z	0x792f80ba0f6b05b9d3b2267af6f1cc0092f0cfa4	0x7cf83005437cb6e309b136483563c399265982c7114ef3ef19b23a997a32e213
0xb292be31649a0b079dbdb772fcf5c7a02a6e0144	0	false	305	45431772	0xc78b6d5586ef339ea511f26b943f13ddfa137f04	2023-07-23T18:15:36.000Z	0x094c6846fb2801b4753182adfac336aae8030a46	0x7cf83005437cb6e309b136483563c399265982c7114ef3ef19b23a997a32e213

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aurafinance_v1_polygon.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
0xb292be31649a0b079dbdb772fcf5c7a02a6e0144	false	0xf7a5e07ddea618038caefdaddf6741375d0b12c0	88	0x417d097d504e5adedb441238f92f1b2c9b38900f	45614626	0xbea6ff2b2ee3832f398007a9321d70c53853d5c8	0xaa0746892a97163b1d821724a6ea087ec208680e	2023-07-28T09:30:37.000Z	0xca3db4346c8adfb706e0b0a313bc75fc354568ac458a88522335e5d4fc6bbf7c
0xb292be31649a0b079dbdb772fcf5c7a02a6e0144	false	0x2a899dd4226515ef2e3eda6d0972b3b7d77ed86e	87	0x417d097d504e5adedb441238f92f1b2c9b38900f	45614626	0x3dc0b0cd0f025b33143a7236cd71a8badeca7052	0xaa0746892a97163b1d821724a6ea087ec208680e	2023-07-28T09:30:37.000Z	0xca3db4346c8adfb706e0b0a313bc75fc354568ac458a88522335e5d4fc6bbf7c
0xb292be31649a0b079dbdb772fcf5c7a02a6e0144	false	0x3ab8826d263637ba6aad7d65f707ff88cd39d482	39	0xe1f394057b7e4a76b1963f48e7766763cfc1e760	46366792	0x42fcd6ca48905601064947cf68d95539e3e73259	0x60673f2a61dde2bb3e0ca0add5c1ff4c1aadf4ba	2023-08-16T07:01:04.000Z	0xb1261be23d9e04fc19bf6f3df1c8a66f4f98c04f8986fe4c9d85f6ec8386a41d

Example Query

Query with partition filter

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