PREVIEW / stock_daily / 2016-01-08

all stock daily files

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

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-08	AAPL	Stock	24.6375	24.7775	24.19	24.24	283192000.0
2016-01-08	MSFT	Stock	52.37	53.28	52.15	52.33	48754000.0
2016-01-08	NVDA	Stock	0.7668	0.7675	0.7393	0.7408	398472000.0
2016-01-08	AMZN	Stock	30.983	31.207	30.3	30.3525	110258000.0
2016-01-08	GOOGL	Stock	37.39	37.506	36.446	36.5455	47506960.0
2016-01-08	META	Stock	99.88	100.5	97.03	97.33	35402300.0
2016-01-08	TSLA	Stock	14.524	14.696	14.0513	14.0667	54421500.0
2016-01-08	TLT	Stock	122.43	123.465	122.2305	123.36	9577237.0
2016-01-08	ES	Stock	51.17	51.49	50.72	50.82	1290200.0
2016-01-08	CL	Stock	63.1	63.42	62.37	62.55	3219800.0
2016-01-08	A	Stock	39.22	39.71	38.47	38.59	3736700.0
2016-01-08	AA.B-DELISTED	Stock	29.91	29.91	28.24	28.65	37816.0
2016-01-08	AAAP-DELISTED	Stock	29.83	29.925	27.47	28.0	115174.0
2016-01-08	AABA-DELISTED	Stock	30.51	31.54	30.0	30.63	25014646.0
2016-01-08	AAC-DELISTED	Stock	18.2	18.72	17.66	18.1	212832.0
2016-01-08	AACG	Stock	6.33	6.54	5.9	5.9	67900.0
2016-01-08	AAIC-DELISTED	Stock	13.03	13.05	12.55	12.56	291573.0
2016-01-08	AAL	Stock	40.94	41.36	40.26	40.37	8853100.0
2016-01-08	AAMC-DELISTED	Stock	4.6941	5.0735	4.3029	4.6146	214074.0
2016-01-08	AAME	Stock	4.62	4.65	4.46	4.46	6400.0
2016-01-08	AAMI	Stock	13.6	13.69	13.51	13.66	268300.0
2016-01-08	AAOI	Stock	15.42	15.69	14.65	14.79	222400.0
2016-01-08	AAON	Stock	14.1667	14.2467	13.6667	13.68	287100.0
2016-01-08	AAP	Stock	149.03	149.44	144.87	145.56	1030400.0
2016-01-08	AAT	Stock	38.09	38.16	37.39	37.56	248800.0
2016-01-08	AAU-DELISTED	Stock	0.64	0.6401	0.6201	0.6201	51725.0
2016-01-08	AAUAF-DELISTED	Stock	0.64	0.6401	0.6201	0.6201	51938.0
2016-01-08	AAV-DELISTED	Stock	4.74	4.86	4.73	4.78	127087.0
2016-01-08	AAVL-DELISTED	Stock	7.6	7.83	7.17	7.28	347714.0
2016-01-08	AAWW-DELISTED	Stock	36.03	37.3899	35.18	35.21	243685.0
2016-01-08	AAXJ	Stock	49.97	49.97	49.08	49.11	4737400.0
2016-01-08	AAXN-DELISTED	Stock	16.8	17.12	16.24	16.27	1151840.0
2016-01-08	AB	Stock	22.55	22.84	21.74	21.83	191400.0
2016-01-08	ABAC-DELISTED	Stock	0.9	0.9	0.89	0.89	1403.0
2016-01-08	ABAX-DELISTED	Stock	53.06	54.16	51.47	51.48	141826.0
2016-01-08	ABB-DELISTED	Stock	16.55	16.59	16.27	16.3	3202385.0
2016-01-08	ABBNY-DELISTED	Stock	16.55	16.59	16.27	16.31	3517711.0
2016-01-08	ABBV	Stock	57.55	57.81	55.48	55.65	7985200.0
2016-01-08	ABC-DELISTED	Stock	99.16	99.51	97.8	97.94	1646000.0
2016-01-08	ABCB	Stock	31.77	32.0	31.14	31.23	396400.0
2016-01-08	ABCD-DELISTED	Stock	4.8	4.82	4.67	4.68	26934.0
2016-01-08	ABCO-DELISTED	Stock	46.5	47.16	45.31	45.38	119625.0
2016-01-08	ABCW-DELISTED	Stock	43.56	43.6901	42.79	42.79	48306.0
2016-01-08	ABDC-DELISTED	Stock	11.64	12.04	11.33	11.8	38336.0
2016-01-08	ABE-DELISTED	Stock	10.5	10.52	10.28	10.28	29986.0
2016-01-08	ABEO	Stock	75.25	77.25	72.75	73.0	4572.0
2016-01-08	ABEOW-DELISTED	Stock	1.08	1.08	1.05	1.05	544.0
2016-01-08	ABEV	Stock	4.23	4.23	4.16	4.18	11960200.0
2016-01-08	ABG	Stock	55.81	56.48	53.12	53.34	750500.0
2016-01-08	ABGB-DELISTED	Stock	1.11	1.23	1.11	1.22	46884.0

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

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