Join the 80,000 other DTN customers who enjoy the fastest, most reliable data available. There is no better value than DTN!

(Move your cursor to this area to pause scrolling)




"You are either overstaffed or people just don't have problems with your feed because customer support always answers the phone quickly." - Comment from Jay via Email
"And by the way, have to say this. I love the IQFeed software. It's rock solid and it has a really nice API." - Comment from Thomas via RT Chat
"I will tell others who want to go into trading that DTN ProphetX is an invaluable tool, I don't think anyone can trade without it..." - Comment from Luther
"If you want customer service that answers the phone, your best bet is IQFeed. I cannot stop praising them or their technical support. They are always there for you, and they are quick. I have used ****** too but the best value is IQFeed." - Comment from Public Forum
"DTN feed was the only feed that consistently matched Bloomberg feed for BID/ASK data verification work these past years......DTN feed is a must for my supply & demand based trading using Cumulative Delta" - Comment from Public Forum Post
"Boy, probably spent a thousand hours trying to get ******* API to work right. And now two hours to have something running with IQFeed. Hmmm, guess I was pretty stupid to fight rather than switch all this time. And have gotten more customer service from you guys already than total from them… in five years." - Comment from Jim
"IQ feed works very well, does not have all of the normal interruptions I have grown used to on *******" - Comment from Mark
"I am a hedge fund manager here. It’s funny, I have a Bloomberg terminal and a Bridge feed, but I still like having my DTN feed!" - Comment from Feras
"The people at Nirvana have very nice things to say about your company and I can see why! Price and service is a potent combination." - Comment from Ed
"With HUGE volume on AAPL and RIMM for 2 days, everyone in a trading room was whining about freezes, crashes and lag with *******, RealTick, TS and Cyber. InvestorRT with IQFeed was rock solid. I mean SOLID!" - Comment from Public IRC Chat
Home  Search  Register  Login  Blogs Recent Posts

Information on DTN's Industries:
DTN Oil & Gas | DTN Trading | DTN Agriculture | DTN Weather
Follow DTN_IQFeed on Twitter
DTN.IQ/IQFeed on Twitter
DTN News and Analysis on Twitter
»Forums Index »Product Support »IQFeed 3rd Party Software Support »What is the best method to maintain a database of ticks for a collection of stocks?
Author Topic: What is the best method to maintain a database of ticks for a collection of stocks? (2 messages, Page 1 of 1)

smt52
-Interested User-
Posts: 31
Joined: Feb 23, 2009


Posted: Feb 23, 2009 08:48 AM          Msg. 1 of 2
Hi,

I'd like to maintain a historical database of tick data for stocks.

Can anybody suggest a method?

I would be open to any method that might require programming, such as a Ninja Trader solution.

I would also be open to any pre-packaged software that will take over the task of populating a database with tick data, in realtime, 365 days a year, 24 hours per day (actually, within trading hours).

Shane.

rbrodt
-Interested User-
Posts: 4
Joined: Oct 23, 2008

What color is an orange?


Posted: Mar 6, 2009 09:07 AM          Msg. 2 of 2
Since tick data is typically accessed sequentially (from start to end) instead of randomly (picking out a tick from the middle of at trading session) it makes sense to use a directory and file structure. One directory per trading instrument, and one file per trading session. To conserve space, we use a flyweight design pattern storing only the price and size offsets from an initial absolute price/size. So the tick file uses a "long" record that contains a timestamp, the LAST price and size, and volume, then subsequent ticks use a "short" record that contains a time offset from the previous record (in seconds), price offset (in "ticks" depending on the instrument) and a size offset. If the offsets are too large to fit into a "short" record, we write another "long" record. A day's worth of tick data is typically about 1Mb - small enough to be managed comfortably.
 

 

Time: Wed February 20, 2019 6:01 PM CFBB v1.2.0 0 ms.
© AderSoftware 2002-2003