PREVIEW / stock_daily / 2023-07-28

all stock daily files

  file:    by_date/stock_daily/2023/2023-07-28.parquet
  size:    241 KB
  rows:    7,475
  symbols: 1,525

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-28	AAPL	Stock	194.67	196.63	194.14	195.83	48291400.0
2023-07-28	MSFT	Stock	333.67	340.01	333.17	338.37	28484900.0
2023-07-28	NVDA	Stock	46.668	47.027	46.381	46.75	331194000.0
2023-07-28	AMZN	Stock	129.69	133.01	129.33	132.21	46317400.0
2023-07-28	GOOGL	Stock	130.78	133.74	130.57	132.58	36591158.0
2023-07-28	META	Stock	316.88	326.2	314.25	325.48	39220300.0
2023-07-28	TSLA	Stock	259.86	267.25	258.23	266.44	111446000.0
2023-07-28	TLT	Stock	99.4	99.86	99.15	99.81	27433966.0
2023-07-28	ES	Stock	72.69	73.01	71.61	72.1	2103600.0
2023-07-28	CL	Stock	75.2	75.74	73.75	75.62	10891400.0
2023-07-28	A	Stock	127.25	127.51	123.16	126.05	3138800.0
2023-07-28	AA	Stock	34.35	34.79	33.79	34.76	4171300.0
2023-07-28	AAC-DELISTED	Stock	10.59	10.61	10.59	10.6	226866.0
2023-07-28	AACG	Stock	1.39	1.41	1.32	1.37	5900.0
2023-07-28	AACT	Stock	10.19	10.19	10.17	10.18	83500.0
2023-07-28	AAIC-DELISTED	Stock	4.7	4.7275	4.63	4.655	374801.0
2023-07-28	AAIC.C-DELISTED	Stock	23.59	23.59	23.59	23.59	2000.0
2023-07-28	AAL	Stock	16.79	16.86	16.59	16.79	18588400.0
2023-07-28	AAM.A-DELISTED	Stock	23.207	23.76	23.207	23.6294	4923.0
2023-07-28	AAM.B-DELISTED	Stock	23.43	24.05	23.4001	23.85	16612.0
2023-07-28	AAMC-DELISTED	Stock	22.3529	29.0471	22.3529	27.9706	131750.0
2023-07-28	AAME	Stock	1.86	1.9	1.83	1.83	9400.0
2023-07-28	AAMI	Stock	21.78	22.19	21.5	21.56	169400.0
2023-07-28	AAN-DELISTED	Stock	15.47	15.65	15.325	15.43	202800.0
2023-07-28	AAOI	Stock	6.35	6.95	6.25	6.71	2304800.0
2023-07-28	AAON	Stock	67.3067	68.8	67.2	68.68	341100.0
2023-07-28	AAP	Stock	73.73	74.2	72.97	73.17	1691500.0
2023-07-28	AAT	Stock	22.48	22.54	22.25	22.4	236800.0
2023-07-28	AATC	Stock	4.59	4.79	4.59	4.73	13569.0
2023-07-28	AAU-DELISTED	Stock	0.15	0.155	0.15	0.154	206688.0
2023-07-28	AAUAF-DELISTED	Stock	0.15	0.155	0.15	0.154	209132.0
2023-07-28	AAXJ	Stock	70.26	70.51	70.03	70.48	452346.0
2023-07-28	AB	Stock	33.08	33.15	32.25	32.54	480000.0
2023-07-28	ABBNY-DELISTED	Stock	40.07	40.17	39.925	39.96	105462.0
2023-07-28	ABBV	Stock	149.92	151.76	148.56	150.85	8000300.0
2023-07-28	ABC-DELISTED	Stock	188.02	188.02	185.88	186.59	793705.0
2023-07-28	ABCB	Stock	40.48	42.62	40.21	42.47	596400.0
2023-07-28	ABCL	Stock	7.56	7.8	7.56	7.69	1185200.0
2023-07-28	ABCM-DELISTED	Stock	23.43	23.54	22.62	23.495	1157668.0
2023-07-28	ABEO	Stock	3.4	3.6	3.26	3.53	338800.0
2023-07-28	ABEV	Stock	3.1	3.14	3.09	3.13	7882800.0
2023-07-28	ABG	Stock	224.28	224.28	216.22	219.99	145100.0
2023-07-28	ABLLW	Stock	0.2876	0.29	0.25	0.2895	16698.0
2023-07-28	ABLV	Stock	11.0	11.0	10.2855	10.67	80973.0
2023-07-28	ABM	Stock	45.11	45.74	45.04	45.18	556800.0
2023-07-28	ABNB	Stock	150.23	154.49	150.21	153.33	4162300.0
2023-07-28	ABOS	Stock	7.2	7.37	6.85	7.33	740200.0
2023-07-28	ABR	Stock	16.8	17.74	16.58	17.62	10584700.0
2023-07-28	ABR.D	Stock	19.0	19.2	18.9	19.18	36594.0
2023-07-28	ABR.E	Stock	18.99	19.95	18.99	19.33	5216.0

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

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