flipside

    collateral w/ OWP
    h4wkcollateral w/ OWP
    Updated 2025-01-20
    -- forked from borrowed tokens @ https://flipsidecrypto.xyz/studio/queries/4c02fb43-ca63-40b6-b2cd-5dfb60c5031b

    -- forked from loan total @ https://flipsidecrypto.xyz/studio/queries/8cd53e0a-71a2-4e63-8a8e-29a75176b3c1

    -- forked from loan timeline @ https://flipsidecrypto.xyz/studio/queries/9d819b99-7231-4758-b330-1d87cd591314

    -- lending 1 usdc -- 4gY2vuyzJSe7bRtUSMxqcivWx92Ch9sscdJP8WbXTRWPfXJGy13kZ6QXrCRvftcU3U21Sbxhir1YiveacuL5jUqe
    ---------------------
    -- borrowing 0.008 sol with 4 USDC as collateral -- 54iuK4UV5CKFsVnxWVLuhGjtCR9szfXz8enkhpbh28x3KiTGMJv82GrZngXh3wsSHTZXxLAr9kdDP8wu1tuVCUee
    -- Create order -> 54iuK4UV5CKFsVnxWVLuhGjtCR9szfXz8enkhpbh28x3KiTGMJv82GrZngXh3wsSHTZXxLAr9kdDP8wu1tuVCUee
    -- Refinanced 1 -> oWrxS83WqXjyRbtqWzP177BNqanV8hY3GcsouiEKLhNtMmp6vP18xMG6y62paMJ4qgSAqGMHhQgNrVpk1TnJYeS
    -- Refinanced 2 -> 3qgJyfzyMMZof2qFg6fgFWyMwQBtUXuB37Pi2NigrftiNKKxJAqxeJpW57zbxD7EJYSK4KyCFuVn3oTPu7zSkTXh
    -- Refinanced 3 -> 3Kw4ZEgKzfsZARQ7acNkW6YXJAK5e2Lgzt1BrmqLPEeQ1rmi5WgWxPRVyNfWMWy66oaFmC4DwPmUeUgufPbz32Z4
    -- Repay -> pTCkgD4y8W2Kyk1FteRysR7qDPRiBHuQH71tCsa6ce7xmnkhV3jUJhDTTreTst9wumqSNHRRELqBMDatAFasScu
    -- Order = new, Refinanced order = old
    -- Loan Vault = new, Refinanced Loan Vault = old

    ---> problems, some CLT/Borrow mint cannot find the value.

    with price as (
    select hour::date as price_date,
    token_address,
    symbol,
    case when token_address in ('jupSoLaHXQiZZTSfEWMTRRgpnyFm8f6sZdosWBjx93v',
    'HUBsveNpjo5pWqNkH57QzxjQASdTVXcSK7bVKTSZtcSX',
    'picobAEvs6w7QEknPce34wAE4gknZA9v5tTonnmHYdX',
    'Bybit2vBJGhPF52GBdNaQfUJ6ZpThSgHBobjWZpLPb4B',
    'he1iusmfkpAdwvxLNGV8Y1iSbj4rUy6yMhEA3fotn9A',
    'Grass7B4RdKfBCjTKgSqnXkqjwiGvQyFbuSCUJr3XXjs',
    'BNso1VUJnh4zcfpZa6986Ea66P6TCp59hvtNJ8b1X85') then 9
    when token_address in ('Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB',
    'CzLSujWBLFsSjncfkh59rUFqvafWcY5tzedWJSuypump',
    'DBRiDgJAMsM95moTzJs7M9LnkGErpbv9v6CUR1DXnUu5') then 6
    when token_address in ('cbbtcf3aa214zXHbiAZQwf4122FBYbraNdFqgw4iMij') then 8
    else decimals end as decimals,
    avg(price) as price
    Last run: about 1 month ago
    OWP Mint
    Borrow Token
    Collateral Volume
    OWP Token_1
    OWP Token_2
    Token_1 Vol
    Token_2 Vol
    Borrow Volume
    Lockbox Key
    User Address
    First Borrow
    Latest Refinance
    Loan Days
    1
    		Eia7v2jepJmd5suBmoH6TGWsoeBY7NXPvyS4CPwV4KZmUSDC15819.39ETHSOL5799.5710019.823340.875LqEAWav8ZUEfFPsmvrfWG8YmeH8KA3rc5wzjCG2i5ZZ67VABVhoSdcWy29XPHs4a9z99ggmWTgenLGxeWYo3o622025-02-11 12:33:22.0002025-02-18 12:52:22.0007
    2
    		7YRpt6KGUEBjNfET2fQrKz3uG5U8GrQASHsuK5KRELCLUSDC776.5USDCSOL426.82349.68599.93EWSogsifEfAocsHcKXcQcusVNaSikCe2oMXWQrQFaeReGhaX1R3DwQPLvnmGiJqvLY1558pN82dmR1oKYYjsEPAW2025-01-30 02:26:40.0002025-02-17 22:34:41.00018.83
    3
    		Gdh2BzgjqnwuciDw66aBkY53z8q8NF3ka5HyFJgpvEmUSDS304.73USDCJTO206.6598.07316.07ES8pGSDYsJujY4PSabRgK2ftMsH4EGC1VSrHA6PNK4y37Ch8hqspGqCnQmqRZ342wphzNiNVcrt71Bzvqde9DhEy2024-12-06 20:32:14.0002025-02-18 15:35:23.00073.79
    4
    		J6kgDFUwfcc9EdA6EUnUjxi2uAugDADtde754FrjRFT6USDC5.92JLPUSDC2.923326wdVuuE6NFBUCeXGnr9NwCfbCyuLoVT6ePNofvYX2ta1oopZTpJDLg59v8SQCuvhHGRhU56mkxQHkLW9FwBSU62025-01-07 22:27:02.0002025-02-18 18:54:08.00041.83
    5
    		5WukAsXWKN2aBRnLoXcw2zv8HqvL1izKRAsanC3gU57XPYUSD3.08WIFSOL0.622.463.133DrvSqLnTodv9Cwyxv7eL6jgFWENNXfZddaPkSRhEuF71oopZTpJDLg59v8SQCuvhHGRhU56mkxQHkLW9FwBSU62024-11-08 20:27:44.0002025-01-31 20:50:50.00084
    6
    		FmCLf39n5FjZLyjjuB27aXH3x9H5jdmBfLN6JkZYCht8USDC1.88$MICHISOL0.191.691.614BbsRvoQDdJepP3oMzuaZV94Nxp45bmtHAPJx1X7GakH1oopZTpJDLg59v8SQCuvhHGRhU56mkxQHkLW9FwBSU62024-11-29 17:30:27.0002024-12-18 17:57:14.00019
    7
    		GUPb5LzbVYCXzYHprcckJknuBZghw7aDYTEnoc1N2zzdPYUSD1.06JLPUSDC0.570.490.56BCjxh8g42cfzGfTAAaRapvTPgDVoRu3gaZVSzbk7uEQ31oopZTpJDLg59v8SQCuvhHGRhU56mkxQHkLW9FwBSU62024-11-08 14:15:31.0002025-02-18 15:35:45.000102.04
    7
    2KB
    559s