Sure, I'm gonna write a lengthier post later but essentially I have the following:

1- I vibe coded an event listener client that stores all events from a relay into a data warehouse. It needs some work still as I suspect it is dropping part of the events.

2 - using the data from the above I started a DBT project (which can become a community template) for getting basic analytics from nostr events in the warehouse. I.e. the follow list of an account, top reacted posts and other aggregations.

The idea was to use the data also to create an open source a few models. Such as: how to flag an account as a bot, or to build a social graph of an account.