PREVIEW / stock_daily / 2023-02-07

all stock daily files

  file:    by_date/stock_daily/2023/2023-02-07.parquet
  size:    248 KB
  rows:    7,636
  symbols: 1,845

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
2023-02-07	AAPL	Stock	150.64	155.23	150.64	154.65	83322600.0
2023-02-07	MSFT	Stock	260.53	268.77	260.08	267.56	50841400.0
2023-02-07	NVDA	Stock	21.382	22.259	21.15	22.173	664150000.0
2023-02-07	AMZN	Stock	101.17	102.41	98.08	102.11	119501300.0
2023-02-07	GOOGL	Stock	103.22	108.18	103.12	107.64	49010230.0
2023-02-07	META	Stock	185.58	193.78	184.4	191.62	47080700.0
2023-02-07	TSLA	Stock	196.43	197.5	189.55	196.81	186010300.0
2023-02-07	TLT	Stock	105.33	106.23	105.0	105.06	18290306.0
2023-02-07	ES	Stock	80.74	81.02	79.48	80.68	1458100.0
2023-02-07	CL	Stock	73.43	73.55	72.71	73.45	3755100.0
2023-02-07	A	Stock	151.49	154.96	151.13	154.51	1126700.0
2023-02-07	AA	Stock	52.16	53.4	50.865	53.24	4359400.0
2023-02-07	AAC-DELISTED	Stock	10.2	10.2	10.19	10.2	25576.0
2023-02-07	AACG	Stock	1.71	1.79	1.54	1.6	34900.0
2023-02-07	AACIW-DELISTED	Stock	0.139	0.139	0.0637	0.1078	6228.0
2023-02-07	AAIC-DELISTED	Stock	3.02	3.03	3.0	3.025	67594.0
2023-02-07	AAL	Stock	16.92	17.03	16.54	16.96	19053400.0
2023-02-07	AAM.A-DELISTED	Stock	24.5	24.7897	24.32	24.7897	10427.0
2023-02-07	AAM.B-DELISTED	Stock	24.43	25.0727	24.39	24.5811	11831.0
2023-02-07	AAMC-DELISTED	Stock	9.7059	11.2	9.4559	11.1765	80243.0
2023-02-07	AAME	Stock	2.57	2.58	2.49	2.52	4400.0
2023-02-07	AAMI	Stock	25.27	26.0	24.985	25.93	207400.0
2023-02-07	AAN-DELISTED	Stock	14.86	15.26	14.645	15.13	317500.0
2023-02-07	AAOI	Stock	2.62	2.68	2.55	2.62	95300.0
2023-02-07	AAON	Stock	52.5733	52.6333	50.8333	51.6933	247350.0
2023-02-07	AAP	Stock	151.33	151.68	148.27	151.47	924800.0
2023-02-07	AAT	Stock	28.06	28.64	27.59	28.29	235300.0
2023-02-07	AATC	Stock	4.22	4.35	4.22	4.3	11281.0
2023-02-07	AAU-DELISTED	Stock	0.22	0.2314	0.22	0.224	72017.0
2023-02-07	AAUAF-DELISTED	Stock	0.22	0.2314	0.22	0.224	74679.0
2023-02-07	AAWW-DELISTED	Stock	102.22	102.22	102.16	102.19	119671.0
2023-02-07	AAXJ	Stock	69.38	69.78	68.88	69.6	950980.0
2023-02-07	AB	Stock	38.71	39.84	38.71	39.73	190900.0
2023-02-07	ABB-DELISTED	Stock	33.8	34.09	33.56	34.0	1197560.0
2023-02-07	ABBNY-DELISTED	Stock	33.8	34.09	33.56	34.0	1339640.0
2023-02-07	ABBV	Stock	144.58	145.46	143.66	145.14	5401900.0
2023-02-07	ABC-DELISTED	Stock	154.23	157.2862	153.015	156.79	1105235.0
2023-02-07	ABCB	Stock	48.8	49.91	48.53	49.65	272600.0
2023-02-07	ABCL	Stock	10.94	11.025	10.56	10.81	1303900.0
2023-02-07	ABCM-DELISTED	Stock	14.55	15.8	14.54	15.65	389049.0
2023-02-07	ABEO	Stock	2.69	2.73	2.59	2.59	194500.0
2023-02-07	ABEV	Stock	2.47	2.5	2.45	2.49	32424900.0
2023-02-07	ABG	Stock	234.29	236.0	229.1	235.92	323900.0
2023-02-07	ABGI-DELISTED	Stock	10.16	10.17	10.16	10.17	164988.0
2023-02-07	ABLV	Stock	10.28	10.62	10.24	10.2403	19802.0
2023-02-07	ABM	Stock	47.18	47.49	46.69	47.45	293000.0
2023-02-07	ABNB	Stock	117.91	120.21	115.138	119.69	4397700.0
2023-02-07	ABOS	Stock	5.96	6.023	5.85	5.86	36900.0
2023-02-07	ABR	Stock	14.82	15.21	14.75	15.12	2557700.0
2023-02-07	ABR.D	Stock	20.58	20.98	20.5501	20.8	11632.0

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

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