PREVIEW / stock_daily / 2017-06-20

all stock daily files

  file:    by_date/stock_daily/2017/2017-06-20.parquet
  size:    214 KB
  rows:    6,448
  symbols: 2,988

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-06-20	AAPL	Stock	36.7175	36.7175	36.235	36.2525	99600400.0
2017-06-20	MSFT	Stock	70.82	70.87	69.87	69.91	21512200.0
2017-06-20	NVDA	Stock	3.9758	4.0435	3.923	3.9272	1095444000.0
2017-06-20	AMZN	Stock	49.9	50.244	49.601	49.6295	81536000.0
2017-06-20	GOOGL	Stock	48.7655	49.0395	48.41	48.4495	25945740.0
2017-06-20	META	Stock	152.88	153.84	152.21	152.25	14743900.0
2017-06-20	TSLA	Stock	25.1113	25.2587	24.6487	24.816	111580500.0
2017-06-20	TLT	Stock	126.79	127.4	126.79	127.3	8405680.0
2017-06-20	ES	Stock	62.82	63.01	62.63	62.85	905300.0
2017-06-20	CL	Stock	76.87	77.24	76.33	76.35	2383200.0
2017-06-20	A	Stock	60.55	60.92	60.3	60.33	1821700.0
2017-06-20	AA	Stock	30.69	31.095	30.41	30.45	2567600.0
2017-06-20	AAAP-DELISTED	Stock	37.79	38.16	37.27	37.9	59223.0
2017-06-20	AABA-DELISTED	Stock	54.54	54.9	53.79	53.8	36585307.0
2017-06-20	AAC-DELISTED	Stock	6.49	6.85	6.355	6.81	38175.0
2017-06-20	AACG	Stock	4.89	4.89	4.79	4.84	10600.0
2017-06-20	AAIC-DELISTED	Stock	14.82	14.91	14.7	14.85	444775.0
2017-06-20	AAL	Stock	49.22	49.36	48.01	48.03	6035100.0
2017-06-20	AAM.A-DELISTED	Stock	25.75	25.93	25.75	25.91	43304.0
2017-06-20	AAMC-DELISTED	Stock	24.9849	25.5882	24.5621	25.5882	6661.0
2017-06-20	AAME	Stock	3.7	3.7	3.65	3.65	900.0
2017-06-20	AAMI	Stock	14.81	14.86	14.61	14.62	554700.0
2017-06-20	AAOI	Stock	63.23	63.75	60.89	61.08	2002100.0
2017-06-20	AAON	Stock	24.7333	24.9333	24.42	24.5667	127500.0
2017-06-20	AAP	Stock	128.28	128.35	123.57	123.58	2233700.0
2017-06-20	AAT	Stock	39.72	39.88	39.24	39.57	212000.0
2017-06-20	AAU-DELISTED	Stock	1.34	1.4	1.3	1.4	164583.0
2017-06-20	AAUAF-DELISTED	Stock	1.34	1.4	1.3	1.4	165878.0
2017-06-20	AAV-DELISTED	Stock	6.2	6.275	6.1	6.2	29459.0
2017-06-20	AAWW-DELISTED	Stock	51.9	52.45	49.95	50.95	371164.0
2017-06-20	AAXJ	Stock	67.5	67.5871	67.18	67.23	887773.0
2017-06-20	AAXN-DELISTED	Stock	25.6	27.0	25.55	25.77	1337488.0
2017-06-20	AB	Stock	22.9	23.48	22.8	23.3	424200.0
2017-06-20	ABAC-DELISTED	Stock	2.0	2.0	1.99	2.0	2395.0
2017-06-20	ABAX-DELISTED	Stock	51.55	51.81	51.09	51.16	66711.0
2017-06-20	ABB-DELISTED	Stock	25.34	25.397	25.04	25.05	1998666.0
2017-06-20	ABBNY-DELISTED	Stock	25.34	25.397	25.04	25.05	2036744.0
2017-06-20	ABBV	Stock	71.44	71.81	71.16	71.22	6542800.0
2017-06-20	ABC-DELISTED	Stock	93.75	93.9	92.81	93.25	955518.0
2017-06-20	ABCB	Stock	47.35	47.75	46.8	47.05	78100.0
2017-06-20	ABCD-DELISTED	Stock	4.81	4.97	4.78	4.92	34349.0
2017-06-20	ABCO-DELISTED	Stock	51.6	51.775	51.125	51.2	114353.0
2017-06-20	ABDC-DELISTED	Stock	13.45	13.52	13.45	13.45	29222.0
2017-06-20	ABE-DELISTED	Stock	13.83	13.88	13.81	13.88	1505.0
2017-06-20	ABEO	Stock	118.75	123.75	118.75	122.5	5100.0
2017-06-20	ABEOW-DELISTED	Stock	2.64	2.64	2.5	2.5	957.0
2017-06-20	ABEV	Stock	5.39	5.47	5.37	5.38	67945100.0
2017-06-20	ABG	Stock	55.55	55.6	54.35	54.4	155500.0
2017-06-20	ABIL-DELISTED	Stock	1.35	1.35	1.15	1.19	149957.0
2017-06-20	ABM	Stock	41.73	41.73	41.32	41.46	235100.0

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

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