PREVIEW / stock_daily / 2022-09-22

all stock daily files

  file:    by_date/stock_daily/2022/2022-09-22.parquet
  size:    252 KB
  rows:    7,885
  symbols: 2,222

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-09-22	AAPL	Stock	152.38	154.47	150.91	152.74	86652500.0
2022-09-22	MSFT	Stock	237.87	243.86	237.57	240.98	31061200.0
2022-09-22	NVDA	Stock	13.07	13.149	12.428	12.561	759162000.0
2022-09-22	AMZN	Stock	117.08	118.79	116.26	117.31	55229200.0
2022-09-22	GOOGL	Stock	98.82	101.24	98.79	100.14	34298619.0
2022-09-22	META	Stock	141.55	144.58	140.87	142.82	34418500.0
2022-09-22	TSLA	Stock	299.86	301.29	285.82	288.59	70545400.0
2022-09-22	TLT	Stock	105.79	105.96	104.73	105.27	29030571.0
2022-09-22	ES	Stock	87.64	88.63	86.79	87.99	1449400.0
2022-09-22	CL	Stock	74.85	75.73	74.71	75.36	3452100.0
2022-09-22	A	Stock	125.55	126.04	123.76	124.39	1378600.0
2022-09-22	AA	Stock	39.94	40.39	37.48	37.52	9867700.0
2022-09-22	AAC-DELISTED	Stock	9.93	9.95	9.93	9.94	594865.0
2022-09-22	AACG	Stock	1.97	2.0	1.93	1.94	18200.0
2022-09-22	AACIW-DELISTED	Stock	0.15	0.15	0.15	0.15	100.0
2022-09-22	AAIC-DELISTED	Stock	3.06	3.07	2.94	2.98	134739.0
2022-09-22	AAIC.C-DELISTED	Stock	20.345	20.345	20.18	20.18	684.0
2022-09-22	AAL	Stock	13.3	13.33	12.52	12.71	44037600.0
2022-09-22	AAM.A-DELISTED	Stock	23.7	23.98	23.35	23.5	17856.0
2022-09-22	AAM.B-DELISTED	Stock	23.87	23.87	23.568	23.74	8027.0
2022-09-22	AAMC-DELISTED	Stock	5.3088	5.3089	4.9118	4.9118	17099.0
2022-09-22	AAME	Stock	2.99	3.14	2.99	3.11	1200.0
2022-09-22	AAMI	Stock	16.23	16.23	15.57	15.58	185600.0
2022-09-22	AAN-DELISTED	Stock	11.44	11.44	10.96	10.98	400700.0
2022-09-22	AAOI	Stock	3.29	3.33	2.995	3.01	535700.0
2022-09-22	AAON	Stock	37.5933	37.5933	36.2333	36.3533	185550.0
2022-09-22	AAP	Stock	164.78	165.17	162.92	164.11	865000.0
2022-09-22	AAQC-DELISTED	Stock	9.82	9.82	9.8	9.8	46710.0
2022-09-22	AAT	Stock	26.56	26.6	26.02	26.2	223700.0
2022-09-22	AATC	Stock	5.01	5.01	4.91	4.91	5490.0
2022-09-22	AAU-DELISTED	Stock	0.2247	0.2298	0.2134	0.2231	249275.0
2022-09-22	AAUAF-DELISTED	Stock	0.2247	0.2298	0.2151	0.2298	250751.0
2022-09-22	AAWW-DELISTED	Stock	99.15	99.23	98.63	99.0	569488.0
2022-09-22	AAXJ	Stock	62.5	62.55	61.98	62.04	1129648.0
2022-09-22	AB	Stock	40.61	40.61	39.29	39.55	390000.0
2022-09-22	ABB-DELISTED	Stock	26.37	26.485	26.01	26.13	1518030.0
2022-09-22	ABBNY-DELISTED	Stock	26.37	26.485	26.01	26.12	1662337.0
2022-09-22	ABBV	Stock	140.21	144.46	140.0	143.01	6161000.0
2022-09-22	ABC-DELISTED	Stock	139.09	140.97	138.68	139.98	439680.0
2022-09-22	ABCB	Stock	48.54	48.7	47.13	47.31	302700.0
2022-09-22	ABCL	Stock	10.14	10.175	9.57	9.69	1615500.0
2022-09-22	ABCM-DELISTED	Stock	15.54	15.57	15.21	15.375	181779.0
2022-09-22	ABEO	Stock	3.58	3.58	3.2	3.25	119600.0
2022-09-22	ABEV	Stock	2.97	3.02	2.93	2.99	46529300.0
2022-09-22	ABG	Stock	150.01	151.99	147.39	148.9	177200.0
2022-09-22	ABGI-DELISTED	Stock	9.9	9.9	9.9	9.9	100.0
2022-09-22	ABLV	Stock	9.97	9.98	9.97	9.98	19500.0
2022-09-22	ABM	Stock	39.65	39.65	39.03	39.23	407500.0
2022-09-22	ABMD-DELISTED	Stock	250.63	251.305	245.23	247.28	109126.0
2022-09-22	ABNB	Stock	112.67	113.72	103.26	103.72	8399400.0

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

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