[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_106":107,"_108":109},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","kamibaba","name","hyperliquid-market-bridge","path","account_checker.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":58,"_59":32,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/kamibaba/hyperliquid-market-bridge/code/account_checker.ts","extension","id","ef6405d3-1656-4eba-a21c-9a70c41c2715","fileId","960fd2b8-aa09-11f1-a49e-1607ee4eb77e","parentId","branchId","9b5029ed-e69a-483d-8cb3-234853c9a254","branchVersion",105,"latest",true,"createdAt",["D",1788742421944],"version",3,"fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst INFO = \"https://api.hyperliquid.xyz/info\";\nconst JST_MS = 9 * 60 * 60 * 1000;\nconst DAY_MS = 86_400_000;\nconst DEFAULT_EFFECTIVE_JST = \"2026-09-07\";\nconst DEFAULT_BASE_TARGET = 200;\n\nconst num = (v: unknown) => {\n const n = typeof v === \"number\" ? v : Number(String(v ?? \"0\").trim());\n return Number.isFinite(n) ? n : 0;\n};\nconst round = (v: number, dp = 6) => {\n const p = 10 ** dp;\n return Math.round((v + Number.EPSILON) * p) / p;\n};\nconst jstDateKey = (ms: number) => new Date(ms + JST_MS).toISOString().slice(0, 10);\nconst jstMidnightMs = (d: string) => Date.parse(`${d}T00:00:00+09:00`);\nconst fillKey = (f: any) => String(f?.tid ?? `${f?.time}|${f?.coin}|${f?.oid}|${f?.side}|${f?.px}|${f?.sz}`);\nconst fundingKey = (r: any) => `${String(r?.hash ?? \"\")}|${String(r?.time ?? \"\")}|${String(r?.delta?.coin ?? \"\")}|${String(r?.delta?.usdc ?? \"\")}`;\nconst projectDelta = (f: any) => {\n const d = String(f?.dir ?? \"\").toLowerCase();\n const s = Math.abs(num(f?.sz));\n if (d.includes(\"open long\")) return s;\n if (d.includes(\"close long\")) return -s;\n if (d.includes(\"open short\")) return -s;\n if (d.includes(\"close short\")) return s;\n return 0;\n};\nconst uniqueBy = (rows: any[], key: (r: any) => string) => {\n const m = new Map();\n for (const r of rows) m.set(key(r), r);\n return [...m.values()];\n};\n\nasync function post(body: Record) {\n const r = await fetch(INFO, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(body),\n });\n if (!r.ok) throw new Error(`HL_HTTP_${r.status}:${(await r.text()).slice(0, 200)}`);\n return await r.json();\n}\n\nasync function fetchRange(type: \"userFillsByTime\" | \"userFunding\", user: string, startTime: number, endTime: number, depth = 0): Promise {\n const body: any = { type, user, startTime, endTime };\n if (type === \"userFillsByTime\") body.aggregateByTime = false;\n const rows = await post(body);\n if (!Array.isArray(rows)) throw new Error(`${type}_NOT_ARRAY`);\n if (rows.length < 2000) return rows;\n if (depth >= 24 || endTime - startTime <= 1) throw new Error(`${type}_WINDOW_TOO_DENSE`);\n const mid = Math.floor((startTime + endTime) / 2);\n return [...await fetchRange(type, user, startTime, mid, depth + 1), ...await fetchRange(type, user, mid + 1, endTime, depth + 1)];\n}\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS strategy_oids (\n oid TEXT PRIMARY KEY, coin TEXT, side TEXT, venue TEXT, order_type TEXT,\n limit_px REAL, trigger_px REAL, orig_sz REAL, parent_oid TEXT,\n plan_id TEXT, registered_at TEXT NOT NULL\n)`);\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS strategy_tids (\n tid TEXT PRIMARY KEY, plan_id TEXT, registered_at TEXT NOT NULL\n)`);\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS strategy_seeds (\n coin TEXT PRIMARY KEY, signed_size REAL NOT NULL, at_time INTEGER NOT NULL,\n note TEXT, registered_at TEXT NOT NULL\n)`);\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS strategy_meta (\n key TEXT PRIMARY KEY, value TEXT NOT NULL\n)`);\n\nconst user = Deno.env.get(\"HL_ACCOUNT_ADDRESS\");\nif (!user) throw new Error(\"MISSING_HL_ACCOUNT_ADDRESS\");\nconst now = Date.now();\nconst todayJST = jstDateKey(now);\nconst metaRows = (await sqlite.execute(\"SELECT key,value FROM strategy_meta\")).rows as any[];\nconst meta = Object.fromEntries(metaRows.map((r: any) => [String(r.key), String(r.value)]));\nconst effectiveJST = meta.effective_from_jst || DEFAULT_EFFECTIVE_JST;\nconst effectiveStart = jstMidnightMs(effectiveJST);\nconst todayStart = jstMidnightMs(todayJST);\nconst baseTarget = num(meta.base_daily_target_usd) || DEFAULT_BASE_TARGET;\nconst priorCarry = num(meta.prior_carry_in_usd);\n\nconst [mainState, mainOrders, xyzState, xyzOrders, spotState, userAbstraction, fillsRaw, fundingRaw, oidRows, tidRows, seedRows] = await Promise.all([\n post({ type: \"clearinghouseState\", user }),\n post({ type: \"frontendOpenOrders\", user }),\n post({ type: \"clearinghouseState\", user, dex: \"xyz\" }),\n post({ type: \"frontendOpenOrders\", user, dex: \"xyz\" }),\n post({ type: \"spotClearinghouseState\", user }),\n post({ type: \"userAbstraction\", user }),\n fetchRange(\"userFillsByTime\", user, effectiveStart, now),\n fetchRange(\"userFunding\", user, effectiveStart, now),\n sqlite.execute(\"SELECT * FROM strategy_oids\"),\n sqlite.execute(\"SELECT * FROM strategy_tids\"),\n sqlite.execute(\"SELECT * FROM strategy_seeds\"),\n]);\n\nconst fills = uniqueBy(fillsRaw, fillKey).filter((f: any) => {\n const c = String(f?.coin ?? \"\");\n return c && !c.startsWith(\"@\") && /(Long|Short)/i.test(String(f?.dir ?? \"\"));\n}).sort((a: any, b: any) => num(a.time) - num(b.time));\nconst funding = uniqueBy(fundingRaw, fundingKey).sort((a: any, b: any) => num(a.time) - num(b.time));\nconst oidSet = new Set((oidRows.rows as any[]).map((r: any) => String(r.oid)));\nconst tidSet = new Set((tidRows.rows as any[]).map((r: any) => String(r.tid)));\nconst seeds = Object.fromEntries((seedRows.rows as any[]).map((r: any) => [String(r.coin), { signedSize: num(r.signed_size), atTime: num(r.at_time) }]));\nconst tagged = fills.filter((f: any) => oidSet.has(String(f?.oid ?? \"\")) || tidSet.has(String(f?.tid ?? \"\")));\n\nconst byCoin = new Map();\nfor (const f of tagged) {\n const c = String(f.coin);\n if (!byCoin.has(c)) byCoin.set(c, []);\n byCoin.get(c)!.push(f);\n}\nconst activeAt = (coin: string, t: number) => {\n const seed = seeds[coin];\n let pos = seed && seed.atTime <= t ? seed.signedSize : 0;\n for (const f of byCoin.get(coin) || []) {\n const ft = num(f.time);\n if (ft > t) break;\n if (seed && ft < seed.atTime) continue;\n pos += projectDelta(f);\n }\n return Math.abs(pos) > 1e-12;\n};\n\nlet accountGross = 0, accountFees = 0, accountFunding = 0;\nlet strategyGross = 0, strategyFees = 0, strategyFunding = 0, strategyFundingCount = 0;\nfor (const f of fills) {\n const t = num(f.time);\n if (t < todayStart || t > now) continue;\n accountGross += num(f.closedPnl);\n if (String(f.feeToken ?? \"USDC\").toUpperCase() === \"USDC\") accountFees += num(f.fee);\n}\nfor (const f of tagged) {\n const t = num(f.time);\n if (t < todayStart || t > now) continue;\n strategyGross += num(f.closedPnl);\n if (String(f.feeToken ?? \"USDC\").toUpperCase() === \"USDC\") strategyFees += num(f.fee);\n}\nfor (const r of funding) {\n const t = num(r.time);\n if (t < todayStart || t > now || String(r?.delta?.type ?? \"\") !== \"funding\") continue;\n const v = num(r?.delta?.usdc);\n accountFunding += v;\n const coin = String(r?.delta?.coin ?? \"\");\n if (activeAt(coin, t)) {\n strategyFunding += v;\n strategyFundingCount++;\n }\n}\n\nconst accountNet = accountGross - accountFees + accountFunding;\nconst strategyNet = strategyGross - strategyFees + strategyFunding;\nconst requiredToday = baseTarget + priorCarry;\nconst remainingToday = Math.max(0, requiredToday - strategyNet);\nconst positionRows = [\n ...(Array.isArray(mainState?.assetPositions) ? mainState.assetPositions : []),\n ...(Array.isArray(xyzState?.assetPositions) ? xyzState.assetPositions : []),\n].map((x: any) => x.position).filter((p: any) => Math.abs(num(p?.szi)) > 1e-12);\nconst openOrders = [\n ...(Array.isArray(mainOrders) ? mainOrders : []),\n ...(Array.isArray(xyzOrders) ? xyzOrders : []),\n];\nconst usdcBalance = (Array.isArray(spotState?.balances) ? spotState.balances : []).find((b: any) => String(b?.coin ?? \"\").toUpperCase() === \"USDC\");\nconst usdcTotal = usdcBalance ? num(usdcBalance.total) : null;\nconst usdcHold = usdcBalance ? num(usdcBalance.hold) : null;\nconst automatedAvailableBalance = userAbstraction === \"unifiedAccount\" && usdcTotal !== null && usdcHold !== null\n ? Math.max(0, usdcTotal - usdcHold)\n : null;\n\nconsole.log(JSON.stringify({\n checkerVersion: \"val-sqlite-v1.0.0\",\n authority: \"VAL_TOWN_SQLITE\",\n fetchedAt: new Date(now).toISOString(),\n jst: { date: todayJST, dayStartAt: new Date(todayStart).toISOString(), timezone: \"Asia/Tokyo\" },\n headroom: {\n accountAbstraction: String(userAbstraction ?? \"unknown\"),\n authoritativeMethod: automatedAvailableBalance !== null ? \"UNIFIED_ACCOUNT_USDC_TOTAL_MINUS_HOLD\" : \"UI_AVAILABLE_BALANCE_REQUIRED\",\n availableBalanceUSDC: automatedAvailableBalance !== null ? round(automatedAvailableBalance, 8) : null,\n usdcTotal: usdcTotal !== null ? round(usdcTotal, 8) : null,\n usdcHold: usdcHold !== null ? round(usdcHold, 8) : null,\n },\n positions: positionRows,\n openOrders,\n targetTracking: {\n authoritativeMethod: \"ACCOUNT_WIDE_JST_STRICT_REALIZED_PERP_NET\",\n todayStrictNetUSD: round(accountNet),\n grossClosedPnlUSD: round(accountGross),\n tradingFeesUSD: round(accountFees),\n fundingUSD: round(accountFunding),\n },\n strategyTracking: {\n authoritativeMethod: \"VAL_TOWN_SQLITE_TAGGED_HYPERLIQUID_FILLS_AND_FUNDING\",\n effectiveFromJST: effectiveJST,\n priorCarryInUSD: round(priorCarry),\n baseDailyTargetUSD: round(baseTarget),\n requiredTodayUSD: round(requiredToday),\n todayStrategyStrictNetUSD: round(strategyNet),\n remainingTodayUSD: round(remainingToday),\n todayGoalMet: remainingToday <= 0,\n grossClosedPnlUSD: round(strategyGross),\n tradingFeesUSD: round(strategyFees),\n fundingUSD: round(strategyFunding),\n fundingAttributedCount: strategyFundingCount,\n registeredOidCount: oidSet.size,\n registeredTidCount: tidSet.size,\n seededPositionCount: Object.keys(seeds).length,\n },\n recentPerpFills: fills.slice(-25).map((f: any) => ({\n time: num(f.time), at: new Date(num(f.time)).toISOString(), tid: String(f.tid ?? \"\"), oid: String(f.oid ?? \"\"),\n coin: String(f.coin ?? \"\"), dir: String(f.dir ?? \"\"), px: num(f.px), sz: num(f.sz),\n closedPnl: num(f.closedPnl), fee: num(f.fee), feeToken: String(f.feeToken ?? \"USDC\"),\n tagged: oidSet.has(String(f.oid ?? \"\")) || tidSet.has(String(f.tid ?? \"\")),\n })),\n}));\n","deleted",false,"label",[14],"87f5b472-21e5-4767-9ac3-e191e3944e56",["D",1788584474524],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Public market data only; on demand; no trading.","imageUrl","userId","0e061ab1-2aec-4517-be54-467ef7fcb625","pinnedFileId","01a06ff1-37fe-726c-835e-8d7a62a2a226","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a06fee-2d51-773c-94a7-f1125fac90b4","tursoName","87f5b47221e547679ac3e191e3944e56","tursoHostname","87f5b47221e547679ac3e191e3944e56-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789491713377],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_105":101},"org",{"_9":10,"_99":10,"_100":101,"_55":56,"_102":103,"_104":42},"branch",{"_35":89,"_11":90,"_22":28,"_91":45,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":12,"_98":10},"isOwned",187,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://avatars.githubusercontent.com/u/51115889?v=4","tier","free","canRestrictVals","profileImageUrl","ctx",{"_82":-5,"_139":140,"_141":142,"_143":144,"_145":42,"_146":42,"_147":42,"_148":32,"_149":-5,"_150":-7,"_151":-7,"_152":63,"_153":42,"_154":42,"_155":-5,"_156":42,"_157":42,"_158":42,"_159":-5},"ENV",{"_110":111,"_112":113,"_114":90,"_115":116,"_117":118,"_119":120,"_121":122,"_123":124,"_125":126,"_127":128,"_129":130,"_131":132,"_133":134,"_135":136,"_137":138},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]