princefarzamTerra whale voters
    Updated 2022-02-16
    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