PREVIEW / stock_daily / 2020-10-23

all stock daily files

  file:    by_date/stock_daily/2020/2020-10-23.parquet
  size:    228 KB
  rows:    6,951
  symbols: 2,477

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
2020-10-23	AAPL	Stock	116.39	116.55	114.28	115.04	82572600.0
2020-10-23	MSFT	Stock	215.03	216.28	213.16	216.23	18879600.0
2020-10-23	NVDA	Stock	13.45	13.5932	13.2912	13.5902	233484000.0
2020-10-23	AMZN	Stock	159.55	160.2665	157.0	160.22	69334000.0
2020-10-23	GOOGL	Stock	80.7525	81.706	80.5955	81.649	30548040.0
2020-10-23	META	Stock	278.8	285.24	276.82	284.79	17535200.0
2020-10-23	TSLA	Stock	140.6133	140.9633	135.7933	140.21	101151000.0
2020-10-23	TLT	Stock	156.81	158.21	156.75	158.01	8784136.0
2020-10-23	ES	Stock	93.28	93.36	91.65	91.97	1217400.0
2020-10-23	CL	Stock	79.55	80.0	79.32	79.34	2259400.0
2020-10-23	A	Stock	107.23	107.38	105.47	106.17	833900.0
2020-10-23	AA	Stock	13.8	14.14	13.47	13.47	5307300.0
2020-10-23	AACG	Stock	1.25	1.25	1.2	1.23	23400.0
2020-10-23	AACQ-DELISTED	Stock	9.73	9.78	9.7	9.76	158705.0
2020-10-23	AACQU-DELISTED	Stock	10.15	10.215	10.08	10.09	108773.0
2020-10-23	AACQW-DELISTED	Stock	1.32	1.33	1.2202	1.305	73815.0
2020-10-23	AAIC-DELISTED	Stock	2.62	2.77	2.62	2.73	202699.0
2020-10-23	AAL	Stock	13.07	13.08	12.42	12.6	90787900.0
2020-10-23	AAM.A-DELISTED	Stock	26.13	26.44	26.1	26.4	18923.0
2020-10-23	AAM.B-DELISTED	Stock	27.13	27.33	27.0901	27.15	24773.0
2020-10-23	AAMC-DELISTED	Stock	6.7794	6.9618	6.7618	6.9118	12240.0
2020-10-23	AAME	Stock	2.22	2.3	2.22	2.25	7400.0
2020-10-23	AAMI	Stock	15.22	15.43	15.05	15.19	319000.0
2020-10-23	AAOI	Stock	10.44	10.54	10.07	10.17	669300.0
2020-10-23	AAON	Stock	40.9267	41.3867	40.7667	41.24	131700.0
2020-10-23	AAP	Stock	153.42	155.17	151.78	154.72	543600.0
2020-10-23	AAT	Stock	24.57	24.75	24.17	24.37	120200.0
2020-10-23	AAU-DELISTED	Stock	0.9562	0.9562	0.9	0.9312	291490.0
2020-10-23	AAUAF-DELISTED	Stock	0.9562	0.9562	0.9	0.935	310878.0
2020-10-23	AAWW-DELISTED	Stock	63.68	64.08	61.81	63.0	250287.0
2020-10-23	AAXJ	Stock	80.34	80.795	80.025	80.79	620980.0
2020-10-23	AAXN-DELISTED	Stock	104.2	104.72	102.16	102.87	424114.0
2020-10-23	AB	Stock	32.57	32.61	31.07	31.55	715500.0
2020-10-23	ABB-DELISTED	Stock	26.23	26.27	25.94	26.13	1812377.0
2020-10-23	ABBNY-DELISTED	Stock	26.23	26.27	25.94	26.13	1945621.0
2020-10-23	ABBV	Stock	84.64	85.15	83.94	84.34	4238700.0
2020-10-23	ABC-DELISTED	Stock	99.3	99.7	98.54	99.38	398427.0
2020-10-23	ABCB	Stock	30.0	30.75	28.42	29.14	761300.0
2020-10-23	ABCM-DELISTED	Stock	19.0	19.69	18.67	18.9	1545265.0
2020-10-23	ABEO	Stock	31.75	34.25	31.25	33.5	45248.0
2020-10-23	ABEV	Stock	2.45	2.51	2.43	2.51	25366800.0
2020-10-23	ABG	Stock	120.51	120.51	117.1	118.94	75400.0
2020-10-23	ABM	Stock	35.05	35.75	34.92	35.67	391500.0
2020-10-23	ABMD-DELISTED	Stock	277.59	281.99	276.37	281.32	136843.0
2020-10-23	ABR	Stock	11.6	11.9	11.58	11.89	1114800.0
2020-10-23	ABR.A-DELISTED	Stock	25.23	25.3008	25.16	25.16	1610.0
2020-10-23	ABR.B-DELISTED	Stock	25.09	25.1	24.99	24.99	4404.0
2020-10-23	ABR.C-DELISTED	Stock	25.47	25.68	25.451	25.68	2000.0
2020-10-23	ABT	Stock	109.64	110.0	107.57	107.79	3573000.0
2020-10-23	ABTC	Stock	111600.0	117900.0	109500.0	113100.0	6.933333333333334

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

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