-- forked from Program Performance @ https://flipsidecrypto.xyz/studio/queries/4c1d32fd-760e-4dd4-98a2-6296a87f61f5
SELECT
COUNT(*) AS transaction_count,
SUM(AMOUNT_USD) AS total_staked,
AVG(AMOUNT_USD) AS avg_stake_amount,
COUNT(DISTINCT STAKER_ADDRESS) AS unique_stakers
FROM
crosschain.olas.ez_olas_staking