2e:["$","title",null,{"children":"LocalBitcoins & Paxful Activity Map | CoinDesk | Observable"}] 33:T474,md`**Notes** - For the volume-over-GDP option, we use 2019 GDP figures for 2020 ones. Annual GDPs are sourced from the [World Bank](https://data.worldbank.org/indicator/NY.GDP.MKTP.CD) and the [IMF](https://www.imf.org/external/pubs/ft/weo/2019/02/weodata/index.aspx) for the most of the countries. For more details, take a look at our [spreadsheet](https://docs.google.com/spreadsheets/d/1tJl1VitmdQhrZ6EY2MGoHJ4kN1hU4WKqUcwsLsQht7c/edit#gid=805291233). - In the choropleth view, a country is colored grey as a result of unavailable data. This is either because it isn't represented by any of the ${ [...currToAttrs.keys()].length } fiat currencies supported by Paxful and LocalBitcoins, or (if in volume-over-GDP mode) because its GDP figure in a certain year is unknown. - Please keep in mind that the data provided by [Paxful](https://developers.paxful.com/public-data/trades-history/) and [LocalBitcoins](https://localbitcoins.com/api-docs/#trades) are *not country-specfic; they're currency-specific*. A spike in volumes for trades using USD might — but not always — correlate to a volume spike for trades conducted in the U.S.`34:T168b,map = { const svg = d3 .create("svg") .attr("viewBox", [0, 0, width, height]) .attr("id", "map"); const zoom = d3 .zoom() .extent([[0, 0], [width, height]]) .translateExtent([[-50, -50], [width + 50, height + 50]]) .scaleExtent([1, 8]) .on("zoom", zoomed); const map = svg.append("g"); const paths = map.append("g"); const bubbles = map.append("g"); const tooltip = svg.append("g"); svg .append("g") .attr("id", "attribution") .call(attribution); function zoomed() { const { transform } = d3.event; mutable zoomK = transform.k; map.attr("transform", transform); map.attr("stroke-width", 0.15 / mutable zoomK); //bubbles.attr("stroke-width", 0.8 / mutable zoomK); } invalidation.then(() => svg.remove()); return Object.assign(svg.node(), { update(p, e, i, c) { const t1 = map .transition() .duration(delay) .ease(d3.easeLinear); const t2 = map .transition() .duration(delay / 4) .ease(d3.easeLinear); function pathClass(d) { if (e === "bubble" || !data[p][e][i].get(d.properties.name)) return "country unbound"; if (data[p][e][i].get(d.properties.name)[c[1]] === null) return "country unbound"; return "country bound"; } function pathFill(d) { if (e === "bubble" || !data[p][e][i].get(d.properties.name)) return defaultColor; if (data[p][e][i].get(d.properties.name)[c[1]] === null) return defaultColor; return colors[p][e][c[1]](data[p][e][i].get(d.properties.name)[c[1]]); } paths .selectAll("path") .data(countries) .join( enter => enter .append("path") .attr("d", path) .attr("stroke-width", 0.15) .call(enter => enter.attr("class", pathClass).attr("fill", pathFill) ), update => update.call(update => update .attr("class", pathClass) .transition(t1) .attr("fill", pathFill) ) ); paths .selectAll(".bound") .on("touchmove mousemove", function(d) { const coun = data[p][e][i].get(d.properties.name); svg.on("touchmove mousemove", function() { tooltip.attr("transform", `translate(${d3.mouse(this)})`); }); tooltip.call( callout, `${ c[1] !== "USDVolChange" ? primaryValFormat(coun[c[1]], c[0]) : percFormat(coun[c[1]]) } ${ymFormat(coun.data[0].date)} Country: ${coun.name}\n ${coun.data .map( d => `Currency: ${d.currency} - ${currToAttrs.get(d.currency).name} Total GDP of ${d.currency} user(s): \$${d3.format(",.0d")(d.gdp_mil)}M ${[...tooltipRenameBubble.keys()] .map(k => `${tooltipRenameBubble.get(k)}: ${numFormat(d[k])}`) .join("\n")}` ) .join("\n\n")}` ); }) .on("touchend mouseleave", function() { tooltip.call(callout, null); }); paths.selectAll(".unbound").on("touchmove mousemove", function() { tooltip.call(callout, null); }); function bubbleRadius(d) { return radii[p][c[0]](d[c[0]]); } function bubbleFill(d) { return colors[p][e][c[0]](d[c[0]]); } const bData = e === "bubble" && c[0] !== "usd_vol_change" ? data[p][e][i] .slice() .sort((a, b) => d3.descending(a[c[0]], b[c[0]])) // Sorting as a solution to overlapping bubbles : []; bubbles .selectAll("circle") .data(bData, d => d.currency) // Key can no longer be index since sorting is applied .join( enter => enter .append("circle") .attr("class", "bubble") .attr( "transform", d => `translate(${projection(currToAttrs.get(d.currency).coords)})` ) .call(enter => enter .transition(t2) .attr("r", bubbleRadius) .attr("fill", bubbleFill) ), update => update.call(update => update .transition(t1) .attr("r", bubbleRadius) .attr("fill", bubbleFill) ), exit => exit.call(exit => exit .transition(t2) .attr("r", 0) .remove() ) ); bubbles .selectAll("circle") .on("touchmove mousemove", function(d) { svg.on("touchmove mousemove", function() { tooltip.attr("transform", `translate(${d3.mouse(this)})`); }); const couns = currToAttrs.get(d.currency).countries; const group = currToAttrs.get(d.currency).group; const gText = group ? group : couns[1] ? `${couns[0]} & ${couns.length - 1} more` : couns[0]; tooltip.call( callout, `${primaryValFormat(d[c[0]], c[0])} ${ymFormat(d.date)} Currency: ${d.currency} - ${currToAttrs.get(d.currency).name} Total GDP of ${d.currency} user(s): \$${d3.format(",.0d")(d.gdp_mil)}M\n ${[...tooltipRenameBubble.keys()] .filter(k => k !== c[0]) .map(k => `${tooltipRenameBubble.get(k)}: ${numFormat(d[k])}`) .join("\n")}` ); }) .on("touchend mouseleave", function() { tooltip.call(callout, null); }); svg.call(zoom); } }); }35:Te70,legend = { const height = maxRadius * 2 + 25; const svg = d3.create("svg").attr("viewBox", [0, 0, width, height]); const legend = svg.append("g"); const bLegend = legend .append("g") .attr("transform", `translate(0,${maxRadius})`); const chLegend = legend .append("g") .attr("transform", `translate(${[(width - 320) / 2, 0]})`); invalidation.then(() => svg.remove()); return Object.assign(svg.node(), { update(p, e, c) { const t = bLegend .transition() .duration(delay / 4) .ease(d3.easeLinear); chLegend.selectAll("svg").remove(); if (e === "choro") { chLegend.append(() => l({ color: colors[p][e][c[1]], tickFormat: c[1] !== "USDVolChange" ? "s" : d => d < 0 ? d3.format("d")(d * 100) : d3.format(".0s")(d * 100), tickSize: 0 }) ); } function bubbleRadius(d) { return radii[p][c[0]](d); } function bubbleFill(d) { return colors[p][e][c[0]](d); } const rData = e === "bubble" && c[0] !== "usd_vol_change" ? radii[p][c[0]].ticks(4).filter(d => d) : []; const r = rData.map(bubbleRadius); let pos = 0; const bubblePos = r.reduce((a, d, i) => { if (i === 0) { pos += d; } else { pos += r[i - 1] + 20 + d; } a.push(pos); return a; }, []); const offset = (width - pos - r[r.length - 1]) / 2; bLegend .selectAll("g") .data(rData) .join( enter => { const g = enter .append("g") .attr( "transform", (_, i) => `translate(${offset + bubblePos[i]})` ); g.append("circle") .attr("class", "bubble") .attr("cy", (_, i) => maxRadius - r[i]) .transition(t) .attr("r", (_, i) => r[i]) .attr("fill", bubbleFill); g.append("text") .attr("text-anchor", "middle") .attr("font-family", "sans-serif") .attr("font-size", "0.7em") .attr("y", (_, i) => r[r.length - 1] + 20) .text(d => d3.format("~s")(d)); }, update => { update .transition(t) .attr( "transform", (_, i) => `translate(${offset + bubblePos[i]})` ); update .select("circle") .transition(t) .attr("cy", (_, i) => maxRadius - r[i]) .attr("r", (_, i) => r[i]) .attr("fill", bubbleFill); update .select("text") .text(d => d3.format("~s")(d)) .transition(t) .attr("y", (_, i) => r[r.length - 1] + 20); }, exit => { exit .select("circle") .transition(t) .attr("r", 0); exit .select("text") .transition(t) .attr("opacity", 0); exit.transition(t).remove(); } ); // For when change in monthly volume is enabled legend.selectAll("#unsupported").remove(); if (e === "bubble" && c[0] === "usd_vol_change") { legend .append("text") .attr("id", "unsupported") .attr("x", width / 2) .attr("y", 20) .attr("text-anchor", "middle") .text("Bubble view not supported"); } } }); }36:T736,function choroWrangle(raw, yms) { return yms.map((ym, i) => currencyCounNames.reduce((a, n) => { const key = rename.get(n) ? rename.get(n) : n; // 1 country can have two currencies, e.g. Cuba const currs = countrytoCurrencies .get(n) .reduce((a2, b) => { let v = raw.find(d => d.ym === ym && d.currency === b); v ? (v = [v.amount, v.usd_vol]) : (v = [0, 0]); let prev = raw.find(d => d.ym === yms[i - 1] && d.currency === b); prev ? (prev = prev.usd_vol) : (prev = 0); const usd_vol_change = (v[1] - prev) / prev; const gdp = currToAttrs.get(b)[`total_gdp_20${ym.substr(-2)}`]; a2.push({ date: d3.utcParse("%d-%b-%y")(`01-${ym}`), currency: b, volume: v[0], usd_vol: v[1], usd_vol_change: isNaN(usd_vol_change) ? null : usd_vol_change, gdp_mil: gdp ? gdp : null, usd_vol_over_gdp: gdp ? v[1] / gdp : null, ym }); return a2; }, []) .sort((a, b) => b.usd_vol - a.usd_vol); // can be undefined if everything is null const maxUSDVolOverGDP = d3.max(currs, d => d.usd_vol_over_gdp); const value = { data: currs, name: n, // Aggregate volumes across all currencies in a country totalVol: d3.sum(currs, d => d.volume), totalUSDVol: d3.sum(currs, d => d.usd_vol), // Choropleth show USD volume over GDP of currenecy with biggest USD volume over GDP maxUSDVolOverGDP: maxUSDVolOverGDP !== undefined ? maxUSDVolOverGDP : null, // Choropleth show USD volume change of currenecy with biggest USD volume USDVolChange: currs[0].usd_vol_change }; a.set(key, value); return a; }, new Map()) ); }37:[{"id":"254a99fef9cfdc739794cf276a25ffce226b9d17d64789497bbed4935f1fda7d621149894d3a06e546f0e5c53beda2580db0166433ff2fac65397af1aa3627ea","href":"https://static.observableusercontent.com/files/254a99fef9cfdc739794cf276a25ffce226b9d17d64789497bbed4935f1fda7d621149894d3a06e546f0e5c53beda2580db0166433ff2fac65397af1aa3627ea","name":"countries-50m.json","type":"application/json","lastModified":1592239728348.221,"size":756420},{"id":"659ec834a1717a9f8f8630005f0d9442709bd098c541fdfa3ba3831f31bf489f50c8820e8a86e1d87a32b1979bb3082165e2f2e1dd8e12b4bf11e0570d0d547f","href":"https://static.observableusercontent.com/files/659ec834a1717a9f8f8630005f0d9442709bd098c541fdfa3ba3831f31bf489f50c8820e8a86e1d87a32b1979bb3082165e2f2e1dd8e12b4bf11e0570d0d547f","name":"currencies_coords_gdp@2.tsv","type":"text/tab-separated-values","lastModified":1593641934243.544,"size":24156},{"id":"99543552c65b88703e065479d7fa3de121adbadcb97dcf6eccfda7b70e05ba97a61daec7eb51c879ce8de8d564be41521f2214bebb26753685278102db63179a","href":"https://static.observableusercontent.com/files/99543552c65b88703e065479d7fa3de121adbadcb97dcf6eccfda7b70e05ba97a61daec7eb51c879ce8de8d564be41521f2214bebb26753685278102db63179a","name":"Coindesk_Logo_RGB.jpg","type":"image/jpeg","lastModified":1596689551502.955,"size":323795},{"id":"719672c8d9c0c4414c678b64bf42f8ec224d36d855c35afb0429401b9d4bf82d99cbcac78c5372e64db47668b7409592a3aa4b8e1d5cf4d4d76948b484d87bd6","href":"https://static.observableusercontent.com/files/719672c8d9c0c4414c678b64bf42f8ec224d36d855c35afb0429401b9d4bf82d99cbcac78c5372e64db47668b7409592a3aa4b8e1d5cf4d4d76948b484d87bd6","name":"paxful@2.csv","type":"text/csv","lastModified":1596727651140.238,"size":111486},{"id":"5f85b537a92b11b32cd3041ecb58f83657e5f325f98869d23fec5371f6dffe1eebf249daf14841b593feabac0ee7912660ba57a5bb61565e012bcff6a420a23d","href":"https://static.observableusercontent.com/files/5f85b537a92b11b32cd3041ecb58f83657e5f325f98869d23fec5371f6dffe1eebf249daf14841b593feabac0ee7912660ba57a5bb61565e012bcff6a420a23d","name":"localbitcoins@3.csv","type":"text/csv","lastModified":1596727633188.59,"size":280921}] 31:{"id":"5051d12ba58bbf98","slug":"localbitcoins-paxful-activity-map","title":"LocalBitcoins & Paxful Activity Map","thumbnail":"2292a7a32032c435769807c8bb4abb17feac1be6b7002f2ab130c0968c7d484f","access_level":"public","create_time":"$D2020-06-15T14:21:09.815Z","update_time":"$D2020-08-10T05:37:40.924Z","view_time":null,"first_public_time":"$D2020-08-06T15:40:48.410Z","has_unpublished_edits":null,"fork":false,"stars":3,"starred":false,"owner":{"type":"team","id":"5b184344ac940e7c","login":"coindesk","name":"CoinDesk","avatar_url":"https://avatars-next.observableusercontent.com/3fb4c92a2c29c2ee4fe42b3d770c294752c37ea4ecdd13dfd4950d28d45bd2f1","tier":"starter_2024"},"version":3331,"publish_version":3331,"role":null,"authored":false,"authors":[{"type":"individual","id":"e4621783f33605e6","login":"coindesk","name":"CoinDesk","avatar_url":"https://avatars-next.observableusercontent.com/3fb4c92a2c29c2ee4fe42b3d770c294752c37ea4ecdd13dfd4950d28d45bd2f1","tier":null}],"members":[{"type":"individual","id":"e4621783f33605e6","login":"coindesk","name":"CoinDesk","avatar_url":"https://avatars-next.observableusercontent.com/3fb4c92a2c29c2ee4fe42b3d770c294752c37ea4ecdd13dfd4950d28d45bd2f1","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"LocalBitcoins & Paxful Activity Map","cells":[{"id":0,"value":"md`# LocalBitcoins & Paxful Activity Map\n\n*Showing transaction volumes by fiat currency in two of the most popular P2P exchanges.*`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3192,"value":"md`\n**To use this map**\n- Pick an exchange\n- Pick a unit\n- Pick a view (bubble or choropleth)\n- Hit \"Play\" or use the slider to see changes in volume over time\n- Scroll to zoom, drag to pan.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3296,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1627,"value":"viewof platform = radio({\n title: \"Exchange\",\n options: [\n { label: \"Both\", value: \"both\" },\n { label: \"Paxful\", value: \"paxful\" },\n { label: \"LocalBitcoins\", value: \"lbc\" }\n ],\n value: \"both\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1611,"value":"viewof column = radio({\n title: \"Unit\",\n options: [\n {\n label: \"Volume (USD Equiv.) per $1M in Total GDP\",\n value: \"usd_vol_over_gdp,maxUSDVolOverGDP\"\n },\n { label: \"Volume (BTC)\", value: \"volume,totalVol\" },\n { label: \"Volume (USD Equiv.)\", value: \"usd_vol,totalUSDVol\" }\n /* Uncomment this part to enable change in USD Volume\n {\n label: \"Change in USD Volume (%)\",\n value: \"usd_vol_change,USDVolChange\"\n }*/\n ],\n value: \"usd_vol_over_gdp,maxUSDVolOverGDP\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":452,"value":"html`\n

${viewof month}

${viewof encoder}

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1694,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2247,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1924,"value":"md`___\n## Appendix\n\nThanks to Jeremy Askenas for the [bubble-map design](https://observablehq.com/@jashkenas/italy-coronavirus-daily-cases-map-covid-19) and ready-to-use radio inputs, as well as Mike Bostock for the responsive [tooltip design](https://observablehq.com/@d3/line-chart-with-tooltip) and very handy scrubber.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3018,"value":"cellInspection","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":448,"value":"html`\n\n \n\n

CSS

\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3004,"value":"md`### Behavior Utilities`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":373,"value":"viewof month = Scrubber(months, {\n delay,\n loop: false,\n autoplay: false,\n format: ymFormat\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":697,"value":"viewof encoder = radio({\n options: [\n { label: 'Bubble', value: 'bubble' },\n { label: 'Choropleth', value: 'choro' }\n ],\n value: 'bubble'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2875,"value":"mutable zoomK = null","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1729,"value":"months = platform === \"lbc\" ? lbcMonths : paxfulMonths","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":381,"value":"delay = 500","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":396,"value":"iUpdate = {\n mutable index = months.indexOf(month);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":437,"value":"update = {\n map.update(platform, encoder, index, column.split(\",\"));\n legend.update(platform, encoder, column.split(\",\"));\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":394,"value":"mutable index = 0","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2758,"value":"ymFormat = t =>\n t.toLocaleString(undefined, {\n month: \"short\",\n year: \"numeric\",\n timeZone: \"UTC\"\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":506,"value":"numFormat = d3.format(\",.2f\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2678,"value":"percFormat = t => {\n if (t === Infinity) return \"Increased from 0\";\n return d3.format(new d3.FormatSpecifier({ type: \".1%\", sign: \"+\" }))(t);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2844,"value":"primaryValFormat = (t, c) =>\n c !== \"volume\" ? `\\$ ${numFormat(t)}` : `${numFormat(t)} BTC`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2780,"value":"tooltipRenameBubble = new Map([\n [\"volume\", \"BTC Volume\"],\n [\"usd_vol\", \"USD Volume\"],\n [\"usd_vol_over_gdp\", \"USD Volume per $1M GDP\"]\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1536,"value":"md`### Map Properties`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":324,"value":"antarcticaHeight = {\n const aBounds = d3\n .geoPath(d3.geoNaturalEarth1().fitSize([width, height], { type: \"Sphere\" }))\n .bounds(\n topojson\n .feature(world, world.objects.countries)\n .features.filter(d => d.properties.name === \"Antarctica\")[0]\n );\n\n return aBounds[1][1] - aBounds[0][1];\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3085,"value":"logoUrl = FileAttachment(\"Coindesk_Logo_RGB.jpg\").url()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3077,"value":"attribution = g => {\n g.attr(\"transform\", `translate(0,${height - 30})`);\n const h = 30;\n\n g.append(\"svg:image\")\n .attr(\"width\", 90)\n .attr(\"height\", h)\n .attr(\"xlink:href\", logoUrl);\n\n const rect = g\n .append(\"rect\")\n .attr(\"fill\", \"white\")\n .attr(\"stroke\", \"none\")\n .attr(\"x\", width - 158)\n .attr(\"width\", 158)\n .attr(\"height\", h);\n\n const text = g\n .append(\"text\")\n .attr(\"id\", \"text\")\n .attr(\"x\", width - 10)\n .attr(\"y\", 20)\n .attr(\"font-size\", 12)\n .attr(\"font-style\", \"italic\")\n .attr(\"text-anchor\", \"end\")\n .text(\"Data: LocalBitcoins, Paxful\");\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"projection = d3\n .geoNaturalEarth1()\n .fitSize([width, height + antarcticaHeight], { type: \"Sphere\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":18,"value":"path = d3.geoPath(projection)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"height = 495","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2860,"value":"defaultColor = \"#f4f4f4\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":20,"value":"countries = topojson.feature(world, world.objects.countries).features.filter(d => d.properties.name !== \"Antarctica\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"world = FileAttachment(\"countries-50m.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2036,"value":"colors = Object.entries(maxima).reduce((a, c) => {\n a[c[0]] = {\n bubble: Object.entries(c[1].bubble).reduce((a, c) => {\n a[c[0]] =\n c[0] !== \"usd_vol_change\"\n ? d3\n .scaleSqrt()\n .domain([0, c[1]])\n .range([\"hsla(57, 100%, 50%, 0.36)\", \"hsla(7, 100%, 50%, 0.57)\"])\n : d3.scaleThreshold(\n [-0.75, -0.5, -0.25, -0.1, 0, 0.5, 1, 5, 10, 100],\n [...d3.schemeRdYlBu[11]].reverse()\n );\n return a;\n }, {}),\n choro: Object.entries(c[1].choro).reduce((a, c) => {\n a[c[0]] =\n c[0] !== \"USDVolChange\"\n ? d3\n .scaleSequentialSqrt()\n .domain([0, c[1]])\n .interpolator(d3.interpolateYlOrRd)\n : d3.scaleThreshold(\n [-0.75, -0.5, -0.25, -0.1, 0, 0.5, 1, 5, 10, 100],\n [...d3.schemeRdYlBu[11]].reverse()\n );\n return a;\n }, {})\n };\n return a;\n}, {})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2006,"value":"maxima = Object.keys(data).reduce((a, k) => {\n a[k] = {\n bubble: data[k].bubble.flat().reduce(\n (a, c) => {\n Object.keys(a).forEach(k => {\n if (c[k] !== Infinity && c[k] > a[k]) a[k] = c[k];\n });\n return a;\n },\n { volume: 0, usd_vol: 0, usd_vol_over_gdp: 0, usd_vol_change: 0 }\n ),\n choro: data[k].choro\n .map(d => [...d.values()])\n .flat()\n .reduce(\n (a, c) => {\n Object.keys(a).forEach(k => {\n if (c[k] !== Infinity && c[k] > a[k]) a[k] = c[k];\n });\n return a;\n },\n { totalVol: 0, totalUSDVol: 0, maxUSDVolOverGDP: 0, USDVolChange: 0 }\n )\n };\n return a;\n}, {})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":431,"value":"maxRadius = width < 600 ? 30 : 50","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2023,"value":"radii = Object.entries(maxima).reduce((a, c) => {\n a[c[0]] = Object.entries(c[1].bubble).reduce((a, c) => {\n a[c[0]] = d3\n .scaleSqrt()\n .domain([0, c[1]])\n .range([0, maxRadius]);\n return a;\n }, {});\n return a;\n}, {})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1530,"value":"md`### Transformations`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":361,"value":"paxfulMonths = paxfulYms\n .map(d => d3.utcParse(\"%d-%b-%y\")(`01-${d}`))\n .sort((a, b) => +a - +b)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1667,"value":"lbcMonths = lbcYms\n .map(d => d3.utcParse(\"%d-%b-%y\")(`01-${d}`))\n .sort((a, b) => +a - +b)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":950,"value":"paxfulYms = Array.from(new Set(paxfulRaw.map(d => d.ym)))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1238,"value":"lbcYms = Array.from(new Set(lbcRaw.map(d => d.ym)))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1401,"value":"currToAttrs = new Map(\n currencies\n .filter(c => c.lat && c.long)\n .map(c => {\n const {\n name,\n countries,\n group,\n lat,\n long,\n total_gdp_2013,\n total_gdp_2014,\n total_gdp_2015,\n total_gdp_2016,\n total_gdp_2017,\n total_gdp_2018,\n total_gdp_2019,\n total_gdp_2020\n } = c;\n return [\n c.abb,\n {\n name,\n countries,\n group,\n lat,\n long,\n coords: [long, lat],\n total_gdp_2013,\n total_gdp_2014,\n total_gdp_2015,\n total_gdp_2016,\n total_gdp_2017,\n total_gdp_2018,\n total_gdp_2019,\n total_gdp_2020\n }\n ];\n })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":770,"value":"countrytoCurrencies = currencies\n .filter(c => c.countries[0])\n .map(c => c.countries.map(n => [n, c.abb]))\n .flat()\n .reduce((a, b) => {\n a.get(b[0]) ? a.get(b[0]).push(b[1]) : a.set(b[0], [b[1]]);\n return a;\n }, new Map())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":759,"value":"currencyCounNames = Array.from(new Set(currencies.map(c => c.countries).flat()))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":741,"value":"renameRev = new Map(\n Array.from(rename)\n .map(d => d[1].split(\",\").map(n => [n, d[0]]))\n .flat()\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":673,"value":"rename = new Map([\n [\"Antigua and Barbuda\", \"Antigua and Barb.\"],\n [\"Bosnia and Herzegovina\", \"Bosnia and Herz.\"],\n [\"Cape Verde\", \"Cabo Verde\"],\n [\"Cayman Islands\", \"Cayman Is.\"],\n [\"Central African Republic\", \"Central African Rep.\"],\n [\"Czech Republic\", \"Czechia\"],\n [\"Dominican Republic\", \"Dominican Rep.\"],\n [\"DR Congo\", \"Dem. Rep. Congo\"],\n [\"Equatorial Guinea\", \"Eq. Guinea\"],\n [\"Falkland Islands\", \"Falkland Is.\"],\n [\"French Polynesia\", \"Fr. Polynesia\"],\n [\"Macau\", \"Macao\"],\n [\"North Macedonia\", \"Macedonia\"],\n [\"Solomon Islands\", \"Solomon Is.\"],\n [\"South Sudan\", \"S. Sudan\"],\n [\"St. Lucia\", \"Saint Lucia\"],\n [\"St. Vincent and the Grenadines\", \"St. Vin. and Gren.\"],\n [\"Swaziland\", \"eSwatini\"],\n [\"São Tomé and Príncipe\", \"São Tomé and Principe\"],\n [\"United States\", \"United States of America\"],\n [\"Wallis and Futuna\", \"Wallis and Futuna Is.\"]\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1520,"value":"md`### Data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1598,"value":"data = ({\n paxful: {\n bubble: bubbleWrangle(paxfulRaw, paxfulYms),\n choro: choroWrangle(paxfulRaw, paxfulYms)\n },\n lbc: {\n bubble: bubbleWrangle(lbcRaw, lbcYms),\n choro: choroWrangle(lbcRaw, lbcYms)\n },\n both: {\n bubble: bubbleWrangle(bothRaw, paxfulYms),\n choro: choroWrangle(bothRaw, paxfulYms)\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1240,"value":"function bubbleWrangle(raw, yms) {\n return yms.map((ym, i) =>\n [...currToAttrs.keys()].sort().reduce((a, c) => {\n let v = raw.find(d => d.ym === ym && d.currency === c);\n v ? (v = [v.amount, v.usd_vol]) : (v = [0, 0]);\n let prev = raw.find(d => d.ym === yms[i - 1] && d.currency === c);\n prev ? (prev = prev.usd_vol) : (prev = 0);\n const usd_vol_change = (v[1] - prev) / prev;\n\n const gdp = currToAttrs.get(c)[`total_gdp_20${ym.substr(-2)}`];\n a.push({\n date: d3.utcParse(\"%d-%b-%y\")(`01-${ym}`),\n currency: c,\n volume: v[0],\n usd_vol: v[1],\n usd_vol_change: isNaN(usd_vol_change) ? null : usd_vol_change,\n gdp_mil: gdp ? gdp : null,\n usd_vol_over_gdp: gdp ? v[1] / gdp : null,\n ym\n });\n return a;\n }, [])\n );\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2536,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":411,"value":"paxfulRaw = d3\n .csvParse(await FileAttachment(\"paxful@2.csv\").text(), d => {\n d.amount = +d.amount;\n d.usd_vol = +d.usd_vol;\n return d;\n })\n .filter(d => d.ym !== \"May-15\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1187,"value":"lbcRaw = d3\n .csvParse(await FileAttachment(\"localbitcoins@3.csv\").text(), d => {\n d.amount = +d.amount;\n d.usd_vol = +d.usd_vol;\n return d;\n })\n .filter(d => d.ym !== \"Mar-13\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1584,"value":"bothRaw = d3\n .nest()\n .key(d => d.ym)\n .key(d => d.currency)\n .entries(lbcRaw.filter(d => paxfulYms.includes(d.ym)).concat(paxfulRaw))\n .map(d =>\n d.values.map(d2 =>\n d2.values.length === 1\n ? d2.values[0]\n : d2.values.reduce(\n (a, c) => {\n a.amount += c.amount;\n a.usd_vol += c.usd_vol;\n return a;\n },\n {\n ym: d2.values[0].ym,\n currency: d2.values[0].currency,\n amount: 0,\n usd_vol: 0\n }\n )\n )\n )\n .flat()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":224,"value":"currencies = d3.tsvParse(\n await FileAttachment(\"currencies_coords_gdp@2.tsv\").text(),\n d => ({\n name: d.name,\n abb: d.abb,\n altcoin: d.altcoin === \"TRUE\",\n countries: d.country !== \"\" ? d.country.split(\",\") : [],\n group: d.group ? d.group : null,\n lat: +d.lat,\n long: +d.long,\n // GDP unit: Current USD, billion => million\n total_gdp_2013: d.gdp_2013 ? +d.gdp_2013 * 1000 : null,\n total_gdp_2014: d.gdp_2014 ? +d.gdp_2014 * 1000 : null,\n total_gdp_2015: d.gdp_2015 ? +d.gdp_2015 * 1000 : null,\n total_gdp_2016: d.gdp_2016 ? +d.gdp_2016 * 1000 : null,\n total_gdp_2017: d.gdp_2017 ? +d.gdp_2017 * 1000 : null,\n total_gdp_2018: d.gdp_2018 ? +d.gdp_2018 * 1000 : null,\n total_gdp_2019: d.gdp_2019 ? +d.gdp_2019 * 1000 : null,\n total_gdp_2020: d.gdp_2019 ? +d.gdp_2019 * 1000 : null\n })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1512,"value":"md`### Imports`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"d3 = require(\"d3@5\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"topojson = require(\"topojson-client@3\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3015,"value":"import { cellInspection } from \"@duynguyen1678/helper-gifs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1002,"value":"import { legend as l } from \"@d3/color-legend\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":480,"value":"import { callout } from \"@d3/line-chart-with-tooltip\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":219,"value":"import {Scrubber} from \"@mbostock/scrubber\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":693,"value":"import { radio } from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":653,"value":"md`___\n## SCRATCH`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1285,"value":"// Check that no GDP data point is ill-formatted\ncurrencies.filter(c => Object.values(c).includes(NaN))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1221,"value":"// Check that no currency is left behind\nlbcRaw.filter(d => !currencies.map(c => c.abb).includes(d.currency)).length +\n paxfulRaw.filter(d => !currencies.map(c => c.abb).includes(d.currency))\n .length ===\n 0","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W37","stdlib":"1","titling":"auto"}} 32:"$31:body" 2d:E{"digest":"NEXT_REDIRECT;replace;/@coindesk/localbitcoins-paxful-activity-map;307;"}