PREVIEW / stock_daily / 2023-03-09

all stock daily files

  file:    by_date/stock_daily/2023/2023-03-09.parquet
  size:    247 KB
  rows:    7,630
  symbols: 1,791

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-03-09	AAPL	Stock	153.56	154.54	150.23	150.59	53833600.0
2023-03-09	MSFT	Stock	255.82	259.56	251.58	252.32	26653400.0
2023-03-09	NVDA	Stock	24.175	24.454	23.383	23.436	501257000.0
2023-03-09	AMZN	Stock	93.68	96.21	92.18	92.25	56218700.0
2023-03-09	GOOGL	Stock	94.05	95.53	91.9	92.32	28813532.0
2023-03-09	META	Stock	186.35	188.93	180.3	181.69	26582800.0
2023-03-09	TSLA	Stock	180.25	185.18	172.51	172.92	170023800.0
2023-03-09	TLT	Stock	101.55	102.52	101.33	102.07	21550356.0
2023-03-09	ES	Stock	75.19	75.89	74.01	74.27	1330200.0
2023-03-09	CL	Stock	72.33	72.53	70.92	71.34	4893200.0
2023-03-09	A	Stock	141.26	142.0	138.3	138.93	1328900.0
2023-03-09	AA	Stock	50.7	51.14	47.33	47.9	5590500.0
2023-03-09	AAC-DELISTED	Stock	10.26	10.29	10.26	10.28	243734.0
2023-03-09	AACG	Stock	2.44	2.49	2.28	2.47	80100.0
2023-03-09	AACIW-DELISTED	Stock	0.1035	0.11	0.0965	0.1025	10700.0
2023-03-09	AAIC-DELISTED	Stock	3.05	3.05	2.93	2.93	91477.0
2023-03-09	AAIC.C-DELISTED	Stock	21.8	21.8	20.88	21.51	5495.0
2023-03-09	AAL	Stock	16.55	16.8	15.85	15.88	18505000.0
2023-03-09	AAM.A-DELISTED	Stock	23.03	23.1241	22.1889	22.4101	10774.0
2023-03-09	AAM.B-DELISTED	Stock	23.94	23.94	22.2	22.4432	11871.0
2023-03-09	AAMC-DELISTED	Stock	16.7088	17.5824	16.7088	17.3471	51398.0
2023-03-09	AAME	Stock	2.36	2.42	2.36	2.42	1600.0
2023-03-09	AAMI	Stock	24.86	24.89	24.08	24.21	122000.0
2023-03-09	AAN-DELISTED	Stock	12.06	12.15	11.49	11.51	285200.0
2023-03-09	AAOI	Stock	2.845	2.91	2.81	2.81	117200.0
2023-03-09	AAON	Stock	61.82	62.1533	61.0533	61.4467	277200.0
2023-03-09	AAP	Stock	132.78	133.69	129.75	129.83	1329700.0
2023-03-09	AAT	Stock	22.5	22.77	21.31	21.38	1829700.0
2023-03-09	AATC	Stock	4.2425	4.2425	4.18	4.19	6189.0
2023-03-09	AAU-DELISTED	Stock	0.19	0.2	0.19	0.1944	242802.0
2023-03-09	AAUAF-DELISTED	Stock	0.19	0.2	0.19	0.1944	245789.0
2023-03-09	AAWW-DELISTED	Stock	100.47	100.655	99.9	100.33	530379.0
2023-03-09	AAXJ	Stock	66.03	66.03	64.82	64.94	865711.0
2023-03-09	AB	Stock	37.81	37.99	36.71	36.74	171800.0
2023-03-09	ABB-DELISTED	Stock	34.09	34.53	33.865	33.93	1267821.0
2023-03-09	ABBNY-DELISTED	Stock	34.09	34.53	33.865	33.93	1431439.0
2023-03-09	ABBV	Stock	150.07	150.91	146.57	147.35	5350200.0
2023-03-09	ABC-DELISTED	Stock	152.58	152.79	149.15	150.0	967603.0
2023-03-09	ABCB	Stock	44.53	44.53	42.2	42.43	450800.0
2023-03-09	ABCL	Stock	8.13	8.17	7.79	7.87	1861000.0
2023-03-09	ABCM-DELISTED	Stock	14.83	15.17	14.71	14.81	431460.0
2023-03-09	ABEO	Stock	3.29	3.37	2.81	2.86	238200.0
2023-03-09	ABEV	Stock	2.66	2.67	2.62	2.62	14157300.0
2023-03-09	ABG	Stock	235.34	237.42	231.61	234.74	292300.0
2023-03-09	ABLV	Stock	10.33	10.33	10.33	10.33	18270.0
2023-03-09	ABM	Stock	46.2	47.09	45.79	46.14	667100.0
2023-03-09	ABNB	Stock	125.06	125.2	119.71	119.84	6147700.0
2023-03-09	ABOS	Stock	5.54	5.652	5.18	5.28	106000.0
2023-03-09	ABR	Stock	14.82	14.83	14.09	14.11	3758800.0
2023-03-09	ABR.D	Stock	18.984	18.984	18.175	18.24	11142.0

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

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