PREVIEW / stock_daily / 2022-11-01

all stock daily files

  file:    by_date/stock_daily/2022/2022-11-01.parquet
  size:    252 KB
  rows:    7,858
  symbols: 2,118

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-11-01	AAPL	Stock	155.08	155.45	149.13	150.65	80379300.0
2022-11-01	MSFT	Stock	234.6	235.74	227.33	228.17	30592300.0
2022-11-01	NVDA	Stock	13.811	13.925	13.519	13.543	432817000.0
2022-11-01	AMZN	Stock	103.99	104.58	96.06	96.79	153370000.0
2022-11-01	GOOGL	Stock	95.45	96.03	90.37	90.47	47161351.0
2022-11-01	META	Stock	94.33	97.49	93.55	95.2	110189600.0
2022-11-01	TSLA	Stock	234.05	237.4	227.28	227.82	62688800.0
2022-11-01	TLT	Stock	97.38	97.42	96.21	96.77	17585088.0
2022-11-01	ES	Stock	76.76	77.08	76.06	76.98	1536900.0
2022-11-01	CL	Stock	73.75	74.55	73.54	73.74	3716000.0
2022-11-01	A	Stock	139.5	141.35	138.06	140.89	1182900.0
2022-11-01	AA	Stock	40.77	42.13	40.26	40.88	6356100.0
2022-11-01	AAC-DELISTED	Stock	9.97	9.975	9.97	9.97	130159.0
2022-11-01	AACG	Stock	1.79	1.85	1.78	1.85	10400.0
2022-11-01	AACIW-DELISTED	Stock	0.12	0.12	0.06	0.06	8311.0
2022-11-01	AAIC-DELISTED	Stock	3.0397	3.0397	2.95	3.0	33864.0
2022-11-01	AAIC.C-DELISTED	Stock	20.0	20.0	19.8631	19.9585	1400.0
2022-11-01	AAL	Stock	14.44	14.54	14.1	14.11	25606900.0
2022-11-01	AAM.A-DELISTED	Stock	21.8	21.92	21.41	21.42	11806.0
2022-11-01	AAM.B-DELISTED	Stock	21.93	22.46	21.8	21.8	13047.0
2022-11-01	AAMC-DELISTED	Stock	4.4706	4.8824	4.3235	4.7794	37053.0
2022-11-01	AAME	Stock	2.82	3.02	2.82	2.84	2100.0
2022-11-01	AAMI	Stock	18.93	19.42	18.73	19.22	214700.0
2022-11-01	AAN-DELISTED	Stock	10.63	10.82	10.15	10.26	1009600.0
2022-11-01	AAOI	Stock	2.82	2.83	2.71	2.73	150300.0
2022-11-01	AAON	Stock	43.32	43.7133	42.5533	43.3333	149100.0
2022-11-01	AAP	Stock	191.18	191.21	188.38	189.28	471700.0
2022-11-01	AAQC-DELISTED	Stock	9.94	9.95	9.93	9.95	47061.0
2022-11-01	AAT	Stock	27.82	28.01	27.49	28.01	255800.0
2022-11-01	AATC	Stock	4.41	4.44	4.3	4.375	4370.0
2022-11-01	AAU-DELISTED	Stock	0.2276	0.2298	0.2201	0.225	361447.0
2022-11-01	AAUAF-DELISTED	Stock	0.2276	0.2298	0.2201	0.2255	370566.0
2022-11-01	AAWW-DELISTED	Stock	101.09	101.25	101.0	101.13	588005.0
2022-11-01	AAXJ	Stock	57.09	57.32	56.66	56.69	492134.0
2022-11-01	AB	Stock	38.28	38.33	37.34	37.66	279500.0
2022-11-01	ABB-DELISTED	Stock	28.58	28.615	27.88	28.1	1302849.0
2022-11-01	ABBNY-DELISTED	Stock	28.58	28.615	27.88	28.09	1514854.0
2022-11-01	ABBV	Stock	146.66	147.7	144.55	146.91	6351200.0
2022-11-01	ABC-DELISTED	Stock	157.37	157.55	154.74	156.34	757253.0
2022-11-01	ABCB	Stock	51.91	51.91	50.57	51.04	498900.0
2022-11-01	ABCL	Stock	12.01	12.32	11.32	11.5	2348700.0
2022-11-01	ABCM-DELISTED	Stock	15.65	15.785	15.47	15.7	262769.0
2022-11-01	ABEO	Stock	4.71	4.96	4.62	4.9	256000.0
2022-11-01	ABEV	Stock	3.05	3.09	3.0	3.06	32104500.0
2022-11-01	ABG	Stock	158.49	168.9	158.49	167.75	248800.0
2022-11-01	ABGI-DELISTED	Stock	9.97	9.97	9.97	9.97	23266.0
2022-11-01	ABLV	Stock	10.03	10.0646	10.03	10.03	6100.0
2022-11-01	ABM	Stock	44.97	45.43	44.58	45.33	279600.0
2022-11-01	ABMD-DELISTED	Stock	379.38	381.99	377.45	377.5	5543892.0
2022-11-01	ABNB	Stock	110.965	113.1	108.0	109.05	15979800.0

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

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