Skip to main content

​
Tables

​
UnipilotFarm_Reward_event

Reward distribution events from Unipilot V1 liquidity management protocol on Ethereum, tracking token rewards earned by users from farming vaults. Useful for analyzing yield farming performance and reward accrual across different vault strategies.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_vaultSTRINGContract address of the vault. Hex-encoded, 0x-prefixed, 42-character string.
in_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
addressin_userremovedin_tokenin_vaultin_rewardlog_indexblock_numberblock_timestamptransaction_hash
0x52d1cc3e97b97d3a915f2c91e0ae687c89f6f2e00x7c3d434d79dddac3174ce0819f55ed82e0276147false0x37c997b35c619c21323f3518b9357914e8b995250x12cc705bdd9ff7cd3bcddafe1cabfce9a182aa2282792621911999999970145019832022-04-01T18:27:23.000Z0x2e8342a747b1d4770e1ea7bcb524ab86d654cc82ca1b2a3a1d3b55b95106407a
0x52d1cc3e97b97d3a915f2c91e0ae687c89f6f2e00x7c3d434d79dddac3174ce0819f55ed82e0276147false0x37c997b35c619c21323f3518b9357914e8b995250x12cc705bdd9ff7cd3bcddafe1cabfce9a182aa22541336374039999998183145021692022-04-01T19:08:58.000Z0x288c0bb7b38404d620642bb135ccbe36f6a27b28838b9845584991eb473e608c
0x52d1cc3e97b97d3a915f2c91e0ae687c89f6f2e00x7c3d434d79dddac3174ce0819f55ed82e0276147false0x37c997b35c619c21323f3518b9357914e8b995250x12cc705bdd9ff7cd3bcddafe1cabfce9a182aa22199020725749999991184145020332022-04-01T18:37:51.000Z0x0b8c0be7dc39a367739c6425f8e5fbf05d0d1219eb556ee64f210a468ea642b2
Query with partition filter
SELECT *
FROM `tt-contracts.unipilot_v1_ethereum.UnipilotFarm_Reward_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100