2b:null 2c:["$","title",null,{"children":"Tether | Harikrishnan Shaji | Observable"}] 31:[] 2f:{"id":"984d8d3c09d73348","slug":null,"title":"Tether","thumbnail":"73f89caab999868dc3f8a2a8e82efceccbb8e137a4cbc11360bfa926061373b1","access_level":"public","create_time":"$D2022-12-02T17:44:40.435Z","update_time":"$D2022-12-04T06:05:47.619Z","view_time":null,"first_public_time":"$D2022-12-02T17:44:40.435Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"8d60521418c51954","login":"hihari777","name":"Harikrishnan Shaji","avatar_url":"https://avatars-next.observableusercontent.com/7120c2a24ee48971d7e52db11558fdc8da1d6932fe7deb39f02afd2667aa20e5","tier":"starter_2024"},"version":445,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"ec55b9c76dc225f5","login":"hihari777","name":"Harikrishnan Shaji","avatar_url":"https://avatars-next.observableusercontent.com/7120c2a24ee48971d7e52db11558fdc8da1d6932fe7deb39f02afd2667aa20e5","tier":null}],"members":[{"type":"individual","id":"ec55b9c76dc225f5","login":"hihari777","name":"Harikrishnan Shaji","avatar_url":"https://avatars-next.observableusercontent.com/7120c2a24ee48971d7e52db11558fdc8da1d6932fe7deb39f02afd2667aa20e5","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Tether","cells":[{"id":0,"value":"# Tether","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":408,"value":"baseApi = \"https://dune-test.herokuapp.com\";","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":133,"value":"## Mint","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":135,"value":"mintEvents = fetch(`${baseApi}/mint_events`).then(response => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":137,"value":"md`### Last updated: ${mintEvents.submitted_at}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":141,"value":"md`### Total mint events: ${mintEvents.count}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":160,"value":"md`### Total minted funds: $${(mintEvents.rows.reduce((a, b) => a + parseInt(b.amount), 0)) / (10**6)}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":143,"value":"Inputs.table(\n mintEvents.rows,\n {\n header: {\n tx_hash: \"transaction\",\n },\n format: {\n tx_hash: tx => html`Etherscan`,\n amount: amount => parseInt(amount) / 10**6,\n }\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":209,"value":"import {LineChart} from \"@d3/line-chart\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":203,"value":"LineChart(mintEvents.rows, {\n x: mint => Date.parse(mint.time),\n y: mint => parseInt(mint.amount) / 10**12,\n yLabel: \"($) in M\",\n width,\n height: 500,\n color: \"steelblue\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":147,"value":"## Burn","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":149,"value":"burnEvents = fetch(`${baseApi}/burn_events`).then(response => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":151,"value":"md`### Last updated: ${burnEvents.submitted_at}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":153,"value":"md`### Total burn events: ${burnEvents.count}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":162,"value":"md`### Total burned funds: $${(burnEvents.rows.reduce((a, b) => a + parseInt(b.amount), 0)) / (10**6)}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":155,"value":"Inputs.table(\n burnEvents.rows,\n {\n header: {\n tx_hash: \"transaction\",\n },\n format: {\n tx_hash: tx => html`Etherscan`,\n amount: amount => parseInt(amount) / 10**6,\n }\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":219,"value":"LineChart(burnEvents.rows, {\n x: burn => Date.parse(burn.time),\n y: burn => parseInt(burn.amount) / 10**12,\n yLabel: \"($) in M\",\n width,\n color: \"steelblue\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":18,"value":"## Blacklist","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":20,"value":"blacklistedEvents = fetch(`${baseApi}/blacklisted_events`).then(response => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":73,"value":"md`### Last updated: ${blacklistedEvents.submitted_at}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":57,"value":"md`### Total blacklist events: ${blacklistedEvents.count}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":31,"value":"Inputs.table(\n blacklistedEvents.rows,\n {\n header: {\n tx_hash: \"transaction\",\n },\n format: {\n tx_hash: tx => html`Etherscan`\n }\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":55,"value":"## Unblacklist","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":69,"value":"unblacklistedEvents = fetch(`${baseApi}/unblacklisted_events`).then(response => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":80,"value":"md`### Last updated: ${unblacklistedEvents.submitted_at}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":65,"value":"md`### Total unblacklist events: ${unblacklistedEvents.count}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":87,"value":"Inputs.table(\n unblacklistedEvents.rows,\n {\n header: {\n tx_hash: \"transaction\",\n },\n format: {\n tx_hash: tx => html`Etherscan`\n }\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":90,"value":"## Destroyed funds due to blacklisting","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":95,"value":"destroyedFundsEvents = fetch(`${baseApi}/destroyed_blacklisted_funds_events`).then(response => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":97,"value":"md`### Last updated: ${destroyedFundsEvents.submitted_at}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":99,"value":"md`### Total destroy funds events: ${destroyedFundsEvents.count}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":107,"value":"md`### Total destroyed funds: $${(destroyedFundsEvents.rows.reduce((a, b) => a + parseInt(b.destroyedAmount), 0)) / (10**6)}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":104,"value":"Inputs.table(\n destroyedFundsEvents.rows,\n {\n header: {\n tx_hash: \"transaction\",\n },\n format: {\n tx_hash: tx => html`Etherscan`,\n destroyedAmount: amount => parseInt(amount) / 10**6,\n }\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":179,"value":"Plot.plot({\n marks: [\n Plot.barX(destroyedFundsEvents.rows.map(row => {\n return {\n blacklistedUser: row[\"blacklistedUser\"],\n destroyedAmount: parseInt(row[\"destroyedAmount\"]) / 10 ** 6\n }\n }).sort((a, b) => b.destroyedAmount - a.destroyedAmount).slice(0, 15), {\n x: \"destroyedAmount\",\n y: \"blacklistedUser\",\n sort: {\n y: \"x\",\n reverse: true\n }\n }),\n Plot.ruleX([0])\n ],\n width\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":244,"value":"## Transfers involving a particular user","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":246,"value":"viewof addressForTransferFilter = Inputs.text({label: \"Address or ENS\", value: \"0x410a6626524b30c2e59bdb7ec81d4c154038f3e9\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":249,"value":"transfersInvolvingUser = fetch(`${baseApi}/transfers/${addressForTransferFilter}`).then(response => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":254,"value":"md`### Last updated: ${transfersInvolvingUser.submitted_at}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":258,"value":"md`### Total transfer events: ${transfersInvolvingUser.count}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":261,"value":"Inputs.table(\n transfersInvolvingUser.rows,\n {\n header: {\n tx_hash: \"transaction\",\n },\n format: {\n tx_hash: tx => html`Etherscan`,\n amount: amount => parseInt(amount) / 10**6,\n }\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":282,"value":"function getNodesFromTransfersInvolvingUser(transfersInvolvingUser, user) {\n let ids = new Set()\n for (let index = 0; index < transfersInvolvingUser.length; ++index) {\n ids.add(transfersInvolvingUser[index].from)\n ids.add(transfersInvolvingUser[index].to)\n }\n \n ids = Array.from(ids)\n \n let nodes = []\n for (let index = 0; index < ids.length; ++index) {\n let node = {\n id: ids[index],\n label: ids[index],\n }\n if(ids[index] === user){\n node[\"color\"] = \"red\"\n }\n nodes.push(node)\n }\n\n return nodes\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":315,"value":"function getLinksFromTransfersInvolvingUser(transfersInvolvingUser) {\n let links = []\n for (let index = 0; index < transfersInvolvingUser.length; ++index) {\n links.push({\n from: transfersInvolvingUser[index][\"from\"],\n to: transfersInvolvingUser[index][\"to\"],\n label: parseInt(transfersInvolvingUser[index][\"amount\"]) / 10**6\n })\n }\n\n return links\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":368,"value":"vis = require(\"vis\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":370,"value":"// Create a div where our vis will eventually live\ndiv = {\n const div = document.createElement(\"div\");\n div.setAttribute(\"style\",\"height:500px\");\n return div;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":372,"value":"new vis.Network(\n div, \n {\n edges: getLinksFromTransfersInvolvingUser(transfersInvolvingUser.rows), \n nodes: getNodesFromTransfersInvolvingUser(transfersInvolvingUser.rows, addressForTransferFilter)\n }, {\n edges: {\n arrows: {\n middle: { enabled: true, scaleFactor: 1, type: \"arrow\" }\n }\n },\n });","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":419,"value":"## Infinite approvals","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":421,"value":"infiniteApprovals = fetch(`${baseApi}/infinite_approvals`).then(response => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":424,"value":"md`### Last updated: ${infiniteApprovals.submitted_at}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":429,"value":"md`### Total spenders with atleast one infinite approval: ${infiniteApprovals.count}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":432,"value":"Inputs.table(\n infiniteApprovals.rows,\n {\n header: {\n count: \"Number of addresses\",\n },\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W31","stdlib":"1","titling":"auto"}} 30:"$2f:body"