PREVIEW / stock_daily / 2023-02-28

all stock daily files

  file:    by_date/stock_daily/2023/2023-02-28.parquet
  size:    246 KB
  rows:    7,610
  symbols: 1,785

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-28	AAPL	Stock	147.05	149.08	146.83	147.41	50547000.0
2023-02-28	MSFT	Stock	249.07	251.49	248.73	249.42	22491000.0
2023-02-28	NVDA	Stock	23.372	23.825	23.206	23.216	455963000.0
2023-02-28	AMZN	Stock	93.14	94.69	92.92	94.23	43959300.0
2023-02-28	GOOGL	Stock	89.33	91.23	89.32	90.06	30142039.0
2023-02-28	META	Stock	171.9	177.55	171.87	174.94	46051100.0
2023-02-28	TSLA	Stock	210.59	211.23	203.75	205.71	153144900.0
2023-02-28	TLT	Stock	100.57	101.72	100.28	101.71	14955716.0
2023-02-28	ES	Stock	76.72	77.17	75.31	75.36	2715500.0
2023-02-28	CL	Stock	73.29	73.65	72.87	73.3	3614300.0
2023-02-28	A	Stock	141.75	143.38	141.39	141.97	2342500.0
2023-02-28	AA	Stock	48.25	50.04	47.8	48.94	3871400.0
2023-02-28	AAC-DELISTED	Stock	10.23	10.23	10.22	10.23	17116.0
2023-02-28	AACG	Stock	1.87	1.9	1.84	1.9	8700.0
2023-02-28	AACIW-DELISTED	Stock	0.1097	0.1098	0.1097	0.1098	210.0
2023-02-28	AAIC-DELISTED	Stock	3.05	3.0601	3.02	3.05	41480.0
2023-02-28	AAIC.C-DELISTED	Stock	22.89	22.9213	22.51	22.51	800.0
2023-02-28	AAL	Stock	15.55	16.05	15.53	15.98	15597800.0
2023-02-28	AAM.A-DELISTED	Stock	24.4	24.76	24.2001	24.63	37166.0
2023-02-28	AAM.B-DELISTED	Stock	24.2	24.63	23.935	24.355	38870.0
2023-02-28	AAMC-DELISTED	Stock	15.5882	15.6529	14.2941	15.2971	45540.0
2023-02-28	AAME	Stock	2.51	2.52	2.44	2.5	1500.0
2023-02-28	AAMI	Stock	24.73	25.18	24.45	25.07	209900.0
2023-02-28	AAN-DELISTED	Stock	14.26	14.685	14.26	14.35	219900.0
2023-02-28	AAOI	Stock	2.56	2.85	2.56	2.81	177300.0
2023-02-28	AAON	Stock	58.0	62.9333	56.6667	60.64	1987800.0
2023-02-28	AAP	Stock	145.0	149.17	144.09	144.96	2934300.0
2023-02-28	AAT	Stock	25.43	25.72	25.21	25.23	313100.0
2023-02-28	AATC	Stock	4.3	4.3	4.3	4.3	434.0
2023-02-28	AAU-DELISTED	Stock	0.2149	0.2149	0.203	0.2041	337615.0
2023-02-28	AAUAF-DELISTED	Stock	0.2149	0.2149	0.203	0.2032	344882.0
2023-02-28	AAWW-DELISTED	Stock	101.57	101.57	100.79	100.83	774603.0
2023-02-28	AAXJ	Stock	65.68	65.86	65.4	65.47	406960.0
2023-02-28	AB	Stock	38.49	39.39	38.39	38.84	255200.0
2023-02-28	ABB-DELISTED	Stock	33.39	33.57	33.3	33.3	877984.0
2023-02-28	ABBNY-DELISTED	Stock	33.39	33.57	33.3	33.3	1037509.0
2023-02-28	ABBV	Stock	153.96	154.37	152.62	153.9	7561700.0
2023-02-28	ABC-DELISTED	Stock	156.0	156.62	154.76	155.49	1368298.0
2023-02-28	ABCB	Stock	48.09	48.51	47.87	47.87	318300.0
2023-02-28	ABCL	Stock	8.49	8.63	8.4	8.4	1535800.0
2023-02-28	ABCM-DELISTED	Stock	14.26	14.49	14.2	14.4	578736.0
2023-02-28	ABEO	Stock	2.28	2.37	2.25	2.29	133100.0
2023-02-28	ABEV	Stock	2.57	2.59	2.54	2.55	34164600.0
2023-02-28	ABG	Stock	227.19	230.87	226.48	227.1	225700.0
2023-02-28	ABLV	Stock	10.31	10.31	10.3	10.31	10702.0
2023-02-28	ABM	Stock	49.0	49.5	48.37	48.41	567000.0
2023-02-28	ABNB	Stock	125.11	126.384	123.03	123.28	7317100.0
2023-02-28	ABOS	Stock	5.25	5.39	5.18	5.27	32200.0
2023-02-28	ABR	Stock	15.15	15.32	15.03	15.08	4120100.0
2023-02-28	ABR.D	Stock	19.9573	19.99	19.5	19.76	21601.0

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

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