PREVIEW / stock_daily / 2019-12-18

all stock daily files

  file:    by_date/stock_daily/2019/2019-12-18.parquet
  size:    223 KB
  rows:    6,635
  symbols: 2,470

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-12-18	AAPL	Stock	69.95	70.475	69.78	69.935	116028400.0
2019-12-18	MSFT	Stock	154.3	155.48	154.18	154.37	24129200.0
2019-12-18	NVDA	Stock	5.7422	5.7985	5.7338	5.7378	343548000.0
2019-12-18	AMZN	Stock	89.751	89.91	89.118	89.2015	67028000.0
2019-12-18	GOOGL	Stock	67.85	67.9715	67.523	67.5955	23334660.0
2019-12-18	META	Stock	200.09	204.3	200.09	202.5	23274400.0
2019-12-18	TSLA	Stock	25.3753	26.348	25.372	26.21	211815000.0
2019-12-18	TLT	Stock	137.3	137.45	136.28	136.47	6244828.0
2019-12-18	ES	Stock	83.22	83.71	82.73	83.59	3030900.0
2019-12-18	CL	Stock	68.13	68.43	67.69	68.27	5846100.0
2019-12-18	A	Stock	83.75	84.05	83.36	83.43	2025500.0
2019-12-18	AA	Stock	20.6	21.035	20.5	20.95	5129800.0
2019-12-18	AACG	Stock	1.47	1.81	1.44	1.59	150500.0
2019-12-18	AAIC-DELISTED	Stock	5.56	5.71	5.56	5.7	439646.0
2019-12-18	AAIC.C-DELISTED	Stock	21.51	21.573	21.4101	21.573	12004.0
2019-12-18	AAL	Stock	28.35	28.57	27.93	28.0	4633800.0
2019-12-18	AAM.A-DELISTED	Stock	26.5952	26.6704	26.5952	26.6	6146.0
2019-12-18	AAM.B-DELISTED	Stock	27.18	27.26	27.14	27.21	17084.0
2019-12-18	AAMC-DELISTED	Stock	4.1088	4.2452	3.9706	3.9853	24079.0
2019-12-18	AAME	Stock	1.83	1.89	1.8	1.8	10900.0
2019-12-18	AAMI	Stock	10.11	10.205	10.05	10.06	510600.0
2019-12-18	AAOI	Stock	11.27	11.34	10.94	11.18	471500.0
2019-12-18	AAON	Stock	33.3333	33.4933	32.6733	33.2933	254850.0
2019-12-18	AAP	Stock	158.13	158.8	156.51	158.03	564900.0
2019-12-18	AAT	Stock	44.44	44.87	44.28	44.7	347300.0
2019-12-18	AAU-DELISTED	Stock	0.5	0.5111	0.49	0.5	235663.0
2019-12-18	AAUAF-DELISTED	Stock	0.5	0.5111	0.49	0.5	253381.0
2019-12-18	AAWW-DELISTED	Stock	28.52	28.52	27.22	27.26	566225.0
2019-12-18	AAXJ	Stock	72.83	72.98	72.76	72.95	1797821.0
2019-12-18	AAXN-DELISTED	Stock	71.38	71.72	69.52	69.83	358704.0
2019-12-18	AB	Stock	29.85	30.22	29.83	30.01	369000.0
2019-12-18	ABB-DELISTED	Stock	23.97	24.05	23.89	24.04	2782012.0
2019-12-18	ABBNY-DELISTED	Stock	23.97	24.05	23.89	24.04	3180792.0
2019-12-18	ABBV	Stock	90.05	90.18	89.02	89.33	6490100.0
2019-12-18	ABC-DELISTED	Stock	82.67	84.85	82.57	83.58	1217785.0
2019-12-18	ABCB	Stock	44.52	44.69	43.74	43.8	247800.0
2019-12-18	ABDC-DELISTED	Stock	9.16	9.18	9.09	9.14	23748.0
2019-12-18	ABEO	Stock	102.25	104.25	97.0	98.5	26420.0
2019-12-18	ABEOW-DELISTED	Stock	0.05	0.0501	0.05	0.0501	2160.0
2019-12-18	ABEV	Stock	4.67	4.69	4.62	4.68	23377900.0
2019-12-18	ABG	Stock	117.87	119.07	115.71	117.89	177600.0
2019-12-18	ABIL-DELISTED	Stock	0.54	0.5499	0.5019	0.5426	59743.0
2019-12-18	ABM	Stock	37.26	37.65	36.25	37.61	733000.0
2019-12-18	ABMD-DELISTED	Stock	179.85	181.1	176.69	176.99	223856.0
2019-12-18	ABR	Stock	14.46	14.6	14.41	14.48	727100.0
2019-12-18	ABR.A-DELISTED	Stock	26.3115	26.3115	26.2267	26.28	1485.0
2019-12-18	ABR.B-DELISTED	Stock	25.94	25.94	25.6427	25.7268	1006.0
2019-12-18	ABR.C-DELISTED	Stock	26.7329	26.7329	26.7329	26.7329	104.0
2019-12-18	ABT	Stock	87.08	87.27	86.61	86.93	5831100.0
2019-12-18	ABTC	Stock	330000.0	370500.0	320100.0	334800.0	13.799999999999999

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

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