PREVIEW / stock_daily / 2022-07-01

all stock daily files

  file:    by_date/stock_daily/2022/2022-07-01.parquet
  size:    251 KB
  rows:    7,826
  symbols: 2,264

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-07-01	AAPL	Stock	136.04	139.04	135.66	138.93	71051600.0
2022-07-01	MSFT	Stock	256.39	259.77	254.61	259.58	22837700.0
2022-07-01	NVDA	Stock	14.899	15.063	14.392	14.523	577610000.0
2022-07-01	AMZN	Stock	106.29	109.75	105.85	109.56	73021200.0
2022-07-01	GOOGL	Stock	107.933	109.25	106.7305	108.7375	35475660.0
2022-07-01	META	Stock	160.31	160.62	155.0	160.03	31423900.0
2022-07-01	TSLA	Stock	227.0	230.23	222.12	227.2633	74460300.0
2022-07-01	TLT	Stock	115.9	117.59	115.22	115.82	21858829.0
2022-07-01	ES	Stock	85.03	87.48	84.73	87.15	2426600.0
2022-07-01	CL	Stock	80.55	82.02	80.35	81.97	4252900.0
2022-07-01	A	Stock	118.79	119.76	116.7	119.21	1119800.0
2022-07-01	AA	Stock	44.885	45.829	43.35	44.78	6634800.0
2022-07-01	AAC-DELISTED	Stock	9.84	9.845	9.83	9.845	110647.0
2022-07-01	AACG	Stock	1.06	1.08	1.06	1.06	7800.0
2022-07-01	AACIW-DELISTED	Stock	0.26	0.26	0.26	0.26	307.0
2022-07-01	AAIC-DELISTED	Stock	3.28	3.289	3.16	3.16	73872.0
2022-07-01	AAIC.C-DELISTED	Stock	22.0	22.0	21.85	21.85	1240.0
2022-07-01	AAL	Stock	12.78	13.18	12.52	13.13	34110400.0
2022-07-01	AAM.A-DELISTED	Stock	24.092	24.42	24.01	24.42	5271.0
2022-07-01	AAM.B-DELISTED	Stock	24.92	25.21	24.86	25.2	5581.0
2022-07-01	AAMC-DELISTED	Stock	2.7421	3.0147	2.7421	2.9382	53230.0
2022-07-01	AAME	Stock	2.6	2.63	2.54	2.54	1300.0
2022-07-01	AAMI	Stock	17.85	18.228	17.75	18.12	397900.0
2022-07-01	AAN-DELISTED	Stock	14.46	14.84	14.34	14.75	218500.0
2022-07-01	AAOI	Stock	1.55	1.572	1.509	1.56	201600.0
2022-07-01	AAON	Stock	36.2733	37.24	35.9933	37.18	360300.0
2022-07-01	AAP	Stock	173.4	177.66	172.13	173.64	784400.0
2022-07-01	AAQC-DELISTED	Stock	9.77	9.77	9.77	9.77	11568.0
2022-07-01	AAT	Stock	29.55	30.22	29.53	30.18	174400.0
2022-07-01	AATC	Stock	5.4	5.52	5.33	5.36	21521.0
2022-07-01	AAU-DELISTED	Stock	0.218	0.2394	0.218	0.23	417178.0
2022-07-01	AAUAF-DELISTED	Stock	0.218	0.2394	0.218	0.228	420171.0
2022-07-01	AAWW-DELISTED	Stock	61.09	62.08	59.95	61.47	239626.0
2022-07-01	AAXJ	Stock	68.37	68.74	67.96	68.69	855114.0
2022-07-01	AB	Stock	41.5	42.24	41.09	42.15	201700.0
2022-07-01	ABB-DELISTED	Stock	26.33	26.625	26.115	26.62	2098115.0
2022-07-01	ABBNY-DELISTED	Stock	26.33	26.625	26.115	26.61	2282680.0
2022-07-01	ABBV	Stock	153.08	153.86	151.46	153.8	4620000.0
2022-07-01	ABC-DELISTED	Stock	141.85	143.467	139.3	143.15	583083.0
2022-07-01	ABCB	Stock	39.87	41.08	39.68	40.84	454600.0
2022-07-01	ABCL	Stock	10.61	10.92	10.43	10.64	1979800.0
2022-07-01	ABCM-DELISTED	Stock	14.34	14.72	14.27	14.7	108360.0
2022-07-01	ABEO	Stock	5.0	5.25	4.75	4.75	113252.0
2022-07-01	ABEV	Stock	2.48	2.57	2.47	2.56	21925700.0
2022-07-01	ABG	Stock	168.66	174.98	167.64	173.28	109900.0
2022-07-01	ABM	Stock	43.17	43.88	42.69	43.2	283200.0
2022-07-01	ABMD-DELISTED	Stock	246.42	254.82	244.66	254.82	112244.0
2022-07-01	ABNB	Stock	89.09	91.46	87.43	91.41	5995400.0
2022-07-01	ABOS	Stock	4.71	5.023	4.401	4.71	114100.0
2022-07-01	ABR	Stock	13.03	13.49	13.03	13.47	1660100.0

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

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