date,

sum(balance_usd) as stakeUSD,

sum(balance) as staked_luna

from terra.daily_balances

where currency = 'LUNA'

and balance_type = 'staked'

group by 1

order by 1

),

reward as (SELECT

date_trunc('day', block_timestamp) AS day,

action,

SUM(event_amount_usd) AS rewardUSD

FROM terra.reward

WHERE action = 'withdraw_delegator_rewards'

GROUP BY 1,2

ORDER BY 1 DESC)

select A.date, A.stakeUSD, B.rewardUSD, B.rewardUSD/A.stakeUSD * 100

from stake A

join reward B on A.date = B.day

order by 1 desc