barbodStaking/luna-price
    Updated 2022-02-01
    WITH rewards as (
    SELECT DATE(block_timestamp) as date,
    sum( event_amount_usd) as s_rewards
    FROM terra.reward
    GROUP BY 1
    ORDER BY 1
    ),
    luna_price as (
    SELECT DATE(block_timestamp) as date, AVG(price_usd) as luna_price
    FROM terra.oracle_prices
    WHERE symbol = 'LUNA'
    GROUP BY 1
    ORDER BY 1
    ),
    stake_amount AS(
    select DATE(block_timestamp) as date, sum(event_amount_usd) as s_amount
    FROM terra.staking
    GROUP BY 1
    ORDER BY 1
    )
    SELECT rewards.date, rewards.s_rewards, luna_price.luna_price from rewards
    JOIN luna_price ON rewards.date=luna_price.date
    Run a query to Download Data