flipside

    Richlist (Top 100)
    MadiRichlist (Top 100)
    Updated 2023-04-13
    select wallet, round(sum(amount/pow(10,6)),2) as amount from
    (select
    SENDER as wallet, sum(AMOUNT) as AMOUNT
    from terra.core.ez_transfers
    where CURRENCY='uluna'
    group by 1

    union all

    select
    RECEIVER as wallet,
    sum(AMOUNT)*-1 as AMOUNT
    from terra.core.ez_transfers
    where CURRENCY='uluna'
    group by 1
    ) group by 1 order by 2 desc limit 100
    Run a query to Download Data