PREVIEW / stock_daily / 2023-01-31

all stock daily files

  file:    by_date/stock_daily/2023/2023-01-31.parquet
  size:    250 KB
  rows:    7,732
  symbols: 1,910

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-31	AAPL	Stock	142.7	144.34	142.28	144.29	65874500.0
2023-01-31	MSFT	Stock	243.45	247.95	242.95	247.81	26541100.0
2023-01-31	NVDA	Stock	19.17	19.687	18.95	19.537	498017000.0
2023-01-31	AMZN	Stock	101.16	103.35	101.14	103.13	66527300.0
2023-01-31	GOOGL	Stock	96.87	98.88	96.82	98.84	29870669.0
2023-01-31	META	Stock	147.95	149.88	147.52	148.97	29842100.0
2023-01-31	TSLA	Stock	164.57	174.3	162.78	173.22	196813500.0
2023-01-31	TLT	Stock	106.98	107.28	105.87	107.17	13705345.0
2023-01-31	ES	Stock	81.66	82.34	80.52	82.33	1947600.0
2023-01-31	CL	Stock	73.38	74.54	73.26	74.53	5890100.0
2023-01-31	A	Stock	151.61	153.46	150.21	152.08	1995400.0
2023-01-31	AA	Stock	49.9	52.3	49.53	52.24	4638800.0
2023-01-31	AAC-DELISTED	Stock	10.16	10.18	10.1513	10.17	1840227.0
2023-01-31	AACG	Stock	1.48	1.48	1.43	1.44	21600.0
2023-01-31	AACIW-DELISTED	Stock	0.12	0.12	0.0996	0.0996	7001.0
2023-01-31	AAIC-DELISTED	Stock	3.02	3.05	2.9973	3.01	173295.0
2023-01-31	AAIC.C-DELISTED	Stock	22.57	22.58	22.57	22.58	604.0
2023-01-31	AAL	Stock	16.01	16.24	15.91	16.14	19866900.0
2023-01-31	AAM.A-DELISTED	Stock	24.89	25.19	24.72	25.14	35213.0
2023-01-31	AAM.B-DELISTED	Stock	24.25	25.48	24.25	25.25	38931.0
2023-01-31	AAMC-DELISTED	Stock	10.4412	11.2781	10.4412	11.2	36938.0
2023-01-31	AAME	Stock	2.59	2.59	2.51	2.51	2200.0
2023-01-31	AAMI	Stock	22.87	23.5	22.67	23.45	264000.0
2023-01-31	AAN-DELISTED	Stock	14.26	14.71	14.26	14.65	187200.0
2023-01-31	AAOI	Stock	2.33	2.44	2.33	2.39	72200.0
2023-01-31	AAON	Stock	49.3333	51.12	49.3333	50.88	372300.0
2023-01-31	AAP	Stock	151.18	152.85	150.24	152.28	1841600.0
2023-01-31	AAT	Stock	27.88	28.55	27.78	28.46	490300.0
2023-01-31	AATC	Stock	4.18	4.18	4.1375	4.1375	1077.0
2023-01-31	AAU-DELISTED	Stock	0.2382	0.2382	0.2331	0.2338	97706.0
2023-01-31	AAUAF-DELISTED	Stock	0.2382	0.2382	0.2331	0.2338	98751.0
2023-01-31	AAWW-DELISTED	Stock	102.25	102.265	102.12	102.21	442271.0
2023-01-31	AAXJ	Stock	70.67	70.92	70.4035	70.9	592923.0
2023-01-31	AB	Stock	37.54	38.0	37.22	37.91	150100.0
2023-01-31	ABB-DELISTED	Stock	34.56	34.85	34.26	34.85	1023969.0
2023-01-31	ABBNY-DELISTED	Stock	34.56	34.85	34.26	34.85	1137020.0
2023-01-31	ABBV	Stock	145.63	147.85	144.41	147.75	5628700.0
2023-01-31	ABC-DELISTED	Stock	167.17	169.165	165.88	168.9	1592802.0
2023-01-31	ABCB	Stock	45.87	47.38	45.86	47.16	503400.0
2023-01-31	ABCL	Stock	10.42	10.69	10.36	10.53	1307800.0
2023-01-31	ABCM-DELISTED	Stock	13.96	13.96	13.15	13.87	1313657.0
2023-01-31	ABEO	Stock	2.51	2.57	2.5	2.52	195300.0
2023-01-31	ABEV	Stock	2.65	2.69	2.64	2.66	26509700.0
2023-01-31	ABG	Stock	215.47	223.29	215.47	220.0	396000.0
2023-01-31	ABGI-DELISTED	Stock	10.15	10.15	10.15	10.15	1001.0
2023-01-31	ABLV	Stock	10.26	10.26	10.23	10.23	400.0
2023-01-31	ABM	Stock	45.65	46.92	45.65	46.91	562700.0
2023-01-31	ABNB	Stock	109.48	111.23	108.82	111.11	3867200.0
2023-01-31	ABOS	Stock	5.385	6.663	5.385	6.57	364900.0
2023-01-31	ABR	Stock	14.7	15.01	14.7	14.93	1837300.0

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

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