PREVIEW / stock_daily / 2023-08-31

all stock daily files

  file:    by_date/stock_daily/2023/2023-08-31.parquet
  size:    238 KB
  rows:    7,437
  symbols: 1,455

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-08-31	AAPL	Stock	187.84	189.12	187.48	187.87	60794500.0
2023-08-31	MSFT	Stock	329.2	330.91	326.78	327.76	26411000.0
2023-08-31	NVDA	Stock	49.38	49.744	48.958	49.355	528570000.0
2023-08-31	AMZN	Stock	135.06	138.79	135.0	138.01	58781300.0
2023-08-31	GOOGL	Stock	136.01	138.0	135.79	136.17	30053800.0
2023-08-31	META	Stock	295.8	301.1	295.66	295.89	17229900.0
2023-08-31	TSLA	Stock	255.98	261.18	255.05	258.08	108861700.0
2023-08-31	TLT	Stock	96.54	97.05	96.425	96.64	26959665.0
2023-08-31	ES	Stock	64.7	64.91	63.78	63.82	2421800.0
2023-08-31	CL	Stock	74.0	74.11	73.42	73.47	5205300.0
2023-08-31	A	Stock	123.11	123.12	120.65	121.07	2875100.0
2023-08-31	AA	Stock	29.82	30.83	29.56	30.08	19155300.0
2023-08-31	AAC-DELISTED	Stock	10.69	10.69	10.67	10.68	46237.0
2023-08-31	AACG	Stock	1.24	1.27	1.24	1.24	2200.0
2023-08-31	AACT	Stock	10.23	10.23	10.23	10.23	4200.0
2023-08-31	AAIC-DELISTED	Stock	4.62	4.63	4.6	4.63	21814.0
2023-08-31	AAIC.C-DELISTED	Stock	24.26	24.26	23.91	24.19	4370.0
2023-08-31	AAL	Stock	14.89	14.92	14.68	14.73	13994500.0
2023-08-31	AAM.A-DELISTED	Stock	24.92	24.96	24.92	24.94	65955.0
2023-08-31	AAM.B-DELISTED	Stock	24.92	25.0	24.92	25.0	39972.0
2023-08-31	AAMC-DELISTED	Stock	5.1471	5.2529	4.9588	4.9647	24990.0
2023-08-31	AAME	Stock	1.97	2.1	1.97	2.03	2900.0
2023-08-31	AAMI	Stock	20.96	21.11	20.685	20.71	177200.0
2023-08-31	AAN-DELISTED	Stock	11.92	12.16	11.92	12.07	280700.0
2023-08-31	AAOI	Stock	15.23	15.78	13.44	13.77	3029500.0
2023-08-31	AAON	Stock	62.86	63.73	62.86	63.06	441800.0
2023-08-31	AAP	Stock	67.99	69.76	67.83	68.82	5760400.0
2023-08-31	AAT	Stock	21.5	21.58	21.29	21.41	280600.0
2023-08-31	AATC	Stock	5.81	6.1	5.81	6.05	21168.0
2023-08-31	AAU-DELISTED	Stock	0.125	0.125	0.12	0.12	105218.0
2023-08-31	AAUAF-DELISTED	Stock	0.125	0.125	0.12	0.12	106638.0
2023-08-31	AAXJ	Stock	65.87	65.99	65.46	65.58	998551.0
2023-08-31	AB	Stock	31.26	31.46	30.91	30.97	252300.0
2023-08-31	ABBNY-DELISTED	Stock	38.02	38.17	37.86	37.91	240379.0
2023-08-31	ABBV	Stock	148.39	148.71	146.87	146.96	4110700.0
2023-08-31	ABCB	Stock	40.14	40.82	39.83	40.75	291200.0
2023-08-31	ABCL	Stock	5.79	5.8	5.43	5.45	1784100.0
2023-08-31	ABCM-DELISTED	Stock	22.62	22.74	22.57	22.605	7259196.0
2023-08-31	ABEO	Stock	4.35	4.54	4.34	4.43	129900.0
2023-08-31	ABEV	Stock	2.85	2.85	2.76	2.77	21106100.0
2023-08-31	ABG	Stock	229.57	231.58	228.89	230.0	165200.0
2023-08-31	ABLLW	Stock	0.47	0.48	0.45	0.48	26228.0
2023-08-31	ABLV	Stock	4.19	4.64	4.19	4.28	181195.0
2023-08-31	ABM	Stock	45.73	46.07	45.33	45.42	358500.0
2023-08-31	ABNB	Stock	130.6	132.44	129.81	131.55	3860300.0
2023-08-31	ABOS	Stock	6.32	6.32	5.99	6.02	320400.0
2023-08-31	ABR	Stock	16.12	16.21	15.91	15.96	7776600.0
2023-08-31	ABR.D	Stock	19.05	19.15	18.6953	19.0	9883.0
2023-08-31	ABR.E	Stock	18.84	18.91	18.8	18.8	3304.0
2023-08-31	ABR.F	Stock	20.55	20.8	20.5106	20.72	63655.0

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

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