PREVIEW / stock_daily / 2018-01-05

all stock daily files

  file:    by_date/stock_daily/2018/2018-01-05.parquet
  size:    218 KB
  rows:    6,509
  symbols: 2,896

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-05	AAPL	Stock	43.36	43.8425	43.2625	43.75	94640000.0
2018-01-05	MSFT	Stock	87.66	88.41	87.43	88.19	23407100.0
2018-01-05	NVDA	Stock	5.3548	5.4228	5.277	5.385	580124000.0
2018-01-05	AMZN	Stock	60.8755	61.457	60.5	61.457	70894000.0
2018-01-05	GOOGL	Stock	55.1725	55.679	55.0898	55.5145	30250520.0
2018-01-05	META	Stock	185.59	186.9	184.93	186.85	13574500.0
2018-01-05	TSLA	Stock	21.108	21.1493	20.8	21.1053	68868000.0
2018-01-05	TLT	Stock	125.87	126.18	125.36	125.71	10915437.0
2018-01-05	ES	Stock	61.85	62.09	61.37	61.82	2265100.0
2018-01-05	CL	Stock	75.5	75.58	75.14	75.42	2852800.0
2018-01-05	A	Stock	68.73	70.1	68.73	69.9	1632500.0
2018-01-05	AA	Stock	54.65	54.66	53.41	54.09	3371400.0
2018-01-05	AAAP-DELISTED	Stock	81.86	81.86	81.71	81.83	260497.0
2018-01-05	AABA-DELISTED	Stock	75.08	76.57	74.9101	76.49	4914367.0
2018-01-05	AAC-DELISTED	Stock	9.32	9.36	9.09	9.13	88205.0
2018-01-05	AACG	Stock	5.39	5.72	5.21	5.4	17400.0
2018-01-05	AAIC-DELISTED	Stock	11.75	11.76	11.63	11.75	362898.0
2018-01-05	AAL	Stock	52.78	52.84	52.43	52.65	2967800.0
2018-01-05	AAM.A-DELISTED	Stock	26.03	26.22	26.03	26.08	21879.0
2018-01-05	AAME	Stock	3.25	3.65	3.25	3.65	7600.0
2018-01-05	AAMI	Stock	16.9	16.975	16.8	16.95	459800.0
2018-01-05	AAOI	Stock	38.7	39.17	38.04	38.89	679900.0
2018-01-05	AAON	Stock	25.0333	25.5	25.0333	25.3667	204300.0
2018-01-05	AAP	Stock	111.96	113.15	110.3	112.18	1996700.0
2018-01-05	AAT	Stock	37.15	37.28	36.92	37.14	128900.0
2018-01-05	AAU-DELISTED	Stock	0.99	1.02	0.99	1.0	93703.0
2018-01-05	AAUAF-DELISTED	Stock	0.99	1.02	0.99	1.0	100747.0
2018-01-05	AAV-DELISTED	Stock	4.25	4.25	3.95	4.025	496860.0
2018-01-05	AAWW-DELISTED	Stock	59.6	59.9	56.4	56.5	282461.0
2018-01-05	AAXJ	Stock	78.99	79.43	78.9101	79.41	686202.0
2018-01-05	AAXN-DELISTED	Stock	26.85	27.1	26.6204	26.85	329148.0
2018-01-05	AB	Stock	25.9	26.23	25.85	26.2	229000.0
2018-01-05	ABAC-DELISTED	Stock	2.8098	3.234	2.8098	2.96	16172.0
2018-01-05	ABAX-DELISTED	Stock	51.02	55.52	50.36	54.99	358721.0
2018-01-05	ABB-DELISTED	Stock	27.46	27.68	27.45	27.63	1846819.0
2018-01-05	ABBNY-DELISTED	Stock	27.46	27.68	27.45	27.63	2399968.0
2018-01-05	ABBV	Stock	99.34	101.2	98.56	101.11	4599300.0
2018-01-05	ABC-DELISTED	Stock	93.77	95.63	93.77	95.33	1169582.0
2018-01-05	ABCB	Stock	49.6	50.53	49.45	50.4	422700.0
2018-01-05	ABCD-DELISTED	Stock	5.9	5.98	5.86	5.95	80311.0
2018-01-05	ABDC-DELISTED	Stock	8.52	8.67	8.46	8.65	85825.0
2018-01-05	ABE-DELISTED	Stock	15.0	15.0966	14.9816	15.0	14337.0
2018-01-05	ABEO	Stock	422.5	422.5	387.5	391.25	21096.0
2018-01-05	ABEOW-DELISTED	Stock	11.88	11.88	10.6	10.6	5174.0
2018-01-05	ABEV	Stock	6.63	6.69	6.59	6.67	14237800.0
2018-01-05	ABG	Stock	64.15	66.65	64.0	66.55	323600.0
2018-01-05	ABIL-DELISTED	Stock	0.48	0.4992	0.4553	0.465	207755.0
2018-01-05	ABLX-DELISTED	Stock	25.2	26.0	25.2	26.0	139673.0
2018-01-05	ABM	Stock	38.5	39.08	38.2	39.02	391700.0
2018-01-05	ABMD-DELISTED	Stock	200.78	202.96	200.78	202.28	210388.0

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

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