PREVIEW / stock_daily / 2017-07-20

all stock daily files

  file:    by_date/stock_daily/2017/2017-07-20.parquet
  size:    213 KB
  rows:    6,418
  symbols: 2,948

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-07-20	AAPL	Stock	37.875	37.935	37.5475	37.585	68974800.0
2017-07-20	MSFT	Stock	74.18	74.3	73.28	74.22	42361000.0
2017-07-20	NVDA	Stock	4.1482	4.1878	4.0978	4.1875	699596000.0
2017-07-20	AMZN	Stock	51.5795	51.7485	51.126	51.435	61950000.0
2017-07-20	GOOGL	Stock	49.85	49.934	49.231	49.6095	28367700.0
2017-07-20	META	Stock	164.8	165.0	162.81	164.53	18523100.0
2017-07-20	TSLA	Stock	21.7933	22.0147	21.6133	21.9947	77493000.0
2017-07-20	TLT	Stock	125.49	125.73	124.9743	125.16	12239091.0
2017-07-20	ES	Stock	60.7	61.22	60.59	61.21	1004400.0
2017-07-20	CL	Stock	72.59	72.88	72.08	72.09	3683600.0
2017-07-20	A	Stock	61.45	61.55	60.81	60.98	2009400.0
2017-07-20	AA	Stock	35.95	37.31	35.95	36.72	4767400.0
2017-07-20	AAAP-DELISTED	Stock	40.93	41.39	40.0	41.08	109798.0
2017-07-20	AABA-DELISTED	Stock	58.46	58.58	58.02	58.39	7831882.0
2017-07-20	AAC-DELISTED	Stock	6.74	6.89	6.58	6.65	45529.0
2017-07-20	AACG	Stock	4.72	4.82	4.69	4.82	17800.0
2017-07-20	AAIC-DELISTED	Stock	13.67	13.78	13.64	13.69	193630.0
2017-07-20	AAL	Stock	52.72	52.78	52.1	52.34	4836200.0
2017-07-20	AAM.A-DELISTED	Stock	26.05	26.25	25.92	26.25	68372.0
2017-07-20	AAMC-DELISTED	Stock	27.7941	27.7941	27.5	27.5	3179.0
2017-07-20	AAME	Stock	3.6	3.65	3.55	3.65	900.0
2017-07-20	AAMI	Stock	15.31	15.31	15.0	15.01	418000.0
2017-07-20	AAOI	Stock	93.2	95.67	88.1	88.8	6140600.0
2017-07-20	AAON	Stock	25.0667	25.1333	24.7	25.0	103950.0
2017-07-20	AAP	Stock	100.7	104.14	99.81	103.23	1714500.0
2017-07-20	AAT	Stock	40.47	40.57	40.23	40.32	159500.0
2017-07-20	AAU-DELISTED	Stock	1.2	1.2362	1.2	1.225	103378.0
2017-07-20	AAUAF-DELISTED	Stock	1.2	1.2362	1.2	1.21	105315.0
2017-07-20	AAV-DELISTED	Stock	7.1	7.175	6.95	6.95	172418.0
2017-07-20	AAWW-DELISTED	Stock	58.35	59.2	57.35	57.75	309232.0
2017-07-20	AAXJ	Stock	70.57	70.62	70.39	70.51	450405.0
2017-07-20	AAXN-DELISTED	Stock	25.45	25.45	25.061	25.375	236148.0
2017-07-20	AB	Stock	24.5	24.88	24.5	24.65	196000.0
2017-07-20	ABAC-DELISTED	Stock	2.22	2.23	2.1278	2.14	21957.0
2017-07-20	ABAX-DELISTED	Stock	50.9	51.99	50.29	51.7901	46980.0
2017-07-20	ABB-DELISTED	Stock	24.26	24.56	24.18	24.4	3603219.0
2017-07-20	ABBNY-DELISTED	Stock	24.26	24.56	24.18	24.39	3707648.0
2017-07-20	ABBV	Stock	72.99	74.22	72.94	74.01	5329700.0
2017-07-20	ABC-DELISTED	Stock	91.2	92.35	90.62	91.96	980238.0
2017-07-20	ABCB	Stock	47.1	47.7	46.8	47.15	112200.0
2017-07-20	ABCD-DELISTED	Stock	4.92	4.92	4.87	4.9	2146.0
2017-07-20	ABCO-DELISTED	Stock	57.0	58.2	56.65	56.875	768326.0
2017-07-20	ABDC-DELISTED	Stock	12.5	12.54	12.01	12.35	197688.0
2017-07-20	ABE-DELISTED	Stock	14.16	14.1791	14.01	14.04	12171.0
2017-07-20	ABEO	Stock	250.0	256.5	237.75	243.75	27552.0
2017-07-20	ABEOW-DELISTED	Stock	4.89	5.2	4.59	5.0	5400.0
2017-07-20	ABEV	Stock	5.96	5.98	5.91	5.94	16839800.0
2017-07-20	ABG	Stock	57.4	58.1	56.65	57.6	282400.0
2017-07-20	ABIL-DELISTED	Stock	0.92	1.0	0.9	0.915	45478.0
2017-07-20	ABM	Stock	43.37	44.22	43.24	43.97	457600.0

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

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