PREVIEW / stock_daily / 2011-10-07

all stock daily files

  file:    by_date/stock_daily/2011/2011-10-07.parquet
  size:    192 KB
  rows:    6,053
  symbols: 3,496

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-10-07	AAPL	Stock	13.4207	13.4907	13.1604	13.2071	535458000.0
2011-10-07	MSFT	Stock	26.34	26.51	26.2	26.25	52741600.0
2011-10-07	NVDA	Stock	0.3488	0.359	0.3415	0.3538	806976000.0
2011-10-07	AMZN	Stock	11.124	11.395	10.9205	11.237	135686000.0
2011-10-07	TSLA	Stock	1.7987	1.84	1.7367	1.7993	19674000.0
2011-10-07	TLT	Stock	117.75	119.05	116.85	118.24	11564527.0
2011-10-07	ES	Stock	32.1	32.47	31.87	32.05	2482000.0
2011-10-07	CL	Stock	45.32	45.625	45.03	45.205	3892200.0
2011-10-07	A	Stock	23.1044	23.3476	21.7668	22.4392	11309261.0
2011-10-07	AABA-DELISTED	Stock	15.64	15.75	15.38	15.48	27451703.0
2011-10-07	AACC-DELISTED	Stock	3.06	3.07	2.8	3.05	36099.0
2011-10-07	AACG	Stock	9.0	9.0	8.99	8.99	1900.0
2011-10-07	AAIC-DELISTED	Stock	25.18	25.18	23.7	23.87	37863.0
2011-10-07	AAME	Stock	1.79	1.83	1.7	1.83	3100.0
2011-10-07	AAON	Stock	5.3689	5.4044	5.0874	5.1319	426600.0
2011-10-07	AAP	Stock	59.65	60.05	58.69	59.04	509900.0
2011-10-07	AAT	Stock	17.9	18.24	17.35	17.41	197000.0
2011-10-07	AATI-DELISTED	Stock	4.44	4.47	4.14	4.35	229894.0
2011-10-07	AAU-DELISTED	Stock	2.67	2.72	2.46	2.53	204944.0
2011-10-07	AAUAF-DELISTED	Stock	2.67	2.72	2.46	2.53	205444.0
2011-10-07	AAV-DELISTED	Stock	4.3	4.3	3.95	4.02	394709.0
2011-10-07	AAWW-DELISTED	Stock	35.3	35.31	32.65	33.39	351365.0
2011-10-07	AAXJ	Stock	48.84	48.84	47.64	47.89	332667.0
2011-10-07	AAXN-DELISTED	Stock	4.47	4.53	4.36	4.44	383162.0
2011-10-07	AB	Stock	13.98	13.99	13.17	13.35	259500.0
2011-10-07	ABAC-DELISTED	Stock	1.89	1.89	1.76	1.83	11257.0
2011-10-07	ABAX-DELISTED	Stock	23.7	23.7	22.83	22.95	109242.0
2011-10-07	ABB-DELISTED	Stock	17.7	17.94	17.59	17.66	4513514.0
2011-10-07	ABBNY-DELISTED	Stock	17.7	17.94	17.59	17.65	4812898.0
2011-10-07	ABC-DELISTED	Stock	36.21	36.42	35.33	35.75	3393190.0
2011-10-07	ABCB	Stock	9.35	9.36	8.91	8.95	69000.0
2011-10-07	ABCD-DELISTED	Stock	2.99	3.052	2.96	2.98	67238.0
2011-10-07	ABCO-DELISTED	Stock	30.75	30.75	29.83	29.98	217798.0
2011-10-07	ABCW-DELISTED	Stock	0.5295	0.5495	0.4895	0.4905	59140.0
2011-10-07	ABD-DELISTED	Stock	5.2003	5.2604	4.9397	4.9397	357620.0
2011-10-07	ABE-DELISTED	Stock	17.33	17.33	16.98	16.98	1661.0
2011-10-07	ABEO	Stock	2187.5	2250.0	1937.5	2187.5	8.0
2011-10-07	ABFS-DELISTED	Stock	16.77	16.93	16.0	16.08	417424.0
2011-10-07	ABG	Stock	18.45	18.77	17.66	17.86	293700.0
2011-10-07	ABH-DELISTED	Stock	15.7	15.7	15.2	15.3	222933.0
2011-10-07	ABM	Stock	19.75	19.91	18.88	19.1	184200.0
2011-10-07	ABMD-DELISTED	Stock	11.61	11.75	11.25	11.41	171579.0
2011-10-07	ABR	Stock	3.31	3.37	3.21	3.22	84800.0
2011-10-07	ABT	Stock	24.7529	24.9496	24.6569	24.7241	59821175.0
2011-10-07	ABTL-DELISTED	Stock	4.6	4.7885	4.25	4.3	31440.0
2011-10-07	ABUS	Stock	1.84	1.84	1.8	1.8	1300.0
2011-10-07	ABV-DELISTED	Stock	32.34	33.12	32.0	32.06	3298949.0
2011-10-07	ABVT-DELISTED	Stock	55.89	56.69	54.64	54.72	125752.0
2011-10-07	ABX-DELISTED	Stock	48.55	48.62	46.29	46.63	5636384.0
2011-10-07	ACAD	Stock	1.02	1.02	0.97	0.99	542400.0

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

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