[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_270":271,"_272":273},"routes/_app.x.$handle.$name",{"_98":97,"_32":45,"_107":88,"_27":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":25,"_122":123,"_124":25,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",36,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","daily_report.ts","latestPath","fileId","e4d003a8-9f2a-11f1-9a39-1607ee4eb77e","name","fileType","interval","content","import { email } from \"https://esm.town/v/std/email\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst TO=\"pmerich9@gmail.com\";\nexport default async function(){\n const since=Date.now()-86400000;\n const runs=await sqlite.execute({sql:\"SELECT COUNT(*) n, SUM(CASE WHEN status LIKE 'ok%' THEN 1 ELSE 0 END) okruns, MAX(ts) last_ts, MAX(universe) max_universe, SUM(alerts) alerts FROM runs WHERE ts>?\",args:[since]});\n const paper=await sqlite.execute(\"SELECT COUNT(*) n, AVG(result_r) avg_r, SUM(CASE WHEN result_r>0 THEN 1 ELSE 0 END) wins, SUM(CASE WHEN result_r<=0 THEN 1 ELSE 0 END) losses, MIN(result_r) worst_r, MAX(result_r) best_r FROM paper_signals WHERE status='CLOSED'\");\n const open=await sqlite.execute(\"SELECT COUNT(*) n FROM paper_signals WHERE status='OPEN'\");\n const cat=await sqlite.execute(\"SELECT COUNT(*) n FROM catalog100k\");\n const dex=await sqlite.execute(\"SELECT COUNT(*) n FROM dex_candidates\");\n const r:any=runs.rows?.[0]||{},p:any=paper.rows?.[0]||{},o:any=open.rows?.[0]||{},c:any=cat.rows?.[0]||{},d:any=dex.rows?.[0]||{};\n const total=Number(p.n||0),wins=Number(p.wins||0);const winRate=total?wins/total*100:0;\n const text=`Crypto Radar Daily Health Report\\n\\n24h scanner runs: ${r.n||0}\\nSuccessful runs: ${r.okruns||0}\\nLargest universe scanned: ${r.max_universe||0}\\nAlerts in last 24h: ${r.alerts||0}\\nCatalog assets: ${c.n||0}\\nDEX candidates: ${d.n||0}\\n\\nPaper performance\\nClosed trades: ${total}\\nOpen trades: ${o.n||0}\\nWin rate: ${winRate.toFixed(1)}%\\nAverage R: ${Number(p.avg_r||0).toFixed(3)}\\nBest R: ${Number(p.best_r||0).toFixed(3)}\\nWorst R: ${Number(p.worst_r||0).toFixed(3)}\\n\\nNo real-money orders are executed automatically.\\nUTC ${new Date().toISOString()}`;\n await email({to:TO,subject:\"Crypto Radar — täglicher Kontrollbericht\",text});\n console.log(JSON.stringify({ok:true,runs24h:r.n||0,catalog:c.n||0,dex:d.n||0,closed:total,open:o.n||0,winRate,avgR:Number(p.avg_r||0)}));\n}","import { email } from \"https://esm.town/v/std/email\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst TO=\"pmerich9@gmail.com\";\nexport default async function(){\n const since=Date.now()-86400000;\n const runs=await sqlite.execute({sql:\"SELECT COUNT(*) n, SUM(CASE WHEN status LIKE 'ok%' THEN 1 ELSE 0 END) okruns, MAX(ts) last_ts, MAX(universe) max_universe, SUM(alerts) alerts FROM runs WHERE ts>?\",args:[since]});\n const paper=await sqlite.execute(\"SELECT COUNT(*) n, AVG(result_r) avg_r, SUM(CASE WHEN result_r>0 THEN 1 ELSE 0 END) wins, SUM(CASE WHEN result_r<=0 THEN 1 ELSE 0 END) losses, MIN(result_r) worst_r, MAX(result_r) best_r FROM paper_signals WHERE status='CLOSED'\");\n const open=await sqlite.execute(\"SELECT COUNT(*) n FROM paper_signals WHERE status='OPEN'\");\n const cat=await sqlite.execute(\"SELECT COUNT(*) n FROM catalog100k\");\n const dex=await sqlite.execute(\"SELECT COUNT(*) n FROM dex_candidates\");\n const r:any=runs.rows?.[0]||{},p:any=paper.rows?.[0]||{},o:any=open.rows?.[0]||{},c:any=cat.rows?.[0]||{},d:any=dex.rows?.[0]||{};\n const total=Number(p.n||0),wins=Number(p.wins||0);const winRate=total?wins/total*100:0;\n const text=`Crypto Radar Daily Health Report\\n\\n24h scanner runs: ${r.n||0}\\nSuccessful runs: ${r.okruns||0}\\nLargest universe scanned: ${r.max_universe||0}\\nAlerts in last 24h: ${r.alerts||0}\\nCatalog assets: ${c.n||0}\\nDEX candidates: ${d.n||0}\\n\\nPaper performance\\nClosed trades: ${total}\\nOpen trades: ${o.n||0}\\nWin rate: ${winRate.toFixed(1)}%\\nAverage R: ${Number(p.avg_r||0).toFixed(3)}\\nBest R: ${Number(p.best_r||0).toFixed(3)}\\nWorst R: ${Number(p.worst_r||0).toFixed(3)}\\n\\nNo real-money orders are executed automatically.\\nUTC ${new Date().toISOString()}`;\n await email({subject:\"Crypto Radar — täglicher Kontrollbericht\",text});\n console.log(JSON.stringify({ok:true,runs24h:r.n||0,catalog:c.n||0,dex:d.n||0,closed:total,open:o.n||0,winRate,avgR:Number(p.avg_r||0)}));\n}","createdAt",["D",1787514227045],"branchVersion","branchId","1f24721f-2036-411a-8118-e59c45c9688a","id","260f4b93-b540-4d31-969e-570a1c5b874e","crypto-radar-live",["D",1787512804582],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","15-minute crypto paper-trading radar","imageUrl","ca9c5969-d2d6-409f-a9d8-f2ac1832a2bb","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a0300b-b4a4-7719-9801-d3db2883fcca","tursoName","260f4b93b5404d31969e570a1c5b874e","tursoHostname","260f4b93b5404d31969e570a1c5b874e-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789523429989],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_106":102},"org",{"_98":97,"_99":100,"_101":102,"_18":55,"_103":104,"_105":25},"branch",{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"isOwned",80,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","ericmller","handle","displayName","Eric Müller","avatar","https://lh3.googleusercontent.com/a/ACg8ocI1PZC2VDTkYbxcPEYqtRMNHUOsc4NQYVI5LprQjEJLXuAh=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":265,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":266,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":267,"_82":268,"_84":269,"_86":25},"tree",[224,225,226,227,228,229,230,231,232,233],"files",[224,225,226,227,228,229,230,231,232,233],"counts",{"_213":61,"_214":215,"_216":61,"_217":218,"_219":220},"contents",[129,130,131,132,133,134,135,136,137,138],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":206,"_32":207,"_30":208,"_142":-5,"_41":42,"_40":209,"_144":25,"_38":210,"_13":197,"_33":34,"_35":211,"_24":25,"_148":-5,"_27":212},{"_43":199,"_32":200,"_30":201,"_142":-5,"_41":42,"_40":202,"_144":25,"_38":203,"_13":197,"_33":155,"_35":204,"_24":25,"_148":-5,"_27":205},{"_43":195,"_32":28,"_30":31,"_142":-5,"_41":42,"_40":14,"_144":25,"_38":196,"_13":197,"_33":34,"_35":37,"_24":25,"_148":-5,"_27":198},{"_43":187,"_32":188,"_30":189,"_142":-5,"_41":42,"_40":190,"_144":25,"_38":191,"_13":192,"_33":34,"_35":193,"_24":25,"_148":-5,"_27":194},{"_43":180,"_32":181,"_30":182,"_142":-5,"_41":42,"_40":183,"_144":25,"_38":184,"_13":61,"_33":34,"_35":185,"_24":25,"_148":-5,"_27":186},{"_43":173,"_32":174,"_30":175,"_142":-5,"_41":42,"_40":176,"_144":25,"_38":177,"_13":61,"_33":155,"_35":178,"_24":25,"_148":-5,"_27":179},{"_43":165,"_32":166,"_30":167,"_142":-5,"_41":42,"_40":168,"_144":25,"_38":169,"_13":170,"_33":34,"_35":171,"_24":25,"_148":-5,"_27":172},{"_43":158,"_32":159,"_30":160,"_142":-5,"_41":42,"_40":161,"_144":25,"_38":162,"_13":61,"_33":34,"_35":163,"_24":25,"_148":-5,"_27":164},{"_43":150,"_32":151,"_30":152,"_142":-5,"_41":42,"_40":153,"_144":25,"_38":154,"_13":61,"_33":155,"_35":156,"_24":25,"_148":-5,"_27":157},{"_43":139,"_32":140,"_30":141,"_142":-5,"_41":42,"_40":143,"_144":25,"_38":145,"_13":146,"_33":34,"_35":147,"_24":25,"_148":-5,"_27":149},"ce2c963a-a5a1-4ebe-8ebf-578df157584d","main.ts","a50eab96-9f27-11f1-a19c-1607ee4eb77e","parentId",33,"latest",["D",1787514149661],12,"import { email } from \"https://esm.town/v/std/email\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst TO=\"pmerich9@gmail.com\";\nconst BROAD_LIMIT=10000;\nconst DEEP_LIMIT=50;\nconst MAX_SPREAD_BPS=40;\nconst MIN_REL_VOL=1.25;\nconst MIN_RR=2;\nconst STABLE=new Set([\"USDT\",\"USDC\",\"DAI\",\"FDUSD\",\"TUSD\",\"USDE\",\"PYUSD\",\"USDD\"]);\nconst avg=(a:number[])=>a.length?a.reduce((x,y)=>x+y,0)/a.length:0;\nasync function j(u:string){const r=await fetch(u,{headers:{\"User-Agent\":\"crypto-radar/2.0\"}});if(!r.ok)throw new Error(`HTTP ${r.status} ${u}`);return r.json()}\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS alerts(symbol TEXT PRIMARY KEY,last_ts INTEGER NOT NULL);`);await sqlite.execute(`CREATE TABLE IF NOT EXISTS runs(ts INTEGER,status TEXT,universe INTEGER,alerts INTEGER,error TEXT);`);await sqlite.execute(`CREATE TABLE IF NOT EXISTS paper_signals(id INTEGER PRIMARY KEY AUTOINCREMENT,symbol TEXT,product TEXT,entry REAL,stop REAL,tp1 REAL,tp2 REAL,rr REAL,relvol REAL,spread REAL,broad_score REAL,source TEXT,created_ts INTEGER,status TEXT DEFAULT 'OPEN',closed_ts INTEGER,result_r REAL,exit_reason TEXT);`);await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_paper_open ON paper_signals(status,created_ts);`)}\n\nfunction broadScore(c:any){const vol=Number(c.volume24||0),cap=Number(c.market_cap_usd||0),h=Number(c.percent_change_1h||0),d=Number(c.percent_change_24h||0),w=Number(c.percent_change_7d||0);const vm=vol/Math.max(cap,1);let score=Math.min(8,Math.max(-8,h))*2+Math.min(20,Math.max(-20,d))*.6+Math.min(40,Math.max(-40,w))*.15+Math.min(5,vm*10);if(vol<500000)score-=12;if(cap<2000000)score-=8;return score;}\n\nasync function broadUniverse(){const first:any=await j(\"https://api.coinlore.net/api/tickers/?start=0&limit=100\");const total=Math.min(BROAD_LIMIT,Number(first?.info?.coins_num||BROAD_LIMIT));const pages=Math.ceil(total/100);const all:any[]=[...(first?.data||[])];for(let base=1;basebase+k);const batch=await Promise.all(idx.map(async p=>{try{const r:any=await j(`https://api.coinlore.net/api/tickers/?start=${p*100}&limit=100`);return r?.data||[]}catch{return []}}));for(const b of batch)all.push(...b)}return all.slice(0,total).filter(c=>!STABLE.has(String(c.symbol||\"\").toUpperCase())).map(c=>({id:c.id,symbol:String(c.symbol||\"\").toUpperCase(),name:c.name,score:broadScore(c),rank:Number(c.rank||0),price:Number(c.price_usd||0),marketCap:Number(c.market_cap_usd||0),volume24:Number(c.volume24||0),chg1h:Number(c.percent_change_1h||0),chg24h:Number(c.percent_change_24h||0),chg7d:Number(c.percent_change_7d||0)})).sort((a,b)=>b.score-a.score)}\n\nasync function scanCoinbase(c:any){const product=`${c.symbol}-USD`;const [t,k]:any[]=await Promise.all([j(`https://api.exchange.coinbase.com/products/${product}/ticker`),j(`https://api.exchange.coinbase.com/products/${product}/candles?granularity=300`)]);if(!Array.isArray(k)||k.length<22)return null;const bid=Number(t.bid),ask=Number(t.ask),spread=((ask-bid)/Math.max(bid,1e-12))*10000;if(!Number.isFinite(spread)||spread>MAX_SPREAD_BPS)return null;const rows=k.slice(0,30).reverse(),cl=rows.map((x:any[])=>Number(x[4])),hi=rows.map((x:any[])=>Number(x[2])),lo=rows.map((x:any[])=>Number(x[1])),vol=rows.map((x:any[])=>Number(x[5])*Number(x[4]));const last=cl.at(-1),prev=cl.at(-2);if(!last||!prev||Math.abs((last-prev)/prev*100)>25)return null;const rel=vol.at(-1)/Math.max(1,avg(vol.slice(-21,-1))),ma5=avg(cl.slice(-5));if(last<=ma5*1.001||rel55)return null;const tr=[];for(let i=1;i0?reward/risk:0;if(rr86400000}\nasync function mark(s:string){await sqlite.execute({sql:\"INSERT INTO alerts(symbol,last_ts) VALUES(?,?) ON CONFLICT(symbol) DO UPDATE SET last_ts=excluded.last_ts\",args:[s,Date.now()]})}\nasync function alertBudget(){const t=Date.now();const h=await sqlite.execute({sql:\"SELECT COUNT(*) n FROM paper_signals WHERE created_ts>?\",args:[t-3600000]});const d=await sqlite.execute({sql:\"SELECT COUNT(*) n FROM paper_signals WHERE created_ts>?\",args:[t-86400000]});return {hour:Number((h.rows?.[0] as any)?.n||0),day:Number((d.rows?.[0] as any)?.n||0)}}\nasync function savePaper(a:any){await sqlite.execute({sql:\"INSERT INTO paper_signals(symbol,product,entry,stop,tp1,tp2,rr,relvol,spread,broad_score,source,created_ts,status) VALUES(?,?,?,?,?,?,?,?,?,?,?,?, 'OPEN')\",args:[a.symbol,a.product,a.entry,a.stop,a.tp1,a.tp2,a.rr,a.rel,a.spread,a.score??0,a.source??'coinlore',Date.now()]})}\n\nexport default async function(){await db();const ts=Date.now();try{const broad=await broadUniverse();const seen=new Set();const deepPool:any[]=[];for(const c of broad){const s=String(c.symbol||\"\").toUpperCase();if(!s||seen.has(s))continue;seen.add(s);deepPool.push(c);if(deepPool.length>=DEEP_LIMIT)break;}const found:any[]=[];const chunks=[];for(let i=0;i{try{return await scanCoinbase(c)}catch{return null}}));for(const x of r)if(x&&await cooldown(x.symbol))found.push(x)}found.sort((a,b)=>(b.rel*b.rr)-(a.rel*a.rr));const budget=await alertBudget();const slots=Math.max(0,Math.min(3,3-budget.hour,10-budget.day));const alerts=found.slice(0,slots);for(const a of alerts){const stopPct=((a.entry-a.stop)/a.entry)*100;const suggestedExposurePct=Math.min(25,0.5/Math.max(stopPct/100,0.002));await savePaper(a);await email({to:TO,subject:`[PAPER] ${a.symbol} LONG R:R ${a.rr.toFixed(1)}`,text:`Paper signal only — no automatic order.\\n${a.name} (${a.symbol})\\nEntry ${a.entry}\\nStop ${a.stop} (${stopPct.toFixed(2)}% risk distance)\\nTP1 ${a.tp1}\\nTP2 ${a.tp2}\\nR:R ${a.rr.toFixed(2)}\\nRelVol ${a.rel.toFixed(2)}x\\nSpread ${a.spread.toFixed(1)} bps\\nBroad score ${(a.score??0).toFixed(2)}\\nRank ${a.rank??'n/a'}\\n24h volume ${Math.round(a.volume24??0).toLocaleString()}\\nRisk model: max 0.5% portfolio risk; indicative exposure cap ${suggestedExposurePct.toFixed(1)}%\\nUTC ${new Date().toISOString()}`});await mark(a.symbol)}await sqlite.execute({sql:\"INSERT INTO runs VALUES(?,?,?,?,?)\",args:[ts,`ok_deep_${deepPool.length}`,broad.length,alerts.length,null]});console.log(JSON.stringify({ok:true,broadAnalyzed:broad.length,deepAnalyzed:deepPool.length,alerts:alerts.map(a=>a.symbol),topBroad:broad.slice(0,10).map(x=>x.symbol)}))}catch(e:any){await sqlite.execute({sql:\"INSERT INTO runs VALUES(?,?,?,?,?)\",args:[ts,\"error\",0,0,String(e?.message||e)]});throw e}}","label",[140],"f6eccf45-fc54-454a-b05a-5687d843d3c5","load_dex_platforms.ts","182f506a-9f2a-11f1-9716-1607ee4eb77e",24,["D",1787513856830],"script","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\"; export default async function(){const r=await fetch('https://pro-api.coinmarketcap.com/public-api/v1/dex/platform/list',{headers:{Accept:'application/json'}});const p:any=await r.json();const rows=Array.isArray(p?.data)?p.data:(Array.isArray(p)?p:[]);await sqlite.execute(`CREATE TABLE IF NOT EXISTS dex_platforms(id INTEGER PRIMARY KEY,name TEXT,acr TEXT,chain_id INTEGER,visible INTEGER);`);if(rows.length)await sqlite.batch(rows.map((x:any)=>({sql:'INSERT INTO dex_platforms(id,name,acr,chain_id,visible) VALUES(?,?,?,?,?) ON CONFLICT(id) DO UPDATE SET name=excluded.name,acr=excluded.acr,chain_id=excluded.chain_id,visible=excluded.visible',args:[Number(x.id),String(x.n||''),String(x.pltA||''),Number(x.chId||0),x.v?1:0]})));console.log(JSON.stringify({status:r.status,count:rows.length}));}",[151],"72883a57-cfb1-4caa-a0c3-6870f306c18c","evaluate_paper.ts","ccce4a62-9f2a-11f1-8819-1607ee4eb77e",34,["D",1787514159845],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nasync function j(u:string){const r=await fetch(u,{headers:{\"User-Agent\":\"crypto-radar-eval/1.0\"}});if(!r.ok)throw new Error(`HTTP ${r.status} ${u}`);return r.json()}\n\nexport default async function(){\n const open=await sqlite.execute(\"SELECT * FROM paper_signals WHERE status='OPEN' ORDER BY created_ts ASC LIMIT 100\");\n let closed=0,stillOpen=0;\n for(const s of (open.rows||[]) as any[]){\n try{\n const startSec=Math.floor(Number(s.created_ts)/1000);\n const candles:any[]=await j(`https://api.exchange.coinbase.com/products/${encodeURIComponent(String(s.product))}/candles?granularity=300&start=${new Date(Number(s.created_ts)).toISOString()}&end=${new Date().toISOString()}`);\n if(!Array.isArray(candles)||!candles.length){stillOpen++;continue}\n const rows=candles.filter((c:any[])=>Number(c[0])>=startSec).sort((a:any[],b:any[])=>Number(a[0])-Number(b[0]));\n let tp1Hit=false; let outcome:null|{reason:string,r:number,ts:number}=null;\n for(const c of rows){\n const ts=Number(c[0])*1000,low=Number(c[1]),high=Number(c[2]);\n const stopHit=low<=Number(s.stop), t1=high>=Number(s.tp1), t2=high>=Number(s.tp2);\n if(stopHit && (t1||t2)){outcome={reason:'STOP_AMBIGUOUS_SAME_CANDLE',r:-1,ts};break}\n if(stopHit){outcome={reason:'STOP',r:tp1Hit?0:-1,ts};break}\n if(t2){outcome={reason:'TP2',r:((Number(s.tp2)-Number(s.entry))/(Number(s.entry)-Number(s.stop))),ts};break}\n if(t1)tp1Hit=true;\n }\n const age=Date.now()-Number(s.created_ts);\n if(!outcome && age>48*3600000){\n const t:any=await j(`https://api.exchange.coinbase.com/products/${encodeURIComponent(String(s.product))}/ticker`);\n const px=Number(t.price);const r=(px-Number(s.entry))/(Number(s.entry)-Number(s.stop));\n outcome={reason:'TIME_48H',r:Number.isFinite(r)?r:0,ts:Date.now()};\n }\n if(outcome){\n await sqlite.execute({sql:\"UPDATE paper_signals SET status='CLOSED',closed_ts=?,result_r=?,exit_reason=? WHERE id=?\",args:[outcome.ts,outcome.r,outcome.reason,Number(s.id)]});closed++;\n }else stillOpen++;\n }catch{stillOpen++}\n }\n const stats=await sqlite.execute(\"SELECT COUNT(*) n, AVG(result_r) avg_r, SUM(CASE WHEN result_r>0 THEN 1 ELSE 0 END) wins, SUM(CASE WHEN result_r<=0 THEN 1 ELSE 0 END) losses, MIN(result_r) worst_r, MAX(result_r) best_r FROM paper_signals WHERE status='CLOSED'\");\n console.log(JSON.stringify({ok:true,checked:(open.rows||[]).length,closed,stillOpen,stats:stats.rows?.[0]||{}}));\n}",[159],"4ace09fa-8577-4c6a-912d-f16a08d54abf","discovery.ts","7fb35792-9f28-11f1-9d61-1607ee4eb77e",18,["D",1787513539026],5,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst PAGE_SIZE=5000;\nconst SHARDS=20; // capacity: 100,000 tracked listings\nconst STABLE=new Set([\"USDT\",\"USDC\",\"DAI\",\"FDUSD\",\"TUSD\",\"USDE\",\"PYUSD\",\"USDD\",\"FRAX\"]);\nconst safe=(x:any)=>{const v=Number(x);return Number.isFinite(v)?v:0};\nasync function j(u:string){const r=await fetch(u,{headers:{\"Accept\":\"application/json\",\"User-Agent\":\"crypto-radar-discovery/2.0\"}});if(!r.ok)throw new Error(`HTTP ${r.status} ${u}`);return r.json()}\nfunction usd(c:any){return c.quote?.USD||c.quotes?.USD||c.quote?.usd||c.quotes?.usd||{}} function score(c:any){const q=usd(c);const h=safe(q.percent_change_1h??q.percentChange1h),d=safe(q.percent_change_24h??q.percentChange24h),w=safe(q.percent_change_7d??q.percentChange7d),v=safe(q.volume_24h??q.volume24h??q.volume24),m=safe(q.market_cap??q.marketCap);if(m<=0||v<=0)return -1e9;const vm=v/m;const marketPairs=safe(c.num_market_pairs??c.numMarketPairs);const s=Math.min(10,Math.max(-10,h))*2+Math.min(30,Math.max(-30,d))*.6+Math.min(60,Math.max(-60,w))*.12+Math.min(8,Math.max(0,vm*20))+Math.min(4,Math.log10(Math.max(1,marketPairs)));return Number.isFinite(s)?s:-1e9}\n\nexport default async function(){\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS discovery100k(source_id TEXT PRIMARY KEY,symbol TEXT,name TEXT,rank INTEGER,score REAL,volume24 REAL,marketcap REAL,chg1h REAL,chg24h REAL,chg7d REAL,last_seen INTEGER,shard INTEGER);`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS discovery_meta(k TEXT PRIMARY KEY,v TEXT);`);\n const m=await sqlite.execute({sql:\"SELECT v FROM discovery_meta WHERE k='cmc_next_shard'\"});\n const shard=safe((m.rows?.[0] as any)?.v)%SHARDS;\n const start=shard*PAGE_SIZE+1;\n let payload:any; let source='coinmarketcap';\n try{\n payload=await j(`https://pro-api.coinmarketcap.com/public-api/v3/cryptocurrency/listings/latest?start=${start}&limit=${PAGE_SIZE}&convert=USD&sort=volume_24h&sort_dir=desc`);\n }catch(e){\n source='coinlore-fallback';\n const coins:any[]=[]; const fallbackStart=shard*1000;\n for(let p=0;p<10;p++){const r:any=await j(`https://api.coinlore.net/api/tickers/?start=${fallbackStart+p*100}&limit=100`);for(const c of (r.data||[]))coins.push({id:`cl-${c.id}`,symbol:c.symbol,name:c.name,cmc_rank:safe(c.rank),num_market_pairs:0,quote:{USD:{volume_24h:safe(c.volume24),market_cap:safe(c.market_cap_usd),percent_change_1h:safe(c.percent_change_1h),percent_change_24h:safe(c.percent_change_24h),percent_change_7d:safe(c.percent_change_7d)}}});}\n payload={data:coins,status:{total_count:null}};\n }\n const coins:any[]=Array.isArray(payload?.data)?payload.data:[];\n const ranked=coins.filter(c=>!STABLE.has(String(c.symbol||\"\").toUpperCase())).map(c=>({...c,_score:score(c)})).filter(c=>c._score>-1e8).sort((a,b)=>b._score-a._score).slice(0,400);\n const now=Date.now();\n for(const c of ranked){const q=c.quote?.USD||{};await sqlite.execute({sql:\"INSERT INTO discovery100k(source_id,symbol,name,rank,score,volume24,marketcap,chg1h,chg24h,chg7d,last_seen,shard) VALUES(?,?,?,?,?,?,?,?,?,?,?,?) ON CONFLICT(source_id) DO UPDATE SET symbol=excluded.symbol,name=excluded.name,rank=excluded.rank,score=excluded.score,volume24=excluded.volume24,marketcap=excluded.marketcap,chg1h=excluded.chg1h,chg24h=excluded.chg24h,chg7d=excluded.chg7d,last_seen=excluded.last_seen,shard=excluded.shard\",args:[String(c.id),String(c.symbol||\"\").toUpperCase(),String(c.name||\"\"),safe(c.cmc_rank),safe(c._score),safe(q.volume_24h),safe(q.market_cap),safe(q.percent_change_1h),safe(q.percent_change_24h),safe(q.percent_change_7d),now,shard]})}\n const next=(shard+1)%SHARDS;\n await sqlite.execute({sql:\"INSERT INTO discovery_meta(k,v) VALUES('cmc_next_shard',?) ON CONFLICT(k) DO UPDATE SET v=excluded.v\",args:[String(next)]});\n await sqlite.execute({sql:\"INSERT INTO discovery_meta(k,v) VALUES('cmc_last_total',?) ON CONFLICT(k) DO UPDATE SET v=excluded.v\",args:[String(payload?.status?.total_count??'unknown')]});\n console.log(JSON.stringify({ok:true,source,capacity:PAGE_SIZE*SHARDS,shard,start,received:coins.length,analyzed:coins.length,storedTop:ranked.length,totalAvailable:payload?.status?.total_count??null,nextShard:next}));\n}",[166],"0fd035ca-44ae-4d9e-8978-5171d741a230","dex_platform_probe.ts","06376b90-9f2a-11f1-bf5f-1607ee4eb77e",23,["D",1787513826671],"export default async function(){const u='https://pro-api.coinmarketcap.com/public-api/v1/dex/platform/list';const r=await fetch(u,{headers:{'Accept':'application/json'}});const t=await r.text();console.log(String(t).slice(0,3000));}",[174],"656c3043-9a43-4dd3-8193-bdefd074b443","dex_list_probe.ts","364b02f6-9f2a-11f1-909c-1607ee4eb77e",27,["D",1787513907320],"export default async function(){const u='https://pro-api.coinmarketcap.com/public-api/v4/dex/listings/quotes?start=1&limit=100';const r=await fetch(u,{headers:{Accept:'application/json'}});const t=await r.text();if(!r.ok)throw new Error(`HTTP ${r.status} ${t.slice(0,800)}`);const p:any=JSON.parse(t);const rows=Array.isArray(p?.data)?p.data:(Array.isArray(p)?p:[]);console.log(JSON.stringify({count:rows.length,sample:rows.slice(0,10).map((x:any)=>({id:x.id,name:x.name,slug:x.slug}))}));}",[181],"c5776edc-79f9-4431-84d1-598c6cbf9d04","dex_discovery.ts","f3376cca-9f29-11f1-b902-1607ee4eb77e",30,["D",1787514004614],6,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst NETWORKS=['ethereum','solana','bnb-smart-chain','base','arbitrum','polygon','avalanche','optimism'];\nconst LIMIT=1000,BATCH=200;\nconst safe=(x:any)=>{const v=Number(x);return Number.isFinite(v)?v:0};\nasync function j(u:string){const r=await fetch(u,{headers:{'Accept':'application/json','User-Agent':'crypto-radar-dex/1.0'}});const t=await r.text();if(!r.ok)throw new Error(`HTTP ${r.status} ${u} BODY ${t.slice(0,800)}`);try{return JSON.parse(t)}catch{throw new Error(`Bad JSON ${t.slice(0,500)}`)}}\nexport default async function(){\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS dex_candidates(token_key TEXT PRIMARY KEY,symbol TEXT,name TEXT,network TEXT,address TEXT,liquidity REAL,volume24 REAL,chg1h REAL,chg24h REAL,holders INTEGER,tx24 INTEGER,score REAL,last_seen INTEGER);`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS discovery_meta(k TEXT PRIMARY KEY,v TEXT);`);\n const mr=await sqlite.execute({sql:\"SELECT v FROM discovery_meta WHERE k='dex_network_idx'\"});const ni=safe((mr.rows?.[0] as any)?.v)%NETWORKS.length;const network=NETWORKS[ni];\n const cr=await sqlite.execute({sql:\"SELECT v FROM discovery_meta WHERE k=?\",args:[`dex_cursor_${network}`]});const cursor=String((cr.rows?.[0] as any)?.v||'');\n let url=`https://pro-api.coinmarketcap.com/public-api/v4/dex/spot-pairs/latest?network_slug=ethereum&dex_slug=uniswap-v3&limit=100`;\n if(cursor)url+=`&scroll_id=${encodeURIComponent(cursor)}`;\n const p:any=await j(url);const rows:any[]=Array.isArray(p?.data)?p.data:(Array.isArray(p)?p:[]);const tokens=new Map();\n for(const x of rows){const addr=String(x.base_asset_contract_address||'');const sym=String(x.base_asset_symbol||'').toUpperCase();if(!addr||!sym)continue;const q=Array.isArray(x.quote)?(x.quote[0]||{}):(x.quote?.USD||x.quote||{});const liq=safe(q.liquidity),vol=safe(q.volume_24h),h=safe(q.percent_change_price_1h),d=safe(q.percent_change_price_24h),holders=safe(x.holders),tx=safe(x.num_transactions_24h);const score=Math.log10(Math.max(1,liq))*2+Math.log10(Math.max(1,vol))*2+Math.min(10,Math.max(-10,h))*1.5+Math.min(30,Math.max(-30,d))*.4+Math.log10(Math.max(1,tx));const key=`${network}:${addr.toLowerCase()}`;const old=tokens.get(key);if(!old||score>old.score)tokens.set(key,{key,sym,name:String(x.base_asset_name||sym),addr,liq,vol,h,d,holders,tx,score})}\n const arr=[...tokens.values()];const now=Date.now();for(let i=0;i[{sql:\"INSERT INTO dex_candidates(token_key,symbol,name,network,address,liquidity,volume24,chg1h,chg24h,holders,tx24,score,last_seen) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?) ON CONFLICT(token_key) DO UPDATE SET symbol=excluded.symbol,name=excluded.name,liquidity=excluded.liquidity,volume24=excluded.volume24,chg1h=excluded.chg1h,chg24h=excluded.chg24h,holders=excluded.holders,tx24=excluded.tx24,score=excluded.score,last_seen=excluded.last_seen\",args:[t.key,t.sym,t.name,network,t.addr,t.liq,t.vol,t.h,t.d,t.holders,t.tx,t.score,now]},{sql:\"INSERT INTO catalog100k(source_id,symbol,name,slug,status,date_added,platform,last_seen,shard) VALUES(?,?,?,?,?,?,?,?,?) ON CONFLICT(source_id) DO UPDATE SET symbol=excluded.symbol,name=excluded.name,status=excluded.status,platform=excluded.platform,last_seen=excluded.last_seen\",args:[`dex:${t.key}`,t.sym,t.name,'','dex-active','',network,now,ni]}]))}\n const nextCursor=String((rows.at(-1) as any)?.scroll_id||p?.status?.scroll_id||p?.scroll_id||'');if(nextCursor&&nextCursor!==cursor){await sqlite.execute({sql:\"INSERT INTO discovery_meta(k,v) VALUES(?,?) ON CONFLICT(k) DO UPDATE SET v=excluded.v\",args:[`dex_cursor_${network}`,nextCursor]})}else{await sqlite.execute({sql:\"DELETE FROM discovery_meta WHERE k=?\",args:[`dex_cursor_${network}`]});await sqlite.execute({sql:\"INSERT INTO discovery_meta(k,v) VALUES('dex_network_idx',?) ON CONFLICT(k) DO UPDATE SET v=excluded.v\",args:[String((ni+1)%NETWORKS.length)]})}\n console.log(JSON.stringify({ok:true,network,pairs:rows.length,uniqueTokens:arr.length,cursorAdvanced:!!nextCursor,nextNetwork:!nextCursor?NETWORKS[(ni+1)%NETWORKS.length]:network}));\n}",[188],"8cf00270-a690-4c59-940d-8e13da89a0b9",["D",1787514227045],1,[28],"50ec7275-850a-4713-8e0b-47e5b44bb7d2","cmc_probe.ts","36bf9676-9f29-11f1-b126-1607ee4eb77e",16,["D",1787513491461],"export default async function(){const u='https://pro-api.coinmarketcap.com/public-api/v3/cryptocurrency/listings/latest?start=1&limit=1&convert=USD';const r=await fetch(u,{headers:{'Accept':'application/json','User-Agent':'crypto-radar-probe/1.0'}});const t=await r.text();let j:any={};try{j=JSON.parse(t)}catch{};const out={status:r.status,ok:r.ok,statusObj:j.status||null,dataLen:Array.isArray(j.data)?j.data.length:null,sample:Array.isArray(j.data)&&j.data[0]?{id:j.data[0].id,symbol:j.data[0].symbol,name:j.data[0].name,rank:j.data[0].cmc_rank}:null};console.log(JSON.stringify(out));return out;}",[200],"b435e71e-24a3-4ba2-a97f-c0447f5e2bee","catalog100k.ts","6e332370-9f29-11f1-b2e5-1607ee4eb77e",20,["D",1787513695139],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst PAGE=5000, SHARDS=20, BATCH=250;\nasync function j(u:string){const r=await fetch(u,{headers:{\"Accept\":\"application/json\",\"User-Agent\":\"crypto-radar-catalog/2.0\"}});if(!r.ok)throw new Error(`HTTP ${r.status} ${u}`);return r.json()}\nexport default async function(){\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS catalog100k(source_id TEXT PRIMARY KEY,symbol TEXT,name TEXT,slug TEXT,status TEXT,date_added TEXT,platform TEXT,last_seen INTEGER,shard INTEGER);`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS discovery_meta(k TEXT PRIMARY KEY,v TEXT);`);\n const m=await sqlite.execute({sql:\"SELECT v FROM discovery_meta WHERE k='catalog_next_shard'\"});\n const shard=Number((m.rows?.[0] as any)?.v||0)%SHARDS; const start=shard*PAGE+1;\n const statuses=['active','inactive','untracked']; const rows:any[]=[];\n for(const status of statuses){try{const p:any=await j(`https://pro-api.coinmarketcap.com/public-api/v1/cryptocurrency/map?listing_status=${status}&start=${start}&limit=${PAGE}`);for(const c of (Array.isArray(p?.data)?p.data:[]))rows.push({...c,_status:status})}catch{}}\n const seen=new Set(); const unique:any[]=[];\n for(const c of rows){const id=String(c.id??'');if(!id||seen.has(id))continue;seen.add(id);unique.push(c)}\n const now=Date.now(); let stored=0;\n for(let i=0;i{let platform='';if(c.platform){platform=String(c.platform.symbol||c.platform.name||c.platform.token_address||'')};return {sql:\"INSERT INTO catalog100k(source_id,symbol,name,slug,status,date_added,platform,last_seen,shard) VALUES(?,?,?,?,?,?,?,?,?) ON CONFLICT(source_id) DO UPDATE SET symbol=excluded.symbol,name=excluded.name,slug=excluded.slug,status=excluded.status,date_added=excluded.date_added,platform=excluded.platform,last_seen=excluded.last_seen,shard=excluded.shard\",args:[String(c.id),String(c.symbol||'').toUpperCase(),String(c.name||''),String(c.slug||''),String(c._status||''),String(c.first_historical_data||c.date_added||''),platform,now,shard]}});await sqlite.batch(stmts);stored+=part.length}\n const next=(shard+1)%SHARDS;await sqlite.execute({sql:\"INSERT INTO discovery_meta(k,v) VALUES('catalog_next_shard',?) ON CONFLICT(k) DO UPDATE SET v=excluded.v\",args:[String(next)]});console.log(JSON.stringify({ok:true,capacity:PAGE*SHARDS,shard,start,raw:rows.length,unique:unique.length,stored,nextShard:next}));\n}",[207],"pulls","branches",2,"forks","envVars",{"_221":61,"_223":61},"connections",{"_221":61,"_222":61},"count","unfilledCount","emptyCount",{"_43":206,"_32":207,"_30":208,"_142":-5,"_41":42,"_40":209,"_144":25,"_38":262,"_13":197,"_33":34,"_35":211,"_24":25,"_148":-5,"_235":263,"_27":264},{"_43":199,"_32":200,"_30":201,"_142":-5,"_41":42,"_40":202,"_144":25,"_38":259,"_13":197,"_33":155,"_35":204,"_24":25,"_148":-5,"_235":260,"_27":261},{"_43":195,"_32":28,"_30":31,"_142":-5,"_41":42,"_40":14,"_144":25,"_38":256,"_13":197,"_33":34,"_35":37,"_24":25,"_148":-5,"_235":257,"_27":258},{"_43":187,"_32":188,"_30":189,"_142":-5,"_41":42,"_40":190,"_144":25,"_38":253,"_13":192,"_33":34,"_35":193,"_24":25,"_148":-5,"_235":254,"_27":255},{"_43":180,"_32":181,"_30":182,"_142":-5,"_41":42,"_40":183,"_144":25,"_38":250,"_13":61,"_33":34,"_35":185,"_24":25,"_148":-5,"_235":251,"_27":252},{"_43":173,"_32":174,"_30":175,"_142":-5,"_41":42,"_40":176,"_144":25,"_38":247,"_13":61,"_33":155,"_35":178,"_24":25,"_148":-5,"_235":248,"_27":249},{"_43":165,"_32":166,"_30":167,"_142":-5,"_41":42,"_40":168,"_144":25,"_38":244,"_13":170,"_33":34,"_35":171,"_24":25,"_148":-5,"_235":245,"_27":246},{"_43":158,"_32":159,"_30":160,"_142":-5,"_41":42,"_40":161,"_144":25,"_38":241,"_13":61,"_33":34,"_35":163,"_24":25,"_148":-5,"_235":242,"_27":243},{"_43":150,"_32":151,"_30":152,"_142":-5,"_41":42,"_40":153,"_144":25,"_38":238,"_13":61,"_33":155,"_35":156,"_24":25,"_148":-5,"_235":239,"_27":240},{"_43":139,"_32":140,"_30":141,"_142":-5,"_41":42,"_40":143,"_144":25,"_38":234,"_13":146,"_33":34,"_35":147,"_24":25,"_148":-5,"_235":236,"_27":237},["D",1787514149661],"children",[],[140],["D",1787513856830],[],[151],["D",1787514159845],[],[159],["D",1787513539026],[],[166],["D",1787513826671],[],[174],["D",1787513907320],[],[181],["D",1787514004614],[],[188],["D",1787514227045],[],[28],["D",1787513491461],[],[200],["D",1787513695139],[],[207],["D",1787512804582],["D",1789523429989],{"_98":97,"_106":102},{"_98":97,"_99":100,"_101":102,"_18":55,"_103":104,"_105":25},{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"ctx",{"_80":-5,"_126":303,"_304":305,"_306":307,"_308":25,"_309":25,"_310":25,"_311":312,"_313":-5,"_314":-7,"_315":-7,"_316":61,"_317":25,"_318":25,"_319":-5,"_320":25,"_321":25,"_322":25,"_323":-5},"ENV",{"_274":275,"_276":277,"_278":88,"_279":280,"_281":282,"_283":284,"_285":286,"_287":288,"_289":290,"_291":292,"_293":294,"_295":296,"_297":298,"_299":300,"_301":302},"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",true,"preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v36