Highest Volume traded and Highest Price

[Beams]

Hi,

Quick Q, designing a database to store my EOD data, what are the highest volume traded and the highest price.

Id imagine 10 of millions and not over a thousand dollars respectively, just checking.

For those with some MYSQL understanding, I have price at decimal(7,3) and volume at int(10).

Cheers

 

[Trembling Hand]

Here is a quick Descending Volume Query from my humble ASX Access database,

To get an idea about volume it will depend on your data provider. Some divide volume by 100 or even 1000.

On the price the highest stocks on the ASX are/was around $150.00 BUT if you want to include the indexes in your database then your looking at 16,000 or greater numbers.

 

[Beams]

Thanks for that. I was worried no one would reply. I thought tens of millions would be about right, the idea of dividing by 100 or 1000 is a good one tho, it reduces the cache size required

Ive set my table to accept prices up to $1000, excluding indices.

Thanks again

 

[Trembling Hand]

Thanks for that. I was worried no one would reply. I thought tens of millions would be about right, the idea of dividing by 100 or 1000 is a good one tho, it reduces the cache size required

Ive set my table to accept prices up to $1000, excluding indices.

Thanks again

No probs. Thou I wouldn't ditch the indexes. Then again I'm an index trader