PREVIEW / stock_daily / 2023-02-08

all stock daily files

  file:    by_date/stock_daily/2023/2023-02-08.parquet
  size:    247 KB
  rows:    7,630
  symbols: 1,838

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-08	AAPL	Stock	153.88	154.58	151.17	151.92	64120100.0
2023-02-08	MSFT	Stock	273.2	276.76	266.21	266.73	54686000.0
2023-02-08	NVDA	Stock	22.387	22.878	22.008	22.205	559651000.0
2023-02-08	AMZN	Stock	102.04	102.67	98.78	100.05	75878300.0
2023-02-08	GOOGL	Stock	102.05	103.14	98.035	99.37	94743515.0
2023-02-08	META	Stock	190.0	190.83	182.92	183.43	36139100.0
2023-02-08	TSLA	Stock	196.1	203.0	194.31	201.29	180673600.0
2023-02-08	TLT	Stock	105.04	105.58	104.39	105.56	13530655.0
2023-02-08	ES	Stock	80.27	80.53	78.75	79.13	1152200.0
2023-02-08	CL	Stock	73.12	73.68	72.81	73.36	3230100.0
2023-02-08	A	Stock	153.64	155.17	153.23	154.42	1073500.0
2023-02-08	AA	Stock	52.18	52.68	50.61	50.62	4649500.0
2023-02-08	AAC-DELISTED	Stock	10.2	10.2	10.185	10.2	487524.0
2023-02-08	AACG	Stock	1.64	1.69	1.6	1.65	6900.0
2023-02-08	AACIW-DELISTED	Stock	0.137	0.137	0.0876	0.1148	75634.0
2023-02-08	AAIC-DELISTED	Stock	3.0	3.02	3.0	3.02	11754.0
2023-02-08	AAIC.C-DELISTED	Stock	22.2487	22.5	22.2	22.5	3125.0
2023-02-08	AAL	Stock	17.26	17.44	16.8	16.97	20774200.0
2023-02-08	AAM.A-DELISTED	Stock	24.534	24.9	24.43	24.66	6434.0
2023-02-08	AAM.B-DELISTED	Stock	25.0625	25.0625	24.45	24.95	6524.0
2023-02-08	AAMC-DELISTED	Stock	11.1176	11.2029	10.3531	10.4412	55291.0
2023-02-08	AAME	Stock	2.45	2.56	2.45	2.55	2600.0
2023-02-08	AAMI	Stock	25.66	26.21	25.655	25.81	144000.0
2023-02-08	AAN-DELISTED	Stock	15.03	15.18	14.93	15.05	176800.0
2023-02-08	AAOI	Stock	2.6	2.65	2.55	2.55	85700.0
2023-02-08	AAON	Stock	51.28	51.8733	50.98	51.3733	150600.0
2023-02-08	AAP	Stock	149.32	151.1	147.68	148.82	1026000.0
2023-02-08	AAT	Stock	27.9	27.9	26.7	27.06	428000.0
2023-02-08	AATC	Stock	4.3	4.45	4.26	4.375	4043.0
2023-02-08	AAU-DELISTED	Stock	0.2258	0.23	0.22	0.2203	163314.0
2023-02-08	AAUAF-DELISTED	Stock	0.2258	0.23	0.22	0.2203	165471.0
2023-02-08	AAWW-DELISTED	Stock	102.21	102.23	102.15	102.19	191676.0
2023-02-08	AAXJ	Stock	69.76	69.87	69.24	69.49	1006980.0
2023-02-08	AB	Stock	39.38	39.93	39.06	39.79	210300.0
2023-02-08	ABB-DELISTED	Stock	33.61	33.77	33.29	33.48	1418717.0
2023-02-08	ABBNY-DELISTED	Stock	33.61	33.77	33.29	33.49	1606676.0
2023-02-08	ABBV	Stock	145.41	146.35	144.47	144.61	5753800.0
2023-02-08	ABC-DELISTED	Stock	156.46	158.49	155.79	157.85	738363.0
2023-02-08	ABCB	Stock	49.34	49.68	49.04	49.21	232600.0
2023-02-08	ABCL	Stock	10.84	10.97	10.36	10.42	1293200.0
2023-02-08	ABCM-DELISTED	Stock	15.56	15.91	15.12	15.13	238781.0
2023-02-08	ABEO	Stock	2.62	2.73	2.62	2.68	61400.0
2023-02-08	ABEV	Stock	2.51	2.53	2.47	2.5	22706900.0
2023-02-08	ABG	Stock	233.78	237.06	231.99	232.32	175800.0
2023-02-08	ABM	Stock	46.95	47.49	46.87	47.09	215800.0
2023-02-08	ABNB	Stock	119.39	119.81	115.57	116.36	3605400.0
2023-02-08	ABOS	Stock	5.86	6.07	5.86	5.95	137300.0
2023-02-08	ABR	Stock	15.11	15.15	14.86	14.87	1950300.0
2023-02-08	ABR.D	Stock	20.7	20.75	20.61	20.75	7678.0
2023-02-08	ABR.E	Stock	21.15	21.4	20.89	21.0	34462.0

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

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