flipside

    JLP Pool Account
    flyingfishJLP Pool Account
    Updated 15 hours ago
    with raw_data as (
    select
    livequery.live.udf_api(
    'POST',
    'https://api.mainnet-beta.solana.com',
    { },
    livequery.utils.udf_json_rpc_call(
    'getAccountInfo'
    , ['5BUwFW4nRbftYTDMbgxykoFWqWHPzahFSNAaaaJtVKsq'
    , {'encoding': 'base64'}
    ]
    )
    ):data:result.value.data[0] as account_data
    )

    , decoded_data as (

    select
    --'8ZptBBGxbbwEAAAAUG9vbAUAAABnWV3YRsAH8miW8q7TG6e1X9EszBWOCwB6nY/oRraf6YuqSkhkImzAIkhNyCgeGhaPXPToBT8a5QZtkWqIud+fQU2BSGrxPm7sni1bz0WRMuOkZkcJtm040GR3kSTGzj7e6As0E6LTEIBia5JsOK80vtGG2zaOl386v0vVRUSabTpX4svK0CiDUCPMq0rYe9J2To/BMtaOmGYJ6xNL14b52Be9JzsFAgAAAAAAAAAAAACA3WKyIQIAAAAAAAAAAADQBwAAAAAAAAAAAAAAAAAAAKicE0YCAAAGAAAAAAAAAAYAAAAAAAAAKAAAAAAAAAAoAAAAAAAAAHgAAAAAAAAAFAAAAAAAAAAUAAAAAAAAAJYAAAAAAAAAxAkAAAAAAACpcKlmAAAAALUVAAAAAAAAnT3KyywAAAAtAAAAAAAAAPz+CHC2ZAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=' as account_data
    account_data
    , TO_VARCHAR(BASE64_DECODE_BINARY(account_data)) AS hex_data
    , len(hex_data) as hex_data_len
    -- string
    , livequery.utils.udf_hex_to_string(substr(hex_data, 1 + 16, 16)) as account_name

    -- array of publicKey
    , livequery.utils.udf_hex_to_int(substr(hex_data, 1 + 32, 2)) as custody_accounts

    , livequery.utils.udf_hex_to_base58('0x' || substr(hex_data, 1 + 40, 64)) AS custody_1
    , livequery.utils.udf_hex_to_base58('0x' || substr(hex_data, 1 + 104, 64)) AS custody_2
    , livequery.utils.udf_hex_to_base58('0x' || substr(hex_data, 1 + 168, 64)) AS custody_3
    , livequery.utils.udf_hex_to_base58('0x' || substr(hex_data, 1 + 232, 64)) AS custody_4
    , livequery.utils.udf_hex_to_base58('0x' || substr(hex_data, 1 + 296, 64)) AS custody_5

    -- u128
    , livequery.utils.udf_hex_to_int(to_char(reverse(to_binary(substr(hex_data, 1 + 360, 32) ) ) ) ) / pow(10, 6) as aum_usd
    Last run: about 15 hours agoAuto-refreshes every 24 hours
    Data Timestamp
    ACCOUNT_NAME
    CUSTODY_ACCOUNTS
    CUSTODY_1
    CUSTODY_2
    CUSTODY_3
    CUSTODY_4
    CUSTODY_5
    AUM_USD
    MAX_AUM_USD
    TOKEN_WEIGHTAGE_BUFFER_BPS
    MAX_POSITION_USD
    INCREASE_POSITION_BPS
    DECREASE_POSITION_BPS
    ADD_REMOVE_LIQUIDITY_BPS
    SWAP_BPS
    TAX_BPS
    STABLE_SWAP_BPS
    STABLE_SWAP_TAX_BPS
    LIQUIDATION_REWARD_BPS
    PROTOCOL_SHARE_BPS
    LAST_EPOCH_UPDATED
    LAST_UPDATED
    FEE_APR_BPS
    REALIZED_FEE_USD
    MAX_REQUEST_EXECUTION_SEC
    INCEPTION_EPOCH_TIME
    INCEPTION_TIME
    1
    		2025-05-28 02:51:02Pool57xS2gz2bTp3fwCC7knJvUWTEU9Tycczu6VhJYKgi1wdzAQCGyheWPLeo6Qp9WpYS9m3Qj479t7R636N9ey1rEjEn5Pv3gM9JrFFH883SWAhvJC9RPYmo8UNxuFtv5bMMALkmG18jKKXQwBbrHeiK3C9MRXhkHsLHf7XgCSisykV46EZa4vkNeXiYEUizLdrpdPS1eC2mccyM4NUPRtERrk6ZETkk1608906640.34692175000000020000100100101010025150250017479296012025-05-22 16:00:01.00015563274656.8320834516896778322023-07-18 10:57:12.000
    1
    462B
    431s