PREVIEW / stock_daily / 2017-01-25

all stock daily files

  file:    by_date/stock_daily/2017/2017-01-25.parquet
  size:    216 KB
  rows:    6,498
  symbols: 3,104

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-25	AAPL	Stock	30.105	30.525	30.07	30.47	129510400.0
2017-01-25	MSFT	Stock	63.95	64.1	63.45	63.68	23672700.0
2017-01-25	NVDA	Stock	2.7263	2.7325	2.6583	2.6948	522760000.0
2017-01-25	AMZN	Stock	41.2895	41.871	41.2645	41.826	78452000.0
2017-01-25	GOOGL	Stock	42.6775	42.9397	42.487	42.9225	33242960.0
2017-01-25	META	Stock	130.0	131.74	129.77	131.48	18731300.0
2017-01-25	TSLA	Stock	17.154	17.2307	16.7867	16.9647	77139000.0
2017-01-25	TLT	Stock	119.28	119.6	118.56	118.8	11115069.0
2017-01-25	ES	Stock	54.37	54.77	54.12	54.3	1134900.0
2017-01-25	CL	Stock	68.2	68.45	68.02	68.43	3034800.0
2017-01-25	A	Stock	47.6	48.42	47.41	48.41	3073200.0
2017-01-25	AA	Stock	38.58	38.94	36.31	36.53	13583300.0
2017-01-25	AAAP-DELISTED	Stock	29.51	30.78	29.48	30.78	126230.0
2017-01-25	AABA-DELISTED	Stock	44.13	45.0	44.09	44.94	11105113.0
2017-01-25	AAC-DELISTED	Stock	8.2	8.29	8.12	8.16	69475.0
2017-01-25	AACG	Stock	3.02	3.14	3.02	3.02	1200.0
2017-01-25	AAIC-DELISTED	Stock	15.4	15.48	15.21	15.24	195818.0
2017-01-25	AAL	Stock	47.9	48.21	47.61	47.91	5075800.0
2017-01-25	AAMC-DELISTED	Stock	18.8529	18.8529	18.0147	18.3676	7364.0
2017-01-25	AAMI	Stock	14.75	14.9	14.61	14.67	244100.0
2017-01-25	AAOI	Stock	32.25	32.25	31.2	31.71	445800.0
2017-01-25	AAON	Stock	22.8333	23.3667	22.7667	23.1	182550.0
2017-01-25	AAP	Stock	169.4	170.31	167.0	167.5	969100.0
2017-01-25	AAT	Stock	43.9	44.11	43.37	43.4	134400.0
2017-01-25	AAU-DELISTED	Stock	1.0	1.05	1.0	1.03	209304.0
2017-01-25	AAUAF-DELISTED	Stock	1.0	1.05	1.0	1.04	214596.0
2017-01-25	AAV-DELISTED	Stock	6.5	6.65	6.5	6.6	66830.0
2017-01-25	AAWW-DELISTED	Stock	52.3	54.65	51.85	54.45	248926.0
2017-01-25	AAXJ	Stock	58.79	59.045	58.73	59.02	538822.0
2017-01-25	AAXN-DELISTED	Stock	25.39	25.5	24.89	25.11	357946.0
2017-01-25	AB	Stock	23.5	23.63	23.35	23.45	267300.0
2017-01-25	ABAC-DELISTED	Stock	3.75	3.92	3.73	3.79	20894.0
2017-01-25	ABAX-DELISTED	Stock	48.0	48.45	47.42	48.0	187778.0
2017-01-25	ABB-DELISTED	Stock	23.41	23.5763	23.39	23.5	2122359.0
2017-01-25	ABBNY-DELISTED	Stock	23.41	23.5763	23.39	23.5	2216167.0
2017-01-25	ABBV	Stock	60.6	61.63	60.34	61.38	8052800.0
2017-01-25	ABC-DELISTED	Stock	84.9	85.92	84.58	85.85	1627147.0
2017-01-25	ABCB	Stock	44.6	46.15	44.45	45.85	257800.0
2017-01-25	ABCD-DELISTED	Stock	5.28	5.38	5.23	5.2401	30885.0
2017-01-25	ABCO-DELISTED	Stock	43.7	44.2	43.4	44.0	724986.0
2017-01-25	ABDC-DELISTED	Stock	12.25	12.39	12.05	12.2799	59327.0
2017-01-25	ABE-DELISTED	Stock	11.79	11.8299	11.79	11.8299	1722.0
2017-01-25	ABEO	Stock	120.0	125.0	116.25	121.25	3856.0
2017-01-25	ABEV	Stock	5.47	5.5	5.45	5.48	9546500.0
2017-01-25	ABG	Stock	65.95	68.0	65.95	67.45	223400.0
2017-01-25	ABIL-DELISTED	Stock	3.16	3.41	3.0725	3.15	63437.0
2017-01-25	ABM	Stock	40.47	41.34	40.47	40.68	993800.0
2017-01-25	ABMD-DELISTED	Stock	113.43	115.68	113.2	114.81	320648.0
2017-01-25	ABR	Stock	7.5	7.53	7.41	7.44	102000.0
2017-01-25	ABR.A-DELISTED	Stock	25.45	25.45	25.4	25.4	350.0

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

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