PREVIEW / stock_daily / 2023-02-27

all stock daily files

  file:    by_date/stock_daily/2023/2023-02-27.parquet
  size:    246 KB
  rows:    7,639
  symbols: 1,825

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-02-27	AAPL	Stock	147.71	149.17	147.45	147.92	44998500.0
2023-02-27	MSFT	Stock	252.46	252.82	249.39	250.16	21190000.0
2023-02-27	NVDA	Stock	23.67	23.88	23.454	23.501	452994000.0
2023-02-27	AMZN	Stock	94.28	94.78	93.14	93.76	47470300.0
2023-02-27	GOOGL	Stock	89.87	90.16	89.335	89.87	27502302.0
2023-02-27	META	Stock	171.88	173.12	169.06	169.54	19277000.0
2023-02-27	TSLA	Stock	202.03	209.42	201.26	207.63	161028300.0
2023-02-27	TLT	Stock	101.29	101.7	100.91	101.25	14209183.0
2023-02-27	ES	Stock	77.76	78.47	76.72	77.09	1161300.0
2023-02-27	CL	Stock	73.42	74.14	73.22	73.6	3434600.0
2023-02-27	A	Stock	142.88	143.76	141.81	142.18	1149600.0
2023-02-27	AA	Stock	46.85	48.435	46.37	48.04	4931200.0
2023-02-27	AAC-DELISTED	Stock	10.23	10.23	10.22	10.23	30133.0
2023-02-27	AACG	Stock	1.9	1.91	1.83	1.89	24600.0
2023-02-27	AACIW-DELISTED	Stock	0.1149	0.1149	0.0795	0.1	11800.0
2023-02-27	AAIC-DELISTED	Stock	3.04	3.06	3.02	3.05	105849.0
2023-02-27	AAIC.C-DELISTED	Stock	23.4	23.4	23.4	23.4	200.0
2023-02-27	AAL	Stock	15.74	15.83	15.55	15.63	15494300.0
2023-02-27	AAM.A-DELISTED	Stock	24.72	24.7899	24.3306	24.6665	10156.0
2023-02-27	AAM.B-DELISTED	Stock	24.97	24.97	24.37	24.74	5131.0
2023-02-27	AAMC-DELISTED	Stock	12.6471	16.2206	12.6471	15.2941	204581.0
2023-02-27	AAME	Stock	2.51	2.53	2.44	2.53	2000.0
2023-02-27	AAMI	Stock	25.05	25.15	24.67	24.82	52800.0
2023-02-27	AAN-DELISTED	Stock	14.33	14.5	14.13	14.28	224400.0
2023-02-27	AAOI	Stock	2.7	2.7	2.54	2.59	186000.0
2023-02-27	AAON	Stock	54.3133	55.3867	53.62	54.3267	653700.0
2023-02-27	AAP	Stock	139.14	141.29	138.44	140.63	2467500.0
2023-02-27	AAT	Stock	25.71	25.88	25.33	25.45	196300.0
2023-02-27	AATC	Stock	4.2	4.3	4.2	4.3	1771.0
2023-02-27	AAU-DELISTED	Stock	0.21	0.2147	0.2066	0.2147	343300.0
2023-02-27	AAUAF-DELISTED	Stock	0.21	0.2147	0.2066	0.2147	346112.0
2023-02-27	AAWW-DELISTED	Stock	101.85	101.85	101.3	101.32	619356.0
2023-02-27	AAXJ	Stock	66.01	66.085	65.82	65.92	296656.0
2023-02-27	AB	Stock	39.5	39.73	38.18	38.67	369500.0
2023-02-27	ABB-DELISTED	Stock	33.51	33.6504	33.44	33.5	876640.0
2023-02-27	ABBNY-DELISTED	Stock	33.51	33.6504	33.44	33.5	997798.0
2023-02-27	ABBV	Stock	153.26	154.75	153.1	154.28	6828800.0
2023-02-27	ABC-DELISTED	Stock	158.86	159.3299	155.59	156.56	727270.0
2023-02-27	ABCB	Stock	48.47	48.79	47.87	48.1	232100.0
2023-02-27	ABCL	Stock	8.558	8.59	8.345	8.43	1533200.0
2023-02-27	ABCM-DELISTED	Stock	14.34	14.395	14.23	14.36	271952.0
2023-02-27	ABEO	Stock	2.31	2.34	2.23	2.29	98700.0
2023-02-27	ABEV	Stock	2.56	2.58	2.54	2.57	13393600.0
2023-02-27	ABG	Stock	224.03	227.11	223.64	227.0	192900.0
2023-02-27	ABGI-DELISTED	Stock	10.18	10.19	10.18	10.19	2039.0
2023-02-27	ABLV	Stock	10.29	10.3	10.285	10.3	13685.0
2023-02-27	ABM	Stock	49.31	49.58	48.9	49.04	232900.0
2023-02-27	ABNB	Stock	123.95	125.06	122.73	123.53	5011400.0
2023-02-27	ABOS	Stock	5.25	5.476	5.24	5.24	58900.0
2023-02-27	ABR	Stock	15.42	15.51	15.03	15.13	2703700.0

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

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