PREVIEW / stock_daily / 2013-09-20

all stock daily files

  file:    by_date/stock_daily/2013/2013-09-20.parquet
  size:    214 KB
  rows:    6,407
  symbols: 3,543

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-20	AAPL	Stock	17.0714	17.0911	16.6429	16.6932	699302800.0
2013-09-20	MSFT	Stock	33.41	33.48	32.69	32.79	102904900.0
2013-09-20	NVDA	Stock	0.3993	0.4018	0.394	0.3948	356036000.0
2013-09-20	AMZN	Stock	15.627	16.0285	15.6205	15.817	106046000.0
2013-09-20	META	Stock	46.32	47.6	45.74	47.49	115508400.0
2013-09-20	TSLA	Stock	11.9267	12.3887	11.904	12.226	201025500.0
2013-09-20	TLT	Stock	104.69	105.18	104.45	104.925	8423126.0
2013-09-20	ES	Stock	41.7	41.84	41.19	41.19	1899600.0
2013-09-20	CL	Stock	60.84	60.99	60.44	60.44	3985400.0
2013-09-20	A	Stock	36.5021	37.475	36.4664	37.3033	14947276.0
2013-09-20	AABA-DELISTED	Stock	31.04	31.1	30.76	30.905	14794702.0
2013-09-20	AAIC-DELISTED	Stock	26.18	26.274	25.53	25.68	245989.0
2013-09-20	AAMC-DELISTED	Stock	105.8824	107.9412	105.8824	107.4735	12570.0
2013-09-20	AAME	Stock	3.91	4.04	3.91	4.04	15200.0
2013-09-20	AAMRQ-DELISTED	Stock	3.95	4.0	3.86	3.92	4088298.0
2013-09-20	AAON	Stock	11.5467	11.9156	11.5467	11.7511	459450.0
2013-09-20	AAP	Stock	81.17	81.31	80.6	80.65	775500.0
2013-09-20	AAT	Stock	31.51	31.51	30.81	30.93	165800.0
2013-09-20	AAU-DELISTED	Stock	1.49	1.51	1.37	1.37	174710.0
2013-09-20	AAUAF-DELISTED	Stock	1.48	1.5	1.37	1.38	178959.0
2013-09-20	AAV-DELISTED	Stock	3.77	3.79	3.6	3.62	135158.0
2013-09-20	AAWW-DELISTED	Stock	46.93	47.54	46.28	46.32	277248.0
2013-09-20	AAXJ	Stock	60.75	60.75	59.77	59.78	567824.0
2013-09-20	AAXN-DELISTED	Stock	14.66	15.22	14.35	14.8	4182495.0
2013-09-20	AB	Stock	21.89	22.05	20.87	20.95	251200.0
2013-09-20	ABAC-DELISTED	Stock	0.79	0.79	0.76	0.77	17130.0
2013-09-20	ABAX-DELISTED	Stock	41.08	42.2	41.01	41.87	140176.0
2013-09-20	ABB-DELISTED	Stock	23.79	23.93	23.75	23.78	1442295.0
2013-09-20	ABBNY-DELISTED	Stock	23.78	23.93	23.75	23.78	1462592.0
2013-09-20	ABBV	Stock	47.44	48.0	47.33	47.84	10495300.0
2013-09-20	ABC-DELISTED	Stock	62.3	62.3	61.45	61.62	1528864.0
2013-09-20	ABCB	Stock	19.0	19.02	18.87	18.91	125700.0
2013-09-20	ABCD-DELISTED	Stock	1.66	1.6601	1.6	1.6	12094.0
2013-09-20	ABCO-DELISTED	Stock	59.84	60.16	59.06	59.8	156802.0
2013-09-20	ABE-DELISTED	Stock	19.93	20.14	19.9086	20.02	18438.0
2013-09-20	ABEO	Stock	500.0	550.0	487.5	512.5	86.0
2013-09-20	ABFS-DELISTED	Stock	25.69	25.95	25.454	25.73	390573.0
2013-09-20	ABG	Stock	53.74	53.88	52.75	52.94	408400.0
2013-09-20	ABM	Stock	26.21	26.24	26.07	26.19	449600.0
2013-09-20	ABMD-DELISTED	Stock	22.04	22.37	21.29	21.38	638454.0
2013-09-20	ABR	Stock	7.5	7.5	7.25	7.25	117500.0
2013-09-20	ABR.A-DELISTED	Stock	24.64	24.64	24.5	24.5	1010.0
2013-09-20	ABR.B-DELISTED	Stock	23.58	23.58	23.3499	23.35	2100.0
2013-09-20	ABT	Stock	35.39	35.47	35.21	35.29	7915200.0
2013-09-20	ABTL-DELISTED	Stock	7.46	7.502	7.241	7.46	45031.0
2013-09-20	ABUS	Stock	6.35	6.35	6.21	6.26	40600.0
2013-09-20	ABV-DELISTED	Stock	39.39	39.72	38.75	39.11	3515339.0
2013-09-20	ABX-DELISTED	Stock	19.195	19.225	18.495	18.585	32271414.0
2013-09-20	ACAD	Stock	24.5	25.5	24.25	24.87	3624000.0
2013-09-20	ACAS-DELISTED	Stock	13.43	13.505	13.2	13.26	2974197.0

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

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