I have no use for this but I've gotta say this is pretty awesome, great job!
Show HN: Database for analyzing US companies, visualize using Apache SuperSet
11–20 of 45 posts
Re: Show HN: Database for analyzing US companies, visualize using Apache SuperSet
#12I have no use for this but I've gotta say this is pretty awesome, great job!
Thank you so much! This has been my project for the past 3 years.
Re: Show HN: Database for analyzing US companies, visualize using Apache SuperSet
#13Earlier quoted context omitted.
I am not sure what you mean by 'trust it'? As in, does it display the data as it should? It is difficult to find free open source data visualization tools that can run in the browser, that anybody could log-in and use right away. For my personal analytics I use Tableau, connected to the same dataset.
I meant that it wasn't popular enough to use it because it might be buggy and/or wont be around in 5 years.
It got better and better and is still around.
Their base technology server side (Sql Alchemy/ Pandas) and client side (React Antd, Apache Echarts) is future proof.
Re: Show HN: Database for analyzing US companies, visualize using Apache SuperSet
#14How often is the database updated? For instance on stock price data can it be considered realtime (or 15 min lag) for daily market tracking? Not familiar with that SEC api.
The data is refreshed nightly for stocks. And monthly from SEC once it is available to download. There is no guaranteed data delivery SLA that I know about from SEC, so I get it monthly once it arrives. I talk more about this in detail on the website, I will also update the data documentation tab, and in tutorials. https://tesseractanalytics.ai/finance-data-quarterly-data-do...
data in edgar is usually available next business day after company filed documents.
Re: Show HN: Database for analyzing US companies, visualize using Apache SuperSet
#15At a first Glance, SuperSet seems a bit limited compared to Grafana.
Re: Show HN: Database for analyzing US companies, visualize using Apache SuperSet
#16nice work, how big is the dataset? @tessbi
Re: Show HN: Database for analyzing US companies, visualize using Apache SuperSet
#17I looked at superset a few years ago and looked great but not popular enough to trust it. Seems the same state now?
Well its a top-level apache project nowadays.
Re: Show HN: Database for analyzing US companies, visualize using Apache SuperSet
#18Interesting! Whenever I am in a more active investing phase I feel like I don't have the data available I would like to have for making decisions.
I am getting 'Database error: Unknown error' when trying to run a query. Maybe too much load at the moment.
Regarding the sign-up form: You expect the input to follow the format '888 888 8888' including blanks. I would consider dropping the phone number altogether or at least allow other formats.
Re: Show HN: Database for analyzing US companies, visualize using Apache SuperSet
#19How can I log into the portal?
There is a registration form that automatically creates you SuperSet account. https://tesseractanalytics.ai/financial-database-registratio... It also creates a Wordpress account for you if you wanted to blog about some discovery.
Is there a way to register without it also creating a WordPress account?
Re: Show HN: Database for analyzing US companies, visualize using Apache SuperSet
#20I looked at superset a few years ago and looked great but not popular enough to trust it. Seems the same state now?
Honestly somewhat buggy, specially the asynchronous and cached queries which were quite important to me.