PREVIEW / stock_daily / 2017-04-07

all stock daily files

  file:    by_date/stock_daily/2017/2017-04-07.parquet
  size:    214 KB
  rows:    6,407
  symbols: 3,006

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-04-07	AAPL	Stock	35.9325	36.045	35.8175	35.835	66688800.0
2017-04-07	MSFT	Stock	65.85	65.96	65.44	65.68	14108500.0
2017-04-07	NVDA	Stock	2.5255	2.5433	2.493	2.5083	429068000.0
2017-04-07	AMZN	Stock	44.9825	45.0045	44.4655	44.744	74218000.0
2017-04-07	GOOGL	Stock	42.25	42.294	41.865	42.105	22232200.0
2017-04-07	META	Stock	141.2	141.55	140.24	140.78	11818300.0
2017-04-07	TSLA	Stock	19.8333	20.1793	19.81	20.1693	68694000.0
2017-04-07	TLT	Stock	121.84	122.25	120.69	120.71	10270017.0
2017-04-07	ES	Stock	59.67	59.84	59.34	59.4	1645200.0
2017-04-07	CL	Stock	73.18	73.89	72.93	73.45	3250900.0
2017-04-07	A	Stock	53.07	53.07	52.7	52.84	1243600.0
2017-04-07	AA	Stock	33.25	34.13	33.151	33.73	3674100.0
2017-04-07	AAAP-DELISTED	Stock	39.4	39.65	39.21	39.38	95976.0
2017-04-07	AABA-DELISTED	Stock	46.23	46.53	45.96	46.45	4294015.0
2017-04-07	AAC-DELISTED	Stock	8.43	8.43	8.21	8.3	49353.0
2017-04-07	AACG	Stock	4.12	4.12	3.87	3.89	26600.0
2017-04-07	AAIC-DELISTED	Stock	14.06	14.148	14.02	14.02	164840.0
2017-04-07	AAL	Stock	41.53	42.1	41.28	41.81	4137000.0
2017-04-07	AAM.A-DELISTED	Stock	25.34	25.37	25.25	25.28	218247.0
2017-04-07	AAMC-DELISTED	Stock	19.1029	19.9559	18.9467	19.7059	15892.0
2017-04-07	AAME	Stock	4.0	4.0	3.95	3.98	3100.0
2017-04-07	AAMI	Stock	15.07	15.2	15.0	15.15	175900.0
2017-04-07	AAOI	Stock	46.0	47.138	44.02	44.68	1867700.0
2017-04-07	AAON	Stock	22.8667	23.0667	22.7667	22.8667	237750.0
2017-04-07	AAP	Stock	142.51	143.54	141.93	142.05	928100.0
2017-04-07	AAT	Stock	42.01	42.32	41.83	41.95	249300.0
2017-04-07	AAU-DELISTED	Stock	1.4	1.41	1.23	1.29	486529.0
2017-04-07	AAUAF-DELISTED	Stock	1.4	1.41	1.23	1.29	488814.0
2017-04-07	AAV-DELISTED	Stock	6.8	6.855	6.65	6.7	52366.0
2017-04-07	AAWW-DELISTED	Stock	53.7	54.2	53.275	53.9	143035.0
2017-04-07	AAXJ	Stock	63.13	63.265	63.01	63.14	1075426.0
2017-04-07	AAXN-DELISTED	Stock	23.25	23.61	22.67	23.28	1784169.0
2017-04-07	AB	Stock	22.85	22.95	22.63	22.65	469400.0
2017-04-07	ABAC-DELISTED	Stock	2.39	2.8355	2.39	2.66	83596.0
2017-04-07	ABAX-DELISTED	Stock	47.02	47.5	46.75	47.39	63606.0
2017-04-07	ABB-DELISTED	Stock	23.23	23.425	23.22	23.31	991269.0
2017-04-07	ABBNY-DELISTED	Stock	23.24	23.425	23.22	23.29	1023774.0
2017-04-07	ABBV	Stock	65.06	65.93	64.83	65.54	6089300.0
2017-04-07	ABC-DELISTED	Stock	87.57	88.07	87.29	87.62	793434.0
2017-04-07	ABCB	Stock	44.35	44.9	44.1	44.35	188300.0
2017-04-07	ABCD-DELISTED	Stock	4.84	4.89	4.81	4.87	8180.0
2017-04-07	ABCO-DELISTED	Stock	46.95	47.4	46.8	47.25	249425.0
2017-04-07	ABDC-DELISTED	Stock	14.0	14.3	13.92	14.275	57422.0
2017-04-07	ABE-DELISTED	Stock	13.39	13.42	13.36	13.4032	2256.0
2017-04-07	ABEO	Stock	127.5	128.75	122.5	126.25	15652.0
2017-04-07	ABEV	Stock	5.72	5.76	5.67	5.69	11340800.0
2017-04-07	ABG	Stock	58.0	58.3	57.5	58.0	246900.0
2017-04-07	ABIL-DELISTED	Stock	1.79	1.79	1.71	1.769	6666.0
2017-04-07	ABM	Stock	41.87	42.09	41.67	41.9	360400.0
2017-04-07	ABMD-DELISTED	Stock	124.97	126.06	124.69	125.39	123236.0

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

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