PREVIEW / stock_daily / 2011-07-22

all stock daily files

  file:    by_date/stock_daily/2011/2011-07-22.parquet
  size:    198 KB
  rows:    6,116
  symbols: 3,549

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-07-22	AAPL	Stock	13.8686	14.1089	13.8482	14.0464	516728800.0
2011-07-22	MSFT	Stock	26.86	27.55	26.68	27.53	76380600.0
2011-07-22	NVDA	Stock	0.3708	0.3763	0.366	0.375	737192000.0
2011-07-22	AMZN	Stock	10.693	10.8975	10.5555	10.826	71834000.0
2011-07-22	TSLA	Stock	1.9133	1.9693	1.9033	1.9527	8752500.0
2011-07-22	TLT	Stock	95.69	96.09	95.53	96.05	4974442.0
2011-07-22	ES	Stock	35.35	35.36	35.1	35.34	1146900.0
2011-07-22	CL	Stock	44.14	44.21	43.725	43.81	3446000.0
2011-07-22	A	Stock	33.5837	33.7196	33.2761	33.5408	2894140.0
2011-07-22	AABA-DELISTED	Stock	13.65	14.05	13.57	13.97	30106263.0
2011-07-22	AACC-DELISTED	Stock	4.56	4.56	4.5	4.5	13600.0
2011-07-22	AACG	Stock	10.41	10.41	10.16	10.16	500.0
2011-07-22	AAIC-DELISTED	Stock	31.67	31.67	31.4	31.55	35075.0
2011-07-22	AAME	Stock	2.05	2.05	1.95	2.04	10900.0
2011-07-22	AAON	Stock	7.04	7.1111	6.9541	7.0222	108000.0
2011-07-22	AAP	Stock	54.96	56.05	54.78	55.87	1108600.0
2011-07-22	AAT	Stock	22.31	22.4	22.17	22.26	92100.0
2011-07-22	AATI-DELISTED	Stock	6.08	6.09	6.08	6.08	504229.0
2011-07-22	AAU-DELISTED	Stock	3.93	3.93	3.89	3.92	91826.0
2011-07-22	AAUAF-DELISTED	Stock	3.94	3.94	3.9	3.91	92031.0
2011-07-22	AAV-DELISTED	Stock	7.58	7.6	7.5	7.54	282932.0
2011-07-22	AAWW-DELISTED	Stock	54.48	56.76	54.25	56.07	258052.0
2011-07-22	AAXJ	Stock	62.8	62.97	62.52	62.85	203802.0
2011-07-22	AAXN-DELISTED	Stock	4.27	4.28	4.21	4.22	151851.0
2011-07-22	AB	Stock	18.47	18.76	18.41	18.62	231700.0
2011-07-22	ABAC-DELISTED	Stock	2.86	2.94	2.84	2.84	17550.0
2011-07-22	ABAX-DELISTED	Stock	30.0	30.23	29.77	29.94	71283.0
2011-07-22	ABB-DELISTED	Stock	24.76	24.84	24.47	24.58	2482523.0
2011-07-22	ABBC-DELISTED	Stock	10.45	10.45	10.21	10.35	10369.0
2011-07-22	ABBNY-DELISTED	Stock	24.76	24.84	24.47	24.57	2482643.0
2011-07-22	ABC-DELISTED	Stock	39.89	40.78	39.58	40.53	5575895.0
2011-07-22	ABCB	Stock	10.3	10.3	9.99	10.08	94600.0
2011-07-22	ABCD-DELISTED	Stock	3.37	3.37	3.3	3.33	3848.0
2011-07-22	ABCO-DELISTED	Stock	28.06	28.25	27.87	28.2	41908.0
2011-07-22	ABCW-DELISTED	Stock	0.6803	0.6997	0.6797	0.6797	40810.0
2011-07-22	ABD-DELISTED	Stock	7.46	7.5	7.37	7.39	144770.0
2011-07-22	ABE-DELISTED	Stock	19.28	19.45	19.25	19.45	9805.0
2011-07-22	ABEO	Stock	3062.5	3112.5	2937.5	3050.0	21.0
2011-07-22	ABFS-DELISTED	Stock	25.99	26.04	25.52	25.73	324865.0
2011-07-22	ABG	Stock	19.98	20.41	19.75	20.37	263500.0
2011-07-22	ABH-DELISTED	Stock	19.31	19.49	19.17	19.41	283923.0
2011-07-22	ABM	Stock	23.98	24.04	23.68	23.69	242100.0
2011-07-22	ABMD-DELISTED	Stock	17.28	17.33	16.7	16.9	114955.0
2011-07-22	ABR	Stock	4.53	4.73	4.53	4.63	19000.0
2011-07-22	ABT	Stock	25.3958	25.4438	25.2711	25.4054	10342643.0
2011-07-22	ABTL-DELISTED	Stock	5.15	5.3	5.0	5.3	27431.0
2011-07-22	ABUS	Stock	2.5	2.63	2.5	2.62	4100.0
2011-07-22	ABV-DELISTED	Stock	31.89	32.19	31.84	31.99	1665659.0
2011-07-22	ABVA-DELISTED	Stock	4.67	4.67	4.64	4.65	11800.0
2011-07-22	ABVT-DELISTED	Stock	63.99	64.25	62.77	63.48	143387.0

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

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