Updated 2023-01-23
    SELECT date_trunc('day',block_timestamp) as date,
    CASE WHEN date between '2023-01-07' AND '2023-01-13' THEN 'before'
    WHEN date between '2023-01-15' AND '2023-01-21' THEN 'after'
    ELSE 'announcement' END as periods,
    sum(CASE WHEN action IN ('Delegate','Redelegate') then amount
    ELSE -1*amount END) as net,
    sum(net) over (ORDER by date) as cum_net

    FROM terra.core.ez_staking
    WHERE tx_succeeded = 'TRUE'
    AND date between '2023-01-07' AND '2023-01-21'
    GROUP BY date, periods
    ORDER BY date DESC
    Run a query to Download Data