PREVIEW / stock_daily / 2021-02-04

all stock daily files

  file:    by_date/stock_daily/2021/2021-02-04.parquet
  size:    245 KB
  rows:    7,422
  symbols: 2,734

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-04	AAPL	Stock	136.3	137.4	134.59	137.39	84183100.0
2021-02-04	MSFT	Stock	242.66	243.24	240.37	242.01	25296100.0
2021-02-04	NVDA	Stock	13.531	13.6735	13.3378	13.6643	201340000.0
2021-02-04	AMZN	Stock	166.5	167.35	163.8875	166.55	73414000.0
2021-02-04	GOOGL	Stock	103.0308	103.465	101.755	102.6815	48595600.0
2021-02-04	META	Stock	267.01	268.16	264.0	266.49	16060000.0
2021-02-04	TSLA	Stock	285.0	285.5	277.8067	283.33	47438100.0
2021-02-04	TLT	Stock	149.16	149.49	148.8	149.28	8262613.0
2021-02-04	ES	Stock	87.85	88.81	87.04	88.28	942800.0
2021-02-04	CL	Stock	78.77	79.28	78.45	78.93	3869600.0
2021-02-04	A	Stock	122.51	124.34	121.6	124.07	1251200.0
2021-02-04	AA	Stock	20.02	20.446	19.85	20.36	5516700.0
2021-02-04	AACG	Stock	3.67	19.75	3.45	14.3	315842300.0
2021-02-04	AACQ-DELISTED	Stock	11.1	11.45	11.1	11.13	1099624.0
2021-02-04	AACQU-DELISTED	Stock	11.98	12.4	11.915	11.95	195011.0
2021-02-04	AACQW-DELISTED	Stock	2.4	2.6057	2.3505	2.55	395599.0
2021-02-04	AAIC-DELISTED	Stock	3.62	3.74	3.59	3.7	183851.0
2021-02-04	AAIC.C-DELISTED	Stock	21.92	22.0	21.805	21.805	1817.0
2021-02-04	AAL	Stock	17.48	17.59	17.31	17.4	37606800.0
2021-02-04	AAM.A-DELISTED	Stock	26.32	26.4442	26.26	26.42	14339.0
2021-02-04	AAM.B-DELISTED	Stock	27.23	27.23	26.93	27.11	18480.0
2021-02-04	AAMC-DELISTED	Stock	6.3088	6.4676	6.3069	6.4676	6164.0
2021-02-04	AAME	Stock	2.32	2.4	2.32	2.39	45400.0
2021-02-04	AAMI	Stock	20.1	20.57	19.73	20.2	438300.0
2021-02-04	AAN-DELISTED	Stock	18.0	18.98	17.79	18.96	332000.0
2021-02-04	AAOI	Stock	10.75	11.45	10.74	11.39	666400.0
2021-02-04	AAON	Stock	50.36	51.3733	50.0067	51.2467	169050.0
2021-02-04	AAP	Stock	156.53	159.54	155.51	158.48	852700.0
2021-02-04	AAT	Stock	28.21	28.87	28.2	28.52	156300.0
2021-02-04	AAU-DELISTED	Stock	0.73	0.74	0.7012	0.7187	4364535.0
2021-02-04	AAUAF-DELISTED	Stock	0.73	0.74	0.7012	0.7187	4510537.0
2021-02-04	AAWW-DELISTED	Stock	51.9	53.43	51.35	52.98	159426.0
2021-02-04	AAXJ	Stock	97.8	98.0	97.23	98.0	637321.0
2021-02-04	AB	Stock	37.49	37.99	37.31	37.86	398400.0
2021-02-04	ABB-DELISTED	Stock	29.11	29.13	28.755	29.02	4343825.0
2021-02-04	ABBNY-DELISTED	Stock	29.11	29.13	28.755	29.02	4598138.0
2021-02-04	ABBV	Stock	106.87	108.88	105.25	108.53	9077800.0
2021-02-04	ABC-DELISTED	Stock	106.14	112.88	106.14	111.9	1574513.0
2021-02-04	ABCB	Stock	42.42	44.15	42.08	43.87	395800.0
2021-02-04	ABCL	Stock	49.0	49.076	46.0	46.58	373800.0
2021-02-04	ABCM-DELISTED	Stock	22.19	22.3243	21.88	22.115	95363.0
2021-02-04	ABEO	Stock	60.0	63.0	58.0	61.5	153532.0
2021-02-04	ABEV	Stock	2.92	2.93	2.87	2.91	14508100.0
2021-02-04	ABG	Stock	146.77	153.62	145.26	153.24	176500.0
2021-02-04	ABM	Stock	38.79	39.43	38.49	39.3	207200.0
2021-02-04	ABMD-DELISTED	Stock	327.73	332.89	323.07	324.73	263841.0
2021-02-04	ABNB	Stock	187.07	195.99	186.19	195.8	3631500.0
2021-02-04	ABR	Stock	14.82	15.47	14.8	15.38	1370300.0
2021-02-04	ABR.A-DELISTED	Stock	25.81	26.15	25.81	26.15	7531.0
2021-02-04	ABR.B-DELISTED	Stock	25.69	25.72	25.69	25.69	4653.0

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

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