PREVIEW / stock_daily / 2022-01-11

all stock daily files

  file:    by_date/stock_daily/2022/2022-01-11.parquet
  size:    262 KB
  rows:    8,030
  symbols: 2,571

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-01-11	AAPL	Stock	172.32	175.18	170.82	175.08	76138300.0
2022-01-11	MSFT	Stock	313.38	316.61	309.89	314.98	29386800.0
2022-01-11	NVDA	Stock	27.323	28.065	26.839	27.817	404089000.0
2022-01-11	AMZN	Stock	161.5	166.35	160.7015	165.362	62806000.0
2022-01-11	GOOGL	Stock	138.007	140.216	136.6922	139.736	28729700.0
2022-01-11	META	Stock	326.78	334.63	325.28	334.37	16226800.0
2022-01-11	TSLA	Stock	351.2233	358.6167	346.2733	354.8	66063300.0
2022-01-11	TLT	Stock	142.88	143.63	142.695	143.56	24388906.0
2022-01-11	ES	Stock	89.06	89.46	85.83	86.63	1902800.0
2022-01-11	CL	Stock	83.42	83.56	82.43	83.17	3562400.0
2022-01-11	A	Stock	145.0	146.94	143.81	146.64	2194200.0
2022-01-11	AA	Stock	60.71	62.25	59.12	62.2	6003600.0
2022-01-11	AAC-DELISTED	Stock	9.76	9.77	9.75	9.77	7674.0
2022-01-11	AACG	Stock	2.19	2.55	2.16	2.29	1542100.0
2022-01-11	AACIU	Stock	10.0	10.09	10.0	10.09	499.0
2022-01-11	AACIW-DELISTED	Stock	0.55	0.55	0.55	0.55	25067.0
2022-01-11	AAIC-DELISTED	Stock	3.55	3.62	3.55	3.61	53567.0
2022-01-11	AAL	Stock	18.88	19.2	18.71	19.02	22531500.0
2022-01-11	AAM.A-DELISTED	Stock	25.4	25.4906	25.38	25.44	20286.0
2022-01-11	AAM.B-DELISTED	Stock	26.28	26.54	26.28	26.46	14891.0
2022-01-11	AAME	Stock	2.86	2.9	2.72	2.85	6900.0
2022-01-11	AAMI	Stock	24.23	24.83	23.97	24.62	529500.0
2022-01-11	AAN-DELISTED	Stock	23.42	23.53	22.791	23.08	143600.0
2022-01-11	AAOI	Stock	4.32	4.5	4.27	4.41	529100.0
2022-01-11	AAON	Stock	49.68	49.8733	48.1333	49.54	194700.0
2022-01-11	AAP	Stock	234.64	234.81	230.57	232.01	638800.0
2022-01-11	AAQC-DELISTED	Stock	9.75	9.75	9.71	9.71	683.0
2022-01-11	AAT	Stock	38.51	38.54	37.44	38.35	212300.0
2022-01-11	AATC	Stock	6.35	6.38	6.3	6.34	6232.0
2022-01-11	AAU-DELISTED	Stock	0.285	0.285	0.2801	0.2835	185084.0
2022-01-11	AAUAF-DELISTED	Stock	0.285	0.285	0.2801	0.2835	188211.0
2022-01-11	AAWW-DELISTED	Stock	87.28	87.68	85.363	87.4	266890.0
2022-01-11	AAXJ	Stock	83.13	84.39	82.95	84.33	591526.0
2022-01-11	AB	Stock	50.0	51.58	49.76	51.11	269600.0
2022-01-11	ABB-DELISTED	Stock	36.96	37.44	36.85	37.42	1802943.0
2022-01-11	ABBNY-DELISTED	Stock	36.96	37.44	36.85	37.42	1987390.0
2022-01-11	ABBV	Stock	135.85	137.09	134.8	136.97	7159400.0
2022-01-11	ABC-DELISTED	Stock	135.0	136.945	134.8	136.45	772221.0
2022-01-11	ABCB	Stock	54.08	54.3	52.94	53.87	396300.0
2022-01-11	ABCL	Stock	11.94	12.45	11.765	12.06	2263900.0
2022-01-11	ABCM-DELISTED	Stock	20.2	20.275	19.98	20.01	1104826.0
2022-01-11	ABEO	Stock	7.5	8.0	7.5	7.75	88900.0
2022-01-11	ABEV	Stock	2.6	2.66	2.57	2.65	18964500.0
2022-01-11	ABG	Stock	178.92	179.88	174.36	176.57	221600.0
2022-01-11	ABGI-DELISTED	Stock	9.7667	9.7667	9.7667	9.7667	300.0
2022-01-11	ABM	Stock	43.36	43.53	42.43	43.07	596500.0
2022-01-11	ABMD-DELISTED	Stock	307.18	322.935	306.405	319.21	542023.0
2022-01-11	ABNB	Stock	160.71	169.39	159.078	168.61	5331600.0
2022-01-11	ABOS	Stock	5.499	5.94	5.4	5.64	105200.0
2022-01-11	ABR	Stock	18.75	18.87	18.62	18.76	1132800.0

> showing 50 of 8,030 rows — these rows as CSV

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