PREVIEW / stock_daily / 2023-10-17

all stock daily files

  file:    by_date/stock_daily/2023/2023-10-17.parquet
  size:    234 KB
  rows:    7,345
  symbols: 1,337

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-10-17	AAPL	Stock	176.65	178.42	174.8	177.15	57549400.0
2023-10-17	MSFT	Stock	329.59	333.46	327.41	332.06	18338500.0
2023-10-17	NVDA	Stock	44.0	44.754	42.48	43.938	812333000.0
2023-10-17	AMZN	Stock	130.39	132.58	128.71	131.47	49344600.0
2023-10-17	GOOGL	Stock	138.63	139.9	137.18	139.72	23515780.0
2023-10-17	META	Stock	318.18	324.4	317.3	324.0	16387800.0
2023-10-17	TSLA	Stock	250.1	257.18	247.08	254.85	93562900.0
2023-10-17	TLT	Stock	84.89	85.6299	84.5045	85.25	52949096.0
2023-10-17	ES	Stock	55.56	56.54	55.24	55.46	2103500.0
2023-10-17	CL	Stock	72.06	72.29	71.22	72.08	10084500.0
2023-10-17	A	Stock	110.1	112.91	109.21	112.4	1682800.0
2023-10-17	AA	Stock	26.3	28.37	26.27	27.77	6025200.0
2023-10-17	AAC-DELISTED	Stock	10.78	10.78	10.76	10.76	28857.0
2023-10-17	AACG	Stock	1.1	1.13	1.02	1.08	2300.0
2023-10-17	AACT	Stock	10.29	10.3	10.29	10.3	8900.0
2023-10-17	AAIC-DELISTED	Stock	4.45	4.495	4.44	4.45	57721.0
2023-10-17	AAIC.C-DELISTED	Stock	23.9	24.0	23.9	23.9806	1270.0
2023-10-17	AAL	Stock	11.88	12.1	11.88	11.94	35207300.0
2023-10-17	AAMC-DELISTED	Stock	3.8941	4.0529	3.8941	3.9529	10710.0
2023-10-17	AAME	Stock	1.8	1.81	1.73	1.73	2000.0
2023-10-17	AAMI	Stock	17.7	18.122	17.7	17.85	123600.0
2023-10-17	AAN-DELISTED	Stock	9.88	10.1	9.88	10.0	405900.0
2023-10-17	AAOI	Stock	7.48	7.929	7.46	7.59	1181100.0
2023-10-17	AAON	Stock	57.08	58.59	57.08	57.32	392200.0
2023-10-17	AAP	Stock	53.17	55.24	53.01	54.68	1663500.0
2023-10-17	AAT	Stock	18.56	19.25	18.56	19.05	267300.0
2023-10-17	AATC	Stock	5.47	5.7	5.43	5.7	6388.0
2023-10-17	AAU-DELISTED	Stock	0.132	0.14	0.132	0.1352	100024.0
2023-10-17	AAUAF-DELISTED	Stock	0.132	0.14	0.132	0.1352	100263.0
2023-10-17	AAXJ	Stock	63.48	64.06	63.47	63.82	497117.0
2023-10-17	AB	Stock	29.58	29.99	29.47	29.92	144300.0
2023-10-17	ABAT	Stock	7.75	7.75	7.03	7.1	167503.0
2023-10-17	ABBNY-DELISTED	Stock	35.88	36.92	35.85	36.46	339313.0
2023-10-17	ABBV	Stock	147.33	149.66	147.15	149.18	5372400.0
2023-10-17	ABCB	Stock	38.21	39.56	38.21	38.75	639900.0
2023-10-17	ABCL	Stock	4.23	4.419	4.22	4.4	1300200.0
2023-10-17	ABCM-DELISTED	Stock	22.82	22.91	22.72	22.88	3414473.0
2023-10-17	ABEO	Stock	4.25	4.43	4.22	4.34	72400.0
2023-10-17	ABEV	Stock	2.52	2.57	2.51	2.52	8776200.0
2023-10-17	ABG	Stock	215.0	222.08	215.0	216.49	113900.0
2023-10-17	ABLLW	Stock	0.303	0.3399	0.28	0.3395	14202.0
2023-10-17	ABLV	Stock	3.09	3.09	2.88	2.88	11500.0
2023-10-17	ABLVW	Stock	0.0256	0.0256	0.0256	0.0256	241.0
2023-10-17	ABM	Stock	43.62	43.98	42.98	43.2	361200.0
2023-10-17	ABNB	Stock	123.76	126.78	122.66	125.71	3073600.0
2023-10-17	ABOS	Stock	3.75	3.9	3.74	3.84	410900.0
2023-10-17	ABR	Stock	14.48	14.76	14.47	14.58	1921500.0
2023-10-17	ABR.D	Stock	16.95	17.25	16.69	16.69	18997.0
2023-10-17	ABR.E	Stock	16.78	16.92	16.55	16.74	4617.0
2023-10-17	ABR.F	Stock	17.98	17.98	17.65	17.82	37177.0

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

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