PREVIEW / stock_daily / 2023-09-20

all stock daily files

  file:    by_date/stock_daily/2023/2023-09-20.parquet
  size:    238 KB
  rows:    7,444
  symbols: 1,434

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-09-20	AAPL	Stock	179.26	179.7	175.4	175.49	58436200.0
2023-09-20	MSFT	Stock	329.51	329.59	320.51	320.77	21436500.0
2023-09-20	NVDA	Stock	43.6	43.903	42.223	42.239	367108000.0
2023-09-20	AMZN	Stock	138.55	139.37	135.2	135.29	46263700.0
2023-09-20	GOOGL	Stock	138.08	138.08	133.62	133.74	29927475.0
2023-09-20	META	Stock	305.05	308.06	299.43	299.67	19379500.0
2023-09-20	TSLA	Stock	267.04	273.93	262.46	262.59	122514600.0
2023-09-20	TLT	Stock	93.29	93.6	93.04	93.09	29451164.0
2023-09-20	ES	Stock	64.15	64.37	63.45	63.96	2228600.0
2023-09-20	CL	Stock	73.47	73.95	73.03	73.76	4212100.0
2023-09-20	A	Stock	113.08	113.47	112.17	112.47	1744900.0
2023-09-20	AA	Stock	28.65	29.79	28.55	29.38	8084100.0
2023-09-20	AAC-DELISTED	Stock	10.73	10.74	10.72	10.74	28907.0
2023-09-20	AACG	Stock	1.15	1.17	1.15	1.16	2600.0
2023-09-20	AACIW-DELISTED	Stock	0.0834	0.09	0.08085	0.08387	3100.0
2023-09-20	AACT	Stock	10.269	10.269	10.269	10.269	2300.0
2023-09-20	AAIC-DELISTED	Stock	4.62	4.64	4.49	4.5	88743.0
2023-09-20	AAIC.C-DELISTED	Stock	24.59	24.59	24.0594	24.0594	250.0
2023-09-20	AAL	Stock	13.32	13.47	13.05	13.06	27822800.0
2023-09-20	AAM.A-DELISTED	Stock	25.01	25.02	25.01	25.02	8116.0
2023-09-20	AAM.B-DELISTED	Stock	25.02	25.04	25.01	25.04	2510.0
2023-09-20	AAMC-DELISTED	Stock	3.9588	4.4824	3.9412	4.1882	105400.0
2023-09-20	AAME	Stock	1.88	2.04	1.88	1.96	3200.0
2023-09-20	AAMI	Stock	20.385	20.67	20.13	20.22	101500.0
2023-09-20	AAN-DELISTED	Stock	9.91	10.17	9.89	10.0	615500.0
2023-09-20	AAOI	Stock	9.66	10.23	9.6	9.84	1847800.0
2023-09-20	AAON	Stock	62.2	63.07	61.1	61.22	303500.0
2023-09-20	AAP	Stock	60.11	61.36	59.54	60.12	1897400.0
2023-09-20	AAT	Stock	20.76	20.96	20.32	20.32	188900.0
2023-09-20	AATC	Stock	6.08	6.14	6.05	6.12	7745.0
2023-09-20	AAU-DELISTED	Stock	0.1307	0.1307	0.126	0.1261	66722.0
2023-09-20	AAUAF-DELISTED	Stock	0.1307	0.1307	0.126	0.1261	71831.0
2023-09-20	AAXJ	Stock	64.98	65.29	64.62	64.62	480107.0
2023-09-20	AB	Stock	32.27	32.51	32.0	32.0	202200.0
2023-09-20	ABBNY-DELISTED	Stock	36.66	36.86	36.46	36.46	139465.0
2023-09-20	ABBV	Stock	154.06	154.88	153.37	153.61	2744800.0
2023-09-20	ABCB	Stock	38.96	39.2	38.14	38.16	261400.0
2023-09-20	ABCL	Stock	5.15	5.295	5.06	5.08	2793400.0
2023-09-20	ABCM-DELISTED	Stock	22.65	22.81	22.6	22.68	4675624.0
2023-09-20	ABEO	Stock	3.82	3.96	3.75	3.8	72800.0
2023-09-20	ABEV	Stock	2.75	2.77	2.73	2.73	7632100.0
2023-09-20	ABG	Stock	225.73	228.51	225.73	226.55	162500.0
2023-09-20	ABLLW	Stock	0.3231	0.4	0.3231	0.4	10312.0
2023-09-20	ABLV	Stock	3.47	3.6	3.349	3.51	24700.0
2023-09-20	ABM	Stock	40.99	41.19	40.53	40.53	596600.0
2023-09-20	ABNB	Stock	142.76	143.27	137.95	138.01	5189000.0
2023-09-20	ABOS	Stock	5.13	5.13	4.91	4.91	206300.0
2023-09-20	ABR	Stock	15.82	15.89	15.47	15.48	2067700.0
2023-09-20	ABR.D	Stock	18.56	18.8	18.56	18.6	7715.0
2023-09-20	ABR.E	Stock	18.81	18.81	18.6	18.6	967.0

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

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