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)




"This is an excellent value, the system is generous (allowing for 500 stocks) and stable (and really is tick-by-tick), and the support is fantastic." - Comment from Shirin via Email
"I've been using Neoticker RT with IQFeed for two months, and I'm very happy with both of the products (I've had IQFeed for two years with very few complaints). The service from both companies is exceptional." - Comment from Public Forum
"I would just like to say that IQFeed version 4 is running very well and I am very happy with its performance. I would also like to extend a big thanks for the fast and efficient help that I always receive. My questions and concerns are always addressed promptly. Way to go!" - Comment from Josh in CO.
"Everything is working great ! Very impressive client. The news refreshes better and is more pertinent than the ******* feed I paid $ 100/month for. I Also like the charts a lot." - Comment from Leon
"After all the anxiety I had with my previous data provider it is a relief not to have to worry about data speed and integrity." - Comment from Eamonn
"I cannot believe what a difference it makes trading with ProphetX!" - Comment from Bruce in Los Angeles
"Thanks for the great product and support. During this week of high volume trading, my QuoteTracker + IQ Feed setup never missed a beat. Also, thanks for your swiftness in responding to data issues. I was on ******* for a few years before I made the switch over early this year, and wish I had done it a long time ago." - Comment from Ken
"I'm satisfied with IQFeed. It's the most reliable and fastest quote feed I have ever used. Although I'm a resident in China, it's still very fast!" - Comment from Xiaofei
"I like you guys better than *******...much more stable and a whole lot fewer issues." - Comment from Philip
"As a past ******* customer(and not a happy one), IQ Feed by DTN is a much better and cheaper product with great customer support. I have had no problems at all since switching over." - Comment from Public Forum
Home  Search  Register  Login  Recent Posts

Information on DTN's Industries:
DTN Oil & Gas | DTN Trading | DTN Agriculture | DTN Weather
Follow DTNMarkets 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 August 5, 2020 4:46 PM CFBB v1.2.0 16 ms.
© AderSoftware 2002-2003