PREVIEW / stock_daily / 2017-01-06

all stock daily files

  file:    by_date/stock_daily/2017/2017-01-06.parquet
  size:    216 KB
  rows:    6,493
  symbols: 3,111

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-06	AAPL	Stock	29.195	29.54	29.1175	29.4775	127007600.0
2017-01-06	MSFT	Stock	62.3	63.15	62.04	62.84	19922900.0
2017-01-06	NVDA	Stock	2.5712	2.6062	2.53	2.5775	822856000.0
2017-01-06	AMZN	Stock	39.118	39.972	38.924	39.7995	119724000.0
2017-01-06	GOOGL	Stock	40.7495	41.448	40.575	41.2605	40341940.0
2017-01-06	META	Stock	120.98	123.88	120.03	123.41	28545300.0
2017-01-06	TSLA	Stock	15.1287	15.354	15.03	15.2673	82918500.0
2017-01-06	TLT	Stock	121.13	121.5414	120.75	120.86	8369334.0
2017-01-06	ES	Stock	54.84	55.48	54.77	55.26	1224200.0
2017-01-06	CL	Stock	66.81	67.49	66.6	67.36	2994800.0
2017-01-06	A	Stock	46.63	48.07	46.56	47.99	2883400.0
2017-01-06	AA	Stock	30.69	31.1	30.31	30.68	2086300.0
2017-01-06	AAAP-DELISTED	Stock	27.54	27.62	27.01	27.51	106007.0
2017-01-06	AABA-DELISTED	Stock	41.25	41.34	40.85	41.24	4888022.0
2017-01-06	AAC-DELISTED	Stock	7.57	7.637	7.46	7.55	90155.0
2017-01-06	AACG	Stock	3.98	3.98	3.8	3.8	1900.0
2017-01-06	AAIC-DELISTED	Stock	15.12	15.12	14.9	14.91	254765.0
2017-01-06	AAL	Stock	45.85	46.72	45.47	46.21	7260200.0
2017-01-06	AAMC-DELISTED	Stock	17.5882	17.5882	16.8058	17.3529	13399.0
2017-01-06	AAME	Stock	4.1	4.1	4.1	4.1	1000.0
2017-01-06	AAMI	Stock	14.55	14.69	14.34	14.48	434200.0
2017-01-06	AAOI	Stock	22.99	23.075	22.271	22.42	221100.0
2017-01-06	AAON	Stock	22.1	22.2667	21.7667	21.8	119100.0
2017-01-06	AAP	Stock	171.32	171.99	169.3	169.63	828000.0
2017-01-06	AAT	Stock	43.64	44.06	43.53	43.73	473600.0
2017-01-06	AAU-DELISTED	Stock	1.05	1.05	0.96	1.0	260691.0
2017-01-06	AAUAF-DELISTED	Stock	1.05	1.05	0.96	1.0	261852.0
2017-01-06	AAV-DELISTED	Stock	6.7	6.725	6.55	6.55	154209.0
2017-01-06	AAWW-DELISTED	Stock	51.35	51.55	50.6	50.7	95996.0
2017-01-06	AAXJ	Stock	56.58	56.63	56.4	56.53	993831.0
2017-01-06	AAXN-DELISTED	Stock	24.79	24.81	24.4687	24.55	262102.0
2017-01-06	AB	Stock	24.4	25.0	24.3	24.35	492900.0
2017-01-06	ABAC-DELISTED	Stock	3.7	3.7011	3.3601	3.7	4305.0
2017-01-06	ABAX-DELISTED	Stock	52.92	53.83	52.38	53.59	99243.0
2017-01-06	ABB-DELISTED	Stock	21.62	21.675	21.56	21.59	1078594.0
2017-01-06	ABBNY-DELISTED	Stock	21.62	21.675	21.56	21.6	1118277.0
2017-01-06	ABBV	Stock	63.88	64.0	63.52	63.79	4722300.0
2017-01-06	ABC-DELISTED	Stock	83.53	85.78	83.53	84.82	1856371.0
2017-01-06	ABCB	Stock	44.35	44.55	43.95	44.1	82600.0
2017-01-06	ABCD-DELISTED	Stock	5.15	5.15	5.0	5.03	14799.0
2017-01-06	ABCO-DELISTED	Stock	34.3	36.6	34.0	36.35	563750.0
2017-01-06	ABDC-DELISTED	Stock	12.4	12.48	12.03	12.45	43468.0
2017-01-06	ABE-DELISTED	Stock	11.46	11.46	11.45	11.46	1989.0
2017-01-06	ABEO	Stock	147.5	158.75	142.5	152.5	25840.0
2017-01-06	ABEOW-DELISTED	Stock	3.0	3.2	3.0	3.0195	896.0
2017-01-06	ABEV	Stock	5.13	5.15	5.05	5.09	17012000.0
2017-01-06	ABG	Stock	63.1	63.3	61.7	61.75	290100.0
2017-01-06	ABIL-DELISTED	Stock	3.2799	3.2799	3.13	3.1899	14200.0
2017-01-06	ABM	Stock	40.46	40.51	39.77	39.81	537200.0
2017-01-06	ABMD-DELISTED	Stock	115.05	115.9179	114.77	115.33	224625.0

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

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