PREVIEW / stock_daily / 2011-03-22

all stock daily files

  file:    by_date/stock_daily/2011/2011-03-22.parquet
  size:    196 KB
  rows:    6,037
  symbols: 3,513

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-03-22	AAPL	Stock	12.2343	12.2364	12.1121	12.1857	325922800.0
2011-03-22	MSFT	Stock	25.3	25.46	25.23	25.3	30895600.0
2011-03-22	NVDA	Stock	0.4428	0.447	0.4342	0.4362	718332000.0
2011-03-22	AMZN	Stock	8.2035	8.222	8.1125	8.13	72228000.0
2011-03-22	TSLA	Stock	1.5153	1.524	1.4667	1.4793	8743500.0
2011-03-22	TLT	Stock	92.81	93.29	92.7399	93.22	6905503.0
2011-03-22	ES	Stock	34.28	34.38	34.07	34.16	1046300.0
2011-03-22	CL	Stock	39.195	39.575	39.085	39.215	4960600.0
2011-03-22	A	Stock	31.4092	31.4378	30.5794	30.8941	3381622.0
2011-03-22	AABA-DELISTED	Stock	16.32	16.48	16.16	16.355	26795497.0
2011-03-22	AACC-DELISTED	Stock	5.49	5.5	5.4	5.44	8378.0
2011-03-22	AACG	Stock	8.0	8.0	7.86	7.91	4800.0
2011-03-22	AAI-DELISTED	Stock	7.36	7.37	7.3	7.31	4923923.0
2011-03-22	AAIC-DELISTED	Stock	28.74	28.75	27.92	28.45	39646.0
2011-03-22	AAME	Stock	2.17	2.24	2.13	2.2	12400.0
2011-03-22	AAON	Stock	6.1452	6.2479	6.0978	6.1965	165544.0
2011-03-22	AAP	Stock	64.98	65.42	64.92	64.99	1052300.0
2011-03-22	AAT	Stock	21.54	21.55	21.06	21.5	115900.0
2011-03-22	AATI-DELISTED	Stock	3.62	3.68	3.6	3.68	62012.0
2011-03-22	AAU-DELISTED	Stock	3.88	4.0701	3.84	3.96	755428.0
2011-03-22	AAUAF-DELISTED	Stock	3.88	4.0701	3.84	3.95	756428.0
2011-03-22	AAV-DELISTED	Stock	8.47	8.48	8.31	8.33	322377.0
2011-03-22	AAWW-DELISTED	Stock	67.15	67.44	64.95	66.23	515722.0
2011-03-22	AAXJ	Stock	60.56	60.56	60.12	60.15	275689.0
2011-03-22	AAXN-DELISTED	Stock	3.82	3.84	3.73	3.73	388263.0
2011-03-22	AB	Stock	21.74	21.86	21.59	21.69	630600.0
2011-03-22	ABAC-DELISTED	Stock	4.4301	4.5392	4.31	4.4	32944.0
2011-03-22	ABAX-DELISTED	Stock	29.64	31.45	29.51	30.57	340172.0
2011-03-22	ABB-DELISTED	Stock	23.57	23.6	23.36	23.45	1946776.0
2011-03-22	ABBC-DELISTED	Stock	12.0	12.02	11.85	11.85	43540.0
2011-03-22	ABBNY-DELISTED	Stock	23.58	23.6	23.36	23.43	1947366.0
2011-03-22	ABC-DELISTED	Stock	37.9	38.45	37.9	38.319	2609168.0
2011-03-22	ABCB	Stock	9.99	9.99	9.84	9.9	18200.0
2011-03-22	ABCD-DELISTED	Stock	3.43	3.43	3.36	3.39	7507.0
2011-03-22	ABCO-DELISTED	Stock	24.81	25.19	24.68	25.03	108296.0
2011-03-22	ABCW-DELISTED	Stock	1.05	1.05	0.96	0.99	150240.0
2011-03-22	ABD-DELISTED	Stock	8.98	9.09	8.9	9.0	257480.0
2011-03-22	ABE-DELISTED	Stock	17.91	17.92	17.88	17.92	3029.0
2011-03-22	ABEO	Stock	2337.5	2437.5	2262.5	2437.5	14.0
2011-03-22	ABFS-DELISTED	Stock	25.22	25.42	24.51	24.62	449362.0
2011-03-22	ABG	Stock	18.26	18.38	17.35	17.45	458100.0
2011-03-22	ABH-DELISTED	Stock	27.35	27.44	26.86	26.98	474039.0
2011-03-22	ABM	Stock	25.21	25.45	25.14	25.17	167700.0
2011-03-22	ABMD-DELISTED	Stock	14.33	14.55	14.27	14.49	118214.0
2011-03-22	ABR	Stock	5.78	5.88	5.71	5.74	22100.0
2011-03-22	ABT	Stock	23.0064	23.1072	22.8625	23.0112	13636307.0
2011-03-22	ABTL-DELISTED	Stock	5.65	5.95	5.6	5.9	46982.0
2011-03-22	ABUS	Stock	3.58	3.6	3.48	3.58	10500.0
2011-03-22	ABV-DELISTED	Stock	27.21	27.44	26.91	27.36	2268009.0
2011-03-22	ABVT-DELISTED	Stock	62.72	63.57	62.51	63.1	48296.0

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

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