boomer77staking rewards
    Updated 2021-07-28
    with stake as
    (SELECT
    date_trunc('month', block_timestamp) AS months,
    SUM(event_amount_usd) AS amount_stake
    FROM terra.staking
    WHERE action = 'delegate'
    GROUP BY 1),

    reward as
    (SELECT
    date_trunc('month', block_timestamp) AS months1,
    SUM(event_amount_usd) AS amount_reward
    FROM terra.reward
    WHERE action = 'withdraw_delegator_rewards'
    GROUP BY 1)

    SELECT A.months, A.amount_stake, B.amount_reward
    from stake A
    join reward B on A.months = B.months1
    order by 1 desc
    Run a query to Download Data