headitmanagerHead to Head - UST
    Updated 2022-03-30
    with max_data as (SELECT address,MAX(date) as max_date
    FROM terra.daily_balances
    where currency='UST' and balance>0 and date>'2022-01-01'
    GROUP BY address)

    , tbl_result as(Select t.address,balance,date from terra.daily_balances as t inner join max_data
    on max_data.address = t.address and max_data.max_date = t.date
    where t.currency='UST' and balance>0 and date>'2022-01-01')

    select * from tbl_result
    order by balance DESC
    limit 20




    Run a query to Download Data