PREVIEW / stock_daily / 2017-10-13

all stock daily files

  file:    by_date/stock_daily/2017/2017-10-13.parquet
  size:    214 KB
  rows:    6,440
  symbols: 2,910

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-10-13	AAPL	Stock	39.1825	39.32	39.1025	39.2475	65576800.0
2017-10-13	MSFT	Stock	77.59	77.87	77.29	77.49	15335700.0
2017-10-13	NVDA	Stock	4.8388	4.875	4.7913	4.8648	628728000.0
2017-10-13	AMZN	Stock	50.35	50.3885	50.0515	50.147	48630000.0
2017-10-13	GOOGL	Stock	50.4555	50.738	50.353	50.3935	26552640.0
2017-10-13	META	Stock	173.45	174.65	173.2	173.74	13658300.0
2017-10-13	TSLA	Stock	23.7987	23.8993	23.5787	23.7047	53107500.0
2017-10-13	TLT	Stock	125.58	125.94	125.165	125.85	7747000.0
2017-10-13	ES	Stock	61.97	62.2	61.51	61.65	1482700.0
2017-10-13	CL	Stock	75.48	76.03	75.26	75.99	3761300.0
2017-10-13	A	Stock	67.63	67.82	66.89	66.99	943100.0
2017-10-13	AA	Stock	48.32	48.63	47.6	47.71	3288600.0
2017-10-13	AAAP-DELISTED	Stock	67.79	69.779	67.79	68.55	94090.0
2017-10-13	AABA-DELISTED	Stock	68.07	68.18	67.38	67.495	3195156.0
2017-10-13	AAC-DELISTED	Stock	7.73	8.44	7.69	8.35	118410.0
2017-10-13	AACG	Stock	4.7	4.74	4.7	4.74	1800.0
2017-10-13	AAIC-DELISTED	Stock	12.66	12.75	12.61	12.69	195593.0
2017-10-13	AAL	Stock	52.67	52.86	52.26	52.7	2960300.0
2017-10-13	AAM.A-DELISTED	Stock	25.91	26.08	25.91	25.98	53888.0
2017-10-13	AAME	Stock	3.25	3.4	3.25	3.4	1300.0
2017-10-13	AAMI	Stock	15.45	15.52	15.36	15.4	210600.0
2017-10-13	AAOI	Stock	46.55	49.77	46.0	47.01	8691000.0
2017-10-13	AAON	Stock	22.7667	22.9667	22.5	22.5667	274350.0
2017-10-13	AAP	Stock	86.76	86.87	85.4	85.51	1969500.0
2017-10-13	AAT	Stock	41.51	41.69	41.15	41.23	230300.0
2017-10-13	AAU-DELISTED	Stock	1.17	1.2	1.15	1.16	95290.0
2017-10-13	AAUAF-DELISTED	Stock	1.17	1.2	1.15	1.16	103920.0
2017-10-13	AAV-DELISTED	Stock	5.7	5.75	5.5	5.55	77466.0
2017-10-13	AAWW-DELISTED	Stock	66.0	66.35	65.0	65.35	139782.0
2017-10-13	AAXJ	Stock	74.99	75.37	74.99	75.24	394530.0
2017-10-13	AAXN-DELISTED	Stock	24.62	24.73	24.42	24.61	502832.0
2017-10-13	AB	Stock	25.0	25.32	24.9	25.0	96800.0
2017-10-13	ABAC-DELISTED	Stock	3.48	3.48	3.2666	3.42	4150.0
2017-10-13	ABAX-DELISTED	Stock	45.665	46.0	45.47	45.9	63617.0
2017-10-13	ABB-DELISTED	Stock	25.18	25.18	25.095	25.14	957637.0
2017-10-13	ABBNY-DELISTED	Stock	25.18	25.18	25.095	25.14	984270.0
2017-10-13	ABBV	Stock	91.41	91.85	90.54	90.67	6803900.0
2017-10-13	ABC-DELISTED	Stock	80.42	81.41	77.77	79.44	2160111.0
2017-10-13	ABCB	Stock	49.5	49.93	48.1	49.05	273600.0
2017-10-13	ABCD-DELISTED	Stock	6.39	6.46	6.27	6.38	44485.0
2017-10-13	ABCO-DELISTED	Stock	53.9	54.0	53.8	53.875	1566563.0
2017-10-13	ABDC-DELISTED	Stock	10.47	10.62	10.45	10.53	36364.0
2017-10-13	ABE-DELISTED	Stock	14.76	14.7718	14.72	14.74	35568.0
2017-10-13	ABEO	Stock	441.25	447.25	393.75	402.5	79288.0
2017-10-13	ABEOW-DELISTED	Stock	13.0	13.0	10.86	10.86	7650.0
2017-10-13	ABEV	Stock	7.01	7.03	6.94	6.98	36074100.0
2017-10-13	ABG	Stock	57.6	58.4	57.2	57.55	127800.0
2017-10-13	ABIL-DELISTED	Stock	0.76	0.76	0.7426	0.76	76625.0
2017-10-13	ABM	Stock	43.4	43.59	43.22	43.33	209500.0
2017-10-13	ABMD-DELISTED	Stock	172.6	175.48	172.12	173.8122	103836.0

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

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