jp12[OSMO] Bug Exploiters - Per Pool
    Updated 2022-06-14
    WITH jdata as (

    select '{
    "vault_data":
    [{"symbol": "ION", "denom": "uion", "price": 901.2415907289011}
    ,{"symbol": "ATOM", "denom": "ibc/27394FB092D2ECCD56123C74F36E4C1F926001CEADA9CA97EA622B25F41E5EB2", "price": 9.419861882554208}
    ,{"symbol": "AKT", "denom": "ibc/1480B8FD20AD5FCAE81EA87584D269547DD4D436843C1D20F15E00EB64743EF4", "price": 0.34922783600524077}
    ,{"symbol": "XPRT", "denom": "ibc/A0CC0CF735BFB30E730C70019D4218A1244FF383503FF7579C9201AB93CA9293", "price": 1.381620130778327}
    ,{"symbol": "IRIS", "denom": "ibc/7C4D60AA95E5A7558B0A364860979CA34B7FF8AAF255B87AF9E879374470CEC0", "price": 0.0244467298543281}
    ,{"symbol": "DVPN", "denom": "ibc/9712DBB13B9631EDFA9BF61B55F1B2D290B2ADB67E3A4EB3A875F3B6081B3B84", "price": 0.0014306305334162999}
    ,{"symbol": "REGEN", "denom": "ibc/1DCC8A6CB5689018431323953344A9F6CC4D0BFB261E88C9F7777372C10CD076", "price": 0.32060717495837876}
    ,{"symbol": "CRO", "denom": "ibc/E6931F78057F7CC5DA0FD6CEF82FF39373A6E0452BF1FD76910B93292CF356C1", "price": 0.17790777510495}
    ,{"symbol": "IOV", "denom": "ibc/52B1AA623B34EB78FD767CEA69E8D7FA6C9CFE1FBF49C5406268FD325E2CC2AC", "price": 0.0276612683659155}
    ,{"symbol": "TICK", "denom": "ibc/655BCEF3CDEBE32863FF281DBBE3B06160339E9897DC9C9C9821932A5F8BA6F8", "price": 0.4027368348934557}
    ,{"symbol": "EEUR", "denom": "ibc/5973C068568365FFF40DEDCF1A1CB7582B6116B731CD31A12231AE25E20B871F", "price": 1.0136578340008713}
    ,{"symbol": "NGM", "denom": "ibc/1DC495FCEFDA068A3820F903EDBD78B942FBD204D7E93D3BA2B432E9669D1A59", "price": 0.6919927498542117}
    ,{"symbol": "BCNA", "denom": "ibc/D805F1DA50D31B96E4282C1D4181EDDFB1A44A598BFF5666F4B43E4B8BEA95A5", "price": 0.014288225525700901}
    ,{"symbol": "LUNA", "denom": "ibc/0EF15DF2F02480ADE0BB6E85D9EBB5DAEA2836D3860E9F97F9AADE4F57A31AA0", "price": 4.86041604111e-05}
    ,{"symbol": "LIKE", "denom": "ibc/9989AD6CCA39D1131523DB0617B50F6442081162294B4795E26746292467B525", "price": 0.0024598378860000002}
    ,{"symbol": "UST", "denom": "ibc/BE1BB42D4BE3C30D50B68D7C41DB4DFCE9678E8EF8C539F6E6A9345048894FCC", "price": 0.0086640074588253}
    ,{"symbol": "JUNO", "denom": "ibc/46B44899322F3CD854D2D46DEEF881958467CDD4B3B10086DA49296BBED94BED", "price": 3.7344029425363066}
    ,{"symbol": "IXO", "denom": "ibc/F3FF7A84A73B62921538642F9797C423D2B4C4ACB3C7FCFFCE7F12AA69909C4B", "price": 0.1074952398695577}
    ,{"symbol": "XKI", "denom": "ibc/B547DC9B897E7C3AA5B824696110B8E3D2C31E3ED3F02FF363DCBAD82457E07E", "price": 0.0786558545103051}
    ,{"symbol": "BTSG", "denom": "ibc/4E5444C35610CC76FC94E7F7886B93121175C28262DDFDDE6F84E82BF2425452", "price": 0.0166805855860554}
    ,{"symbol": "BOOT", "denom": "ibc/FE2CD1E6828EC0FAB8AF39BAC45BC25B965BA67CCBC50C13A14BD610B0D1E2C4", "price": 2.2282665111957e-08}
    ,{"symbol": "SCRT", "denom": "ibc/0954E1C28EB7AF5B72D24F3BC2B47BBB2FDF91BDDFD57B74B99E133AED40972A", "price": 1.303759474770078}
    ,{"symbol": "MED", "denom": "ibc/3BCCC93AD5DF58D11A6F8A05FA8BC801CBA0BA61A981F57E91B8B598BF8061CB", "price": 0.028320572005851297}
    ,{"symbol": "CMDX", "denom": "ibc/EA3E1640F9B1532AB129A571203A0B9F789A7F14BB66E350DCBFA18E1A1931F0", "price": 0.3443737484561466}
    ,{"symbol": "CHEQ", "denom": "ibc/7A08C6F11EF0F59EB841B9F788A87EC9F2361C7D9703157EC13D940DC53031FA", "price": 0.039513941314199996}
    ,{"symbol": "STARS", "denom": "ibc/987C17B11ABC2B20019178ACE62929FE9840202CE79498E29FE8E5CB02B7C0A4", "price": 0.032098245677113196}
    ,{"symbol": "LUM", "denom": "ibc/8A34AF0C1943FD0DFCDE9ADBF0B2C9959C45E87E6088EA2FC6ADACD59261B8A2", "price": 0.0013626160158684}
    ,{"symbol": "VDL", "denom": "ibc/E7B35499CFBEB0FF5778127ABA4FB2C4B79A6B8D3D831D4379C4048C238796BD", "price": 0.0388842787207905}
    ,{"symbol": "HUAHUA", "denom": "ibc/B9E0A1A524E98BB407D3CED8720EFEFD186002F90C1B1B7964811DD0CCC12228", "price": 4.69158171348e-05}
    ,{"symbol": "DSM", "denom": "ibc/EA4C0A9F72E2CEDF10D0E7A9A6A22954DB3444910DB5BE980DF59B05A46DAD1C", "price": 0.020904272590374296}
    ,{"symbol": "DIG", "denom": "ibc/307E5C96C8F60D1CBEE269A9A86C0834E1DB06F2B3788AE4F716EDB97A48B97D", "price": 0.0003890904481587}
    ,{"symbol": "SOMM", "denom": "ibc/9BBA9A1C257E971E38C1422780CE6F0B0686F0A3085E2D61118D904BFE0F5F5E", "price": 0.481296017774841}
    Run a query to Download Data