PREVIEW / stock_daily / 2013-09-23

all stock daily files

  file:    by_date/stock_daily/2013/2013-09-23.parquet
  size:    212 KB
  rows:    6,374
  symbols: 3,524

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
2013-09-23	AAPL	Stock	17.7179	17.7468	17.2357	17.5229	762106800.0
2013-09-23	MSFT	Stock	32.54	32.97	32.5	32.74	39826100.0
2013-09-23	NVDA	Stock	0.3945	0.3978	0.3888	0.391	271244000.0
2013-09-23	AMZN	Stock	15.7005	15.795	15.4385	15.5745	37698000.0
2013-09-23	META	Stock	47.28	47.55	46.29	47.19	75177000.0
2013-09-23	TSLA	Stock	12.2987	12.3653	11.8073	12.074	122601000.0
2013-09-23	TLT	Stock	105.21	105.73	105.11	105.69	10242010.0
2013-09-23	ES	Stock	40.99	41.79	40.88	41.63	1303500.0
2013-09-23	CL	Stock	60.45	60.47	59.94	60.2	1935500.0
2013-09-23	A	Stock	37.1316	37.3677	36.7525	36.9599	3798226.0
2013-09-23	AABA-DELISTED	Stock	31.05	31.05	30.02	30.27	15328383.0
2013-09-23	AACG	Stock	4.63	4.63	4.44	4.48	1200.0
2013-09-23	AAIC-DELISTED	Stock	25.9	26.22	25.87	26.01	234455.0
2013-09-23	AAMC-DELISTED	Stock	108.8235	111.7647	105.9294	111.7647	15854.0
2013-09-23	AAME	Stock	4.0	4.04	3.9	4.03	15200.0
2013-09-23	AAMRQ-DELISTED	Stock	3.925	3.96	3.85	3.95	7663412.0
2013-09-23	AAON	Stock	11.7467	11.7467	11.4889	11.6222	161550.0
2013-09-23	AAP	Stock	80.57	80.7	79.47	79.79	696200.0
2013-09-23	AAT	Stock	31.0	31.07	30.7	30.75	122100.0
2013-09-23	AAU-DELISTED	Stock	1.37	1.4	1.3151	1.33	255649.0
2013-09-23	AAUAF-DELISTED	Stock	1.38	1.401	1.32	1.32	255853.0
2013-09-23	AAV-DELISTED	Stock	3.62	3.62	3.55	3.59	90258.0
2013-09-23	AAWW-DELISTED	Stock	46.13	46.54	45.72	45.91	176116.0
2013-09-23	AAXJ	Stock	59.69	60.03	59.635	59.87	556205.0
2013-09-23	AAXN-DELISTED	Stock	14.83	14.85	14.21	14.51	1711199.0
2013-09-23	AB	Stock	20.95	21.44	20.38	20.41	256300.0
2013-09-23	ABAC-DELISTED	Stock	0.79	0.82	0.7499	0.798	24200.0
2013-09-23	ABAX-DELISTED	Stock	41.58	42.14	41.29	41.9	143349.0
2013-09-23	ABB-DELISTED	Stock	23.87	23.89	23.61	23.69	1814238.0
2013-09-23	ABBNY-DELISTED	Stock	23.87	23.89	23.61	23.68	1925426.0
2013-09-23	ABBV	Stock	47.56	47.56	46.93	47.1	3179500.0
2013-09-23	ABC-DELISTED	Stock	61.68	61.83	61.281	61.58	791375.0
2013-09-23	ABCB	Stock	18.86	18.97	18.74	18.94	51600.0
2013-09-23	ABCD-DELISTED	Stock	1.62	1.62	1.56	1.57	11878.0
2013-09-23	ABCO-DELISTED	Stock	60.4	60.4	58.87	60.09	181789.0
2013-09-23	ABE-DELISTED	Stock	20.12	20.12	19.76	19.9	2184.0
2013-09-23	ABEO	Stock	500.0	587.5	462.5	487.5	97.0
2013-09-23	ABFS-DELISTED	Stock	25.63	25.82	24.88	25.195	269923.0
2013-09-23	ABG	Stock	52.81	53.15	52.36	52.83	169200.0
2013-09-23	ABM	Stock	26.19	26.73	26.19	26.52	253300.0
2013-09-23	ABMD-DELISTED	Stock	21.33	21.4	18.75	18.8801	1501026.0
2013-09-23	ABR	Stock	7.26	7.43	7.23	7.3	71200.0
2013-09-23	ABR.A-DELISTED	Stock	24.6	24.73	24.48	24.699	1600.0
2013-09-23	ABR.B-DELISTED	Stock	23.4	23.4	23.3499	23.35	1850.0
2013-09-23	ABT	Stock	35.25	35.26	35.07	35.12	5718700.0
2013-09-23	ABTL-DELISTED	Stock	7.41	7.58	7.25	7.45	62527.0
2013-09-23	ABUS	Stock	6.3	6.3	5.93	6.09	97800.0
2013-09-23	ABV-DELISTED	Stock	38.99	39.26	38.81	39.01	1719649.0
2013-09-23	ABX-DELISTED	Stock	18.55	19.0	18.29	18.35	14471698.0
2013-09-23	ACAD	Stock	25.1	25.2	24.01	24.62	1890600.0

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

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