31:[] 2f:{"title":"Cada oferta de USDT por Bolivianos","cells":[{"id":0,"value":"# Cada oferta de USDT por Bolivianos\n## y cómo se compara con el precio de mercado","pinned":false,"hidden":false,"mode":"md"},{"id":448,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":447,"value":"htl.html`

${viewof search}

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":446,"value":"htl.html`\n

\n${userLabel}\n

${userPlot}

${viewof mainPlot}

\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":445,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":444,"value":"user = mainPlot ? mainPlot.user : search.length > 0 ? search[0][0] : null","pinned":false,"hidden":false,"mode":"ojs"},{"id":433,"value":"","pinned":false,"hidden":false,"mode":"html"},{"id":74,"value":"vwap = {\n const d = await d3.csv(`${github}/vwap.csv`, d3.autoType)\n return d.map((d) => ({timestamp: new Date(d[\"\"] + \"Z\"), vwap:Number(d[\"0\"])}))\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":123,"value":"vwapIndex = Object.fromEntries(vwap.map(({timestamp, vwap}) => [timestamp.getTime(), vwap]))","pinned":false,"hidden":false,"mode":"ojs"},{"id":10,"value":"names = d3.json(`${github}/names.json`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":13,"value":"hyparquet = import(\"https://cdn.jsdelivr.net/npm/hyparquet/+esm\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":410,"value":"compressors = import(\"https://cdn.jsdelivr.net/npm/hyparquet-compressors/+esm\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":16,"value":"arrayBuffer = fetch(`${github}/ads.parquet`).then((d) => d.arrayBuffer())","pinned":false,"hidden":false,"mode":"ojs"},{"id":14,"value":"data = new Promise((onComplete) =>\n hyparquet.parquetRead({ file: arrayBuffer, compressors: compressors.compressors, onComplete })\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":441,"value":"ads = data.map(arr => {\n const vwap = vwapIndex[arr[1].getTime()];\n const price = Number(arr[2]);\n const amount = Number(arr[3]);\n return ({\n user: arr[0],\n timestamp: arr[1],\n price: price,\n amount: amount,\n opacity: Math.log1p(amount) ** 2,\n color: price > vwap ? \"over\" : \"under\"\n })\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":440,"value":"adsByUser = data.map(arr => {\n return ({\n user: arr[0],\n timestamp: arr[1],\n price: Number(arr[2]),\n amount: Number(arr[3]), \n })\n}).reduce((acc, { user, timestamp, price, amount }) => {\n if (!acc[user]) acc[user] = [];\n const vwap = vwapIndex[timestamp.getTime()]\n acc[user].push({ timestamp, price, amount, vwap: vwap, color: price > vwap ? \"over\" : \"under\"});\n return acc;\n}, {});","pinned":false,"hidden":false,"mode":"ojs"},{"id":439,"value":"priceDomain = [Math.min(...ads.map(d => d.price)), Math.max(...ads.map(d => d.price))]","pinned":false,"hidden":false,"mode":"ojs"},{"id":438,"value":"viewof mainPlot = Plot.plot({\n width: width,\n height: height,\n x: {\n tickSize: 0,\n ticks: 10,\n label: null,\n axis: \"top\"\n },\n y: {\n axis: \"right\",\n tickSize: 0,\n ticks: 6,\n label: null,\n domain: priceDomain,\n tickFormat: (d, i, _) => (i === _.length - 1 ? `${d} Bs.` : d),\n },\n style: {\n color: colors.pasive.frame,\n },\n marks: [\n Plot.gridX({\n ticks: 10,\n strokeDasharray: \"1,2\",\n strokeOpacity: .5\n }),\n Plot.gridY({\n ticks: 6,\n strokeDasharray: \"1,2\",\n strokeOpacity: .5\n }),\n Plot.raster(ads, {\n x: \"timestamp\",\n y: \"price\",\n fill: d => colors.pasive[d.color],\n fillOpacity: \"opacity\",\n pixelSize: 1,\n }),\n Plot.line(vwap, {\n x: \"timestamp\",\n y: \"vwap\",\n stroke: colors.pasive.black,\n strokeWidth: .5\n }),\n Plot.dot(ads, Plot.pointer({\n x: \"timestamp\",\n y: \"price\",\n fill: d => colors.active[d.color],\n })),\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":544,"value":"height = 600","pinned":false,"hidden":false,"mode":"ojs"},{"id":450,"value":"userIcon = svg``","pinned":false,"hidden":false,"mode":"ojs"},{"id":437,"value":"userLabel = mainPlot ? htl.html`\n${userIcon} ${names[user]}\n` : htl.html``","pinned":false,"hidden":false,"mode":"ojs"},{"id":436,"value":"userPlot = {\n let userMarks = [];\n if (user) {\n const userAds = adsByUser[user];\n userMarks = [\n Plot.ruleX(userAds, {\n x: \"timestamp\",\n y1: \"vwap\",\n y2: \"price\",\n sort: \"timestamp\",\n stroke: d => colors.active[d.color],\n strokeWidth: .5,\n strokeOpacity: .8\n }),\n Plot.dot(userAds, {\n x: \"timestamp\",\n y: \"price\",\n fill: d => colors.active[d.color],\n fillOpacity: .5,\n r: 1,\n })\n ]\n }\n return Plot.plot({\n width: width,\n height: height,\n marginTop: 30,\n marginBottom: 20,\n marginLeft: 20,\n marginRight: 40,\n x: {\n axis: null,\n },\n y: {\n axis: null,\n domain: priceDomain,\n },\n style: {\n color: colors.pasive.frame,\n },\n marks: [\n Plot.line(vwap, {\n x: \"timestamp\",\n y: \"vwap\",\n stroke: colors.pasive.black,\n strokeWidth: .5\n }),\n ...userMarks\n ]\n })\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":435,"value":"viewof search = Inputs.search(Object.entries(names), {\n required: false,\n format: d => `${d} ${d == 1 ? \"usuario\" : \"usuarios\"}`,\n placeholder: \"Busca usuarios\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":434,"value":"colors = ({\n pasive: {\n over: \"#b75e6e\",\n under: \"#9faaac\",\n frame: \"#a1a1a1\",\n black: \"#000000\",\n button: \"#f0f0f0\",\n buttonHover: \"#daebf7\"\n },\n active: {\n over: \"#e86267\",\n under: \"#50bab5\"\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":398,"value":"github = \"https://mauforonda.github.io/cajeros\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}