PREVIEW / stock_daily / 2016-01-05

all stock daily files

  file:    by_date/stock_daily/2016/2016-01-05.parquet
  size:    221 KB
  rows:    6,616
  symbols: 3,369

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-05	AAPL	Stock	26.4375	26.4625	25.6025	25.6775	223164000.0
2016-01-05	MSFT	Stock	54.93	55.39	54.54	55.05	34079700.0
2016-01-05	NVDA	Stock	0.8245	0.836	0.8125	0.8222	490272000.0
2016-01-05	AMZN	Stock	32.343	32.3455	31.3825	31.6895	116452000.0
2016-01-05	GOOGL	Stock	38.205	38.46	37.7825	38.0765	45215900.0
2016-01-05	META	Stock	102.89	103.71	101.67	102.73	23258200.0
2016-01-05	TSLA	Stock	15.0907	15.126	14.6667	14.8953	47802000.0
2016-01-05	TLT	Stock	120.88	121.5	120.66	120.96	6242567.0
2016-01-05	ES	Stock	50.85	51.43	50.01	51.35	1087100.0
2016-01-05	CL	Stock	64.73	65.26	64.6	65.0	4307000.0
2016-01-05	A	Stock	40.73	40.95	40.34	40.55	2587200.0
2016-01-05	AA.B-DELISTED	Stock	33.12	33.12	31.2171	31.53	61285.0
2016-01-05	AAAP-DELISTED	Stock	31.0	31.0	29.6	30.24	15954.0
2016-01-05	AABA-DELISTED	Stock	31.55	32.325	31.53	32.2	13565011.0
2016-01-05	AAC-DELISTED	Stock	18.58	19.5	18.55	19.4601	90939.0
2016-01-05	AACG	Stock	6.37	6.6	6.37	6.53	36800.0
2016-01-05	AAIC-DELISTED	Stock	13.3	13.53	13.16	13.49	254758.0
2016-01-05	AAL	Stock	41.18	41.49	39.95	40.52	10514200.0
2016-01-05	AAMC-DELISTED	Stock	5.8824	6.5471	5.7382	5.8588	161962.0
2016-01-05	AAME	Stock	4.8	4.89	4.57	4.57	4900.0
2016-01-05	AAMI	Stock	14.78	15.02	14.6	14.9	158600.0
2016-01-05	AAOI	Stock	16.3	16.36	15.6	16.08	322600.0
2016-01-05	AAON	Stock	14.8667	14.8867	14.5933	14.7333	185550.0
2016-01-05	AAP	Stock	152.35	153.79	149.89	151.2	1127700.0
2016-01-05	AAT	Stock	37.72	38.96	37.66	38.77	231700.0
2016-01-05	AAU-DELISTED	Stock	0.6437	0.6601	0.6188	0.65	42039.0
2016-01-05	AAUAF-DELISTED	Stock	0.6437	0.6601	0.6188	0.65	42830.0
2016-01-05	AAV-DELISTED	Stock	4.95	4.99	4.88	4.97	26831.0
2016-01-05	AAVL-DELISTED	Stock	8.75	8.96	8.47	8.8001	133732.0
2016-01-05	AAWW-DELISTED	Stock	40.38	41.13	39.56	39.8	217126.0
2016-01-05	AAXJ	Stock	52.05	52.19	51.86	51.95	1571554.0
2016-01-05	AAXN-DELISTED	Stock	16.98	17.21	16.62	17.02	1182146.0
2016-01-05	AB	Stock	23.53	23.8	23.1	23.1	202500.0
2016-01-05	ABAC-DELISTED	Stock	0.85	0.87	0.7799	0.8601	36541.0
2016-01-05	ABAX-DELISTED	Stock	54.44	55.29	54.095	55.02	73907.0
2016-01-05	ABB-DELISTED	Stock	17.23	17.31	17.09	17.195	2418086.0
2016-01-05	ABBNY-DELISTED	Stock	17.23	17.31	17.09	17.21	2477779.0
2016-01-05	ABBV	Stock	57.99	58.25	56.82	57.37	7179600.0
2016-01-05	ABC-DELISTED	Stock	102.2	103.4	101.59	103.37	1859292.0
2016-01-05	ABCB	Stock	32.6	32.92	32.13	32.68	258100.0
2016-01-05	ABCD-DELISTED	Stock	4.85	5.05	4.84	5.04	27042.0
2016-01-05	ABCO-DELISTED	Stock	47.46	48.07	47.02	47.53	109753.0
2016-01-05	ABCW-DELISTED	Stock	43.11	43.94	43.0	43.82	12479.0
2016-01-05	ABDC-DELISTED	Stock	11.3	11.415	11.03	11.41	50215.0
2016-01-05	ABE-DELISTED	Stock	10.6672	10.6672	10.6672	10.6672	825.0
2016-01-05	ABEO	Stock	84.25	92.0	82.5	87.5	2228.0
2016-01-05	ABEV	Stock	4.27	4.35	4.26	4.33	17926500.0
2016-01-05	ABG	Stock	66.66	67.06	64.29	65.13	264900.0
2016-01-05	ABGB-DELISTED	Stock	1.23	1.29	1.13	1.15	41048.0
2016-01-05	ABIL-DELISTED	Stock	10.45	10.5	9.94	10.01	48954.0

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

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