PREVIEW / stock_daily / 2011-11-28

all stock daily files

  file:    by_date/stock_daily/2011/2011-11-28.parquet
  size:    195 KB
  rows:    6,142
  symbols: 3,555

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-28	AAPL	Stock	13.2982	13.4543	13.2261	13.4329	346413200.0
2011-11-28	MSFT	Stock	24.94	24.97	24.69	24.87	46766700.0
2011-11-28	NVDA	Stock	0.3625	0.3763	0.3625	0.3708	690616000.0
2011-11-28	AMZN	Stock	9.5825	9.731	9.527	9.7075	144146000.0
2011-11-28	TSLA	Stock	2.1333	2.2187	2.1207	2.1707	10218000.0
2011-11-28	TLT	Stock	118.63	121.15	118.58	120.74	7661838.0
2011-11-28	ES	Stock	33.88	34.05	33.24	33.4	1304100.0
2011-11-28	CL	Stock	44.05	44.3	43.9	44.14	3898600.0
2011-11-28	A	Stock	25.1288	25.6652	24.8355	25.1502	4303044.0
2011-11-28	AABA-DELISTED	Stock	15.24	15.47	15.21	15.36	18753664.0
2011-11-28	AACC-DELISTED	Stock	3.03	3.14	3.02	3.03	19980.0
2011-11-28	AACG	Stock	9.44	9.51	9.4	9.41	4600.0
2011-11-28	AAIC-DELISTED	Stock	19.79	20.16	19.45	19.74	62875.0
2011-11-28	AAME	Stock	1.99	2.0	1.97	2.0	5400.0
2011-11-28	AAON	Stock	5.8785	6.1215	5.8015	6.1185	232538.0
2011-11-28	AAP	Stock	68.54	69.1	66.93	67.3	718900.0
2011-11-28	AAT	Stock	20.18	20.48	19.94	20.25	398000.0
2011-11-28	AATI-DELISTED	Stock	4.45	4.45	4.29	4.34	289040.0
2011-11-28	AAU-DELISTED	Stock	2.58	2.61	2.4907	2.55	137185.0
2011-11-28	AAUAF-DELISTED	Stock	2.61	2.64	2.52	2.55	136191.0
2011-11-28	AAV-DELISTED	Stock	4.49	4.62	4.37	4.42	348380.0
2011-11-28	AAWW-DELISTED	Stock	36.14	38.26	34.36	36.89	302754.0
2011-11-28	AAXJ	Stock	49.86	50.08	49.615	49.94	427589.0
2011-11-28	AAXN-DELISTED	Stock	5.76	5.95	5.6	5.88	661765.0
2011-11-28	AB	Stock	13.06	13.47	12.8	13.07	428600.0
2011-11-28	ABAC-DELISTED	Stock	1.83	1.9	1.7996	1.88	3400.0
2011-11-28	ABAX-DELISTED	Stock	25.32	26.12	25.32	25.72	77673.0
2011-11-28	ABB-DELISTED	Stock	17.64	17.73	17.555	17.68	2501957.0
2011-11-28	ABBNY-DELISTED	Stock	17.63	17.73	17.555	17.68	2506494.0
2011-11-28	ABC-DELISTED	Stock	36.86	37.09	36.24	36.45	1615719.0
2011-11-28	ABCB	Stock	9.48	9.61	9.33	9.61	62400.0
2011-11-28	ABCD-DELISTED	Stock	2.79	2.93	2.74	2.88	79997.0
2011-11-28	ABCO-DELISTED	Stock	34.03	34.83	34.03	34.78	193218.0
2011-11-28	ABCW-DELISTED	Stock	0.3615	0.3866	0.3514	0.3815	141520.0
2011-11-28	ABD-DELISTED	Stock	8.79	9.0	8.69	8.85	439630.0
2011-11-28	ABE-DELISTED	Stock	17.76	17.92	17.61	17.61	1301.0
2011-11-28	ABEO	Stock	1687.5	1687.5	1625.0	1662.5	16.0
2011-11-28	ABFS-DELISTED	Stock	17.59	18.18	17.59	18.06	432823.0
2011-11-28	ABG	Stock	19.02	19.24	18.61	18.89	345900.0
2011-11-28	ABH-DELISTED	Stock	15.38	15.63	15.09	15.3	137469.0
2011-11-28	ABM	Stock	20.4	21.28	20.25	21.2	480000.0
2011-11-28	ABMD-DELISTED	Stock	17.88	18.46	17.338	18.44	232807.0
2011-11-28	ABR	Stock	3.58	3.58	3.39	3.49	32200.0
2011-11-28	ABT	Stock	25.2807	25.5446	25.2615	25.5254	11667570.0
2011-11-28	ABTL-DELISTED	Stock	3.9995	4.001	3.6605	3.9505	19176.0
2011-11-28	ABUS	Stock	1.45	1.6	1.45	1.59	13300.0
2011-11-28	ABV-DELISTED	Stock	32.14	32.45	32.0	32.43	2252968.0
2011-11-28	ABVA-DELISTED	Stock	5.14	5.22	5.05	5.22	22803.0
2011-11-28	ABVT-DELISTED	Stock	55.58	57.02	55.2	56.24	207348.0
2011-11-28	ABX-DELISTED	Stock	49.72	50.42	49.29	49.54	6226781.0

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

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