PREVIEW / stock_daily / 2011-11-21

all stock daily files

  file:    by_date/stock_daily/2011/2011-11-21.parquet
  size:    195 KB
  rows:    6,117
  symbols: 3,535

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-11-21	AAPL	Stock	13.2286	13.2743	13.0682	13.1789	447980400.0
2011-11-21	MSFT	Stock	25.24	25.25	24.9	25.0	61882500.0
2011-11-21	NVDA	Stock	0.3428	0.3692	0.3375	0.3658	1330788000.0
2011-11-21	AMZN	Stock	9.6645	9.668	9.2525	9.4625	226424000.0
2011-11-21	TSLA	Stock	2.1627	2.1627	2.07	2.1173	15474000.0
2011-11-21	TLT	Stock	120.38	120.73	119.91	120.05	7345739.0
2011-11-21	ES	Stock	34.16	34.18	33.38	33.79	2194900.0
2011-11-21	CL	Stock	43.76	44.115	43.495	43.72	4075200.0
2011-11-21	A	Stock	25.6152	25.7439	24.9499	25.6009	5598850.0
2011-11-21	AABA-DELISTED	Stock	15.19	15.19	14.77	14.99	22702275.0
2011-11-21	AACC-DELISTED	Stock	2.95	3.14	2.82	2.85	74389.0
2011-11-21	AACG	Stock	9.6	9.6	9.22	9.32	19200.0
2011-11-21	AAIC-DELISTED	Stock	21.15	21.2	20.37	20.43	75789.0
2011-11-21	AAME	Stock	1.88	1.9	1.84	1.88	5200.0
2011-11-21	AAON	Stock	6.1304	6.2193	6.0119	6.0296	118463.0
2011-11-21	AAP	Stock	66.89	67.92	66.58	67.54	677600.0
2011-11-21	AAT	Stock	20.5	20.73	19.78	20.68	402800.0
2011-11-21	AATI-DELISTED	Stock	4.19	4.38	4.19	4.31	743533.0
2011-11-21	AAU-DELISTED	Stock	2.49	2.54	2.4	2.471	252406.0
2011-11-21	AAUAF-DELISTED	Stock	2.49	2.54	2.4	2.47	249862.0
2011-11-21	AAV-DELISTED	Stock	4.95	5.0	4.81	4.89	471378.0
2011-11-21	AAWW-DELISTED	Stock	38.67	39.74	37.62	38.16	354793.0
2011-11-21	AAXJ	Stock	49.58	49.61	48.72	49.01	371027.0
2011-11-21	AAXN-DELISTED	Stock	5.74	5.91	5.68	5.87	417539.0
2011-11-21	AB	Stock	13.02	13.31	13.02	13.13	485700.0
2011-11-21	ABAC-DELISTED	Stock	1.7501	1.94	1.75	1.94	9145.0
2011-11-21	ABAX-DELISTED	Stock	25.95	26.24	25.69	25.86	63502.0
2011-11-21	ABB-DELISTED	Stock	17.33	17.39	17.06	17.28	2618554.0
2011-11-21	ABBNY-DELISTED	Stock	17.33	17.39	17.06	17.26	2621989.0
2011-11-21	ABC-DELISTED	Stock	36.9	36.99	36.26	36.7	2264920.0
2011-11-21	ABCB	Stock	9.83	9.99	9.65	9.65	52200.0
2011-11-21	ABCD-DELISTED	Stock	2.96	3.04	2.88	2.88	43436.0
2011-11-21	ABCO-DELISTED	Stock	33.92	34.23	33.87	34.05	142214.0
2011-11-21	ABCW-DELISTED	Stock	0.3	0.3938	0.25	0.34	455490.0
2011-11-21	ABD-DELISTED	Stock	8.8	9.029	8.64	8.98	599390.0
2011-11-21	ABE-DELISTED	Stock	17.6	17.63	17.35	17.36	8394.0
2011-11-21	ABEO	Stock	1662.5	1675.0	1625.0	1675.0	81.0
2011-11-21	ABFS-DELISTED	Stock	18.87	18.9799	18.0	18.19	485842.0
2011-11-21	ABG	Stock	18.68	19.06	18.49	18.91	275200.0
2011-11-21	ABH-DELISTED	Stock	16.1	16.43	15.79	16.01	393636.0
2011-11-21	ABM	Stock	19.99	20.46	19.89	20.16	279200.0
2011-11-21	ABMD-DELISTED	Stock	17.99	18.24	17.52	17.82	305855.0
2011-11-21	ABR	Stock	3.56	3.61	3.56	3.57	15200.0
2011-11-21	ABT	Stock	25.3142	25.5685	25.2423	25.319	13070238.0
2011-11-21	ABUS	Stock	1.47	1.68	1.47	1.55	3000.0
2011-11-21	ABV-DELISTED	Stock	32.41	32.44	31.81	32.06	2511564.0
2011-11-21	ABVA-DELISTED	Stock	5.15	5.2	5.06	5.08	21501.0
2011-11-21	ABVT-DELISTED	Stock	56.51	56.71	55.676	56.46	63327.0
2011-11-21	ABX-DELISTED	Stock	48.29	48.34	47.34	48.08	7490129.0
2011-11-21	ACAD	Stock	1.03	1.04	1.0	1.04	146400.0

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

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