PREVIEW / stock_daily / 2017-03-14

all stock daily files

  file:    by_date/stock_daily/2017/2017-03-14.parquet
  size:    215 KB
  rows:    6,454
  symbols: 3,045

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-03-14	AAPL	Stock	34.825	34.9125	34.71	34.7475	61236400.0
2017-03-14	MSFT	Stock	64.53	64.55	64.15	64.41	14280200.0
2017-03-14	NVDA	Stock	2.5593	2.5688	2.5118	2.5445	522016000.0
2017-03-14	AMZN	Stock	42.6775	42.6875	42.3775	42.6265	42612000.0
2017-03-14	GOOGL	Stock	43.1875	43.379	43.0065	43.2955	21233840.0
2017-03-14	META	Stock	139.46	139.46	138.52	139.32	12944000.0
2017-03-14	TSLA	Stock	16.4073	17.208	16.4013	17.2	113976000.0
2017-03-14	TLT	Stock	116.77	117.35	116.71	117.07	9869230.0
2017-03-14	ES	Stock	58.0	58.34	57.72	58.33	1630800.0
2017-03-14	CL	Stock	73.56	74.06	73.49	73.65	3502300.0
2017-03-14	A	Stock	52.22	52.26	51.96	52.21	1203400.0
2017-03-14	AA	Stock	34.45	34.58	33.77	34.19	3112200.0
2017-03-14	AAAP-DELISTED	Stock	37.38	37.53	36.09	36.55	29176.0
2017-03-14	AABA-DELISTED	Stock	46.41	46.755	46.19	46.36	3511223.0
2017-03-14	AAC-DELISTED	Stock	8.66	8.72	8.37	8.63	124407.0
2017-03-14	AACG	Stock	3.61	3.69	3.48	3.65	16100.0
2017-03-14	AAIC-DELISTED	Stock	13.6	13.64	13.46	13.51	226113.0
2017-03-14	AAL	Stock	42.06	42.1	40.84	41.21	10208500.0
2017-03-14	AAM.A-DELISTED	Stock	24.64	24.75	24.59	24.7377	131260.0
2017-03-14	AAMC-DELISTED	Stock	21.9412	22.5882	21.2647	21.9265	18799.0
2017-03-14	AAMI	Stock	14.98	15.09	14.92	15.04	403100.0
2017-03-14	AAOI	Stock	50.57	50.65	47.87	48.19	1139400.0
2017-03-14	AAON	Stock	23.4	23.6667	23.2667	23.5667	189900.0
2017-03-14	AAP	Stock	154.3	154.64	152.9	153.71	896600.0
2017-03-14	AAT	Stock	41.42	41.8	41.36	41.67	174700.0
2017-03-14	AAU-DELISTED	Stock	1.02	1.038	0.98	0.98	173982.0
2017-03-14	AAUAF-DELISTED	Stock	1.02	1.038	0.98	0.98	175047.0
2017-03-14	AAV-DELISTED	Stock	5.9	6.0	5.75	5.85	92703.0
2017-03-14	AAWW-DELISTED	Stock	53.7	54.4	53.3	53.65	138494.0
2017-03-14	AAXJ	Stock	61.3	61.32	61.11	61.12	411645.0
2017-03-14	AAXN-DELISTED	Stock	22.7	22.96	22.58	22.91	570324.0
2017-03-14	AB	Stock	22.7	22.7	22.5	22.55	151900.0
2017-03-14	ABAC-DELISTED	Stock	2.44	2.53	2.2701	2.38	15894.0
2017-03-14	ABAX-DELISTED	Stock	49.04	49.47	48.63	48.74	53874.0
2017-03-14	ABB-DELISTED	Stock	22.57	22.62	22.51	22.56	1613084.0
2017-03-14	ABBNY-DELISTED	Stock	22.57	22.62	22.51	22.57	1664599.0
2017-03-14	ABBV	Stock	65.88	66.05	65.6	65.67	3727200.0
2017-03-14	ABC-DELISTED	Stock	88.96	89.2	88.04	88.81	1065206.0
2017-03-14	ABCB	Stock	46.0	46.6	45.25	46.5	185900.0
2017-03-14	ABCD-DELISTED	Stock	4.8	4.8	4.58	4.74	142896.0
2017-03-14	ABCO-DELISTED	Stock	45.0	45.6	44.95	45.35	290036.0
2017-03-14	ABDC-DELISTED	Stock	13.25	13.2999	13.15	13.21	86075.0
2017-03-14	ABE-DELISTED	Stock	12.26	12.26	12.17	12.19	18476.0
2017-03-14	ABEO	Stock	141.25	143.75	128.75	131.25	8756.0
2017-03-14	ABEV	Stock	5.43	5.46	5.34	5.34	9064900.0
2017-03-14	ABG	Stock	62.15	62.7	61.4	62.55	176400.0
2017-03-14	ABIL-DELISTED	Stock	2.31	2.37	2.29	2.35	3123.0
2017-03-14	ABM	Stock	43.54	43.59	42.91	43.51	300500.0
2017-03-14	ABMD-DELISTED	Stock	122.22	122.22	120.25	120.51	131581.0
2017-03-14	ABR	Stock	7.65	7.67	7.53	7.66	61500.0

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

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