PREVIEW / stock_daily / 2022-06-27

all stock daily files

  file:    by_date/stock_daily/2022/2022-06-27.parquet
  size:    255 KB
  rows:    7,933
  symbols: 2,332

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-06-27	AAPL	Stock	142.7	143.49	140.97	141.66	70207900.0
2022-06-27	MSFT	Stock	268.21	268.3	263.28	264.89	24615100.0
2022-06-27	NVDA	Stock	17.312	17.33	16.626	16.869	427968000.0
2022-06-27	AMZN	Stock	117.09	117.98	112.7	113.22	62133200.0
2022-06-27	GOOGL	Stock	118.273	118.5795	115.1797	115.8335	36420760.0
2022-06-27	META	Stock	171.32	171.75	168.01	169.49	29174600.0
2022-06-27	TSLA	Stock	249.3667	252.07	242.5667	244.92	89178300.0
2022-06-27	TLT	Stock	111.22	112.22	111.16	111.6	12053040.0
2022-06-27	ES	Stock	82.99	84.11	82.65	84.09	1279600.0
2022-06-27	CL	Stock	79.56	80.34	79.36	79.88	4564600.0
2022-06-27	A	Stock	121.83	122.3	119.85	120.57	1805700.0
2022-06-27	AA	Stock	50.52	50.52	48.75	49.56	4211800.0
2022-06-27	AAC-DELISTED	Stock	9.82	9.845	9.82	9.84	188083.0
2022-06-27	AACG	Stock	1.08	1.09	1.08	1.09	1500.0
2022-06-27	AAIC-DELISTED	Stock	3.21	3.3	3.09	3.1	62041.0
2022-06-27	AAIC.C-DELISTED	Stock	22.6999	22.7	22.5	22.5	2172.0
2022-06-27	AAL	Stock	13.96	13.96	13.38	13.56	26086200.0
2022-06-27	AAM.A-DELISTED	Stock	24.19	24.2	23.72	23.97	27524.0
2022-06-27	AAM.B-DELISTED	Stock	25.23	25.37	24.88	25.11	17496.0
2022-06-27	AAMC-DELISTED	Stock	3.25	3.4412	3.1912	3.4088	19482.0
2022-06-27	AAME	Stock	2.69	2.89	2.69	2.8	8800.0
2022-06-27	AAMI	Stock	19.47	19.63	19.15	19.21	489300.0
2022-06-27	AAN-DELISTED	Stock	16.37	16.549	15.907	16.08	264000.0
2022-06-27	AAOI	Stock	1.86	1.885	1.7	1.77	556300.0
2022-06-27	AAON	Stock	35.7133	36.26	35.3267	35.9	189600.0
2022-06-27	AAP	Stock	184.18	186.0	182.13	183.63	529000.0
2022-06-27	AAQC-DELISTED	Stock	9.775	9.8	9.75	9.7501	3849.0
2022-06-27	AAT	Stock	30.51	30.68	30.09	30.3	141800.0
2022-06-27	AATC	Stock	5.33	5.4847	5.3	5.3	2349.0
2022-06-27	AAU-DELISTED	Stock	0.2351	0.264	0.23	0.237	1186781.0
2022-06-27	AAUAF-DELISTED	Stock	0.2351	0.264	0.23	0.237	1192150.0
2022-06-27	AAWW-DELISTED	Stock	64.54	65.895	64.1	65.32	199614.0
2022-06-27	AAXJ	Stock	70.45	70.64	69.93	70.02	1381914.0
2022-06-27	AB	Stock	43.28	43.3	42.37	42.73	226700.0
2022-06-27	ABB-DELISTED	Stock	27.06	27.24	26.865	27.11	1823535.0
2022-06-27	ABBNY-DELISTED	Stock	27.06	27.24	26.865	27.1	1996942.0
2022-06-27	ABBV	Stock	153.0	155.45	152.75	153.14	5377300.0
2022-06-27	ABC-DELISTED	Stock	148.31	149.72	147.81	149.27	830844.0
2022-06-27	ABCB	Stock	41.65	41.78	40.88	41.17	411400.0
2022-06-27	ABCL	Stock	10.68	10.69	10.025	10.27	3133300.0
2022-06-27	ABCM-DELISTED	Stock	14.89	15.21	14.745	15.0	110905.0
2022-06-27	ABEO	Stock	4.25	4.75	4.25	4.5	56620.0
2022-06-27	ABEV	Stock	2.58	2.62	2.57	2.59	29885500.0
2022-06-27	ABG	Stock	180.68	180.68	175.13	178.36	166300.0
2022-06-27	ABGI-DELISTED	Stock	9.82	9.82	9.82	9.82	100.0
2022-06-27	ABM	Stock	44.38	44.73	43.43	43.61	508600.0
2022-06-27	ABMD-DELISTED	Stock	254.02	256.66	249.605	254.92	137752.0
2022-06-27	ABNB	Stock	103.96	104.17	99.33	101.5	7352100.0
2022-06-27	ABOS	Stock	3.78	4.16	3.64	4.1	286300.0
2022-06-27	ABR	Stock	13.76	13.85	13.47	13.51	2067800.0

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

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