flipside

    Terra Staking
    rajsTerra Staking
    Updated 2023-01-11
    with req_tab as
    (
    SELECT
    validator_address,
    sum(amount_million) as amount_million
    FROM
    (
    SELECT
    -- *
    validator_address,
    -- validator_label,
    -- action,
    sum(case when action = 'undelegate' then -amount / 1e6 else amount / 1e6 end) as amount_million
    -- sum(amount)
    from terra.core.ez_staking
    -- where delegator_address = 'terra13t8vqfu6d84mhvlcpvxa9aycakq292r96vkwyv'
    -- and action = 'Redelegate'
    group by 1
    -- order by 4 desc
    -- limit 10

    union ALL

    SELECT
    validator_src_address as validator_address,
    -sum(amount) / 1e6 as amount_million
    from terra.core.ez_staking
    where action = 'Redelegate'
    group by 1
    )
    group by 1
    order by 2 desc
    )

    SELECT
    *,
    Run a query to Download Data