KaskoazulBalance of top 100 Addresses
    Updated 2022-01-27
    with total_sum as (
    SELECT
    SUM(BALANCE_USD) as total_sum
    from terra.daily_balances where currency='LUNA' AND BALANCE_TYPE='liquid' AND date='2022-01-27'
    )

    Select
    ADDRESS
    , SUM(BALANCE_USD) AS SUM_BALANCE_USD
    , SUM(BALANCE_USD)/(select total_sum from total_sum)*100 AS PERCENTAGE_OF_CIRCULATING_SUPPLY
    from terra.daily_balances where currency='LUNA' AND BALANCE_TYPE='liquid'
    GROUP BY ADDRESS
    ORDER BY 2 desc
    LIMIT 5
    Run a query to Download Data