binhachonFolks Finance TVL - Deposited #1
Updated 2022-06-29
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 fasset_list as (
select
asset_id,
creator_address,
asset_name,
case
when asset_id = 686505742 then 0
when asset_id = 686508050 then 31566704
when asset_id = 686509463 then 312769
when asset_id = 686510134 then 386192725
when asset_id = 694408528 then 386195940
when asset_id = 694474015 then 694432641
when asset_id = 751289888 then 27165954
when asset_id = 776184808 then 552888874
when asset_id = 776185076 then 701273234
when asset_id = 747244426 then 552647097
when asset_id = 747244580 then 620996279
when asset_id = 743689704 then 694683000
when asset_id = 743689819 then 701364134
end as borrowed_asset_id,
decimals
from flipside_prod_db.algorand.asset
where asset_id in ( 686505742, --fALGO
686508050, --fUSDC
686509463, --fUSDt
686510134, --fgoBTC
694408528, --fgoETH
694474015, --fgALGO3
751289888, --PLANET
776184808, --USDC/USDt TMP1.1
776185076, --USDC/USDt PLP
747244426, --ALGO/USDC TMP1.1
747244580, --ALGO/USDC PLP
743689704, --ALGO/gALGO3 TMP1.1
743689819 --ALGO/gALGO3 PLP
)
Run a query to Download Data