PREVIEW / stock_daily / 2011-04-19

all stock daily files

  file:    by_date/stock_daily/2011/2011-04-19.parquet
  size:    197 KB
  rows:    6,075
  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-04-19	AAPL	Stock	11.8964	12.0707	11.8468	12.0664	419378400.0
2011-04-19	MSFT	Stock	25.0	25.17	24.87	25.15	38892400.0
2011-04-19	NVDA	Stock	0.4525	0.4542	0.4382	0.4505	659860000.0
2011-04-19	AMZN	Stock	8.9175	8.9735	8.83	8.941	52920000.0
2011-04-19	TSLA	Stock	1.684	1.684	1.6433	1.6773	8230500.0
2011-04-19	TLT	Stock	92.86	93.28	92.76	93.28	5295431.0
2011-04-19	ES	Stock	33.52	33.67	33.44	33.65	1378800.0
2011-04-19	CL	Stock	40.655	40.785	40.475	40.71	5560200.0
2011-04-19	A	Stock	33.412	33.4764	33.1187	33.4335	6125197.0
2011-04-19	AABA-DELISTED	Stock	16.23	16.36	16.08	16.12	30521452.0
2011-04-19	AACC-DELISTED	Stock	5.36	5.45	5.24	5.32	7412.0
2011-04-19	AACG	Stock	7.44	7.73	7.4	7.58	13400.0
2011-04-19	AAI-DELISTED	Stock	7.36	7.38	7.35	7.35	1741935.0
2011-04-19	AAIC-DELISTED	Stock	29.42	29.47	28.75	28.91	45038.0
2011-04-19	AAME	Stock	2.05	2.05	1.93	2.04	2200.0
2011-04-19	AAON	Stock	6.2202	6.3447	6.2202	6.3427	136687.0
2011-04-19	AAP	Stock	64.75	65.11	64.52	65.0	872000.0
2011-04-19	AAT	Stock	21.27	21.3	21.1	21.25	100400.0
2011-04-19	AATI-DELISTED	Stock	4.31	4.31	4.18	4.19	79873.0
2011-04-19	AAU-DELISTED	Stock	4.4	4.43	4.2	4.28	225541.0
2011-04-19	AAUAF-DELISTED	Stock	4.4	4.43	4.2	4.28	225841.0
2011-04-19	AAV-DELISTED	Stock	8.33	8.3701	8.24	8.29	314336.0
2011-04-19	AAWW-DELISTED	Stock	63.48	64.28	60.83	62.01	351006.0
2011-04-19	AAXJ	Stock	63.26	63.43	62.99	63.41	151612.0
2011-04-19	AAXN-DELISTED	Stock	3.9	4.06	3.88	3.89	631428.0
2011-04-19	AB	Stock	21.71	21.71	21.22	21.34	261100.0
2011-04-19	ABAC-DELISTED	Stock	3.35	3.45	3.35	3.4	44412.0
2011-04-19	ABAX-DELISTED	Stock	28.47	28.69	28.11	28.25	114481.0
2011-04-19	ABB-DELISTED	Stock	24.21	24.22	23.93	23.99	2489075.0
2011-04-19	ABBC-DELISTED	Stock	12.16	12.16	11.842	11.92	34151.0
2011-04-19	ABBNY-DELISTED	Stock	24.2	24.22	23.93	24.01	2603375.0
2011-04-19	ABC-DELISTED	Stock	39.5	39.82	39.45	39.77	1868371.0
2011-04-19	ABCB	Stock	9.63	9.63	9.36	9.47	39800.0
2011-04-19	ABCD-DELISTED	Stock	3.28	3.29	3.25	3.27	10696.0
2011-04-19	ABCO-DELISTED	Stock	23.66	23.73	22.93	22.97	104312.0
2011-04-19	ABCW-DELISTED	Stock	0.86	0.91	0.85	0.91	56170.0
2011-04-19	ABD-DELISTED	Stock	9.47	9.66	9.33	9.61	141710.0
2011-04-19	ABE-DELISTED	Stock	18.68	18.85	18.59	18.84	3400.0
2011-04-19	ABEO	Stock	2562.5	2875.0	2562.5	2875.0	4.0
2011-04-19	ABFS-DELISTED	Stock	25.24	25.64	25.16	25.16	237616.0
2011-04-19	ABG	Stock	16.81	16.99	16.51	16.67	144200.0
2011-04-19	ABH-DELISTED	Stock	25.48	25.82	25.36	25.68	269449.0
2011-04-19	ABM	Stock	24.24	24.3	23.99	24.15	168900.0
2011-04-19	ABMD-DELISTED	Stock	16.72	16.76	16.5	16.6	492482.0
2011-04-19	ABR	Stock	5.19	5.23	5.12	5.17	57700.0
2011-04-19	ABT	Stock	24.4986	24.5802	24.4266	24.513	16817424.0
2011-04-19	ABTL-DELISTED	Stock	6.6015	6.7985	6.4537	6.7	43686.0
2011-04-19	ABUS	Stock	2.7	2.72	2.7	2.72	600.0
2011-04-19	ABV-DELISTED	Stock	30.27	31.09	30.24	31.07	2250001.0
2011-04-19	ABVA-DELISTED	Stock	6.15	6.4	6.15	6.26	14367.0

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

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