PREVIEW / stock_daily / 2017-10-05

all stock daily files

  file:    by_date/stock_daily/2017/2017-10-05.parquet
  size:    215 KB
  rows:    6,456
  symbols: 2,928

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-05	AAPL	Stock	38.545	38.86	38.5125	38.8475	85135200.0
2017-10-05	MSFT	Stock	75.22	76.12	74.96	75.97	21195300.0
2017-10-05	NVDA	Stock	4.5465	4.55	4.489	4.5193	437364000.0
2017-10-05	AMZN	Stock	48.5	49.0755	48.482	49.0425	64584000.0
2017-10-05	GOOGL	Stock	48.6395	49.3254	48.5135	49.2595	35618920.0
2017-10-05	META	Stock	169.18	171.31	168.6	171.24	14580600.0
2017-10-05	TSLA	Stock	23.7333	23.8293	23.4233	23.6887	62575500.0
2017-10-05	TLT	Stock	124.27	124.3	123.69	123.94	8180271.0
2017-10-05	ES	Stock	60.82	60.84	60.32	60.63	1113600.0
2017-10-05	CL	Stock	73.07	73.61	73.04	73.21	3037200.0
2017-10-05	A	Stock	65.85	65.99	65.52	65.7	1974100.0
2017-10-05	AA	Stock	48.08	48.729	47.65	48.25	3191500.0
2017-10-05	AAAP-DELISTED	Stock	65.5	69.5	64.94	69.05	451695.0
2017-10-05	AABA-DELISTED	Stock	67.75	68.1	66.96	67.71	3098557.0
2017-10-05	AAC-DELISTED	Stock	9.9	10.1	9.56	9.58	112744.0
2017-10-05	AACG	Stock	4.75	4.75	4.75	4.75	200.0
2017-10-05	AAIC-DELISTED	Stock	12.76	12.87	12.74	12.77	419731.0
2017-10-05	AAL	Stock	50.85	50.99	50.26	50.56	4212300.0
2017-10-05	AAM.A-DELISTED	Stock	26.04	26.12	26.01	26.02	23739.0
2017-10-05	AAMC-DELISTED	Stock	26.9706	27.5882	25.7353	26.4706	8357.0
2017-10-05	AAME	Stock	3.4	3.45	3.25	3.4	13100.0
2017-10-05	AAMI	Stock	14.9	15.08	14.85	15.03	332600.0
2017-10-05	AAOI	Stock	59.0	59.24	56.75	56.99	2576200.0
2017-10-05	AAON	Stock	23.6	23.6	23.3	23.4333	154350.0
2017-10-05	AAP	Stock	94.77	95.85	93.6	94.33	2050800.0
2017-10-05	AAT	Stock	40.46	40.75	40.07	40.53	178100.0
2017-10-05	AAU-DELISTED	Stock	1.23	1.24	1.18	1.23	188542.0
2017-10-05	AAUAF-DELISTED	Stock	1.23	1.24	1.18	1.23	204110.0
2017-10-05	AAV-DELISTED	Stock	6.0	6.05	5.9	5.95	116757.0
2017-10-05	AAWW-DELISTED	Stock	67.9	68.0919	66.55	66.85	235479.0
2017-10-05	AAXJ	Stock	73.5	74.03	73.5	73.97	2134323.0
2017-10-05	AAXN-DELISTED	Stock	23.72	23.86	23.5492	23.63	187150.0
2017-10-05	AB	Stock	24.7	24.9	24.5	24.7	169400.0
2017-10-05	ABAC-DELISTED	Stock	2.88	4.76	2.8758	3.4858	260496.0
2017-10-05	ABAX-DELISTED	Stock	46.11	46.48	45.76	46.42	51838.0
2017-10-05	ABB-DELISTED	Stock	25.07	25.1	25.03	25.06	803998.0
2017-10-05	ABBNY-DELISTED	Stock	25.07	25.1	25.03	25.06	859131.0
2017-10-05	ABBV	Stock	89.69	90.56	89.48	90.18	4382900.0
2017-10-05	ABC-DELISTED	Stock	84.16	85.29	83.83	84.13	1775645.0
2017-10-05	ABCB	Stock	48.3	49.15	47.56	48.65	164700.0
2017-10-05	ABCD-DELISTED	Stock	6.52	6.59	6.411	6.49	38147.0
2017-10-05	ABCO-DELISTED	Stock	53.95	54.0	53.875	53.95	220525.0
2017-10-05	ABDC-DELISTED	Stock	10.4	10.62	10.4	10.62	93584.0
2017-10-05	ABE-DELISTED	Stock	14.58	15.04	14.58	14.87	65229.0
2017-10-05	ABEO	Stock	463.75	471.25	437.5	462.5	46980.0
2017-10-05	ABEOW-DELISTED	Stock	14.0	14.0	12.42	13.5	11024.0
2017-10-05	ABEV	Stock	6.77	6.82	6.68	6.68	21066000.0
2017-10-05	ABG	Stock	61.6	61.95	61.15	61.8	158300.0
2017-10-05	ABIL-DELISTED	Stock	0.8097	0.8601	0.8	0.824	159416.0
2017-10-05	ABM	Stock	43.0	43.27	42.79	42.8	350900.0

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

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