PREVIEW / stock_daily / 2017-07-03

all stock daily files

  file:    by_date/stock_daily/2017/2017-07-03.parquet
  size:    209 KB
  rows:    6,337
  symbols: 2,911

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-03	AAPL	Stock	36.22	36.325	35.775	35.875	57111200.0
2017-07-03	MSFT	Stock	69.33	69.6	68.02	68.17	16165500.0
2017-07-03	NVDA	Stock	3.6263	3.6412	3.4645	3.4833	709072000.0
2017-07-03	AMZN	Stock	48.6395	48.7245	47.55	47.683	58182000.0
2017-07-03	GOOGL	Stock	46.661	46.712	45.7655	45.973	33896220.0
2017-07-03	META	Stock	151.72	152.15	147.8	148.43	13862700.0
2017-07-03	TSLA	Stock	24.6827	24.7567	23.4333	23.508	94581000.0
2017-07-03	TLT	Stock	125.0	125.04	124.02	124.46	11021117.0
2017-07-03	ES	Stock	60.74	60.81	60.36	60.41	798700.0
2017-07-03	CL	Stock	74.34	74.47	73.93	73.94	1489900.0
2017-07-03	A	Stock	59.59	59.98	59.13	59.13	1489600.0
2017-07-03	AA	Stock	32.94	34.3	32.915	34.02	3114300.0
2017-07-03	AAAP-DELISTED	Stock	39.39	39.39	37.63	39.17	9560.0
2017-07-03	AABA-DELISTED	Stock	55.08	55.25	54.045	54.461	4381214.0
2017-07-03	AAC-DELISTED	Stock	6.93	7.07	6.85	6.99	14610.0
2017-07-03	AACG	Stock	4.56	4.72	4.56	4.72	3600.0
2017-07-03	AAIC-DELISTED	Stock	13.67	13.78	13.59	13.68	274883.0
2017-07-03	AAL	Stock	50.78	51.28	50.37	50.39	2906500.0
2017-07-03	AAM.A-DELISTED	Stock	25.74	25.79	25.72	25.7699	14555.0
2017-07-03	AAMC-DELISTED	Stock	26.4118	26.7647	25.5882	26.75	20492.0
2017-07-03	AAME	Stock	3.75	3.75	3.75	3.75	600.0
2017-07-03	AAMI	Stock	14.97	15.07	14.71	14.77	629900.0
2017-07-03	AAOI	Stock	62.41	63.75	61.04	61.39	970600.0
2017-07-03	AAON	Stock	24.6667	24.8	24.5	24.6667	79500.0
2017-07-03	AAP	Stock	117.45	118.73	116.27	118.41	914800.0
2017-07-03	AAT	Stock	39.39	40.37	39.39	40.09	228500.0
2017-07-03	AAU-DELISTED	Stock	1.24	1.25	1.1	1.15	471838.0
2017-07-03	AAUAF-DELISTED	Stock	1.24	1.25	1.1	1.15	476885.0
2017-07-03	AAV-DELISTED	Stock	6.8	6.8	6.7	6.8	14990.0
2017-07-03	AAWW-DELISTED	Stock	52.2	55.2	51.75	54.8	276393.0
2017-07-03	AAXJ	Stock	67.76	67.89	67.57	67.63	409868.0
2017-07-03	AAXN-DELISTED	Stock	25.22	25.45	25.02	25.15	150614.0
2017-07-03	AB	Stock	23.6	24.0	23.6	23.8	246300.0
2017-07-03	ABAC-DELISTED	Stock	2.11	2.27	2.11	2.2	29718.0
2017-07-03	ABAX-DELISTED	Stock	53.1	53.85	52.88	53.64	47114.0
2017-07-03	ABB-DELISTED	Stock	24.99	25.01	24.86	24.9	1202419.0
2017-07-03	ABBNY-DELISTED	Stock	24.99	25.01	24.86	24.88	1221168.0
2017-07-03	ABBV	Stock	72.76	72.99	72.37	72.42	2570700.0
2017-07-03	ABC-DELISTED	Stock	94.86	95.36	94.4	94.68	424688.0
2017-07-03	ABCB	Stock	48.35	49.6	48.25	49.3	73700.0
2017-07-03	ABCD-DELISTED	Stock	5.11	5.2299	5.02	5.1	4774.0
2017-07-03	ABCO-DELISTED	Stock	51.65	51.65	50.55	51.25	96397.0
2017-07-03	ABDC-DELISTED	Stock	13.16	13.49	13.16	13.28	27509.0
2017-07-03	ABE-DELISTED	Stock	13.77	13.83	13.77	13.795	9697.0
2017-07-03	ABEO	Stock	158.75	168.75	156.25	165.0	10304.0
2017-07-03	ABEOW-DELISTED	Stock	3.43	3.43	3.4	3.4001	1880.0
2017-07-03	ABEV	Stock	5.54	5.56	5.46	5.47	12515800.0
2017-07-03	ABG	Stock	57.15	58.4	57.15	57.65	144700.0
2017-07-03	ABIL-DELISTED	Stock	1.23	1.24	1.17	1.18	115885.0
2017-07-03	ABM	Stock	41.49	41.74	41.24	41.62	84400.0

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

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