SajjadiiiLoan-to-Deposit Ratio (LDR)
    Updated 2025-04-03
    WITH atoken_prices AS (
    SELECT
    hour AS prices_hour,
    '0x15d9f3ab1982b0e5a415451259994ff40369f584' AS underlying_address,
    'BTCB' AS symbol,
    NULL AS name,
    18 AS decimals,
    price AS hourly_price,
    'kaia' AS blockchain,
    NULL AS is_native,
    NULL AS is_imputed,
    NULL AS is_deprecated,
    SYSDATE() AS inserted_timestamp,
    SYSDATE() AS modified_timestamp
    FROM ethereum.price.ez_prices_hourly
    WHERE token_address = '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599' -- WBTC

    UNION ALL

    SELECT
    hour AS prices_hour,
    '0x608792deb376cce1c9fa4d0e6b7b44f507cffa6a' AS underlying_address,
    'USDC' AS symbol,
    NULL AS name,
    6 AS decimals,
    1 AS hourly_price,
    'kaia' AS blockchain,
    NULL AS is_native,
    NULL AS is_imputed,
    NULL AS is_deprecated,
    SYSDATE() AS inserted_timestamp,
    SYSDATE() AS modified_timestamp
    FROM kaia.price.ez_prices_hourly
    WHERE symbol = 'KLAY'

    UNION ALL
    Last run: 3 months ago
    DATE
    TOKEN_SYMBOL
    TOTAL_DEPOSIT
    TOTAL_BORROW
    LOAN_TO_DEPOSIT_RATIO_PERCENTAGE
    1
    2024-11-20 00:00:00.000WKLAY0.2171790.07239333.333333333
    2
    2024-11-23 00:00:00.000WKLAY1786.1517.86151
    3
    2024-11-24 00:00:00.000BTCB2203.0925454651097.82531463849.83110296
    4
    2024-11-25 00:00:00.000WKLAY0.29194919620.00415615861.42358967
    5
    2024-11-29 00:00:00.000BTCB2.88482.8848100
    6
    2024-11-29 00:00:00.000USDC2.10.36717817.484666667
    7
    2024-11-29 00:00:00.000USDT12.5787011.1000148.74505245
    8
    2024-11-29 00:00:00.000WETH2.1412451.7834183.288460685
    9
    2024-11-29 00:00:00.000WKLAY46.88676430.60305508265.270136967
    10
    2024-11-30 00:00:00.000WKLAY7.99020.03923260.491008986
    11
    2024-12-02 00:00:00.000BTCB4101.0232868974123.058954811100.537321209
    12
    2024-12-02 00:00:00.000USDC1796191.8317431013856.20368356.444761955
    13
    2024-12-02 00:00:00.000USDT2136389.5805651035546.01977148.471778237
    14
    2024-12-02 00:00:00.000WKLAY1669841.507963512920937.67252743174.923048601
    15
    2024-12-03 00:00:00.000BTCB249136.367202822128748.21497951.677808593
    16
    2024-12-03 00:00:00.000USDC764928.502675165.7141220.02166400146
    17
    2024-12-03 00:00:00.000USDT1706004.186796220755.74583812.939929899
    18
    2024-12-03 00:00:00.000WETH45032.7004208075632.95234391612.508582189
    19
    2024-12-03 00:00:00.000WKLAY2401850.285046691147916.1954326447.792995366
    20
    2024-12-04 00:00:00.000BTCB11621.690959802170.4888311361.466988167
    ...
    175
    13KB
    68s