PREVIEW / stock_daily / 2017-08-22

all stock daily files

  file:    by_date/stock_daily/2017/2017-08-22.parquet
  size:    214 KB
  rows:    6,454
  symbols: 2,954

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-22	AAPL	Stock	39.5575	40.0	39.505	39.945	86418400.0
2017-08-22	MSFT	Stock	72.35	73.24	72.35	73.16	14343700.0
2017-08-22	NVDA	Stock	4.0123	4.0698	3.9928	4.0638	450456000.0
2017-08-22	AMZN	Stock	47.776	48.3965	47.775	48.345	55000000.0
2017-08-22	GOOGL	Stock	46.348	47.0981	46.3085	47.02	35501980.0
2017-08-22	META	Stock	168.28	169.87	167.15	169.64	11391000.0
2017-08-22	TSLA	Stock	22.742	22.816	22.4913	22.7567	64830000.0
2017-08-22	TLT	Stock	126.79	126.805	126.27	126.44	6140708.0
2017-08-22	ES	Stock	62.91	63.04	62.64	62.91	2193400.0
2017-08-22	CL	Stock	71.68	71.96	71.45	71.64	2360600.0
2017-08-22	A	Stock	61.87	63.02	61.85	62.96	1666400.0
2017-08-22	AA	Stock	38.74	40.13	38.73	39.77	3869200.0
2017-08-22	AAAP-DELISTED	Stock	47.83	48.98	47.83	48.48	33815.0
2017-08-22	AABA-DELISTED	Stock	63.76	65.52	63.755	65.42	4919620.0
2017-08-22	AAC-DELISTED	Stock	9.02	9.206	9.02	9.12	50573.0
2017-08-22	AACG	Stock	4.76	4.76	4.6	4.7	32900.0
2017-08-22	AAIC-DELISTED	Stock	12.76	13.04	12.76	12.95	287016.0
2017-08-22	AAL	Stock	45.85	45.93	45.33	45.41	4019700.0
2017-08-22	AAM.A-DELISTED	Stock	26.12	26.1499	26.021	26.0835	19641.0
2017-08-22	AAMC-DELISTED	Stock	22.5588	23.1618	22.5588	22.9559	10445.0
2017-08-22	AAME	Stock	3.45	3.45	3.35	3.35	500.0
2017-08-22	AAMI	Stock	13.59	13.645	13.43	13.6	420000.0
2017-08-22	AAOI	Stock	60.94	62.4	60.41	61.02	1934300.0
2017-08-22	AAON	Stock	21.3	21.6	21.22	21.5	90150.0
2017-08-22	AAP	Stock	95.23	96.75	95.07	95.8	2075200.0
2017-08-22	AAT	Stock	40.55	40.55	39.86	39.93	149100.0
2017-08-22	AAU-DELISTED	Stock	1.12	1.12	1.1	1.105	43824.0
2017-08-22	AAUAF-DELISTED	Stock	1.12	1.12	1.1	1.105	46300.0
2017-08-22	AAV-DELISTED	Stock	6.4	6.4	6.3	6.4	60759.0
2017-08-22	AAWW-DELISTED	Stock	62.15	63.85	62.15	63.8	216055.0
2017-08-22	AAXJ	Stock	70.96	71.36	70.9	71.35	809411.0
2017-08-22	AAXN-DELISTED	Stock	21.5	22.13	21.4001	21.78	735343.0
2017-08-22	AB	Stock	23.2	23.7	23.2	23.6	242400.0
2017-08-22	ABAC-DELISTED	Stock	2.07	2.07	2.05	2.0501	2141.0
2017-08-22	ABAX-DELISTED	Stock	46.67	47.41	46.6575	47.09	55601.0
2017-08-22	ABB-DELISTED	Stock	22.97	23.17	22.96	23.15	1960555.0
2017-08-22	ABBNY-DELISTED	Stock	22.97	23.17	22.96	23.14	2215428.0
2017-08-22	ABBV	Stock	70.91	71.88	70.76	71.75	3589000.0
2017-08-22	ABC-DELISTED	Stock	78.24	79.46	78.09	79.23	1134906.0
2017-08-22	ABCB	Stock	43.7	43.95	43.45	43.75	76600.0
2017-08-22	ABCD-DELISTED	Stock	5.15	5.24	5.11	5.16	45896.0
2017-08-22	ABCO-DELISTED	Stock	51.8	51.8	51.35	51.65	309267.0
2017-08-22	ABDC-DELISTED	Stock	10.66	10.94	10.26	10.33	107713.0
2017-08-22	ABE-DELISTED	Stock	13.92	13.987	13.92	13.9774	2771.0
2017-08-22	ABEO	Stock	198.5	205.0	194.5	196.25	18108.0
2017-08-22	ABEOW-DELISTED	Stock	4.1	4.35	4.1	4.35	750.0
2017-08-22	ABEV	Stock	6.25	6.28	6.15	6.16	13340300.0
2017-08-22	ABG	Stock	50.95	51.38	50.85	51.25	159400.0
2017-08-22	ABIL-DELISTED	Stock	0.651	0.651	0.5999	0.6039	26826.0
2017-08-22	ABM	Stock	43.09	43.86	43.09	43.77	127700.0

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

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