[Forensics] KAU "Exchange physical for digital" (EPD) [100 g Au --> 100 KAU]

Doing the same work for KAU as I did for KAG previously

We will find:

1 in 6 KAU from EPD
thus
5 in 6 presumably from Minting

About 1 EPD event every 20 days working from a CSV extract file made by CI around JAN 2023.
I'll fill in the details in the replies.

 

[ZürichGnome]

Derek's Watcher Node -though now up again- has some bizarre seemingly encrypted fields in the records so I'll go straight to CI's as I did previously for the KAG work,.

wget https://github.com/cryptoinformer0/kinesis-data/raw/main/kau-raw.csv

linux> wget https://github.com/cryptoinformer0/kinesis-data/raw/main/kau-raw.csv
--2023-04-17 00:38:44--  https://github.com/cryptoinformer0/kinesis-data/raw/main/kau-raw.csv
Resolving github.com (github.com)... 140.82.121.4
Connecting to github.com (github.com)|140.82.121.4|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://raw.githubusercontent.com/cryptoinformer0/kinesis-data/main/kau-raw.csv [following]
--2023-04-17 00:38:45--  https://raw.githubusercontent.com/cryptoinformer0/kinesis-data/main/kau-raw.csv
Resolving raw.githubusercontent.com (raw.githubusercontent.com)... 185.199.109.133, 185.199.110.133, 185.199.111.133, ...
Connecting to raw.githubusercontent.com (raw.githubusercontent.com)|185.199.109.133|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 19786298 (19M) [text/plain]
Saving to: ‘kau-raw.csv.1’

kau-raw.csv.1                         100%[=========================================================================>]  18.87M  43.3MB/s    in 0.4s    

2023-04-17 00:38:47 (43.3 MB/s) - ‘kau-raw.csv.1’ saved [19786298/19786298]

set linux bash symbol to point to the right place (TAB line complete always useful here)

KAU_CI_extract=../CI-dat/kau-raw.csv 

linux> echo $KAU_CI_extract
../CI-dat/kau-raw.csv
linux> ls -ng $KAU_CI_extract
-rw-rw-r-- 1 1000 19786298 Apr 17 00:38 ../CI-dat/kau-raw.csv
linux> wc -l $KAU_CI_extract
80904 ../CI-dat/kau-raw.csv

Just under 20M in size
Over 80K records
thus
80K transactions

All good. We're all set to play.

 

[ZürichGnome]

Pick out first date and last date from file.

linux> sed '1d' $KAU_CI_extract | awk -F, '(($3 == "account_merge") || ($3 == "create_account") || ($3 == "payment") ) {printf "%s\t%20s\t%-20s\t%8.2f\n", $1, $3, $4, $7}' | sort -k1 | head -1 | cut -f1
2019-03-12T01:28:08Z

linux> sed '1d' $KAU_CI_extract | awk -F, '(($3 == "account_merge") || ($3 == "create_account") || ($3 == "payment") ) {printf "%s\t%20s\t%-20s\t%8.2f\n", $1, $3, $4, $7}' | sort -k1 | tail -1 | cut -f1
2023-01-05T18:37:03Z

sed '1d' $KAU_CI_extract | awk -F, '(toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/) {printf "%s\t%20s\t%-20s\t%8.2f\n", $1, $3, $4, $7}' | sort -k1 | head -1 | cut -f1
sed '1d' $KAU_CI_extract | awk -F, '(toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/) {printf "%s\t%20s\t%-20s\t%8.2f\n", $1, $3, $4, $7}' | sort -k1 | tail -1 | cut -f1

linux> sed '1d' $KAU_CI_extract | awk -F, '(toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/) {printf "%s\t%20s\t%-20s\t%8.2f\n", $1, $3, $4, $7}' | sort -k1 | head -1 | cut -f1
2019-04-01T12:13:53Z

linux> sed '1d' $KAU_CI_extract | awk -F, '(toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/) {printf "%s\t%20s\t%-20s\t%8.2f\n", $1, $3, $4, $7}' | sort -k1 | tail -1 | cut -f1
2022-08-16T01:53:33Z

Thus for this extract file (probably made on 5 JAN 2023), the latest EPD event was in AUG 2022
Onwards:

sed '1d' $KAU_CI_extract | awk -F, '(toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/) {printf "%s\t%20s\t%-20s\t%8.2f\n", $1, $3, $4, $7}' | sort -k1 | wc -l
65

linux> echo $((($(date '+%s' -d "2022-08-16T01:53:33Z") - $(date '+%s' -d "2019-04-01T12:13:53Z")) / (24 * 60 * 60)))
1232

linux> units -t "1232 days" year
3.3731042

bc <<< "scale=2; 1232 / 65 "
linux> bc <<< "scale=2; 1232 / 65 "
18.95

65 EPD events
over 3 and a bit years
That's an average of 1 EPD event every nearly 19 days.

 

[ZürichGnome]

Totals?

sed '1d' $KAU_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) {sum_7 += $7} END {printf "%.2f\n", sum_7}'

linux> sed '1d' $KAU_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) {sum_7 += $7} END {printf "%.2f\n", sum_7}'
193388.72

193+ kg Au
Just to show my work:

units -t "193388.72 g" kg
linux> units -t "193388.72 g" kg
193.38872

193
kg

coin in circulation at present? (yeah, a different date but we're doing rough work for now. Practising technique. This can be cleaned up later once we all figure out how to run our own watcher nodes with extract and/ or scrape facility)

1,228,263.1598 KAU
1228263.1598

That's from a manual screen-scrape from first page from the Explorer
Top left

Reminder
1 KAU = 1 g Au

linux> units -t "1228263.1598 g" kg
1228.2632
kg

Thus

bc <<< "scale=6; 193.38872 / 1228.2632"
linux> bc <<< "scale=6; 193.38872 / 1228.2632"
.157448
linux> bc <<< "scale=6; (193.38872 / 1228.2632)^(-1)"
6.351303

1 in 6 KAU from EPD
Thus
5 in 6 presumably from Minting

 

[ZürichGnome]

Focus temporarily on EPDs over 5 kg

Just because they're larger than the rest.

Current price of 5 kg Au?

linux> units -t "XAU (g/ozt) 5000" USD
328022.81
328K USD fiat

linux> units -t XAU USD
2040.53

linux> units -t XAU
goldounce = goldprice troyounce = 2040.53 US$
linux> units -t ozt
troyounce = 1|12 troypound = 0.031103477 kg

units, a very versatile tool

 

[ZürichGnome]

'ere we go

sed '1d' $KAU_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) && ($7 > 5000) {printf "%s\t%50s\t%20s\t%-20s\t%8.2f\n", $1, $2, $3, $4, $7}' | sort -k1 

linux> sed '1d' $KAU_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) && ($7 > 5000) {printf "%s\t%50s\t%20s\t%-20s\t%8.2f\n", $1, $2, $3, $4, $7}' | sort -k1 
2020-06-10T09:41:08Z    1e9f210c2599d64959d6f13aa4bb29dd0710232589141f7559b4c76130b692a7                 payment    EPD 016                 10000.00
2020-10-20T06:06:35Z    250efa202e51a2e3dd8341c91ebb1a3952474b9bf754f393d559bf26cc88f7de          create_account    EPD 017                 15000.00
2020-11-03T00:02:47Z    e1bdb034bc2a1a055e21b4284989dc7b6da626724f456999614124cf374b9c1e          create_account    EPD 018                 83000.00
2021-06-21T03:05:41Z    30fdc1bce352f755210cd60b28106479921a441da99708ca1d1c37e17ba458e6          create_account    EPD 037                 13000.00
2022-01-25T02:33:42Z    795f2473c698f82920d26997ee31b72f5325414e0d9186ced52e099c168e4ead          create_account    EPD 056                 22246.50

5 EPD transactions over 5kg
10, 15, 83, 13, 22 kg
Let's have a closer look.
Next:

 

[ZürichGnome]

Oh.
I forgot to warn everybody while doing the KAG work.
Please do not be too generous advertising yourself if you recognise your own EPD transaction here.
It's all too easy to dox yourself inadvertently

 

[ZürichGnome]

write tx hashes (transactions = Field2) to list

sed '1d' $KAU_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) && ($7 > 5000) {printf "%s\t%50s\t%20s\t%-20s\t%8.2f\n", $1, $2, $3, $4, $7}' | sort -k1 | cut -f2 > list

Have a look in Explorer:

while IFS= read x
do
  xdg-open https://explorer.kinesis.money/transaction/KAU/$x
  sleep $[($RANDOM % 9) + 10]s
done < list

Kinesis Chain Explorer

explorer.kinesis.money

Kinesis Chain Explorer

explorer.kinesis.money

Kinesis Chain Explorer

explorer.kinesis.money

Kinesis Chain Explorer

explorer.kinesis.money

Kinesis Chain Explorer

explorer.kinesis.money

linux> set | grep KAU | sort -t= -k2
KAU_CI_extract=../CI-dat/kau-raw.csv
KAU_GAPSAccount=GAPS3KZ4YVEL4UYFAGTE6L6H6GRZ3KYBWGY2UTGTAJBXGUJLBCYQIXXA
KAU_HotWalletAccount=GBUBOKEFUNF4ZZQA7QJCGYF54U4N2T5VV2QAN7RWQCVS75OOI5KSVCZS
KAU_InflationAccount=GCO75U2EVO3HKGYO2PUO2ZO7CEL52JPQL5WYUHHKPEORQSASSKT4MA3B
KAU_EmissionAccount=GDIENNQ3BXCTB74ZYCQAGXCY7KTGFBZGHRMUVF3ZLIW6SMAZIGX2JCCS
KAU_RootAccount=GDTYNME5HX3FCFDS4D3R3LTVH3DFLSB5HWVTV3VVL4PBGQ6SCKC7J3PD

bash symbols found then set from previous work...
From which we quickly see Emission account (Vertex E) is writing new units to each user account who triggered the EPD ...

 

[ZürichGnome]

or hit the flat file directly:

while IFS= read x
do
  grep $x $KAU_CI_extract
  sleep 5
done < list

2020-06-10T09:41:08Z,1e9f210c2599d64959d6f13aa4bb29dd0710232589141f7559b4c76130b692a7,payment,EPD 016,GDIENNQ3BXCTB74ZYCQAGXCY7KTGFBZGHRMUVF3ZLIW6SMAZIGX2JCCS,GA76HMVLR5URAIHBFBYPUTNC2UI3GQ6WQ432CAO2KJUHPG2PC4QWCCT5,10000,45.00001,kau,TRUE
2020-10-20T06:06:35Z,250efa202e51a2e3dd8341c91ebb1a3952474b9bf754f393d559bf26cc88f7de,create_account,EPD 017,GDIENNQ3BXCTB74ZYCQAGXCY7KTGFBZGHRMUVF3ZLIW6SMAZIGX2JCCS,GA3KQ367GJ7A7GFN6C2DHGPWRBSKITPJQC5GOUX5Q3TXQJZDH42ECUII,15000,67.50001,kau,TRUE
2020-11-03T00:02:47Z,e1bdb034bc2a1a055e21b4284989dc7b6da626724f456999614124cf374b9c1e,create_account,EPD 018,GDIENNQ3BXCTB74ZYCQAGXCY7KTGFBZGHRMUVF3ZLIW6SMAZIGX2JCCS,GDJNK7YUXVFDUI4UKE6WEHJV4WMJ3MQV7T7TLP4JCZOLCL6T7BON2A6P,83000,373.50001,kau,TRUE
2021-06-21T03:05:41Z,30fdc1bce352f755210cd60b28106479921a441da99708ca1d1c37e17ba458e6,create_account,EPD 037,GDIENNQ3BXCTB74ZYCQAGXCY7KTGFBZGHRMUVF3ZLIW6SMAZIGX2JCCS,GDWE732HT57VMFRPY7VJKK3VJNS2IXEZZ6HTAQ5F2ZR7YCVK5AW6ABN3,13000,58.50001,kau,TRUE
2022-01-25T02:33:42Z,795f2473c698f82920d26997ee31b72f5325414e0d9186ced52e099c168e4ead,create_account,EPD 056,GDIENNQ3BXCTB74ZYCQAGXCY7KTGFBZGHRMUVF3ZLIW6SMAZIGX2JCCS,GCH7PFW7FSSUAAFYXYKWEA2ODRDFCMTSKQPNA2O5XDYFPLKYERTYWNPA,22246.5045,100.1092803,kau,TRUE

GDI account is Emission or Vertex E e a I have been calling it in previous work

 

[ZürichGnome]

Check the 5 transactions above 5 kg are not from system accounts.
Why?
Dunno. I'm just an apprentice auditor ok?

while IFS= read x
do
  grep $x $KAU_CI_extract
  sleep 5
done < list > output

cut -d, -f6 output
GA76HMVLR5URAIHBFBYPUTNC2UI3GQ6WQ432CAO2KJUHPG2PC4QWCCT5
GA3KQ367GJ7A7GFN6C2DHGPWRBSKITPJQC5GOUX5Q3TXQJZDH42ECUII
GDJNK7YUXVFDUI4UKE6WEHJV4WMJ3MQV7T7TLP4JCZOLCL6T7BON2A6P
GDWE732HT57VMFRPY7VJKK3VJNS2IXEZZ6HTAQ5F2ZR7YCVK5AW6ABN3
GCH7PFW7FSSUAAFYXYKWEA2ODRDFCMTSKQPNA2O5XDYFPLKYERTYWNPA

linux> cut -d, -f6 output | sort > t2

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

Easy peasy.
Now got them sorted in 2 separate files:

comm t1 t2
linux> comm t1 t2
    GA3KQ367GJ7A7GFN6C2DHGPWRBSKITPJQC5GOUX5Q3TXQJZDH42ECUII
    GA76HMVLR5URAIHBFBYPUTNC2UI3GQ6WQ432CAO2KJUHPG2PC4QWCCT5
GAPS3KZ4YVEL4UYFAGTE6L6H6GRZ3KYBWGY2UTGTAJBXGUJLBCYQIXXA
GBUBOKEFUNF4ZZQA7QJCGYF54U4N2T5VV2QAN7RWQCVS75OOI5KSVCZS
    GCH7PFW7FSSUAAFYXYKWEA2ODRDFCMTSKQPNA2O5XDYFPLKYERTYWNPA
GCO75U2EVO3HKGYO2PUO2ZO7CEL52JPQL5WYUHHKPEORQSASSKT4MA3B
GDIENNQ3BXCTB74ZYCQAGXCY7KTGFBZGHRMUVF3ZLIW6SMAZIGX2JCCS
    GDJNK7YUXVFDUI4UKE6WEHJV4WMJ3MQV7T7TLP4JCZOLCL6T7BON2A6P
GDTYNME5HX3FCFDS4D3R3LTVH3DFLSB5HWVTV3VVL4PBGQ6SCKC7J3PD
    GDWE732HT57VMFRPY7VJKK3VJNS2IXEZZ6HTAQ5F2ZR7YCVK5AW6ABN3

comm is common

SQL people would call that an inner join.
I only learnt that in the past week.

Normal people would do that in MS-Access in a GUI.
20 years ago.

Now I have no clue.
I just like using tech from 50 years ago.

Tiny detail:
it's free and available to all

that comm output actually shows:

Empty set
ie
Set t1 - Set t2 = 0
A - B = 0
[EDIT]
(Set t1) AND (Set t2) = 0
A AND B = 0
In SQL,
INTERSECT
In C, awk, linux in general: "&&"
[/End EDIT]

that's how a mathematician might see it

That's to make sure those 5 accounts are not system accounts. Or at least those identified as such from work up until now.

 

[ZürichGnome]

A closer look at these 5 accounts using the Explorer:

while IFS= read x
do
  xdg-open https://explorer.kinesis.money/account/$x
  sleep $[($RANDOM % 9) + 10]s
done < t2

Kinesis Chain Explorer

explorer.kinesis.money

Kinesis Chain Explorer

explorer.kinesis.money

Kinesis Chain Explorer

explorer.kinesis.money

Kinesis Chain Explorer

explorer.kinesis.money

Kinesis Chain Explorer

explorer.kinesis.money

GDJNK7YUXVFDUI4UKE6WEHJV4WMJ3MQV7T7TLP4JCZOLCL6T7BON2A6P
looks interesting

grep GDJNK7YUXVFDUI4UKE6WEHJV4WMJ3MQV7T7TLP4JCZOLCL6T7BON2A6P $KAU_CI_extract
Eh
I have SNIPped the gory details

The extract file stops at
AUG-2022

Large transactions after that date
Not necessarily EPDs
Active recently (not visible from extract file; transparent on the blockchain Explorer)
60 kg 3 days ago.
Not EPD

 

[ZürichGnome]

The 5 EPDs above were probably special cases of some sort.
5++ kg to 83 kg Au

Let's now exclude them for clarity.
To focus on the rest

 

[ZürichGnome]

linux> sed '1d' $KAU_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) && ($7 <= 5000) {printf "%s\t%20s\t%-20s\t%8.2f\n", $1, $3, $4, $7}' | sort -k1 
2019-04-01T12:13:53Z                 payment    test epd                  500.00
2019-04-01T12:17:23Z                 payment    test epd leg 2            500.00
2019-04-04T07:08:39Z          create_account    EPD 001                   100.00
2019-04-08T06:21:45Z          create_account    EPD 002                   100.00
2019-05-01T06:59:36Z          create_account    EPD 003                   100.00
2019-05-07T05:17:40Z          create_account    EPD 004                   200.00
2019-05-07T05:23:10Z                 payment    EPD 005                   300.00
2019-05-16T06:05:17Z          create_account    EPD 006                  1000.00
2019-08-21T09:54:19Z                 payment    EPD 007                   800.00
2019-09-03T08:06:49Z                 payment    EPD 008                   700.00
2019-09-03T08:14:11Z                 payment    EPD 009                  1244.14
2019-09-09T05:07:39Z          create_account    EPD 010                  3000.00
2019-09-09T05:12:10Z                 payment    EPD 011                   311.04
2019-09-09T05:31:38Z          create_account    EPD 012                   311.04
2019-09-12T07:58:24Z          create_account    EPD 013                   300.00
2019-09-12T08:04:04Z                 payment    EPD 014                   200.00
2019-09-12T08:08:30Z                 payment    EPD 015                   300.00
2020-09-18T01:04:41Z                 payment    EPD 017                   311.04
2021-01-27T05:08:19Z          create_account    EPD 020                  3000.00
2021-01-27T05:13:30Z          create_account    EPD 021                   500.00
2021-01-27T05:29:15Z          create_account    EPD 019                  1000.00
2021-02-04T23:32:24Z          create_account    EPD 022                  1000.00
2021-03-03T00:18:36Z          create_account    EPD 023                   311.04
2021-03-03T00:22:12Z                 payment    EPD 024                   311.04
2021-03-22T05:53:13Z          create_account    EPD 025                  1000.00
2021-03-22T06:09:23Z          create_account    EPD 026                   700.00
2021-04-21T06:56:43Z          create_account    EPD 027                   311.04
2021-04-23T07:03:58Z          create_account    EPD 028                   100.00
2021-04-27T05:33:25Z          create_account    EPD 029                  2200.00
2021-05-05T06:43:00Z          create_account    EPD 030                   500.00
2021-05-11T05:56:25Z          create_account    EPD 031                  1000.00
2021-05-13T07:29:05Z          create_account    EPD 032                  1000.00
2021-05-19T03:08:36Z          create_account    EPD 033                  3000.00
2021-05-19T03:10:40Z          create_account    EPD 034                   700.00
2021-05-21T06:50:56Z          create_account    EPD 031                  1000.00
2021-05-21T07:25:01Z          create_account    EPD 035                  2000.00
2021-06-17T07:26:33Z          create_account    EPD 036                  1000.00
2021-06-22T05:36:22Z          create_account    EPD 038                   300.00
2021-07-19T23:24:57Z          create_account    EPD 039                   700.00
2021-08-12T08:44:02Z          create_account    EPD 040                  4976.56
2021-10-15T06:02:11Z          create_account    EPD 041                   100.00
2021-10-21T05:46:21Z          create_account    EPD 042                   200.00
2021-11-12T01:29:19Z          create_account    EPD 043                    74.90
2021-11-15T03:49:16Z          create_account    EPD 044                   200.00
2021-11-15T07:10:04Z          create_account    EPD 045                  1000.00
2021-11-16T23:34:41Z          create_account    EPD 046                   311.04
2021-11-16T23:38:26Z          create_account    EPD 047                   311.04
2021-11-23T05:59:06Z          create_account    EPD 048                  1000.00
2021-11-30T07:48:20Z          create_account    EPD 049                  1000.00
2021-11-30T09:37:24Z          create_account    EPD 050                  2488.24
2021-11-30T09:43:54Z          create_account    EPD 051                   622.06
2021-11-30T09:47:39Z          create_account    EPD 052                  1000.00
2021-12-10T02:28:09Z          create_account    EPD 053                   200.00
2021-12-14T03:34:14Z          create_account    EPD 054                   622.06
2021-12-14T03:37:59Z          create_account    EPD 055                    93.31
2022-03-11T03:50:22Z          create_account    EPD KAU 057               200.00
2022-03-16T06:29:57Z          create_account    EPD KAU 058              1710.69
2022-06-13T02:03:46Z          create_account    EPD KAU 059               100.00
2022-06-17T01:11:21Z          create_account    EPD KAU 060              2000.00
2022-08-16T01:53:33Z          create_account    EPD 056-A                  21.98

Ooh. That's nice.
Yup. That's all of them up to JAN 2023 (sic)

 

[ZürichGnome]

Select the round numbers to identify EPDs made up of 1 kg and 100 g
Why?
Dunno. Seems the right thing to do.

linux> sed '1d' $KAU_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) && ($7 <= 5000) {printf "%s\t%20s\t%-20s\t%8.2f\n", $1, $3, $4, $7}' | sort -k1 | cut -f4 | grep "\.00" 
  500.00
  500.00
  100.00
  100.00
  100.00
  200.00
  300.00
 1000.00
  800.00
  700.00
 3000.00
  300.00
  200.00
  300.00
 3000.00
  500.00
 1000.00
 1000.00
 1000.00
  700.00
  100.00
 2200.00
  500.00
 1000.00
 1000.00
 3000.00
  700.00
 1000.00
 2000.00
 1000.00
  300.00
  700.00
  100.00
  200.00
  200.00
 1000.00
 1000.00
 1000.00
 1000.00
  200.00
  200.00
  100.00
 2000.00

linux> sed '1d' $KAU_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) && ($7 <= 5000) {printf "%s\t%20s\t%-20s\t%8.2f\n", $1, $3, $4, $7}' | sort -k1 | cut -f4 | grep "\.00" | wc -l
43

43 round numbers
ie
multiples of 100, 1000
Small bars to kilo bars and so on
Kewl to observe init?

linux> sed '1d' $KAU_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) && ($7 <= 5000) {printf "%s\t%20s\t%-20s\t%8.2f\n", $1, $3, $4, $7}' | sort -k1 | cut -f4 | grep -v "\.00" | wc -l
17

17 not round
grep -v
such a simple trick
and yet so powerful
oh you'd like to see the data?
'ere you are:

linux> sed '1d' $KAU_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) && ($7 <= 5000) {printf "%s\t%20s\t%-20s\t%8.2f\n", $1, $3, $4, $7}' | sort -k1 | cut -f4 | grep -v "\.00" 
 1244.14
  311.04
  311.04
  311.04
  311.04
  311.04
  311.04
 4976.56
   74.90
  311.04
  311.04
 2488.24
  622.06
  622.06
   93.31
 1710.69
   21.98

Old hands will immediately .
I only do 'cos I did the job for KAGs.
Multiples of ozt to grammes is what this is about init?

linux> units -t ozt g
31.103477

Some of the EPD gold may well have come in as troy ounce (ozt) coins or small bars.
Im far too lazy to actually think. I much prefer to hit data with brute force.

 

[ZürichGnome]

Write the above data into file Not-Metric

sed '1d' $KAU_CI_extract | awk -F, '((toupper($4) ~ /EPD/) || (toupper($4) ~ /EDP/)) && ! ((toupper($4) ~ /SEGREGATED/) || (toupper($4) ~ /FEE/) ) && ($7 <= 5000) {printf "%s\t%20s\t%-20s\t%8.2f\n", $1, $3, $4, $7}' | sort -k1 | cut -f4 | grep -v "\.00" > Not-Metric

Then hit it with units to perform an automatic conversion from ozt (we're just guessing of course) to g

for i in `cat Not-Metric`; do   printf "%-10.2f" $i;    units -o "%-.2f" -t " $i g" "ozt"; done 
1244.14   40.00
311.04    10.00
311.04    10.00
311.04    10.00
311.04    10.00
311.04    10.00
311.04    10.00
4976.56   160.00
74.90     2.41
311.04    10.00
311.04    10.00
2488.24   80.00
622.06    20.00
622.06    20.00
93.31     3.00
1710.69   55.00
21.98     0.71

The round numbers are multiples of ozt units.
The remainder?
after writing to flat file output

linux> cut -c10- output
 40.00
 10.00
 10.00
 10.00
 10.00
 10.00
 10.00
 160.00
 2.41
 10.00
 10.00
 80.00
 20.00
 20.00
 3.00
 55.00
 0.71
linux> cut -c10- output | grep -v ".00"
 2.41
 0.71

Yes I'm afraid that's called hard-coding (c10- = column 10 to end of line, for the cut. Not elegant. But it does the job init?)
but we do have 2 as yet unidentified objects.

 

[ZürichGnome]

Heck. Time to actually think.
And I have a few glasses of the finest Aldi red in my bloodstream. Too much sharing? I know, I can't help it.

linux> grep "EPD 043\|EPD 056-A" $KAU_CI_extract 
2022-08-16T01:53:33Z,efcf902bea8af2f0bf1864e4632fa5977d18d9261e2cb78284ad5f262979c1b5,create_account,EPD 056-A,GDIENNQ3BXCTB74ZYCQAGXCY7KTGFBZGHRMUVF3ZLIW6SMAZIGX2JCCS,GCH7PFW7FSSUAAFYXYKWEA2ODRDFCMTSKQPNA2O5XDYFPLKYERTYWNPA,21.9754,0.0988993,kau,TRUE
2021-11-12T01:29:19Z,13a9b99448bdc528f0db346c0e82ab7069ab702df0e0a91cd4cb2854ba161baf,create_account,EPD 043,GDIENNQ3BXCTB74ZYCQAGXCY7KTGFBZGHRMUVF3ZLIW6SMAZIGX2JCCS,GDJNK7YUXVFDUI4UKE6WEHJV4WMJ3MQV7T7TLP4JCZOLCL6T7BON2A6P,74.8962,0.3370429,kau,TRUE

Wot is that all about?
I know. We are only dealing with just over 3 ozt of gold. But that is over 6K USD fiat right now init?

 

[ZürichGnome]

Oh

https://explorer.kinesis.money/account/GCH7PFW7FSSUAAFYXYKWEA2ODRDFCMTSKQPNA2O5XDYFPLKYERTYWNPA

Our friend we met previously.
One of the top 5 (above 5kg people)
22 kg
Looks like a 1% thing.
Possibly an EPD going into segregated storage.
EPD 056
and
EPD 056-A
clearly related init...

 

[ZürichGnome]

From the hash of the other fellah, we get the account (by inspection; fancy word for just about thinking while heavily under the influence)

Kinesis Chain Explorer

explorer.kinesis.money

Again one the Big Five from far above...
Time for bed.
Apprentice auditor.
Out.
Over to you all.