alleriaUnique Addresses Eligible to Claim
Updated 2021-10-18
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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