PREVIEW / stock_daily / 2022-01-31

all stock daily files

  file:    by_date/stock_daily/2022/2022-01-31.parquet
  size:    261 KB
  rows:    8,092
  symbols: 2,588

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
2022-01-31	AAPL	Stock	170.16	175.0	169.51	174.78	115541600.0
2022-01-31	MSFT	Stock	308.95	312.38	306.37	310.98	46444500.0
2022-01-31	NVDA	Stock	23.182	24.509	23.052	24.486	564680000.0
2022-01-31	AMZN	Stock	144.75	150.3605	144.3005	149.5735	78308000.0
2022-01-31	GOOGL	Stock	134.162	135.473	132.2095	135.3035	39986000.0
2022-01-31	META	Stock	300.68	313.79	299.32	313.26	21579500.0
2022-01-31	TSLA	Stock	290.9033	312.6633	287.35	312.24	104436000.0
2022-01-31	TLT	Stock	142.18	142.95	141.96	142.39	13997188.0
2022-01-31	ES	Stock	86.7	89.73	86.56	89.49	2298600.0
2022-01-31	CL	Stock	82.24	82.9	81.55	82.45	6372200.0
2022-01-31	A	Stock	137.32	139.47	136.97	139.32	1703000.0
2022-01-31	AA	Stock	56.94	57.02	55.02	56.71	7206100.0
2022-01-31	AAC-DELISTED	Stock	9.71	9.73	9.71	9.72	28814.0
2022-01-31	AACG	Stock	1.66	1.66	1.48	1.56	27400.0
2022-01-31	AACIW-DELISTED	Stock	0.25	0.2501	0.2493	0.2498	41521.0
2022-01-31	AAIC-DELISTED	Stock	3.3	3.43	3.3	3.43	79258.0
2022-01-31	AAIC.C-DELISTED	Stock	25.0	25.0001	24.7196	24.8	3998.0
2022-01-31	AAL	Stock	15.55	16.47	15.4	16.47	35533500.0
2022-01-31	AAM.A-DELISTED	Stock	25.34	25.39	25.15	25.15	446964.0
2022-01-31	AAM.B-DELISTED	Stock	26.35	26.428	25.82	25.88	334308.0
2022-01-31	AAME	Stock	2.44	2.63	2.44	2.59	5100.0
2022-01-31	AAMI	Stock	20.73	21.66	20.73	21.58	1521300.0
2022-01-31	AAN-DELISTED	Stock	20.48	21.21	20.1	21.17	508200.0
2022-01-31	AAOI	Stock	3.84	4.1	3.84	4.1	280300.0
2022-01-31	AAON	Stock	41.5667	42.9267	41.46	42.8333	739350.0
2022-01-31	AAP	Stock	226.73	231.92	226.0	231.51	796000.0
2022-01-31	AAQC-DELISTED	Stock	9.68	9.69	9.68	9.69	5570.0
2022-01-31	AAT	Stock	35.18	35.99	34.92	35.97	255200.0
2022-01-31	AATC	Stock	6.48	6.9	6.4498	6.865	39751.0
2022-01-31	AAU-DELISTED	Stock	0.28	0.2877	0.2733	0.2857	234331.0
2022-01-31	AAUAF-DELISTED	Stock	0.28	0.2877	0.2733	0.2857	239929.0
2022-01-31	AAWW-DELISTED	Stock	75.76	80.43	74.68	80.19	808593.0
2022-01-31	AAXJ	Stock	79.83	81.73	79.83	81.65	1027022.0
2022-01-31	AB	Stock	45.36	47.21	45.33	46.95	509400.0
2022-01-31	ABB-DELISTED	Stock	34.08	34.805	34.05	34.77	2349288.0
2022-01-31	ABBNY-DELISTED	Stock	34.08	34.805	34.05	34.77	2613473.0
2022-01-31	ABBV	Stock	136.82	137.17	135.62	136.89	10300000.0
2022-01-31	ABC-DELISTED	Stock	135.85	136.63	134.48	136.19	783568.0
2022-01-31	ABCB	Stock	48.72	49.39	47.51	49.31	630500.0
2022-01-31	ABCL	Stock	8.64	9.09	8.64	8.99	1941200.0
2022-01-31	ABCM-DELISTED	Stock	17.75	18.04	17.75	17.92	74488.0
2022-01-31	ABEO	Stock	6.25	6.5	5.75	6.5	113400.0
2022-01-31	ABEV	Stock	2.77	2.85	2.77	2.83	14314900.0
2022-01-31	ABG	Stock	156.46	161.33	156.08	160.97	255400.0
2022-01-31	ABGI-DELISTED	Stock	9.72	9.72	9.72	9.72	888.0
2022-01-31	ABM	Stock	40.37	41.84	40.37	41.69	1871700.0
2022-01-31	ABMD-DELISTED	Stock	278.81	296.22	277.99	295.86	373464.0
2022-01-31	ABNB	Stock	144.803	153.97	143.81	153.97	5463000.0
2022-01-31	ABOS	Stock	5.01	5.21	4.96	5.12	364300.0
2022-01-31	ABR	Stock	17.0	17.52	17.0	17.51	1422500.0

> showing 50 of 8,092 rows — these rows as CSV

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