PREVIEW / stock_daily / 2016-01-14

all stock daily files

  file:    by_date/stock_daily/2016/2016-01-14.parquet
  size:    221 KB
  rows:    6,643
  symbols: 3,397

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-14	AAPL	Stock	24.49	25.12	23.935	24.88	252680400.0
2016-01-14	MSFT	Stock	52.0	53.42	51.57	53.11	52381900.0
2016-01-14	NVDA	Stock	0.7165	0.725	0.6955	0.7168	600236000.0
2016-01-14	AMZN	Stock	29.0125	30.1125	28.494	29.65	144760000.0
2016-01-14	GOOGL	Stock	36.222	36.9945	35.25	36.5695	55557360.0
2016-01-14	META	Stock	95.85	98.87	92.45	98.37	48658600.0
2016-01-14	TSLA	Stock	13.4807	14.0	12.892	13.7453	97360500.0
2016-01-14	TLT	Stock	124.47	124.965	123.34	123.82	12873776.0
2016-01-14	ES	Stock	51.28	52.22	50.57	51.86	4149300.0
2016-01-14	CL	Stock	63.03	64.14	62.98	63.53	3894200.0
2016-01-14	A	Stock	36.94	37.88	36.55	37.61	2893300.0
2016-01-14	AA.B-DELISTED	Stock	25.68	26.2999	24.92	25.8	110756.0
2016-01-14	AAAP-DELISTED	Stock	26.03	26.2325	24.01	25.2	22058.0
2016-01-14	AABA-DELISTED	Stock	29.71	30.57	28.71	30.32	14151187.0
2016-01-14	AAC-DELISTED	Stock	16.27	17.7	16.17	17.25	194047.0
2016-01-14	AACG	Stock	5.27	5.87	5.27	5.65	13200.0
2016-01-14	AAIC-DELISTED	Stock	11.71	11.76	11.2	11.24	600971.0
2016-01-14	AAL	Stock	40.21	40.78	38.86	40.55	11756500.0
2016-01-14	AAMC-DELISTED	Stock	4.3764	5.0735	4.3235	4.9941	89447.0
2016-01-14	AAME	Stock	4.37	4.48	4.37	4.42	3100.0
2016-01-14	AAMI	Stock	12.28	12.28	11.75	11.96	898200.0
2016-01-14	AAOI	Stock	14.05	14.53	13.62	14.16	259100.0
2016-01-14	AAON	Stock	13.34	13.5	13.1667	13.32	189900.0
2016-01-14	AAP	Stock	142.18	143.0	139.16	141.32	1121200.0
2016-01-14	AAT	Stock	37.35	37.59	36.76	37.08	206700.0
2016-01-14	AAU-DELISTED	Stock	0.5575	0.5724	0.5575	0.56	59250.0
2016-01-14	AAUAF-DELISTED	Stock	0.5575	0.5724	0.5575	0.56	62550.0
2016-01-14	AAV-DELISTED	Stock	4.49	4.7701	4.46	4.73	99725.0
2016-01-14	AAVL-DELISTED	Stock	6.11	6.2	5.72	6.01	494256.0
2016-01-14	AAWW-DELISTED	Stock	33.59	34.45	32.7	34.08	142850.0
2016-01-14	AAXJ	Stock	48.78	49.39	48.38	49.25	1585906.0
2016-01-14	AAXN-DELISTED	Stock	15.44	15.8	14.93	15.475	1448571.0
2016-01-14	AB	Stock	19.74	20.31	19.35	20.19	362500.0
2016-01-14	ABAC-DELISTED	Stock	0.751	0.85	0.75	0.85	2623.0
2016-01-14	ABAX-DELISTED	Stock	50.02	51.08	48.86	50.46	111050.0
2016-01-14	ABB-DELISTED	Stock	16.57	16.82	16.41	16.74	3851587.0
2016-01-14	ABBNY-DELISTED	Stock	16.57	16.82	16.41	16.73	3928537.0
2016-01-14	ABBV	Stock	51.32	56.83	50.71	54.56	16704900.0
2016-01-14	ABC-DELISTED	Stock	92.79	94.2431	92.42	93.72	2436351.0
2016-01-14	ABCB	Stock	30.58	30.76	30.1	30.2	258500.0
2016-01-14	ABCD-DELISTED	Stock	4.55	4.62	4.47	4.51	25322.0
2016-01-14	ABCO-DELISTED	Stock	45.68	48.4999	45.16	45.83	229151.0
2016-01-14	ABCW-DELISTED	Stock	43.49	43.55	42.92	42.99	163677.0
2016-01-14	ABDC-DELISTED	Stock	10.42	10.77	10.31	10.49	52818.0
2016-01-14	ABE-DELISTED	Stock	10.1	10.15	10.1	10.15	2679.0
2016-01-14	ABEO	Stock	66.0	78.5	66.0	73.75	6892.0
2016-01-14	ABEOW-DELISTED	Stock	0.64	1.0	0.64	0.9999	3100.0
2016-01-14	ABEV	Stock	4.14	4.24	4.09	4.23	31235700.0
2016-01-14	ABG	Stock	49.56	51.56	47.27	50.14	560400.0
2016-01-14	ABGB-DELISTED	Stock	1.18	1.3	1.13	1.15	280270.0

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

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