PREVIEW / stock_daily / 2017-05-22

all stock daily files

  file:    by_date/stock_daily/2017/2017-05-22.parquet
  size:    214 KB
  rows:    6,454
  symbols: 3,002

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
2017-05-22	AAPL	Stock	38.5	38.645	38.2275	38.4975	91865600.0
2017-05-22	MSFT	Stock	67.89	68.5	67.5	68.45	16237600.0
2017-05-22	NVDA	Stock	3.4442	3.487	3.4333	3.4725	836608000.0
2017-05-22	AMZN	Stock	48.2	48.569	48.145	48.5335	52844000.0
2017-05-22	GOOGL	Stock	47.85	48.241	47.828	48.2035	27747840.0
2017-05-22	META	Stock	148.08	148.59	147.69	148.24	12586700.0
2017-05-22	TSLA	Stock	20.8533	20.958	20.4533	20.69	64938000.0
2017-05-22	TLT	Stock	123.41	123.56	123.26	123.37	4063071.0
2017-05-22	ES	Stock	60.1	60.84	59.95	60.74	1060000.0
2017-05-22	CL	Stock	75.0	75.23	74.18	74.28	4182700.0
2017-05-22	A	Stock	56.52	56.52	55.85	56.08	4264800.0
2017-05-22	AA	Stock	32.65	33.2	32.47	32.96	3456700.0
2017-05-22	AAAP-DELISTED	Stock	36.5	37.45	36.24	36.72	44556.0
2017-05-22	AABA-DELISTED	Stock	50.51	51.08	50.215	50.64	8209383.0
2017-05-22	AAC-DELISTED	Stock	6.7	7.0	6.7	6.93	44268.0
2017-05-22	AACG	Stock	3.6	3.61	3.51	3.51	3200.0
2017-05-22	AAIC-DELISTED	Stock	14.27	14.37	14.2	14.34	255924.0
2017-05-22	AAL	Stock	45.33	46.25	45.33	46.21	4428600.0
2017-05-22	AAM.A-DELISTED	Stock	25.75	25.77	25.69	25.69	63513.0
2017-05-22	AAMC-DELISTED	Stock	20.8676	22.0588	20.8676	22.0441	3138.0
2017-05-22	AAME	Stock	3.7	3.75	3.7	3.7	1000.0
2017-05-22	AAMI	Stock	14.42	14.45	13.98	14.24	546300.0
2017-05-22	AAOI	Stock	66.0	71.34	65.8	71.24	6771200.0
2017-05-22	AAON	Stock	24.5667	24.6667	24.2333	24.5333	140550.0
2017-05-22	AAP	Stock	150.9	151.35	147.2	147.37	1921500.0
2017-05-22	AAT	Stock	39.42	39.78	39.14	39.32	302900.0
2017-05-22	AAU-DELISTED	Stock	1.27	1.33	1.26	1.32	183961.0
2017-05-22	AAUAF-DELISTED	Stock	1.27	1.33	1.26	1.31	185467.0
2017-05-22	AAV-DELISTED	Stock	6.75	6.8	6.55	6.55	62901.0
2017-05-22	AAWW-DELISTED	Stock	47.7	48.7	47.25	48.45	365807.0
2017-05-22	AAXJ	Stock	66.58	66.71	66.49	66.62	710312.0
2017-05-22	AAXN-DELISTED	Stock	24.72	24.82	24.53	24.72	295113.0
2017-05-22	AB	Stock	20.85	21.13	20.75	20.95	1091400.0
2017-05-22	ABAC-DELISTED	Stock	2.08	2.1399	1.95	1.95	5884.0
2017-05-22	ABAX-DELISTED	Stock	47.27	47.9484	46.555	47.86	31159.0
2017-05-22	ABB-DELISTED	Stock	25.09	25.19	25.01	25.04	1324466.0
2017-05-22	ABBNY-DELISTED	Stock	25.1	25.19	25.01	25.04	1383135.0
2017-05-22	ABBV	Stock	65.55	65.62	64.8	65.44	5541700.0
2017-05-22	ABC-DELISTED	Stock	89.0	90.2	89.0	89.5	1163060.0
2017-05-22	ABCB	Stock	43.62	44.65	43.62	44.4	90500.0
2017-05-22	ABCD-DELISTED	Stock	5.11	5.11	4.9	5.04	15596.0
2017-05-22	ABCO-DELISTED	Stock	51.0	51.45	50.65	50.95	169581.0
2017-05-22	ABDC-DELISTED	Stock	13.6	13.64	13.4411	13.48	37031.0
2017-05-22	ABE-DELISTED	Stock	13.7116	13.94	13.7116	13.87	5062.0
2017-05-22	ABEO	Stock	152.5	152.5	146.25	148.75	4808.0
2017-05-22	ABEV	Stock	5.64	5.71	5.56	5.63	37700200.0
2017-05-22	ABG	Stock	58.05	58.2	57.05	57.8	183700.0
2017-05-22	ABIL-DELISTED	Stock	0.7207	0.7566	0.65	0.67	57067.0
2017-05-22	ABM	Stock	41.33	41.81	40.99	41.73	154300.0
2017-05-22	ABMD-DELISTED	Stock	134.5	137.0	134.5	135.76	327183.0

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

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