29:null 2a:["$","title",null,{"children":"Cada oferta de USDT por Bolivianos | Mauricio Foronda | Observable"}] 2f:[] 2d:{"id":"40085abe2edffee7","slug":"cada-oferta-de-usdt-por-bolivianos","title":"Cada oferta de USDT por Bolivianos","thumbnail":"034d0866e8e2e37db96eb7915cad4952e3a5f2051245046523de60d7d454e458","access_level":"public","create_time":"$D2025-05-19T17:03:22.647Z","update_time":"$D2025-06-20T15:06:14.394Z","view_time":null,"first_public_time":"$D2025-05-29T13:24:59.565Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"475974948549302f","login":"mauforonda","name":"Mauricio Foronda","avatar_url":"https://avatars-next.observableusercontent.com/4cc3af3b792916571df54649e193dbdbf80a875b4e37b1def6ecb0480c561075","tier":"starter_2024"},"version":551,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"018969b4abf63b07","login":"mauforonda","name":"Mau Foronda","avatar_url":"https://avatars-next.observableusercontent.com/513f52feadea4c57a52e2ab0f2fbdad66bf45a132acf7f9fbb19eb61e86e345f","tier":null}],"members":[{"type":"individual","id":"018969b4abf63b07","login":"mauforonda","name":"Mau Foronda","avatar_url":"https://avatars-next.observableusercontent.com/513f52feadea4c57a52e2ab0f2fbdad66bf45a132acf7f9fbb19eb61e86e345f","tier":null,"role":"editor"},{"type":"team","id":"475974948549302f","login":"mauforonda","name":"Mauricio Foronda","avatar_url":"https://avatars-next.observableusercontent.com/4cc3af3b792916571df54649e193dbdbf80a875b4e37b1def6ecb0480c561075","tier":"starter_2024","role":"viewer"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":3,"collection":null,"type":"notebook","body":{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":448,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":447,"value":"htl.html`

${viewof search}

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":446,"value":"htl.html`\n

\n${userLabel}\n

${userPlot}

${viewof mainPlot}

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":445,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":444,"value":"user = mainPlot ? mainPlot.user : search.length > 0 ? search[0][0] : null","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":433,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":123,"value":"vwapIndex = Object.fromEntries(vwap.map(({timestamp, vwap}) => [timestamp.getTime(), vwap]))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"names = d3.json(`${github}/names.json`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":13,"value":"hyparquet = import(\"https://cdn.jsdelivr.net/npm/hyparquet/+esm\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":410,"value":"compressors = import(\"https://cdn.jsdelivr.net/npm/hyparquet-compressors/+esm\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"arrayBuffer = fetch(`${github}/ads.parquet`).then((d) => d.arrayBuffer())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"data = new Promise((onComplete) =>\n hyparquet.parquetRead({ file: arrayBuffer, compressors: compressors.compressors, onComplete })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":439,"value":"priceDomain = [Math.min(...ads.map(d => d.price)), Math.max(...ads.map(d => d.price))]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":544,"value":"height = 600","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":450,"value":"userIcon = svg``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":437,"value":"userLabel = mainPlot ? htl.html`\n${userIcon} ${names[user]}\n` : htl.html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":398,"value":"github = \"https://mauforonda.github.io/cajeros\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W2f","stdlib":"1","titling":"auto"}} 2e:"$2d:body"