PREVIEW / stock_daily / 2022-08-23

all stock daily files

  file:    by_date/stock_daily/2022/2022-08-23.parquet
  size:    251 KB
  rows:    7,809
  symbols: 2,178

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-23	AAPL	Stock	167.08	168.71	166.65	167.23	54147100.0
2022-08-23	MSFT	Stock	276.44	278.86	275.4	276.44	17527400.0
2022-08-23	NVDA	Stock	16.989	17.465	16.97	17.181	369986000.0
2022-08-23	AMZN	Stock	133.41	134.99	132.95	133.62	36252100.0
2022-08-23	GOOGL	Stock	113.475	115.01	113.43	113.86	15870373.0
2022-08-23	META	Stock	162.48	165.05	160.7	161.11	18111800.0
2022-08-23	TSLA	Stock	291.4533	298.8267	287.9233	296.4533	63984900.0
2022-08-23	TLT	Stock	112.19	113.48	111.735	112.04	17813184.0
2022-08-23	ES	Stock	92.2	92.41	91.2	91.76	901300.0
2022-08-23	CL	Stock	81.41	81.46	80.65	80.96	2567700.0
2022-08-23	A	Stock	133.11	134.1	132.04	132.64	1188300.0
2022-08-23	AA	Stock	51.06	53.875	50.67	53.09	5267000.0
2022-08-23	AAC-DELISTED	Stock	9.87	9.8707	9.87	9.87	52103.0
2022-08-23	AACG	Stock	2.32	2.56	2.32	2.56	56700.0
2022-08-23	AACIW-DELISTED	Stock	0.1497	0.1497	0.1497	0.1497	107.0
2022-08-23	AAIC-DELISTED	Stock	3.25	3.25	3.23	3.25	23192.0
2022-08-23	AAIC.C-DELISTED	Stock	20.71	20.83	20.7	20.7	42511.0
2022-08-23	AAL	Stock	13.78	13.93	13.59	13.82	25500100.0
2022-08-23	AAM.A-DELISTED	Stock	25.06	25.15	24.66	24.91	45540.0
2022-08-23	AAM.B-DELISTED	Stock	25.2	25.31	24.51	24.75	30970.0
2022-08-23	AAMC-DELISTED	Stock	6.0559	6.2382	5.8706	5.8706	3601.0
2022-08-23	AAME	Stock	3.1	3.1	3.02	3.02	1800.0
2022-08-23	AAMI	Stock	18.51	18.73	18.39	18.59	166300.0
2022-08-23	AAN-DELISTED	Stock	13.97	14.15	13.87	13.95	183800.0
2022-08-23	AAOI	Stock	2.42	2.5	2.35	2.41	218100.0
2022-08-23	AAON	Stock	39.86	40.2733	39.1333	39.4733	129900.0
2022-08-23	AAP	Stock	199.53	200.49	197.75	199.05	1022800.0
2022-08-23	AAQC-DELISTED	Stock	9.84	9.84	9.81	9.82	76785.0
2022-08-23	AAT	Stock	28.86	28.96	28.51	28.52	165100.0
2022-08-23	AATC	Stock	5.2997	5.49	5.2997	5.3408	58083.0
2022-08-23	AAU-DELISTED	Stock	0.2293	0.23	0.22	0.23	188626.0
2022-08-23	AAUAF-DELISTED	Stock	0.2293	0.2351	0.22	0.2351	199409.0
2022-08-23	AAWW-DELISTED	Stock	100.0	100.15	99.77	99.82	687464.0
2022-08-23	AAXJ	Stock	66.81	67.22	66.59	66.94	679141.0
2022-08-23	AB	Stock	43.36	44.13	43.36	43.83	154900.0
2022-08-23	ABB-DELISTED	Stock	28.42	28.85	28.4	28.55	1116439.0
2022-08-23	ABBNY-DELISTED	Stock	28.42	28.85	28.4	28.54	1268618.0
2022-08-23	ABBV	Stock	139.65	140.85	138.45	139.02	3768100.0
2022-08-23	ABC-DELISTED	Stock	148.55	149.24	147.66	148.02	356925.0
2022-08-23	ABCB	Stock	48.72	49.28	47.75	48.16	141100.0
2022-08-23	ABCL	Stock	11.09	11.61	11.01	11.47	1693600.0
2022-08-23	ABCM-DELISTED	Stock	14.4	14.66	14.15	14.61	262323.0
2022-08-23	ABEO	Stock	4.01	4.23	4.0	4.1	61700.0
2022-08-23	ABEV	Stock	2.96	3.01	2.95	2.98	16559900.0
2022-08-23	ABG	Stock	181.12	184.81	181.12	181.84	96700.0
2022-08-23	ABGI-DELISTED	Stock	9.86	9.86	9.86	9.86	100000.0
2022-08-23	ABM	Stock	46.71	47.71	46.66	46.88	230800.0
2022-08-23	ABMD-DELISTED	Stock	260.34	262.75	256.55	262.44	120027.0
2022-08-23	ABNB	Stock	112.41	114.02	111.41	111.6	5447200.0
2022-08-23	ABOS	Stock	5.075	5.17	5.03	5.04	7000.0

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

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