tessbi

15 ms·

1. 1.▲
   Show HN: I built an open-source financial research terminal (SEC data and SQL)(terminal.tesseractanalytics.ai)

   5 points by tessbi 3mo ago|0 comments
2. 2.▲
   by tessbi 4mo ago

   thank you for your feedback! I thought I stress tested my server, but it wasn't handling the traffic load from this HN post, so the app stopped responding! Resizing the VM now.
3. 3.▲
   by tessbi 4mo ago

   thank you for your feedback! I thought I stress tested my server, but it wasn't handling the traffic load from this HN post, so the app stopped responding! Resizing the VM now.
4. 4.▲
   by tessbi 4mo ago

   Hi everyone, thank you for your feedback! I thought I stress tested my server, but it wasn't handling the traffic load from this HN post, so the app stopped responding! Resizing the VM now. I wish it could run fully locally in browser.
5. 5.▲
   Show HN: Open Terminal – A Bloomberg Style App for Research(tesseractanalytics.ai)

   10 points by tessbi 4mo ago|11 comments
6. 6.▲
   by tessbi 2y ago

   This is excellent! Good work!
7. 7.▲
   by tessbi 3y ago

   Very cool!
8. 8.▲
   by tessbi 3y ago

   Thanks for the tip! I will check it out!
9. 9.▲
   by tessbi 3y ago

   I can add a button for that.
10. 10.▲
    by tessbi 3y ago

    That would be in the future for sure, US data is just much easier to work with right now.
11. 11.▲
    by tessbi 3y ago

    Thank you! Yes, but I am using their monthly dumps for now, because it was easier for data warehousing. I will put it in my plans to pull data daily incrementally in the future as a next phase.
12. 12.▲
    by tessbi 3y ago

    Well the quarterly one is much smaller then say, the daily one. Select count(*) from superset.company_financials_quarterly; = 458,573. I have >6000 companies, with over 80 features/columns. I cannot post daily data through SuperS
13. 13.▲
    by tessbi 3y ago

    Yes, but they do not necessarily offer it as a dump right away. So I am still relying on monthly dumps.
14. 14.▲
    by tessbi 3y ago

    I could try playing around with Grafana as well, thanks for the tip!
15. 15.▲
    by tessbi 3y ago

    Yeah, I suppose I can remove that feature, I just thought if people wanted to add comments or blog on my tutorials. Just message me in Contact Us, I will remove you from WordPress.
16. 16.▲
    by tessbi 3y ago

    Got it! I removed the phone number as necessary.
17. 17.▲
    by tessbi 3y ago

    Thank you for the feedback! I dropped the phone number as being necessary for registration. If you still have issues registering, please email me: alex@tesseractanalytics.ai
18. 18.▲
    by tessbi 3y ago

    Oh no!!! I am so sorry to hear this, I will work on fixing this. If you are still interested in trying out the data, please email me: alex@tesseractanalytics.ai. I can register you manually.
19. 19.▲
    by tessbi 3y ago

    I am deeply offended that you do not trust me, a stranger on the internet! I am hearing that many people feel that I am asking for too much data. I removed the phone number being necessary for registration. But I did still want to keep th
20. 20.▲
    by tessbi 3y ago

    Thank you so much! This has been my project for the past 3 years.
21. 21.▲
    by tessbi 3y ago

    I see. Well its not as slick as paid data visualization tools for sure.
22. 22.▲
    by tessbi 3y ago

    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.
23. 23.▲
    by tessbi 3y ago

    For most questions, please look through the tutorial videos and documentation that I created! :) https://tesseractanalytics.ai/data-tutorials/ https://tesseractanalytics.ai/finance-data-quarterly-data-d
24. 24.▲
    by tessbi 3y ago

    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
25. 25.▲
    by tessbi 3y ago

    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 dis
26. 26.▲
    Show HN: Database for analyzing US companies, visualize using Apache SuperSet(tesseractanalytics.ai)

    113 points by tessbi 3y ago|44 comments
27. 27.▲
    by tessbi 3y ago

    I used PostgreSQL as the backend database for ELT data pipelines, and used Citus Data cstore_fdw for columnar compression for the final dataset. All financial data is coming from SEC Edgar, https://www.sec.gov/developer . I