PREVIEW / stock_daily / 2019-05-21

all stock daily files

  file:    by_date/stock_daily/2019/2019-05-21.parquet
  size:    220 KB
  rows:    6,539
  symbols: 2,557

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-05-21	AAPL	Stock	46.305	47.0	46.175	46.65	113459200.0
2019-05-21	MSFT	Stock	127.43	127.53	126.58	126.9	15293300.0
2019-05-21	NVDA	Stock	3.855	3.8925	3.816	3.8765	361848000.0
2019-05-21	AMZN	Stock	93.7395	93.95	92.3	92.876	80102000.0
2019-05-21	GOOGL	Stock	57.724	57.9	57.1655	57.722	20564960.0
2019-05-21	META	Stock	184.57	185.7	183.89	184.82	7502800.0
2019-05-21	TSLA	Stock	13.184	13.8267	13.0693	13.672	270058500.0
2019-05-21	TLT	Stock	125.6	125.72	125.3	125.53	4022162.0
2019-05-21	ES	Stock	73.62	74.16	73.38	73.74	1003500.0
2019-05-21	CL	Stock	71.71	71.91	71.49	71.53	2538200.0
2019-05-21	A	Stock	69.37	70.44	68.25	68.32	3928200.0
2019-05-21	AA	Stock	24.29	24.865	23.89	24.74	2769600.0
2019-05-21	AABA-DELISTED	Stock	65.4	66.08	64.97	65.34	6881039.0
2019-05-21	AAC-DELISTED	Stock	1.39	1.42	1.28	1.29	325547.0
2019-05-21	AACG	Stock	2.14	2.3	2.14	2.23	92600.0
2019-05-21	AAIC-DELISTED	Stock	7.24	7.31	7.2078	7.21	270273.0
2019-05-21	AAIC.C-DELISTED	Stock	23.58	23.58	23.5495	23.5495	714.0
2019-05-21	AAL	Stock	31.21	31.64	31.13	31.3	4986900.0
2019-05-21	AAM.A-DELISTED	Stock	25.69	25.7	25.64	25.6999	33994.0
2019-05-21	AAM.B-DELISTED	Stock	25.66	25.76	25.64	25.65	126284.0
2019-05-21	AAMC-DELISTED	Stock	7.1735	7.1765	5.7382	6.1725	20121.0
2019-05-21	AAME	Stock	2.28	2.51	2.26	2.26	15600.0
2019-05-21	AAMI	Stock	11.92	12.1	11.915	11.95	315800.0
2019-05-21	AAOI	Stock	9.46	9.71	9.41	9.52	584300.0
2019-05-21	AAON	Stock	31.3867	32.0667	31.3333	31.9467	148650.0
2019-05-21	AAP	Stock	159.02	161.72	156.65	161.3	1821300.0
2019-05-21	AAT	Stock	45.51	46.05	45.51	45.97	166200.0
2019-05-21	AAU-DELISTED	Stock	0.478	0.478	0.444	0.4465	135769.0
2019-05-21	AAUAF-DELISTED	Stock	0.478	0.478	0.444	0.4465	138874.0
2019-05-21	AAWW-DELISTED	Stock	39.33	40.48	39.065	40.37	171942.0
2019-05-21	AAXJ	Stock	66.39	66.5	66.1	66.48	1053758.0
2019-05-21	AAXN-DELISTED	Stock	65.98	67.93	65.24	67.84	381458.0
2019-05-21	AB	Stock	28.7	29.17	28.7	29.04	157200.0
2019-05-21	ABB-DELISTED	Stock	18.91	19.015	18.825	18.87	2539667.0
2019-05-21	ABBNY-DELISTED	Stock	18.91	19.015	18.825	18.88	2625083.0
2019-05-21	ABBV	Stock	80.33	81.5	80.32	80.88	4841900.0
2019-05-21	ABC-DELISTED	Stock	79.78	81.26	79.47	80.58	1196860.0
2019-05-21	ABCB	Stock	36.07	36.59	35.96	36.34	138100.0
2019-05-21	ABDC-DELISTED	Stock	8.47	8.64	8.4487	8.5	30764.0
2019-05-21	ABEO	Stock	185.75	187.5	182.0	185.5	11640.0
2019-05-21	ABEV	Stock	4.09	4.25	4.05	4.21	19373000.0
2019-05-21	ABG	Stock	78.11	79.11	77.7	78.66	102500.0
2019-05-21	ABIL-DELISTED	Stock	1.26	1.3	1.24	1.2652	32515.0
2019-05-21	ABM	Stock	37.76	38.06	37.57	37.87	307600.0
2019-05-21	ABMD-DELISTED	Stock	253.99	263.9	253.27	260.46	518563.0
2019-05-21	ABR	Stock	13.24	13.4	13.16	13.37	1752400.0
2019-05-21	ABR.A-DELISTED	Stock	25.6718	25.8071	25.5001	25.5001	4453.0
2019-05-21	ABR.B-DELISTED	Stock	25.8873	25.8896	25.7989	25.7989	1900.0
2019-05-21	ABR.C-DELISTED	Stock	26.28	26.28	26.15	26.15	2103.0
2019-05-21	ABT	Stock	76.56	76.82	76.02	76.03	3819700.0

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

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