PREVIEW / stock_daily / 2017-07-24

all stock daily files

  file:    by_date/stock_daily/2017/2017-07-24.parquet
  size:    214 KB
  rows:    6,431
  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-24	AAPL	Stock	37.645	38.11	37.475	38.0225	85972800.0
2017-07-24	MSFT	Stock	73.53	73.75	73.13	73.6	21394800.0
2017-07-24	NVDA	Stock	4.2098	4.2195	4.143	4.1538	652524000.0
2017-07-24	AMZN	Stock	51.417	52.1505	51.3715	51.9475	65760000.0
2017-07-24	GOOGL	Stock	49.705	50.3095	49.5136	49.9155	79690640.0
2017-07-24	META	Stock	164.64	166.17	164.31	166.0	17367000.0
2017-07-24	TSLA	Stock	22.016	22.8933	22.0007	22.8347	129556500.0
2017-07-24	TLT	Stock	125.45	125.66	125.16	125.2	5378534.0
2017-07-24	ES	Stock	61.55	61.56	60.61	60.74	1071400.0
2017-07-24	CL	Stock	73.06	73.1	71.64	71.85	4678700.0
2017-07-24	A	Stock	61.38	61.58	61.25	61.5	973800.0
2017-07-24	AA	Stock	36.59	36.88	36.51	36.69	2244800.0
2017-07-24	AAAP-DELISTED	Stock	41.3	43.5	40.83	42.55	77798.0
2017-07-24	AABA-DELISTED	Stock	58.28	58.5	58.02	58.14	3421026.0
2017-07-24	AAC-DELISTED	Stock	6.75	6.86	6.51	6.69	86801.0
2017-07-24	AACG	Stock	4.82	4.82	4.49	4.61	22000.0
2017-07-24	AAIC-DELISTED	Stock	13.76	13.78	13.58	13.58	383102.0
2017-07-24	AAL	Stock	51.79	52.03	51.24	51.28	4876400.0
2017-07-24	AAM.A-DELISTED	Stock	26.1411	26.23	26.037	26.08	37096.0
2017-07-24	AAMC-DELISTED	Stock	27.4412	28.0882	27.4412	27.6471	3941.0
2017-07-24	AAME	Stock	3.65	3.65	3.55	3.65	1200.0
2017-07-24	AAMI	Stock	14.77	15.01	14.72	14.94	558000.0
2017-07-24	AAOI	Stock	90.63	97.75	90.6	95.63	6768000.0
2017-07-24	AAON	Stock	24.8667	24.8667	23.2667	23.4667	389400.0
2017-07-24	AAP	Stock	105.11	105.2	103.12	103.17	1413700.0
2017-07-24	AAT	Stock	40.2	40.21	39.79	39.79	179200.0
2017-07-24	AAU-DELISTED	Stock	1.27	1.27	1.22	1.2292	103553.0
2017-07-24	AAUAF-DELISTED	Stock	1.27	1.27	1.22	1.2292	109468.0
2017-07-24	AAV-DELISTED	Stock	7.0	7.0	6.8	6.9	146285.0
2017-07-24	AAWW-DELISTED	Stock	57.3	58.35	57.3	58.3	136088.0
2017-07-24	AAXJ	Stock	71.0	71.0	70.7	70.9	576084.0
2017-07-24	AAXN-DELISTED	Stock	25.23	25.53	25.106	25.3601	239182.0
2017-07-24	AB	Stock	24.65	24.85	24.6	24.75	232500.0
2017-07-24	ABAC-DELISTED	Stock	2.1	2.15	2.0659	2.12	6114.0
2017-07-24	ABAX-DELISTED	Stock	51.25	52.22	50.88	51.34	134899.0
2017-07-24	ABB-DELISTED	Stock	23.62	23.64	23.44	23.555	1832181.0
2017-07-24	ABBNY-DELISTED	Stock	23.62	23.64	23.44	23.55	2048523.0
2017-07-24	ABBV	Stock	74.63	74.75	73.84	73.91	5497800.0
2017-07-24	ABC-DELISTED	Stock	91.64	93.66	91.34	93.18	1094887.0
2017-07-24	ABCB	Stock	46.3	47.25	46.15	47.1	254500.0
2017-07-24	ABCD-DELISTED	Stock	4.84	4.95	4.82	4.9	4565.0
2017-07-24	ABCO-DELISTED	Stock	57.0	57.6	56.655	57.225	379495.0
2017-07-24	ABDC-DELISTED	Stock	12.43	12.4406	12.15	12.22	88556.0
2017-07-24	ABE-DELISTED	Stock	14.0	14.09	14.0	14.09	2620.0
2017-07-24	ABEO	Stock	243.75	247.25	230.0	235.0	27140.0
2017-07-24	ABEOW-DELISTED	Stock	5.05	5.1243	4.9	4.9	750.0
2017-07-24	ABEV	Stock	5.97	5.97	5.91	5.92	9173400.0
2017-07-24	ABG	Stock	57.15	57.3	56.35	56.8	472800.0
2017-07-24	ABIL-DELISTED	Stock	0.9334	0.97	0.92	0.9429	16111.0
2017-07-24	ABM	Stock	43.93	43.98	43.31	43.91	242700.0

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

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