PREVIEW / stock_daily / 2023-10-10

all stock daily files

  file:    by_date/stock_daily/2023/2023-10-10.parquet
  size:    236 KB
  rows:    7,380
  symbols: 1,377

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-10	AAPL	Stock	178.1	179.72	177.95	178.39	43698000.0
2023-10-10	MSFT	Stock	330.96	331.1	327.67	328.39	20557100.0
2023-10-10	NVDA	Stock	45.31	46.259	45.088	45.798	368582000.0
2023-10-10	AMZN	Stock	128.82	130.74	128.05	129.48	42178600.0
2023-10-10	GOOGL	Stock	138.5	139.72	137.33	138.06	27786613.0
2023-10-10	META	Stock	319.12	324.66	318.16	321.84	19038000.0
2023-10-10	TSLA	Stock	257.75	268.94	257.65	263.62	122656000.0
2023-10-10	TLT	Stock	85.85	87.17	85.52	86.66	54743911.0
2023-10-10	ES	Stock	57.51	58.55	57.47	58.28	3144400.0
2023-10-10	CL	Stock	69.59	70.06	69.27	69.49	4737800.0
2023-10-10	A	Stock	111.31	113.83	111.02	113.29	2183000.0
2023-10-10	AA	Stock	27.64	28.57	27.47	28.2	4850000.0
2023-10-10	AAC-DELISTED	Stock	10.77	10.78	10.75	10.77	78928.0
2023-10-10	AACG	Stock	1.1	1.14	1.1	1.1	6800.0
2023-10-10	AACT	Stock	10.27	10.27	10.27	10.27	100.0
2023-10-10	AAIC-DELISTED	Stock	4.38	4.4312	4.38	4.4	50232.0
2023-10-10	AAIC.C-DELISTED	Stock	23.88	23.88	23.85	23.85	300.0
2023-10-10	AAL	Stock	12.4	12.65	12.24	12.26	37144200.0
2023-10-10	AAMC-DELISTED	Stock	3.8882	4.1118	3.8824	4.0647	6800.0
2023-10-10	AAME	Stock	1.8	1.81	1.8	1.81	500.0
2023-10-10	AAMI	Stock	18.31	18.38	17.83	17.85	147700.0
2023-10-10	AAN-DELISTED	Stock	9.93	10.08	9.845	9.98	271000.0
2023-10-10	AAOI	Stock	7.71	7.99	7.425	7.46	2257600.0
2023-10-10	AAON	Stock	57.66	59.44	57.66	58.51	354100.0
2023-10-10	AAP	Stock	51.74	52.84	51.56	52.09	2137600.0
2023-10-10	AAT	Stock	18.36	18.66	18.3	18.45	219900.0
2023-10-10	AATC	Stock	5.61	6.0	5.585	5.7	35227.0
2023-10-10	AAU-DELISTED	Stock	0.13	0.1393	0.13	0.1302	89613.0
2023-10-10	AAUAF-DELISTED	Stock	0.13	0.1393	0.13	0.1302	95336.0
2023-10-10	AAXJ	Stock	63.81	64.345	63.67	64.25	344918.0
2023-10-10	AB	Stock	30.98	31.25	30.4	30.45	281800.0
2023-10-10	ABAT	Stock	6.87	7.19	6.7506	6.89	190931.0
2023-10-10	ABBNY-DELISTED	Stock	36.39	36.73	36.39	36.48	325382.0
2023-10-10	ABBV	Stock	149.39	149.56	148.04	148.89	3729000.0
2023-10-10	ABCB	Stock	39.49	40.99	39.03	39.11	301900.0
2023-10-10	ABCL	Stock	4.41	4.52	4.37	4.52	838800.0
2023-10-10	ABCM-DELISTED	Stock	22.73	22.85	22.73	22.85	3698588.0
2023-10-10	ABEO	Stock	4.21	4.32	4.0	4.12	183800.0
2023-10-10	ABEV	Stock	2.56	2.61	2.55	2.6	6020400.0
2023-10-10	ABG	Stock	217.52	222.84	217.52	221.52	97900.0
2023-10-10	ABLLW	Stock	0.375	0.395	0.375	0.375	2307.0
2023-10-10	ABLV	Stock	3.25	3.41	3.23	3.41	5200.0
2023-10-10	ABM	Stock	42.38	43.09	42.34	42.9	441500.0
2023-10-10	ABNB	Stock	127.69	132.78	126.95	131.59	5114700.0
2023-10-10	ABOS	Stock	4.17	4.43	4.12	4.31	683800.0
2023-10-10	ABR	Stock	14.28	14.53	14.07	14.47	3951700.0
2023-10-10	ABR.D	Stock	17.3	17.39	17.185	17.24	37874.0
2023-10-10	ABR.E	Stock	17.4	17.75	17.2	17.22	4680.0
2023-10-10	ABR.F	Stock	18.28	18.3	18.19	18.28	16540.0
2023-10-10	ABSI	Stock	1.32	1.445	1.32	1.38	266500.0

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

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