|
I know you can get historical end of day stock data from both Google and Yahoo, and I'm able to get delayed quotes from Yahoo. I'm looking for free intra day historical stock data, ideally with data at every five minutes or less.
Started by Jared on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Tick-by-tick data....
IQFeed only has about two years of historical data for stocks.
22,000 ticks in one day, along with price from this web site .
I looked up the data for GOOG once..
historical intradaily data.
|
|
I'd like to view historical data for guest cpu/memory/IO usage, rather than just current usage.
Started by Otto on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
A Xen Virtual.
Both Nagios and Munin seem to have plugins/support for Xen data collection.
The problem is that you'd like to see the historical CPU/Mem usage , or Munin .
I believe its called esxtop).
|
|
I'm trying to determine how I should store historical transactional data.
Should I store it in a single table where the record just gets reinserted with a new timestamp each time?
Should I break out the historical data into a separate 'history' table ...
Started by Aaron Palmer on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
This lets reporting but don't work well in a transactional... .
You use data structures like slowly changing dimensions that are much better for historicalIf the requirement is solely for reporting, consider building a separate data warehouse.
|
Ask your Facebook Friends
|
I'm trying to make a stock market simulator (perhaps eventually growing into a predicting AI), but I'm having trouble finding data to use. I'm looking for a (hopefully free) source of historical stock market data.
Ideally, it would be a very fine-grained...
Started by rmeador on
, 11 posts
by 11 people.
Answer Snippets (Read the full thread at stackoverflow):
Using....
We used TickData for our source I can assist you with .
Now that opentick is dead an automated trading system, and we used historical data profusely.
Unfortunately historical ticker data that is free is hard to come by.
|
|
My simplified and contrived example is the following:-
Lets say that I want to measure and store the temperature (and other values) of all the worlds' towns on a daily basis. I am looking for an optimal way of storing the data so that it is just as easy...
Started by Andrew Rimmer on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
If usage patterns indicate that the historical data will be queried more often than the current values, then put them all....
Unless you patterns...
I suggest keep in the same table since historical data is queried just as often.
|
|
I'm creating a database schema for storing historical stock data. I currently have a schema as show below.
My requirements are to store "bar data" (date, open, high, low, close volume) for multiple stock symbols. Each symbol might also have multiple timeframes...
Started by nall on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
It's better to add one further....
From a performance as well as a usability perspective.
You're storing timeframe data as TEXT .
We purchased all of our historical market data from the Kibot web site: http://www.kibot.com/
effort.
|
|
Hello,
I'm looking for some ideas about saving a snapshot of some (different) records at the time of an event, for example user getting a document from my application, so that this document can be regenerated later. What strategies do you reccomend? Should...
Started by kyku on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
We created a new table that had a very similar structure to the table we wanted to log and whenever we needed to log something, we did something similar to this:
attr = object_to_log.attributes # Remove things like created... .
I did this once awhile back.
|
|
I want to maintain last ten years of stock market data in a single table. Certain analysis need only data of the last one month data. When I do this short term analysis it takes a long time to complete the operation.
To overcome this I created another...
Started by Prabu on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
To update your historical data? If you're dealing with stock splits, it's common to implement that using a seperate multiplier table that is used in conjunction with the raw historical data to give with large data volumes....
|
|
I'm looking for an API that provides recent, 3-hourly temperatures... either observed or forecasted. To be clear, I'm looking for data from the past... like 'yesterday'.
Free or paid is fine. International or US only is fine. Lookup by long/lat, zip, ...
Started by Josh on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
To be clear, I'm looking for....
You may use the public data from NOAA's Global Summary of the Day public data FTP , but you have to read the data format convention and build a script to connect and parse the data needed.
|
|
I want to record user states and then be able to report historically based on the record of changes we've kept. I'm trying to do this in SQL (using PostgreSQL) and I have a proposed structure for recording user changes like the following.
CREATE TABLE...
Started by Phil on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
With your model you have to do something like:
select l1.userid from status_log l1 where l1.status='s' and l1.logcreated = (select max(l2.logcreated) from status... .
This can be done, but would be a lot more efficient if you stored the end date of each log .
|
