LTirrellUntitled Query
    Updated 2022-04-26
    -- select
    -- balance,
    -- balance_type,
    -- address,
    -- address_label
    -- from terra.daily_balances
    -- where date = current_date and currency = 'LUNA' and balance > 0
    -- AND address_label ilike ('terra%') and balance_type = 'staked'
    -- -- group by balance_type
    -- ORDER BY balance DESC
    select * from terra.daily_balances
    where date = CURRENT_DATE-1 and currency = 'LUNA'
    and address='terra1sk06e3dyexuq4shw77y3dsv480xv42mq73anxu'
    -- and address NOT IN (
    -- 'terra1fl48vsnmsdzcv85q5d2q4z5ajdha8yu3nln0mh',
    -- 'terra1dp0taj85ruc299rkdvzp4z5pfg6z6swaed74e6'
    -- )
    -- and balance > 0 and address_name is not NULL
    order by balance DESC
    limit 100
    Run a query to Download Data