31:T81e,function aggregateTransactions(data) { // Helper function to get 15-minute key from timestamp const get15MinKey = (timestamp) => { // timestamp is already a Date object const minutes = timestamp.getUTCMinutes(); const roundedMinutes = Math.floor(minutes / 15) * 15; return new Date(Date.UTC( timestamp.getFullYear(), timestamp.getMonth(), timestamp.getDate(), timestamp.getHours(), roundedMinutes, 0, 0 )); }; // Initialize aggregation object const agg = {}; // Process each transaction data.forEach(tx => { const key15Min = get15MinKey(tx.timestamp); const keyStr = key15Min.toISOString(); // Use string as key for the object const candidate = tx.title; const outcome = tx.outcome; const side = tx.side; // Create nested structure if it doesn't exist if (!agg[keyStr]) agg[keyStr] = {}; if (!agg[keyStr][candidate]) agg[keyStr][candidate] = {}; if (!agg[keyStr][candidate][outcome]) agg[keyStr][candidate][outcome] = {}; if (!agg[keyStr][candidate][outcome][side]) agg[keyStr][candidate][outcome][side] = 0; // Sum the traded value (size * price) const tradedValue = tx.size * tx.price; agg[keyStr][candidate][outcome][side] += tradedValue; }); // Get all unique candidates and time intervals const candidates = [...new Set(data.map(tx => tx.title))]; const intervals = Object.keys(agg).sort().map(h => new Date(h)); // Convert back to Date objects // Convert to time series arrays const result = { timestamps: intervals, candidates: {} }; candidates.forEach(candidate => { result.candidates[candidate] = { Yes: { BUY: intervals.map(t => agg[t.toISOString()][candidate]?.Yes?.BUY || 0), SELL: intervals.map(t => agg[t.toISOString()][candidate]?.Yes?.SELL || 0) }, No: { BUY: intervals.map(t => agg[t.toISOString()][candidate]?.No?.BUY || 0), SELL: intervals.map(t => agg[t.toISOString()][candidate]?.No?.SELL || 0) } }; }); return result; }32:Tb1a,function areaPlot(serie, {reverse, yMax, c, h, minimal, title}={}) { const yDomain = yMax ? {domain:[0, yMax]} : {} const maincolor = c ? c : color const gradientId = `gradient-${Math.random().toString(36).substr(2, 9)}`; const gradient = reverse ? htl.svg` ` : htl.svg` ` const marginShort = minimal ? 5 : 50 const marginLong = minimal ? 15 : 50 return Plot.plot({ height: h ? h : 350, marginTop: reverse ? marginShort : marginLong, marginBottom: reverse ? marginLong : marginShort, x: { domain: timeDomain, tickSize: 0, ticks: reverse ? 0 : 5, label: null, type: "time", axis: minimal ? null : "bottom", }, y:{ tickSize: 0, ticks: 5, axis: null, reverse: reverse, ...yDomain, }, marks: [ () => gradient, Plot.gridY({ ticks: 5, strokeDasharray: "1,3", strokeOpacity: .5 }), Plot.axisY({ ticks: 5, anchor: "right", textAnchor: "end", tickSize: 0, dx: -10, dy: -6, lineAnchor: "bottom", tickFormat: (d, i, _) => (i === _.length - 1 ? `\$${d}` : d), label: null }), Plot.areaY(serie, { x: "time", y1: 0, y2: "value", fill: `url(#${gradientId})`, fillOpacity: .5, curve: "basis" }), Plot.line(serie, { x: "time", y: "value", sort: "time", stroke: maincolor, strokeWidth: 2, strokeOpacity: .8, curve: "basis" }), Plot.dot(serie, Plot.pointerX({ x: "time", y: "value", fill: maincolor, fillOpacity: .3, r: 7, })), Plot.dot(serie, Plot.pointerX({ x: "time", y: "value", fill: maincolor, fillOpacity: 1, r: 3, })), Plot.text(serie, Plot.pointerX({ px: "time", frameAnchor: reverse ? "bottom-left" : "top-left", dy: reverse ? -20 : 20, text: d => `\$${d3.format(",.2f")(d.value)} el ${dateFormatter.format(d.time)}`, lineAnchor: "top", fontSize: 10, fontWeight: 400, })), title ? Plot.text([title], { frameAnchor: reverse ? "bottom" : "top", fontWeight: "bold", dy: reverse ? -10 : 10, }) : null ] }) }33:T4f7,viewof bets_plot = Plot.plot({ marginTop: 40, marginBottom: 40, x: { domain: timeDomain, tickSize: 0, ticks: 5, label: null, type: "time" }, y:{ tickSize: 0, ticks: 5, axis: null, }, marks: [ Plot.gridY({ ticks: 5, strokeDasharray: "1,3", strokeOpacity: .5 }), Plot.axisY({ ticks: 5, anchor: "right", textAnchor: "end", tickSize: 0, dx: -10, dy: -6, lineAnchor: "bottom", tickFormat: (d, i, _) => (i === _.length - 1 ? `\$${d}` : d), label: null }), Plot.dot(bets, { x: "timestamp", y: "price", r: "size", fill: color, fillOpacity: .2, stroke: color, strokeWidth: .5 }), Plot.dot(bets, Plot.pointer({ x: "timestamp", y: "price", r: "size", fill: color, fillOpacity: .5, stroke: color, strokeWidth: .8 })), Plot.text(bets, Plot.pointer({ px: "timestamp", py: "price", frameAnchor: "top-left", text: d => `\$${d3.format(",.2f")(d.size)} a \$${d3.format(",.2f")(d.price)} el ${dateFormatter.format(d.timestamp)}`, lineAnchor: "top", fontSize: 10, fontWeight: 400, dy: -35, })), ] })34:[] 2f:{"title":"Polymarket electoral","cells":[{"id":0,"value":"# Polymarket electoral","pinned":false,"hidden":false,"mode":"md"},{"id":22,"value":"viewof candidate = Inputs.radio(candidatos, {\n value: candidatos[0]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":31,"value":"viewof outcome = Inputs.radio(outcomes, {\n value: \"Yes\",\n label:\"outcome\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":34,"value":"viewof side = Inputs.radio(sides, {\n value: \"BUY\",\n label:\"side\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":133,"value":"Volumen apostado por hora","pinned":false,"hidden":false,"mode":"md"},{"id":38,"value":"viewof volume_plot = areaPlot(serie)","pinned":false,"hidden":false,"mode":"ojs"},{"id":131,"value":"Apuestas individuales","pinned":false,"hidden":false,"mode":"md"},{"id":140,"value":"htl.html`\n

\n${user}\n

${viewof bets_plot}

\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":156,"value":"Comparación entre apuestas a favor y en contra","pinned":false,"hidden":false,"mode":"md"},{"id":155,"value":"areaPlot(dual.Yes, {h: 200, minimal: true, title: \"Yes\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":154,"value":"areaPlot(dual.No, {reverse: true, yMax:dualMax, c: \"green\", h: 200, minimal: true, title: \"No\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":97,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":4,"value":"gist = {\n const raw = await d3.csv(\"https://gist.githubusercontent.com/pr0nstar/db63e71ddbde0f74e61b6f3149d96b09/raw/polymarket.paz.quiroga.csv\", row => ({\n ...row,\n timestamp: new Date(row.timestamp),\n time: row.timestamp,\n size: Number(row.size),\n price: Number(row.price),\n proxyWallet: String(row.proxyWallet)\n }));\n return raw\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":15,"value":"data = aggregateTransactions(gist)","pinned":false,"hidden":false,"mode":"ojs"},{"id":129,"value":"bets = gist.filter(d => d.title == candidate & d.outcome == outcome & d.side == side).map(d => ({...d, timestamp: new Date(d.timestamp.getTime() - d.timestamp.getTimezoneOffset() * 60000)}))","pinned":false,"hidden":false,"mode":"ojs"},{"id":13,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":36,"value":"serie = zipArrays(data.candidates[candidate][outcome][side], data.timestamps, \"value\", \"time\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":152,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":151,"value":"dual = ({\n Yes: zipArrays(data.candidates[candidate].Yes[side], data.timestamps, \"value\", \"time\"),\n No: zipArrays(data.candidates[candidate].No[side], data.timestamps, \"value\", \"time\")\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":150,"value":"dualMax = Math.max(...Object.values(dual).flat().map(d => d.value))","pinned":false,"hidden":false,"mode":"ojs"},{"id":39,"value":"zipArrays = (arr1, arr2, name1, name2) => \n arr1.map((val, i) => ({ [name1]: val, [name2]: arr2[i] }));\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":145,"value":"timeDomain = (() => {\n const times = data.timestamps.map(d => d.getTime());\n const minTime = Math.min(...times);\n const maxTime = Math.max(...times);\n const range = maxTime - minTime;\n const padding = range * 0.12; // 5% padding on the right\n \n return [\n new Date(minTime),\n new Date(maxTime + padding)\n ];\n})();","pinned":false,"hidden":false,"mode":"ojs"},{"id":44,"value":"color = \"#f0844a\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":60,"value":"dateFormatter = new Intl.DateTimeFormat('es', { year: 'numeric', month: 'long', day: 'numeric', hour:\"numeric\", minute: \"numeric\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":104,"value":"outcomes = [\"Yes\", \"No\"]","pinned":false,"hidden":false,"mode":"ojs"},{"id":106,"value":"sides = [\"BUY\", \"SELL\"]","pinned":false,"hidden":false,"mode":"ojs"},{"id":123,"value":"candidatos = [\"Will Rodrigo Paz win the 2025 Bolivia presidential election?\", \"Will Jorge “Tuto” Quiroga win the 2025 Bolivia presidential election?\"]","pinned":false,"hidden":false,"mode":"ojs"},{"id":138,"value":"","pinned":false,"hidden":false,"mode":"html"},{"id":135,"value":"user = bets_plot ? htl.html`\n${userIcon}\n` : htl.html``","pinned":false,"hidden":false,"mode":"ojs"},{"id":134,"value":"userIcon = svg``","pinned":false,"hidden":false,"mode":"ojs"},{"id":130,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W34","stdlib":"1","titling":"auto"}