PREVIEW / stock_daily / 2017-08-02

all stock daily files

  file:    by_date/stock_daily/2017/2017-08-02.parquet
  size:    215 KB
  rows:    6,437
  symbols: 2,961

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-02	AAPL	Stock	39.82	39.9375	39.04	39.285	279747200.0
2017-08-02	MSFT	Stock	72.55	72.56	71.44	72.26	26499200.0
2017-08-02	NVDA	Stock	4.1438	4.1478	4.0318	4.1098	478444000.0
2017-08-02	AMZN	Stock	50.0885	50.1605	49.0865	49.7945	81400000.0
2017-08-02	GOOGL	Stock	47.4185	47.455	46.626	47.382	40788360.0
2017-08-02	META	Stock	170.3	170.55	166.91	169.3	17433800.0
2017-08-02	TSLA	Stock	21.2627	21.808	20.748	21.726	196372500.0
2017-08-02	TLT	Stock	124.77	125.17	124.68	124.71	5745622.0
2017-08-02	ES	Stock	60.64	61.06	60.37	61.06	1153800.0
2017-08-02	CL	Stock	71.59	71.92	71.16	71.62	3059500.0
2017-08-02	A	Stock	60.0	60.33	59.52	60.2	1121500.0
2017-08-02	AA	Stock	36.27	37.33	36.2	37.28	2965500.0
2017-08-02	AAAP-DELISTED	Stock	50.17	50.59	48.0	48.32	90162.0
2017-08-02	AABA-DELISTED	Stock	58.95	59.25	56.9	57.6	5640580.0
2017-08-02	AAC-DELISTED	Stock	6.41	6.41	5.99	6.06	140150.0
2017-08-02	AACG	Stock	4.6	4.7	4.58	4.7	6700.0
2017-08-02	AAIC-DELISTED	Stock	13.14	13.1899	13.0	13.11	276557.0
2017-08-02	AAL	Stock	50.89	51.18	49.9	50.45	4679700.0
2017-08-02	AAM.A-DELISTED	Stock	26.1	26.234	26.1	26.18	26860.0
2017-08-02	AAMC-DELISTED	Stock	26.4706	26.7353	25.5882	26.1471	6480.0
2017-08-02	AAME	Stock	3.6	3.6	3.6	3.6	600.0
2017-08-02	AAMI	Stock	14.96	14.96	14.445	14.55	745200.0
2017-08-02	AAOI	Stock	100.0	101.3	92.36	93.5	4473700.0
2017-08-02	AAON	Stock	22.6333	22.7	22.2333	22.5	133650.0
2017-08-02	AAP	Stock	113.68	114.88	113.46	114.48	1775200.0
2017-08-02	AAT	Stock	40.8	40.96	40.13	40.45	248800.0
2017-08-02	AAU-DELISTED	Stock	1.19	1.2	1.15	1.16	161830.0
2017-08-02	AAUAF-DELISTED	Stock	1.19	1.2	1.15	1.16	168508.0
2017-08-02	AAV-DELISTED	Stock	6.75	6.875	6.7201	6.75	102777.0
2017-08-02	AAWW-DELISTED	Stock	63.3	67.75	62.2	66.85	1068799.0
2017-08-02	AAXJ	Stock	71.47	71.47	70.87	71.22	2299795.0
2017-08-02	AAXN-DELISTED	Stock	24.8	25.04	24.645	24.86	310416.0
2017-08-02	AB	Stock	24.85	24.95	24.6	24.8	267500.0
2017-08-02	ABAC-DELISTED	Stock	2.34	2.3856	2.2	2.3	13982.0
2017-08-02	ABAX-DELISTED	Stock	46.28	46.77	45.33	45.96	177394.0
2017-08-02	ABB-DELISTED	Stock	23.63	23.68	23.505	23.62	1770570.0
2017-08-02	ABBNY-DELISTED	Stock	23.63	23.68	23.505	23.61	1918293.0
2017-08-02	ABBV	Stock	70.25	70.74	69.93	70.71	4922200.0
2017-08-02	ABC-DELISTED	Stock	92.19	92.19	89.09	91.295	1962442.0
2017-08-02	ABCB	Stock	46.4	46.6	45.75	45.8	221600.0
2017-08-02	ABCD-DELISTED	Stock	4.94	5.05	4.91	4.91	9303.0
2017-08-02	ABCO-DELISTED	Stock	55.4	55.6	53.11	54.7	971808.0
2017-08-02	ABDC-DELISTED	Stock	11.6	11.73	11.55	11.65	71259.0
2017-08-02	ABE-DELISTED	Stock	14.25	14.25	14.15	14.1977	3092.0
2017-08-02	ABEO	Stock	200.0	205.0	185.0	191.25	16660.0
2017-08-02	ABEOW-DELISTED	Stock	4.05	4.1908	3.52	3.75	6175.0
2017-08-02	ABEV	Stock	6.09	6.2	6.09	6.19	19304400.0
2017-08-02	ABG	Stock	54.2	54.3	53.25	53.45	248000.0
2017-08-02	ABIL-DELISTED	Stock	0.76	0.76	0.73	0.7498	36415.0
2017-08-02	ABM	Stock	44.79	45.01	44.3	44.49	195700.0

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

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