PREVIEW / stock_daily / 2023-03-23

all stock daily files

  file:    by_date/stock_daily/2023/2023-03-23.parquet
  size:    243 KB
  rows:    7,536
  symbols: 1,717

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-23	AAPL	Stock	158.83	161.55	157.68	158.93	67622100.0
2023-03-23	MSFT	Stock	277.94	281.06	275.2	277.66	36610900.0
2023-03-23	NVDA	Stock	27.115	27.499	26.69	27.191	564889000.0
2023-03-23	AMZN	Stock	100.43	101.06	97.62	98.71	57559300.0
2023-03-23	GOOGL	Stock	105.06	106.3	104.46	105.6	40797769.0
2023-03-23	META	Stock	202.84	207.88	202.15	204.28	27389700.0
2023-03-23	TSLA	Stock	195.26	199.31	188.65	192.22	144193900.0
2023-03-23	TLT	Stock	105.36	106.55	104.82	106.4	25475128.0
2023-03-23	ES	Stock	73.26	74.4	72.77	73.25	2582500.0
2023-03-23	CL	Stock	72.1	72.71	71.78	71.83	3494500.0
2023-03-23	A	Stock	134.66	135.07	129.37	131.13	3297900.0
2023-03-23	AA	Stock	40.58	41.63	39.73	40.23	4143200.0
2023-03-23	AAC-DELISTED	Stock	10.3	10.34	10.3	10.32	1737741.0
2023-03-23	AACG	Stock	1.86	1.86	1.76	1.76	17800.0
2023-03-23	AACIW-DELISTED	Stock	0.11	0.11	0.11	0.11	100.0
2023-03-23	AAIC-DELISTED	Stock	2.72	2.74	2.65	2.67	57890.0
2023-03-23	AAIC.C-DELISTED	Stock	20.4	20.58	20.4	20.58	800.0
2023-03-23	AAL	Stock	14.0	14.18	13.47	13.63	25033400.0
2023-03-23	AAM.A-DELISTED	Stock	21.1001	21.5044	20.67	21.0	23868.0
2023-03-23	AAM.B-DELISTED	Stock	21.34	21.475	21.0	21.0	12796.0
2023-03-23	AAMC-DELISTED	Stock	16.3235	17.3706	16.3235	17.3235	80702.0
2023-03-23	AAME	Stock	2.46	2.49	2.41	2.49	3500.0
2023-03-23	AAMI	Stock	22.82	23.04	22.41	22.59	80800.0
2023-03-23	AAN-DELISTED	Stock	9.1	9.31	8.97	9.14	439200.0
2023-03-23	AAOI	Stock	2.36	2.47	2.36	2.46	84300.0
2023-03-23	AAON	Stock	61.1	62.9133	60.7733	61.5667	501150.0
2023-03-23	AAP	Stock	113.8	114.22	110.3	111.14	2062700.0
2023-03-23	AAT	Stock	17.09	17.27	16.38	16.48	650400.0
2023-03-23	AATC	Stock	4.07	4.08	4.055	4.06	3368.0
2023-03-23	AAU-DELISTED	Stock	0.201	0.2074	0.196	0.196	103220.0
2023-03-23	AAUAF-DELISTED	Stock	0.201	0.2074	0.196	0.196	105034.0
2023-03-23	AAXJ	Stock	66.91	67.74	66.71	67.05	832175.0
2023-03-23	AB	Stock	33.99	34.76	33.67	33.67	480500.0
2023-03-23	ABB-DELISTED	Stock	33.49	33.75	33.175	33.38	1918298.0
2023-03-23	ABBNY-DELISTED	Stock	33.51	33.75	33.175	33.38	2115532.0
2023-03-23	ABBV	Stock	154.1	156.5	154.02	155.3	4584000.0
2023-03-23	ABC-DELISTED	Stock	153.38	153.665	150.54	150.85	601425.0
2023-03-23	ABCB	Stock	37.02	37.24	35.32	35.38	554900.0
2023-03-23	ABCL	Stock	7.35	7.45	7.16	7.31	1736000.0
2023-03-23	ABCM-DELISTED	Stock	13.39	13.55	12.98	13.185	568671.0
2023-03-23	ABEO	Stock	2.4	2.51	2.35	2.43	72800.0
2023-03-23	ABEV	Stock	2.67	2.68	2.56	2.59	24670800.0
2023-03-23	ABG	Stock	199.99	202.52	195.0	197.96	243800.0
2023-03-23	ABM	Stock	42.93	43.24	42.2	42.43	458800.0
2023-03-23	ABNB	Stock	122.51	124.66	118.33	120.3	4028500.0
2023-03-23	ABOS	Stock	4.13	4.26	3.84	3.98	64400.0
2023-03-23	ABR	Stock	11.22	11.39	10.8	10.84	6586800.0
2023-03-23	ABR.D	Stock	17.24	17.24	16.65	16.69	20474.0
2023-03-23	ABR.E	Stock	16.03	16.62	15.9	16.1186	24723.0
2023-03-23	ABR.F	Stock	17.6651	18.11	17.05	17.05	8738.0

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

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