[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_187":188,"_189":190},"routes/_app.x.$handle.$name",{"_104":103,"_37":49,"_112":94,"_32":106,"_13":14,"_113":-5,"_11":114,"_115":116,"_117":118,"_119":120,"_121":122,"_26":-5,"_123":-5,"_124":-5,"_125":30,"_126":127,"_128":63,"_129":-5,"_130":-5,"_131":132},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_47":48,"_37":49,"_42":50,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":87,"_88":89,"_90":91,"_92":30},"version",13,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","fea305f0-3563-433e-bc8d-40dabb4678e1","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":33,"_38":39,"_40":41,"_42":43,"_44":14,"_45":46,"_29":30},"previous","deleted",false,"deletedHere","path","send-report.ts","latestPath","fileId","56c7f0a2-aa5b-11f1-87d4-1607ee4eb77e","name","fileType","script","content","// One-off: send the current report to Telegram immediately\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { buildReport } from \"./bot.ts\";\n\nexport default async function () {\n const token = Deno.env.get(\"TELEGRAM_BOT_TOKEN\");\n const chatId = Deno.env.get(\"TELEGRAM_CHAT_ID\");\n if (!token || !chatId) throw new Error(\"Missing TELEGRAM_BOT_TOKEN / TELEGRAM_CHAT_ID\");\n\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS paper_wallet (\n id INTEGER PRIMARY KEY CHECK (id = 1),\n balance REAL NOT NULL DEFAULT 1000.0,\n initial_balance REAL NOT NULL DEFAULT 1000.0,\n total_scans INTEGER NOT NULL DEFAULT 0,\n total_trades INTEGER NOT NULL DEFAULT 0,\n winning_trades INTEGER NOT NULL DEFAULT 0,\n last_report_time INTEGER NOT NULL DEFAULT 0\n )`,\n );\n await sqlite.execute(`INSERT OR IGNORE INTO paper_wallet (id) VALUES (1)`);\n\n const text = await buildReport();\n const res = await fetch(`https://api.telegram.org/bot${token}/sendMessage`, {\n method: \"POST\",\n headers: { \"content-type\": \"application/json\" },\n body: JSON.stringify({ chat_id: chatId, text, parse_mode: \"HTML\" }),\n });\n const j = await res.json();\n console.log(\"telegram response:\", JSON.stringify(j));\n console.log(\"--- report ---\\n\" + text);\n}\n","createdAt",["D",1788744469920],"branchVersion","branchId","aac67d51-0543-407d-80be-a91c6aa86232","id","bc86fafd-3047-4c1e-b370-575e9419e36d","jup-arb-paper-bot",["D",1788215971075],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Jupiter v6 Solana arbitrage paper trading bot","imageUrl","ce1d74cb-7bc9-40a2-bbdd-2eb0b3916b37","pinnedFileId","f5e8ab64-a58c-11f1-91cb-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a059f6-d6ad-7343-b9ef-2e04007a610e","tursoName","bc86fafd30474c1eb370575e9419e36d","tursoHostname","bc86fafd30474c1eb370575e9419e36d-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789526460011],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_104":103,"_111":106},"org",{"_104":103,"_105":106,"_107":106,"_19":59,"_108":109,"_110":30},"branch",{"_13":93,"_37":94,"_47":46,"_95":48,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":49,"_102":103},"isOwned",21,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","moju","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_47":48,"_37":49,"_42":182,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":183,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":184,"_88":185,"_90":186,"_92":30},"tree",[169,170,171],"files",[169,170,171],"counts",{"_158":67,"_159":160,"_161":67,"_162":163,"_164":165},"contents",[133,134,135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_47":149,"_37":150,"_35":151,"_138":-5,"_45":46,"_44":152,"_140":30,"_42":153,"_13":154,"_38":155,"_40":156,"_29":30,"_144":-5,"_32":157},{"_47":146,"_37":33,"_35":36,"_138":-5,"_45":46,"_44":14,"_140":30,"_42":147,"_13":67,"_38":39,"_40":41,"_29":30,"_144":-5,"_32":148},{"_47":136,"_37":137,"_35":61,"_138":-5,"_45":46,"_44":139,"_140":63,"_42":141,"_13":67,"_38":142,"_40":143,"_29":30,"_144":-5,"_32":145},"968577be-4bb7-4838-b333-796f044de4d0","webhook.ts","parentId",2,"latest",["D",1788216026411],"http","// Telegram webhook handler — responds to /stats (and other commands).\n// Set the webhook to this endpoint's URL in Telegram:\n// https://api.telegram.org/bot/setWebhook?url=\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { buildReport } from \"./bot.ts\";\n\nexport async function http(req: Request) {\n let text = \"Unknown command. Try /stats.\";\n try {\n const update = await req.json();\n const msg = update?.message;\n const cmd: string = (msg?.text ?? \"\").split(/[ @]/)[0];\n\n if (cmd === \"/start\") {\n text = \"Solana Arb Paper Bot ready. Use /stats for the current report.\";\n } else if (cmd === \"/stats\" || cmd === \"/report\") {\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS paper_wallet (\n id INTEGER PRIMARY KEY CHECK (id = 1),\n balance REAL NOT NULL DEFAULT 1000.0,\n initial_balance REAL NOT NULL DEFAULT 1000.0,\n total_scans INTEGER NOT NULL DEFAULT 0,\n total_trades INTEGER NOT NULL DEFAULT 0,\n winning_trades INTEGER NOT NULL DEFAULT 0,\n last_report_time INTEGER NOT NULL DEFAULT 0\n )`,\n );\n await sqlite.execute(`INSERT OR IGNORE INTO paper_wallet (id) VALUES (1)`);\n text = await buildReport();\n }\n } catch (e) {\n text = \"Error: \" + (e instanceof Error ? e.message : String(e));\n }\n\n // If this came from a Telegram webhook, reply directly to the chat\n try {\n const update = await req.clone().json();\n const chatId = update?.message?.chat?.id;\n if (chatId) {\n const token = Deno.env.get(\"TELEGRAM_BOT_TOKEN\");\n if (token) {\n await fetch(`https://api.telegram.org/bot${token}/sendMessage`, {\n method: \"POST\",\n headers: { \"content-type\": \"application/json\" },\n body: JSON.stringify({ chat_id: chatId, text, parse_mode: \"HTML\" }),\n });\n return new Response(\"ok\");\n }\n }\n } catch { /* not a webhook call */ }\n\n return new Response(text, {\n headers: { \"content-type\": \"text/plain; charset=utf-8\" },\n });\n}\n","label",[137],"fb1bd667-b6a0-4491-bc3d-7c4bf7229a43",["D",1788744469920],[33],"040ef036-323c-4425-a82b-c8c71bf9c3ee","bot.ts","ef72a1e0-a58c-11f1-bfa9-1607ee4eb77e",12,["D",1788744387053],10,"interval","// Solana Arbitrage Paper Trading Bot — Jupiter Quote API v6\n// Runs every 1–2 minutes. Logs paper trades to SQLite, sends a Telegram\n// summary at most every 10 minutes. No per-trade notifications.\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// ---------- Config ----------\nconst USDC = \"EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v\";\nconst TOKENS: { symbol: string; mint: string }[] = [\n { symbol: \"RAY\", mint: \"4k3Dyjzvzp8eMZWUXbBCjEvwSkkk59S5iCNLY3QrkX6R\" },\n { symbol: \"PYTH\", mint: \"HZ1JovNiVvGrGNiiYvEozEVgZ58xaU3RKwX8eACQBCt3\" },\n { symbol: \"ORCA\", mint: \"orcaEKTdK7LKz57vaAYr9QeNsVEPfiu6QeMU1kektZE\" },\n { symbol: \"JTO\", mint: \"jtojtomepa8beP8AuQc6eXt5FriJwfFMwQx2v2f9mCL\" },\n { symbol: \"KMNO\", mint: \"KMNo3nJsBXfcpJTVhZcXLW7RmTwTt4GVFE7suUBo9sS\" },\n { symbol: \"DRIFT\", mint: \"DriFtupJYLTosbwoN8koMbEYSx54aFAVLddWsbksjwg7\" },\n { symbol: \"TNSR\", mint: \"TNSRxcUxoT9xBG3de7PiJyTDYu7kskLqcpddxnEJAS6\" },\n { symbol: \"RENDER\", mint: \"rndrizKT3MK1iimdxRdWabcF7Zg7AR5T4nud4EkHBof\" },\n];\n\nconst TRADE_AMOUNT_USDC = 100;\nconst SLIPPAGE_BPS = 30;\nconst GAS_FEE_USDC = 0.005;\nconst MIN_NET_PROFIT = 0.05;\nconst REPORT_INTERVAL_MS = 10 * 60 * 1000;\nconst JUP_QUOTE = \"https://lite-api.jup.ag/swap/v1/quote\";\n\nconst BASE58_RE = /^[1-9A-HJ-NP-Za-km-z]{32,44}$/;\n// Skip mints that are obviously invalid (bad length/base58) so Jupiter isn't spammed\nconst TOKENS_VALID = TOKENS.filter(\n (t) => BASE58_RE.test(t.mint),\n);\nconst TOKENS_SKIPPED = TOKENS.filter((t) => !TOKENS_VALID.includes(t));\n\n// ---------- DB ----------\nasync function initDb() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS paper_wallet (\n id INTEGER PRIMARY KEY CHECK (id = 1),\n balance REAL NOT NULL DEFAULT 1000.0,\n initial_balance REAL NOT NULL DEFAULT 1000.0,\n total_scans INTEGER NOT NULL DEFAULT 0,\n total_trades INTEGER NOT NULL DEFAULT 0,\n winning_trades INTEGER NOT NULL DEFAULT 0,\n last_report_time INTEGER NOT NULL DEFAULT 0\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS paper_trades (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n symbol TEXT NOT NULL,\n profit_loss REAL NOT NULL,\n arb_percent REAL NOT NULL,\n route TEXT NOT NULL,\n timestamp INTEGER NOT NULL\n )`);\n await sqlite.execute(\n `INSERT OR IGNORE INTO paper_wallet (id) VALUES (1)`,\n );\n}\n\ninterface Wallet {\n balance: number;\n initial_balance: number;\n total_scans: number;\n total_trades: number;\n winning_trades: number;\n last_report_time: number;\n}\n\nasync function getWallet(): Promise {\n const r = await sqlite.execute(\"SELECT * FROM paper_wallet WHERE id = 1\");\n return r.rows[0] as unknown as Wallet;\n}\n\n// ---------- Jupiter quotes (parallel) ----------\nasync function fetchQuote(inputMint: string, outputMint: string) {\n const url =\n `${JUP_QUOTE}?inputMint=${inputMint}&outputMint=${outputMint}` +\n `&amount=${BigInt(TRADE_AMOUNT_USDC * 1e6)}&slippageBps=${SLIPPAGE_BPS}` +\n `&onlyDirectRoutes=true`;\n const res = await fetch(url, {\n headers: { accept: \"application/json\" },\n });\n if (!res.ok) throw new Error(`Jupiter ${res.status}`);\n const j = await res.json();\n if (!j || !j.outAmount) throw new Error(\"no route\");\n return j;\n}\n\ninterface ArbResult {\n symbol: string;\n arbPercent: number;\n netProfit: number;\n route: string;\n}\n\nasync function checkToken(t: { symbol: string; mint: string }) {\n // USDC -> token, then token -> USDC (round-trip), concurrently\n const [buy, sell] = await Promise.all([\n fetchQuote(USDC, t.mint),\n fetchQuote(t.mint, USDC),\n ]);\n const outUsdc = Number(sell.outAmount) / 1e6;\n const grossProfit = outUsdc - TRADE_AMOUNT_USDC;\n const netProfit = grossProfit - GAS_FEE_USDC;\n const arbPercent = (grossProfit / TRADE_AMOUNT_USDC) * 100;\n return {\n symbol: t.symbol,\n arbPercent,\n netProfit,\n route:\n (buy.routePlan || [])\n .map((s: any) => s.swapInfo?.label ?? s.swapInfo?.ammKey ?? \"?\")\n .join(\" → \") || \"direct\",\n } as ArbResult;\n}\n\n// ---------- Telegram ----------\nasync function sendTelegram(text: string) {\n const token = Deno.env.get(\"TELEGRAM_BOT_TOKEN\");\n const chatId = Deno.env.get(\"TELEGRAM_CHAT_ID\");\n if (!token || !chatId) {\n console.log(\"[telegram] missing TELEGRAM_BOT_TOKEN / TELEGRAM_CHAT_ID; skipping send\");\n return false;\n }\n await fetch(`https://api.telegram.org/bot${token}/sendMessage`, {\n method: \"POST\",\n headers: { \"content-type\": \"application/json\" },\n body: JSON.stringify({ chat_id: chatId, text, parse_mode: \"HTML\" }),\n });\n return true;\n}\n\n// Shared by cron and the /stats HTTP handler\nexport async function buildReport() {\n const w = await getWallet();\n const since = w.last_report_time;\n const trades = await sqlite.execute(\n \"SELECT * FROM paper_trades WHERE timestamp > ? ORDER BY timestamp\",\n [since],\n );\n const recent = trades.rows as unknown as {\n symbol: string;\n profit_loss: number;\n arb_percent: number;\n route: string;\n timestamp: number;\n }[];\n\n const pnl = w.balance - w.initial_balance;\n const pnlPct = (pnl / w.initial_balance) * 100;\n const winRate = w.total_trades > 0 ? (w.winning_trades / w.total_trades) * 100 : 0;\n const avgArb = recent.length\n ? recent.reduce((s, t) => s + t.arb_percent, 0) / recent.length\n : 0;\n\n const lines = [\n \"📊 Solana Arb Paper Bot — 10min Report\",\n \"\",\n `💰 Balance: $${w.balance.toFixed(2)}`,\n `📈 PnL: ${pnl >= 0 ? \"+\" : \"\"}$${pnl.toFixed(4)} (${pnlPct.toFixed(3)}%)`,\n `🎯 Win Rate: ${winRate.toFixed(1)}% (${w.winning_trades}/${w.total_trades})`,\n `🔍 Total Scans: ${w.total_scans}`,\n `⚡ Trades (last 10m): ${recent.length}`,\n `📊 Avg Arb (last 10m): ${avgArb.toFixed(4)}%`,\n \"\",\n ];\n if (recent.length === 0) {\n lines.push(\"No trades captured in the last 10 minutes.\");\n } else {\n lines.push(\"Last 10m trades:\");\n for (const t of recent) {\n lines.push(\n `• ${t.symbol} | ${t.arb_percent.toFixed(3)}% | ` +\n `${t.profit_loss >= 0 ? \"+\" : \"\"}$${t.profit_loss.toFixed(4)} | ${t.route}`,\n );\n }\n }\n return lines.join(\"\\n\");\n}\n\nasync function maybeSendReport(w: Wallet): Promise {\n const now = Date.now();\n if (now - w.last_report_time < REPORT_INTERVAL_MS) return w;\n const report = await buildReport();\n await sendTelegram(report);\n await sqlite.execute(\n \"UPDATE paper_wallet SET last_report_time = ? WHERE id = 1\",\n [now],\n );\n return { ...w, last_report_time: now };\n}\n\n// ---------- Cron entrypoint ----------\n// One scan per invocation. The interval trigger handles repetition\n// (an in-code loop of 40 rounds × 5s exceeds the free-tier 1-minute timeout).\nexport default async function paperTradingBot() {\n await initDb();\n await runScanCycle();\n}\n\nasync function runScanCycle() {\n let w = await getWallet();\n\n // Parallel quote sweep across all tokens\n const results = await Promise.allSettled(TOKENS_VALID.map(checkToken));\n\n const arbs: ArbResult[] = [];\n for (const r of results) {\n if (r.status === \"fulfilled\") {\n arbs.push(r.value);\n } else {\n console.log(\"[scan] quote failed:\", r.reason?.message ?? r.reason);\n }\n }\n\n // Execute profitable paper trades (quiet — no per-trade notifications)\n let executed = 0;\n for (const a of arbs) {\n if (a.netProfit >= MIN_NET_PROFIT && w.balance >= TRADE_AMOUNT_USDC) {\n await sqlite.execute(\n `INSERT INTO paper_trades (symbol, profit_loss, arb_percent, route, timestamp)\n VALUES (?, ?, ?, ?, ?)`,\n [a.symbol, a.netProfit, a.arbPercent, a.route, Date.now()],\n );\n w = {\n ...w,\n balance: w.balance + a.netProfit,\n total_trades: w.total_trades + 1,\n winning_trades: w.winning_trades + 1,\n };\n executed++;\n }\n }\n\n w.total_scans += 1;\n await sqlite.execute(\n `UPDATE paper_wallet SET balance = ?, total_scans = ?, total_trades = ?, winning_trades = ?\n WHERE id = 1`,\n [w.balance, w.total_scans, w.total_trades, w.winning_trades],\n );\n\n console.log(\n `[scan] quotes ok: ${arbs.length}/${TOKENS_VALID.length}, executed: ${executed}, balance: $${w.balance.toFixed(2)}`,\n );\n if (TOKENS_SKIPPED.length) {\n console.log(\n \"[scan] skipped invalid mints:\",\n TOKENS_SKIPPED.map((t) => t.symbol).join(\", \"),\n );\n }\n\n // At most one Telegram summary per 10 minutes\n await maybeSendReport(w);\n}\n",[150],"pulls","branches",1,"forks","envVars",{"_166":139,"_168":67},"connections",{"_166":67,"_167":67},"count","unfilledCount","emptyCount",{"_47":149,"_37":150,"_35":151,"_138":-5,"_45":46,"_44":152,"_140":30,"_42":179,"_13":154,"_38":155,"_40":156,"_29":30,"_144":-5,"_173":180,"_32":181},{"_47":146,"_37":33,"_35":36,"_138":-5,"_45":46,"_44":14,"_140":30,"_42":176,"_13":67,"_38":39,"_40":41,"_29":30,"_144":-5,"_173":177,"_32":178},{"_47":136,"_37":137,"_35":61,"_138":-5,"_45":46,"_44":139,"_140":63,"_42":172,"_13":67,"_38":142,"_40":143,"_29":30,"_144":-5,"_173":174,"_32":175},["D",1788216026411],"children",[],[137],["D",1788744469920],[],[33],["D",1788744387053],[],[150],["D",1788215971075],["D",1789526460011],{"_104":103,"_111":106},{"_104":103,"_105":106,"_107":106,"_19":59,"_108":109,"_110":30},{"_13":93,"_37":94,"_47":46,"_95":48,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":49,"_102":103},"ctx",{"_86":-5,"_130":220,"_221":222,"_223":224,"_225":30,"_226":30,"_227":30,"_228":63,"_229":-5,"_230":-7,"_231":-7,"_232":67,"_233":30,"_234":30,"_235":-5,"_236":30,"_237":30,"_238":30,"_239":-5},"ENV",{"_191":192,"_193":194,"_195":94,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219},"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",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v13