SELECT

BLOCK_TIMESTAMP,

STAKER_ADDRESS,

AMOUNT,

AMOUNT_USD,

TOKEN_SYMBOL,

PROGRAM_NAME,

EZ_OLAS_STAKING_ID

FROM crosschain.olas.ez_olas_staking

WHERE BLOCK_TIMESTAMP >= '2024-01-01'

AND BLOCK_TIMESTAMP < CURRENT_DATE()

),

STAKING_SUMMARY AS (

SELECT

BLOCK_TIMESTAMP,

TOKEN_SYMBOL,

SUM(AMOUNT) AS TOTAL_STAKED_AMOUNT,

SUM(AMOUNT_USD) AS TOTAL_STAKED_USD

FROM STAKING_ACTIVITY

GROUP BY BLOCK_TIMESTAMP, TOKEN_SYMBOL

),

DAILY_CHANGE AS (

SELECT

BLOCK_TIMESTAMP,

TOKEN_SYMBOL,

AMOUNT - LAG(AMOUNT) OVER (PARTITION BY TOKEN_SYMBOL ORDER BY BLOCK_TIMESTAMP) AS DAILY_CHANGE_IN_STAKED_AMOUNT

FROM STAKING_ACTIVITY

),

AVERAGE_DAILY AS (

SELECT

BLOCK_TIMESTAMP,

AVG(AMOUNT) AS AVERAGE_DAILY_STAKED_AMOUNT,