PREVIEW / stock_daily / 2017-04-12

all stock daily files

  file:    by_date/stock_daily/2017/2017-04-12.parquet
  size:    214 KB
  rows:    6,415
  symbols: 3,008

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-04-12	AAPL	Stock	35.4	35.5375	35.2525	35.45	81400000.0
2017-04-12	MSFT	Stock	65.42	65.51	65.11	65.23	17108500.0
2017-04-12	NVDA	Stock	2.453	2.4675	2.4275	2.4328	414092000.0
2017-04-12	AMZN	Stock	45.1545	45.2045	44.7625	44.8115	49122000.0
2017-04-12	GOOGL	Stock	41.923	42.186	41.8795	42.073	22715500.0
2017-04-12	META	Stock	139.72	140.4	139.44	139.58	11612500.0
2017-04-12	TSLA	Stock	20.4227	20.5633	19.7547	19.7893	90760500.0
2017-04-12	TLT	Stock	122.51	123.185	122.29	123.09	11532463.0
2017-04-12	ES	Stock	59.08	59.91	58.99	59.88	1280400.0
2017-04-12	CL	Stock	73.63	74.1	73.44	74.0	2816600.0
2017-04-12	A	Stock	52.85	53.03	52.47	52.55	1258200.0
2017-04-12	AA	Stock	33.86	34.29	32.03	32.05	7603400.0
2017-04-12	AAAP-DELISTED	Stock	38.17	38.54	37.4	37.75	30704.0
2017-04-12	AABA-DELISTED	Stock	46.8	47.16	46.67	46.835	4883505.0
2017-04-12	AAC-DELISTED	Stock	8.24	8.33	8.125	8.2	81471.0
2017-04-12	AACG	Stock	3.92	3.92	3.65	3.65	9800.0
2017-04-12	AAIC-DELISTED	Stock	14.2	14.26	14.0	14.02	253250.0
2017-04-12	AAL	Stock	44.79	45.35	43.83	43.96	9991100.0
2017-04-12	AAM.A-DELISTED	Stock	25.26	25.41	25.26	25.4	163868.0
2017-04-12	AAMC-DELISTED	Stock	20.5882	21.1029	20.0588	20.9236	28404.0
2017-04-12	AAME	Stock	3.8	4.0	3.8	3.8	1600.0
2017-04-12	AAMI	Stock	15.04	15.13	14.79	14.87	162100.0
2017-04-12	AAOI	Stock	42.04	42.489	40.28	40.82	2503000.0
2017-04-12	AAON	Stock	23.4333	23.4667	22.8	22.8667	157200.0
2017-04-12	AAP	Stock	142.91	142.91	141.07	141.74	596100.0
2017-04-12	AAT	Stock	43.6	44.3	43.31	44.02	482000.0
2017-04-12	AAU-DELISTED	Stock	1.51	1.71	1.5	1.65	2791578.0
2017-04-12	AAUAF-DELISTED	Stock	1.51	1.71	1.5	1.65	2853703.0
2017-04-12	AAV-DELISTED	Stock	6.8	6.85	6.65	6.7	59936.0
2017-04-12	AAWW-DELISTED	Stock	55.5	55.55	54.85	55.225	187871.0
2017-04-12	AAXJ	Stock	62.86	62.87	62.57	62.86	745449.0
2017-04-12	AAXN-DELISTED	Stock	23.27	23.35	22.34	22.43	797415.0
2017-04-12	AB	Stock	23.1	23.15	22.55	22.95	616400.0
2017-04-12	ABAC-DELISTED	Stock	2.71	2.71	2.55	2.56	9280.0
2017-04-12	ABAX-DELISTED	Stock	47.72	47.78	46.55	47.05	78823.0
2017-04-12	ABB-DELISTED	Stock	22.94	22.9653	22.825	22.915	1309358.0
2017-04-12	ABBNY-DELISTED	Stock	22.95	22.9653	22.825	22.91	1738085.0
2017-04-12	ABBV	Stock	64.17	64.41	63.67	64.37	6122000.0
2017-04-12	ABC-DELISTED	Stock	87.15	87.59	86.14	86.82	1432404.0
2017-04-12	ABCB	Stock	44.65	44.8	43.95	44.0	90500.0
2017-04-12	ABCD-DELISTED	Stock	4.9	4.9	4.785	4.88	22160.0
2017-04-12	ABCO-DELISTED	Stock	47.55	47.75	46.95	47.2	149374.0
2017-04-12	ABDC-DELISTED	Stock	14.03	14.2	13.46	14.14	50021.0
2017-04-12	ABE-DELISTED	Stock	13.5	13.5262	13.45	13.48	14621.0
2017-04-12	ABEO	Stock	121.25	125.0	118.75	122.5	5504.0
2017-04-12	ABEV	Stock	5.6	5.63	5.55	5.63	16931800.0
2017-04-12	ABG	Stock	59.5	59.8	58.95	59.05	285100.0
2017-04-12	ABIL-DELISTED	Stock	1.2499	1.25	1.17	1.21	41683.0
2017-04-12	ABM	Stock	42.32	42.85	42.16	42.45	569300.0
2017-04-12	ABMD-DELISTED	Stock	125.87	126.17	125.27	125.49	120903.0

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

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