PREVIEW / stock_daily / 2023-11-13

all stock daily files

  file:    by_date/stock_daily/2023/2023-11-13.parquet
  size:    233 KB
  rows:    7,346
  symbols: 1,296

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-13	AAPL	Stock	185.82	186.03	184.21	184.8	43627500.0
2023-11-13	MSFT	Stock	368.22	368.47	365.9	366.68	19986500.0
2023-11-13	NVDA	Stock	48.32	49.116	48.099	48.62	384136000.0
2023-11-13	AMZN	Stock	142.08	143.23	140.67	142.59	35680600.0
2023-11-13	GOOGL	Stock	131.78	132.59	131.25	132.09	18324751.0
2023-11-13	META	Stock	326.2	332.33	325.7	329.19	16908900.0
2023-11-13	TSLA	Stock	215.6	225.4	211.61	223.71	140447600.0
2023-11-13	TLT	Stock	87.22	87.94	86.9	87.79	25661516.0
2023-11-13	ES	Stock	53.74	53.74	52.49	53.03	2981600.0
2023-11-13	CL	Stock	75.8	76.26	75.72	75.95	2805500.0
2023-11-13	A	Stock	108.13	108.27	106.96	107.46	1200300.0
2023-11-13	AA	Stock	24.49	25.025	24.3	24.6	2839700.0
2023-11-13	AACG	Stock	0.8	0.88	0.8	0.87	8400.0
2023-11-13	AACIU	Stock	11.02	11.02	11.02	11.02	102.0
2023-11-13	AACIW-DELISTED	Stock	0.04	0.05	0.04	0.047	26130.0
2023-11-13	AACT	Stock	10.32	10.33	10.32	10.33	26700.0
2023-11-13	AAIC-DELISTED	Stock	4.51	4.5399	4.48	4.49	39900.0
2023-11-13	AAIC.C-DELISTED	Stock	23.8501	23.8501	23.8501	23.8501	135.0
2023-11-13	AAL	Stock	11.7	11.89	11.62	11.78	20147700.0
2023-11-13	AAMC-DELISTED	Stock	3.4	3.4	3.12	3.2	15700.0
2023-11-13	AAME	Stock	1.53	1.6	1.49	1.58	11300.0
2023-11-13	AAMI	Stock	16.21	16.32	16.012	16.09	250800.0
2023-11-13	AAN-DELISTED	Stock	7.03	7.3	7.0	7.26	523500.0
2023-11-13	AAOI	Stock	8.96	11.06	8.96	11.0	2839900.0
2023-11-13	AAON	Stock	58.92	59.13	57.56	59.0	348500.0
2023-11-13	AAP	Stock	55.66	56.64	55.52	55.94	1716700.0
2023-11-13	AAT	Stock	18.25	18.5	18.0	18.48	243000.0
2023-11-13	AATC	Stock	6.31	6.46	6.31	6.46	8484.0
2023-11-13	AAU-DELISTED	Stock	0.135	0.1396	0.135	0.1363	63462.0
2023-11-13	AAUAF-DELISTED	Stock	0.135	0.1396	0.135	0.1363	65542.0
2023-11-13	AAXJ	Stock	63.71	64.25	63.68	64.0	350492.0
2023-11-13	AB	Stock	26.62	26.74	25.83	26.08	423400.0
2023-11-13	ABAT	Stock	4.22	4.243	3.868	4.06	305955.0
2023-11-13	ABBNY-DELISTED	Stock	35.86	36.2199	35.81	36.14	200696.0
2023-11-13	ABBV	Stock	138.59	139.16	137.43	138.64	4454700.0
2023-11-13	ABCB	Stock	39.11	39.99	38.83	39.81	234700.0
2023-11-13	ABCL	Stock	4.02	4.031	3.93	3.98	830100.0
2023-11-13	ABCM-DELISTED	Stock	23.1	23.15	23.05	23.08	2065227.0
2023-11-13	ABEO	Stock	4.15	4.5	3.87	4.5	102800.0
2023-11-13	ABEV	Stock	2.68	2.76	2.68	2.74	14582800.0
2023-11-13	ABG	Stock	199.84	204.41	199.8	203.7	77600.0
2023-11-13	ABLLW	Stock	0.3465	0.3499	0.3	0.3249	132849.0
2023-11-13	ABLV	Stock	1.68	1.76	1.671	1.7	18200.0
2023-11-13	ABM	Stock	39.7	39.87	39.43	39.76	332300.0
2023-11-13	ABNB	Stock	117.51	119.86	117.401	119.15	3408800.0
2023-11-13	ABOS	Stock	2.07	2.08	1.95	2.03	988100.0
2023-11-13	ABR	Stock	13.05	13.12	12.94	12.98	2082800.0
2023-11-13	ABR.D	Stock	16.7	16.8	16.46	16.57	21272.0
2023-11-13	ABR.E	Stock	16.4	16.55	16.3701	16.39	11954.0
2023-11-13	ABR.F	Stock	17.71	17.8882	17.7	17.75	6373.0

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

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