LTirrellUntitled Query
    Updated 2022-01-26
    with loop_pools as (
    SELECT
    *
    FROM
    crosschain.address_labels
    where
    blockchain = 'terra'
    and project_name = 'loop'
    and label_type = 'dex'
    )
    SELECT
    bal.date,
    bal.address as pool_adr,
    address_name,
    bal.balance_usd as balance_usd,
    bal.balance as balance,
    case
    when address_name = 'LOOP token/loopr LP' then 'loop-loopr'
    when address_name = 'bLUNA/uusd LP' then 'bluna-ust'
    when address_name = 'ANC token/uusd LP' then 'anc-ust'
    when address_name = 'uusd/SWAP LP' then 'swap-ust'
    when address_name = 'MIR token/uusd LP' then 'mir-ust'
    when address_name = 'spec/uusd LP' then 'spec-ust'
    when address_name = 'orion/uusd LP' then 'orion-ust'
    when address_name = 'dph/uusd LP' then 'dph-ust'
    when address_name = 'twd/uusd LP' then 'twd-ust'
    when address_name = 'SEXY/uusd LP' then 'SEXY-ust'
    when address_name = 'LOTA/uusd LP' then 'lota-ust'
    when address_name = 'LOOP token/LOTA LP' then 'loop-lota'
    when address_name = 'whweth/uluna LP' then 'weweth-luna'
    when address_name = 'MINE token/uusd LP' then 'mine-ust'
    when address_name = 'aUST/uusd LP' then 'aust-ust'
    when address_name = 'whwbtc/uusd LP' then 'wewbtc-ust'
    when address_name = 'halo/uusd LP' then 'halo-ust'
    when address_name = 'aUST/uluna LP' then 'luna-aust'
    when address_name = 'loopr/uusd LP' then 'loopr-ust'
    Run a query to Download Data