PREVIEW / stock_daily / 2017-08-04

all stock daily files

  file:    by_date/stock_daily/2017/2017-08-04.parquet
  size:    214 KB
  rows:    6,438
  symbols: 2,960

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-08-04	AAPL	Stock	39.0175	39.35	38.9225	39.0975	82239600.0
2017-08-04	MSFT	Stock	72.4	73.04	72.24	72.68	22579000.0
2017-08-04	NVDA	Stock	4.185	4.2518	4.162	4.1802	589096000.0
2017-08-04	AMZN	Stock	49.484	49.5835	49.1	49.379	54606000.0
2017-08-04	GOOGL	Stock	47.1975	47.377	46.9898	47.2895	25091480.0
2017-08-04	META	Stock	168.97	170.06	168.69	169.62	10777700.0
2017-08-04	TSLA	Stock	23.1333	23.818	22.8867	23.794	139033500.0
2017-08-04	TLT	Stock	125.15	125.18	124.44	124.93	8485492.0
2017-08-04	ES	Stock	61.74	61.83	61.13	61.58	1175000.0
2017-08-04	CL	Stock	71.84	71.88	71.27	71.48	2297300.0
2017-08-04	A	Stock	60.52	60.74	60.01	60.13	778800.0
2017-08-04	AA	Stock	37.34	37.5	36.73	37.42	2287600.0
2017-08-04	AAAP-DELISTED	Stock	49.33	49.69	49.03	49.2125	40576.0
2017-08-04	AABA-DELISTED	Stock	58.43	58.57	58.0136	58.51	6703531.0
2017-08-04	AAC-DELISTED	Stock	7.3	8.38	7.23	8.14	410081.0
2017-08-04	AACG	Stock	4.53	4.72	4.53	4.68	7300.0
2017-08-04	AAIC-DELISTED	Stock	13.09	13.1	12.99	13.09	149613.0
2017-08-04	AAL	Stock	50.67	50.92	50.39	50.8	2993500.0
2017-08-04	AAM.A-DELISTED	Stock	26.39	26.39	26.33	26.39	11991.0
2017-08-04	AAMC-DELISTED	Stock	25.8824	25.8824	25.5882	25.5882	1346.0
2017-08-04	AAMI	Stock	14.54	14.6	14.04	14.29	874900.0
2017-08-04	AAOI	Stock	75.0	75.0	64.4	64.6	17035300.0
2017-08-04	AAON	Stock	22.4333	23.5333	21.9	23.4667	372000.0
2017-08-04	AAP	Stock	111.13	111.85	110.3	111.01	944000.0
2017-08-04	AAT	Stock	40.28	40.66	40.09	40.39	209700.0
2017-08-04	AAU-DELISTED	Stock	1.1	1.11	1.05	1.1084	287686.0
2017-08-04	AAUAF-DELISTED	Stock	1.1	1.11	1.05	1.1084	297037.0
2017-08-04	AAV-DELISTED	Stock	6.5	6.625	6.4406	6.575	109687.0
2017-08-04	AAWW-DELISTED	Stock	65.3	66.25	64.8648	65.65	527030.0
2017-08-04	AAXJ	Stock	71.0	71.19	70.81	71.19	1017584.0
2017-08-04	AAXN-DELISTED	Stock	25.0	25.46	24.7	25.39	396978.0
2017-08-04	AB	Stock	24.3	24.45	24.18	24.3	215300.0
2017-08-04	ABAC-DELISTED	Stock	2.2615	2.38	2.18	2.23	54076.0
2017-08-04	ABAX-DELISTED	Stock	46.29	47.89	45.7888	46.57	89343.0
2017-08-04	ABB-DELISTED	Stock	23.46	23.48	23.355	23.395	1238247.0
2017-08-04	ABBNY-DELISTED	Stock	23.46	23.48	23.355	23.39	1292976.0
2017-08-04	ABBV	Stock	71.17	71.37	70.35	70.99	4732500.0
2017-08-04	ABC-DELISTED	Stock	81.71	81.97	79.58	80.83	2459072.0
2017-08-04	ABCB	Stock	45.85	46.55	45.6	46.25	120000.0
2017-08-04	ABCD-DELISTED	Stock	4.8	4.84	4.7701	4.8	5145.0
2017-08-04	ABCO-DELISTED	Stock	55.15	55.825	54.2	54.4	576345.0
2017-08-04	ABDC-DELISTED	Stock	11.55	11.79	11.34	11.4	87126.0
2017-08-04	ABE-DELISTED	Stock	14.194	14.2049	14.17	14.186	1900.0
2017-08-04	ABEO	Stock	185.0	205.0	183.75	201.25	19276.0
2017-08-04	ABEOW-DELISTED	Stock	4.0	4.0	3.9999	4.0	1500.0
2017-08-04	ABEV	Stock	6.13	6.15	6.07	6.12	10742500.0
2017-08-04	ABG	Stock	53.4	54.35	53.2	54.25	122100.0
2017-08-04	ABIL-DELISTED	Stock	0.76	0.76	0.64	0.6651	35421.0
2017-08-04	ABM	Stock	44.79	44.9	44.67	44.76	323100.0
2017-08-04	ABMD-DELISTED	Stock	148.63	151.22	148.33	151.04	312046.0

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

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