PREVIEW / stock_daily / 2021-02-01

all stock daily files

  file:    by_date/stock_daily/2021/2021-02-01.parquet
  size:    245 KB
  rows:    7,408
  symbols: 2,715

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
2021-02-01	AAPL	Stock	133.75	135.38	130.93	134.14	106239800.0
2021-02-01	MSFT	Stock	235.06	242.5	232.43	239.65	33314200.0
2021-02-01	NVDA	Stock	13.0532	13.2708	12.9028	13.237	217204000.0
2021-02-01	AMZN	Stock	162.118	167.513	161.7515	167.144	83204000.0
2021-02-01	GOOGL	Stock	92.2293	95.777	92.2293	94.6535	40252060.0
2021-02-01	META	Stock	259.52	264.17	254.91	262.01	22914300.0
2021-02-01	TSLA	Stock	271.43	280.6667	265.1867	279.9367	76174200.0
2021-02-01	TLT	Stock	151.66	152.36	151.49	152.0	8164443.0
2021-02-01	ES	Stock	88.04	88.7	87.05	87.8	897100.0
2021-02-01	CL	Stock	78.64	79.7	78.32	78.52	6514500.0
2021-02-01	A	Stock	120.69	122.09	120.18	120.83	1292700.0
2021-02-01	AA	Stock	18.49	18.89	17.78	18.82	9127400.0
2021-02-01	AACG	Stock	1.35	1.36	1.31	1.34	27700.0
2021-02-01	AACQ-DELISTED	Stock	10.7	10.98	10.68	10.75	1240056.0
2021-02-01	AACQU-DELISTED	Stock	11.33	11.65	11.33	11.46	48114.0
2021-02-01	AACQW-DELISTED	Stock	2.01	2.27	2.0	2.18	329344.0
2021-02-01	AAIC-DELISTED	Stock	3.59	3.67	3.545	3.66	167306.0
2021-02-01	AAIC.C-DELISTED	Stock	21.72	21.72	21.7199	21.7199	446.0
2021-02-01	AAL	Stock	17.25	17.33	16.33	16.84	49436000.0
2021-02-01	AAM.A-DELISTED	Stock	26.45	26.65	26.43	26.43	12006.0
2021-02-01	AAM.B-DELISTED	Stock	27.02	27.17	26.8701	26.8701	17436.0
2021-02-01	AAMC-DELISTED	Stock	6.6124	6.6124	6.5503	6.5794	6188.0
2021-02-01	AAME	Stock	2.37	2.37	2.25	2.32	17600.0
2021-02-01	AAMI	Stock	18.37	19.17	18.27	19.09	358500.0
2021-02-01	AAN-DELISTED	Stock	17.1	18.36	16.64	17.96	463800.0
2021-02-01	AAOI	Stock	11.46	11.46	10.45	11.0	758600.0
2021-02-01	AAON	Stock	49.66	50.1467	48.4733	49.9733	307800.0
2021-02-01	AAP	Stock	151.13	155.5	150.03	150.97	1671700.0
2021-02-01	AAT	Stock	27.7	28.27	27.21	28.13	195500.0
2021-02-01	AAU-DELISTED	Stock	0.9726	1.2	0.8629	0.924	63239279.0
2021-02-01	AAUAF-DELISTED	Stock	0.9726	1.2	0.8629	0.9295	64666518.0
2021-02-01	AAWW-DELISTED	Stock	51.88	54.5	51.57	54.14	337377.0
2021-02-01	AAXJ	Stock	95.72	96.32	95.2	96.28	743447.0
2021-02-01	AB	Stock	35.62	36.37	35.41	36.12	645300.0
2021-02-01	ABB-DELISTED	Stock	29.79	30.16	29.66	30.135	1390872.0
2021-02-01	ABBNY-DELISTED	Stock	29.79	30.16	29.66	30.14	1500380.0
2021-02-01	ABBV	Stock	103.0	103.89	101.86	102.3	7518200.0
2021-02-01	ABC-DELISTED	Stock	104.86	107.38	104.81	106.88	1028664.0
2021-02-01	ABCB	Stock	39.87	41.39	39.16	41.26	381900.0
2021-02-01	ABCL	Stock	53.25	54.26	52.86	53.2	1247900.0
2021-02-01	ABCM-DELISTED	Stock	22.88	22.88	22.48	22.64	97145.0
2021-02-01	ABEO	Stock	49.25	51.25	47.5	48.5	153952.0
2021-02-01	ABEV	Stock	2.86	2.91	2.8	2.9	15762200.0
2021-02-01	ABG	Stock	142.42	152.11	142.42	151.32	300400.0
2021-02-01	ABM	Stock	37.05	38.4	36.31	38.3	471400.0
2021-02-01	ABMD-DELISTED	Stock	345.64	353.075	341.67	341.9	184955.0
2021-02-01	ABNB	Stock	187.48	188.82	179.74	180.44	3877400.0
2021-02-01	ABR	Stock	14.39	14.65	14.01	14.5	1225200.0
2021-02-01	ABR.A-DELISTED	Stock	25.7637	25.79	25.7637	25.79	500.0
2021-02-01	ABR.B-DELISTED	Stock	25.4609	25.54	25.34	25.54	1589.0

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

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