strawbettyWhale Voters
    Updated 2022-02-16
    with whales as (
    SELECT DISTINCT(address) as unique_address, sum(balance_usd) as sum
    FROM terra.daily_balances
    WHERE date > CURRENT_DATE - 1
    group BY unique_address
    ORDER BY 2 DESC
    LIMIT 1000
    ), whales_voted as (
    SELECT DISTINCT(voter)
    FROM terra.gov_vote
    WHERE voter IN (SELECT unique_address FROM whales)
    AND date_trunc('day',block_timestamp) > CURRENT_DATE- 90
    )
    SELECT
    'Vote Compare', COUNT(*) as whales_voted, (SELECT COUNT(*) as whales_count from whales) as total_whales,
    (whales_voted/total_whales)*100 as voted_percentage
    from whales_voted




    Run a query to Download Data