Async Price Data Load with aiohttp and asyncpg

[yourpersonaldatadealer]

Async is hard to teach but you did a great job. For the newbies, one thing to remember that had me scratching my head a few years ago is: don't use synchronous code in an async function (e.g. don't use dataframe.to_csv(), instead use an async equivalent lib like aiofiles). If you don't do this then you end up going back to synchronous code running speeds.

[ballyoracle]

the diff concept is very well explained ... got every bit for it .. you are already explaining it very well Thank you Larry !!!

[TuranInsight]

The pieces of information you teach here are so valuable- thank you for doing this larry!

[Rickynator]

Hey Larry I want to start saying thank you for all the knowledge that you share man. I have been following this series and I have been learning a lot

Have a great and safe rest of your weekend!!

[michaelstreck]

I can't believe this video slipped by me until today. I need to up my PTL stalking game! Thank you for all you do!

[CameronCrosby]

Hey Larry, great video! I see your subscriber count going up :) You deserve 100 times as many as you have now!

[iamvazu]

Thanks for all the KT larry, this is gold 🥇

[stephenambrose]

This is great Larry, thank you for sharing and pickin on the guitar (if that was you). I did something similar with multiprocessing and mysql.connector.pooling which took a dataframe broke it into chunks based on the number of cpu cores and processed the df in parallel. This will be very helpful to get a snapshot loaded to a table for quick analysis.

[binup]

Hey Larry - Great stuff!! Thank you.
Could you do one for alphavantage? Thanks in advance!

[degenviking]

dude, is your site down? Was going to send you a should out for a whiskey for this video. Thanks for the awesome stuff man

[brianrowe]

This is great, except Alpaca discontinued polygon. I'm trying in postman to get the REST API to return something, but with their current documentation it is just not working and the message is just Not Found. Maybe the URL is wrong, but they have no examples on their site of how to get bars from the REST API its all the API. Maybe I just write an example, that use concurrent futures, but I'm not sure I'll know how to the async pg working with that. Also maybe I need to see the next video, because I really wanted to see how to keep the prices up to date, not do a 1 time load. Thanks again, these are great.

[AnikPatelIsABaws]

Hey Larry, could you make a video on how to do this with the new Alpaca API and not a HTTP request?

[DavidCVdev]

hi, the poligon api key requires payment any alternatives?

[HitAndMissLab]

yeah, but data provider is going to block your connection if you send too many requests. How do you work around that? can you use proxies?

[shrimal]

Great video! Does still work? I keep getting "<class 'TypeError'>" error on call to write_to_db.

[mezseyoum]

Hey I noticed that this is not added in the repository yet. I would love to see the code. I'm not using RESTful API I'm using the TWS API of interactive broker. so I'm making all the necessary adjustments. So far I've been following this series and everything has been working great for me but I'm having a hard time wrapping my head around the concept of "co-routine". I would love to have the code in front of me so I could get a better intuition. Thanks for the content.

[samgeorgesullivan]

Hey, thanks for another great video! I have been trying to follow along using binance api instead and can't work out what the equivalent binance url would look like? Any help greatly appreciated

[kylehammerberg]

Sadly, as far as I know, this is no longer possible without paying for an API. Still a great video, though. Thanks, Larry.

[milprodin]

awesome vid, Larry! thx! will this method work equally well with alpaca_trade_api instead of straight up session.get(url)

[FinGeeknow]

Awesome video! Gives a few ideas for my ML algo-trader =) Any plans for a multithreading video with perhaps also using the async as well?