PREVIEW / stock_daily / 2023-03-21

all stock daily files

  file:    by_date/stock_daily/2023/2023-03-21.parquet
  size:    246 KB
  rows:    7,632
  symbols: 1,775

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-21	AAPL	Stock	157.32	159.4	156.54	159.28	73938300.0
2023-03-21	MSFT	Stock	274.88	275.0	269.52	273.78	34558700.0
2023-03-21	NVDA	Stock	26.18	26.392	25.381	26.199	547408000.0
2023-03-21	AMZN	Stock	98.14	100.85	98.0	100.61	58597300.0
2023-03-21	GOOGL	Stock	101.25	105.1	101.22	104.92	42110279.0
2023-03-21	META	Stock	203.2	203.55	197.95	202.16	31827000.0
2023-03-21	TSLA	Stock	188.28	198.0	188.04	197.58	153391400.0
2023-03-21	TLT	Stock	105.08	105.42	104.54	105.0	18934923.0
2023-03-21	ES	Stock	76.17	76.66	73.61	74.92	2322400.0
2023-03-21	CL	Stock	73.02	73.26	71.97	72.38	4561200.0
2023-03-21	A	Stock	135.56	137.42	135.22	137.01	1392300.0
2023-03-21	AA	Stock	41.12	42.47	41.12	41.91	4334100.0
2023-03-21	AAC-DELISTED	Stock	10.32	10.32	10.3016	10.31	129739.0
2023-03-21	AACG	Stock	1.8	1.93	1.8	1.9	5600.0
2023-03-21	AACIW-DELISTED	Stock	0.09	0.1099	0.0847	0.1099	1453.0
2023-03-21	AAIC-DELISTED	Stock	2.74	2.8	2.74	2.77	48365.0
2023-03-21	AAIC.C-DELISTED	Stock	20.78	20.78	20.48	20.5601	2284.0
2023-03-21	AAL	Stock	14.29	14.54	14.25	14.37	17788600.0
2023-03-21	AAM.A-DELISTED	Stock	20.83	21.7	20.83	21.11	20102.0
2023-03-21	AAM.B-DELISTED	Stock	21.155	21.58	20.78	21.25	17241.0
2023-03-21	AAMC-DELISTED	Stock	14.7059	16.0897	14.7	15.8529	57025.0
2023-03-21	AAME	Stock	2.48	2.5	2.48	2.48	2500.0
2023-03-21	AAMI	Stock	23.06	23.36	22.84	23.31	144600.0
2023-03-21	AAN-DELISTED	Stock	9.65	9.76	9.22	9.29	661500.0
2023-03-21	AAOI	Stock	2.42	2.5	2.38	2.43	50700.0
2023-03-21	AAON	Stock	60.7267	61.4267	60.1333	61.1133	566250.0
2023-03-21	AAP	Stock	119.91	120.82	119.14	119.79	1290000.0
2023-03-21	AAT	Stock	17.98	18.47	17.84	18.17	894300.0
2023-03-21	AATC	Stock	4.12	4.155	4.07	4.105	1370.0
2023-03-21	AAU-DELISTED	Stock	0.2029	0.2048	0.1965	0.1994	131697.0
2023-03-21	AAUAF-DELISTED	Stock	0.2029	0.2048	0.1965	0.1994	132534.0
2023-03-21	AAXJ	Stock	65.33	65.68	65.15	65.51	280866.0
2023-03-21	AB	Stock	35.87	35.9	35.27	35.46	360600.0
2023-03-21	ABB-DELISTED	Stock	33.21	33.37	33.1	33.28	1116951.0
2023-03-21	ABBNY-DELISTED	Stock	33.21	33.37	33.1	33.27	1233260.0
2023-03-21	ABBV	Stock	156.64	157.05	155.1	156.77	4675700.0
2023-03-21	ABC-DELISTED	Stock	154.68	156.54	154.5	156.08	813737.0
2023-03-21	ABCB	Stock	37.69	38.69	37.65	38.56	566700.0
2023-03-21	ABCL	Stock	7.71	7.75	7.5	7.62	1037200.0
2023-03-21	ABCM-DELISTED	Stock	13.51	13.98	13.38	13.815	287638.0
2023-03-21	ABEO	Stock	2.39	2.54	2.33	2.45	99800.0
2023-03-21	ABEV	Stock	2.68	2.69	2.63	2.63	13958100.0
2023-03-21	ABG	Stock	206.49	210.29	203.3	204.25	204800.0
2023-03-21	ABM	Stock	44.84	45.25	43.93	44.22	391500.0
2023-03-21	ABNB	Stock	120.0	124.43	119.85	123.69	5374400.0
2023-03-21	ABOS	Stock	3.78	4.05	3.78	3.88	91300.0
2023-03-21	ABR	Stock	11.97	12.21	11.84	11.91	4039300.0
2023-03-21	ABR.D	Stock	17.16	17.16	16.8387	16.97	39312.0
2023-03-21	ABR.E	Stock	16.42	16.81	16.16	16.17	33994.0
2023-03-21	ABR.F	Stock	18.0	18.1998	17.65	17.65	11714.0

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

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