17:01:09 knaccc do you have the code available for the max transaction depth for outputs? If I recall correctly, you ran some numbers on this 17:03:47 sarang what is the best general purpose tool for analyzing the Monero blockchain? Things like querying transactions that spend given outputs and the like 17:04:21 I'm trying to assist someone who is researching churning more specifically 17:04:59 Can do RPC calls on a local blockchain, or use something like the explorer API (which is much slower) on a local installation 17:05:52 That'd be unreasonably slow unless you use a patch that adds spent height to the spent_keys table. 17:06:55 I should probably make it store the tx index instead of height... 17:06:58 I assume you'd want to build some kind of custom DB structure to optimize whatever analysis is desired 17:07:29 n3ptune might have that partiuclar table. 17:08:03 Oh, good call 17:08:10 Yeah, they run a lot of analysis 17:18:50 How can I help? you mention both a specific question, but also wanting a general purpose tool 17:37:50 well, the database tool I use is here: https://github.com/coinmetrics-io/haskell-tools/blob/master/docs/coinmetrics-export.md 17:38:01 short doc on using it with Monero: https://github.com/neptuneresearch/monero-notes/blob/main/coinmetrics-export.md 17:39:19 you'll need to set up a PostgreSQL server, and you'll be writing everything in SQL queries 17:41:10 If that all sounds within reach of your researcher, we can talk more about using that to answer their questions 17:41:15 also don't forget about this tool: https://github.com/moneroexamples/transactions-export 17:43:47 Ty, I'll reply if I need something more or have other questions 18:36:00 sarang | I assume you'd want to build some kind of custom DB structure to optimize whatever analysis is desired < yeah I did that :) 18:36:28 it uses a memory mapped file with only the essentials required for chain analysis 18:36:43 and so it's fast to answer all sorts of questions 18:37:14 sgp_ https://github.com/knaccc/anonymityExplorer