OWP Borrow

h4wkOWP Borrow

Updated 2025-01-20

-- forked from collateral w/ OWP @ https://flipsidecrypto.xyz/studio/queries/4f280b3f-1308-4099-8b04-4bc69142f7f8

-- 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

Last run: about 2 months ago

70B

503s