PREVIEW / stock_daily / 2017-08-25

all stock daily files

  file:    by_date/stock_daily/2017/2017-08-25.parquet
  size:    212 KB
  rows:    6,420
  symbols: 2,938

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-25	AAPL	Stock	39.9125	40.14	39.8175	39.965	101920400.0
2017-08-25	MSFT	Stock	72.86	73.35	72.48	72.82	12794300.0
2017-08-25	NVDA	Stock	4.1542	4.1645	4.0888	4.0952	357200000.0
2017-08-25	AMZN	Stock	47.8	47.881	47.205	47.263	66496000.0
2017-08-25	GOOGL	Stock	46.9605	47.0365	46.505	46.525	23746260.0
2017-08-25	META	Stock	167.86	168.38	166.18	166.32	12614500.0
2017-08-25	TSLA	Stock	23.616	23.7127	23.1533	23.2033	52260000.0
2017-08-25	TLT	Stock	127.02	127.45	126.87	127.32	7303300.0
2017-08-25	ES	Stock	63.05	63.39	62.96	63.08	1325400.0
2017-08-25	CL	Stock	71.12	71.51	70.88	71.15	2162200.0
2017-08-25	A	Stock	63.06	63.14	62.67	62.9	1352800.0
2017-08-25	AA	Stock	41.68	41.8	40.84	41.21	2754000.0
2017-08-25	AAAP-DELISTED	Stock	49.33	49.6	48.43	48.67	37895.0
2017-08-25	AABA-DELISTED	Stock	65.41	65.56	64.26	64.5	4581377.0
2017-08-25	AAC-DELISTED	Stock	9.15	9.205	8.97	9.0	41039.0
2017-08-25	AACG	Stock	4.61	4.61	4.59	4.59	600.0
2017-08-25	AAIC-DELISTED	Stock	13.04	13.0674	12.89	12.93	210254.0
2017-08-25	AAL	Stock	43.09	45.43	43.01	45.25	11738400.0
2017-08-25	AAM.A-DELISTED	Stock	26.4	26.4	26.258	26.2679	17808.0
2017-08-25	AAMC-DELISTED	Stock	22.1176	23.5294	22.1176	23.5294	5029.0
2017-08-25	AAME	Stock	3.4	3.4	3.39	3.39	500.0
2017-08-25	AAMI	Stock	13.58	13.66	13.5	13.55	298300.0
2017-08-25	AAOI	Stock	62.38	62.9	61.7	62.3	1011900.0
2017-08-25	AAON	Stock	21.2333	21.3667	20.9667	21.2	122100.0
2017-08-25	AAP	Stock	93.49	97.84	93.0	95.8	1633200.0
2017-08-25	AAT	Stock	40.54	40.99	40.36	40.82	234800.0
2017-08-25	AAU-DELISTED	Stock	1.14	1.14	1.09	1.1	227988.0
2017-08-25	AAUAF-DELISTED	Stock	1.14	1.14	1.09	1.1	237157.0
2017-08-25	AAV-DELISTED	Stock	6.4	6.5	6.35	6.475	21030.0
2017-08-25	AAWW-DELISTED	Stock	63.7	64.025	63.05	63.725	83088.0
2017-08-25	AAXJ	Stock	72.22	72.31	72.0	72.08	2213861.0
2017-08-25	AAXN-DELISTED	Stock	21.63	21.83	21.57	21.59	612005.0
2017-08-25	AB	Stock	23.3	23.75	23.25	23.35	184400.0
2017-08-25	ABAC-DELISTED	Stock	2.15	2.2044	2.15	2.2044	4081.0
2017-08-25	ABAX-DELISTED	Stock	46.15	46.39	45.28	46.0	94648.0
2017-08-25	ABB-DELISTED	Stock	23.2	23.36	23.18	23.32	1789780.0
2017-08-25	ABBNY-DELISTED	Stock	23.2	23.36	23.18	23.31	1918644.0
2017-08-25	ABBV	Stock	72.22	72.78	72.21	72.48	3871200.0
2017-08-25	ABC-DELISTED	Stock	78.39	78.9522	77.97	78.11	975400.0
2017-08-25	ABCB	Stock	44.6	44.75	43.95	44.4	108200.0
2017-08-25	ABCD-DELISTED	Stock	5.19	5.3	5.11	5.24	37858.0
2017-08-25	ABCO-DELISTED	Stock	51.15	51.25	50.725	50.85	307889.0
2017-08-25	ABDC-DELISTED	Stock	10.42	10.53	10.3	10.5	63962.0
2017-08-25	ABE-DELISTED	Stock	13.87	14.13	13.86	14.0726	1979.0
2017-08-25	ABEO	Stock	241.25	250.0	220.0	226.25	38728.0
2017-08-25	ABEOW-DELISTED	Stock	5.22	5.22	4.75	4.75	900.0
2017-08-25	ABEV	Stock	6.25	6.3	6.22	6.25	9814000.0
2017-08-25	ABG	Stock	50.9	51.46	50.7	51.1	61300.0
2017-08-25	ABIL-DELISTED	Stock	0.87	1.28	0.87	1.01	4799510.0
2017-08-25	ABM	Stock	43.94	44.2	43.71	43.99	182900.0

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

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