PREVIEW / stock_daily / 2018-01-23

all stock daily files

  file:    by_date/stock_daily/2018/2018-01-23.parquet
  size:    218 KB
  rows:    6,482
  symbols: 2,869

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
2018-01-23	AAPL	Stock	44.325	44.86	44.205	44.26	130756400.0
2018-01-23	MSFT	Stock	91.9	92.3	91.54	91.9	23412800.0
2018-01-23	NVDA	Stock	5.8962	5.9958	5.8775	5.9728	475228000.0
2018-01-23	AMZN	Stock	66.9045	68.245	66.867	68.127	103386000.0
2018-01-23	GOOGL	Stock	58.531	58.9255	58.3625	58.8085	39137300.0
2018-01-23	META	Stock	186.05	189.55	185.55	189.35	25678800.0
2018-01-23	TSLA	Stock	24.0	24.0333	23.4	23.5193	81981000.0
2018-01-23	TLT	Stock	123.81	124.2	123.24	123.71	12325687.0
2018-01-23	ES	Stock	60.2	61.63	60.18	61.12	3995700.0
2018-01-23	CL	Stock	77.0	77.17	76.37	76.9	3388900.0
2018-01-23	A	Stock	74.05	74.08	73.25	73.44	1213400.0
2018-01-23	AA	Stock	52.34	52.9	51.73	52.49	4892100.0
2018-01-23	AAAP-DELISTED	Stock	82.1	82.21	81.96	82.02	21054.0
2018-01-23	AABA-DELISTED	Stock	74.66	76.76	74.0	76.57	13103159.0
2018-01-23	AAC-DELISTED	Stock	9.05	9.11	9.0	9.02	45842.0
2018-01-23	AACG	Stock	5.52	5.55	5.29	5.29	4600.0
2018-01-23	AAIC-DELISTED	Stock	11.7	11.76	11.64	11.66	460533.0
2018-01-23	AAL	Stock	57.74	58.46	57.4	58.29	3337000.0
2018-01-23	AAM.A-DELISTED	Stock	25.71	25.71	25.6401	25.68	18062.0
2018-01-23	AAMC-DELISTED	Stock	19.9118	19.9118	19.9118	19.9118	768.0
2018-01-23	AAME	Stock	3.5	3.5	3.5	3.5	1700.0
2018-01-23	AAMI	Stock	18.41	18.58	18.35	18.44	421200.0
2018-01-23	AAOI	Stock	34.42	35.09	33.85	35.09	695200.0
2018-01-23	AAON	Stock	24.2	24.2	23.9333	24.0333	228150.0
2018-01-23	AAP	Stock	117.74	119.14	116.6	119.1	1277000.0
2018-01-23	AAT	Stock	36.4	36.65	36.28	36.65	107300.0
2018-01-23	AAU-DELISTED	Stock	0.9	0.9675	0.8857	0.9281	174817.0
2018-01-23	AAUAF-DELISTED	Stock	0.9	0.9675	0.8857	0.9281	188401.0
2018-01-23	AAV-DELISTED	Stock	3.5	3.65	3.42	3.625	597316.0
2018-01-23	AAWW-DELISTED	Stock	62.35	62.6	61.4	62.25	82209.0
2018-01-23	AAXJ	Stock	81.98	82.29	81.8	82.25	1120904.0
2018-01-23	AAXN-DELISTED	Stock	27.44	27.49	27.17	27.46	132197.0
2018-01-23	AB	Stock	27.45	27.58	27.35	27.4	155800.0
2018-01-23	ABAC-DELISTED	Stock	2.96	2.98	2.85	2.97	5199.0
2018-01-23	ABAX-DELISTED	Stock	62.55	64.45	62.2178	64.33	213675.0
2018-01-23	ABB-DELISTED	Stock	28.15	28.25	28.105	28.15	1397801.0
2018-01-23	ABBNY-DELISTED	Stock	28.15	28.25	28.105	28.16	1467609.0
2018-01-23	ABBV	Stock	106.17	106.97	105.03	105.38	5095300.0
2018-01-23	ABC-DELISTED	Stock	103.0	103.67	102.1	102.83	1184026.0
2018-01-23	ABCB	Stock	53.8	54.15	53.55	54.05	100900.0
2018-01-23	ABCD-DELISTED	Stock	6.88	7.07	6.751	7.0	103584.0
2018-01-23	ABDC-DELISTED	Stock	8.25	8.273	8.12	8.15	50283.0
2018-01-23	ABE-DELISTED	Stock	15.48	15.53	15.43	15.45	9097.0
2018-01-23	ABEO	Stock	390.0	411.25	376.25	385.0	43628.0
2018-01-23	ABEOW-DELISTED	Stock	10.75	10.75	10.48	10.48	1371.0
2018-01-23	ABEV	Stock	6.71	6.77	6.65	6.71	16051900.0
2018-01-23	ABG	Stock	74.85	75.5	73.85	75.2	250900.0
2018-01-23	ABIL-DELISTED	Stock	0.5398	0.5398	0.488	0.4933	194039.0
2018-01-23	ABLX-DELISTED	Stock	43.52	44.11	43.52	43.96	128583.0
2018-01-23	ABM	Stock	39.49	39.54	38.8	39.33	471200.0

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

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