PREVIEW / stock_daily / 2022-09-26

all stock daily files

  file:    by_date/stock_daily/2022/2022-09-26.parquet
  size:    253 KB
  rows:    7,976
  symbols: 2,264

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-26	AAPL	Stock	149.66	153.77	149.64	150.77	93339400.0
2022-09-26	MSFT	Stock	237.05	241.45	236.9	237.45	27694200.0
2022-09-26	NVDA	Stock	12.491	12.659	12.214	12.228	547343000.0
2022-09-26	AMZN	Stock	113.3	117.34	113.13	115.15	62723300.0
2022-09-26	GOOGL	Stock	98.1	99.88	97.8	98.17	27072662.0
2022-09-26	META	Stock	140.12	142.24	136.19	136.37	30497000.0
2022-09-26	TSLA	Stock	271.83	284.09	270.31	276.01	58076900.0
2022-09-26	TLT	Stock	105.36	105.41	103.22	103.68	25104572.0
2022-09-26	ES	Stock	86.81	86.91	83.79	84.63	1482800.0
2022-09-26	CL	Stock	75.53	75.78	74.78	75.0	3797200.0
2022-09-26	A	Stock	123.18	124.25	121.63	122.31	1733100.0
2022-09-26	AA	Stock	35.09	36.02	34.345	34.47	7275500.0
2022-09-26	AAC-DELISTED	Stock	9.92	9.93	9.91	9.92	424710.0
2022-09-26	AACG	Stock	1.78	1.78	1.72	1.72	11600.0
2022-09-26	AAIC-DELISTED	Stock	2.83	2.9	2.67	2.67	166417.0
2022-09-26	AAIC.C-DELISTED	Stock	20.0501	20.0501	19.6437	19.6437	8473.0
2022-09-26	AAL	Stock	12.18	12.43	11.85	11.86	38155600.0
2022-09-26	AAM.A-DELISTED	Stock	23.1	23.5	23.1	23.49	10117.0
2022-09-26	AAM.B-DELISTED	Stock	23.2	23.5419	23.2	23.4	6177.0
2022-09-26	AAMC-DELISTED	Stock	4.5588	4.5588	4.4324	4.4324	8255.0
2022-09-26	AAME	Stock	2.85	3.11	2.85	3.04	2600.0
2022-09-26	AAMI	Stock	15.53	15.95	15.4	15.53	209600.0
2022-09-26	AAN-DELISTED	Stock	10.74	11.04	10.57	10.59	272700.0
2022-09-26	AAOI	Stock	2.85	2.9	2.73	2.77	237700.0
2022-09-26	AAON	Stock	35.92	36.66	35.6667	36.48	258750.0
2022-09-26	AAP	Stock	160.89	161.8	157.16	157.68	899200.0
2022-09-26	AAQC-DELISTED	Stock	9.8	9.82	9.8	9.82	12982.0
2022-09-26	AAT	Stock	25.34	25.34	24.22	24.65	344000.0
2022-09-26	AATC	Stock	4.68	4.78	4.6085	4.6085	12817.0
2022-09-26	AAU-DELISTED	Stock	0.2246	0.2246	0.2	0.204	319705.0
2022-09-26	AAUAF-DELISTED	Stock	0.2246	0.2246	0.2	0.204	323607.0
2022-09-26	AAWW-DELISTED	Stock	98.0	98.5	97.08	97.215	704764.0
2022-09-26	AAXJ	Stock	60.57	60.86	60.16	60.28	837149.0
2022-09-26	AB	Stock	37.51	38.35	37.03	37.52	384600.0
2022-09-26	ABB-DELISTED	Stock	25.34	25.74	25.2	25.39	2846874.0
2022-09-26	ABBNY-DELISTED	Stock	25.34	25.74	25.2	25.38	3022827.0
2022-09-26	ABBV	Stock	142.08	142.8	140.11	141.21	5697800.0
2022-09-26	ABC-DELISTED	Stock	136.36	137.28	135.7	136.31	816501.0
2022-09-26	ABCB	Stock	46.51	46.95	45.88	46.0	304400.0
2022-09-26	ABCL	Stock	9.19	9.51	9.091	9.22	1846100.0
2022-09-26	ABCM-DELISTED	Stock	14.57	14.855	14.5	14.78	200042.0
2022-09-26	ABEO	Stock	2.99	3.02	2.7	2.79	83400.0
2022-09-26	ABEV	Stock	2.83	2.88	2.77	2.8	36231900.0
2022-09-26	ABG	Stock	146.67	152.35	146.67	150.77	250900.0
2022-09-26	ABGI-DELISTED	Stock	9.89	9.89	9.89	9.89	100399.0
2022-09-26	ABM	Stock	38.16	39.72	38.16	38.33	554900.0
2022-09-26	ABMD-DELISTED	Stock	244.15	247.09	240.18	242.45	90599.0
2022-09-26	ABNB	Stock	101.78	105.36	101.56	103.23	5278800.0
2022-09-26	ABOS	Stock	4.56	4.6	4.09	4.44	35500.0
2022-09-26	ABR	Stock	12.8	12.91	12.24	12.35	3187800.0

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

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