urbit__cyberpunks.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%% md\n"
    }
   },
   "source": [
    "## Cyberpunks. Urbit Owners"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "from IPython.core.display import display, HTML\n",
    "\n",
    "from config import ERC721_ANALYSIS_DATASET_NAME, AZIMUTH_POINTS_TABLE_NAME, SNAPSHOT_TS\n",
    "from src.utils_bigquery import get_df, create_table_from_df\n",
    "from src.extractor_urbit import extract_point_data\n",
    "\n",
    "SELECT_TRANSFERRED_TOKENS = True\n",
    "DROP_TABLES = True\n",
    "CREATE_TABLES = True\n",
    "\n",
    "AZIMUTH_CONTRACT_ADDRESS = '0x223c067F8CF28ae173EE5CafEa60cA44C335fecB'.lower()\n",
    "LINEAR_STAR_RELEASE_CONTRACT_ADDRESS= '0x86cd9cd0992F04231751E3761De45cEceA5d1801'.lower()\n",
    "SPAWNED_EVENT_TOPIC = '0xb2d3a6e7a339f5c8ff96265e2f03a010a8541070f3744a247090964415081546'\n",
    "ZERO_ADDRESS = '0x0000000000000000000000000000000000000000'\n",
    "AZIMUTH_CONTRACT_CREATE_TS = '2018-11-27 00:00:00'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%% md\n"
    }
   },
   "source": [
    "### Get List of Transferred Tokens"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of Azimuth Tokens: 77,050\n"
     ]
    }
   ],
   "source": [
    "if SELECT_TRANSFERRED_TOKENS:\n",
    "    query_1 = f'''\n",
    "    SELECT cast(topics[ORDINAL(3)] AS INT64) as point\n",
    "    FROM `bigquery-public-data.crypto_ethereum.logs`\n",
    "    WHERE block_timestamp > '{AZIMUTH_CONTRACT_CREATE_TS}'\n",
    "      AND block_timestamp < '{SNAPSHOT_TS}'\n",
    "      AND address = '{AZIMUTH_CONTRACT_ADDRESS}'\n",
    "      AND topics[ORDINAL(1)] = '{SPAWNED_EVENT_TOPIC}'\n",
    "    '''\n",
    "\n",
    "    azimuth_tokens_list = list(get_df(query=query_1).point)\n",
    "    print(f'Number of Azimuth Tokens: {len(azimuth_tokens_list):>,}')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%% md\n"
    }
   },
   "source": [
    "### Get Point Owners and Types"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processing 77050 points split into 602 chunks on 10 processes:\n",
      "Points 55753:43346 extracted\n",
      "Points 106693888:103220480 extracted\n",
      "Points 4680:25674 extracted\n",
      "Points 43802:28188 extracted\n",
      "Points 44631:64621 extracted\n",
      "Points 61960:35639 extracted\n",
      "Points 60492:36566 extracted\n",
      "Points 39584:16050 extracted\n",
      "Points 35900:52286 extracted\n",
      "Points 3103392162:1383605414 extracted\n",
      "Points 1008932774:85984512 extracted\n",
      "Points 43602:47442 extracted\n",
      "Points 21322:31261696 extracted\n",
      "Points 31279:3796 extracted\n",
      "Points 64877:2985855442 extracted\n",
      "Points 16305:47266 extracted\n",
      "Points 28444:42534 extracted\n",
      "Points 35895:30217 extracted\n",
      "Points 53822:24894 extracted\n",
      "Points 328742100:42231 extracted\n",
      "Points 87098624:85656832 extracted\n",
      "Points 14591:63826 extracted\n",
      "Points 31327232:45152 extracted\n",
      "Points 56245:57521 extracted\n",
      "Points 3679056310:1592992 extracted\n",
      "Points 3798:28426 extractedPoints 56349:6693 extracted\n",
      "\n",
      "Points 42487:58359 extracted\n",
      "Points 30473:39945 extracted\n",
      "Points 25662:7714 extracted\n",
      "Points 45408:8032 extracted\n",
      "Points 64082:51770 extracted\n",
      "Points 86050048:24786 extracted\n",
      "Points 6949:47754 extracted\n",
      "Points 28682:40202 extracted\n",
      "Points 7970:43068 extracted\n",
      "Points 1658528:32674 extracted\n",
      "Points 40713:31084 extracted\n",
      "Points 58615:54461 extracted\n",
      "Points 18342:19891 extracted\n",
      "Points 52026:30552 extracted\n",
      "Points 23250:1900151712 extracted\n",
      "Points 8288:59464 extracted\n",
      "Points 46730:28965 extracted\n",
      "Points 43324:27453 extracted\n",
      "Points 40458:57579 extracted\n",
      "Points 57277:49815 extracted\n",
      "Points 19892:49077 extracted\n",
      "Points 31340:55404 extracted\n",
      "Points 32930:1879634358 extracted\n",
      "Points 30808:37720 extracted\n",
      "Points 3812097829:12300 extracted\n",
      "Points 59720:34121 extracted\n",
      "Points 29221:10023 extracted\n",
      "Points 22845:54817 extracted\n",
      "Points 57835:3595 extracted\n",
      "Points 42150:59830 extracted\n",
      "Points 55660:12298 extracted\n",
      "Points 50071:28151 extracted\n",
      "Points 2422378008:2796749218 extracted\n",
      "Points 37976:15680 extracted\n",
      "Points 34377:40305664 extracted\n",
      "Points 12556:23648 extracted\n",
      "Points 51489:37923 extracted\n",
      "Points 3851:17163 extracted\n",
      "Points 10279:64394 extracted\n",
      "Points 60064:49590 extracted\n",
      "Points 28407:31165 extracted\n",
      "Points 12554:1595213056 extracted\n",
      "Points 1659044258:1557069752 extracted\n",
      "Points 40371200:50725888 extracted\n",
      "Points 23904:48652 extracted\n",
      "Points 15936:24896 extracted\n",
      "Points 12811:422 extracted\n",
      "Points 38179:41507 extracted\n",
      "Points 31421:43222 extracted\n",
      "Points 50080:37299 extracted\n",
      "Points 646710528:45627 extracted\n",
      "Points 64650:40512 extracted\n",
      "Points 3208118200:114623744 extracted\n",
      "Points 50791424:14418688 extracted\n",
      "Points 48908:54028 extracted\n",
      "Points 433:41739 extracted\n",
      "Points 25152:11548 extracted\n",
      "Points 41763:16928 extracted\n",
      "Points 37300:62882 extractedPoints 43476:9111 extracted\n",
      "\n",
      "Points 45883:6971 extracted\n",
      "Points 114820352:29481 extracted\n",
      "Points 40768:52508 extracted\n",
      "Points 14418944:30282 extracted\n",
      "Points 54284:61708 extracted\n",
      "Points 41995:50695 extracted\n",
      "Points 11804:15132 extracted\n",
      "Points 18208:28466 extracted\n",
      "Points 7227:18994 extracted\n",
      "Points 9367:4759 extracted\n",
      "Points 62886:32591520 extracted\n",
      "Points 53276:36236 extracted\n",
      "Points 29737:61993 extracted\n",
      "Points 61964:15139328 extracted\n",
      "Points 50951:1544 extracted\n",
      "Points 30538:3998464 extracted\n",
      "Points 15388:37440 extracted\n",
      "Points 28722:53809 extracted\n",
      "Points 5015:49341 extracted\n",
      "Points 19250:50979 extracted\n",
      "Points 33115808:53101 extracted\n",
      "Points 36492:57639 extracted\n",
      "Points 62249:29846 extracted\n",
      "Points 15139072:22284 extracted\n",
      "Points 1800:4531 extracted\n",
      "Points 3866880:17302528 extracted\n",
      "Points 37696:8742 extracted\n",
      "Points 54065:117769472 extracted\n",
      "Points 51235:4914 extracted\n",
      "Points 49597:15062 extracted\n",
      "Points 53357:17005 extracted\n",
      "Points 57895:64576 extracted\n",
      "Points 30102:62614 extracted\n",
      "Points 4532:26648 extracted\n",
      "Points 25100:34634 extracted\n",
      "Points 17236480:65012736 extracted\n",
      "Points 7206:10011 extracted\n",
      "Points 117507328:27826 extracted\n",
      "Points 17261:8279 extracted\n",
      "Points 15316:31735 extracted\n",
      "Points 5170:41019 extracted\n",
      "Points 64832:7250 extracted\n",
      "Points 65174:30934 extracted\n",
      "Points 64881408:13397 extracted\n",
      "Points 10267:58201 extracted\n",
      "Points 34890:61002 extracted\n",
      "Points 27827:29363 extracted\n",
      "Points 29192:47640 extracted\n",
      "Points 8535:28245 extracted\n",
      "Points 31991:30343 extracted\n",
      "Points 41275:33342 extracted\n",
      "Points 7506:18258 extracted\n",
      "Points 31188:58580 extracted\n",
      "Points 13653:25682 extracted\n",
      "Points 29364:31154 extracted\n",
      "Points 58457:5514 extracted\n",
      "Points 61258:3657 extracted\n",
      "Points 47896:823 extracted\n",
      "Points 30599:27837 extracted\n",
      "Points 28501:26967 extracted\n",
      "Points 33598:58146 extracted\n",
      "Points 18514:3913613730 extracted\n",
      "Points 58582:14110 extracted\n",
      "Points 25126:43546 extracted\n",
      "Points 3913:4424 extracted\n",
      "Points 1079:61704 extracted\n",
      "Points 44335:60236 extracted\n",
      "Points 25938:55497 extracted\n",
      "Points 31156:39350 extracted\n",
      "Points 43117:44375 extracted\n",
      "Points 32050:35644 extracted\n",
      "Points 2715156898:2623735599 extracted\n",
      "Points 14366:51755 extracted\n",
      "Points 52011:20225 extracted\n",
      "Points 38406:47428 extracted\n",
      "Points 1044382114:64669 extracted\n",
      "Points 50989:43038 extracted\n",
      "Points 9344:44078 extracted\n",
      "Points 65240:62884 extracted\n",
      "Points 23886:54094 extracted\n",
      "Points 42154:21104 extracted\n",
      "Points 6059:65249 extracted\n",
      "Points 35961:32683 extracted\n",
      "Points 42014:10566 extracted\n",
      "Points 38431:45081 extracted\n",
      "Points 20481:49475 extracted\n",
      "Points 47684:17475 extracted\n",
      "Points 3462804660:45688 extracted\n",
      "Points 63140:57290 extracted\n",
      "Points 54350:361496504 extracted\n",
      "Points 17776:26288 extracted\n",
      "Points 65505:1514 extracted\n",
      "Points 32939:56741 extracted\n",
      "Points 45944:29912 extracted\n",
      "Points 49731:23082 extracted\n",
      "Points 17731:2356 extracted\n",
      "Points 10822:40235 extracted\n",
      "Points 45337:59151 extracted\n",
      "Points 52170:23179 extracted\n",
      "Points 606470072:869370927 extracted\n",
      "Points 28848:39812 extracted\n",
      "Points 56997:21966 extracted\n",
      "Points 1770:52356 extracted\n",
      "Points 63276:43091 extracted\n",
      "Points 30168:63120 extracted\n",
      "Points 23338:20781 extracted\n",
      "Points 40491:49709 extracted\n",
      "Points 56847:60817 extracted\n",
      "Points 25995:46461 extracted\n",
      "Points 885653922:3204713395 extracted\n",
      "Points 40068:51346 extracted\n",
      "Points 22222:23699 extracted\n",
      "Points 52612:49803 extracted\n",
      "Points 21037:54558 extracted\n",
      "Points 46717:48096 extracted\n",
      "Points 49965:469281974 extracted\n",
      "Points 43347:46893 extracted\n",
      "Points 63376:64392 extracted\n",
      "Points 61073:59378 extracted\n",
      "Points 4289594624:1669530018 extracted\n",
      "Points 15781:60797 extracted\n",
      "Points 23955:8315 extracted\n",
      "Points 51851:21620 extracted\n",
      "Points 306907318:8008148 extracted\n",
      "Points 48352:50144 extracted\n",
      "Points 54814:13381 extracted\n",
      "Points 59634:22079 extracted\n",
      "Points 64648:62911 extracted\n",
      "Points 1391264162:2944 extracted\n",
      "Points 47149:42284 extracted\n",
      "Points 61053:24944 extracted\n",
      "Points 8571:34254 extracted\n",
      "Points 21876:64613 extracted\n",
      "Points 50400:64744 extracted\n",
      "Points 22335:33997 extracted\n",
      "Points 9187796:4199900834 extracted\n",
      "Points 42540:6470 extracted\n",
      "Points 63167:39076 extracted\n",
      "Points 3200:33807 extracted\n",
      "Points 25200:54442 extracted\n",
      "Points 13637:20532 extracted\n",
      "Points 32974:38350 extracted\n",
      "Points 58981:16766 extracted\n",
      "Points 65000:56768 extracted\n",
      "Points 6726:42550 extracted\n",
      "Points 741024:14496212 extracted\n",
      "Points 34253:25887 extracted\n",
      "Points 34063:15488 extracted\n",
      "Points 39332:40168 extracted\n",
      "Points 20788:54865 extracted\n",
      "Points 38606:48885 extracted\n",
      "Points 54698:4044 extracted\n",
      "Points 17022:26484 extracted\n",
      "Points 57536:13259 extracted\n",
      "Points 26143:49966 extracted\n",
      "Points 10432980:3224020 extracted\n",
      "Points 15744:34554 extracted\n",
      "Points 40424:48104 extracted\n",
      "Points 55121:41025 extracted\n",
      "Points 4300:37353 extracted\n",
      "Points 49141:50403 extracted\n",
      "Points 42806:12100 extracted\n",
      "Points 26740:358 extracted\n",
      "Points 13515:58611 extracted\n",
      "Points 50222:43002 extracted\n",
      "Points 34810:43921 extracted\n",
      "Points 31470036:30945748 extracted\n",
      "Points 41281:28979 extracted\n",
      "Points 48360:26314 extracted\n",
      "Points 50659:60069 extracted\n",
      "Points 37609:58258 extracted\n",
      "Points 12356:8491 extracted\n",
      "Points 614:57466 extracted\n",
      "Points 58867:58848 extracted\n",
      "Points 43258:59199 extracted\n",
      "Points 3067405216:19028 extracted\n",
      "Points 44177:25549 extracted\n",
      "Points 29235:18753 extracted\n",
      "Points 26570:30922 extracted\n",
      "Points 60325:30682 extracted\n",
      "Points 8747:54339 extracted\n",
      "Points 58514:42123 extracted\n",
      "Points 57722:55756 extracted\n",
      "Points 19284:51796 extracted\n",
      "Points 59455:37013 extracted\n",
      "Points 59104:56681 extracted\n",
      "Points 25805:34802 extracted\n",
      "Points 19009:2310 extracted\n",
      "Points 31178:30825 extracted\n",
      "Points 30938:20409 extracted\n",
      "Points 42379:35685 extracted\n",
      "Points 54595:4915 extracted\n",
      "Points 56012:13301 extracted\n",
      "Points 32498:10521 extracted\n",
      "Points 37269:53242 extracted\n",
      "Points 56937:29657 extracted\n",
      "Points 52052:16485 extracted\n",
      "Points 2566:54838 extracted\n",
      "Points 5171:7430 extracted\n",
      "Points 20665:62965 extracted\n",
      "Points 31081:54402 extracted\n",
      "Points 13557:3790 extracted\n",
      "Points 35941:36545 extracted\n",
      "Points 29913:27595 extracted\n",
      "Points 10777:36992 extracted\n",
      "Points 11822:57753 extracted\n",
      "Points 16741:23629 extracted\n",
      "Points 55094:9508 extracted\n",
      "Points 54658:43210 extracted\n",
      "Points 63221:8333 extracted\n",
      "Points 7686:55877 extracted\n",
      "Points 4046:15605 extracted\n",
      "Points 36801:40129 extracted\n",
      "Points 27851:5029 extracted\n",
      "Points 38016:15129 extracted\n",
      "Points 58009:54297 extracted\n",
      "Points 23885:55117 extracted\n",
      "Points 9764:57409 extracted\n",
      "Points 43466:53720 extracted\n",
      "Points 8589:13453 extracted\n",
      "Points 56133:49478 extracted\n",
      "Points 40385:46324 extracted\n",
      "Points 15861:17114 extracted\n",
      "Points 5285:41898 extracted\n",
      "Points 55577:228050 extracted\n",
      "Points 15385:9088 extracted\n",
      "Points 13709:41598 extracted\n",
      "Points 57665:38150 extracted\n",
      "Points 53976:62424 extracted\n",
      "Points 49734:20772 extracted\n",
      "Points 55373:26446 extracted\n",
      "Points 42740:5803 extracted\n",
      "Points 17370:9585 extracted\n",
      "Points 6774:12508 extracted\n",
      "Points 43883:64442 extracted\n",
      "Points 42366:46182 extracted\n",
      "Points 37343:3247 extracted\n",
      "Points 50909:27299 extracted\n",
      "Points 50842:58489 extracted\n",
      "Points 43624:40167 extracted\n",
      "Points 24791:6057 extracted\n",
      "Points 48643:34654 extracted\n",
      "Points 507:44381 extracted\n",
      "Points 12764:17013 extracted\n",
      "Points 15757:42107 extracted\n",
      "Points 64698:56205 extracted\n",
      "Points 3503:16856 extracted\n",
      "Points 40423:3714 extracted\n",
      "Points 27555:28092 extracted\n",
      "Points 58745:37254 extracted\n",
      "Points 6313:33665 extracted\n",
      "Points 44637:56669 extracted\n",
      "Points 12028:52574 extracted\n",
      "Points 41849:31655 extracted\n",
      "Points 56461:1211 extracted\n",
      "Points 13784:30338 extracted\n",
      "Points 42363:42458 extracted\n",
      "Points 36742:63205 extracted\n",
      "Points 28348:39654 extracted\n",
      "Points 33921:10153 extracted\n",
      "Points 3458:2271 extracted\n",
      "Points 59741:48379 extracted\n",
      "Points 56158:9116 extracted\n",
      "Points 31911:36068 extracted\n",
      "Points 1467:45740 extracted\n",
      "Points 30594:59377 extracted\n",
      "Points 10409:1767 extracted\n",
      "Points 39910:49581 extracted\n",
      "Points 2527:17833 extracted\n",
      "Points 58597:42222 extracted\n",
      "Points 42714:16109 extracted\n",
      "Points 48635:5628 extracted\n",
      "Points 9372:60924 extracted\n",
      "Points 36324:10412 extracted\n",
      "Points 45996:56171 extracted\n",
      "Points 63974:7056 extracted\n",
      "Points 59633:1699146418 extracted\n",
      "Points 49837:37820 extracted\n",
      "Points 18089:12674 extracted\n",
      "Points 42478:55194 extracted\n",
      "Points 16365:4560 extracted\n",
      "Points 5884:539167667 extracted\n",
      "Points 61180:14589 extracted\n",
      "Points 7084:18396 extracted\n",
      "Points 51619:39664 extracted\n",
      "Points 1218112178:2736914360 extracted\n",
      "Points 56427:10949 extracted\n",
      "Points 38076:45500 extracted\n",
      "Points 15234:25459 extracted\n",
      "Points 4816:49009 extracted\n",
      "Points 55450:40645 extracted\n",
      "Points 634594470:1365325216 extracted\n",
      "Points 14845:30973 extracted\n",
      "Points 18652:47056 extracted\n",
      "Points 11205:21221 extracted\n",
      "Points 45756:43383 extracted\n",
      "Points 39920:25736 extracted\n",
      "Points 25715:61671 extracted\n",
      "Points 387186616:138018744 extracted\n",
      "Points 1976173824:36884 extracted\n",
      "Points 49265:19702 extracted\n",
      "Points 40901:8166 extracted\n",
      "Points 31229:42237 extracted\n",
      "Points 47312:19932 extracted\n",
      "Points 21477:27260 extracted\n",
      "Points 25992:63174 extracted\n",
      "Points 37140:8983 extracted\n",
      "Points 61927:12735 extracted\n",
      "Points 19958:17872 extracted\n",
      "Points 43639:28614 extracted\n",
      "Points 42493:60925 extracted\n",
      "Points 2305294264:2218394415 extracted\n",
      "Points 8422:48366 extracted\n",
      "Points 20188:48336 extracted\n",
      "Points 27516:7633 extracted\n",
      "Points 63430:27773 extracted\n",
      "Points 18128:58842 extracted\n",
      "Points 16063:30323 extracted\n",
      "Points 9239:63445 extracted\n",
      "Points 28870:49894 extracted\n",
      "Points 61181:28088 extracted\n",
      "Points 3642622767:1725432226 extracted\n",
      "Points 48622:48764 extracted\n",
      "Points 48592:57572 extracted\n",
      "Points 29413:12174 extracted\n",
      "Points 28029:25722 extracted\n",
      "Points 63701:11522 extracted\n",
      "Points 59098:25837 extracted\n",
      "Points 30579:43975 extracted\n",
      "Points 50150:7272 extracted\n",
      "Points 28344:31486 extracted\n",
      "Points 1689125282:3211921062 extracted\n",
      "Points 49020:9379 extracted\n",
      "Points 57828:4742 extracted\n",
      "Points 12430:17093 extracted\n",
      "Points 25978:51184 extracted\n",
      "Points 11778:58008 extracted\n",
      "Points 26093:63102 extracted\n",
      "Points 1128:63932 extracted\n",
      "Points 44231:27889 extracted\n",
      "Points 33278:22776 extracted\n",
      "Points 2014773922:4147904930 extracted\n",
      "Points 9635:38568 extracted\n",
      "Points 4998:24434 extracted\n",
      "Points 17349:14045 extracted\n",
      "Points 51440:4551 extracted\n",
      "Points 58264:24930 extracted\n",
      "Points 63358:2175 extracted\n",
      "Points 28145:42153 extracted\n",
      "Points 64188:63608 extracted\n",
      "Points 107676066:1902707106 extracted\n",
      "Points 38824:63100 extracted\n",
      "Points 23032:54008 extracted\n",
      "Points 24690:32732 extracted\n",
      "Points 27746:2123 extracted\n",
      "Points 14301:22213 extracted\n",
      "Points 4807:31869 extracted\n",
      "Points 2431:21927 extracted\n",
      "Points 42409:5848 extracted\n",
      "Points 948946:14084 extracted\n",
      "Points 59304:6024 extracted\n",
      "Points 63356:42205 extracted\n",
      "Points 54264:42494 extracted\n",
      "Points 32988:37340 extracted\n",
      "Points 22469:30149 extracted\n",
      "Points 843:7067 extracted\n",
      "Points 32125:23527 extracted\n",
      "Points 22183:31440 extracted\n",
      "Points 6104:61870 extracted\n",
      "Points 14340:47108 extracted\n",
      "Points 8328:14270 extracted\n",
      "Points 23526:50574 extracted\n",
      "Points 42750:60414 extracted\n",
      "Points 37596:50106 extracted\n",
      "Points 18141:25297 extracted\n",
      "Points 7323:60177 extracted\n",
      "Points 23783:5491 extracted\n",
      "Points 32749:38096 extracted\n",
      "Points 62126:9327 extracted\n",
      "Points 14526:52087 extracted\n",
      "Points 47364:14851 extracted\n",
      "Points 50830:12476 extracted\n",
      "Points 60670:50425 extracted\n",
      "Points 50362:43627 extracted\n",
      "Points 25553:49050 extracted\n",
      "Points 60433:49429 extracted\n",
      "Points 5747:7153 extracted\n",
      "Points 38352:6518 extracted\n",
      "Points 9583:37087 extracted\n",
      "Points 15107:48387 extracted\n",
      "Points 52343:46022 extracted\n",
      "Points 12732:50653 extracted\n",
      "Points 50681:2811 extracted\n",
      "Points 49685:61957 extracted\n",
      "Points 49227:62555 extracted\n",
      "Points 2713911224:24911 extracted\n",
      "Points 23813:43611 extracted\n",
      "Points 12943:48891136 extracted\n",
      "Points 15816:26056 extracted\n",
      "Points 3867280640:2292559030 extracted\n",
      "Points 24941103:1409549990 extracted\n",
      "Points 62213:60491 extracted\n",
      "Points 43867:475 extracted\n",
      "Points 25167:57679 extracted\n",
      "Points 62811:14099 extracted\n",
      "Points 46269696:57672098 extracted\n",
      "Points 26312:26082 extracted\n",
      "Points 4144824738:2390264879 extracted\n",
      "Points 623141043:3293290085 extracted\n",
      "Points 60747:3606 extracted\n",
      "Points 731:53323 extracted\n",
      "Points 14355:61736 extracted\n",
      "Points 57935:22021376 extracted\n",
      "Points 26338:58439 extracted\n",
      "Points 57606562:32965026 extracted\n",
      "Points 1104478626:1065547445 extracted\n",
      "Points 1045667429:81855744 extracted\n",
      "Points 3862:44072 extracted\n",
      "Points 53579:47964 extracted\n",
      "Points 61992:11025 extracted\n",
      "Points 22086912:30213376 extracted\n",
      "Points 32309666:40436130 extracted\n",
      "Points 46735:18736 extracted\n",
      "Points 3525575330:148440486 extracted\n",
      "Points 80413952:1335964884 extracted\n",
      "Points 44328:38675 extracted\n",
      "Points 48220:55314 extracted\n",
      "Points 11281:16912 extracted\n",
      "Points 30475520:38864128 extracted\n",
      "Points 40305058:49349026 extracted\n",
      "Points 48711:29283 extracted\n",
      "Points 3989845172:3670434 extracted\n",
      "Points 3704894676:626603220 extracted\n",
      "Points 38931:52578 extracted\n",
      "Points 51730:17939 extracted\n",
      "Points 38929664:8783104 extracted\n",
      "Points 17168:63255 extracted\n",
      "Points 49807778:16056738 extracted\n",
      "Points 29539:4405 extracted\n",
      "Points 3342754:2454717231 extracted\n",
      "Points 379860180:588745775 extracted\n",
      "Points 52834:13473 extracted\n",
      "Points 18195:10203 extracted\n",
      "Points 8848640:14877952 extracted\n",
      "Points 4661:24975 extracted\n",
      "Points 63511:20741 extracted\n",
      "Points 16515490:10682786 extracted\n",
      "Points 1484195251:252838322 extracted\n",
      "Points 2616167471:3157525760 extracted\n",
      "Points 13729:43266 extracted\n",
      "Points 10459:28514 extracted\n",
      "Points 20997:36887 extracted\n",
      "Points 14943488:3434515503 extracted\n",
      "Points 23695:52706 extracted\n",
      "Points 3512599343:84935936 extracted\n",
      "Points 9437602:52756898 extracted\n",
      "Points 1517945266:418723028 extracted\n",
      "Points 39316:47120 extracted\n",
      "Points 28770:1919716399 extracted\n",
      "Points 52962:7182 extracted\n",
      "Points 37143:55650 extracted\n",
      "Points 2542351540:24391 extracted\n",
      "Points 2253166496:1452341432 extracted\n",
      "Points 30933410:3758030776 extracted\n",
      "Points 3061462228:2799566489 extracted\n",
      "Points 47376:16148 extracted\n",
      "Points 3580464175:3127422112 extracted\n",
      "Points 3858892211:2132669797 extractedPoints 7438:31075 extracted\n",
      "\n",
      "Points 45916:59547 extracted\n",
      "Points 24647:2062 extracted\n",
      "Points 3091509016:3658615731 extracted\n",
      "Points 3294953400:3895526050 extracted\n",
      "Points 16404:38036 extracted\n",
      "Points 845414818:3497394594 extracted\n",
      "Points 31331:48654 extracted\n",
      "Points 2318:60976 extracted\n",
      "Points 59803:56991 extracted\n",
      "Points 453510822:72877312 extracted\n",
      "Points 3136532504:881276116 extracted\n",
      "Points 38292:790 extracted\n",
      "Points 2141192610:3504944340 extracted\n",
      "Points 48910:32670 extracted\n",
      "Points 61232:59207 extracted\n",
      "Points 57247:532 extracted\n",
      "Points 2134062292:58787072 extracted\n",
      "Points 3994744501:74253568 extracted\n",
      "Points 534:22289 extracted\n",
      "Points 2756326612:3958833570 extracted\n",
      "Points 33694:58467 extracted\n",
      "Points 59463:11720 extracted\n",
      "Points 788:21781 extracted\n",
      "Points 62784768:414481826 extracted\n",
      "Points 74581248:297823926 extracted\n",
      "Points 22545:7699 extracted\n",
      "Points 3340370338:35206356 extracted\n",
      "Points 55651:15199 extracted\n",
      "Points 11976:26270 extracted\n",
      "Points 22037:21860 extracted\n",
      "Points 1096024576:83756288 extracted\n",
      "Points 475399424:3601307552 extracted\n",
      "Points 7955:44692 extracted\n",
      "Points 1275868372:1054533816 extracted\n",
      "Points 17465:23600 extracted\n",
      "Points 15455:5945 extracted\n",
      "Points 22116:20555 extracted\n",
      "Points 5464879:2438149332 extracted\n",
      "Points 34641824:2811130525 extracted\n",
      "Points 44948:48971 extracted\n",
      "Points 1337718453:3585998776 extracted\n",
      "Points 23856:15560 extracted\n",
      "Points 7442:23557 extracted\n",
      "Points 6201:55088 extracted\n",
      "Points 4240373429:2527790336 extracted\n",
      "Points 4217517268:71632128 extracted\n"
     ]
    }
   ],
   "source": [
    "points_df = extract_point_data(point_list=azimuth_tokens_list, pool_size=10, chunk_size=128)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>point</th>\n",
       "      <th>point_size</th>\n",
       "      <th>point_type</th>\n",
       "      <th>owner</th>\n",
       "      <th>parent_point</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>106693888</td>\n",
       "      <td>2</td>\n",
       "      <td>planet</td>\n",
       "      <td>0xeb5041edcd9b64c12a4f5714de2735276b77aa4e</td>\n",
       "      <td>1280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4170450735</td>\n",
       "      <td>2</td>\n",
       "      <td>planet</td>\n",
       "      <td>0xdc7bb203950dd469a738ef346001f1ad996b4a5b</td>\n",
       "      <td>1839</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>107218176</td>\n",
       "      <td>2</td>\n",
       "      <td>planet</td>\n",
       "      <td>0xc4d0bf450a8eaebdade66302b6428ab92463019d</td>\n",
       "      <td>1280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>107283712</td>\n",
       "      <td>2</td>\n",
       "      <td>planet</td>\n",
       "      <td>0xb0aabc70cb2dac74ae197a8d00776ee9184013a1</td>\n",
       "      <td>1280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>107939072</td>\n",
       "      <td>2</td>\n",
       "      <td>planet</td>\n",
       "      <td>0x843ec875de69c0cbdc115610246537b99d8688e4</td>\n",
       "      <td>1280</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display(HTML(points_df.head().to_html(index=False, notebook=True, show_dimensions=False)))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%% md\n"
    }
   },
   "source": [
    "### Insert Point Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Table erc721_analysis:azimuth_points has been deleted.\n",
      "Table erc721_analysis:azimuth_points has been created.\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "create_table_from_df(source_df=points_df,\n",
    "                     dataset_name=ERC721_ANALYSIS_DATASET_NAME,\n",
    "                     table_name=AZIMUTH_POINTS_TABLE_NAME,\n",
    "                     drop_existing_table=DROP_TABLES)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "bc76d0645b1cf604c8520835e64309500e40c4c326673226e4e522ff2b7f18da"
  },
  "kernelspec": {
   "display_name": "Python 3.8.2 64-bit",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}