PREVIEW / stock_daily / 2017-10-04

all stock daily files

  file:    by_date/stock_daily/2017/2017-10-04.parquet
  size:    215 KB
  rows:    6,453
  symbols: 2,927

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-04	AAPL	Stock	38.4075	38.465	38.115	38.37	80655200.0
2017-10-04	MSFT	Stock	74.09	74.72	73.71	74.69	13317700.0
2017-10-04	NVDA	Stock	4.4905	4.5443	4.4535	4.5218	427848000.0
2017-10-04	AMZN	Stock	47.7105	48.3895	47.7025	48.2725	50548000.0
2017-10-04	GOOGL	Stock	48.588	48.72	48.2805	48.339	21155380.0
2017-10-04	META	Stock	169.83	170.67	168.29	168.42	12127900.0
2017-10-04	TSLA	Stock	23.4167	23.908	23.3067	23.6673	122452500.0
2017-10-04	TLT	Stock	124.53	124.59	123.88	124.41	7446965.0
2017-10-04	ES	Stock	60.36	60.85	60.07	60.79	1585700.0
2017-10-04	CL	Stock	72.35	73.33	72.32	72.88	2345300.0
2017-10-04	A	Stock	65.15	65.87	65.15	65.83	745600.0
2017-10-04	AA	Stock	48.27	49.3	47.75	47.91	4124200.0
2017-10-04	AAAP-DELISTED	Stock	65.5	66.16	64.85	65.75	207885.0
2017-10-04	AABA-DELISTED	Stock	67.79	68.22	67.48	67.64	3989452.0
2017-10-04	AAC-DELISTED	Stock	10.0	10.01	9.7248	9.96	34582.0
2017-10-04	AACG	Stock	4.65	4.79	4.65	4.72	10100.0
2017-10-04	AAIC-DELISTED	Stock	12.79	12.84	12.69	12.76	330133.0
2017-10-04	AAL	Stock	50.5	51.67	50.49	50.73	7454500.0
2017-10-04	AAM.A-DELISTED	Stock	26.1	26.21	26.04	26.04	22833.0
2017-10-04	AAMC-DELISTED	Stock	24.5735	25.6618	24.1176	25.6618	17075.0
2017-10-04	AAME	Stock	3.26	3.35	3.26	3.35	4000.0
2017-10-04	AAMI	Stock	15.02	15.05	14.86	14.89	454100.0
2017-10-04	AAOI	Stock	61.39	61.99	59.35	59.43	2200900.0
2017-10-04	AAON	Stock	23.6	23.7333	23.3	23.5667	145350.0
2017-10-04	AAP	Stock	95.04	98.41	94.48	94.93	2780300.0
2017-10-04	AAT	Stock	40.57	40.63	40.23	40.37	226300.0
2017-10-04	AAU-DELISTED	Stock	1.17	1.22	1.12	1.21	440483.0
2017-10-04	AAUAF-DELISTED	Stock	1.17	1.22	1.12	1.21	475372.0
2017-10-04	AAV-DELISTED	Stock	6.1	6.1	5.95	5.95	107278.0
2017-10-04	AAWW-DELISTED	Stock	68.25	68.6921	67.3	68.05	241470.0
2017-10-04	AAXJ	Stock	73.38	73.48	73.2475	73.35	516235.0
2017-10-04	AAXN-DELISTED	Stock	23.26	23.77	23.2	23.76	531211.0
2017-10-04	AB	Stock	24.45	24.75	24.4	24.65	184300.0
2017-10-04	ABAC-DELISTED	Stock	2.51	2.8305	2.5	2.74	8726.0
2017-10-04	ABAX-DELISTED	Stock	45.58	46.06	45.48	46.06	42010.0
2017-10-04	ABB-DELISTED	Stock	25.07	25.2	25.06	25.12	1157874.0
2017-10-04	ABBNY-DELISTED	Stock	25.07	25.2	25.06	25.12	1363228.0
2017-10-04	ABBV	Stock	89.52	90.44	89.31	89.9	3251200.0
2017-10-04	ABC-DELISTED	Stock	82.76	84.14	82.56	82.76	2032126.0
2017-10-04	ABCB	Stock	48.45	48.45	48.0	48.35	217400.0
2017-10-04	ABCD-DELISTED	Stock	6.3	6.53	6.18	6.5	88945.0
2017-10-04	ABCO-DELISTED	Stock	53.85	54.15	53.825	53.95	514544.0
2017-10-04	ABDC-DELISTED	Stock	10.39	10.46	10.36	10.4299	76198.0
2017-10-04	ABE-DELISTED	Stock	14.25	14.32	14.23	14.31	14160.0
2017-10-04	ABEO	Stock	437.5	444.75	428.75	435.0	21672.0
2017-10-04	ABEOW-DELISTED	Stock	12.84	13.11	12.44	12.7	2400.0
2017-10-04	ABEV	Stock	6.78	6.81	6.68	6.68	17444800.0
2017-10-04	ABG	Stock	62.1	62.3	61.55	61.7	84000.0
2017-10-04	ABIL-DELISTED	Stock	0.77	0.84	0.76	0.7999	152585.0
2017-10-04	ABM	Stock	42.49	43.01	42.46	43.01	295600.0

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

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