[alt account hunters] Which posted address formats should I look for?

[Shishir99]

You are correct that hundreds of accounts have active loans on the forum and have already repaid many, but almost all the users have used a Bitcoin wallet, and earlier, a lot of people (almost all) used erc-20 wallet. Considering these 2 types of accounts, I think BEP20/TRC20 is too low. I mean low, that doesn't mean only a few, that means few compared to BTC as well as ERC-20.

Probably you are right. Since you are in the lending section, you must have a good experience. Yes, I agree that the usage of TRC-20 is too low compared to Bitcoin users. I think people mostly use ERC-20/BEP-20 addresses to participate in bounty campaigns. I think bounty campaign things died after 2018. So, I don't know if people still use ERC-20 wallet addresses these days. But since he wants to work on it, let him find the TRC-20 addresses as well.

[rbynxx]

@loycev Is this possible with social handles like telegram, twitter, reddit, facebook(meta), etc. or this would require more storage/workload on your end? Most of the time alt accounts don't just use crypto addresses and with experience most finds I did as far as I can remember was through social handles.

[LoyceV]

@loycev Is this possible with social handles like telegram, twitter, reddit, facebook(meta), etc. or this would require more storage/workload on your end? Most of the time alt accounts don't just use crypto addresses and with experience most finds I did as far as I can remember was through social handles.

For now, this project is on halt. So much to do, so little time.... If I continue this, I may just search for any long string: anything above 30 characters that's posted by anyone. That should include most crypto addresses, but also TXIDs and links to TXIDs, so I'll have to see how  useful that is. But it's much easier to implement than searching for each separate crypto.

[rbynxx]

@loycev Is this possible with social handles like telegram, twitter, reddit, facebook(meta), etc. or this would require more storage/workload on your end? Most of the time alt accounts don't just use crypto addresses and with experience most finds I did as far as I can remember was through social handles.

For now, this project is on halt. So much to do, so little time.... If I continue this, I may just search for any long string: anything above 30 characters that's posted by anyone. That should include most crypto addresses, but also TXIDs and links to TXIDs, so I'll have to see how  useful that is. But it's much easier to implement than searching for each separate crypto.

Glad to know that, I do hope it will be realized in the future. Got it!

[nutildah]

For now, this project is on halt. So much to do, so little time.... If I continue this, I may just search for any long string: anything above 30 characters that's posted by anyone. That should include most crypto addresses, but also TXIDs and links to TXIDs, so I'll have to see how  useful that is. But it's much easier to implement than searching for each separate crypto.

That's alright. I think it would still work so long as all the users sharing the same strings are identified. It is still easy to filter out the noise.

[nutildah]

Hi LoyceV,

I started using Arkham Intelligence recently and noticed it has an import list option. I was wondering did you ever make any more progress with this project? It would be great to get a list of addresses from you if you have one already... I thought I remember you creating such a thing at one point but can't find where it was. A .csv file of "name, address" would be ideal, I can just plop it in there. Thanks!

[LoyceV]

I was wondering did you ever make any more progress with this project? It would be great to get a list of addresses from you if you have one already... I thought I remember you creating such a thing at one point but can't find where it was. A .csv file of "name, address" would be ideal, I can just plop it in there. Thanks!

I'm still at this:

For now, this project is on halt. So much to do, so little time.... If I continue this, I may just search for any long string: anything above 30 characters that's posted by anyone. That should include most crypto addresses, but also TXIDs and links to TXIDs, so I'll have to see how  useful that is. But it's much easier to implement than searching for each separate crypto.

I remember I reduced the data to about 2 GB, after removing quotes and anything that couldn't be an address. The data dump is also about 8 months old by now. I could probably just do what I wrote above, and include all long strings. If that works, you can go from there. If it doesn't work, it would still be a good starting point to get only certain address formats.

For a CSV, I'm thinking of:

Code:

userID,msgID,addressstring,username

I'll see if I can find time for this the coming week.

[AakZaki]

-snip-

For a CSV, I'm thinking of:

Code:

userID,msgID,addressstring,username

If possible, can you change this format to something like this?

Code:

userID,msgID,username,addressstring

Given that the tool I use asks for a format like this, if it is inverted then there will be an input error.
Also so that I don't format it again.

[LoyceV]

If possible, can you change this format to something like this?

Code:

userID,msgID,username,addressstring

The reason I placed the username at the end, is because some names contain commas:

1462. b,ca
4729. (void, *)
9577. epi 1:10,000
12582. billionaire,82
27716. Richard at Wendel Services, LLC
35409. Ninja,,
75265. best power, power
75824. Brunt, FCA
89046. Tea, Towels, Vogons etc.
91805. Park,Hanseok
103677. batman, not crabman
103835. 3a6aukaJIeU,
125133. AIR,S4CS
130217. im a bitcoin user, friend
131120. ,
155205. man,myth,legend
176252. bankerscu,
186080. yi chun, chen
220675. ,./,./
234656. 3,14
248424. venus,wu
254473. Song, Min jung
308835. Skywalker Services, LLC
328860. Summer,69
331186. ,,,,,,2
331754. jessicafout,
333579. thyemos,
341443. san,san
357895. bitmarket,io
358163. In fact,
358195. to unload,
361172. Markus, CoinBau
362616. ghash,io
376714. up,debug
391174. gino,gino pasticcino
391875. NoChecks, CzechsWelcome
392279. nexusosx86,com
392607. bamba,
393753. PAMP SA, Switzerland

I'll just remove the commas from the names, you can use the userID to find the correct user.

[LoyceV]

Note: this data is based on a snapshot taken when I started this topic (8 months ago). If this is useful, I can create a more up to date version (but that will take several days).

A .csv file of "name, address" would be ideal, I can just plop it in there.

How's this as a first attempt?
tmp.loyce.club/alt_account_hunters_I_mean_nutildah/CSV_sorted.txt (378 MB):

Code:

userID,msgID,<all strings 25-90 characters>,<username with _ instead of ,>

3,1322,1auaDZCFYqaGx4FKS5WenNfurk2SkoDu4h,satoshi
3,15110,9fc44ea5f2109618073e2cfd887e2cc266eb31a9,satoshi
3,15110,fb7c66270281ed058c570627cf7baff0bdc16e5d,satoshi
3,249,0000000000692000000000000000000000000000000000000000000000000000,satoshi
3,249,0000000000800e00000000000000000000000000000000000000000000000000,satoshi
3,249,0000000000ba1800000000000000000000000000000000000000000000000000,satoshi
3,249,00000000010c5a00000000000000000000000000000000000000000000000000,satoshi
3,249,000000000168fd00000000000000000000000000000000000000000000000000,satoshi
3,249,0000000005a3f400000000000000000000000000000000000000000000000000,satoshi
3,249,000000000ae49300000000000000000000000000000000000000000000000000,satoshi
3,249,000000000d314200000000000000000000000000000000000000000000000000,satoshi
3,249,000000000eba6400000000000000000000000000000000000000000000000000,satoshi
3,249,000000000f675c00000000000000000000000000000000000000000000000000,satoshi
3,249,0000000013ec5300000000000000000000000000000000000000000000000000,satoshi
3,249,00000000159c2400000000000000000000000000000000000000000000000000,satoshi
3,249,0000000016546f00000000000000000000000000000000000000000000000000,satoshi
3,249,0000000020bca700000000000000000000000000000000000000000000000000,satoshi
3,249,000000002a111500000000000000000000000000000000000000000000000000,satoshi
3,249,0000000038137500000000000000000000000000000000000000000000000000,satoshi
3,249,00000000387f6f00000000000000000000000000000000000000000000000000,satoshi
3,249,0000000043b3e500000000000000000000000000000000000000000000000000,satoshi
3,249,0000000065465700000000000000000000000000000000000000000000000000,satoshi
3,249,000000008cc30000000000000000000000000000000000000000000000000000,satoshi
3,249,00000000be710000000000000000000000000000000000000000000000000000,satoshi
3,249,00000000c4280000000000000000000000000000000000000000000000000000,satoshi
3,249,00000000d86a0000000000000000000000000000000000000000000000000000,satoshi
3,249,00000000ffff0000000000000000000000000000000000000000000000000000,satoshi
3,346,0000000065465700000000000000000000000000000000000000000000000000,satoshi
3,510,0000000043b3e500000000000000000000000000000000000000000000000000,satoshi
3,9046,47d9998f7d15fe81234a5c89a542da9d0664df40,satoshi
3,9046,a36ea00cce27b4b083755df73a3d1e5e5729884e,satoshi
3,9046,bbb333b0ea57302740ad1bb9948520d00f884f9d,satoshi
3,9573,16645ec5fcdb35bc54bc7195309a1a81105242bb,satoshi
3,9573,4f35ad7711a38fe8c880c6c9beab430824c426d3,satoshi
3,9584,16645ec5fcdb35bc54bc7195309a1a81105242bb,satoshi
3,9584,4f35ad7711a38fe8c880c6c9beab430824c426d3,satoshi
3,9584,e3fda1ddb31b0d5c35156cacd80dee6ea6ae6423,satoshi
3,9590,16645ec5fcdb35bc54bc7195309a1a81105242bb,satoshi
3,9590,4f35ad7711a38fe8c880c6c9beab430824c426d3,satoshi
3,9590,b812ccff4881778b9090f7c0b0255bcba7b078ac,satoshi
3,9590,e3fda1ddb31b0d5c35156cacd80dee6ea6ae6423,satoshi
4,74268,17ujzChRb6VPQGyANVyktc1du,sirius
12,1708063,145yk7kqdEGAFJHopszqcE9eVAD3Svmsye,nanaimogold
12,1708063,1WCzxpkCAWW2KwCygdk8HZ2kCD1McVCTH,nanaimogold
.......
.......
.......
3223153,57828062,0xe2A4387De34179c54A19bc740cFfa6AE0621ED13,Manthar
3254697,58280639,0x6955b0713229bc10d551F324b7F7FF6882323D43,jaswinder888
3322452,57482806,0xfAcb2d5beE1Bd96c519316358Dd4927a21C20A82,At9090
3337239,60828062,0xae938163be6eebA5bA96fD93a0dE51abb610959d,sitiliayo
3337283,58280612,0x5A4c0715991dbe60BB656b50d685194e69F4bB9f,reronepan
3337283,58280693,0x5A4c0715991dbe60BB656b50d685194e69F4bB9f,reronepan
3342790,58150102,0x11d5e7d4735de4827c003c0fb09408e5d874bd408280614db72cd05ea97e58900x000xb361716,Wow001
3343584,57828063,0x949A8b7CD10986272731Ad991a69475a94C72Df5,ShelimHossain
3344962,58280631,0xdef6986BEcb3e68975Ef83424f7c2aceD0dfADB1,MKP90
3357990,58267851,30323846517303729827532682829550858906582806404201814808764013880589802844002,interiawp
3358553,58280656,0x01216306850fDB77d96769E327120065A5C74535,edwardafra
3376902,58280636,0x382BcB4580a0589e62cEba6D7F1560dF47ebD27d,kashif221993
3385104,58280680,0xA473D023572C4dF2dd231cE54a2C4eE7a19A015F,Mjmastan0047
3397147,58280608,0xC2452d6088D5CB761a1539BE71ebc1E5c0864Bcc,Suha61
3432420,61382806,pfbid02SYbrx7CmBQHtJoiA5k9KPRoenMZd2nuoTofJ85TA3bCKeEjNSBdGUYUF1ivEksJ4l,AliRazatitok
.......
.......
.......
99999999,53359694,BpUqojDz9bY1ftH6d1xUSYwWrv452ENWGfKHbARs2uhZ,Anonymous
99999999,53359748,0x2F486cD2711fed55ecc481a5a0aC62001EbFB16c,Anonymous
99999999,53359760,BzJ2fvjfcHaxuM5nvaYirLBZC5mEEPsqC21DXszJhrGZ,Anonymous
99999999,53359853,0x2f911c66a90265005dd8bc58a8a3b150b12b17ab,Anonymous
99999999,53359853,0x3d1889c6f1b44305f53367b3b6C2dA510D87927A,Anonymous
99999999,53749,1EEfxhgSejDJqsgU2nwuCd1YQg89SLZgxe,Anonymous
99999999,539757,1JsjFFBtG7t2x4kojZWobKnFJvMpF4tM3U,Anonymous
99999999,56027258,1CF9wLX6uiSJkrNeXurLoBWVfxzCwU23Vk,Anonymous
99999999,56600593,bc1qe5uxswrvmfenjlwxsajv8429vunsqn2sherlgz,Anonymous
99999999,576202,13UwZ4WJFB9ia5ywC3Kjt7Ruxbo7Cg4o2G,Anonymous
99999999,649612,0000000000000000000000000000000000000000000000000000000000000000,Anonymous
99999999,657248,1BGKe3xnx9QB4KpFPxpGys2hB35SE6FN6P,Anonymous
99999999,658391,1KCxyQxcurjvzdDF9hvAU5joFoR2BNzupV,Anonymous
99999999,67744,1899KKLG1b6ti1bs3U4kXfuFcRxCEVax1V,Anonymous
99999999,68398,1L1Kh8zYBFnKRYog6LeDjRcB4wZex8oWBv,Anonymous
99999999,68398,2F6b5f32f05caf12f70a46e092,Anonymous
99999999,68399,1L1Kh8zYBFnKRYog6LeDjRcB4wZex8oWBv,Anonymous
99999999,68399,2F62bd6ae4fd224612b83820e0,Anonymous
99999999,69665,18vSVcS8upH34qsFvshwjxHcxH2gNnusff,Anonymous
99999999,71276,16SFNzAdkTEmZwQyHYFF8G3fQchSpxaGwZ,Anonymous
99999999,72046,1L1Kh8zYBFnKRYog6LeDjRcB4wZex8oWBv,Anonymous
99999999,72057,1L1Kh8zYBFnKRYog6LeDjRcB4wZex8oWBv,Anonymous
99999999,72080,1L1Kh8zYBFnKRYog6LeDjRcB4wZex8oWBv,Anonymous
99999999,72697,1JxHpPZbHz6Tbmkq1fo4zogG6Qagsu7jkN,Anonymous
99999999,73285,18ibBDnrbRuaaswAeMMRxiAtixhSdnj7RD,Anonymous
99999999,85531,1PAkrfgEXxyJ3cwkg3KSJVSfdd9QEyahWh,Anonymous
99999999,86179,149dqpBxwVafaRpoGsy9LoqENenJxf3vcq,Anonymous
99999999,87325,1BZYH24gDB5KZfr3fh2LahkqbYrGppZTPS,Anonymous
99999999,90036,1NWc7N4FAs55hJ1xdTf3KWHZD89yn2PQKV,Anonymous
99999999,9790,17ujzChRb6VPQGyANVyktc1du2Hrjfwhsz,Anonymous

This can be used to grep only certain address formats. I found this regexp for Bitcoin addresses on stackoverflow:

Code:

egrep -aw --regexp="bc(0([ac-hj-np-z02-9]{39}|[ac-hj-np-z02-9]{25,90})|1[ac-hj-np-z02-9]{8,87})|[13][a-km-zA-HJ-NP-Z1-9]{25,35}"

Result: tmp.loyce.club/alt_account_hunters_I_mean_nutildah/CSV_sorted_Bitcoin.txt (30 MB):

Code:

3,1322,1auaDZCFYqaGx4FKS5WenNfurk2SkoDu4h,satoshi
12,1708063,145yk7kqdEGAFJHopszqcE9eVAD3Svmsye,nanaimogold
12,1708063,1WCzxpkCAWW2KwCygdk8HZ2kCD1McVCTH,nanaimogold
12,17990,1PrN2fHJctgkEDJYjD9RpvkoZuiJYo7VKs,nanaimogold
12,17991,1PrN2fHJctgkEDJYjD9RpvkoZuiJYo7VKs,nanaimogold
12,84624,15VjRaDX9zpbA8LVnbrCAFzrVzN7ixHNsC,nanaimogold
14,17139,19vhXH8her5oBsZGdnRy4AU7cJoJRMuk8u,The Madhatter
23,18113454,1Hf3eFvg8AZ7ztByYsKuWN7isYrdLvQ4vp,1 currency now
24,190870,12JuxerBKaZqj1Byyxfi1a5uSPiT3Ueso3,dwdollar
24,190870,17tvqFtxmqEk1dHkp1SPZ1xhqVJytgqfQf,dwdollar
24,190870,1Ez9Ey6D2ubgroSirbMHx8gGhqeZdjqg31,dwdollar
24,2244,13kndzuZ7XmWh3WboL6nFp7gpYj4poGuJt,dwdollar
24,851,1JyEmxiMso2RsFVfBcCa616npBvGgxiBX,dwdollar
26,1007,1Dnvwj3hAGSwFPMnkJZvi3KnaqksRPa74p,NewLibertyStandard
27,1027256,12NcNYb2oEh6ANo95AakEjPqQdgbcxh4m9,riX
27,1027256,12SSYCcvaHadm8Myxb3mUTzyv96VNhyzeZ,riX
27,1027256,12kM9BocNb5zSG7RMKp9wPxopK5NpayrMZ,riX
27,1027256,13YmfB6TeLzyCdnwsVZ5MdYVCLnfm5eNGF,riX
27,1027256,14no5MUE4ur2gyyEE3BHpHhV82gKm8NLbH,riX
27,1027256,14x3n2ntSAGN4gGvGoLhi6NbUuuoWwvfdL,riX
27,1027256,155gBnpiBQcpnP6coTX6V7znSK3G73uNjK,riX
27,1027256,15UJrPbxd6ULPJaxASUoWUp6xc473T7mww,riX
27,1027256,15nutdfqcS38hXdZoL7LNz5wBt8Aq4wCUT,riX
27,1027256,16Hz2xA4NmAp4CU3Mr9aJy8H9D5XqXupHG,riX
.......
.......
.......
459836,48920450,1ARQf44i6nkqx4kpxR9RnBDQjo6iAewpUt,LoyceV
459836,48920450,1ARz5VBamv9oCoS2qTDgJXDE46JzWkBaYm,LoyceV
459836,48920450,1ASeMZEu7afAkjBhGos1JrnZAPLQp34Jmk,LoyceV
459836,48920450,1ASociaLbBZzBUR8hSw8CryajncADsR1m6,LoyceV
459836,48920450,1AVUiW2XQCXavhkt6xmpvcgZrnrQ1qHfrY,LoyceV
459836,48920450,1AbUNPwLTHA4E3pjHgq2PeNci9SjBQnX7w,LoyceV
459836,48920450,1ActBTCi5XUMjqnyFxVWgSfE5xWicj8g3o,LoyceV
459836,48920450,1AgeFzeJZCK8u7zha6F7bAUcmibTn1C2zk,LoyceV
459836,48920450,1AiNSSNyGjd8aVp75sutK8K8pucxx5RbF6,LoyceV
459836,48920450,1AjQFEJdt2z5bERbLNAF7hvaUmrJwYPfDX,LoyceV
459836,48920450,1Anno16kisLSLhNvn7FEQysijJn3vd5PX9,LoyceV
459836,48920450,1Ap2XE7ZPp2mWekWxJMusnoNLmrVFn3Frc,LoyceV
459836,48920450,1ArcanaFbDJjZ1tM5J9kCh4CtRx8Y1JezX,LoyceV
459836,48920450,1At6EhbjN8BLCJz4pVAjsFcNzhzxQmXrwZ,LoyceV
459836,48920450,1AtherqxqVPDpmuwzXkTbBHw9mwqhmEzKt,LoyceV
459836,48920450,1AzKRzPijeq9FtUs5TBVKC5kHBMELX2XMJ,LoyceV
459836,48920450,1B6FS5pNiwb4dsE16tzwhszNxQ9i6UAWz3,LoyceV
459836,48920450,1BJ7X1s5qBT1bcmkYx6tBWPyuHhKL7i1dk,LoyceV
459836,48920450,1BKL2xzF4YNFJKaMFFNi7QGyRJS99oqRt8,LoyceV
459836,48920450,1BSwnKvoW759jWf5nLcMB5jVhT2S3TX7qs,LoyceV
459836,48920450,1BWsqHvp7Xfefefu4R5EqXtq2zYTRdzcrz,LoyceV
459836,48920450,1BaHQb1eYCDJPzRdU2JZHXpo7ia7z2ER4T,LoyceV
459836,48920450,1BaQPwJqFcFKnGt3kL2JuZDp477VvXQpRy,LoyceV
459836,48920450,1BcBpd8weYM6Ue2X4KpJw8CwRYnSf74rU1,LoyceV
459836,48920450,1Bitcoin8tfbtGAQNFxDRUVUfFgFWKoWi9,LoyceV
459836,48920450,1CD4aFktajzusw1NCzbRds9K1s9La8VwQ7,LoyceV
459836,48920450,1CGpKBjwqw4cqPvz2JFXTBWVngD2FPXGBU,LoyceV
459836,48920450,1CKPcA7vdZCDY5di3gWtu4mb6p2C7Fk95u,LoyceV
459836,48920450,1CT2gzD8cmcfibGtJtrkBv7qdELVUMT5b5,LoyceV
459836,48920450,1CgbNM86TR2HGZyH3UEPHVKPYDP8KrTV2E,LoyceV
459836,48920450,1Ck4ZNnpaCFnBGbbWhD4RFxo5iFTajjFyP,LoyceV
459836,48920450,1Cm9Q68Vs2y9nCPMp87xAgGsXtH1dMJ5ys,LoyceV
459836,48920450,1Coins3cxN32ie1Sg8MuhtTGMBPSxoqpYV,LoyceV
459836,48920450,1CrMfYN2BLFsSroFXhqTPUnnbZFCaDZ3Sv,LoyceV
459836,48920450,1CsCJDe8hr8G5KQbEFoESrTaB5Dpt6tViy,LoyceV
459836,48920450,1DBFDVLPBWhNjCgsMn4NYoQ13w9mWQ9JsH,LoyceV
.......
.......
.......
99999999,53356632,1ozTwVmqCzHUNqrPtXNMPNPcefmjFo3Dw,Anonymous
99999999,53749,1EEfxhgSejDJqsgU2nwuCd1YQg89SLZgxe,Anonymous
99999999,539757,1JsjFFBtG7t2x4kojZWobKnFJvMpF4tM3U,Anonymous
99999999,56027258,1CF9wLX6uiSJkrNeXurLoBWVfxzCwU23Vk,Anonymous
99999999,56600593,bc1qe5uxswrvmfenjlwxsajv8429vunsqn2sherlgz,Anonymous
99999999,576202,13UwZ4WJFB9ia5ywC3Kjt7Ruxbo7Cg4o2G,Anonymous
99999999,657248,1BGKe3xnx9QB4KpFPxpGys2hB35SE6FN6P,Anonymous
99999999,658391,1KCxyQxcurjvzdDF9hvAU5joFoR2BNzupV,Anonymous
99999999,67744,1899KKLG1b6ti1bs3U4kXfuFcRxCEVax1V,Anonymous
99999999,68398,1L1Kh8zYBFnKRYog6LeDjRcB4wZex8oWBv,Anonymous
99999999,68399,1L1Kh8zYBFnKRYog6LeDjRcB4wZex8oWBv,Anonymous
99999999,69665,18vSVcS8upH34qsFvshwjxHcxH2gNnusff,Anonymous
99999999,71276,16SFNzAdkTEmZwQyHYFF8G3fQchSpxaGwZ,Anonymous
99999999,72046,1L1Kh8zYBFnKRYog6LeDjRcB4wZex8oWBv,Anonymous
99999999,72057,1L1Kh8zYBFnKRYog6LeDjRcB4wZex8oWBv,Anonymous
99999999,72080,1L1Kh8zYBFnKRYog6LeDjRcB4wZex8oWBv,Anonymous
99999999,72697,1JxHpPZbHz6Tbmkq1fo4zogG6Qagsu7jkN,Anonymous
99999999,73285,18ibBDnrbRuaaswAeMMRxiAtixhSdnj7RD,Anonymous
99999999,85531,1PAkrfgEXxyJ3cwkg3KSJVSfdd9QEyahWh,Anonymous
99999999,86179,149dqpBxwVafaRpoGsy9LoqENenJxf3vcq,Anonymous
99999999,87325,1BZYH24gDB5KZfr3fh2LahkqbYrGppZTPS,Anonymous
99999999,90036,1NWc7N4FAs55hJ1xdTf3KWHZD89yn2PQKV,Anonymous
99999999,9790,17ujzChRb6VPQGyANVyktc1du2Hrjfwhsz,Anonymous

It's probably best to ignore userID 99999999, which I made up as there was none for certain posts back in the days.

[nutildah]

Thanks!

tmp.loyce.club/alt_account_hunters_I_mean_nutildah/CSV_sorted_Bitcoin.txt (30 MB):

I will try this one first.