PREVIEW / stock_daily / 2017-01-20

all stock daily files

  file:    by_date/stock_daily/2017/2017-01-20.parquet
  size:    215 KB
  rows:    6,447
  symbols: 3,070

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-01-20	AAPL	Stock	30.1125	30.1125	29.9325	30.0	130391600.0
2017-01-20	MSFT	Stock	62.67	62.82	62.37	62.74	30213500.0
2017-01-20	NVDA	Stock	2.652	2.67	2.578	2.6003	492024000.0
2017-01-20	AMZN	Stock	40.764	40.801	40.313	40.4165	67524000.0
2017-01-20	GOOGL	Stock	41.4545	41.462	41.23	41.4085	26123660.0
2017-01-20	META	Stock	128.1	128.48	126.78	127.04	19097200.0
2017-01-20	TSLA	Stock	16.364	16.4	16.2007	16.3153	63064500.0
2017-01-20	TLT	Stock	119.84	120.31	119.29	119.94	16953217.0
2017-01-20	ES	Stock	55.15	55.45	54.72	55.0	1373700.0
2017-01-20	CL	Stock	67.43	68.35	67.31	67.95	3940600.0
2017-01-20	A	Stock	47.83	47.93	47.41	47.62	1701700.0
2017-01-20	AA	Stock	35.4	35.74	34.93	35.66	5330900.0
2017-01-20	AAAP-DELISTED	Stock	28.28	29.07	28.0	28.55	96806.0
2017-01-20	AABA-DELISTED	Stock	42.33	42.535	41.865	42.05	4659251.0
2017-01-20	AAC-DELISTED	Stock	7.85	8.07	7.85	8.06	46054.0
2017-01-20	AACG	Stock	3.12	3.19	2.96	2.97	25200.0
2017-01-20	AAIC-DELISTED	Stock	14.91	15.13	14.91	15.12	220179.0
2017-01-20	AAL	Stock	47.54	48.16	47.24	48.0	5611800.0
2017-01-20	AAMC-DELISTED	Stock	21.4853	21.4853	20.6618	21.1618	19108.0
2017-01-20	AAME	Stock	3.93	4.03	3.75	3.75	14400.0
2017-01-20	AAMI	Stock	14.27	14.73	14.27	14.65	385500.0
2017-01-20	AAOI	Stock	30.58	31.07	29.78	30.58	547700.0
2017-01-20	AAON	Stock	21.5333	22.0333	21.4667	21.8	173100.0
2017-01-20	AAP	Stock	172.24	172.91	170.41	171.5	731300.0
2017-01-20	AAT	Stock	42.67	43.18	42.67	42.97	140800.0
2017-01-20	AAU-DELISTED	Stock	1.0	1.02	0.9824	0.9999	198553.0
2017-01-20	AAUAF-DELISTED	Stock	1.0	1.02	0.9824	0.9999	200623.0
2017-01-20	AAV-DELISTED	Stock	6.45	6.55	6.4	6.4	49887.0
2017-01-20	AAWW-DELISTED	Stock	50.9	51.75	50.6	50.85	92171.0
2017-01-20	AAXJ	Stock	57.45	57.55	57.25	57.46	401069.0
2017-01-20	AAXN-DELISTED	Stock	25.24	25.24	24.7532	24.85	439749.0
2017-01-20	AB	Stock	23.1	23.3	22.95	23.1	175100.0
2017-01-20	ABAC-DELISTED	Stock	3.68	3.68	3.39	3.58	16978.0
2017-01-20	ABAX-DELISTED	Stock	48.49	48.78	47.875	48.48	177192.0
2017-01-20	ABB-DELISTED	Stock	22.73	22.795	22.69	22.79	1330426.0
2017-01-20	ABBNY-DELISTED	Stock	22.73	22.795	22.69	22.78	1370352.0
2017-01-20	ABBV	Stock	61.41	61.77	61.08	61.15	6730000.0
2017-01-20	ABC-DELISTED	Stock	85.86	86.27	83.21	83.74	3400153.0
2017-01-20	ABCB	Stock	42.0	43.65	41.6	43.2	212300.0
2017-01-20	ABCD-DELISTED	Stock	5.09	5.22	4.95	5.16	33510.0
2017-01-20	ABCO-DELISTED	Stock	41.55	42.85	41.325	42.7	1633306.0
2017-01-20	ABDC-DELISTED	Stock	12.59	12.59	12.3821	12.51	21294.0
2017-01-20	ABE-DELISTED	Stock	11.49	11.54	11.4124	11.54	9611.0
2017-01-20	ABEO	Stock	125.0	126.25	121.25	125.0	5944.0
2017-01-20	ABEOW-DELISTED	Stock	3.0	3.0	3.0	3.0	100.0
2017-01-20	ABEV	Stock	5.41	5.44	5.35	5.43	9926000.0
2017-01-20	ABG	Stock	64.8	65.08	63.1	63.9	174600.0
2017-01-20	ABIL-DELISTED	Stock	3.4	3.5144	3.31	3.36	7618.0
2017-01-20	ABM	Stock	39.27	39.77	39.26	39.64	364800.0
2017-01-20	ABMD-DELISTED	Stock	112.0	112.3	110.8306	111.78	327618.0

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

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