PREVIEW / stock_daily / 2011-05-23

all stock daily files

  file:    by_date/stock_daily/2011/2011-05-23.parquet
  size:    197 KB
  rows:    6,106
  symbols: 3,540

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-05-23	AAPL	Stock	11.7846	11.9993	11.765	11.9429	383600000.0
2011-05-23	MSFT	Stock	24.21	24.25	24.03	24.17	52692500.0
2011-05-23	NVDA	Stock	0.4458	0.455	0.44	0.4518	588000000.0
2011-05-23	AMZN	Stock	9.778	9.8645	9.601	9.811	84000000.0
2011-05-23	TSLA	Stock	1.8413	1.8413	1.7747	1.788	12954000.0
2011-05-23	TLT	Stock	95.73	96.19	95.59	95.78	6346041.0
2011-05-23	ES	Stock	35.86	35.86	35.46	35.48	1231000.0
2011-05-23	CL	Stock	43.095	43.285	42.835	43.035	4220800.0
2011-05-23	A	Stock	35.6295	35.6295	34.6924	35.1216	5963588.0
2011-05-23	AABA-DELISTED	Stock	16.05	16.17	16.0	16.07	19086215.0
2011-05-23	AACC-DELISTED	Stock	4.3	4.34	4.06	4.1	19834.0
2011-05-23	AACG	Stock	10.35	10.35	9.51	9.98	40600.0
2011-05-23	AAIC-DELISTED	Stock	26.9	27.05	26.55	26.55	102906.0
2011-05-23	AAME	Stock	2.04	2.05	1.96	2.0	11700.0
2011-05-23	AAON	Stock	6.3328	6.4612	6.3328	6.4	163519.0
2011-05-23	AAP	Stock	62.34	63.45	61.91	62.99	1072900.0
2011-05-23	AAT	Stock	21.63	21.66	21.15	21.18	182700.0
2011-05-23	AATI-DELISTED	Stock	3.71	3.78	3.6	3.62	191571.0
2011-05-23	AAU-DELISTED	Stock	3.66	3.8906	3.58	3.67	216211.0
2011-05-23	AAUAF-DELISTED	Stock	3.65	3.88	3.57	3.68	217000.0
2011-05-23	AAV-DELISTED	Stock	7.86	7.9699	7.83	7.9	143461.0
2011-05-23	AAWW-DELISTED	Stock	63.47	63.78	60.87	61.395	206114.0
2011-05-23	AAXJ	Stock	61.32	61.3622	60.93	61.26	684086.0
2011-05-23	AAXN-DELISTED	Stock	4.4	4.57	4.35	4.49	383163.0
2011-05-23	AB	Stock	21.37	21.44	21.11	21.16	524200.0
2011-05-23	ABAC-DELISTED	Stock	2.96	2.96	2.77	2.84	19825.0
2011-05-23	ABAX-DELISTED	Stock	30.42	30.42	29.51	29.86	90104.0
2011-05-23	ABB-DELISTED	Stock	25.52	25.77	25.45	25.68	3730391.0
2011-05-23	ABBC-DELISTED	Stock	11.21	11.34	11.11	11.27	76012.0
2011-05-23	ABBNY-DELISTED	Stock	25.52	25.77	25.45	25.69	4132341.0
2011-05-23	ABC-DELISTED	Stock	41.14	41.48	40.91	41.36	2166710.0
2011-05-23	ABCB	Stock	8.84	8.94	8.74	8.74	42800.0
2011-05-23	ABCD-DELISTED	Stock	2.93	2.99	2.85	2.86	22511.0
2011-05-23	ABCO-DELISTED	Stock	25.14	25.64	24.89	25.11	187285.0
2011-05-23	ABCW-DELISTED	Stock	0.84	0.84	0.8	0.83	12840.0
2011-05-23	ABD-DELISTED	Stock	8.535	8.535	8.275	8.285	223420.0
2011-05-23	ABE-DELISTED	Stock	18.38	18.48	18.3	18.319	4722.0
2011-05-23	ABEO	Stock	2750.0	2750.0	2562.5	2675.0	10.0
2011-05-23	ABFS-DELISTED	Stock	24.84	24.99	24.01	24.36	469089.0
2011-05-23	ABG	Stock	15.56	16.03	15.45	16.0	262600.0
2011-05-23	ABH-DELISTED	Stock	24.36	24.37	23.15	23.25	1145521.0
2011-05-23	ABM	Stock	22.92	23.17	22.84	22.96	386400.0
2011-05-23	ABMD-DELISTED	Stock	17.6	17.94	17.55	17.91	433572.0
2011-05-23	ABR	Stock	4.88	4.94	4.81	4.84	24400.0
2011-05-23	ABT	Stock	25.4102	25.6645	25.3526	25.5494	12916424.0
2011-05-23	ABTL-DELISTED	Stock	5.3	5.75	5.3	5.6	29757.0
2011-05-23	ABUS	Stock	2.78	2.78	2.71	2.72	500.0
2011-05-23	ABV-DELISTED	Stock	30.53	31.0	30.43	30.91	1331133.0
2011-05-23	ABVA-DELISTED	Stock	5.39	5.56	5.39	5.53	3379.0
2011-05-23	ABVT-DELISTED	Stock	63.29	63.82	63.0401	63.41	113655.0

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

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