[Forensics] KAG "Exchange physical for digital" (EPD)

ZürichGnome · Apr 3, 2023

Code:

linux>  cat All-Together | awk 'NR%9 {printf("%s\t", $0); next} {print $0}' | nl -ba | grep "\.00000" | cut -c8-14 > fetch
linux> nl fetch
     1    30.40  
     2    39.60  
     3    49.50  
     4    49.50  
     5    108.90 
     6    108.90 
     7    29.70  
linux> while IFS= read x
do
  grep $x Not-Round-kg | head -1
  sleep 2
done < fetch
977.32    30.40
1273.17   39.60
1591.46   49.50
1591.46   49.50
3501.21   108.90
3501.21   108.90
954.88    29.70

30.40 is kg
977.32 is the original ozt number

ZürichGnome · Apr 3, 2023

Using line numbering from 2 posts up

Line 11
Net
30.40 kg
came in as

Code:

linux> grep 30.40 Not-Round-kg
977.32    30.40

Either
800 Fine 38 kg
or
950 Fine 32 kg
or else
1 Kozt bar at
977 ozt
which is probably the most likely ;-)

I may be guilty of slight overkill here

ZürichGnome · Apr 3, 2023

Going down the list:

39.60 net kg ?
likely
900 Fine
gross weight
44 kg

next:
1591.46 49.50
55 kg gross 900 Fine

next:
3501.21 108.90
121 kg 900 Fine
or
109 kg and dust 999 Fine

954.88 29.70
1 Kozt bar most likely

Code:

linux> set | grep ^AG
AG_GDB_lower_bound=900
AG_GDB_upper_bound=1050

or
33 kg gross 900 Fine

What of the remainder?
Next post:

ZürichGnome · Apr 3, 2023

Code:

cat All-Together | awk 'NR%9 {printf("%s\t", $0); next} {print $0}' | nl -ba | grep -v "\.00000"

linux> cat All-Together | awk 'NR%9 {printf("%s\t", $0); next} {print $0}' | nl -ba | grep -v "\.00000"
     1    3.43          4.287500    3.811111    3.744541    3.708108    3.621964    3.610526    3.580376    3.433433
     2    122.37        152.962500    135.966667    133.591703    132.291892    129.218585    128.810526    127.734864    122.492492
     3    31.10         38.875000    34.555556    33.951965    33.621622    32.840549    32.736842    32.463466    31.131131
     4    30.66         38.325000    34.066667    33.471616    33.145946    32.375924    32.273684    32.004175    30.690691
     5    31.53         39.412500    35.033333    34.421397    34.086486    33.294615    33.189474    32.912317    31.561562
     6    251.52        314.400000    279.466667    274.585153    271.913514    265.596621    264.757895    262.546973    251.771772
     7    8.07          10.087500    8.966667    8.810044    8.724324    8.521647    8.494737    8.423800    8.078078
     8    100.64        125.800000    111.822222    109.868996    108.800000    106.272439    105.936842    105.052192    100.740741
     9    124.84        156.050000    138.711111    136.288210    134.962162    131.826822    131.410526    130.313152    124.964965
    10    29.83         37.287500    33.144444    32.565502    32.248649    31.499472    31.400000    31.137787    29.859860
    12    187.35        234.187500    208.166667    204.530568    202.540541    197.835269    197.210526    195.563674    187.537538
    14    47.52         59.400000    52.800000    51.877729    51.372973    50.179514    50.021053    49.603340    47.567568
    15    107.88        134.850000    119.866667    117.772926    116.627027    113.917635    113.557895    112.609603    107.987988
    16    74.25         92.812500    82.500000    81.058952    80.270270    78.405491    78.157895    77.505219    74.324324
    17    74.25         92.812500    82.500000    81.058952    80.270270    78.405491    78.157895    77.505219    74.324324
    20    32.59         40.737500    36.211111    35.578603    35.232432    34.413939    34.305263    34.018789    32.622623
    24    14.85         18.562500    16.500000    16.211790    16.054054    15.681098    15.631579    15.501044    14.864865

Mysteries abound...
Write out the kg column to flat file fetch2

Code:

linux> cat All-Together | awk 'NR%9 {printf("%s\t", $0); next} {print $0}' | nl -ba | grep -v "\.00000" | cut -c8-14 > fetch2

grep -v
Must not forget

Code:

while IFS= read x
do
  grep $x Not-Round-kg
  sleep 2
done < fetch2 > Remaining-Mysteries

linux> while IFS= read x
do
  grep $x Not-Round-kg
  sleep 2
done < fetch2 > Remaining-Mysteries

That was to grab back the original ozt number

Code:

linux> nl Remaining-Mysteries 
     1    110.30    3.43
     2    3934.40   122.37
     3    999.90    31.10
     4    985.80    30.66
     5    1013.70   31.53
     6    8086.62   251.52
     7    259.53    8.07
     8    3235.57   100.64
     9    4013.60   124.84
    10    959.06    29.83
    11    6023.54   187.35
    12    1527.80   47.52
    13    3468.40   107.88
    14    2387.19   74.25
    15    2387.19   74.25
    16    2387.19   74.25
    17    2387.19   74.25
    18    1047.80   32.59
    19    477.44    14.85

Line 3 is easy
1 Four Nines fine 1Kozt bar netted out by operator. Or the actual weight of the bar.

Lines 2,4-6, 8-11, 18
multiples of possible 1 Kozt GDBs

Code:

     2    3934.40   122.37
     3    999.90    31.10
     4    985.80    30.66
     5    1013.70   31.53
     6    8086.62   251.52
     8    3235.57   100.64
     9    4013.60   124.84
    10    959.06    29.83
    11    6023.54   187.35
    18    1047.80   32.59

The rest. I don't know.

Code:

     1    110.30    3.43
     7    259.53    8.07
    12    1527.80   47.52
    13    3468.40   107.88
    14    2387.19   74.25
    15    2387.19   74.25
    16    2387.19   74.25
    17    2387.19   74.25
    19    477.44    14.85

9 mysteries
6 in reality if we exclude the repeating occurrences

Code:

          ozt      kg

     1    110.30    3.43
     7    259.53    8.07
    12    1527.80   47.52
    13    3468.40   107.88
    14    2387.19   74.25
    19    477.44    14.85

and then clickkkkkkkkkkkkkkkkkkkkkkkkkkkk
Next post:

ZürichGnome · Apr 4, 2023

Code:

    19    477.44    14.85

We've seen this fellow before...

Code:

2022-12-28T04:29:57Z          create_account    EPD KAG 135               477.44

an EPD transaction into segregated
From previous work (above; same thread):

Code:

2022-10-21T05:50:13Z          create_account    EPD KAG 120              1591.46
2022-10-21T05:53:12Z          create_account    EPD KAG 121              1591.46
2022-10-21T05:55:46Z          create_account    EPD 1% fee                 16.07
2022-10-21T05:57:56Z          create_account    EPD 1% fee                 16.07
...
2022-12-05T04:31:58Z          create_account    EPD KAG 126              3501.21
2022-12-05T04:35:08Z          create_account    EPD KAG 127              3501.21
2022-12-05T04:38:05Z          create_account    Segregated EPD 1% fee       35.37
2022-12-05T04:40:19Z          create_account    Segregated EPD 1% fee       35.37
...
2022-12-28T04:28:02Z          create_account    EPD KAG 134               954.88
2022-12-28T04:29:57Z          create_account    EPD KAG 135               477.44
2022-12-28T04:32:06Z          create_account    Segregated EPD 1% fee        9.65
2022-12-28T04:33:53Z          create_account    Segregated EPD 1% fee        4.82

As seen previously:

11 Kozt AG + are part of a special category for one or more customers using Segregated Storage (at 1% cost of storage per year?)

Probably same client
All these EPD transactions appear to be 900 Fine silver:

1591.46 ozt
49.50 kg net
55.00 kg gross 900 Fine

3501.21 ozt
108.90 kg net
121.00 kg gross 900 Fine

954.88 ozt
29.70 kg net
33.00 kg gross 900 Fine

By inference (big word for a wild guess),
477.44 ozt
14.85 kg net
16.50 kg gross 900 Fine

Chuck that into file t

Code:

linux> grep gross t | cut -d " " -f1
55.00
121.00
33.00
16.50
linux> grep gross t | cut -d " " -f1 | paste -s -d+ | bc -l
225.50

225.50 kg gross 900 Fine Total
for that batch of segregated units

Back to our remaining concern:

ZürichGnome · Apr 4, 2023

6-1 = 5 mysteries remaining

Code:

        ozt      kg

     1    110.30    3.43
     7    259.53    8.07
    12    1527.80   47.52
    13    3468.40   107.88
    14    2387.19   74.25

Code:

linux> cat fetch4 | sed '/477/d'
110.30 
259.53 
1527.80
2387.19
3468.40
linux> cat fetch4 | sed '/477/d' > fetch5

Hit the original flat file extract yet again for these 5 records:

Code:

linux>  while IFS= read x; do   sed '1d' $KAG_CI_extract | awk -F, -v sniff=$x '($7 <= sniff + 0.001) && ($7 >= sniff - 0.001) && ($3 != "account_merge" ) {print $0}';   sleep 2; done < fetch5
2020-09-23T06:59:38Z,d38ed7d03ff07dfbd23d314dea650a75517a86fc6e4880ef0acd73c8736fc0bc,create_account,EPD KAG 032,GCGTMT2X6NUV6ABEOAOSDI2YQ7FXQOQYKYA7KVZQ5ID67GQU3C6AIUGU,GDTPWRRISLY57HIA2OS37LZPAQRAAJLVAQI57OF4XQLTX7S443HQ5R27,110.3,0.49636,kag,TRUE
2021-10-08T07:20:19Z,7d29b898bd7dbbd9a88bd48850636db21d9834b140af673ac83d1b58b31f8b13,create_account,EPD KAG 072,GCGTMT2X6NUV6ABEOAOSDI2YQ7FXQOQYKYA7KVZQ5ID67GQU3C6AIUGU,GCUZAALERDNP7VF3WPHNVLSOHSCB32BKOO36RBFQCMJYNXOGFMMTZVJF,259.52949,1.1678928,kag,TRUE
2022-09-13T05:57:43Z,4e386932a360e7edf3ec3e8220b894cca2e12f985e82018b11634bceae7a2066,create_account,EPD KAG 118,GCGTMT2X6NUV6ABEOAOSDI2YQ7FXQOQYKYA7KVZQ5ID67GQU3C6AIUGU,GA6XX42MUJWAEAXX5O37ZWPG43SJFQ4JIUTIDBYAJYMRIYDCTRAJK6PS,2387.1895,10.7423628,kag,TRUE
2022-09-13T05:55:08Z,6014bf469c7436ccf3dde41d8feaa24ff84edbc28de213fc6aaf5cfa3e264db6,create_account,EPD KAG 117,GCGTMT2X6NUV6ABEOAOSDI2YQ7FXQOQYKYA7KVZQ5ID67GQU3C6AIUGU,GCQNJPPME2SWRJMAJC6BEYSC674QPKDKMSW7IHL56ONBIM64MTXZNBXN,2387.1895,10.7423628,kag,TRUE
2022-09-01T06:40:09Z,e0de370dbc0c093cb8a5099b7ccbc9827f431e6cd8768dfce2111dffad016485,create_account,EPD KAG 115,GCGTMT2X6NUV6ABEOAOSDI2YQ7FXQOQYKYA7KVZQ5ID67GQU3C6AIUGU,GCDNNFV6OCK6673JPFU2W7M2F3663JKIORQXRRZQIQ5IRHRWQJWW7EWV,3468.4,15.60781,kag,TRUE

Extract the transaction hash field for each.
Write to flat file:

Code:

while IFS= read x; do   sed '1d' $KAG_CI_extract | awk -F, -v sniff=$x '($7 <= sniff + 0.001) && ($7 >= sniff - 0.001) && ($3 != "account_merge" ) {print $2}';   sleep 2; done < fetch5 > transactions

Third one missing below.

Code:

4e386932a360e7edf3ec3e8220b894cca2e12f985e82018b11634bceae7a2066

I don't know why.

Code:

https://explorer.kinesis.money/transaction/KAG/d38ed7d03ff07dfbd23d314dea650a75517a86fc6e4880ef0acd73c8736fc0bc
https://explorer.kinesis.money/transaction/KAG/7d29b898bd7dbbd9a88bd48850636db21d9834b140af673ac83d1b58b31f8b13
https://explorer.kinesis.money/404
https://explorer.kinesis.money/transaction/KAG/6014bf469c7436ccf3dde41d8feaa24ff84edbc28de213fc6aaf5cfa3e264db6
https://explorer.kinesis.money/transaction/KAG/e0de370dbc0c093cb8a5099b7ccbc9827f431e6cd8768dfce2111dffad016485

A list of the System Accounts for your convenience

Code:

linux> set | grep KAG_[E,G,H,I,R] | sort -t= -k2
KAG_GAPSAccount=GAPS3KZ4YVEL4UYFAGTE6L6H6GRZ3KYBWGY2UTGTAJBXGUJLBCYQIXXA
KAG_RootAccount=GAUCIFE37F4KQ5F6QPNSZ75QKRQTNRCF32FZNUXMCXUFSKRMWGF76LTI
KAG_InflationAccount=GBBVUAMR3CYNQKMNHVWCMUQVE3XQIL3WM5GSP5D6SCECKIZNNBT6FT7I
KAG_HotWalletAccount=GBTYCT2VVWURNU23ZSR3IPSXU6BRWT3ELIOQJAJOKGIHCLLE6YDX4A7E
KAG_EmissionAccount=GCGTMT2X6NUV6ABEOAOSDI2YQ7FXQOQYKYA7KVZQ5ID67GQU3C6AIUGU

Looking at the destination accounts (Field6 = $6):

Code:

linux> while IFS= read x; do   sed '1d' $KAG_CI_extract | awk -F, -v sniff=$x '($7 <= sniff + 0.001) && ($7 >= sniff - 0.001) && ($3 != "account_merge" ) {print $6}';   sleep 2; done < fetch5 | sort > t1

and comparing again with the System Accounts:

Code:

linux> set | grep KAG_[E,G,H,I,R] | sort -t= -k2 | cut -d= -f2 | sort > t2

Code:

linux> comm t1 t2
GA6XX42MUJWAEAXX5O37ZWPG43SJFQ4JIUTIDBYAJYMRIYDCTRAJK6PS
    GAPS3KZ4YVEL4UYFAGTE6L6H6GRZ3KYBWGY2UTGTAJBXGUJLBCYQIXXA
    GAUCIFE37F4KQ5F6QPNSZ75QKRQTNRCF32FZNUXMCXUFSKRMWGF76LTI
    GBBVUAMR3CYNQKMNHVWCMUQVE3XQIL3WM5GSP5D6SCECKIZNNBT6FT7I
    GBTYCT2VVWURNU23ZSR3IPSXU6BRWT3ELIOQJAJOKGIHCLLE6YDX4A7E
GCDNNFV6OCK6673JPFU2W7M2F3663JKIORQXRRZQIQ5IRHRWQJWW7EWV
    GCGTMT2X6NUV6ABEOAOSDI2YQ7FXQOQYKYA7KVZQ5ID67GQU3C6AIUGU
GCQNJPPME2SWRJMAJC6BEYSC674QPKDKMSW7IHL56ONBIM64MTXZNBXN
GCUZAALERDNP7VF3WPHNVLSOHSCB32BKOO36RBFQCMJYNXOGFMMTZVJF
GDTPWRRISLY57HIA2OS37LZPAQRAAJLVAQI57OF4XQLTX7S443HQ5R27

Intersection is the empty set.
ie
no intersection
ie
not System Accounts
Perhaps I have not yet correctly identified System Accounts?

End of Thread.

Lozion · Apr 4, 2023

Code 7 looks like my First Majestic EPD..

[Forensics] KAG "Exchange physical for digital" (EPD)

ZürichGnome

Active member

ZürichGnome

Active member

ZürichGnome

Active member

ZürichGnome

Active member

ZürichGnome

Active member

ZürichGnome

Active member

Lozion

Well-known member

Translate