LTirrellUntitled Query
Updated 2022-01-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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