Live data from Hacker News

Viewing profile — tessbi

tessbi

HN member
Joined
Fri, Apr 14, 2023, 4:09 AM UTC
HN karma
57
Public activity
30 items

About tessbi

I mostly work with datbases, data analytics, and dabble in data science

Recent public activity

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

    I posted this a few weeks ago and the server died under the traffic. Fixed that by adding an in-mem caching layer with Redis/valkey and added CloudFront caching for static content.…

  2. comment
    Comment #48405242

    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. comment
    Comment #48405238

    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. comment
    Comment #48405227

    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 th…

  5. comment
  6. story
  7. comment
    Comment #40394701

    This is excellent! Good work!

  8. comment
    Comment #36251335

    Very cool!

  9. comment
    Comment #35642947

    Thanks for the tip! I will check it out!

  10. comment
    Comment #35636486

    I can add a button for that.

  11. comment
    Comment #35634699

    That would be in the future for sure, US data is just much easier to work with right now.

  12. comment
    Comment #35631512

    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 …

  13. comment
    Comment #35631479

    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…

  14. comment
    Comment #35630280

    Yes, but they do not necessarily offer it as a dump right away. So I am still relying on monthly dumps.

  15. comment
    Comment #35630270

    I could try playing around with Grafana as well, thanks for the tip!

  16. comment
    Comment #35630258

    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.…

  17. comment
    Comment #35630245

    Got it! I removed the phone number as necessary.

  18. comment
    Comment #35630242

    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

  19. comment
    Comment #35630233

    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…

  20. comment
    Comment #35630220

    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 n…

  21. comment
    Comment #35624243

    Thank you so much! This has been my project for the past 3 years.

  22. comment
    Comment #35624173

    I see. Well its not as slick as paid data visualization tools for sure.

  23. comment
    Comment #35624081

    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 brows…

  24. comment
    Comment #35623704

    For most questions, please look through the tutorial videos and documentation that I created! :) https://tesseractanalytics.ai/data-tutorials/ https://tesseractanalytics.ai/finance…

  25. comment
    Comment #35623619

    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 mo…