PREVIEW / stock_daily / 2016-01-13

all stock daily files

  file:    by_date/stock_daily/2016/2016-01-13.parquet
  size:    221 KB
  rows:    6,631
  symbols: 3,390

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
2016-01-13	AAPL	Stock	25.08	25.2975	24.325	24.3475	249758400.0
2016-01-13	MSFT	Stock	53.8	54.07	51.3	51.64	66883600.0
2016-01-13	NVDA	Stock	0.7603	0.7652	0.7308	0.7315	481672000.0
2016-01-13	AMZN	Stock	31.044	31.044	28.958	29.0905	153104000.0
2016-01-13	GOOGL	Stock	37.467	37.65	35.839	35.9785	51727900.0
2016-01-13	META	Stock	100.58	100.58	95.21	95.44	33410600.0
2016-01-13	TSLA	Stock	14.134	14.1767	13.3333	13.354	61896000.0
2016-01-13	TLT	Stock	123.53	125.495	123.27	124.99	15577552.0
2016-01-13	ES	Stock	51.27	51.73	51.06	51.3	2202100.0
2016-01-13	CL	Stock	63.6	63.94	62.8	62.91	3575600.0
2016-01-13	A	Stock	38.35	38.47	36.72	36.86	4206600.0
2016-01-13	AA.B-DELISTED	Stock	25.9701	26.74	25.41	25.7	38869.0
2016-01-13	AAAP-DELISTED	Stock	24.7	26.8	24.12	25.3	30495.0
2016-01-13	AABA-DELISTED	Stock	30.88	31.17	29.325	29.435	15746710.0
2016-01-13	AAC-DELISTED	Stock	16.9	16.91	15.91	16.26	218787.0
2016-01-13	AACG	Stock	5.57	6.01	5.57	5.76	68200.0
2016-01-13	AAIC-DELISTED	Stock	12.22	12.33	11.42	11.67	672623.0
2016-01-13	AAL	Stock	42.17	42.74	39.66	40.1	12718600.0
2016-01-13	AAMC-DELISTED	Stock	4.8588	4.9706	4.3971	4.4235	82375.0
2016-01-13	AAME	Stock	4.47	4.47	4.39	4.39	2200.0
2016-01-13	AAMI	Stock	12.71	12.995	12.16	12.22	283800.0
2016-01-13	AAOI	Stock	15.05	15.16	13.8	13.97	241800.0
2016-01-13	AAON	Stock	13.7067	13.76	13.24	13.32	320850.0
2016-01-13	AAP	Stock	148.34	148.89	141.76	142.16	1336000.0
2016-01-13	AAT	Stock	37.53	38.07	37.01	37.28	226500.0
2016-01-13	AAU-DELISTED	Stock	0.57	0.5831	0.5618	0.5618	35582.0
2016-01-13	AAUAF-DELISTED	Stock	0.57	0.5831	0.5618	0.5618	35906.0
2016-01-13	AAV-DELISTED	Stock	4.74	4.86	4.51	4.54	124441.0
2016-01-13	AAVL-DELISTED	Stock	6.37	6.394	5.98	6.02	530575.0
2016-01-13	AAWW-DELISTED	Stock	34.55	34.68	32.94	33.57	191732.0
2016-01-13	AAXJ	Stock	49.63	49.76	48.57	48.69	1176303.0
2016-01-13	AAXN-DELISTED	Stock	16.09	16.36	15.33	15.41	1124265.0
2016-01-13	AB	Stock	21.19	21.29	19.5	19.8	319000.0
2016-01-13	ABAC-DELISTED	Stock	0.89	0.89	0.89	0.89	300.0
2016-01-13	ABAX-DELISTED	Stock	52.0	52.3	49.56	49.72	106994.0
2016-01-13	ABB-DELISTED	Stock	16.71	16.79	16.26	16.3	2545540.0
2016-01-13	ABBNY-DELISTED	Stock	16.71	16.79	16.26	16.3	2607366.0
2016-01-13	ABBV	Stock	54.55	54.62	50.98	51.18	10432200.0
2016-01-13	ABC-DELISTED	Stock	94.31	94.85	92.94	93.15	3631233.0
2016-01-13	ABCB	Stock	31.08	31.08	30.24	30.42	436300.0
2016-01-13	ABCD-DELISTED	Stock	4.65	4.71	4.45	4.55	67739.0
2016-01-13	ABCO-DELISTED	Stock	46.64	48.4899	44.865	45.54	261227.0
2016-01-13	ABCW-DELISTED	Stock	43.48	44.25	43.06	43.17	177956.0
2016-01-13	ABDC-DELISTED	Stock	11.09	11.09	10.32	10.37	40534.0
2016-01-13	ABE-DELISTED	Stock	10.25	10.25	9.9	10.0201	5205.0
2016-01-13	ABEO	Stock	67.0	67.5	60.0	62.5	4224.0
2016-01-13	ABEOW-DELISTED	Stock	0.89	0.89	0.776	0.776	8851.0
2016-01-13	ABEV	Stock	4.28	4.31	4.13	4.14	17525500.0
2016-01-13	ABG	Stock	52.56	53.09	48.61	49.58	645800.0
2016-01-13	ABGB-DELISTED	Stock	1.25	1.33	1.17	1.19	89059.0

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

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