It made the most sense to have the table name be the ticker. In my case, I am capturing >5000 tickers, so some of them are reserved words like KEY and some contain special characters like TICK.Z. So be sure you are using proper backtick syntax.
Anyway, one database for daily, minute, ticks, and l2 made the most sense for me, so I could keep the table name uniform across all of it.
And I definitely think you should have one table per symbol.
My comments are based on large data collection. If you are only doing it for a handful of symbols, or only for a few million records, then anything would work. I am dealing with massive amounts of data --- my server holds many times more tick data than IQFeed's does, for example. And I have it for ALL tickers (US).
Due to time constraints, please do not PM me if your question can be resolved or answered on the forum.
Need help? 1) Stop changing things. No new indicators, charts, or methods. Be consistent with what is in front of you first. 2) Start a journal and post to it daily with the trades you made to show your strengths and weaknesses. 3) Set goals for yourself to reach daily. Make them about how you trade, not how much money you make. 4) Accept responsibility for your actions. Stop looking elsewhere to explain away poor performance. 5) Where to start as a trader? Watch this webinar and read this thread for hundreds of questions and answers. 6) Help using the forum? Watch this video to learn general tips on using the site.
If you want to support our community, become an Elite Member.