PREVIEW / stock_daily / 2022-09-23

all stock daily files

  file:    by_date/stock_daily/2022/2022-09-23.parquet
  size:    252 KB
  rows:    7,901
  symbols: 2,216

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-23	AAPL	Stock	151.19	151.47	148.56	150.43	96029900.0
2022-09-23	MSFT	Stock	239.54	241.13	235.2	237.92	34176000.0
2022-09-23	NVDA	Stock	12.42	12.611	12.257	12.516	663309000.0
2022-09-23	AMZN	Stock	116.0	116.05	112.06	113.78	65126700.0
2022-09-23	GOOGL	Stock	99.63	99.66	97.47	98.74	31625437.0
2022-09-23	META	Stock	141.42	142.62	138.89	140.41	31710700.0
2022-09-23	TSLA	Stock	283.09	284.5	272.82	275.33	63748400.0
2022-09-23	TLT	Stock	105.34	106.425	104.56	105.7	23042234.0
2022-09-23	ES	Stock	86.78	87.07	85.86	86.85	2121500.0
2022-09-23	CL	Stock	75.21	75.93	74.79	75.53	4471900.0
2022-09-23	A	Stock	123.73	124.43	121.44	123.48	1481900.0
2022-09-23	AA	Stock	35.9	36.32	35.11	35.51	8163900.0
2022-09-23	AAC-DELISTED	Stock	9.94	9.94	9.9125	9.915	444397.0
2022-09-23	AACG	Stock	1.91	1.94	1.7	1.74	33900.0
2022-09-23	AAIC-DELISTED	Stock	3.06	3.06	2.85	2.89	100304.0
2022-09-23	AAIC.C-DELISTED	Stock	20.2	20.39	20.05	20.2001	10784.0
2022-09-23	AAL	Stock	12.48	12.57	11.86	12.21	53874900.0
2022-09-23	AAM.A-DELISTED	Stock	23.5431	23.61	23.25	23.36	15828.0
2022-09-23	AAM.B-DELISTED	Stock	23.4	23.6	23.23	23.39	7182.0
2022-09-23	AAME	Stock	3.09	3.09	2.91	2.95	4600.0
2022-09-23	AAMI	Stock	15.38	15.54	15.01	15.5	237900.0
2022-09-23	AAN-DELISTED	Stock	10.81	10.91	10.59	10.8	208900.0
2022-09-23	AAOI	Stock	2.96	2.98	2.72	2.85	642000.0
2022-09-23	AAON	Stock	36.08	36.5533	35.3067	36.0467	250500.0
2022-09-23	AAP	Stock	162.45	163.49	157.79	160.5	1002200.0
2022-09-23	AAQC-DELISTED	Stock	9.83	9.83	9.8	9.81	9520.0
2022-09-23	AAT	Stock	26.0	26.0	24.99	25.46	232600.0
2022-09-23	AATC	Stock	4.89	4.89	4.68	4.7269	8801.0
2022-09-23	AAU-DELISTED	Stock	0.2296	0.2296	0.1969	0.2201	245015.0
2022-09-23	AAUAF-DELISTED	Stock	0.2296	0.2296	0.1969	0.22	248043.0
2022-09-23	AAWW-DELISTED	Stock	98.76	98.94	97.72	97.89	844979.0
2022-09-23	AAXJ	Stock	61.03	61.12	60.41	60.7	961278.0
2022-09-23	AB	Stock	39.01	39.19	37.41	38.24	573500.0
2022-09-23	ABB-DELISTED	Stock	25.82	25.8395	25.4592	25.76	1812845.0
2022-09-23	ABBNY-DELISTED	Stock	25.82	25.8395	25.4592	25.76	1967366.0
2022-09-23	ABBV	Stock	142.07	143.42	140.95	143.06	5751600.0
2022-09-23	ABC-DELISTED	Stock	139.32	139.461	135.36	137.21	677185.0
2022-09-23	ABCB	Stock	46.51	46.72	45.86	46.58	275100.0
2022-09-23	ABCL	Stock	9.59	9.61	9.09	9.2	1792600.0
2022-09-23	ABCM-DELISTED	Stock	14.65	15.03	14.26	14.61	295520.0
2022-09-23	ABEO	Stock	3.23	3.29	2.96	3.03	69400.0
2022-09-23	ABEV	Stock	2.92	2.93	2.86	2.88	39915300.0
2022-09-23	ABG	Stock	146.51	148.29	143.28	147.68	173700.0
2022-09-23	ABGI-DELISTED	Stock	9.9	9.9	9.9	9.9	1000.0
2022-09-23	ABLV	Stock	9.99	9.99	9.99	9.99	1358.0
2022-09-23	ABM	Stock	38.75	39.01	37.9	38.26	396200.0
2022-09-23	ABMD-DELISTED	Stock	246.56	247.53	239.0	245.39	157266.0
2022-09-23	ABNB	Stock	102.2	103.18	99.71	101.75	6245600.0
2022-09-23	ABOS	Stock	4.58	4.8	4.45	4.63	45700.0
2022-09-23	ABR	Stock	13.22	13.28	12.7	12.91	3453600.0

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

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