I always wanted to generate all the common Bitcoin metrics myself, only obtaining the data from my full node, not to depend on Glassnode or any other paid service.
My initial interest was to generate the time series of the quantity of non-zero addresses, since it correlated so well with the 2017 cycle Bitcoin price peak. It ended up being a journey harder than I originally thought!
Eventually, I was able to code a framework to do all the calculations and decided to take advantage of the work to provide free charts and beautiful visualizations on a website, which culminated in launching https://bitcoinisdata.com/ some time ago.
The app also provides the optional ability to download the raw data in .CSV or Microsoft Excel format for just 1,000 sats a month, incredibly cheap compared to other services such as Glassnode or Bitcoin Magazine Pro.
Anyway, if you can, please take a look at Bitcoin Is Data and tell me what is missing on the website, what things I can improve on, including everything from website design and usability to what data and metrics I should add next.
Thanks a lot!