PREVIEW / stock_daily / 2023-10-11

all stock daily files

  file:    by_date/stock_daily/2023/2023-10-11.parquet
  size:    235 KB
  rows:    7,391
  symbols: 1,378

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-11	AAPL	Stock	178.2	179.85	177.6	179.8	47551100.0
2023-10-11	MSFT	Stock	331.21	332.82	329.14	332.42	20063200.0
2023-10-11	NVDA	Stock	46.196	46.859	46.05	46.806	378137000.0
2023-10-11	AMZN	Stock	129.74	132.05	129.61	131.83	40741800.0
2023-10-11	GOOGL	Stock	138.58	141.11	138.58	140.55	25884303.0
2023-10-11	META	Stock	323.01	328.84	322.95	327.82	22036300.0
2023-10-11	TSLA	Stock	266.2	268.6	260.9	262.99	103706300.0
2023-10-11	TLT	Stock	87.85	88.47	87.6	88.47	58517653.0
2023-10-11	ES	Stock	58.65	59.03	57.92	58.97	2269200.0
2023-10-11	CL	Stock	69.61	70.04	68.55	68.87	3310200.0
2023-10-11	A	Stock	113.41	113.6	112.05	113.38	1381500.0
2023-10-11	AA	Stock	28.29	28.4	27.6	28.04	3749800.0
2023-10-11	AAC-DELISTED	Stock	10.76	10.78	10.76	10.77	380759.0
2023-10-11	AACG	Stock	1.1	1.1	1.1	1.1	2700.0
2023-10-11	AACT	Stock	10.28	10.28	10.28	10.28	40700.0
2023-10-11	AAIC-DELISTED	Stock	4.42	4.49	4.4	4.48	76331.0
2023-10-11	AAIC.C-DELISTED	Stock	23.88	24.0	23.86	24.0	8190.0
2023-10-11	AAL	Stock	12.32	12.68	12.28	12.48	35569100.0
2023-10-11	AAMC-DELISTED	Stock	3.9588	4.0176	3.8412	3.8412	4760.0
2023-10-11	AAME	Stock	1.82	1.82	1.82	1.82	500.0
2023-10-11	AAMI	Stock	17.89	18.02	17.45	17.7	145800.0
2023-10-11	AAN-DELISTED	Stock	10.01	10.04	9.79	9.99	246200.0
2023-10-11	AAOI	Stock	7.5	7.97	7.5	7.79	1413900.0
2023-10-11	AAON	Stock	58.82	59.53	58.67	59.06	289000.0
2023-10-11	AAP	Stock	52.27	52.59	50.92	51.26	1489100.0
2023-10-11	AAT	Stock	18.62	18.87	18.5	18.84	287800.0
2023-10-11	AATC	Stock	5.52	5.59	5.51	5.565	14170.0
2023-10-11	AAU-DELISTED	Stock	0.13	0.1363	0.13	0.1319	122123.0
2023-10-11	AAUAF-DELISTED	Stock	0.13	0.1363	0.13	0.1319	115221.0
2023-10-11	AAXJ	Stock	64.69	64.865	64.455	64.68	584065.0
2023-10-11	AB	Stock	30.49	30.71	30.02	30.54	229900.0
2023-10-11	ABAT	Stock	7.97	8.0	6.8	6.88	621768.0
2023-10-11	ABBNY-DELISTED	Stock	36.8	37.18	36.78	37.17	496798.0
2023-10-11	ABBV	Stock	149.13	150.4	148.77	149.34	3189800.0
2023-10-11	ABCB	Stock	38.99	39.76	38.91	39.33	274000.0
2023-10-11	ABCL	Stock	4.5	4.548	4.32	4.39	1077900.0
2023-10-11	ABCM-DELISTED	Stock	22.84	22.99	22.8	22.84	3665441.0
2023-10-11	ABEO	Stock	4.13	4.35	4.1	4.26	74400.0
2023-10-11	ABEV	Stock	2.61	2.61	2.57	2.6	7103800.0
2023-10-11	ABG	Stock	221.51	223.08	216.74	218.07	124200.0
2023-10-11	ABLLW	Stock	0.3401	0.39	0.3401	0.3501	33221.0
2023-10-11	ABLV	Stock	3.58	3.58	3.4	3.4	7600.0
2023-10-11	ABM	Stock	42.97	43.89	42.88	43.86	384600.0
2023-10-11	ABNB	Stock	132.12	132.69	128.52	130.0	3456500.0
2023-10-11	ABOS	Stock	4.36	4.47	4.08	4.16	763400.0
2023-10-11	ABR	Stock	14.59	14.81	14.56	14.63	3412800.0
2023-10-11	ABR.D	Stock	17.4	17.69	17.34	17.34	22144.0
2023-10-11	ABR.E	Stock	17.47	17.815	17.3	17.3	3111.0
2023-10-11	ABR.F	Stock	18.34	18.5699	18.13	18.35	49658.0
2023-10-11	ABSI	Stock	1.35	1.41	1.305	1.36	234600.0

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

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