saber-jldaily luna stake
    Updated 2023-01-24
    SELECT
    date_trunc('day',BLOCK_TIMESTAMP) as date,
    CASE
    when date >= '2023-01-07' and date < '2023-01-14' then 'befroe announcement'
    when date >= '2023-01-14' and date <= '2023-01-20' then 'after announcement'
    end as time_frame,
    count(distinct tx_id) as tx_count,
    count(distinct DELEGATOR_ADDRESS) as users,
    sum(amount) as stake_amount,
    (stake_amount/users) as "stake amount per user"
    from terra.core.ez_staking
    where TX_SUCCEEDED = 'TRUE'
    and ACTION = 'Delegate'
    and BLOCK_TIMESTAMP::date between '2023-01-07' and '2023-01-20'
    group by 1,2
    Run a query to Download Data