PREVIEW / stock_daily / 2017-10-06

all stock daily files

  file:    by_date/stock_daily/2017/2017-10-06.parquet
  size:    214 KB
  rows:    6,450
  symbols: 2,930

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-06	AAPL	Stock	38.7425	38.8725	38.64	38.825	69630400.0
2017-10-06	MSFT	Stock	75.67	76.03	75.54	76.0	13959800.0
2017-10-06	NVDA	Stock	4.4912	4.546	4.475	4.5325	318800000.0
2017-10-06	AMZN	Stock	48.782	49.7875	48.782	49.479	75642000.0
2017-10-06	GOOGL	Stock	49.0	49.713	48.9255	49.682	31060660.0
2017-10-06	META	Stock	170.25	172.37	169.75	172.23	13124500.0
2017-10-06	TSLA	Stock	23.54	24.0067	23.4833	23.792	64462500.0
2017-10-06	TLT	Stock	123.29	124.1	123.03	123.59	10375026.0
2017-10-06	ES	Stock	60.42	60.61	60.13	60.38	1593600.0
2017-10-06	CL	Stock	73.07	73.2	72.49	72.72	1771000.0
2017-10-06	A	Stock	65.68	66.38	65.66	66.36	1405100.0
2017-10-06	AA	Stock	47.89	47.89	47.3	47.49	3963400.0
2017-10-06	AAAP-DELISTED	Stock	69.99	70.95	67.65	70.71	281629.0
2017-10-06	AABA-DELISTED	Stock	67.49	68.075	67.32	67.84	1688435.0
2017-10-06	AAC-DELISTED	Stock	9.5	9.6	9.15	9.17	93570.0
2017-10-06	AACG	Stock	4.65	4.75	4.65	4.7	6400.0
2017-10-06	AAIC-DELISTED	Stock	12.78	12.78	12.625	12.71	359190.0
2017-10-06	AAL	Stock	50.7	51.59	50.65	51.3	4240500.0
2017-10-06	AAM.A-DELISTED	Stock	26.0	26.0	25.61	25.85	78326.0
2017-10-06	AAMC-DELISTED	Stock	25.8824	26.1912	25.6299	26.1912	5474.0
2017-10-06	AAME	Stock	3.25	3.4	3.25	3.4	900.0
2017-10-06	AAMI	Stock	15.07	15.11	14.91	15.0	232000.0
2017-10-06	AAOI	Stock	56.73	59.43	56.55	58.17	2021500.0
2017-10-06	AAON	Stock	23.3	23.7	23.2	23.6333	217950.0
2017-10-06	AAP	Stock	94.14	95.67	93.69	94.29	1316800.0
2017-10-06	AAT	Stock	40.32	40.4	39.85	40.27	103200.0
2017-10-06	AAU-DELISTED	Stock	1.23	1.23	1.17	1.1856	173115.0
2017-10-06	AAUAF-DELISTED	Stock	1.23	1.23	1.17	1.19	177541.0
2017-10-06	AAV-DELISTED	Stock	5.9	5.925	5.8	5.85	124608.0
2017-10-06	AAWW-DELISTED	Stock	67.05	67.55	65.005	66.0	233897.0
2017-10-06	AAXJ	Stock	73.47	73.65	73.22	73.56	2092100.0
2017-10-06	AAXN-DELISTED	Stock	23.64	23.78	23.5005	23.72	275969.0
2017-10-06	AB	Stock	24.7	25.0	24.55	24.75	127000.0
2017-10-06	ABAC-DELISTED	Stock	3.69	3.79	3.5	3.5	58047.0
2017-10-06	ABAX-DELISTED	Stock	46.39	47.03	46.31	46.67	55731.0
2017-10-06	ABB-DELISTED	Stock	24.96	25.05	24.94	25.045	723135.0
2017-10-06	ABBNY-DELISTED	Stock	24.96	25.06	24.94	25.06	753288.0
2017-10-06	ABBV	Stock	90.2	91.33	89.95	90.49	3461800.0
2017-10-06	ABC-DELISTED	Stock	84.23	84.5	80.04	80.46	2616420.0
2017-10-06	ABCB	Stock	48.65	49.43	48.65	49.4	177000.0
2017-10-06	ABCD-DELISTED	Stock	6.63	6.63	6.3201	6.46	17034.0
2017-10-06	ABCO-DELISTED	Stock	53.9	54.05	53.675	53.9	772849.0
2017-10-06	ABDC-DELISTED	Stock	10.6	10.7	10.537	10.7	56888.0
2017-10-06	ABE-DELISTED	Stock	14.79	14.84	14.71	14.71	10238.0
2017-10-06	ABEO	Stock	466.25	467.5	435.0	442.5	38756.0
2017-10-06	ABEOW-DELISTED	Stock	13.39	13.4	12.7092	12.7092	7314.0
2017-10-06	ABEV	Stock	6.62	6.63	6.56	6.61	15738000.0
2017-10-06	ABG	Stock	61.6	62.2	61.35	61.75	117700.0
2017-10-06	ABIL-DELISTED	Stock	0.85	0.93	0.7907	0.8047	393420.0
2017-10-06	ABM	Stock	42.63	42.81	42.44	42.62	298800.0

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

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