PREVIEW / stock_daily / 2017-06-02

all stock daily files

  file:    by_date/stock_daily/2017/2017-06-02.parquet
  size:    214 KB
  rows:    6,455
  symbols: 3,008

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-06-02	AAPL	Stock	38.395	38.8625	38.2225	38.8625	111082800.0
2017-06-02	MSFT	Stock	70.44	71.86	70.24	71.76	34770300.0
2017-06-02	NVDA	Stock	3.606	3.6325	3.585	3.591	487456000.0
2017-06-02	AMZN	Stock	49.9495	50.424	49.7835	50.3365	75046000.0
2017-06-02	GOOGL	Stock	49.4295	49.824	49.3535	49.806	34709380.0
2017-06-02	META	Stock	151.85	153.63	151.3	153.61	16854400.0
2017-06-02	TSLA	Stock	22.6513	22.8587	22.3953	22.6567	83853000.0
2017-06-02	TLT	Stock	125.22	125.7675	125.05	125.62	13245037.0
2017-06-02	ES	Stock	62.66	62.68	61.89	62.37	2205300.0
2017-06-02	CL	Stock	77.0	77.11	76.5	77.11	2305000.0
2017-06-02	A	Stock	60.8	61.15	60.76	60.81	1665500.0
2017-06-02	AA	Stock	32.39	33.0	32.35	32.86	2639900.0
2017-06-02	AAAP-DELISTED	Stock	37.6	37.6	35.52	35.52	45622.0
2017-06-02	AABA-DELISTED	Stock	50.53	50.75	50.31	50.6	7816302.0
2017-06-02	AAC-DELISTED	Stock	6.46	6.665	6.32	6.505	101875.0
2017-06-02	AACG	Stock	3.82	3.82	3.55	3.67	15100.0
2017-06-02	AAIC-DELISTED	Stock	14.43	14.605	14.43	14.44	529473.0
2017-06-02	AAL	Stock	49.56	50.47	49.37	49.52	7708600.0
2017-06-02	AAM.A-DELISTED	Stock	25.61	25.62	25.5	25.54	123768.0
2017-06-02	AAMC-DELISTED	Stock	26.8723	27.0735	26.8723	27.0588	5409.0
2017-06-02	AAME	Stock	3.75	3.8	3.75	3.8	700.0
2017-06-02	AAMI	Stock	14.19	14.4	14.12	14.14	524600.0
2017-06-02	AAOI	Stock	72.05	74.73	71.76	74.68	3986800.0
2017-06-02	AAON	Stock	24.5	25.1667	24.4	24.8667	196800.0
2017-06-02	AAP	Stock	136.98	138.23	136.13	137.8	1209200.0
2017-06-02	AAT	Stock	39.9	40.25	39.87	40.12	280400.0
2017-06-02	AAU-DELISTED	Stock	1.33	1.4	1.32	1.375	165866.0
2017-06-02	AAUAF-DELISTED	Stock	1.33	1.4	1.32	1.38	167175.0
2017-06-02	AAV-DELISTED	Stock	6.35	6.35	6.125	6.15	137421.0
2017-06-02	AAWW-DELISTED	Stock	50.5	52.175	50.33	51.9	354510.0
2017-06-02	AAXJ	Stock	67.69	67.8	67.55	67.78	856375.0
2017-06-02	AAXN-DELISTED	Stock	24.42	24.83	24.4	24.52	528176.0
2017-06-02	AB	Stock	22.7	22.95	22.5	22.8	703900.0
2017-06-02	ABAC-DELISTED	Stock	1.9299	2.0	1.9053	2.0	6300.0
2017-06-02	ABAX-DELISTED	Stock	49.35	50.9	49.33	50.72	88474.0
2017-06-02	ABB-DELISTED	Stock	25.69	25.83	25.62	25.81	1898521.0
2017-06-02	ABBNY-DELISTED	Stock	25.69	25.83	25.62	25.8	1953006.0
2017-06-02	ABBV	Stock	66.81	67.31	66.62	67.25	5646000.0
2017-06-02	ABC-DELISTED	Stock	93.5	93.84	92.71	93.6	1002178.0
2017-06-02	ABCB	Stock	43.8	44.9	43.6	44.2	189000.0
2017-06-02	ABCD-DELISTED	Stock	5.0	5.24	5.0	5.11	27416.0
2017-06-02	ABCO-DELISTED	Stock	52.45	52.95	52.15	52.75	672685.0
2017-06-02	ABDC-DELISTED	Stock	13.24	13.58	13.2	13.2	39455.0
2017-06-02	ABE-DELISTED	Stock	13.9482	13.9482	13.9482	13.9482	100.0
2017-06-02	ABEO	Stock	137.5	140.25	130.0	133.75	6868.0
2017-06-02	ABEV	Stock	5.74	5.75	5.6	5.67	83589900.0
2017-06-02	ABG	Stock	57.6	57.9	56.15	56.7	183000.0
2017-06-02	ABIL-DELISTED	Stock	0.577	0.61	0.5711	0.59	35702.0
2017-06-02	ABM	Stock	43.96	44.93	43.96	44.28	209600.0
2017-06-02	ABMD-DELISTED	Stock	141.12	142.49	140.61	141.6	244024.0

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

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