PREVIEW / stock_daily / 2006-10-09

all stock daily files

  file:    by_date/stock_daily/2006/2006-10-09.parquet
  size:    150 KB
  rows:    4,486
  symbols: 2,826

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2006-10-09	AAPL	Stock	2.6357	2.6814	2.6261	2.6654	438222400.0
2006-10-09	MSFT	Stock	27.8	27.93	27.62	27.72	33366300.0
2006-10-09	NVDA	Stock	0.5143	0.5555	0.5128	0.5487	932304000.0
2006-10-09	AMZN	Stock	1.6245	1.674	1.6225	1.669	105784000.0
2006-10-09	CL	Stock	31.125	31.345	31.005	31.31	2718400.0
2006-10-09	A	Stock	23.6409	24.02	23.4406	23.9056	3899022.0
2006-10-09	AABA-DELISTED	Stock	25.4500007629395	25.7199993133545	25.0	25.0300006866455	15729500.0
2006-10-09	AACC-DELISTED	Stock	16.89	17.17	16.7	17.09	67259.0
2006-10-09	AACQU-DELISTED	Stock	6.11	6.11	6.11	6.11	1000.0
2006-10-09	AACQW-DELISTED	Stock	0.38	0.39	0.38	0.38	22189.0
2006-10-09	AAI-DELISTED	Stock	10.2	10.23	10.03	10.19	1269500.0
2006-10-09	AAIC-DELISTED	Stock	165.4	171.6	165.2	169.0	948400.0
2006-10-09	AAME	Stock	2.4	2.45	2.4	2.45	2600.0
2006-10-09	AAON	Stock	3.1394	3.1658	3.1197	3.1579	209587.0
2006-10-09	AAP	Stock	34.42	34.84	34.01	34.68	509700.0
2006-10-09	AATI-DELISTED	Stock	4.98	5.14	4.98	5.1	347357.0
2006-10-09	AAU-DELISTED	Stock	2.59	2.6	2.5	2.5	44400.0
2006-10-09	AAUAF-DELISTED	Stock	2.59	2.6	2.5	2.5	44400.0
2006-10-09	AAV-DELISTED	Stock	11.46	11.73	11.32	11.5693	753700.0
2006-10-09	AAWW-DELISTED	Stock	45.13	45.28	44.97	45.08	61492.0
2006-10-09	AAXN-DELISTED	Stock	8.85000038146973	9.5	8.78999996185303	9.30000019073486	2796500.0
2006-10-09	AB	Stock	70.1	72.0	69.84	71.2	291300.0
2006-10-09	ABAX-DELISTED	Stock	22.59	22.77	21.28	21.85	634319.0
2006-10-09	ABB-DELISTED	Stock	13.73	13.84	13.7	13.75	1359100.0
2006-10-09	ABBC-DELISTED	Stock	14.97	15.04	14.97	15.04	6516.0
2006-10-09	ABC-DELISTED	Stock	22.92	23.14	22.82	23.01	1568600.0
2006-10-09	ABCB	Stock	27.2826	27.4285	27.0006	27.4285	11001.0
2006-10-09	ABCO-DELISTED	Stock	26.64	26.88	26.28	26.83	175813.0
2006-10-09	ABCW-DELISTED	Stock	28.62	28.92	28.57	28.91	23860.0
2006-10-09	ABD-DELISTED	Stock	22.79	22.82	22.38	22.64	141400.0
2006-10-09	ABE-DELISTED	Stock	14.58	14.6	14.32	14.5	287400.0
2006-10-09	ABFS-DELISTED	Stock	46.33	47.25	45.5	46.95	266256.0
2006-10-09	ABG	Stock	21.58	21.72	21.26	21.72	185400.0
2006-10-09	ABK-DELISTED	Stock	84.68	84.85	84.17	84.78	273200.0
2006-10-09	ABM	Stock	18.97	19.29	18.94	19.18	188200.0
2006-10-09	ABMD-DELISTED	Stock	14.61	15.65	14.58	14.64	100002.0
2006-10-09	ABP-DELISTED	Stock	3.34	3.5	3.27	3.3	167600.0
2006-10-09	ABR	Stock	25.92	26.5	25.8	26.49	49900.0
2006-10-09	ABT	Stock	22.2579	22.5794	22.2483	22.4067	9447895.0
2006-10-09	ABTL-DELISTED	Stock	15.35	15.5	15.05	15.5	9463.0
2006-10-09	ABV-DELISTED	Stock	45.8	46.5	45.74	46.42	185200.0
2006-10-09	ABVA-DELISTED	Stock	16.8	17.04	16.8	17.033	6625.0
2006-10-09	ABX-DELISTED	Stock	29.75	29.85	29.11	29.25	2264800.0
2006-10-09	ACAD	Stock	8.8	9.35	8.8	9.27	244100.0
2006-10-09	ACAP-DELISTED	Stock	51.11	51.6	51.0	51.36	21617.0
2006-10-09	ACAS-DELISTED	Stock	41.41	41.7	41.24	41.57	870850.0
2006-10-09	ACAT-DELISTED	Stock	17.61	17.61	17.14	17.38	93514.0
2006-10-09	ACC-DELISTED	Stock	25.81	25.81	25.45	25.77	91000.0
2006-10-09	ACCL-DELISTED	Stock	6.18	6.27	6.15	6.15	21569.0
2006-10-09	ACCO	Stock	22.79	22.82	22.38	22.64	145300.0

> showing 50 of 4,486 rows — these rows as CSV

> unlock the full archive -- $79 one-time