PREVIEW / stock_daily / 2022-08-31

all stock daily files

  file:    by_date/stock_daily/2022/2022-08-31.parquet
  size:    252 KB
  rows:    7,831
  symbols: 2,195

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
2022-08-31	AAPL	Stock	160.31	160.58	157.14	157.22	87991100.0
2022-08-31	MSFT	Stock	265.39	267.11	261.33	261.47	24791800.0
2022-08-31	NVDA	Stock	15.384	15.54	14.959	15.094	573710000.0
2022-08-31	AMZN	Stock	129.45	130.59	126.74	126.77	53648700.0
2022-08-31	GOOGL	Stock	110.65	110.85	108.13	108.22	28626972.0
2022-08-31	META	Stock	167.07	167.84	162.14	162.93	40953000.0
2022-08-31	TSLA	Stock	280.62	281.25	271.81	275.61	52107300.0
2022-08-31	TLT	Stock	112.69	113.34	111.575	111.88	13623548.0
2022-08-31	ES	Stock	90.81	90.91	89.34	89.69	2520800.0
2022-08-31	CL	Stock	79.25	79.57	78.14	78.21	4054100.0
2022-08-31	A	Stock	129.38	130.23	128.0	128.25	1890700.0
2022-08-31	AA	Stock	50.33	50.61	48.89	49.48	5649700.0
2022-08-31	AAC-DELISTED	Stock	9.9	9.91	9.89	9.91	317074.0
2022-08-31	AACG	Stock	2.58	2.58	2.46	2.5	16100.0
2022-08-31	AACIU	Stock	9.96	9.96	9.96	9.96	300.0
2022-08-31	AACIW-DELISTED	Stock	0.1999	0.1999	0.1999	0.1999	100.0
2022-08-31	AAIC-DELISTED	Stock	3.33	3.33	3.17	3.2	86194.0
2022-08-31	AAIC.C-DELISTED	Stock	21.7914	22.3293	21.75	22.04	1423.0
2022-08-31	AAL	Stock	13.49	13.53	12.96	12.99	27923800.0
2022-08-31	AAM.A-DELISTED	Stock	24.75	24.8272	24.3	24.46	19217.0
2022-08-31	AAM.B-DELISTED	Stock	24.6	24.72	24.16	24.27	18332.0
2022-08-31	AAMC-DELISTED	Stock	5.4824	6.1971	5.4422	5.9706	57610.0
2022-08-31	AAME	Stock	3.03	3.09	2.9	2.99	13700.0
2022-08-31	AAMI	Stock	17.83	17.84	17.09	17.09	212200.0
2022-08-31	AAN-DELISTED	Stock	12.68	12.72	11.815	11.9	369800.0
2022-08-31	AAOI	Stock	2.42	2.46	2.35	2.41	123700.0
2022-08-31	AAON	Stock	38.7533	39.0067	38.0467	38.32	149100.0
2022-08-31	AAP	Stock	170.23	171.74	168.26	168.64	913600.0
2022-08-31	AAQC-DELISTED	Stock	9.82	9.83	9.81	9.81	103865.0
2022-08-31	AAT	Stock	28.07	28.22	27.75	27.76	237300.0
2022-08-31	AATC	Stock	5.28	5.28	5.05	5.0548	29512.0
2022-08-31	AAU-DELISTED	Stock	0.2352	0.2353	0.221	0.221	128328.0
2022-08-31	AAUAF-DELISTED	Stock	0.2352	0.2353	0.221	0.2352	131240.0
2022-08-31	AAWW-DELISTED	Stock	99.97	100.18	99.75	99.91	432063.0
2022-08-31	AAXJ	Stock	67.3	67.56	66.91	66.96	680249.0
2022-08-31	AB	Stock	43.9	44.26	43.04	43.08	129700.0
2022-08-31	ABB-DELISTED	Stock	27.83	27.95	27.56	27.57	1566559.0
2022-08-31	ABBNY-DELISTED	Stock	27.83	27.95	27.56	27.57	1806026.0
2022-08-31	ABBV	Stock	135.69	136.04	134.17	134.46	5789600.0
2022-08-31	ABC-DELISTED	Stock	145.63	147.61	145.56	146.56	630243.0
2022-08-31	ABCB	Stock	47.07	47.3	46.4	46.68	293600.0
2022-08-31	ABCL	Stock	10.82	10.92	10.54	10.68	767400.0
2022-08-31	ABCM-DELISTED	Stock	14.86	15.069	14.82	14.91	183727.0
2022-08-31	ABEO	Stock	3.84	3.92	3.62	3.64	105400.0
2022-08-31	ABEV	Stock	2.93	2.98	2.89	2.9	23077300.0
2022-08-31	ABG	Stock	179.49	181.32	173.98	174.48	166600.0
2022-08-31	ABM	Stock	45.94	46.57	45.56	46.4	309600.0
2022-08-31	ABMD-DELISTED	Stock	260.38	266.4	258.12	259.18	155890.0
2022-08-31	ABNB	Stock	113.49	115.58	112.4	113.12	6191600.0
2022-08-31	ABOS	Stock	5.409	5.85	5.37	5.69	22800.0

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

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