with cliam_reward as (

date_trunc('day', block_timestamp) as day, avg(event_amount_usd) as reward_claimed

FROM terra.reward

where block_timestamp >= CURRENT_DATE - 120

group by day

),

stake_luna AS (

SELECT

date_trunc('day', date) as day, avg(balance) as total_staked_luna

FROM terra.daily_balances

WHERE balance_type = 'staked'

and currency = 'LUNA'

AND DATE >= CURRENT_DATE - 120

group by day

)

select

stake_luna.day as day,

(reward_claimed/total_staked_luna) as Yield_of_staking,

total_staked_luna,

reward_claimed

from stake_luna

inner join cliam_reward on stake_luna.day = cliam_reward.day

),

lunaprice as (

SELECT DATE(block_timestamp) as day,

AVG(price_usd) as Luna_price

FROM terra.oracle_prices

WHERE symbol = 'LUNA' AND DATEDIFF('day', TO_DATE(block_timestamp), CURRENT_DATE()) < 120

GROUP BY day

)

select