and is unspent. Primarly between blocks 0 to 278,298. It is about ~34,300 entries. The fields I would like are: block_id transaction_hash time value value_usd recipient type script_hex is_from_coinbase is_spendable.
This is what I ultimately need.
Would you be looking for "4104eacd3bfaf2d76524763c4416db596cc26e4ff20c13f12ac7d3cc5b5cec3ec88b53ff35b349f b47421976facdc25e63ea365416c3a4ace7acb7884caa6a6d7a52ac"?
The only method I've found that gives me something close to the aforementioned is on
Blockchair.com. Can you export that dataset to a tsv/csv file? The option "Get this dataset in .tsv format" on the site takes you to the
Database Dumps.
I don't think I can easily get this data, other than clicking "Load more" 3000 times.
But even if you get everything: the address I checked hasn't sent funds yet, so if you're looking for the pubkey, it's not what you need, right?
I have no idea how to extract the data in that format from the outputs dump files. If you know some linux commands to parse them and give a similar output, that would be appreciated.
If you tell me exactly which part of the data dump you need, I can quite easily get it for you. It just takes a few hours to process all the data. Or I'll get you a short script that loops through the data, but to use it you'll need to download everything first.
If I take
a random output, it has this data:
block_id transaction_hash index time value value_usd recipient type script_hex is_from_coinbase is_spendable
158078 968937595d4777356aa3dbd61148c4ddcf0aef44e6295a479731f34998ee392c 0 2011-12-19 00:08:29 5008750000 160.28 1J6iKnrn9RPM6D23VZ6o1z5muVLUjJ9NuT pubkey 4104eacd3bfaf2d76524763c4416db596cc26e4ff20c13f12ac7d3cc5b5cec3ec88b53ff35b349fb47421976facdc25e63ea365416c3a4ace7acb7884caa6a6d7a52ac 1 1
158078 5c717d331dae3919337f11722e0e3f62b8c27230ee154f4c6c67b36a60bc4dd5 0 2011-12-19 00:08:29 1000000 0.032 1KSiuy6DeeDefyj2Ls8mnMvhRPb25xs6jx pubkeyhash 76a914ca4fa68a872fb740f16ca1caaa414bd989362aa788ac 0 -1
158078 5c717d331dae3919337f11722e0e3f62b8c27230ee154f4c6c67b36a60bc4dd5 1 2011-12-19 00:08:29 119721000000 3831.072 1LaN6ooQJpCqC5nFb5TCinceDkCc24eetR pubkeyhash 76a914d6b9bae958a79b931072b93a52e632f2464ae37e88ac 0 -1
158078 1c4e4dfa580566cb92ec3eb43e3650e542ba1ce7a35415b671f59794da702de4 0 2011-12-19 00:08:29 78812408397 2521.9971 1HT5UX8eSiT65fUZSskZYJ4nPPPL58Rzic pubkeyhash 76a914b4709009d5e5844f643b02ecafa7d55d7acb3f7d88ac 0 -1
158078 1c4e4dfa580566cb92ec3eb43e3650e542ba1ce7a35415b671f59794da702de4 1 2011-12-19 00:08:29 100000000 3.2 17gN64BPHtxi4mEM3qWrxdwhieUvRq8R2r pubkeyhash 76a914494294730abf03c846988654f15d1864469c737a88ac 0 -1
158078 bc9822da9fb69f43f1fe33682cd8007ad247deb75f5a6edb641751e456e18b93 0 2011-12-19 00:08:29 3578400000 114.5088 1KDE7sAtyhzJnLXcmJmAMYN9Xk3MRLsDxT pubkeyhash 76a914c7c234d085dd3d5dbc342d59cca174335f554fa988ac 0 -1
Would you be looking for "4104eacd3bfaf2d76524763c4416db596cc26e4ff20c13f12ac7d3cc5b5cec3ec88b53ff35b349f
b47421976facdc25e63ea365416c3a4ace7acb7884caa6a6d7a52ac"?