PREVIEW / stock_daily / 2023-02-17

all stock daily files

  file:    by_date/stock_daily/2023/2023-02-17.parquet
  size:    246 KB
  rows:    7,617
  symbols: 1,817

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-17	AAPL	Stock	152.35	153.0	150.85	152.55	59144100.0
2023-02-17	MSFT	Stock	259.39	260.09	256.0	258.06	30000100.0
2023-02-17	NVDA	Stock	21.631	21.74	20.975	21.388	465888000.0
2023-02-17	AMZN	Stock	97.8	97.94	95.65	97.2	60029400.0
2023-02-17	GOOGL	Stock	94.85	95.5599	93.21	94.35	34284118.0
2023-02-17	META	Stock	170.22	173.18	169.7	172.88	24171300.0
2023-02-17	TSLA	Stock	199.99	208.44	197.5	208.31	213738500.0
2023-02-17	TLT	Stock	101.1	102.38	100.965	102.38	19560871.0
2023-02-17	ES	Stock	78.95	80.57	78.49	80.27	1710100.0
2023-02-17	CL	Stock	72.96	74.96	72.96	74.52	5019100.0
2023-02-17	A	Stock	147.26	148.94	146.49	148.26	1194800.0
2023-02-17	AA	Stock	48.175	48.19	46.32	46.89	5550600.0
2023-02-17	AAC-DELISTED	Stock	10.21	10.22	10.21	10.21	532737.0
2023-02-17	AACG	Stock	2.18	2.32	2.04	2.15	172800.0
2023-02-17	AACIW-DELISTED	Stock	0.1045	0.1045	0.0903	0.1	1205.0
2023-02-17	AAIC-DELISTED	Stock	2.99	3.02	2.99	3.01	28526.0
2023-02-17	AAIC.C-DELISTED	Stock	22.8	23.93	22.56	23.74	5746.0
2023-02-17	AAL	Stock	16.38	16.56	16.15	16.36	21921300.0
2023-02-17	AAM.A-DELISTED	Stock	24.7201	24.8	24.64	24.75	3317.0
2023-02-17	AAM.B-DELISTED	Stock	24.58	24.75	24.44	24.75	5802.0
2023-02-17	AAMC-DELISTED	Stock	11.5559	12.3088	11.5559	11.9441	33599.0
2023-02-17	AAME	Stock	2.44	2.55	2.28	2.47	22100.0
2023-02-17	AAMI	Stock	26.08	26.2	25.48	25.9	110500.0
2023-02-17	AAN-DELISTED	Stock	14.9	15.06	14.56	14.75	215500.0
2023-02-17	AAOI	Stock	2.97	3.012	2.793	2.8	207300.0
2023-02-17	AAON	Stock	52.58	53.9067	52.0	53.3333	404550.0
2023-02-17	AAP	Stock	150.66	151.3	147.87	149.99	1279600.0
2023-02-17	AAT	Stock	26.49	26.49	25.93	26.3	257100.0
2023-02-17	AATC	Stock	4.41	4.41	4.16	4.2	26081.0
2023-02-17	AAU-DELISTED	Stock	0.223	0.225	0.2192	0.225	406112.0
2023-02-17	AAUAF-DELISTED	Stock	0.223	0.225	0.2192	0.225	398651.0
2023-02-17	AAWW-DELISTED	Stock	102.19	102.19	101.89	102.0	246350.0
2023-02-17	AAXJ	Stock	67.94	68.03	67.635	67.97	909965.0
2023-02-17	AB	Stock	40.13	40.63	40.05	40.44	241800.0
2023-02-17	ABB-DELISTED	Stock	33.81	34.215	33.8	34.175	823885.0
2023-02-17	ABBNY-DELISTED	Stock	33.81	34.215	33.8	34.17	909735.0
2023-02-17	ABBV	Stock	149.15	151.39	148.61	151.31	4562400.0
2023-02-17	ABC-DELISTED	Stock	160.7	163.59	159.96	161.5	1477848.0
2023-02-17	ABCB	Stock	48.55	49.13	48.23	48.92	358400.0
2023-02-17	ABCL	Stock	9.45	9.66	9.261	9.59	2806800.0
2023-02-17	ABCM-DELISTED	Stock	14.48	14.61	14.26	14.41	429438.0
2023-02-17	ABEO	Stock	2.32	2.44	2.32	2.38	124400.0
2023-02-17	ABEV	Stock	2.49	2.54	2.48	2.52	11354400.0
2023-02-17	ABG	Stock	235.72	242.93	232.7	241.52	416800.0
2023-02-17	ABGI-DELISTED	Stock	10.16	10.16	10.16	10.16	49975.0
2023-02-17	ABLV	Stock	10.27	10.27	10.27	10.27	22367.0
2023-02-17	ABM	Stock	49.07	49.07	48.4	48.8	196600.0
2023-02-17	ABNB	Stock	137.435	138.4	130.73	131.6	11386700.0
2023-02-17	ABOS	Stock	5.52	5.969	5.46	5.51	33200.0
2023-02-17	ABR	Stock	15.21	15.63	14.91	15.54	3524200.0

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

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