PREVIEW / stock_daily / 2023-01-23

all stock daily files

  file:    by_date/stock_daily/2023/2023-01-23.parquet
  size:    251 KB
  rows:    7,790
  symbols: 1,949

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-01-23	AAPL	Stock	138.12	143.32	137.9	141.11	81760300.0
2023-01-23	MSFT	Stock	241.1	245.17	239.65	242.58	31934000.0
2023-01-23	NVDA	Stock	18.064	19.245	17.818	19.193	655163000.0
2023-01-23	AMZN	Stock	97.56	97.78	95.86	97.52	76501100.0
2023-01-23	GOOGL	Stock	97.95	100.04	97.5	99.79	40005055.0
2023-01-23	META	Stock	139.29	143.76	138.66	143.27	27470100.0
2023-01-23	TSLA	Stock	135.87	145.38	134.27	143.75	203119200.0
2023-01-23	TLT	Stock	105.57	106.2	105.49	105.7	12961516.0
2023-01-23	ES	Stock	79.67	80.66	79.34	79.89	1602500.0
2023-01-23	CL	Stock	75.54	75.67	74.94	75.5	2463400.0
2023-01-23	A	Stock	156.0	159.59	155.67	159.06	974900.0
2023-01-23	AA	Stock	51.27	52.0	50.42	51.75	4311400.0
2023-01-23	AAC-DELISTED	Stock	10.13	10.13	10.12	10.12	62801.0
2023-01-23	AACG	Stock	1.37	1.44	1.37	1.44	12000.0
2023-01-23	AACIW-DELISTED	Stock	0.06	0.12	0.06	0.09	14263.0
2023-01-23	AAIC-DELISTED	Stock	3.03	3.08	3.02	3.06	227863.0
2023-01-23	AAIC.C-DELISTED	Stock	22.02	22.02	21.8943	21.8943	200.0
2023-01-23	AAL	Stock	16.39	16.44	16.16	16.17	23408500.0
2023-01-23	AAM.A-DELISTED	Stock	24.56	24.7	24.56	24.69	8352.0
2023-01-23	AAM.B-DELISTED	Stock	24.19	24.7565	24.1393	24.34	10973.0
2023-01-23	AAMC-DELISTED	Stock	8.6324	8.8235	8.6324	8.8235	8687.0
2023-01-23	AAME	Stock	2.39	2.56	2.38	2.56	7700.0
2023-01-23	AAMI	Stock	22.82	23.09	22.67	23.09	111600.0
2023-01-23	AAN-DELISTED	Stock	14.22	14.45	14.18	14.43	182800.0
2023-01-23	AAOI	Stock	2.23	2.3	2.18	2.24	121500.0
2023-01-23	AAON	Stock	48.7933	49.66	48.36	49.36	356100.0
2023-01-23	AAP	Stock	148.3	149.39	146.85	148.62	807300.0
2023-01-23	AAT	Stock	27.16	27.42	27.01	27.17	339600.0
2023-01-23	AATC	Stock	4.05	4.17	4.01	4.075	21951.0
2023-01-23	AAU-DELISTED	Stock	0.24	0.2448	0.233	0.2388	236745.0
2023-01-23	AAUAF-DELISTED	Stock	0.24	0.2448	0.233	0.2388	238889.0
2023-01-23	AAWW-DELISTED	Stock	102.06	102.27	101.94	102.06	249634.0
2023-01-23	AAXJ	Stock	71.94	72.66	71.82	72.38	882442.0
2023-01-23	AB	Stock	37.59	38.36	37.45	38.08	192800.0
2023-01-23	ABB-DELISTED	Stock	33.8	34.275	33.765	34.18	1196695.0
2023-01-23	ABBNY-DELISTED	Stock	33.82	34.275	33.765	34.17	1343259.0
2023-01-23	ABBV	Stock	149.86	150.43	148.05	148.55	7616400.0
2023-01-23	ABC-DELISTED	Stock	162.7	163.56	161.48	161.73	753663.0
2023-01-23	ABCB	Stock	48.24	48.86	47.88	48.29	218800.0
2023-01-23	ABCL	Stock	10.31	10.41	10.17	10.28	947500.0
2023-01-23	ABCM-DELISTED	Stock	16.41	17.43	16.1859	17.1	521124.0
2023-01-23	ABEO	Stock	2.57	2.61	2.56	2.58	90500.0
2023-01-23	ABEV	Stock	2.56	2.61	2.55	2.57	29984500.0
2023-01-23	ABG	Stock	190.99	192.24	188.77	191.84	94700.0
2023-01-23	ABM	Stock	44.89	45.52	44.39	44.81	294900.0
2023-01-23	ABNB	Stock	101.99	105.38	101.35	105.22	4442700.0
2023-01-23	ABOS	Stock	5.8	6.08	5.66	5.83	52500.0
2023-01-23	ABR	Stock	14.3	14.48	14.29	14.4	1159800.0
2023-01-23	ABR.D	Stock	20.0499	20.3	19.7601	20.01	14535.0
2023-01-23	ABR.E	Stock	19.7	20.22	19.7	20.05	20197.0

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

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