LTirrellFlipside validator outfows
    Updated 2021-10-25
    -- select * from terra.validator_labels
    -- where operator_address = 'terravaloper1r843mpk5zzkfgtnduskd0dzgeltv0n503ckzy6'
    -- -- flipside
    -- -- terravaloper1r843mpk5zzkfgtnduskd0dzgeltv0n503ckzy6
    -- -- terra1r843mpk5zzkfgtnduskd0dzgeltv0n503h6l5f
    -- -- terravalcons1twdyzfcr4dxydyh97kcpe3al4pp978zrhmvxr5

    with outflow as (
    select
    date_trunc('hour', block_timestamp) as date,
    tx_status,
    action,
    DELEGATOR_ADDRESS,
    validator_address,
    EVENT_AMOUNT,
    EVENT_AMOUNT_USD
    from terra.staking
    where validator_address = 'terravaloper1r843mpk5zzkfgtnduskd0dzgeltv0n503ckzy6' and tx_status = 'SUCCEEDED' and action = 'undelegate'
    )
    select
    date,
    sum(EVENT_AMOUNT),
    sum(EVENT_AMOUNT_USD)
    FROM
    outflow
    group by date
    order by date
    Run a query to Download Data