SocioCryptostaking actions and actors
    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,
    ACTION,
    count(DISTINCT delegator_address) as n_deleg,
    count(DISTINCT validator_address) as n_valid,
    sum(amount) as amnt,
    count(DISTINCT tx_id) as n_action
    FROM terra.core.ez_staking
    WHERE tx_succeeded = 'TRUE'
    AND date BETWEEN '2023-01-07' AND '2023-01-21'
    GROUP BY date,action,periods
    ORDER BY periods DESC