PREVIEW / stock_daily / 2023-04-06

all stock daily files

  file:    by_date/stock_daily/2023/2023-04-06.parquet
  size:    243 KB
  rows:    7,591
  symbols: 1,721

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-04-06	AAPL	Stock	162.43	164.96	162.0	164.66	45390100.0
2023-04-06	MSFT	Stock	283.21	292.08	282.03	291.6	29770300.0
2023-04-06	NVDA	Stock	26.584	27.08	26.427	27.037	397654000.0
2023-04-06	AMZN	Stock	100.75	102.38	99.8	102.06	43808000.0
2023-04-06	GOOGL	Stock	105.26	109.17	104.33	108.42	48711480.0
2023-04-06	META	Stock	209.25	216.94	208.65	216.1	26104400.0
2023-04-06	TSLA	Stock	183.08	186.39	179.74	185.06	123857900.0
2023-04-06	TLT	Stock	108.42	108.87	108.39	108.53	16447295.0
2023-04-06	ES	Stock	81.09	81.36	79.99	80.82	1175900.0
2023-04-06	CL	Stock	75.59	76.07	75.01	75.68	3261800.0
2023-04-06	A	Stock	138.01	138.13	136.59	138.03	1206200.0
2023-04-06	AA	Stock	39.12	39.29	38.08	39.16	5313600.0
2023-04-06	AAC-DELISTED	Stock	10.32	10.34	10.32	10.325	95449.0
2023-04-06	AACG	Stock	1.87	1.9	1.81	1.84	9900.0
2023-04-06	AAIC-DELISTED	Stock	2.8	2.82	2.72	2.7589	73061.0
2023-04-06	AAL	Stock	13.95	14.18	13.87	14.01	14067000.0
2023-04-06	AAM.A-DELISTED	Stock	22.48	22.656	21.92	22.52	19460.0
2023-04-06	AAM.B-DELISTED	Stock	23.39	23.4223	22.885	23.18	8694.0
2023-04-06	AAMC-DELISTED	Stock	19.0588	19.0618	18.7706	18.7706	12441.0
2023-04-06	AAME	Stock	2.49	2.49	2.42	2.42	1800.0
2023-04-06	AAMI	Stock	22.01	22.54	21.85	22.36	112400.0
2023-04-06	AAN-DELISTED	Stock	9.53	10.005	9.31	9.89	439000.0
2023-04-06	AAOI	Stock	2.11	2.17	2.05	2.14	69500.0
2023-04-06	AAON	Stock	61.92	62.3133	60.7333	61.8333	391500.0
2023-04-06	AAP	Stock	120.08	121.0	119.77	120.69	1029800.0
2023-04-06	AAT	Stock	18.61	18.63	18.22	18.55	378900.0
2023-04-06	AATC	Stock	3.89	3.97	3.89	3.96	3815.0
2023-04-06	AAU-DELISTED	Stock	0.19	0.1946	0.19	0.1927	140738.0
2023-04-06	AAUAF-DELISTED	Stock	0.19	0.1946	0.19	0.19	141416.0
2023-04-06	AAXJ	Stock	67.28	67.9	67.15	67.78	367573.0
2023-04-06	AB	Stock	34.01	34.6	33.86	34.11	258900.0
2023-04-06	ABB-DELISTED	Stock	32.76	33.08	32.74	33.02	1277607.0
2023-04-06	ABBNY-DELISTED	Stock	32.77	33.08	32.74	33.02	1408578.0
2023-04-06	ABBV	Stock	160.8	162.19	160.62	161.55	5498300.0
2023-04-06	ABC-DELISTED	Stock	168.0	168.82	165.89	166.35	587939.0
2023-04-06	ABCB	Stock	33.78	34.53	33.69	34.4	392000.0
2023-04-06	ABCL	Stock	7.14	7.34	7.1	7.24	1274200.0
2023-04-06	ABCM-DELISTED	Stock	12.64	12.895	12.48	12.82	483331.0
2023-04-06	ABEO	Stock	2.76	2.84	2.71	2.81	68500.0
2023-04-06	ABEV	Stock	2.85	2.87	2.8	2.84	19583500.0
2023-04-06	ABG	Stock	194.85	197.57	192.98	193.54	160000.0
2023-04-06	ABM	Stock	43.51	43.84	43.14	43.84	285400.0
2023-04-06	ABNB	Stock	113.34	113.415	107.66	109.69	14400100.0
2023-04-06	ABOS	Stock	3.86	3.97	3.7	3.77	193000.0
2023-04-06	ABR	Stock	11.27	11.31	10.9	10.95	3868700.0
2023-04-06	ABR.D	Stock	17.9651	18.1616	17.7475	18.16	10800.0
2023-04-06	ABR.E	Stock	17.49	17.7	17.08	17.65	9422.0
2023-04-06	ABR.F	Stock	17.84	17.9299	17.79	17.85	19725.0
2023-04-06	ABSI	Stock	1.66	1.77	1.6	1.73	268800.0
2023-04-06	ABST-DELISTED	Stock	8.09	8.32	7.89	8.29	82687.0

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

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