PREVIEW / stock_daily / 2016-06-14

all stock daily files

  file:    by_date/stock_daily/2016/2016-06-14.parquet
  size:    219 KB
  rows:    6,567
  symbols: 3,278

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-06-14	AAPL	Stock	24.33	24.62	24.1875	24.365	127727600.0
2016-06-14	MSFT	Stock	49.9	50.1	49.57	49.83	42577100.0
2016-06-14	NVDA	Stock	1.167	1.1775	1.154	1.172	298344000.0
2016-06-14	AMZN	Stock	35.6165	36.0405	35.6135	35.965	50138000.0
2016-06-14	GOOGL	Stock	36.4655	36.8	36.325	36.6625	26583520.0
2016-06-14	META	Stock	114.07	114.95	113.58	114.94	17618500.0
2016-06-14	TSLA	Stock	14.592	14.8133	14.1687	14.3307	53703000.0
2016-06-14	TLT	Stock	136.19	136.22	135.22	135.28	9012488.0
2016-06-14	ES	Stock	56.92	57.29	56.49	57.29	1010800.0
2016-06-14	CL	Stock	71.48	72.17	71.22	72.09	2485000.0
2016-06-14	A	Stock	44.7	44.95	44.56	44.91	1624100.0
2016-06-14	AA.B-DELISTED	Stock	32.75	32.87	31.865	32.18	32739.0
2016-06-14	AAAP-DELISTED	Stock	30.15	30.24	29.0101	29.47	52730.0
2016-06-14	AABA-DELISTED	Stock	36.63	37.44	36.63	37.4	12240595.0
2016-06-14	AAC-DELISTED	Stock	19.81	20.4	19.56	19.93	97902.0
2016-06-14	AACG	Stock	5.25	5.25	5.09	5.09	3100.0
2016-06-14	AAIC-DELISTED	Stock	13.28	13.47	13.08	13.18	244420.0
2016-06-14	AAL	Stock	31.81	31.97	30.02	30.36	13802900.0
2016-06-14	AAMC-DELISTED	Stock	4.8765	5.2941	4.7412	4.9529	45159.0
2016-06-14	AAME	Stock	3.67	3.72	3.51	3.58	2000.0
2016-06-14	AAMI	Stock	14.1	14.71	14.01	14.3	307700.0
2016-06-14	AAOI	Stock	9.87	10.33	9.78	9.95	353500.0
2016-06-14	AAON	Stock	17.7733	17.7733	17.2867	17.52	225300.0
2016-06-14	AAP	Stock	152.75	153.59	151.1	152.63	1039600.0
2016-06-14	AAT	Stock	41.09	41.14	40.63	40.81	68900.0
2016-06-14	AAU-DELISTED	Stock	1.08	1.1	1.02	1.05	663920.0
2016-06-14	AAUAF-DELISTED	Stock	1.08	1.1	1.02	1.05	666505.0
2016-06-14	AAV-DELISTED	Stock	5.62	5.79	5.62	5.64	60787.0
2016-06-14	AAWW-DELISTED	Stock	44.64	45.125	43.45	44.15	218744.0
2016-06-14	AAXJ	Stock	52.79	53.015	52.515	52.9	1168133.0
2016-06-14	AAXN-DELISTED	Stock	22.65	22.97	22.43	22.67	492269.0
2016-06-14	AB	Stock	22.9	23.12	22.28	22.46	189900.0
2016-06-14	ABAC-DELISTED	Stock	0.68	0.799	0.68	0.75	12658.0
2016-06-14	ABAX-DELISTED	Stock	45.49	45.6	44.95	45.53	54772.0
2016-06-14	ABB-DELISTED	Stock	20.19	20.24	20.07	20.18	2229684.0
2016-06-14	ABBNY-DELISTED	Stock	20.19	20.24	20.07	20.18	2289302.0
2016-06-14	ABBV	Stock	59.46	60.38	59.16	59.9	11560200.0
2016-06-14	ABC-DELISTED	Stock	76.08	76.45	74.96	75.51	2419005.0
2016-06-14	ABCB	Stock	30.76	31.0	30.14	30.19	144300.0
2016-06-14	ABCD-DELISTED	Stock	4.59	4.63	4.46	4.57	36836.0
2016-06-14	ABCO-DELISTED	Stock	33.17	33.96	32.82	33.89	287354.0
2016-06-14	ABDC-DELISTED	Stock	12.2	12.235	12.01	12.07	22696.0
2016-06-14	ABE-DELISTED	Stock	11.92	11.92	11.89	11.89	2100.0
2016-06-14	ABEO	Stock	74.0	77.5	72.0	74.0	2784.0
2016-06-14	ABEV	Stock	5.38	5.42	5.25	5.31	14687800.0
2016-06-14	ABG	Stock	53.61	54.17	52.87	53.88	343900.0
2016-06-14	ABIL-DELISTED	Stock	3.77	3.96	3.76	3.87	86558.0
2016-06-14	ABM	Stock	36.57	36.95	36.4	36.79	389700.0
2016-06-14	ABMD-DELISTED	Stock	101.56	102.45	100.91	102.05	244765.0
2016-06-14	ABR	Stock	6.88	6.89	6.85	6.85	38600.0

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

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