PREVIEW / stock_daily / 2011-08-24

all stock daily files

  file:    by_date/stock_daily/2011/2011-08-24.parquet
  size:    193 KB
  rows:    6,074
  symbols: 3,514

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-08-24	AAPL	Stock	13.3382	13.5343	13.2357	13.435	626267600.0
2011-08-24	MSFT	Stock	24.65	24.93	24.42	24.9	45329700.0
2011-08-24	NVDA	Stock	0.33	0.331	0.3175	0.326	687500000.0
2011-08-24	AMZN	Stock	9.6945	9.8155	9.5085	9.6865	124974000.0
2011-08-24	TSLA	Stock	1.54	1.5953	1.522	1.5913	10264500.0
2011-08-24	TLT	Stock	109.29	109.41	106.15	106.28	14621994.0
2011-08-24	ES	Stock	33.1	34.37	33.01	34.26	2478900.0
2011-08-24	CL	Stock	43.455	43.74	43.17	43.65	6631600.0
2011-08-24	A	Stock	22.7897	23.6981	22.5751	23.6624	7933370.0
2011-08-24	AABA-DELISTED	Stock	13.28	13.3	12.79	13.15	24635511.0
2011-08-24	AACC-DELISTED	Stock	4.1	4.11	3.95	3.95	32275.0
2011-08-24	AACG	Stock	8.42	8.59	8.42	8.5	2100.0
2011-08-24	AAIC-DELISTED	Stock	25.03	25.7	24.84	25.68	52661.0
2011-08-24	AAME	Stock	1.87	1.91	1.87	1.91	500.0
2011-08-24	AAON	Stock	4.7437	4.9867	4.717	4.96	247050.0
2011-08-24	AAP	Stock	57.97	59.2	57.75	59.14	1317300.0
2011-08-24	AAT	Stock	19.12	19.59	18.96	19.07	125900.0
2011-08-24	AATI-DELISTED	Stock	5.9	5.95	5.85	5.9	337169.0
2011-08-24	AAU-DELISTED	Stock	3.1	3.1	2.85	3.0	375347.0
2011-08-24	AAUAF-DELISTED	Stock	3.1	3.1	2.85	3.01	376639.0
2011-08-24	AAV-DELISTED	Stock	5.44	5.59	5.4	5.54	546220.0
2011-08-24	AAWW-DELISTED	Stock	43.33	44.88	42.9	44.69	208685.0
2011-08-24	AAXJ	Stock	53.57	54.24	53.35	54.19	221671.0
2011-08-24	AAXN-DELISTED	Stock	4.09	4.27	4.0207	4.25	452303.0
2011-08-24	AB	Stock	14.52	15.35	14.52	15.27	406600.0
2011-08-24	ABAC-DELISTED	Stock	2.3	2.3	2.18	2.2	4800.0
2011-08-24	ABAX-DELISTED	Stock	23.64	24.61	23.53	24.45	153717.0
2011-08-24	ABB-DELISTED	Stock	20.47	20.82	20.2187	20.59	2958961.0
2011-08-24	ABBC-DELISTED	Stock	8.04	8.33	8.04	8.29	24518.0
2011-08-24	ABBNY-DELISTED	Stock	20.46	20.82	20.2187	20.59	2961261.0
2011-08-24	ABC-DELISTED	Stock	38.13	38.43	37.48	38.17	3089365.0
2011-08-24	ABCB	Stock	8.97	9.28	8.81	9.18	190300.0
2011-08-24	ABCD-DELISTED	Stock	2.89	2.94	2.81	2.9	53659.0
2011-08-24	ABCO-DELISTED	Stock	29.99	30.47	29.77	30.29	161690.0
2011-08-24	ABCW-DELISTED	Stock	0.69	0.69	0.63	0.63	12090.0
2011-08-24	ABD-DELISTED	Stock	5.96	6.22	5.92	6.13	160900.0
2011-08-24	ABE-DELISTED	Stock	18.23	18.31	17.989	18.31	7915.0
2011-08-24	ABEO	Stock	2562.5	2600.0	2375.0	2500.0	2.0
2011-08-24	ABFS-DELISTED	Stock	19.0	19.48	18.67	19.36	149606.0
2011-08-24	ABG	Stock	17.17	17.96	17.05	17.72	464200.0
2011-08-24	ABH-DELISTED	Stock	16.05	16.29	15.91	16.05	338790.0
2011-08-24	ABM	Stock	19.52	20.01	19.31	20.0	205600.0
2011-08-24	ABMD-DELISTED	Stock	11.78	12.21	11.63	12.11	190550.0
2011-08-24	ABR	Stock	3.96	4.05	3.92	4.01	68800.0
2011-08-24	ABT	Stock	24.1243	24.5274	24.062	24.5226	14460400.0
2011-08-24	ABTL-DELISTED	Stock	4.4434	4.6451	4.2442	4.2566	29793.0
2011-08-24	ABUS	Stock	1.9	1.95	1.8	1.9	33500.0
2011-08-24	ABV-DELISTED	Stock	33.43	34.14	33.15	33.72	3694538.0
2011-08-24	ABVA-DELISTED	Stock	4.93	5.0	4.731	4.83	8350.0
2011-08-24	ABVT-DELISTED	Stock	57.06	58.91	56.93	58.58	122417.0

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

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