PREVIEW / stock_daily / 2022-08-26

all stock daily files

  file:    by_date/stock_daily/2022/2022-08-26.parquet
  size:    252 KB
  rows:    7,844
  symbols: 2,227

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-26	AAPL	Stock	170.57	171.05	163.56	163.62	78961000.0
2022-08-26	MSFT	Stock	279.08	280.34	267.98	268.09	27549300.0
2022-08-26	NVDA	Stock	17.857	17.924	16.237	16.26	769127000.0
2022-08-26	AMZN	Stock	136.55	137.83	130.5	130.75	53322700.0
2022-08-26	GOOGL	Stock	114.72	115.12	110.19	110.34	37245697.0
2022-08-26	META	Stock	168.48	170.92	161.67	161.78	24023600.0
2022-08-26	TSLA	Stock	297.43	302.0	287.47	288.09	57163900.0
2022-08-26	TLT	Stock	112.3	113.99	112.01	113.62	18764391.0
2022-08-26	ES	Stock	92.86	92.97	91.5	91.6	1089500.0
2022-08-26	CL	Stock	80.87	81.2	79.07	79.21	3407600.0
2022-08-26	A	Stock	136.0	136.05	129.78	129.87	1252700.0
2022-08-26	AA	Stock	57.67	58.235	55.2	55.84	5506800.0
2022-08-26	AAC-DELISTED	Stock	9.89	9.91	9.89	9.91	102916.0
2022-08-26	AACG	Stock	2.52	2.57	2.43	2.47	33400.0
2022-08-26	AACIU	Stock	9.87	9.91	9.87	9.91	230.0
2022-08-26	AAIC-DELISTED	Stock	3.38	3.38	3.28	3.29	45762.0
2022-08-26	AAIC.C-DELISTED	Stock	21.4001	22.32	21.4001	21.4001	400.0
2022-08-26	AAL	Stock	14.41	14.54	13.71	13.74	23177500.0
2022-08-26	AAM.A-DELISTED	Stock	25.17	25.4528	25.17	25.2	3168.0
2022-08-26	AAM.B-DELISTED	Stock	26.43	26.43	25.55	25.8	26662.0
2022-08-26	AAMC-DELISTED	Stock	5.8088	6.3059	5.801	5.9265	16813.0
2022-08-26	AAME	Stock	3.08	3.09	2.96	3.07	9000.0
2022-08-26	AAMI	Stock	19.07	19.07	18.085	18.23	186600.0
2022-08-26	AAN-DELISTED	Stock	13.83	13.96	12.68	12.8	232500.0
2022-08-26	AAOI	Stock	2.81	2.81	2.55	2.56	211100.0
2022-08-26	AAON	Stock	40.5933	40.5933	39.0133	39.3333	175800.0
2022-08-26	AAP	Stock	181.27	181.42	173.57	173.59	867200.0
2022-08-26	AAQC-DELISTED	Stock	9.81	9.82	9.81	9.81	19700.0
2022-08-26	AAT	Stock	29.12	29.12	28.46	28.53	262300.0
2022-08-26	AATC	Stock	5.15	5.35	5.1333	5.29	45810.0
2022-08-26	AAU-DELISTED	Stock	0.2301	0.2351	0.226	0.231	266971.0
2022-08-26	AAUAF-DELISTED	Stock	0.2301	0.2351	0.226	0.231	279078.0
2022-08-26	AAWW-DELISTED	Stock	99.92	100.08	99.8	99.84	900658.0
2022-08-26	AAXJ	Stock	69.01	69.11	67.44	67.44	646409.0
2022-08-26	AB	Stock	44.8	44.97	43.47	43.8	247600.0
2022-08-26	ABB-DELISTED	Stock	29.06	29.06	28.15	28.17	1789415.0
2022-08-26	ABBNY-DELISTED	Stock	29.06	29.06	28.15	28.17	1953426.0
2022-08-26	ABBV	Stock	138.89	139.85	136.25	136.35	3838800.0
2022-08-26	ABC-DELISTED	Stock	150.46	150.9699	146.03	146.2	390655.0
2022-08-26	ABCB	Stock	49.44	49.87	48.1	48.26	200800.0
2022-08-26	ABCL	Stock	12.15	12.17	11.1	11.26	1813400.0
2022-08-26	ABCM-DELISTED	Stock	15.55	15.58	15.15	15.25	181219.0
2022-08-26	ABEO	Stock	4.48	4.48	4.05	4.08	71500.0
2022-08-26	ABEV	Stock	3.07	3.08	3.01	3.03	30971500.0
2022-08-26	ABG	Stock	190.9	191.94	183.63	184.28	113500.0
2022-08-26	ABGI-DELISTED	Stock	9.87	9.87	9.87	9.87	200.0
2022-08-26	ABM	Stock	48.48	48.53	46.98	47.05	184100.0
2022-08-26	ABMD-DELISTED	Stock	274.72	274.99	257.65	258.15	148411.0
2022-08-26	ABNB	Stock	117.06	118.27	112.78	112.82	3778700.0
2022-08-26	ABOS	Stock	5.673	5.815	5.265	5.49	25000.0

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

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