PREVIEW / stock_daily / 2023-03-16

all stock daily files

  file:    by_date/stock_daily/2023/2023-03-16.parquet
  size:    245 KB
  rows:    7,589
  symbols: 1,737

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-03-16	AAPL	Stock	152.16	156.46	151.64	155.85	76161100.0
2023-03-16	MSFT	Stock	265.21	276.56	263.28	276.2	54768800.0
2023-03-16	NVDA	Stock	24.027	25.588	23.894	25.541	583253000.0
2023-03-16	AMZN	Stock	95.75	100.99	95.61	100.04	84446900.0
2023-03-16	GOOGL	Stock	96.2	101.19	95.5	100.32	65567656.0
2023-03-16	META	Stock	198.26	205.76	196.09	204.93	50447100.0
2023-03-16	TSLA	Stock	180.37	185.81	178.84	184.13	121136800.0
2023-03-16	TLT	Stock	107.38	108.03	105.04	105.27	43103531.0
2023-03-16	ES	Stock	76.52	77.88	76.26	76.8	2222100.0
2023-03-16	CL	Stock	73.31	73.45	72.62	72.95	4256400.0
2023-03-16	A	Stock	133.97	137.05	132.37	136.82	1789300.0
2023-03-16	AA	Stock	39.17	41.098	38.51	40.75	6519500.0
2023-03-16	AAC-DELISTED	Stock	10.27	10.2899	10.26	10.285	94567.0
2023-03-16	AACG	Stock	1.93	1.98	1.87	1.87	15800.0
2023-03-16	AAIC-DELISTED	Stock	2.74	2.8493	2.72	2.81	65473.0
2023-03-16	AAIC.C-DELISTED	Stock	21.75	21.75	21.7	21.7	2250.0
2023-03-16	AAL	Stock	13.7	14.23	13.63	14.12	24557900.0
2023-03-16	AAM.A-DELISTED	Stock	21.15	22.1525	21.15	21.75	12450.0
2023-03-16	AAM.B-DELISTED	Stock	21.26	22.279	21.26	22.02	17908.0
2023-03-16	AAMC-DELISTED	Stock	16.0794	16.0882	15.2486	15.3824	35234.0
2023-03-16	AAME	Stock	2.39	2.5	2.39	2.5	2600.0
2023-03-16	AAMI	Stock	22.19	23.12	22.12	22.75	137000.0
2023-03-16	AAN-DELISTED	Stock	10.0	10.34	9.78	10.05	327100.0
2023-03-16	AAOI	Stock	2.42	2.5	2.395	2.48	77400.0
2023-03-16	AAON	Stock	58.0333	61.66	57.7867	61.18	452850.0
2023-03-16	AAP	Stock	120.62	122.87	119.9	122.03	1911500.0
2023-03-16	AAT	Stock	18.67	19.02	17.92	18.62	1103000.0
2023-03-16	AATC	Stock	4.14	4.15	4.14	4.15	884.0
2023-03-16	AAU-DELISTED	Stock	0.1854	0.1996	0.1854	0.1933	135816.0
2023-03-16	AAUAF-DELISTED	Stock	0.1854	0.1996	0.1854	0.1933	137705.0
2023-03-16	AAWW-DELISTED	Stock	102.43	102.48	102.43	102.48	891853.0
2023-03-16	AAXJ	Stock	63.83	65.04	63.83	65.01	653129.0
2023-03-16	AB	Stock	35.78	35.88	35.05	35.31	382800.0
2023-03-16	ABB-DELISTED	Stock	31.59	32.5993	31.57	32.54	1510556.0
2023-03-16	ABBNY-DELISTED	Stock	31.59	32.5993	31.57	32.55	1756978.0
2023-03-16	ABBV	Stock	153.2	155.92	152.51	155.3	6331200.0
2023-03-16	ABC-DELISTED	Stock	149.29	152.525	149.07	152.07	698417.0
2023-03-16	ABCB	Stock	36.53	39.35	35.4	38.52	808200.0
2023-03-16	ABCL	Stock	7.35	7.52	7.215	7.48	1269000.0
2023-03-16	ABCM-DELISTED	Stock	13.85	14.38	13.76	14.26	649043.0
2023-03-16	ABEO	Stock	2.56	2.65	2.49	2.54	87500.0
2023-03-16	ABEV	Stock	2.67	2.72	2.66	2.71	13296500.0
2023-03-16	ABG	Stock	195.17	203.13	193.88	202.94	324400.0
2023-03-16	ABM	Stock	43.82	45.08	43.65	44.79	291000.0
2023-03-16	ABNB	Stock	113.95	120.06	113.51	119.99	7691900.0
2023-03-16	ABOS	Stock	4.1	4.155	3.78	4.01	197400.0
2023-03-16	ABR	Stock	11.6	11.8	11.37	11.5	4648800.0
2023-03-16	ABR.D	Stock	16.5	17.0	16.4701	16.515	55183.0
2023-03-16	ABR.E	Stock	16.43	16.43	16.1	16.1332	90803.0
2023-03-16	ABR.F	Stock	18.065	18.12	17.64	17.772	7441.0

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

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