PREVIEW / stock_daily / 2023-02-24

all stock daily files

  file:    by_date/stock_daily/2023/2023-02-24.parquet
  size:    247 KB
  rows:    7,630
  symbols: 1,804

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-24	AAPL	Stock	147.11	147.19	145.72	146.71	55469600.0
2023-02-24	MSFT	Stock	249.96	251.0	248.1	249.22	24990900.0
2023-02-24	NVDA	Stock	23.225	23.474	22.947	23.286	589716000.0
2023-02-24	AMZN	Stock	93.53	94.14	92.32	93.5	57053800.0
2023-02-24	GOOGL	Stock	89.44	89.89	88.575	89.13	36585093.0
2023-02-24	META	Stock	168.64	170.72	167.66	170.39	19791300.0
2023-02-24	TSLA	Stock	196.33	197.67	192.8	196.88	142228100.0
2023-02-24	TLT	Stock	101.44	101.795	100.56	100.97	21403577.0
2023-02-24	ES	Stock	77.25	77.68	76.66	77.38	1206500.0
2023-02-24	CL	Stock	73.28	73.36	72.75	73.13	3115000.0
2023-02-24	A	Stock	141.46	142.24	138.72	141.2	1522100.0
2023-02-24	AA	Stock	46.93	46.93	45.27	46.45	4587700.0
2023-02-24	AAC-DELISTED	Stock	10.23	10.23	10.22	10.22	32522.0
2023-02-24	AACG	Stock	1.94	1.94	1.82	1.87	57600.0
2023-02-24	AACIW-DELISTED	Stock	0.1149	0.115	0.1	0.1	1029.0
2023-02-24	AAIC-DELISTED	Stock	3.04	3.07	3.01	3.03	69412.0
2023-02-24	AAIC.C-DELISTED	Stock	23.0	23.5	23.0	23.4	981.0
2023-02-24	AAL	Stock	15.51	15.67	15.36	15.56	20471800.0
2023-02-24	AAM.A-DELISTED	Stock	24.41	24.7	24.29	24.57	5343.0
2023-02-24	AAM.B-DELISTED	Stock	24.59	24.85	24.59	24.59	8075.0
2023-02-24	AAMC-DELISTED	Stock	11.7681	12.5396	11.7681	12.1765	28839.0
2023-02-24	AAME	Stock	2.47	2.48	2.4	2.4	1100.0
2023-02-24	AAMI	Stock	24.74	24.88	24.26	24.82	103600.0
2023-02-24	AAN-DELISTED	Stock	13.8	14.225	13.65	14.13	281800.0
2023-02-24	AAOI	Stock	2.97	2.97	2.59	2.61	329700.0
2023-02-24	AAON	Stock	53.14	54.4333	52.7733	54.3133	367500.0
2023-02-24	AAP	Stock	140.28	140.76	137.93	138.85	2080300.0
2023-02-24	AAT	Stock	25.5	25.58	25.32	25.47	239500.0
2023-02-24	AATC	Stock	4.23	4.25	4.2	4.2	6638.0
2023-02-24	AAU-DELISTED	Stock	0.2175	0.2175	0.21	0.2109	88858.0
2023-02-24	AAUAF-DELISTED	Stock	0.2175	0.2175	0.21	0.2109	91808.0
2023-02-24	AAWW-DELISTED	Stock	101.55	101.78	101.55	101.74	378568.0
2023-02-24	AAXJ	Stock	65.63	65.78	65.23	65.48	563285.0
2023-02-24	AB	Stock	38.61	39.32	38.61	39.23	166000.0
2023-02-24	ABB-DELISTED	Stock	33.11	33.225	32.935	33.155	910637.0
2023-02-24	ABBNY-DELISTED	Stock	33.13	33.225	32.935	33.16	1039217.0
2023-02-24	ABBV	Stock	151.3	152.98	150.91	152.71	5621100.0
2023-02-24	ABC-DELISTED	Stock	159.19	159.7	155.34	158.54	787074.0
2023-02-24	ABCB	Stock	47.77	48.2	47.5	48.02	276100.0
2023-02-24	ABCL	Stock	8.37	8.525	8.3	8.37	2234700.0
2023-02-24	ABCM-DELISTED	Stock	14.26	14.4	14.12	14.28	238922.0
2023-02-24	ABEO	Stock	2.28	2.31	2.19	2.25	159700.0
2023-02-24	ABEV	Stock	2.52	2.57	2.51	2.55	32153800.0
2023-02-24	ABG	Stock	224.7	225.21	219.26	221.24	248300.0
2023-02-24	ABLV	Stock	10.3	10.3	10.29	10.29	24075.0
2023-02-24	ABM	Stock	48.18	48.84	47.8	48.82	319300.0
2023-02-24	ABNB	Stock	123.04	124.85	120.191	122.78	5119800.0
2023-02-24	ABOS	Stock	5.22	5.55	5.22	5.24	27900.0
2023-02-24	ABR	Stock	15.25	15.33	15.15	15.28	1982600.0
2023-02-24	ABR.D	Stock	20.19	20.22	20.15	20.17	6235.0

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

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