The sample that you've shows is exactly how I want it. Your suggestion to remove the duplicates and match them with those with a balance of 1btc and more would be appreciated.
Based on my what I've seen on the block chain, p2pk addresses were used up to block 278,298.
You efforts are truly appreciated.
I am away from my computer so my response is short.
I'm looking for all of the entries with script-type pubkey (P2PK) only 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.
If I get this from "
outputs", you get it for all outputs when they were created. So they're all "spendable" (unless they were used again in the same block), even though most of them were spent later on already.
If you need a list similar to what
TheArchaeologist showed, you don't need most of the data you're asking for. Now the output looks like this:
160345 3abd1b599fe1e69147c6d375d0c85f47999ba99b5ddfbc090370bcb1d1775760 2012-01-03 00:38:50 1375309318 71.6536 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160345 ff0b0816051a55f0e50820f3551df083491114bff0048e214dca75adf52f7506 2012-01-03 00:38:50 2943300000 153.3459 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160345 61622dff47f8f242ffeeae9f3b382fa975d309be45248af9f044e5350323b014 2012-01-03 00:38:50 1174309318 61.1815 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160345 a91453015e530f092013d24b063d821d46a739b6cddb913bd7f7fd30710b1971 2012-01-03 00:38:50 2780300000 144.8536 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160345 bcec7c219b25a598750a85c136446d2992ba336f8e2c2c0a2e1c2248adeacef5 2012-01-03 00:38:50 1072309318 55.8673 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 c3d575d5773035585fcd65d9f8f3291e2dc0aa2f52e28f3a6c6c2ad11ffb4e29 2012-01-03 00:39:37 5001000000 260.5521 1CkjArEYChyvBhjrfw69SZXeMbCLooRvyD pubkey 410408e007dd2c04b76beeb5a17c43ed81a8393174575bd80ba38b82097611f2ea0ff6bea432e69c22d5c67694462dc9d424477f130d55b35c595e8ec36ef774637cac 1 1
160346 7ea972403219e1b29db5b2dc7370ef3ef01317adca2520520f9934e0a35816ae 2012-01-03 00:39:37 2294300000 119.533 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 6f7a8a7733a44710b239f914b902d47013abf768c09a92c3c82448567dae0e57 2012-01-03 00:39:37 968309318 50.4489 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 5e434a0b0b670073b7c3b9983b73f6b71fccf4d88b200205451ada84da776ec0 2012-01-03 00:39:37 2187300000 113.9583 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 80bdaf438a966115587de07654e271b89bd6c2be4f158d114ff23f9f09295c96 2012-01-03 00:39:37 845309318 44.0406 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 c2827d8e852bb0e0b0938fba7a214ea6387030773e42f524c805ebc622f9225a 2012-01-03 00:39:37 2159300000 112.4995 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 caedb38e300073a08fa7cb04bf4da34018a8016506eb6c0fac15601ed375ccca 2012-01-03 00:39:37 745309318 38.8306 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 b53520a99ea46c541f8bcb2c3327d439a525ed897928a3771385550312fafdd1 2012-01-03 00:39:37 2142300000 111.6138 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 0d11d8a4cd909bb7aba2b0e39fa3ee3f26a4253a6ffe34ffb1b948206826aaba 2012-01-03 00:39:37 741309318 38.6222 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 a0107298cf53abfeb699402def5949763721186ddac81e88e4f55154043bea91 2012-01-03 00:39:37 2025300000 105.5181 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 7d5e8972f79b61ce3004a74fc5a1bda1e8d5531099ed5dfad3bb675c1982841c 2012-01-03 00:39:37 726309318 37.8407 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 f89d13dfcc18724e1d99a34e0149e7320277ff3e75ffacdd9008573d6c2ac8b2 2012-01-03 00:39:37 1834300000 95.567 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 54e0dd5717434d69c0e761dbf3791b8df39d13fb8e8578f22e6f161475069280 2012-01-03 00:39:37 712309318 37.1113 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 588329950a7cd00e492ea40c1f2b79c9b3648767dd5c0d8be6b1e51030ace4a5 2012-01-03 00:39:37 1707300000 88.9503 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 4c7636192f99c3e49cba193615e0a9f9e679725f0a545b2ef53206d321b7674c 2012-01-03 00:39:37 556309318 28.9837 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 5960134323fef0e8a6f945306eb3d6d8a1283265de1e61d1068c041c5f5d3d9f 2012-01-03 00:39:37 1686300000 87.8562 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 559b2e1ccbe450d3ca276955dd76677226c00ba82a514397159646a0722c6d6a 2012-01-03 00:39:37 505309318 26.3266 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 aacfd9b0f72603d533bdce3c217f4c291be181b733a7930aa16876dba768270f 2012-01-03 00:39:37 1670300000 87.0226 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 40092b4c718d1078a20edb7e9ead9456314cdedb4daea9d868cab53d7a66f396 2012-01-03 00:39:37 358309318 18.6679 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 5963ff2d7969842dd60a82b47b208037d09e6c47c6db2f4225167a4cade79b7d 2012-01-03 00:39:37 1585300000 82.5941 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
I'm still not sure if the long hash at the end of each line is really what you need, but if it is, I could get only the address and hex from each line, remove the duplicates, match the addresses with the current list of addresses with a balance, and only show those. Would that be more useful? Otherwise you'll end up with a couple hundred GB of data.
Why end at block 278,298 if I you don't mind me asking?