The previous datasets have been missing some transactions for unusual types like MetaDEx Trade and Send All.
The update data is at https://mega.nz/file/1I9kCIiZ#J9XE46rKeCpJhjW9āA6rD4Ws6ueEoALdEZDYc5P2uk and should now contain all transactions that involve maidsafecoin thanks to the updated omnicore_sraper.py
The output of report_tx_stats.py is much better now, only one address has negative balance, 15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL, which is because Iām still not sure how to deal with MetaDEx trade and cancel-price transactions. Anyone got ideas? Iām going to keep digging into it but at this stage itās not clear to me how the final balance for 15ji has been calculated from the tx data.
One clue is if you look at the last two transactions for 15ji (both metadex trades) youāll see they donāt have the 15ji address anywhere, so why are they listed here? Click through to the raw tx json to get an idea of the data Iām working with in these cases. But if you look at the third transaction (also a metadex trade) youāll see it does list 15ji. So Iām confused how to handle metadex trades in the calculation of an address balance.
I suspect the ātradeā type corresponds to an entry in the orderbook but is not necessarily always matched. So I probably need to keep a variable DexOrderbook and track Trades there, only updating address balances when thereās matching orders. For example currently thereās about 6K open orders for maidsafecoin on metadex (see here)
Hereās my best guess at the history of 15ji balances:
{
"txid": "98b6e4ae1557a822fdc79b43cd3499d60ff5f4cd071166d2d56ec2544a934fb3",
"sendingaddress": "1LF4uhCxwoZ6kbdDznMiqFSoqGxdGQGGQC",
"referenceaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "Simple Send",
"propertyid": 3,
"divisible": false,
"amount": "1",
"valid": true
}
IN: 1 UPDATED: 1.0
{
"txid": "bb2a31c63ecbbf071223f4a6fb4b06fac26d0457320cb0f99f1c0ecdf67adfa1",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx trade",
"propertyidforsale": 3,
"amountforsale": "1",
"propertyiddesired": 1,
"amountdesired": "0.01780000",
"valid": true
}
OUT: 1 UPDATED: 0.0
{
"txid": "8f9044a20b3978b00bd9be80b585ab08e106e676264881fee3f24e1e056e90c9",
"sendingaddress": "1LF4uhCxwoZ6kbdDznMiqFSoqGxdGQGGQC",
"referenceaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "Simple Send",
"propertyid": 3,
"divisible": false,
"amount": "110",
"valid": true
}
IN: 110 UPDATED: 110.0
{
"txid": "2e12f243348d58f4a44465c717bf0737904bb0d77bf30656ebf22bbae48abe5f",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"referenceaddress": "164XeLd6yRwqDHt91v1QfvTvvXMpu9qbHF",
"type": "Simple Send",
"propertyid": 3,
"divisible": false,
"amount": "1",
"valid": true
}
OUT: 1 UPDATED: 109.0
{
"txid": "adbdb684a5500f779d4ff92ef3188385bce2385f8cf0378c1122bdc83a145a49",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"referenceaddress": "164XeLd6yRwqDHt91v1QfvTvvXMpu9qbHF",
"type": "Simple Send",
"propertyid": 3,
"divisible": false,
"amount": "89",
"valid": true
}
OUT: 89 UPDATED: 20.0
{
"txid": "ed939e6cae1e5035a077c06b346877165aed49c4c99081df022a7e2dcf67e61e",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx trade",
"propertyidforsale": 3,
"amountforsale": "20",
"propertyiddesired": 1,
"amountdesired": "0.50000000",
"valid": true
}
OUT: 20 UPDATED: 0.0
{
"txid": "67bea4e13a4afd655f6b5a6e985bfcfa8062d3052c9b45d693a229e6b5724e88",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx trade",
"propertyidforsale": 1,
"amountforsale": "0.25000000",
"propertyiddesired": 3,
"amountdesired": "10",
"valid": true
}
IN: 10 UPDATED: 10.0
{
"txid": "e21bacfac5ec4ef2b77c3b3266eb3cf159dae748945439fd01dc02aa42c870fe",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx trade",
"propertyidforsale": 3,
"amountforsale": "10",
"propertyiddesired": 1,
"amountdesired": "0.20000000",
"valid": true
}
OUT: 10 UPDATED: 0.0
{
"txid": "971bb5afba924ef5651cee4699f50cba869c0445f899a44c6c4e6c606d970a9d",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx trade",
"propertyidforsale": 1,
"amountforsale": "0.17500000",
"propertyiddesired": 3,
"amountdesired": "7",
"valid": true
}
IN: 7 UPDATED: 7.0
{
"txid": "f449fa25c78d3d7ed51a9cfb312984cd1dbac7da20fbeb5675466a9686eb29b2",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx trade",
"propertyidforsale": 1,
"amountforsale": "0.17500000",
"propertyiddesired": 3,
"amountdesired": "7",
"valid": true
}
IN: 7 UPDATED: 14.0
{
"txid": "761bc8ae755ccac230c561b1b0a8f016561daec451733cefacc03d9dc29d1d78",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx trade",
"propertyidforsale": 3,
"amountforsale": "2",
"propertyiddesired": 1,
"amountdesired": "0.10000000",
"valid": true
}
OUT: 2 UPDATED: 12.0
{
"txid": "5bbb7ef6de7d41a296f5c3bc8a6e6d767900219f41379ecc3fb69c5dc6027314",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx trade",
"propertyidforsale": 3,
"amountforsale": "5",
"propertyiddesired": 1,
"amountdesired": "0.09000000",
"valid": true
}
OUT: 5 UPDATED: 7.0
{
"txid": "34b20e612bceb62b8cd35f2b3c4770e1792c0ca04a50d8849bab1418a26e3cec",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx trade",
"propertyidforsale": 3,
"amountforsale": "5",
"propertyiddesired": 1,
"amountdesired": "0.12500000",
"valid": true
}
OUT: 5 UPDATED: 2.0
{
"txid": "cfe0ec088625b9546be1b60e153d542cee2b3c56618c45cc579f57014408cff1",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx trade",
"propertyidforsale": 3,
"amountforsale": "2",
"propertyiddesired": 1,
"amountdesired": "0.05000000",
"valid": true
}
OUT: 2 UPDATED: 0.0
{
"txid": "82f0c7502bb9ed804bd9723deb6a6164688c095830cb223f318e838afb598963",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx cancel-price",
"propertyidforsale": 3,
"amountforsale": "2",
"propertyiddesired": 1,
"amountdesired": "0.05000000",
"valid": true
}
OUT: -2 UPDATED: 2.0
{
"txid": "bcfd6ad9bc75016fd22820894796ec42fed75cebfd1913ef67be7fdb221939c3",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx trade",
"propertyidforsale": 1,
"amountforsale": "0.15000000",
"propertyiddesired": 3,
"amountdesired": "3",
"valid": true
}
IN: 3 UPDATED: 5.0
{
"txid": "34a6526c6d382f2355ae59c5dfbe2f5e569a22398db9b282c1fdfcd0bb4cef4f",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx trade",
"propertyidforsale": 3,
"amountforsale": "7",
"propertyiddesired": 1,
"amountdesired": "0.10500000",
"valid": true
}
OUT: 7 UPDATED: -2.0
{
"txid": "3ed7816ef8152dc4ed1a718cd8df7ed84c5a1e67c3941cd92ca53aeeb7fd2027",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx trade",
"propertyidforsale": 1,
"amountforsale": "0.03000000",
"propertyiddesired": 3,
"amountdesired": "2",
"valid": true
}
IN: 2 UPDATED: 0.0
{
"txid": "3df0ab0f623676194823b8d0be4e7af60869cb026016caa76686bfe3579f150d",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx trade",
"propertyidforsale": 1,
"amountforsale": "0.06000000",
"propertyiddesired": 3,
"amountdesired": "2",
"valid": true
}
IN: 2 UPDATED: 2.0
{
"txid": "87d4d306525d601541bedc845a849ba48b04aba22c4e94e2d4dfc04c97b7e472",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx trade",
"propertyidforsale": 3,
"amountforsale": "4",
"propertyiddesired": 1,
"amountdesired": "0.10000000",
"valid": true
}
OUT: 4 UPDATED: -2.0
{
"txid": "280ece2c88f3dface4328e162e3df5160c40ba0cf36c17054e186a69eaafd2e7",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx trade",
"propertyidforsale": 3,
"amountforsale": "2",
"propertyiddesired": 1,
"amountdesired": "0.03500000",
"valid": true
}
OUT: 2 UPDATED: -4.0
{
"txid": "914f9b85a16b392ea510ab2eee0af146b481e6ad1608e8b6e188a166059d9a03",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx trade",
"propertyidforsale": 1,
"amountforsale": "0.30000000",
"propertyiddesired": 3,
"amountdesired": "20",
"valid": true
}
IN: 20 UPDATED: 16.0
{
"txid": "585d93d9b9d2fce5f91e16a1377b1bc0e54ab7f40394f5bb40e18663bf131fc1",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx cancel-price",
"propertyidforsale": 3,
"amountforsale": "2",
"propertyiddesired": 1,
"amountdesired": "0.03500000",
"valid": true
}
OUT: -2 UPDATED: 18.0
{
"txid": "1ea9d3def9aa7bf7f8f2c4047c79789e04c31619fa84aa67c32fd0be7979696c",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx cancel-price",
"propertyidforsale": 1,
"amountforsale": "0.30000000",
"propertyiddesired": 3,
"amountdesired": "20",
"valid": true
}
IN: -20 UPDATED: -2.0
{
"txid": "67ecc0c8b9b56feabe70f5afb8db7989131be834f6b410a3c39fdb65ba79794f",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx trade",
"propertyidforsale": 3,
"amountforsale": "1",
"propertyiddesired": 1,
"amountdesired": "0.01300000",
"valid": true
}
OUT: 1 UPDATED: -3.0
{
"txid": "a3029935c5473b5e0b4c7ff41984fdde84c2802df076d17f7efe26f8bd2a6a17",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx trade",
"propertyidforsale": 1,
"amountforsale": "0.15000000",
"propertyiddesired": 3,
"amountdesired": "10",
"valid": true
}
IN: 10 UPDATED: 7.0
{
"txid": "da9abec292169133e4a863b584a400e942b7947bd44e8858432d9ce621766fa4",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx trade",
"propertyidforsale": 3,
"amountforsale": "1",
"propertyiddesired": 1,
"amountdesired": "0.01500000",
"valid": true
}
OUT: 1 UPDATED: 6.0
{
"txid": "428a3014bb74da204ffffb2b7d433495304e6604888dbc319b0cfd28a7a7feb6",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx cancel-price",
"propertyidforsale": 1,
"amountforsale": "0.15000000",
"propertyiddesired": 3,
"amountdesired": "10",
"valid": true
}
IN: -10 UPDATED: -4.0
{
"txid": "91ba042970580b048748fd9f34f54e77ce0fec46d6b167aa3a4b56706b1d6884",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx cancel-price",
"propertyidforsale": 3,
"amountforsale": "4",
"propertyiddesired": 1,
"amountdesired": "0.10000000",
"valid": true
}
OUT: -4 UPDATED: 0.0
{
"txid": "3ba5e14608c0dc585426b34c47a4e1a715fb20beae95e399a697028d5b717322",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx trade",
"propertyidforsale": 3,
"amountforsale": "6",
"propertyiddesired": 1,
"amountdesired": "0.15000000",
"valid": true
}
OUT: 6 UPDATED: -6.0
{
"txid": "59d57316f27a979cd8af7b021aa8cbf74e11813695fd01f3f7b1aa0f7bf62e01",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx cancel-price",
"propertyidforsale": 3,
"amountforsale": "6",
"propertyiddesired": 1,
"amountdesired": "0.15000000",
"valid": true
}
OUT: -6 UPDATED: 0.0
{
"txid": "e12a3fc5948b930e18d54d4244256ae9c61fab2c221e76d46d61396231c35a9d",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx trade",
"propertyidforsale": 3,
"amountforsale": "6",
"propertyiddesired": 1,
"amountdesired": "0.15000000",
"valid": true
}
OUT: 6 UPDATED: -6.0
{
"txid": "e3e11b5d5e99abee6ce94261eaacbfad176fbdd877e661b8b228f504aa0875bc",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx cancel-price",
"propertyidforsale": 3,
"amountforsale": "6",
"propertyiddesired": 1,
"amountdesired": "0.15000000",
"valid": true
}
OUT: -6 UPDATED: 0.0
{
"txid": "fc780e045668432620f10d1e11209ce0750eafe0e76cc70c4560211d0b437d9e",
"sendingaddress": "15jiVUZLqg9ExtyDdfHsjA1J5efujTBqJL",
"type": "MetaDEx trade",
"propertyidforsale": 3,
"amountforsale": "6",
"propertyiddesired": 31,
"amountdesired": "0.48000000",
"valid": true
}
OUT: 6 UPDATED: -6.0