princefarzamTerra whale voters
Updated 2022-02-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH Terra_whale as (
SELECT DISTINCT
ADDRESS,
max(balance_usd)/pow(10,6) AS Total --total Luna in USD(million)
FROM terra.daily_balances
WHERE CURRENCY LIKE 'LUNA'
AND DATE >= CURRENT_DATE - 90
AND balance != 0
GROUP BY 1
ORDER BY 2 DESC
LIMIT 1000)
SELECT DISTINCT
'Whales',
1000 AS All_whales,
COUNT(g.VOTER) as Whale_voters
FROM terra.gov_vote g INNER JOIN Terra_whale w ON g.VOTER=w.ADDRESS
WHERE g.BLOCK_TIMESTAMP::DATE >= CURRENT_DATE - 90
and g.tx_status='SUCCEEDED'
Run a query to Download Data