Highest Volume traded and Highest Price

• 17 December 2010

• #1

B

Beams

Joined

2 November 2010

Posts

16

Reactions

0

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

 

• 17 December 2010

• #2

Trembling Hand

Can be found on the bid

Joined

10 June 2007

Posts

8,852

Reactions

205

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.

 

Attachments

• High Vol ASX.gif

  53.5 KB · Views: 3

• 17 December 2010

• #3

B

Beams

Joined

2 November 2010

Posts

16

Reactions

0

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

 

• 17 December 2010

• #4

Trembling Hand

Can be found on the bid

Joined

10 June 2007

Posts

8,852

Reactions

205

Beams said:

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

Click to expand...

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