PREVIEW / stock_daily / 2023-03-27

all stock daily files

  file:    by_date/stock_daily/2023/2023-03-27.parquet
  size:    244 KB
  rows:    7,595
  symbols: 1,761

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-27	AAPL	Stock	159.94	160.77	157.87	158.28	52390300.0
2023-03-27	MSFT	Stock	280.5	281.46	275.52	276.38	26840200.0
2023-03-27	NVDA	Stock	26.837	27.0	26.365	26.531	361026000.0
2023-03-27	AMZN	Stock	99.07	99.34	97.08	98.04	46721300.0
2023-03-27	GOOGL	Stock	104.615	104.76	101.9273	102.46	31120864.0
2023-03-27	META	Stock	204.81	205.86	201.36	202.84	18527200.0
2023-03-27	TSLA	Stock	194.42	197.39	189.94	191.81	120851600.0
2023-03-27	TLT	Stock	105.05	105.76	104.325	104.34	22224508.0
2023-03-27	ES	Stock	76.15	76.71	75.36	75.86	1771500.0
2023-03-27	CL	Stock	73.82	74.47	73.7	74.15	4203900.0
2023-03-27	A	Stock	133.58	134.62	132.73	133.07	1216300.0
2023-03-27	AA	Stock	40.51	40.77	39.573	40.12	3897700.0
2023-03-27	AAC-DELISTED	Stock	10.33	10.34	10.32	10.325	31832.0
2023-03-27	AACG	Stock	1.9	1.9	1.8	1.82	9800.0
2023-03-27	AACIW-DELISTED	Stock	0.1095	0.1095	0.1	0.1	301.0
2023-03-27	AAIC-DELISTED	Stock	2.73	2.73	2.66	2.73	18441.0
2023-03-27	AAIC.C-DELISTED	Stock	20.1641	20.25	20.1641	20.24	3683.0
2023-03-27	AAL	Stock	13.96	14.06	13.71	13.94	17126700.0
2023-03-27	AAM.A-DELISTED	Stock	21.1	21.1999	20.8501	20.93	26389.0
2023-03-27	AAM.B-DELISTED	Stock	20.9	21.25	20.9	21.02	7316.0
2023-03-27	AAMC-DELISTED	Stock	18.3676	21.0971	18.3676	20.9706	102092.0
2023-03-27	AAME	Stock	2.43	2.48	2.43	2.48	800.0
2023-03-27	AAMI	Stock	22.95	23.08	22.76	22.83	95700.0
2023-03-27	AAN-DELISTED	Stock	9.36	9.4	9.195	9.26	263200.0
2023-03-27	AAOI	Stock	2.36	2.365	1.71	1.72	808000.0
2023-03-27	AAON	Stock	61.5133	62.6733	61.3867	61.8733	357750.0
2023-03-27	AAP	Stock	111.95	115.79	111.95	114.74	1731600.0
2023-03-27	AAT	Stock	17.38	17.53	17.19	17.27	432600.0
2023-03-27	AATC	Stock	4.0	4.0	4.0	4.0	4096.0
2023-03-27	AAU-DELISTED	Stock	0.19	0.202	0.19	0.1975	50941.0
2023-03-27	AAUAF-DELISTED	Stock	0.19	0.202	0.19	0.1975	53100.0
2023-03-27	AAXJ	Stock	66.32	66.355	65.99	66.3	256448.0
2023-03-27	AB	Stock	33.77	35.21	33.77	34.86	388800.0
2023-03-27	ABB-DELISTED	Stock	32.16	32.3	32.03	32.145	1113280.0
2023-03-27	ABBNY-DELISTED	Stock	32.16	32.3	32.03	32.14	1235766.0
2023-03-27	ABBV	Stock	158.83	159.14	157.38	157.54	3887800.0
2023-03-27	ABC-DELISTED	Stock	157.49	158.44	156.09	156.69	555566.0
2023-03-27	ABCB	Stock	38.11	38.31	36.8	36.9	360800.0
2023-03-27	ABCL	Stock	7.435	7.665	7.35	7.58	1097400.0
2023-03-27	ABCM-DELISTED	Stock	12.88	13.515	12.85	13.25	623694.0
2023-03-27	ABEO	Stock	2.8	2.8	2.61	2.72	69400.0
2023-03-27	ABEV	Stock	2.65	2.68	2.64	2.66	13130300.0
2023-03-27	ABG	Stock	201.34	201.34	197.89	198.54	170400.0
2023-03-27	ABM	Stock	44.05	44.35	43.61	44.01	258000.0
2023-03-27	ABNB	Stock	117.99	119.274	116.74	117.91	2819600.0
2023-03-27	ABOS	Stock	4.21	4.25	3.8	4.21	107900.0
2023-03-27	ABR	Stock	11.37	11.45	11.14	11.18	4828900.0
2023-03-27	ABR.D	Stock	16.65	17.0	16.61	17.0	32758.0
2023-03-27	ABR.E	Stock	16.29	16.4888	16.1147	16.17	18752.0
2023-03-27	ABR.F	Stock	17.21	17.535	17.0	17.02	21292.0

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

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