count (distinct tx_hash) as Transactions,

count (distinct origin_from_address) as Stakers,

sum (amount) as Staked_Volume_OLAS,

sum (amount_usd) as Staked_Volume_USD,

avg (amount) as Average_Staked_Volume_OLAS,

avg (amount_USD) as Average_Staked_Volume_USD,

Staked_Volume_OLAS / Stakers as AVG_Staked_Volume_Per_User_OLAS,

sum (Staked_Volume_OLAS) over (order by date) as Total_Staked_Volume_OLAS,

sum (Staked_Volume_USD) over (order by date) as Total_Staked_Volume_USD,

sum (Transactions) over (order by date) as Total_Transactions

from crosschain.olas.ez_olas_staking

group by 1

order by 1 desc