Author

Topic: Obtaining all transactions until 2013 (Read 206 times)

newbie
Activity: 17
Merit: 2
June 06, 2019, 02:29:30 AM
#7
Tell me where I can download the Blockchain Transaction ID until 2013? That is, I want to take only part of the information about the blockchain from 2009 to 2013?

1) check which was the last block
2) use the bitcoin parser on github
3) filter out all tx
legendary
Activity: 2870
Merit: 7490
Crypto Swap Exchange
June 01, 2019, 12:39:48 PM
#6
You also can done it with bitcoin-cli by :

1. getblockhash 277995

Code:
0000000000000002646768bcc5062a072fd97339f9830fa2e4fe83d9478ebd5a

2. getblock 0000000000000002646768bcc5062a072fd97339f9830fa2e4fe83d9478ebd5a

Code:
{
  "hash": "0000000000000002646768bcc5062a072fd97339f9830fa2e4fe83d9478ebd5a",
  "confirmations": 300833,
  "strippedsize": 115716,
  "size": 115716,
  "weight": 462864,
  "height": 277995,
  "version": 2,
  "versionHex": "00000002",
  "merkleroot": "7312bf0903cdc30cfdaf84c70a98bf34a4b49b3529803e9318c92b3893198d09",
  "tx": [
    "6ae260f431d13b49cab68ffc4915ce8bbabeca8c70951b09dd3ae729b799b702",
    "b09886958fda52012ffa4dda24e9f86ee3af7e87a447d5a31ef4f49663006ddf",
    "41970a157ccfe6c2bae3efce298ef8e29b460c682512aab586dcf246f3b7e46e",
    "2b8260c3f579981f393e18e551e3c4a58b432c98e4b01e844706610a844dc49a",
    "55582755b07c3ab9a575391cabae47dc03df69257e53128d0579a5739c925ab9",
    "da21d6c4920cc99b136a94f5c87bd027dcee2bfcf01f01b340ff83ed905ed595",
    "5699de7ab6383a1330b5a29927c081b63ebb3157d09b3a5de17db11b2f543237",
    "fbec40cd667f44d1133ce5bc1a07895a2c9374670041a9191e3c56fb198f02ad",
    "3d0881cc3eb1716dae7942fc25720930e406eb2df850ae90dda9a2c5652271e3",
    "44e9e5f2be08b6cf5b1fcfadfd38b91b65f92bda8f3475b6acb9e5cc4faae5d1",
    "244d24edb6abb2e9ae312d0199a64d367b598d68634e396919f932adde3a586d",
    "b2a8f844fced25130d45f9848cb935f7e1afe3557bffcecb41a0cda801ebf56a",
    "adede15b3c61de851fdd53e494584f51f0a6bfae36580df7ad1dc24815082cbc",
    "84de527a375e0e4257ec45f107dc05c04d9dfd91fc60da0cd5604177e8028979",
    "ad66825ccd6993fab7409dffb29acf0863806da1e48e3381261911f59a66d22b",
    "1f7932eb215869252882c954d829483fd920e6fb1fba4587adb9ce48375b0b32",
    "8f9cd012ab3a5bc869e76fa50e817a59c7510e05985e9584d2631bd4063da850",
    "3a3bde9d716b2aae0ecaf5fb2e18ba3a120844f384aaee48315e1bc119d49d94",
    "7d6ab68cdd47d185d8ae3e7f1a9e9ef859a97d0231ce7a54f12d21addf98dffc",
    "0318fb7c01592e972b6ebb2214b5dc5ae8f6619530b83c0bfc14678858eef3a1",
    "df9752611ec21e4fe722bb16fa723ec3008b3597f659a512bfdda126d28de875",
    "8e44417063bc3327ce8851109ffba8e8ded2b7f3ea00aa76cff1c33e97f1d502",
    "c1e9afdfd7ef1454d3eef50b5ce696ea6057d4397695317e556d710a639280d1",
    "efd902663262d04632253c43bc580a0a6bf682a4d46ee3c668c419349aa8af79",
    "14f057d5163acf70368844155b549680af457c859168fc65cf002f0df87e7c9e",
    "71b4de2fb6d4c766f9af84f539063b9ea0115ecdb22bd0995003bb9489c87f6f",
    "940398692de7dd5c3d02a6845ba2f5c0c1879f0ad743d11b962e8866ab4eb1a1",
    "c2b559240b813220f33f63a726fdf1374d5cb18ab09262c5bb21796bf0cf1b34",
    "72205ee5c472a07f1b07835f052e33a82a737dc6834081a2c0240282a87b65e8",
    "9b14269760f2d4477504a218d3bd6ff8a14b0bf56b8d8a677894ed1beb1ff877",
    "c5f39e46aed5d6e7116d2023863aaaae3dba7b8aa640b28b331416dd1e4c09c9",
    "9565f21a0c074b2051c6aaa27ed13a96986fe4155f1947c95d6dfc873fd34d24",
    "f98b9aaba05dad43d5b996a8fd8d72b5e8c6ad2c501af85ec2bc292b66303e44",
    "f818ef85edace0fb02be9133149c1de3a605be0995aad1b493aebaa7bf1009fc",
    "e439e81ee0034ba9867239ac9f69d99b6b22b66cff6299904040c2a615c616e0",
    "695b61f5cfa9a242dc891ee9c5785c2da0a60fb50009f68acfb78ff820655623",
    "54c815191c09c7ddb8fb46cbf0b911d7f69c3cbabad276f3fdf7f459b709ebed",
    "1437b41e62aa3fd558e1ea38ced214c8a5c964f2d3e04c82a8b0f4f0b842e0fb",
    "fa664605ef6e17c6d57de20833546442e5b219bbe6d84fe3f7ff3036a7d111d9",
    "200eadee0036ffa2f27358bcf1ddaa709948310a9a400bad5cf921816014fa48",
    "1207b24e15c9ce5915c83ddaf431083cb36b9132b8a44d449c859ef4ed51662d",
    "dc83846b5b7288e11415873847041900276518785e7de97b50511ee17f424765",
    "79df15f8ec9b6183eda4766736c15ec267a059b44d4b19593ba674647c9621a0",
    "d8d0058a2369dbc0dca7982dffc965286f808d3eab6700c5b0bf1275a345c9a9",
    "2c9c4d79256805a0cc61a547c0f6088c1431f7829844efebc08a065e7121d770",
    "a957630040bb8ea94e626a23bbf0826a1cdce353c8faa61919bb21dc2c5703cc",
    "fb346064fad8db82b05b312569df17754d753cf9a436af12c7d57c1733b287a8",
    "037763056ab8ca690f9296cde21729e28d694694127b8c88a9e39cc23906d0d2",
    "8f6121da6cb9c3505b559596f3c668e89b96af67ce91f6d498d37351df916761",
    "9ee848d789b8d84e03bfe58e7337339c81a2cb5305b2fe1b87ea7529c19722bb",
    "577505e59a6860aa2183ff7e352b3599e65633d2e91997cf442a7deb1057b70b",
    "3037855bc7440b6c0a6990d74ce37c19ac899ce410af374df636e14f8c30c9a0",
    "cc785ff82382779b538d75ef39c8baf4fc049b492c28c973415903e75b392d1b",
    "a6c607ca4785118d62b3215cf512d6dbd6c0c2881558765506f4ab64dbd3cefb",
    "4313f473907d526c9c668866408b35ee04ecf64d30f4dbdc2ecb14e452f8d4e9",
    "55c38c7e153132af70d8dc2fac616ff983da4b248179bab4db57a2fb68606d64",
    "17c682da630a0d61e05d9ec4335cc1daf333b0a6b30807798d2d059afb700760",
    "0cd6631f8e4f2120dba5965e2ab229584ed06aaf7b320c1739652c9bf0ea817c",
    "8827e3184c04d047f75433363296aea48c9ded598fe8e1786a3efcd1c57c5ec8",
    "b2d9a763f9bf3cf45a3148f8a96f76aca447bcef787b6b17d6588dfb86d3453b",
    "22eaccdf0560b46b4bed6b41a3e18984a7c1cd0223ee98cb40226eff67c18d17",
    "4cd7cfb67d9b015d9736035579bd47f2c27452984923b175a171c012ad83d80e",
    "b7a30926a35d45e73da35c0602f5fe6582f8b89356a6de5fe5bb81ac88c3c0b7",
    "a259298fbbbbf081630b846fa1ae90d981803640e4531a57848cad0054e5d10c",
    "e7bfaf01b44bbce9c079fe9a1b298620d2fcf837b31ec0a92424b69c45cdc60f",
    "6280d039ce02bb2eda60465f3a157b4eb1ae2874da0f2465359afb7ea8cda87e",
    "64dbc789106b7627dd8d1443106c3675368fbf6a8bcb105d2b3b3112bf6334ca",
    "d016047697f1c6a66f49520252c328e162401b7caf784b43d654decec57b2422",
    "7ad44eed07c71315f056e611ad1749798f12cd81780392f06a2d2bcf336830cf",
    "fdd3bedaee0fb8e9c32be38181d02484d2b99f0821ddbbfe05f3e3a9fcc8d390",
    "4960351ac7dc54218a9dfb57977ab5120e84623ddc0be3c384679da102a27331",
    "c2752087c70a99a21d0409813315ddf8b85900e005ac962db553194adcd74ac6",
    "515c2ebb1a8346431653ca14ed337e9fd2c0d73b639c562d3836eba26a26a14b",
    "94c3d34ea6e1135613e515f91787060948f3932715b1e54ad910ad97d977cc64",
    "1ed9cf0f805d2e0334b4f2a64de1df1bf3daeb3e4378c3ac3592f2aad27432fc",
    "7afa604ae546c0b6d916b6d2928bae196048c9e5cdc4e471ef3a552dda17a764",
    "3e71da64b821fa449b4bac737e6b74058b678c768379eac2394a668e5c9f2f80",
    "2a6a7f827868f5ac8951bbbb856ee0a2b358137bcd9047c188fbde039f4cebcb",
    "151efff6aff7f9a407c3669df391d44cd63c1f35792ccdb28eb3577d0c671e66",
    "481d70a54a26df8971dffdb06dcb16c7d7fa140565262394e9a2edd673b4254b",
    "6e7c59ea1d4a9027ab938df963942abd49e2b0a6e20da20a536391ea49f47a60",
    "006e8f022fe92a83dc8fc891094260a2fec61493a6a13a5d8d588309a143b868",
    "f640d592722dcba2d8ac30f5273d1a41ea219ab444262c2bf4da6fd6339864ed",
    "317b465d4705cdc5bdaaf67f6808aff21e0e484227716838af411754ec4db56e",
    "bb4992becf59daafd5a7ac0d1f4bc9da8715913bf17ca0246cf877bbb373c828",
    "faf6ed5367ac9c019310bb0439c73aada0b4ee349e5dedbdbf1c5a4e1e8bceb4",
    "c8fc4fe0e48ba2383beff72cdcfd8379c108abd5a0be715385dd1ac4ad354795",
    "8db728e5e3ada69b108e820c094767d9b72d4bcb28deac8b5f478235245bd4ee",
    "8ed70ddfbe61641b6ccc29627cf1b2aa09ac346f8c0779c7d8b98102748c8ab1",
    "bbc65749711e27aacf29ccd0c913a825176438ffa26a65b44905153c92cbb7e5",
    "26dc484221ea030df2ec1dfc843d00f317db96090982cf5332ed201cb78efd5d",
    "01ef32991a5016e5e1138915c30b19ec3340ca20de3595ed0f134e58b606ef9f",
    "b66dfee900c396a2ca85352932aa5ab83f31d52a6958f989c158bf2bd33d1fb5",
    "5a6609ecdc3fce178d7f781ed8aff985b5604560752dbfd4baa4ff36725fa97b",
    "c6c511b3d6aeeb0b3f0afca2418aa02e07108c843413ca17116429d582f411ea",
    "90378342cdef6be79984005aaa9ef41714b8bf3e01275a91f570e607a6d85594",
    "feb4b1f4b92efa48462dbe49f3e6d2a4b68e7abdcaccc429e6366a9232fae859",
    "cce12f5fd44831249f58e0d65fee6037229f43b63a5fc527c0e4f6ff34317eaf",
    "fa1dee766ec5376dbc0b94d861ea64d1eecc633c28c3d2c7e7ec4dd405b4476a",
    "7081c3ef7632295e6f3ba0afa7e2d45b2bb4d4af9db7fb3e8a8d347caa14c2b2",
    "527246d8d935e497aca18473784ad1370748f1117e62263d24e518d37adf3e57",
    "bb3d5b8b000c188c2845835adf395e7afd4ed79acf441fbf72d1842225fe1f6b",
    "bc7574a286c3a19dcb0fd666267ac7cd4bdb15275b58a1de49018d3cd2c80107",
    "866070292505a76137e1e2228cf6f2e13b3cc4a116fe076b2b6bbbcb5d3fbbf9",
    "30d7da7867b9039dbf13a35a5ac13a9b9e0e092946854440da505437ec44cac0",
    "191f78f16daea329caafdc9225e4c14b73ad27a14c21a1e36283f654375274a4",
    "f8611d86aef3632b9ce49c143777773b4a31cc35e190b08c220f00cfa1754e99",
    "047a4e3676bda8552a9b680d22401849a93df49e486d01aaa2e025809160fc45",
    "94c8f73205e9d2eef862108c23349a2220efb866e27270f3f4f60eb2cdcb1434",
    "39dcdad8210d5d7e849e7025ed6cb89a6bc479e9faffc1e6c6632382b5f7e352",
    "cd4c9599ce1bee8403da353758e9710b0302ec5472a3d688d208d98abefe3cda",
    "b7b62890ea03bbe5311dc95712beaeb79275d3e00c3050ba510fb59684bd490e",
    "b53d588bb15ed86a7e62d9098b186666cc66183f893827f5e850a7f5f802a374",
    "33d7eb990efb57258c765a5ab2c1dd35a854dd4366fc6ac3e9bd92c3f5532aa2",
    "469583e485fad55941cadc3835e77fc7c56dbd776e50e44537f82c05df77a5e8",
    "da342c9bcc408f9793d1d3a027ea650067f19fdca9589ff0b950d75c9d13c097",
    "2d85c2086bbd4cdd0b6313166048106a016d7d00f7cc7ff1b4f633b4ba71a87b",
    "5183611b933634e89ed3f10a36bdb7ad1a74eb203df2676fdba1b7730a8145b4",
    "a5fd75e0666d2ce13d09b0b85a59166574bcf612f4fc3753da85106567ad7bd0",
    "ef44ff124303e79f4b0ed819f39d2ae3a666c5b795f57644fad63755468f94b1",
    "de0377c347d97031ade8428952556c7a058b91c16feee126f7c829907f2ed49d",
    "ea0860a1a7563dcb02755b435065dda051c42176cf6d9944427588ff30b6bcc8",
    "8cec8881860e2b0a02228de75660e8c767d8d907ddff7bf21c31e3cdeaed9404",
    "01ac4662deed2f898c422117311460e3b50a332b77705c473a35e22471768536",
    "64e5f03514efc958e6349495bcf63c720b3abc08cf89b04db6f3796663a88b7b",
    "5a95e0fb1806e55383804e7d13170edb3bc257b8aab8a4b33d7ee310698d05ad",
    "d52315104c80a599a4c4633097c57241070232a02bf52398858a26b5d7e81c1a",
    "6f3824ec2293a19dc704bbe99ae9eab86b1c9ad11ddccca2e405ab80e0ea8ca0",
    "ceac7f8b3b8b39255b98daa0ec9b75b5af44d781e38a9dee33a55add64d9a70f",
    "e08f5edc74fbe622812e401aa825ad57dc95d74e82cc192923e785353cf4a36a",
    "1787fbd7423c2c0cab294894ba6340a8342841584f797d2cbdff89581a2d4c1e",
    "8085911643db9baf9c070ecbbbb63e55d7f23fb083f3fe1c657388c7a458571f",
    "566b210ce667af963c0b48d1d12f9dd11c877378bb5c62a20397c457e4dd7668",
    "d20da582c34259696336d1eb70901526d8b83cda379fce4bef3cf27d009d1552",
    "2e012f90884fa805d476b836fb187b86b657eff141bfc6c3cc63786e9aea1d4b",
    "bff4d7f8160f5c823dc627cc29ed5e77f031ee755636cf0ab3339c2cd7f210b7",
    "1e32d89b202f49e23a16ece43bc9f5dbf7021fc94af0f2eec19e41af2d4631d7",
    "dec5c7f351bee2f50190252e63d7d029cffa25444bbb2d58065536d1aaf625bf",
    "43dd81c575491e015d2836924e1e53b609bf938c2ef559b7774ae50367c44978",
    "a77fea07a7df2923e8cac99e035d4e7a4b38654cda8dd027b79dd78c26bab50c",
    "7aa1192bf39d60026a9b3dd15908abf66d71f7a88917bb8354bd2798ca27549e",
    "b3597e11a7ee088e86135976e0592734c1b30356fa012d523fe4187533216945",
    "8105ee64f5e5415b82fd28823e2e5f656f0c2039a616c05d850a716a84ff9a20",
    "27e0a59acc2b6e7962f7bfc3c09c277faa234eefe2ffffa8d0375bc5bc2ac8da",
    "8008207c44291b4f890626c9ca60a32609b34f39343f399a3da592d97f09330b",
    "d5c7d5181d02a3f5d6095990ba991641d74047585486ceae8d7b0a8f410e2213",
    "4046ccdb255fcb4281b0ef77cb4ac868f5acd84968b14ca0881b449957cbe0af",
    "d07f4e1cd71f78e2e627fde9103190b17d987217ba2ae2fc3fd59606fc153c6d",
    "83719794c13ffb3f76fcf56485d4e297400932ffa75be270bad58baed04f4ce6",
    "a9025b2ef277148016460e3db3eea8efe0a4d5116d1030b7194bfda080e02706",
    "a95c2fc39a2d2bc827f20455cae2f55d72be60550a4583c80a9a7247adc83dca",
    "b9c48d7d70c81ab1ed63d551fe16ba0b1d5a61868f843a61ea20bc76660f2fb5",
    "6f43d0e44c74880e8659ad49ebef8b0d27acadc2ba687e74f1a0b14742228d47",
    "03c60f5008c6de65639e8f4b52c6044cd01fe8080d118e0a5f9045e408fae373",
    "6186bab58a83d420d22646c1a32dbdf12b7bf0ab29eeaa14564a0ef66d6b196f",
    "85ed2be9e9834cd6cee6ef35917d689b1888ac443e3bdee5542979aec182803c",
    "3610a72d35bd118f9d92070a835b701572bf003db7b62766bc7a8fb57e7cb2cb",
    "cbaf1af7238984a40c7dbe0f5f0b28a15495d748c7d15560dc561004631cc7a5",
    "5d53e3bda6d913ed4cc3c961efab1873373cc57217ee28ea06b5b6d925a4bc6d",
    "51d9364dbdcd286036f7aaa632b593d42c1088d66aae071dc0cf532908fe9200",
    "119e37e068d9c2f5c1eb45c6b0bc0c5cafb7a5c8b5a2a40ee2d63b3c03084809",
    "f468ade9a6f61827f57e6e6676c73389062f599a810b3cdebdad78569eefd917",
    "e65a853d0484243387d321a25280db31f3e5aa82cdbe5723d00c2c4d23087907",
    "1c2793f3ba35781ab98427df71578ec1170bfea89da242e1bb07f857e8c2fce0",
    "e8b18dcb46530132026f827fd23f20763dacc5bb7dc102b428234664504c61c8",
    "9415aedd1f72249590353c5c1478702394f927b191b5c047a3be24075b97fa30",
    "25e3e5a407b5dfe0f3f89d71f43230b61f57b34930da3a2a818718db3dd1e402",
    "fcd8c01624b9f8fa8d8f31405272ec9e34ca5da7847d04b0121e5c0c68e694ed",
    "3067ab6e6aeddf685cbd101878b7d0b24397345832ebaa6fb2899f1c386767a7",
    "ae30db5d07137e64fe1de6b2ebaaf87db8d1cc1a1ecf93139d3d882b09c94cd5",
    "12e0f8851fa5bf815a3495953d6c84f0f6b301bd0b21dae6a1b4bb7b32788ee6",
    "0daaf3f6a828dc422954917b025d11a132e6458a4ffcc87a0ce60be887a6830f",
    "9533ad0b987aa9e8c792b7eb7590e96333e59ee909e6a01f4d0d2c2c5fdb4077",
    "408c397fcf82a759764a87e13e7de60c073d00fa7771585a67084b983defd535",
    "1e09fb4802f01101049c21a1acb61b5afcef54d3ec7427700bde64636ee525e7",
    "40016d96280b428f95f8a80fe16eb0e4b22296896e3095a5a2224c5d47767f1f",
    "0c9b21cae1d1707a2f02fe5d4feb10dca3d42425715f1d0b730f50dd555e5bee",
    "40bde0fc566803964b999066cb53bd312825bfc6b99cc8161eb2c89217eada6a",
    "fb3730684b65ea5fd480974d7c2a539e6b16933e20bff708094c44d4c5bf9dcf",
    "8d7340e5ca4da471627cb59c9a4e4e2c44cc87dfb41c9df61e78471895b07a0a",
    "8af024f8309a7f382168b3c7b5b74e45e515159fed4bcf6e969189cd393f0077",
    "5dadd4d94a6d59b082955ca561ee5e6aebee45c27a430527870f1d0da858a412",
    "2c2063a096dee10a8d8364d539d7787ac32525fb3cf6a2f5f0c22cac42c9553f",
    "990748ef77986806c1e115a3b20331679413da4c9dfea0dfc4de686ec3eb0f35",
    "78dc47a929d71ddafe93d2ca73bce48b46bcd79d1e28573cf3963953c23f87db",
    "b5e1296bca9cadd2c0d78dbc77c1d95ed569e151cd9064752214d5e319ee3f23",
    "22ee3ba7e71de62830259ee780c547634d6760facc54423b8e2d711ee4d33043",
    "8c88d6596e35507a9008e0bb887c0aa808c52845270e58d3c011301da7f31ca7"
  ],
  "time": 1388533521,
  "mediantime": 1388530881,
  "nonce": 981059396,
  "bits": "1903a30c",
  "difficulty": 1180923195.258026,
  "chainwork": "0000000000000000000000000000000000000000000009ef1be5355dcb0ddff8",
  "nTx": 188,
  "previousblockhash": "0000000000000002cef6a921d36360ad5099025a5cb8fb7d29ab50c1ac96b9a4",
  "nextblockhash": "0000000000000001eac750e8f6b9226e009856cbea1f9e05ed5874056218deea"
}

3. Use JSON reader to obtain only Transaction ID
4. Repeat until block height #1
legendary
Activity: 3472
Merit: 10611
May 31, 2019, 11:13:28 PM
#5
you can use Blockchair.com explorer to export almost everything as long as the number of cells is less than 1 million, otherwise it may cost you.
visit: https://blockchair.com/bitcoin/transactions?s=time(asc)&q=time(..2013-12-31)# i've already set the date for you but the rest of the options won't register in the url so at the bottom of the page deselect every other option you don't want such as total output, output count,... and only have hash and  time options selected. now you should see 60432140 cells. either reduce the time to get 1 million and export manually or contact them and see if the payment works for you and get the data that way.
hero member
Activity: 1220
Merit: 612
OGRaccoon
May 31, 2019, 06:40:26 PM
#4
If you start to download the blockchain you can use something like bitcoin abe to parse the chain into a database.

I have started on a small guide on how to set this up.

Code:
   SETUP

 :Required:

Ubuntu, MySQL Python, MySQL Client, MySQL Server, Python, Python2, Blockchain,

Downloading the bitcoin blockchain two options.  

1. Download & Install bitcoin core wallet and sync with network


################################################################################

Install Python MySQL


$ sudo apt-get install python-mysqldb

   Install MySQL Client & Server

$ sudo apt-get install mysql-client mysql-server

To configure the MySQL instance with InnoDB engine support.  
If you installed with Debian/Ubuntu then InnoDB is enabled by default.  
To check for InnoDB support, issue "SHOW ENGINES" and look in the output
for "InnoDB" with "YES" next to it.  If "skip-innodb" appears in the server
configuration (my.cnf or my.ini) then remove it and restart the server.

################################################################################

SETUP MYSQL

Log into MySQL as root (i.e: mysql -u root) and give commands.
Don't forget to change the PASSWORD

    create database abe;
    CREATE USER 'abe'@'localhost' IDENTIFIED BY 'YOUR_PASSWORD_HERE';
    grant all on abe.* to abe;

The above will

1.  Create a database called abe
2.  Create a user called abe for localhost with the password you enter above
3.  Will grant all permisions to abe for abe user


################################################################################

DOWNLOAD AND INSTALL BITCOIN-ABE

This will allow you to check getrecievedbyaddress calls quickly without being rate limited by online API checkers.

$ git clone https://github.com/bitcoin-abe/bitcoin-abe.git
cd bitcoin-abe
python setup.py install

once installed open file abe.conf
(Included is a copy of the file with section uncommented all you need to do is edit the password and DB info if you changed it)
If You use the original config file from abe you will need to follow steps below and uncomment and modify lines.

################################################################################

abe.conf GUIDE

uncomment lines 33 & 34 and update line 34 with your password / user and db info for MySQL

# MySQL example; see also README-MYSQL.txt:
dbtype MySQLdb
connect-args {"user":"abe","db":"abe","passwd":"YOUR_PASSWORD_HERE"}

Uncomment lines 57 & 58

# Specify port and/or host to serve HTTP instead of FastCGI:
port 2750
host localhost

This will open port 2750 on localhost to allow the wallet checker to connect to the API

Next scroll down to the section where datadir is listed, you must specifiy the path to the blockchain directory this path should contain the bitcoin.conf & blocks & chainstate folders.

Uncomment Lines 136 / 137 / 139 / 140
**Do not uncomment line 138 "loader"**  as we are not caling via RPC rather via the API and http request to gettecievedbyaddress + addy

datadir += [{
        "dirname": "/path/to/blockchain",
#        "loader": "rpc",    # See the comments for default-loader below.
        "chain": "Bitcoin"
      }]

################################################################################

START THE IMPORT

You can now start to load the data to abe from the blockchain run the following command from the bitcoin-abe-master dir

$ python -m Abe.abe --config abe.conf --commit-bytes 100000 --no-serve --datadir /path/to/blockchain

You should see output like:

block_tx 1 1
     block_tx 2 2
block_tx 3 3
     block_tx 4 4
block_tx 5 5
     block_tx 6 6
block_tx 7 7
     block_tx 8 8

( THIS PROCESS WILL TAKE A VERY LONG TIME POSSIBLY 2-6 DAYS DEPENDING ON YOUR SYSTEM SPEC )

You can stop the process at any time and re-start the load will continue from the last block loaded after checking the chain.
The data that is loaded can also be used to search while data in importing but only up to the latest block number processed.

Next step can be done now if you want to scan small search space or wait for full import of data before continuing.


################################################################################

CHECK MYSQL

Go back to MySQL and log in and type

mysql> use abe;

mysql> show tables;

Output will show.

+-----------------+
| Tables_in_abe   |
+-----------------+
| abe_lock        |
| block           |
| block_next      |
| block_seq       |
| block_tx        |
| block_txin      |
| chain           |
| chain_candidate |
| chain_seq       |
| chain_summary   |
| configvar       |
| datadir         |
| datadir_seq     |
| multisig_pubkey |
| orphan_block    |
| pubkey          |
| pubkey_seq      |
| tx              |
| tx_seq          |
| txin            |
| txin_detail     |
| txin_seq        |
| txout           |
| txout_approx    |
| txout_detail    |
| txout_seq       |
| unlinked_tx     |
| unlinked_txin   |
+-----------------+



################################################################################


LAUNCH BITCOIN ABE (LOCALHOST)

If you have this working you can now launch ABE from the bitcoin-abe-master dir to view the api in localhost.

$ python -m Abe.abe --config abe.conf

Open browser and navagate to: localhost:2750  

You should now see the ABE block explorer running.


################################################################################

Quicker ways to do this but if you wanted some kind of database of transaction this would be one way to host it all locally.
hero member
Activity: 1232
Merit: 738
Mixing reinvented for your privacy | chipmixer.com
May 31, 2019, 06:27:24 PM
#3
try contacting TheArchaeologist, he may have saved a copy of all txids while conducting his experiments
he was working with blockhashes, merkle roots and also doing sha256 on public addresses and all other stuff
can you tell us what you are going to do with all those transaction ids? similar to what TheArchaeologist has done?
staff
Activity: 3458
Merit: 6793
Just writing some code
May 31, 2019, 02:42:42 PM
#2
Transaction IDs are not stored in the blockchain. There are probably APIs that you can use. Otherwise you will need to download the blockchain and hash every transaction to get its ID. The blockchain between 2009 and 2013 is pretty small so it won't take a lot of time or disk space to download that part.
newbie
Activity: 2
Merit: 0
May 31, 2019, 12:13:35 PM
#1
Tell me where I can download the Blockchain Transaction ID until 2013? That is, I want to take only part of the information about the blockchain from 2009 to 2013?
Jump to: