PREVIEW / stock_daily / 2011-01-06

all stock daily files

  file:    by_date/stock_daily/2011/2011-01-06.parquet
  size:    196 KB
  rows:    6,050
  symbols: 3,537

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
2011-01-06	AAPL	Stock	11.9543	11.9732	11.8893	11.9189	300428800.0
2011-01-06	MSFT	Stock	28.04	28.85	27.86	28.82	88026300.0
2011-01-06	NVDA	Stock	0.4355	0.4835	0.4342	0.4832	3493312000.0
2011-01-06	AMZN	Stock	9.325	9.3705	9.2625	9.293	63594000.0
2011-01-06	TSLA	Stock	1.7887	1.8667	1.7873	1.8587	30918000.0
2011-01-06	TLT	Stock	91.54	92.12	91.16	91.86	9317430.0
2011-01-06	ES	Stock	31.44	31.54	31.26	31.45	1726200.0
2011-01-06	CL	Stock	39.455	39.65	39.17	39.355	8646800.0
2011-01-06	A	Stock	29.5923	29.9285	29.4778	29.671	4699097.0
2011-01-06	AABA-DELISTED	Stock	16.9	17.3401	16.77	17.05	29885564.0
2011-01-06	AACC-DELISTED	Stock	6.14	6.31	6.08	6.19	12082.0
2011-01-06	AACG	Stock	3.75	3.9	3.74	3.84	11500.0
2011-01-06	AAI-DELISTED	Stock	7.47	7.49	7.44	7.46	2242042.0
2011-01-06	AAIC-DELISTED	Stock	24.76	24.77	24.36	24.36	26669.0
2011-01-06	AAME	Stock	2.23	2.23	2.1	2.1	600.0
2011-01-06	AAON	Stock	5.5664	5.5783	5.4815	5.517	161494.0
2011-01-06	AAP	Stock	61.99	62.29	60.09	60.27	1513500.0
2011-01-06	AATI-DELISTED	Stock	3.89	3.9892	3.84	3.93	128946.0
2011-01-06	AAU-DELISTED	Stock	4.84	4.9	4.42	4.47	609395.0
2011-01-06	AAUAF-DELISTED	Stock	4.84	4.9	4.42	4.47	610395.0
2011-01-06	AAV-DELISTED	Stock	6.96	6.98	6.88	6.89	312198.0
2011-01-06	AAWW-DELISTED	Stock	53.96	54.23	53.21	53.24	179601.0
2011-01-06	AAXJ	Stock	64.4	64.6	64.09	64.28	1076505.0
2011-01-06	AAXN-DELISTED	Stock	4.92	4.98	4.74	4.76	564074.0
2011-01-06	AB	Stock	23.58	23.58	23.19	23.24	480200.0
2011-01-06	ABAC-DELISTED	Stock	5.8099	6.0	5.8	5.81	40750.0
2011-01-06	ABAX-DELISTED	Stock	26.31	26.345	25.3	25.45	202336.0
2011-01-06	ABB-DELISTED	Stock	21.97	21.98	21.68	21.76	2747368.0
2011-01-06	ABBC-DELISTED	Stock	11.87	11.9191	11.7	11.76	28604.0
2011-01-06	ABBNY-DELISTED	Stock	21.97	21.98	21.68	21.78	2792468.0
2011-01-06	ABC-DELISTED	Stock	34.4	35.02	34.34	34.86	3216159.0
2011-01-06	ABCB	Stock	11.04	11.2	10.9	11.1	32600.0
2011-01-06	ABCD-DELISTED	Stock	3.44	3.44	3.26	3.42	23930.0
2011-01-06	ABCO-DELISTED	Stock	24.61	25.17	24.19	24.4	157640.0
2011-01-06	ABCW-DELISTED	Stock	1.24	1.39	1.24	1.35	224170.0
2011-01-06	ABD-DELISTED	Stock	8.88	8.88	8.34	8.43	172510.0
2011-01-06	ABE-DELISTED	Stock	19.22	19.3	19.08	19.08	4665.0
2011-01-06	ABEO	Stock	3062.5	3062.5	3000.0	3062.5	12.0
2011-01-06	ABFS-DELISTED	Stock	26.87	27.109	26.31	26.63	140469.0
2011-01-06	ABG	Stock	18.61	18.64	18.31	18.62	134400.0
2011-01-06	ABH-DELISTED	Stock	23.63	24.0	23.45	23.8501	767199.0
2011-01-06	ABM	Stock	26.47	26.5	26.04	26.2	206700.0
2011-01-06	ABMD-DELISTED	Stock	10.01	10.05	9.895	10.04	97305.0
2011-01-06	ABR	Stock	5.8	5.89	5.78	5.81	21500.0
2011-01-06	ABT	Stock	23.2703	23.3279	22.9248	23.112	32471030.0
2011-01-06	ABTL-DELISTED	Stock	4.8475	4.8475	4.6851	4.8025	28184.0
2011-01-06	ABUS	Stock	4.88	4.98	4.73	4.85	4200.0
2011-01-06	ABV-DELISTED	Stock	30.27	30.67	30.2	30.51	2547842.0
2011-01-06	ABVA-DELISTED	Stock	4.18	4.39	4.18	4.36	28929.0
2011-01-06	ABVT-DELISTED	Stock	62.0	62.37	60.51	60.95	77208.0

> showing 50 of 6,050 rows — these rows as CSV

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