WHEN action = 'delegate' THEN

event_amount

ELSE

0

END)) as amount_staked,

SUM((CASE

WHEN action = 'undelegate'

THEN

event_amount

ELSE

0

END)) as amount_unstaked

FROM terra.staking

GROUP BY day),

luna_price AS (SELECT DATE_TRUNC('DAY', block_timestamp) as day, AVG(price_usd) as luna_price_usd

FROM terra.oracle_prices

WHERE symbol = 'LUNA'

GROUP BY day)

SELECT amount_staked.day, amount_staked - amount_unstaked as amount_staked_unstaked, luna_price_usd

FROM amount_staked INNER JOIN luna_price ON amount_staked.day = luna_price.day