EDIT: Regarding the [duplicate] designation: I carefully checked all the sites listed in the Equities and Equity Indices section of What data sources are available online?. I was not able to find what I am looking for (as described in the post below) in any of them. If what I am looking is there, and somehow I missed it, please provide a specific link.
I would like to get a table of the form
symbol | open | close | high | low A | 90.32 | 89.81 | 90.58 | 89.46 AA | 12.51 | 12.17 | 12.61 | 11.93 AAAU | 17.20 | 17.35 | 17.35 | 17.09 ⋮ ⋮ ⋮ ⋮ ⋮ ZYME | 37.77 | 36.16 | 38.00 | 36.50 ZYNE | 5.41 | 5.21 | 5.48 | 5.13 ZYXI | 20.40 | 21.26 | 22.25 | 20.10
...where the numeric column's are today's open, close, high, and low prices, and the rows range over all ~9000 symbols traded in AMEX, NYSE, and NASDAQ.
I have found many ways to programmatically query for data for individual, but with this approach, generating such a table would require at least ~9000 queries (assuming I can get all four values of interest in a single query).
EDIT: Judging from the answers I've received so far, the last paragraph above was not explicit enough. So let me be even more clear: I am not interested in solutions that entail iterating over ~9000 stock symbols, and querying some site for each symbol's data.
Is there a low-cost (preferably free) source that would allow me to download such data (for today) in bulk, as a single file?
I imagine that today's data (if it's available sometime before midnight) may not be available for free. In that case, what about yesterday's data?
I have studied the thread Where to download list of all common stocks traded on NYSE, NASDAQ and AMEX?, and tried several of the sites mentioned in it, but with one exception, all the answers seem to limit themselves to providing a list of all traded symbols, which is not what I'm after.
The one exception I alluded to are the files one can download from https://old.nasdaq.com/screening/company-list.aspx, which at least seem to include yesterday's close price. This is still less than what I'm looking for.
I should add that I have no problem with scripting and data munging. In other words, as long as I can download the data in some form, I am confident that I will be able to parse it and reformat it if necessary to achieve the format described above.
EDIT: Originally, my question asked for a free source, but, after reading What data sources are available online? I suspect that I won't find the data I'm looking for for free.