PREVIEW / stock_daily / 2022-07-22

all stock daily files

  file:    by_date/stock_daily/2022/2022-07-22.parquet
  size:    252 KB
  rows:    7,867
  symbols: 2,269

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-22	AAPL	Stock	155.39	156.28	153.41	154.09	66675400.0
2022-07-22	MSFT	Stock	265.24	265.33	259.07	260.36	21881300.0
2022-07-22	NVDA	Stock	17.893	17.967	17.137	17.319	536671000.0
2022-07-22	AMZN	Stock	125.01	125.5	121.35	122.42	51463800.0
2022-07-22	GOOGL	Stock	111.0	112.34	106.5	107.9	48901184.0
2022-07-22	META	Stock	173.07	175.6	168.41	169.27	42583900.0
2022-07-22	TSLA	Stock	276.22	280.7867	270.7133	272.2433	103472700.0
2022-07-22	TLT	Stock	118.29	119.27	117.97	118.55	17715311.0
2022-07-22	ES	Stock	83.41	84.08	83.22	84.06	1149700.0
2022-07-22	CL	Stock	76.16	77.52	76.06	77.47	2537700.0
2022-07-22	A	Stock	127.41	128.54	124.31	125.04	1079500.0
2022-07-22	AA	Stock	46.05	48.47	45.47	45.8	10121200.0
2022-07-22	AAC-DELISTED	Stock	9.87	9.88	9.86	9.86	702431.0
2022-07-22	AACG	Stock	1.62	1.62	1.51	1.57	8000.0
2022-07-22	AACIU	Stock	10.01	10.01	10.01	10.01	5000.0
2022-07-22	AAIC-DELISTED	Stock	3.2569	3.2569	3.2001	3.234	41001.0
2022-07-22	AAIC.C-DELISTED	Stock	20.32	20.33	20.32	20.32	349.0
2022-07-22	AAL	Stock	14.11	14.28	13.63	13.68	38345400.0
2022-07-22	AAM.A-DELISTED	Stock	24.75	24.99	24.75	24.97	16738.0
2022-07-22	AAM.B-DELISTED	Stock	25.03	25.39	25.03	25.07	8348.0
2022-07-22	AAMC-DELISTED	Stock	3.4588	4.8522	3.4397	4.3265	173305.0
2022-07-22	AAME	Stock	3.0	3.0	2.99	3.0	600.0
2022-07-22	AAMI	Stock	18.65	18.9	18.49	18.71	152100.0
2022-07-22	AAN-DELISTED	Stock	16.38	16.45	15.72	16.01	264400.0
2022-07-22	AAOI	Stock	1.82	1.82	1.64	1.68	187900.0
2022-07-22	AAON	Stock	38.32	38.56	37.54	37.8667	138300.0
2022-07-22	AAP	Stock	191.83	193.03	190.6	191.23	543400.0
2022-07-22	AAQC-DELISTED	Stock	9.8	9.82	9.8	9.82	1111.0
2022-07-22	AAT	Stock	29.92	30.06	29.35	29.68	208600.0
2022-07-22	AATC	Stock	4.9501	5.0	4.95	5.0	13549.0
2022-07-22	AAU-DELISTED	Stock	0.226	0.23	0.2248	0.2265	404792.0
2022-07-22	AAUAF-DELISTED	Stock	0.226	0.23	0.2245	0.2265	431605.0
2022-07-22	AAWW-DELISTED	Stock	68.56	69.705	68.35	69.63	375062.0
2022-07-22	AAXJ	Stock	68.28	68.32	67.39	67.61	468300.0
2022-07-22	AB	Stock	42.4	42.45	41.19	41.58	162800.0
2022-07-22	ABB-DELISTED	Stock	28.73	28.855	28.43	28.54	1181849.0
2022-07-22	ABBNY-DELISTED	Stock	28.73	28.855	28.43	28.54	1320998.0
2022-07-22	ABBV	Stock	148.47	149.29	147.58	148.47	3639700.0
2022-07-22	ABC-DELISTED	Stock	143.47	143.89	141.46	142.5	428857.0
2022-07-22	ABCB	Stock	42.42	42.91	41.72	42.24	248200.0
2022-07-22	ABCL	Stock	10.48	10.48	9.93	10.07	1586800.0
2022-07-22	ABCM-DELISTED	Stock	14.55	14.63	14.39	14.42	267312.0
2022-07-22	ABEO	Stock	5.14	5.14	4.79	4.84	55400.0
2022-07-22	ABEV	Stock	2.62	2.66	2.59	2.61	25361400.0
2022-07-22	ABG	Stock	168.22	172.54	165.14	167.22	125700.0
2022-07-22	ABM	Stock	43.48	43.48	42.47	42.95	296200.0
2022-07-22	ABMD-DELISTED	Stock	285.16	286.31	279.12	281.77	117172.0
2022-07-22	ABNB	Stock	108.31	110.1	102.93	103.97	4243900.0
2022-07-22	ABOS	Stock	6.21	6.49	6.12	6.28	38900.0
2022-07-22	ABR	Stock	15.32	15.48	15.12	15.24	1998700.0

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

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