ErsvanDetails asset stablecoins
    Updated 2022-06-03
    WITH w_stableCoins (ASSET_ID, ASSET_NAME, TOTAL_SUPPLY, DECIMALS, CREATOR_ADDRESS) AS
    (
    SELECT ASSET_ID, ASSET_NAME, TOTAL_SUPPLY, DECIMALS, CREATOR_ADDRESS FROM flipside_prod_db.algorand.asset
    WHERE
    ASSET_ID IN (
    312769 --Tether USDt
    ,31566704 --USDC
    ,2757561 --realioUSD
    ,465865291 --STBL
    ,684649988 --GARD
    ,506189856) --NCoin USD)
    )


    SELECT * FROM w_stableCoins



    /*
    312769 --Tether USDt
    31566704 --USDC
    2757561 --realioUSD
    465865291 --STBL
    684649988 --GARD
    506189856) --NCoin USD
    */
    Run a query to Download Data