PREVIEW / stock_daily / 2022-11-07

all stock daily files

  file:    by_date/stock_daily/2022/2022-11-07.parquet
  size:    251 KB
  rows:    7,835
  symbols: 2,110

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-07	AAPL	Stock	137.11	139.15	135.67	138.92	83374600.0
2022-11-07	MSFT	Stock	221.99	228.41	221.28	227.87	33498000.0
2022-11-07	NVDA	Stock	14.228	14.412	13.954	14.301	410061000.0
2022-11-07	AMZN	Stock	91.95	92.1	89.04	90.53	77495700.0
2022-11-07	GOOGL	Stock	87.28	88.9	86.85	88.49	34078912.0
2022-11-07	META	Stock	94.78	96.88	93.1	96.72	81987300.0
2022-11-07	TSLA	Stock	208.65	208.9	196.66	197.08	93916500.0
2022-11-07	TLT	Stock	94.8	94.86	93.24	93.28	14522820.0
2022-11-07	ES	Stock	77.27	77.29	73.94	75.03	1971300.0
2022-11-07	CL	Stock	73.49	74.01	73.11	73.5	3052500.0
2022-11-07	A	Stock	136.85	138.08	135.56	138.03	1213600.0
2022-11-07	AA	Stock	42.47	42.79	41.0	41.51	4790700.0
2022-11-07	AAC-DELISTED	Stock	9.98	9.99	9.98	9.985	18730.0
2022-11-07	AACG	Stock	1.76	1.87	1.75	1.76	12400.0
2022-11-07	AAIC-DELISTED	Stock	3.01	3.03	2.99	3.01	36342.0
2022-11-07	AAIC.C-DELISTED	Stock	21.78	21.78	21.33	21.33	3781.0
2022-11-07	AAL	Stock	14.32	14.39	13.86	14.32	23797300.0
2022-11-07	AAM.A-DELISTED	Stock	21.47	21.52	21.1616	21.4	16336.0
2022-11-07	AAM.B-DELISTED	Stock	21.39	21.71	21.22	21.71	9986.0
2022-11-07	AAMC-DELISTED	Stock	5.5706	5.8088	5.5324	5.5324	5712.0
2022-11-07	AAME	Stock	3.08	3.13	2.89	2.9	3700.0
2022-11-07	AAMI	Stock	19.51	19.595	19.21	19.41	198300.0
2022-11-07	AAN-DELISTED	Stock	9.81	9.94	9.605	9.84	347800.0
2022-11-07	AAOI	Stock	2.14	2.18	2.12	2.16	283500.0
2022-11-07	AAON	Stock	43.6733	44.5533	43.5733	43.7	161700.0
2022-11-07	AAP	Stock	181.69	183.45	178.13	183.09	782300.0
2022-11-07	AAQC-DELISTED	Stock	9.94	9.95	9.935	9.94	237448.0
2022-11-07	AAT	Stock	28.64	28.74	27.73	27.99	358500.0
2022-11-07	AATC	Stock	4.25	4.3117	4.25	4.3117	1066.0
2022-11-07	AAU-DELISTED	Stock	0.23	0.238	0.2231	0.2369	230386.0
2022-11-07	AAUAF-DELISTED	Stock	0.23	0.238	0.2231	0.2369	230386.0
2022-11-07	AAWW-DELISTED	Stock	100.44	100.61	100.2	100.44	314625.0
2022-11-07	AAXJ	Stock	59.71	59.884	59.23	59.54	899588.0
2022-11-07	AB	Stock	36.6	36.92	36.05	36.54	195000.0
2022-11-07	ABB-DELISTED	Stock	28.84	28.985	28.64	28.91	1012111.0
2022-11-07	ABBNY-DELISTED	Stock	28.84	28.985	28.64	28.91	1012111.0
2022-11-07	ABBV	Stock	145.28	148.8	144.7	148.1	4304000.0
2022-11-07	ABC-DELISTED	Stock	161.94	163.61	160.55	162.01	1393626.0
2022-11-07	ABCB	Stock	52.12	52.5	51.8	52.17	270200.0
2022-11-07	ABCL	Stock	11.94	12.32	11.86	12.01	1393600.0
2022-11-07	ABCM-DELISTED	Stock	14.52	14.97	14.48	14.9	327363.0
2022-11-07	ABEO	Stock	4.05	4.05	3.59	3.67	369000.0
2022-11-07	ABEV	Stock	3.21	3.22	3.13	3.13	29987100.0
2022-11-07	ABG	Stock	155.88	160.99	153.7	159.63	144700.0
2022-11-07	ABGI-DELISTED	Stock	9.97	9.97	9.97	9.97	27308.0
2022-11-07	ABM	Stock	43.13	43.63	42.88	43.33	213100.0
2022-11-07	ABMD-DELISTED	Stock	374.0	375.17	373.18	373.29	1939599.0
2022-11-07	ABNB	Stock	96.76	97.25	93.28	95.46	7972700.0
2022-11-07	ABOS	Stock	6.33	6.7	6.16	6.48	77900.0
2022-11-07	ABR	Stock	14.65	14.77	14.34	14.48	2158800.0

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

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