LidoTotalReward

This table stores information about the total rewards earned by Lido validators, including the reward amounts, fees, APR calculations, and the number of shares minted and allocated to various parties (treasury, insurance fund, operators).

Schema

Data Fields	Description
id	A unique identifier for the total reward record.
total_rewards	A unique identifier for the total reward record.
total_rewards_with_fees	The total reward amount including fees.
mev_fee	The fee charged for Maximal Extractable Value (MEV) or miner-extractable value.
fee_basis	The basis for calculating the fees (e.g., total rewards).
treasury_fee_basis_points	The portion of the fee allocated to the Lido treasury, in basis points.
insurance_fee_basis_points	The portion of the fee allocated to the Lido insurance fund, in basis points.
operators_fee_basis_points	The portion of the fee allocated to the node operators, in basis points.
total_fee	The portion of the fee allocated to the node operators, in basis points.
insurance_fee	The portion of the fee allocated to the node operators, in basis points.
operators_fee	The portion of the fee allocated to the node operators, in basis points.
treasury_fee	The portion of the fee allocated to the node operators, in basis points.
dust	The portion of the fee allocated to the node operators, in basis points.
shares_to_mint	The number of new Lido shares to be minted from the rewards.
shares_to_treasury	The number of new Lido shares to be minted from the rewards.
shares_to_insurance_fund	The number of new Lido shares to be minted from the rewards.
shares_to_operators	The number of Lido shares allocated to the node operators.
dust_shares_to_treasury	The number of Lido shares allocated to the node operators
total_pooled_ether_before	The number of Lido shares allocated to the node operators
total_pooled_ether_after	The total amount of Ether pooled by Lido after the reward distribution.
total_shares_before	The total number of Lido shares in circulation before the reward distribution.
total_shares_after	The total number of Lido shares in circulation after the reward distribution.
time_elapsed	The time elapsed since the last reward distribution.
apr_raw	The raw annualized percentage rate (APR) of the rewards.
apr_before_fees	The annualized percentage rate (APR) of the rewards before fees are deducted.
apr	The annualized percentage rate (APR) of the rewards after fees are deducted.
block_timestamp	The timestamp of the block in which the reward distribution occurred.
transaction_hash	The hash of the transaction that included the reward distribution.
transaction_index	The index of the transaction within the block.
log_index	The index of the log entry for the reward distribution event within the transaction.