PREVIEW / stock_daily / 2017-12-21

all stock daily files

  file:    by_date/stock_daily/2017/2017-12-21.parquet
  size:    218 KB
  rows:    6,522
  symbols: 2,908

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-12-21	AAPL	Stock	43.5425	44.005	43.525	43.7525	83799600.0
2017-12-21	MSFT	Stock	86.05	86.1	85.4	85.5	17990700.0
2017-12-21	NVDA	Stock	4.9235	4.9488	4.8888	4.8972	300904000.0
2017-12-21	AMZN	Stock	58.795	58.9585	58.382	58.738	42462000.0
2017-12-21	GOOGL	Stock	53.7695	53.876	53.45	53.5425	25640500.0
2017-12-21	META	Stock	177.94	178.68	177.05	177.45	11600700.0
2017-12-21	TSLA	Stock	21.9727	22.2493	21.814	22.1107	65778000.0
2017-12-21	TLT	Stock	124.03	124.86	124.0	124.6	7026878.0
2017-12-21	ES	Stock	61.86	62.46	61.68	61.98	1579200.0
2017-12-21	CL	Stock	74.83	75.09	74.58	74.66	1916600.0
2017-12-21	A	Stock	67.51	67.87	67.27	67.52	1502200.0
2017-12-21	AA	Stock	49.285	49.68	48.77	48.99	3055800.0
2017-12-21	AAAP-DELISTED	Stock	81.58	81.63	81.57	81.59	378955.0
2017-12-21	AABA-DELISTED	Stock	71.0	72.17	70.88	71.6	6509161.0
2017-12-21	AAC-DELISTED	Stock	8.46	8.69	8.428	8.67	300575.0
2017-12-21	AACG	Stock	5.05	5.27	5.05	5.26	1200.0
2017-12-21	AAIC-DELISTED	Stock	12.41	12.56	12.3699	12.5	357071.0
2017-12-21	AAL	Stock	52.16	53.47	52.07	52.79	7125900.0
2017-12-21	AAM.A-DELISTED	Stock	26.21	26.4	26.21	26.4	11193.0
2017-12-21	AAMC-DELISTED	Stock	23.5294	23.5294	23.5294	23.5294	1353.0
2017-12-21	AAME	Stock	3.6	4.0	3.6	3.85	6300.0
2017-12-21	AAMI	Stock	16.95	17.08	16.84	16.85	210400.0
2017-12-21	AAOI	Stock	41.35	41.94	40.2	40.52	1076000.0
2017-12-21	AAON	Stock	24.0333	24.4333	23.9667	24.3333	176700.0
2017-12-21	AAP	Stock	98.51	100.52	98.2	100.13	1090000.0
2017-12-21	AAT	Stock	38.07	38.07	37.66	37.66	127200.0
2017-12-21	AAU-DELISTED	Stock	0.99	1.0379	0.99	1.02	259221.0
2017-12-21	AAUAF-DELISTED	Stock	0.99	1.0379	0.99	1.03	279089.0
2017-12-21	AAV-DELISTED	Stock	4.05	4.25	3.96	4.225	723649.0
2017-12-21	AAWW-DELISTED	Stock	59.5	60.35	58.9	59.9	157363.0
2017-12-21	AAXJ	Stock	74.74	75.2	74.72	75.01	2325757.0
2017-12-21	AAXN-DELISTED	Stock	25.96	26.6	25.54	26.38	621865.0
2017-12-21	AB	Stock	25.35	25.68	25.31	25.45	162900.0
2017-12-21	ABAC-DELISTED	Stock	2.93	3.01	2.82	2.96	23610.0
2017-12-21	ABAX-DELISTED	Stock	49.25	49.42	48.84	48.96	60960.0
2017-12-21	ABB-DELISTED	Stock	26.48	26.71	26.47	26.61	783770.0
2017-12-21	ABBNY-DELISTED	Stock	26.48	26.71	26.47	26.61	821332.0
2017-12-21	ABBV	Stock	97.82	98.35	97.72	97.91	2249500.0
2017-12-21	ABC-DELISTED	Stock	93.75	94.16	92.445	92.99	1199058.0
2017-12-21	ABCB	Stock	49.0	49.45	48.2	49.25	141900.0
2017-12-21	ABCD-DELISTED	Stock	5.73	5.85	5.72	5.7899	34264.0
2017-12-21	ABDC-DELISTED	Stock	8.55	8.7	8.5	8.52	70407.0
2017-12-21	ABE-DELISTED	Stock	14.32	14.52	14.32	14.4857	8602.0
2017-12-21	ABEO	Stock	376.25	380.0	368.75	373.75	17408.0
2017-12-21	ABEV	Stock	6.21	6.33	6.2	6.26	11363700.0
2017-12-21	ABG	Stock	65.35	66.1	64.5	64.7	138800.0
2017-12-21	ABIL-DELISTED	Stock	0.41	0.49	0.4021	0.4875	778291.0
2017-12-21	ABLX-DELISTED	Stock	24.17	24.2756	23.96	23.96	39512.0
2017-12-21	ABM	Stock	38.56	38.68	38.43	38.55	502600.0
2017-12-21	ABMD-DELISTED	Stock	194.95	195.65	190.05	190.69	151509.0

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

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