binhachonFolks Finance TVL - Deposited #1
    Updated 2022-06-29
    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