PREVIEW / stock_daily / 2023-03-22

all stock daily files

  file:    by_date/stock_daily/2023/2023-03-22.parquet
  size:    244 KB
  rows:    7,585
  symbols: 1,728

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-22	AAPL	Stock	159.3	162.14	157.81	157.83	75701800.0
2023-03-22	MSFT	Stock	273.4	281.04	272.18	272.29	34873300.0
2023-03-22	NVDA	Stock	26.425	27.589	26.237	26.468	797295000.0
2023-03-22	AMZN	Stock	100.45	102.1	98.61	98.7	57475400.0
2023-03-22	GOOGL	Stock	104.27	106.59	103.33	103.37	43427419.0
2023-03-22	META	Stock	202.5	207.37	199.67	199.81	28477800.0
2023-03-22	TSLA	Stock	199.3	200.66	190.95	191.15	150376400.0
2023-03-22	TLT	Stock	104.66	106.45	104.44	106.4	26388481.0
2023-03-22	ES	Stock	74.62	75.44	73.51	73.52	2289000.0
2023-03-22	CL	Stock	72.7	73.28	72.12	72.13	3180800.0
2023-03-22	A	Stock	136.96	137.54	133.6	133.73	1268500.0
2023-03-22	AA	Stock	41.95	42.24	39.96	40.06	6664500.0
2023-03-22	AAC-DELISTED	Stock	10.3	10.32	10.3	10.3	204622.0
2023-03-22	AACG	Stock	1.93	1.97	1.87	1.87	5500.0
2023-03-22	AACIW-DELISTED	Stock	0.1095	0.1095	0.1	0.1	401.0
2023-03-22	AAIC-DELISTED	Stock	2.79	2.8	2.71	2.73	31939.0
2023-03-22	AAIC.C-DELISTED	Stock	20.48	20.4801	19.95	20.4	7244.0
2023-03-22	AAL	Stock	14.36	14.43	13.79	13.82	21378100.0
2023-03-22	AAM.A-DELISTED	Stock	21.04	21.448	20.7898	21.245	12585.0
2023-03-22	AAM.B-DELISTED	Stock	21.4399	21.49	20.7823	21.165	25766.0
2023-03-22	AAMC-DELISTED	Stock	15.5882	16.5588	15.5882	16.2676	56770.0
2023-03-22	AAME	Stock	2.48	2.48	2.36	2.41	5700.0
2023-03-22	AAMI	Stock	23.36	23.425	22.64	22.64	82700.0
2023-03-22	AAN-DELISTED	Stock	9.33	9.59	8.99	9.0	523100.0
2023-03-22	AAOI	Stock	2.45	2.493	2.37	2.37	49600.0
2023-03-22	AAON	Stock	60.96	62.1067	60.5933	60.9333	531750.0
2023-03-22	AAP	Stock	119.74	119.92	113.57	113.6	2061100.0
2023-03-22	AAT	Stock	18.08	18.13	17.01	17.03	613500.0
2023-03-22	AATC	Stock	4.1025	4.1025	4.05	4.08	6039.0
2023-03-22	AAU-DELISTED	Stock	0.2049	0.2088	0.1922	0.195	149785.0
2023-03-22	AAUAF-DELISTED	Stock	0.2049	0.2088	0.1922	0.195	152457.0
2023-03-22	AAXJ	Stock	66.18	66.9	65.88	65.92	1494834.0
2023-03-22	AB	Stock	35.31	35.53	33.86	33.93	441500.0
2023-03-22	ABB-DELISTED	Stock	33.55	33.78	33.12	33.13	1339760.0
2023-03-22	ABBNY-DELISTED	Stock	33.55	33.78	33.12	33.12	1487655.0
2023-03-22	ABBV	Stock	155.68	156.88	153.61	153.67	4376900.0
2023-03-22	ABC-DELISTED	Stock	156.31	156.91	153.41	153.42	456635.0
2023-03-22	ABCB	Stock	38.43	38.72	36.75	36.91	632600.0
2023-03-22	ABCL	Stock	7.69	7.7	7.3	7.31	1181700.0
2023-03-22	ABCM-DELISTED	Stock	13.67	13.89	13.36	13.36	269332.0
2023-03-22	ABEO	Stock	2.46	2.6	2.38	2.4	49500.0
2023-03-22	ABEV	Stock	2.64	2.68	2.61	2.63	20009200.0
2023-03-22	ABG	Stock	204.63	206.39	198.75	198.76	164000.0
2023-03-22	ABLV	Stock	10.32	10.32	10.32	10.32	102.0
2023-03-22	ABM	Stock	44.28	44.28	43.01	43.02	376100.0
2023-03-22	ABNB	Stock	123.89	125.43	121.0	121.17	3971100.0
2023-03-22	ABOS	Stock	3.96	4.19	3.895	4.08	53500.0
2023-03-22	ABR	Stock	11.86	11.9	11.13	11.14	6037900.0
2023-03-22	ABR.D	Stock	17.1	17.2	16.805	16.805	28692.0
2023-03-22	ABR.E	Stock	16.44	16.5401	15.91	16.09	29453.0

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

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