PREVIEW / stock_daily / 2023-07-05

all stock daily files

  file:    by_date/stock_daily/2023/2023-07-05.parquet
  size:    239 KB
  rows:    7,463
  symbols: 1,553

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-07-05	AAPL	Stock	191.57	192.98	190.62	191.33	46920300.0
2023-07-05	MSFT	Stock	335.09	341.65	334.73	338.15	18172400.0
2023-07-05	NVDA	Stock	42.135	43.177	42.085	42.317	323618000.0
2023-07-05	AMZN	Stock	130.24	131.4	129.64	130.38	35895400.0
2023-07-05	GOOGL	Stock	119.24	122.61	119.23	121.75	27584809.0
2023-07-05	META	Stock	287.65	298.12	286.36	294.37	33865500.0
2023-07-05	TSLA	Stock	278.82	283.85	277.6	282.48	131530900.0
2023-07-05	TLT	Stock	101.89	102.0	100.74	101.11	28170286.0
2023-07-05	ES	Stock	70.63	72.63	70.5	71.64	2925200.0
2023-07-05	CL	Stock	77.3	77.44	76.66	76.87	4796400.0
2023-07-05	A	Stock	118.95	120.28	118.61	119.5	1246200.0
2023-07-05	AA	Stock	33.91	34.443	33.52	33.68	4490700.0
2023-07-05	AAC-DELISTED	Stock	10.56	10.57	10.5557	10.565	127110.0
2023-07-05	AACG	Stock	1.5	1.5	1.38	1.41	5500.0
2023-07-05	AACIW-DELISTED	Stock	0.0912	0.0912	0.036	0.07675	5966.0
2023-07-05	AACT	Stock	10.15	10.17	10.15	10.17	2300.0
2023-07-05	AAIC-DELISTED	Stock	4.48	4.53	4.46	4.46	137348.0
2023-07-05	AAIC.C-DELISTED	Stock	22.4	23.1	22.4	22.8	4470.0
2023-07-05	AAL	Stock	17.98	18.42	17.89	18.32	19351500.0
2023-07-05	AAM.A-DELISTED	Stock	23.41	23.43	22.84	23.3199	7863.0
2023-07-05	AAM.B-DELISTED	Stock	22.93	23.06	22.57	23.05	5822.0
2023-07-05	AAMC-DELISTED	Stock	30.0059	35.5	29.5588	34.2588	59500.0
2023-07-05	AAME	Stock	1.96	2.0	1.96	2.0	2900.0
2023-07-05	AAMI	Stock	20.84	20.955	20.46	20.73	248400.0
2023-07-05	AAN-DELISTED	Stock	14.35	14.54	13.56	14.23	365300.0
2023-07-05	AAOI	Stock	6.05	7.31	6.0	7.03	5343100.0
2023-07-05	AAON	Stock	63.5867	63.5867	61.7867	62.2267	367050.0
2023-07-05	AAP	Stock	70.94	71.29	69.3	71.16	2212100.0
2023-07-05	AAT	Stock	19.53	19.83	19.22	19.52	393700.0
2023-07-05	AATC	Stock	4.41	4.47	4.41	4.4395	14203.0
2023-07-05	AAU-DELISTED	Stock	0.128	0.1292	0.126	0.1289	185881.0
2023-07-05	AAUAF-DELISTED	Stock	0.128	0.1292	0.126	0.1289	185645.0
2023-07-05	AAXJ	Stock	66.83	66.905	66.64	66.7	847823.0
2023-07-05	AB	Stock	32.22	32.63	32.0	32.0	277500.0
2023-07-05	ABBNY-DELISTED	Stock	38.07	38.17	38.0	38.02	125973.0
2023-07-05	ABBV	Stock	135.18	137.88	134.64	137.62	6903300.0
2023-07-05	ABC-DELISTED	Stock	191.39	191.81	189.95	190.65	697951.0
2023-07-05	ABCB	Stock	34.68	34.97	34.12	34.24	257500.0
2023-07-05	ABCL	Stock	6.59	6.72	6.405	6.52	2440500.0
2023-07-05	ABCM-DELISTED	Stock	24.2	24.305	23.72	23.99	1484245.0
2023-07-05	ABEO	Stock	4.29	4.45	4.27	4.35	152500.0
2023-07-05	ABEV	Stock	3.1	3.13	3.08	3.13	6981600.0
2023-07-05	ABG	Stock	238.69	242.61	237.71	241.65	177700.0
2023-07-05	ABLLW	Stock	0.25	0.3696	0.2402	0.2788	213477.0
2023-07-05	ABLV	Stock	10.62	10.62	10.62	10.62	19719.0
2023-07-05	ABM	Stock	41.86	42.64	41.74	42.11	662100.0
2023-07-05	ABNB	Stock	131.845	132.95	130.535	131.69	3429900.0
2023-07-05	ABOS	Stock	5.13	5.31	4.912	5.21	196300.0
2023-07-05	ABR	Stock	15.0	15.09	14.87	15.05	4071100.0
2023-07-05	ABR.D	Stock	18.55	18.6	18.28	18.42	16934.0

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

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