PREVIEW / stock_daily / 2023-11-27

all stock daily files

  file:    by_date/stock_daily/2023/2023-11-27.parquet
  size:    237 KB
  rows:    7,458
  symbols: 1,337

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-27	AAPL	Stock	189.92	190.67	188.9	189.79	40552600.0
2023-11-27	MSFT	Stock	376.78	380.64	376.2	378.61	22179200.0
2023-11-27	NVDA	Stock	47.8	48.53	47.652	48.242	395662000.0
2023-11-27	AMZN	Stock	147.53	149.26	146.88	147.73	53762400.0
2023-11-27	GOOGL	Stock	136.03	138.42	136.0	136.41	23436526.0
2023-11-27	META	Stock	336.18	339.9	334.2	334.7	15684500.0
2023-11-27	TSLA	Stock	236.89	238.33	232.1	236.08	112031800.0
2023-11-27	TLT	Stock	90.3	91.34	90.205	91.3	39804428.0
2023-11-27	ES	Stock	59.33	59.45	58.61	59.04	2353100.0
2023-11-27	CL	Stock	77.38	77.46	77.01	77.11	3706600.0
2023-11-27	A	Stock	125.98	126.68	124.89	125.01	2255400.0
2023-11-27	AA	Stock	26.22	26.596	25.87	26.3	3429000.0
2023-11-27	AACG	Stock	0.85	0.85	0.85	0.85	3700.0
2023-11-27	AACIW-DELISTED	Stock	0.044	0.044	0.0212	0.0284	10403.0
2023-11-27	AACT	Stock	10.35	10.39	10.35	10.36	140600.0
2023-11-27	AAIC-DELISTED	Stock	4.66	4.69	4.64	4.67	118122.0
2023-11-27	AAIC.C-DELISTED	Stock	24.15	24.21	24.15	24.15	1554.0
2023-11-27	AAL	Stock	12.25	12.31	12.08	12.18	27427600.0
2023-11-27	AAMC-DELISTED	Stock	2.89	3.14	2.89	3.09	18800.0
2023-11-27	AAME	Stock	1.88	2.03	1.88	1.88	5200.0
2023-11-27	AAMI	Stock	17.83	17.97	17.5	17.77	101100.0
2023-11-27	AAN-DELISTED	Stock	8.83	9.075	8.799	9.04	281500.0
2023-11-27	AAOI	Stock	12.87	14.579	12.85	14.4	3073300.0
2023-11-27	AAON	Stock	63.74	64.11	63.4	63.62	256100.0
2023-11-27	AAP	Stock	52.84	52.97	51.0	51.01	1872600.0
2023-11-27	AAT	Stock	18.7	19.18	18.44	19.01	534800.0
2023-11-27	AATC	Stock	6.47	6.5	6.31	6.31	4540.0
2023-11-27	AAU-DELISTED	Stock	0.14	0.1419	0.14	0.1401	142723.0
2023-11-27	AAUAF-DELISTED	Stock	0.14	0.1419	0.14	0.1401	144124.0
2023-11-27	AAXJ	Stock	65.27	65.45	65.19	65.38	392567.0
2023-11-27	AB	Stock	28.35	28.35	27.58	27.86	376400.0
2023-11-27	ABAT	Stock	4.28	4.28	4.06	4.13	249380.0
2023-11-27	ABBNY-DELISTED	Stock	38.27	38.57	38.26	38.45	107607.0
2023-11-27	ABBV	Stock	138.7	139.38	137.79	139.09	5529400.0
2023-11-27	ABCB	Stock	42.26	42.52	41.0	42.39	352200.0
2023-11-27	ABCL	Stock	4.4	4.55	4.27	4.53	1325200.0
2023-11-27	ABCM-DELISTED	Stock	23.94	23.95	23.93	23.95	1132216.0
2023-11-27	ABEO	Stock	4.6	5.38	4.51	4.81	1586000.0
2023-11-27	ABEV	Stock	2.74	2.78	2.72	2.76	9796200.0
2023-11-27	ABG	Stock	208.03	209.69	207.43	207.53	169100.0
2023-11-27	ABLLW	Stock	0.33	0.3999	0.33	0.38	433505.0
2023-11-27	ABLV	Stock	2.89	3.01	2.765	2.82	13800.0
2023-11-27	ABLVW	Stock	0.0987	0.0987	0.0987	0.0987	100.0
2023-11-27	ABM	Stock	41.15	41.23	40.71	40.74	406300.0
2023-11-27	ABNB	Stock	127.5	129.56	125.85	129.0	4408400.0
2023-11-27	ABOS	Stock	2.35	2.385	2.29	2.34	359000.0
2023-11-27	ABR	Stock	12.2	12.35	12.0	12.03	5885900.0
2023-11-27	ABR.D	Stock	16.6	16.7731	16.53	16.62	19701.0
2023-11-27	ABR.E	Stock	16.84	16.85	16.5001	16.81	3828.0
2023-11-27	ABR.F	Stock	18.5	18.6	18.35	18.6	32134.0

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

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