PREVIEW / stock_daily / 2023-03-28

all stock daily files

  file:    by_date/stock_daily/2023/2023-03-28.parquet
  size:    243 KB
  rows:    7,580
  symbols: 1,741

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-28	AAPL	Stock	157.97	158.49	155.98	157.65	45992200.0
2023-03-28	MSFT	Stock	275.79	276.14	272.05	275.23	21878600.0
2023-03-28	NVDA	Stock	26.447	26.513	25.85	26.41	356104000.0
2023-03-28	AMZN	Stock	98.11	98.44	96.29	97.24	38720100.0
2023-03-28	GOOGL	Stock	102.44	102.45	99.74	101.03	32057865.0
2023-03-28	META	Stock	200.15	201.03	197.9	200.68	19127300.0
2023-03-28	TSLA	Stock	192.0	192.35	185.43	189.19	98654600.0
2023-03-28	TLT	Stock	104.24	104.68	104.02	104.53	17794343.0
2023-03-28	ES	Stock	75.68	76.92	75.63	76.18	1033400.0
2023-03-28	CL	Stock	74.45	74.79	74.24	74.5	4241900.0
2023-03-28	A	Stock	132.54	133.31	132.01	132.63	942600.0
2023-03-28	AA	Stock	40.25	41.03	40.06	40.53	3409800.0
2023-03-28	AAC-DELISTED	Stock	10.33	10.34	10.32	10.34	41358.0
2023-03-28	AACG	Stock	1.88	1.89	1.81	1.81	10600.0
2023-03-28	AACIW-DELISTED	Stock	0.1096	0.1097	0.0983	0.0985	7700.0
2023-03-28	AAIC-DELISTED	Stock	2.73	2.77	2.67	2.67	60577.0
2023-03-28	AAIC.C-DELISTED	Stock	20.1	20.115	20.0	20.0	1025.0
2023-03-28	AAL	Stock	13.91	14.08	13.85	13.98	11553000.0
2023-03-28	AAM.A-DELISTED	Stock	20.85	21.27	20.725	20.94	43651.0
2023-03-28	AAM.B-DELISTED	Stock	21.04	21.23	20.95	21.23	5552.0
2023-03-28	AAMC-DELISTED	Stock	21.1765	23.0588	20.8824	22.35	124090.0
2023-03-28	AAME	Stock	2.39	2.5	2.37	2.5	2400.0
2023-03-28	AAMI	Stock	22.69	22.95	22.69	22.85	82200.0
2023-03-28	AAN-DELISTED	Stock	9.22	9.43	9.175	9.22	278900.0
2023-03-28	AAOI	Stock	1.76	1.87	1.7	1.82	494200.0
2023-03-28	AAON	Stock	61.8667	63.7	61.8133	63.32	558000.0
2023-03-28	AAP	Stock	114.63	116.65	114.63	115.74	1048000.0
2023-03-28	AAT	Stock	17.1	17.59	16.93	17.54	488900.0
2023-03-28	AATC	Stock	4.0	4.0	3.94	3.975	8558.0
2023-03-28	AAU-DELISTED	Stock	0.202	0.202	0.1912	0.1966	128025.0
2023-03-28	AAUAF-DELISTED	Stock	0.202	0.202	0.1912	0.1966	131695.0
2023-03-28	AAXJ	Stock	66.62	67.205	66.62	67.17	596534.0
2023-03-28	AB	Stock	34.71	35.78	34.7	35.43	315900.0
2023-03-28	ABB-DELISTED	Stock	32.33	32.38	32.16	32.33	872953.0
2023-03-28	ABBNY-DELISTED	Stock	32.33	32.38	32.16	32.34	1000142.0
2023-03-28	ABBV	Stock	157.8	158.6	157.45	158.25	3532500.0
2023-03-28	ABC-DELISTED	Stock	156.73	158.55	156.65	158.01	573398.0
2023-03-28	ABCB	Stock	36.71	37.32	36.22	36.95	275000.0
2023-03-28	ABCL	Stock	7.5	7.74	7.5	7.55	962500.0
2023-03-28	ABCM-DELISTED	Stock	13.23	13.32	13.04	13.17	227232.0
2023-03-28	ABEO	Stock	2.73	3.09	2.72	2.78	218900.0
2023-03-28	ABEV	Stock	2.68	2.89	2.68	2.78	62541300.0
2023-03-28	ABG	Stock	198.36	201.52	196.32	199.39	194600.0
2023-03-28	ABM	Stock	43.79	44.3	43.66	44.04	220300.0
2023-03-28	ABNB	Stock	117.97	118.31	116.015	116.61	2941000.0
2023-03-28	ABOS	Stock	4.25	4.5	3.94	4.01	39400.0
2023-03-28	ABR	Stock	11.12	11.14	10.77	10.94	5311100.0
2023-03-28	ABR.D	Stock	16.99	17.0	16.92	16.9915	3355.0
2023-03-28	ABR.E	Stock	16.17	16.415	16.17	16.25	3746.0
2023-03-28	ABR.F	Stock	17.1221	17.45	17.0	17.08	16106.0

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

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