PREVIEW / stock_daily / 2022-08-15

all stock daily files

  file:    by_date/stock_daily/2022/2022-08-15.parquet
  size:    254 KB
  rows:    7,907
  symbols: 2,257

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
2022-08-15	AAPL	Stock	171.52	173.39	171.35	173.19	54091700.0
2022-08-15	MSFT	Stock	291.0	294.18	290.11	293.47	18085700.0
2022-08-15	NVDA	Stock	18.701	19.164	18.613	19.032	457666000.0
2022-08-15	AMZN	Stock	142.8	143.76	141.49	143.18	39014600.0
2022-08-15	GOOGL	Stock	121.13	122.3	120.61	122.08	19494825.0
2022-08-15	META	Stock	178.96	181.44	178.2	180.89	15878700.0
2022-08-15	TSLA	Stock	301.7867	313.1333	301.23	309.32	89359200.0
2022-08-15	TLT	Stock	116.33	116.745	115.45	115.45	9031814.0
2022-08-15	ES	Stock	93.2	93.49	92.63	93.31	1500900.0
2022-08-15	CL	Stock	80.5	81.34	80.33	81.24	4257600.0
2022-08-15	A	Stock	133.28	134.62	132.67	133.9	1291100.0
2022-08-15	AA	Stock	50.59	52.18	49.93	51.7	4225000.0
2022-08-15	AAC-DELISTED	Stock	9.88	9.89	9.88	9.885	787359.0
2022-08-15	AACG	Stock	1.9	1.95	1.61	1.94	88700.0
2022-08-15	AAIC-DELISTED	Stock	3.39	3.43	3.39	3.43	17490.0
2022-08-15	AAIC.C-DELISTED	Stock	21.07	21.25	21.07	21.2	5245.0
2022-08-15	AAL	Stock	15.27	15.55	15.25	15.33	18364000.0
2022-08-15	AAM.A-DELISTED	Stock	25.4171	25.43	25.32	25.3905	2401.0
2022-08-15	AAM.B-DELISTED	Stock	25.41	25.53	25.41	25.45	5874.0
2022-08-15	AAMC-DELISTED	Stock	6.1676	6.2706	5.8059	5.8088	49463.0
2022-08-15	AAME	Stock	3.1	3.11	3.0	3.1	16400.0
2022-08-15	AAMI	Stock	19.8	20.26	19.8	20.12	204200.0
2022-08-15	AAN-DELISTED	Stock	14.69	14.71	14.391	14.5	297800.0
2022-08-15	AAOI	Stock	2.59	3.03	2.5	2.86	1026700.0
2022-08-15	AAON	Stock	40.7133	42.42	39.8667	42.24	252450.0
2022-08-15	AAP	Stock	201.93	205.43	201.03	205.33	532000.0
2022-08-15	AAT	Stock	30.58	30.81	30.3	30.65	169800.0
2022-08-15	AATC	Stock	4.9499	5.1	4.92	5.07	28862.0
2022-08-15	AAU-DELISTED	Stock	0.249	0.2499	0.24	0.2471	137706.0
2022-08-15	AAUAF-DELISTED	Stock	0.249	0.2499	0.24	0.2422	147013.0
2022-08-15	AAWW-DELISTED	Stock	100.05	100.28	99.7	99.77	1160013.0
2022-08-15	AAXJ	Stock	68.75	69.04	68.61	68.87	327703.0
2022-08-15	AB	Stock	45.16	45.34	44.75	44.79	150500.0
2022-08-15	ABB-DELISTED	Stock	30.52	30.645	30.3867	30.59	869581.0
2022-08-15	ABBNY-DELISTED	Stock	30.52	30.645	30.3867	30.59	1016630.0
2022-08-15	ABBV	Stock	143.11	143.28	140.42	142.29	4513200.0
2022-08-15	ABC-DELISTED	Stock	149.69	151.48	148.25	150.83	622218.0
2022-08-15	ABCB	Stock	49.23	49.9	49.12	49.86	200100.0
2022-08-15	ABCL	Stock	13.7	14.08	13.48	13.54	1647500.0
2022-08-15	ABCM-DELISTED	Stock	15.44	15.69	15.34	15.63	224394.0
2022-08-15	ABEO	Stock	4.5	4.73	4.26	4.65	135400.0
2022-08-15	ABEV	Stock	2.94	3.0	2.92	3.0	34620000.0
2022-08-15	ABG	Stock	184.66	186.34	182.54	186.03	179400.0
2022-08-15	ABGI-DELISTED	Stock	9.87	9.87	9.87	9.87	100.0
2022-08-15	ABM	Stock	46.61	47.77	46.36	47.72	195200.0
2022-08-15	ABMD-DELISTED	Stock	294.65	296.72	291.75	294.81	50274.0
2022-08-15	ABNB	Stock	123.55	126.435	123.2	126.04	4884700.0
2022-08-15	ABOS	Stock	5.41	5.51	5.31	5.41	19200.0
2022-08-15	ABR	Stock	15.7	15.77	15.56	15.69	1316100.0
2022-08-15	ABR.D	Stock	21.19	21.79	21.19	21.75	22564.0

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

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