Thread by @trepca

Introducing a SQL Explorer for Chia blockchain - a powerful analysis & data mining tool that enables you to dive deep into the #Chia blockchain using SQL. 📊🔍

Some examples to get you started: 🧵 $xch

Here's average block utilization per week using `block_records` table: mojonode.com/explorer?q=sel…

Number of reorgs and depth. (Looks like reorgs of 10 blocks are not uncommon.)
mojonode.com/explorer?q=sel…

Number of "unique" active addresses per day. Notice the dusting.
mojonode.com/explorer?q=sel…

What type of coin puzzles are being spent per week. This done by querying puzzle reveals and puzzle hash.
mojonode.com/explorer?q=sel…

Avg fees earned per week
mojonode.com/explorer?q=sel…

NFTs minted without DID launcher in the last year
mojonode.com/explorer?q=%0A…

Fees earned per farmer per week
mojonode.com/explorer?q=sel…

Traverse up the ancestors of a latest hacker's coin:
mojonode.com/explorer?q=WIT…
here we're using recursive CTEs

Feel free to play with it, there are some rate limits but shouldn't be noticeable. Resultset can be max 500 records. It will timeout if query is too complex or requires too much memory. Enjoy!