| From: | chester c young <chestercyoung(at)yahoo(dot)com> |
|---|---|
| To: | roopa perumalraja <roopabenzer(at)yahoo(dot)com> |
| Cc: | sql pgsql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Add calculated fields from one table to other table |
| Date: | 2006-10-26 15:29:00 |
| Message-ID: | 20061026152900.21557.qmail@web54305.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
roopa perumalraja <roopabenzer(at)yahoo(dot)com> wrote: Hi
I have two tables. Tick table has fields like ticker, time, price & volume and Timeseries table has fields like ticker, time, avg_price, avg_volume.
The time field in Timeseries table is different from time in tick table, its the timeseries for every minute. Now I want to calculate the average price & volume from tick table for each ticker and for every minute and add those fields to timeseries table. Can anyone please help me out with the sql query.
Note: The ticker in the tick table also has duplicate values, so i am not able to create relation between two tables.
Thanks in advance
Roopa
---------------------------------
You can't get there from here. It is like saying a hitter has a .250 average and in this game he was 2 for 4, what's his average? Timeseries must also have quantity and price, just as you would need to know number of bats and hits for the baseball player.
---------------------------------
Want to be your own boss? Learn how on Yahoo! Small Business.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Broersma Jr | 2006-10-26 17:59:34 | Re: Add calculated fields from one table to other table |
| Previous Message | Aaron Bono | 2006-10-26 01:59:51 | Re: Add calculated fields from one table to other table |