h4wkloan timeline
Updated 2024-11-28
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- 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
from solana.price.ez_prices_hourly
where hour::date >= '2024-11-05'
group by all
)
QueryRunArchived: QueryRun has been archived