PREVIEW / stock_daily / 2023-09-01

all stock daily files

  file:    by_date/stock_daily/2023/2023-09-01.parquet
  size:    236 KB
  rows:    7,363
  symbols: 1,439

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-09-01	AAPL	Stock	189.49	189.92	188.28	189.46	45732600.0
2023-09-01	MSFT	Stock	331.31	331.99	326.78	328.66	14931200.0
2023-09-01	NVDA	Stock	49.762	49.8	48.142	48.509	463830000.0
2023-09-01	AMZN	Stock	139.46	139.96	136.88	138.12	40948300.0
2023-09-01	GOOGL	Stock	137.455	137.455	134.85	135.66	21543687.0
2023-09-01	META	Stock	299.37	301.74	294.47	296.38	12819800.0
2023-09-01	TSLA	Stock	257.26	259.08	242.01	245.01	132272500.0
2023-09-01	TLT	Stock	95.8	95.82	94.62	94.85	32469677.0
2023-09-01	ES	Stock	64.31	64.46	62.72	63.05	1809300.0
2023-09-01	CL	Stock	73.95	73.97	73.0	73.27	2412800.0
2023-09-01	A	Stock	122.69	123.68	121.54	121.91	840700.0
2023-09-01	AA	Stock	30.95	31.45	30.701	31.1	5975500.0
2023-09-01	AAC-DELISTED	Stock	10.69	10.69	10.68	10.68	28542.0
2023-09-01	AACG	Stock	1.3	1.3	1.23	1.26	2900.0
2023-09-01	AACIW-DELISTED	Stock	0.0792	0.0792	0.0792	0.0792	250.0
2023-09-01	AACT	Stock	10.23	10.24	10.23	10.24	550300.0
2023-09-01	AAIC-DELISTED	Stock	4.64	4.65	4.58	4.58	40600.0
2023-09-01	AAIC.C-DELISTED	Stock	24.09	24.2	24.06	24.2	5402.0
2023-09-01	AAL	Stock	14.8	14.84	14.59	14.68	14713500.0
2023-09-01	AAM.A-DELISTED	Stock	24.99	24.99	24.95	24.97	4439.0
2023-09-01	AAM.B-DELISTED	Stock	24.95	24.9799	24.95	24.96	6236.0
2023-09-01	AAMC-DELISTED	Stock	5.0118	5.1941	4.7529	4.9	36040.0
2023-09-01	AAME	Stock	2.09	2.09	1.98	1.98	1400.0
2023-09-01	AAMI	Stock	20.89	21.36	20.89	21.09	235500.0
2023-09-01	AAN-DELISTED	Stock	12.17	12.44	12.17	12.26	188800.0
2023-09-01	AAOI	Stock	13.94	14.29	13.5	13.94	1409600.0
2023-09-01	AAON	Stock	63.64	66.23	63.62	65.66	462200.0
2023-09-01	AAP	Stock	69.2	69.38	67.22	67.65	1966400.0
2023-09-01	AAT	Stock	21.61	21.74	21.41	21.54	202300.0
2023-09-01	AATC	Stock	6.1	6.1	6.06	6.08	1905.0
2023-09-01	AAU-DELISTED	Stock	0.121	0.1248	0.12	0.124	183197.0
2023-09-01	AAUAF-DELISTED	Stock	0.121	0.1248	0.12	0.124	183942.0
2023-09-01	AAXJ	Stock	66.46	66.8	66.28	66.43	403611.0
2023-09-01	AB	Stock	31.07	31.69	31.07	31.21	428800.0
2023-09-01	ABBNY-DELISTED	Stock	38.16	38.16	37.46	37.49	314636.0
2023-09-01	ABBV	Stock	147.36	148.89	147.36	148.2	3357800.0
2023-09-01	ABCB	Stock	41.15	42.22	41.02	41.77	236600.0
2023-09-01	ABCL	Stock	5.51	5.66	5.38	5.59	1840200.0
2023-09-01	ABCM-DELISTED	Stock	22.66	22.85	22.63	22.83	6905217.0
2023-09-01	ABEO	Stock	4.45	4.55	4.05	4.19	209000.0
2023-09-01	ABEV	Stock	2.82	2.83	2.75	2.77	6855500.0
2023-09-01	ABG	Stock	232.11	234.1	231.76	233.48	108100.0
2023-09-01	ABLLW	Stock	0.4752	0.48	0.4625	0.4625	11005.0
2023-09-01	ABLV	Stock	4.37	4.57	4.1	4.17	68251.0
2023-09-01	ABM	Stock	45.77	46.13	45.5	45.81	342300.0
2023-09-01	ABNB	Stock	133.7	134.5	131.33	132.69	4418300.0
2023-09-01	ABOS	Stock	6.04	6.2	5.97	6.11	613800.0
2023-09-01	ABR	Stock	16.13	16.28	16.04	16.16	2892300.0
2023-09-01	ABR.D	Stock	19.07	19.14	18.9	19.14	3610.0
2023-09-01	ABR.E	Stock	18.94	19.15	18.93	19.14	2207.0

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

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