PREVIEW / stock_daily / 2023-11-14

all stock daily files

  file:    by_date/stock_daily/2023/2023-11-14.parquet
  size:    235 KB
  rows:    7,377
  symbols: 1,308

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-11-14	AAPL	Stock	187.7	188.11	186.3	187.44	60108400.0
2023-11-14	MSFT	Stock	371.01	371.95	367.35	370.27	27683900.0
2023-11-14	NVDA	Stock	49.68	49.834	49.04	49.656	416954000.0
2023-11-14	AMZN	Stock	145.0	147.26	144.68	145.8	56674600.0
2023-11-14	GOOGL	Stock	134.19	135.7	133.32	133.62	32395178.0
2023-11-14	META	Stock	334.54	338.1	333.33	336.31	17179400.0
2023-11-14	TSLA	Stock	235.03	238.14	230.72	237.41	149771600.0
2023-11-14	TLT	Stock	90.0	90.15	89.29	89.78	65666823.0
2023-11-14	ES	Stock	54.59	56.38	54.24	56.23	2972900.0
2023-11-14	CL	Stock	75.8	76.85	75.71	76.66	2919900.0
2023-11-14	A	Stock	109.55	112.29	109.46	111.61	2009700.0
2023-11-14	AA	Stock	25.44	26.565	25.36	26.17	5472100.0
2023-11-14	AACG	Stock	0.89	0.95	0.89	0.89	5700.0
2023-11-14	AACIU	Stock	10.81	10.81	10.81	10.81	117.0
2023-11-14	AACIW-DELISTED	Stock	0.035	0.0491	0.035	0.0491	300.0
2023-11-14	AACT	Stock	10.34	10.34	10.33	10.33	41700.0
2023-11-14	AAIC-DELISTED	Stock	4.55	4.7	4.518	4.67	198140.0
2023-11-14	AAIC.C-DELISTED	Stock	24.0994	24.1	23.91	23.91	2849.0
2023-11-14	AAL	Stock	12.15	12.3	12.04	12.25	35529800.0
2023-11-14	AAMC-DELISTED	Stock	3.19	3.225	3.1	3.1	15100.0
2023-11-14	AAME	Stock	1.72	1.78	1.7	1.71	5600.0
2023-11-14	AAMI	Stock	16.63	17.2	16.55	17.2	217700.0
2023-11-14	AAN-DELISTED	Stock	7.78	8.5	7.78	8.45	746900.0
2023-11-14	AAOI	Stock	11.23	12.55	10.88	12.28	5085000.0
2023-11-14	AAON	Stock	60.0	64.33	59.71	64.06	573700.0
2023-11-14	AAP	Stock	58.0	60.51	57.45	58.4	2665000.0
2023-11-14	AAT	Stock	19.38	20.35	19.38	19.98	347500.0
2023-11-14	AATC	Stock	6.41	6.47	6.35	6.43	21184.0
2023-11-14	AAU-DELISTED	Stock	0.1351	0.1409	0.135	0.14	168371.0
2023-11-14	AAUAF-DELISTED	Stock	0.1351	0.1409	0.135	0.14	167373.0
2023-11-14	AAXJ	Stock	64.84	65.62	64.84	65.51	820384.0
2023-11-14	AB	Stock	26.3	27.46	26.18	27.39	826800.0
2023-11-14	ABAT	Stock	4.25	4.37	3.88	4.37	266490.0
2023-11-14	ABBNY-DELISTED	Stock	37.05	37.61	37.05	37.51	156692.0
2023-11-14	ABBV	Stock	138.93	140.1	137.96	138.06	4509200.0
2023-11-14	ABCB	Stock	41.62	43.67	41.62	43.0	386900.0
2023-11-14	ABCL	Stock	4.17	4.365	4.15	4.33	1319500.0
2023-11-14	ABCM-DELISTED	Stock	23.13	23.25	23.09	23.22	2422690.0
2023-11-14	ABEO	Stock	4.73	4.75	4.14	4.25	129200.0
2023-11-14	ABEV	Stock	2.8	2.83	2.79	2.8	6123500.0
2023-11-14	ABG	Stock	210.84	221.32	210.84	218.58	133100.0
2023-11-14	ABLLW	Stock	0.3499	0.35	0.29	0.3291	124071.0
2023-11-14	ABLV	Stock	1.75	1.76	1.7	1.75	31200.0
2023-11-14	ABLVW	Stock	0.0152	0.0154	0.0152	0.0154	1580.0
2023-11-14	ABM	Stock	40.72	41.71	40.72	41.62	620500.0
2023-11-14	ABNB	Stock	122.355	127.12	121.51	126.68	8405200.0
2023-11-14	ABOS	Stock	2.1	2.17	2.005	2.13	637400.0
2023-11-14	ABR	Stock	13.47	13.8	13.3	13.7	4506400.0
2023-11-14	ABR.D	Stock	16.8	16.995	16.6731	16.79	30620.0
2023-11-14	ABR.E	Stock	16.59	16.73	16.42	16.71	14723.0

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

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