alleriaUnique Addresses Eligible to Claim
    Updated 2021-10-18
    WITH LUNA_users as (
    SELECT
    delegator_address,
    CASE
    WHEN action = 'delegate' THEN event_amount
    WHEN action = 'undelegate' THEN (event_amount * -1)
    END as stake_amount
    FROM terra.staking
    WHERE tx_status = 'SUCCEEDED'
    --AND currency = 'LUNA'
    AND (action = 'delegate' OR action = 'undelegate')
    AND block_timestamp < to_timestamp('2021.09.23 00:00:00', 'YYYY.MM.DD HH:MI:SS')
    ORDER BY delegator_address DESC
    ),

    LUNA_stake_amounts as (
    SELECT
    delegator_address,
    sum(stake_amount) as staked_LUNA
    FROM LUNA_users
    GROUP BY delegator_address
    ),

    LUNA_stakers as (
    SELECT
    delegator_address
    --staked_LUNA
    FROM LUNA_stake_amounts
    WHERE staked_LUNA > 0
    ORDER BY staked_LUNA DESC
    ),
    MINE_staked as(
    SELECT
    block_timestamp,
    tx_id,
    Run a query to Download Data