PREVIEW / stock_daily / 2019-06-07

all stock daily files

  file:    by_date/stock_daily/2019/2019-06-07.parquet
  size:    220 KB
  rows:    6,565
  symbols: 2,566

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
2019-06-07	AAPL	Stock	46.6275	47.98	46.4425	47.5375	122737600.0
2019-06-07	MSFT	Stock	129.19	132.25	128.26	131.4	33885600.0
2019-06-07	NVDA	Stock	3.6005	3.672	3.5812	3.6375	348856000.0
2019-06-07	AMZN	Stock	88.185	90.3125	87.9745	90.2015	96164000.0
2019-06-07	GOOGL	Stock	52.714	53.6715	52.5575	53.4185	43827140.0
2019-06-07	META	Stock	170.17	173.87	168.84	173.35	16917300.0
2019-06-07	TSLA	Stock	13.6667	14.056	13.5667	13.6333	240052500.0
2019-06-07	TLT	Stock	131.79	132.07	131.438	131.74	11378665.0
2019-06-07	ES	Stock	77.53	77.73	76.3	76.3	1328000.0
2019-06-07	CL	Stock	73.2	74.14	73.13	73.99	3453800.0
2019-06-07	A	Stock	69.7	70.22	69.33	69.52	1547400.0
2019-06-07	AA	Stock	21.53	21.63	20.92	21.44	3970900.0
2019-06-07	AABA-DELISTED	Stock	61.01	62.47	61.01	61.9603	2790896.0
2019-06-07	AAC-DELISTED	Stock	0.9234	0.9648	0.88	0.911	477663.0
2019-06-07	AACG	Stock	2.0	2.05	1.94	1.99	30900.0
2019-06-07	AAIC-DELISTED	Stock	6.75	6.79	6.66	6.77	438760.0
2019-06-07	AAIC.C-DELISTED	Stock	21.65	21.8695	21.62	21.62	16418.0
2019-06-07	AAL	Stock	30.59	31.15	30.43	30.92	4843600.0
2019-06-07	AAM.A-DELISTED	Stock	25.8	25.8	25.7	25.74	29103.0
2019-06-07	AAM.B-DELISTED	Stock	25.8	25.8396	25.723	25.8	25683.0
2019-06-07	AAMC-DELISTED	Stock	4.2647	4.3971	4.0735	4.1088	21029.0
2019-06-07	AAME	Stock	2.45	2.45	2.45	2.45	500.0
2019-06-07	AAMI	Stock	10.95	11.06	10.83	10.99	341800.0
2019-06-07	AAOI	Stock	9.33	9.55	9.23	9.5	298900.0
2019-06-07	AAON	Stock	32.2467	32.9733	32.2467	32.5667	153900.0
2019-06-07	AAP	Stock	155.1	157.13	154.57	155.35	663300.0
2019-06-07	AAT	Stock	46.73	46.91	46.38	46.61	250300.0
2019-06-07	AAU-DELISTED	Stock	0.478	0.492	0.452	0.4917	146087.0
2019-06-07	AAUAF-DELISTED	Stock	0.478	0.492	0.452	0.4917	170555.0
2019-06-07	AAWW-DELISTED	Stock	38.19	39.99	38.03	39.87	222574.0
2019-06-07	AAXJ	Stock	66.56	67.19	66.56	66.71	582419.0
2019-06-07	AAXN-DELISTED	Stock	68.45	69.55	68.0	69.16	294358.0
2019-06-07	AB	Stock	28.06	28.34	27.99	28.0	203500.0
2019-06-07	ABB-DELISTED	Stock	19.24	19.39	19.22	19.24	1668213.0
2019-06-07	ABBNY-DELISTED	Stock	19.24	19.39	19.22	19.23	1745037.0
2019-06-07	ABBV	Stock	77.49	78.38	77.08	77.43	4829100.0
2019-06-07	ABC-DELISTED	Stock	82.33	83.67	81.96	83.46	996370.0
2019-06-07	ABCB	Stock	36.83	37.0	36.53	36.58	140500.0
2019-06-07	ABDC-DELISTED	Stock	8.19	8.1996	8.06	8.13	28165.0
2019-06-07	ABEO	Stock	131.75	134.5	129.75	132.5	11036.0
2019-06-07	ABEV	Stock	4.54	4.61	4.54	4.54	13608700.0
2019-06-07	ABG	Stock	77.5	78.45	77.5	77.95	115600.0
2019-06-07	ABIL-DELISTED	Stock	1.2	1.2	1.16	1.18	42398.0
2019-06-07	ABM	Stock	39.74	39.99	39.0	39.36	532000.0
2019-06-07	ABMD-DELISTED	Stock	270.29	274.59	266.14	267.87	272222.0
2019-06-07	ABR	Stock	12.46	12.52	12.36	12.51	1162700.0
2019-06-07	ABR.A-DELISTED	Stock	26.07	26.11	25.9874	26.08	4742.0
2019-06-07	ABR.B-DELISTED	Stock	25.6	25.7225	25.5	25.6	1800.0
2019-06-07	ABR.C-DELISTED	Stock	26.178	26.277	26.0401	26.1425	2430.0
2019-06-07	ABT	Stock	80.49	81.16	80.3	80.74	5136400.0

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

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