PREVIEW / stock_daily / 2023-09-06

all stock daily files

  file:    by_date/stock_daily/2023/2023-09-06.parquet
  size:    236 KB
  rows:    7,356
  symbols: 1,416

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-06	AAPL	Stock	188.4	188.85	181.47	182.91	81755800.0
2023-09-06	MSFT	Stock	333.38	334.46	330.18	332.88	17535800.0
2023-09-06	NVDA	Stock	48.441	48.549	46.58	47.061	468670000.0
2023-09-06	AMZN	Stock	136.32	137.45	134.61	135.36	41785500.0
2023-09-06	GOOGL	Stock	136.02	136.5299	133.665	134.46	18684534.0
2023-09-06	META	Stock	301.71	303.3	295.66	299.17	15418100.0
2023-09-06	TSLA	Stock	255.14	255.39	245.06	251.92	116959800.0
2023-09-06	TLT	Stock	94.09	94.11	93.46	93.75	23609041.0
2023-09-06	ES	Stock	61.5	61.52	60.37	60.98	3354200.0
2023-09-06	CL	Stock	72.72	72.84	72.28	72.32	2869100.0
2023-09-06	A	Stock	118.35	118.66	116.53	117.94	1668900.0
2023-09-06	AA	Stock	30.04	30.65	29.81	30.2	4090900.0
2023-09-06	AAC-DELISTED	Stock	10.7	10.71	10.69	10.695	131011.0
2023-09-06	AACG	Stock	1.23	1.23	1.21	1.21	1000.0
2023-09-06	AACT	Stock	10.23	10.24	10.23	10.23	45600.0
2023-09-06	AAIC-DELISTED	Stock	4.61	4.61	4.56	4.57	22375.0
2023-09-06	AAIC.C-DELISTED	Stock	24.3	24.4	24.3	24.3	5241.0
2023-09-06	AAL	Stock	14.27	14.75	14.24	14.33	25490000.0
2023-09-06	AAM.A-DELISTED	Stock	24.96	24.98	24.96	24.98	6170.0
2023-09-06	AAM.B-DELISTED	Stock	24.975	24.99	24.96	24.9604	4234.0
2023-09-06	AAMC-DELISTED	Stock	4.7294	4.8353	4.5665	4.6412	30090.0
2023-09-06	AAME	Stock	1.89	1.89	1.85	1.88	5000.0
2023-09-06	AAMI	Stock	20.38	20.687	20.2	20.22	179300.0
2023-09-06	AAN-DELISTED	Stock	10.69	10.87	10.44	10.55	880000.0
2023-09-06	AAOI	Stock	12.95	13.26	12.03	12.45	2108600.0
2023-09-06	AAON	Stock	64.33	65.71	64.29	65.26	307400.0
2023-09-06	AAP	Stock	67.19	68.0	66.51	67.0	2026700.0
2023-09-06	AAT	Stock	20.6	20.85	20.42	20.8	273900.0
2023-09-06	AATC	Stock	6.0	6.05	5.98	6.01	12334.0
2023-09-06	AAU-DELISTED	Stock	0.1217	0.1236	0.121	0.1235	267351.0
2023-09-06	AAUAF-DELISTED	Stock	0.1217	0.1236	0.121	0.1235	270433.0
2023-09-06	AAXJ	Stock	65.86	66.24	65.59	65.72	507007.0
2023-09-06	AB	Stock	32.4	32.66	31.96	32.25	462500.0
2023-09-06	ABBNY-DELISTED	Stock	37.35	37.61	37.33	37.42	714914.0
2023-09-06	ABBV	Stock	146.1	146.12	143.74	145.61	5304300.0
2023-09-06	ABCB	Stock	40.44	40.77	39.36	39.65	311000.0
2023-09-06	ABCL	Stock	5.56	5.57	5.425	5.51	1189300.0
2023-09-06	ABCM-DELISTED	Stock	22.85	23.03	22.71	22.92	7476832.0
2023-09-06	ABEO	Stock	4.25	4.43	4.01	4.04	45800.0
2023-09-06	ABEV	Stock	2.8	2.81	2.77	2.77	13907500.0
2023-09-06	ABG	Stock	226.71	230.0	224.2	225.24	135300.0
2023-09-06	ABLLW	Stock	0.49	0.49	0.47	0.47036	1005.0
2023-09-06	ABLV	Stock	3.59	3.59	3.0	3.0	74600.0
2023-09-06	ABM	Stock	44.83	45.16	44.45	44.81	646200.0
2023-09-06	ABNB	Stock	140.78	143.22	140.266	141.77	7114400.0
2023-09-06	ABOS	Stock	5.98	5.98	5.76	5.93	223000.0
2023-09-06	ABR	Stock	15.95	16.14	15.81	15.85	1681100.0
2023-09-06	ABR.D	Stock	19.02	19.02	18.94	18.95	7998.0
2023-09-06	ABR.E	Stock	19.1701	19.1701	19.0	19.0	4194.0
2023-09-06	ABR.F	Stock	20.59	20.59	20.26	20.59	6181.0

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

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