PREVIEW / stock_daily / 2020-12-02

all stock daily files

  file:    by_date/stock_daily/2020/2020-12-02.parquet
  size:    235 KB
  rows:    7,140
  symbols: 2,570

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-12-02	AAPL	Stock	122.02	123.37	120.89	123.08	89004200.0
2020-12-02	MSFT	Stock	214.88	215.47	212.8	215.37	23724500.0
2020-12-02	NVDA	Stock	13.3505	13.6735	13.2342	13.5445	283360000.0
2020-12-02	AMZN	Stock	161.0825	161.6	158.663	160.1765	62586000.0
2020-12-02	GOOGL	Stock	89.768	91.637	89.2585	91.2485	29424700.0
2020-12-02	META	Stock	285.36	291.78	280.83	287.52	17361600.0
2020-12-02	TSLA	Stock	185.48	190.5133	180.4033	189.6067	143327100.0
2020-12-02	TLT	Stock	156.88	156.93	155.48	156.25	12114580.0
2020-12-02	ES	Stock	87.95	88.33	87.1	88.15	1415100.0
2020-12-02	CL	Stock	86.07	86.38	85.25	85.74	2740100.0
2020-12-02	A	Stock	115.63	115.95	114.13	114.57	1735800.0
2020-12-02	AA	Stock	21.58	22.46	21.3	22.37	5866300.0
2020-12-02	AACG	Stock	1.19	1.2	1.15	1.17	11500.0
2020-12-02	AACQ-DELISTED	Stock	9.95	9.97	9.92	9.95	94382.0
2020-12-02	AACQU-DELISTED	Stock	10.58	10.58	10.425	10.45	21891.0
2020-12-02	AACQW-DELISTED	Stock	1.4	1.45	1.33	1.415	16012.0
2020-12-02	AAIC-DELISTED	Stock	3.25	3.39	3.24	3.36	289854.0
2020-12-02	AAIC.C-DELISTED	Stock	21.0	21.25	21.0	21.222	2094.0
2020-12-02	AAL	Stock	14.16	14.86	13.85	14.86	76032800.0
2020-12-02	AAM.A-DELISTED	Stock	26.25	26.3281	26.14	26.315	25257.0
2020-12-02	AAM.B-DELISTED	Stock	26.98	27.15	26.98	27.05	19593.0
2020-12-02	AAMC-DELISTED	Stock	6.7794	6.7794	6.7794	6.7794	575.0
2020-12-02	AAME	Stock	2.06	2.14	2.02	2.14	18300.0
2020-12-02	AAMI	Stock	17.73	17.92	17.45	17.84	285100.0
2020-12-02	AAN-DELISTED	Stock	18.13	18.6	17.26	18.25	2105400.0
2020-12-02	AAOI	Stock	8.07	8.37	8.02	8.32	411100.0
2020-12-02	AAON	Stock	42.58	42.8	41.7133	42.4867	220050.0
2020-12-02	AAP	Stock	151.18	151.45	147.5	148.45	1279900.0
2020-12-02	AAT	Stock	28.99	29.96	28.91	29.67	203700.0
2020-12-02	AAU-DELISTED	Stock	0.99	0.99	0.64	0.7441	5230640.0
2020-12-02	AAUAF-DELISTED	Stock	0.99	0.99	0.64	0.7352	5286745.0
2020-12-02	AAWW-DELISTED	Stock	54.09	54.74	53.51	54.27	219341.0
2020-12-02	AAXJ	Stock	86.26	86.46	85.8	86.33	726790.0
2020-12-02	AAXN-DELISTED	Stock	124.29	124.499	122.59	123.84	200534.0
2020-12-02	AB	Stock	32.67	33.33	32.5	33.12	273800.0
2020-12-02	ABB-DELISTED	Stock	26.62	26.71	26.475	26.56	1520779.0
2020-12-02	ABBNY-DELISTED	Stock	26.62	26.71	26.475	26.55	1775683.0
2020-12-02	ABBV	Stock	104.0	105.38	103.32	104.99	5492200.0
2020-12-02	ABC-DELISTED	Stock	102.55	103.69	102.13	103.11	521500.0
2020-12-02	ABCB	Stock	34.74	35.88	34.57	35.77	205300.0
2020-12-02	ABCM-DELISTED	Stock	19.26	19.42	19.11	19.24	43271.0
2020-12-02	ABEO	Stock	38.0	39.5	36.5	39.0	71256.0
2020-12-02	ABEV	Stock	2.81	2.89	2.79	2.88	35575800.0
2020-12-02	ABG	Stock	119.2	123.83	115.35	122.82	421800.0
2020-12-02	ABM	Stock	39.14	39.19	38.35	38.44	290000.0
2020-12-02	ABMD-DELISTED	Stock	268.22	268.22	263.76	265.26	102979.0
2020-12-02	ABR	Stock	13.67	13.7	13.46	13.63	771600.0
2020-12-02	ABR.A-DELISTED	Stock	25.56	25.56	25.36	25.4899	5185.0
2020-12-02	ABR.B-DELISTED	Stock	25.3	25.3	25.2	25.2	2460.0
2020-12-02	ABR.C-DELISTED	Stock	25.945	26.05	25.8348	25.985	4346.0

> showing 50 of 7,140 rows — these rows as CSV

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