PREVIEW / stock_daily / 2017-06-05

all stock daily files

  file:    by_date/stock_daily/2017/2017-06-05.parquet
  size:    215 KB
  rows:    6,489
  symbols: 3,022

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-05	AAPL	Stock	38.585	38.6125	38.365	38.4825	101326800.0
2017-06-05	MSFT	Stock	71.97	72.89	71.81	72.28	33316800.0
2017-06-05	NVDA	Stock	3.5745	3.7133	3.5628	3.7002	817376000.0
2017-06-05	AMZN	Stock	50.3615	50.6605	50.1755	50.567	54398000.0
2017-06-05	GOOGL	Stock	49.8945	50.3701	49.7725	50.194	27578320.0
2017-06-05	META	Stock	153.64	154.71	153.41	153.63	12520400.0
2017-06-05	TSLA	Stock	22.5667	23.2293	22.2807	23.1547	101766000.0
2017-06-05	TLT	Stock	124.9	125.16	124.78	124.84	6775466.0
2017-06-05	ES	Stock	62.47	62.47	62.09	62.29	1486600.0
2017-06-05	CL	Stock	77.0	77.26	76.55	77.23	2091500.0
2017-06-05	A	Stock	60.8	60.84	60.33	60.4	1473300.0
2017-06-05	AA	Stock	32.65	33.58	32.65	33.32	2605000.0
2017-06-05	AAAP-DELISTED	Stock	35.56	35.99	35.2	35.74	24576.0
2017-06-05	AABA-DELISTED	Stock	50.52	50.88	50.4	50.6	11543282.0
2017-06-05	AAC-DELISTED	Stock	6.54	6.67	6.26	6.38	82445.0
2017-06-05	AACG	Stock	3.62	3.97	3.54	3.8	34500.0
2017-06-05	AAIC-DELISTED	Stock	14.45	14.53	14.339	14.38	255751.0
2017-06-05	AAL	Stock	49.53	49.95	49.4	49.74	5466700.0
2017-06-05	AAM.A-DELISTED	Stock	25.56	25.59	25.51	25.56	32707.0
2017-06-05	AAMC-DELISTED	Stock	26.8602	26.8602	26.6176	26.6176	2315.0
2017-06-05	AAME	Stock	3.78	3.8	3.75	3.8	1700.0
2017-06-05	AAMI	Stock	14.59	14.59	14.32	14.52	1536600.0
2017-06-05	AAOI	Stock	74.96	75.0	71.8	72.44	2754700.0
2017-06-05	AAON	Stock	24.8667	24.9467	24.5667	24.6	158400.0
2017-06-05	AAP	Stock	137.0	137.0	134.73	135.57	1406800.0
2017-06-05	AAT	Stock	39.92	39.92	39.26	39.59	224000.0
2017-06-05	AAU-DELISTED	Stock	1.4	1.44	1.38	1.39	151381.0
2017-06-05	AAUAF-DELISTED	Stock	1.4	1.44	1.38	1.41	159352.0
2017-06-05	AAV-DELISTED	Stock	6.15	6.2	6.05	6.15	59558.0
2017-06-05	AAWW-DELISTED	Stock	52.0	52.55	51.3	52.55	271217.0
2017-06-05	AAXJ	Stock	67.77	67.825	67.68	67.69	562745.0
2017-06-05	AAXN-DELISTED	Stock	24.44	24.59	24.14	24.41	646734.0
2017-06-05	AB	Stock	22.75	22.95	22.58	22.65	523600.0
2017-06-05	ABAC-DELISTED	Stock	2.0126	2.06	1.98	2.03	14527.0
2017-06-05	ABAX-DELISTED	Stock	50.75	51.3914	50.14	50.47	77087.0
2017-06-05	ABB-DELISTED	Stock	25.56	25.66	25.485	25.54	3063988.0
2017-06-05	ABBNY-DELISTED	Stock	25.56	25.66	25.485	25.53	3227686.0
2017-06-05	ABBV	Stock	67.25	67.86	66.88	67.51	4918100.0
2017-06-05	ABC-DELISTED	Stock	93.2	93.57	92.51	93.31	921663.0
2017-06-05	ABCB	Stock	44.25	44.6	43.85	44.05	157000.0
2017-06-05	ABCD-DELISTED	Stock	5.13	5.22	4.99	5.07	12024.0
2017-06-05	ABCO-DELISTED	Stock	52.7	52.95	52.3	52.35	143047.0
2017-06-05	ABDC-DELISTED	Stock	13.2	13.2799	13.18	13.22	31102.0
2017-06-05	ABE-DELISTED	Stock	13.83	13.9365	13.83	13.89	2275.0
2017-06-05	ABEO	Stock	135.0	136.25	130.0	131.25	6068.0
2017-06-05	ABEV	Stock	5.65	5.73	5.62	5.72	37350200.0
2017-06-05	ABG	Stock	56.55	57.4	56.0	56.5	131300.0
2017-06-05	ABIL-DELISTED	Stock	0.6051	0.6179	0.5885	0.59	7900.0
2017-06-05	ABM	Stock	44.22	44.22	43.57	43.68	266400.0
2017-06-05	ABMD-DELISTED	Stock	141.98	142.95	140.85	141.79	116323.0

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

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