PREVIEW / stock_daily / 2022-01-28

all stock daily files

  file:    by_date/stock_daily/2022/2022-01-28.parquet
  size:    262 KB
  rows:    8,107
  symbols: 2,630

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-28	AAPL	Stock	165.71	170.35	162.8	170.33	179935700.0
2022-01-28	MSFT	Stock	300.23	308.48	294.45	308.26	49743700.0
2022-01-28	NVDA	Stock	22.012	22.858	21.296	22.84	543774000.0
2022-01-28	AMZN	Stock	140.8605	143.998	137.9295	143.978	74392000.0
2022-01-28	GOOGL	Stock	129.659	133.3565	128.485	133.351	34361480.0
2022-01-28	META	Stock	295.62	301.9	293.03	301.71	21871600.0
2022-01-28	TSLA	Stock	277.1867	285.8333	264.0033	282.1167	134789100.0
2022-01-28	TLT	Stock	142.09	143.46	141.85	143.13	12826264.0
2022-01-28	ES	Stock	85.24	87.37	84.71	87.21	2593500.0
2022-01-28	CL	Stock	81.96	83.17	80.53	83.05	5987300.0
2022-01-28	A	Stock	133.0	137.4	131.22	137.06	2174800.0
2022-01-28	AA	Stock	58.0	58.39	55.58	57.4	6995300.0
2022-01-28	AAC-DELISTED	Stock	9.7	9.72	9.7	9.72	31553.0
2022-01-28	AACG	Stock	1.53	1.58	1.48	1.55	28500.0
2022-01-28	AACIU	Stock	9.82	9.82	9.82	9.82	308.0
2022-01-28	AACIW-DELISTED	Stock	0.28	0.28	0.2402	0.25005	90662.0
2022-01-28	AAIC-DELISTED	Stock	3.34	3.34	3.25	3.31	58073.0
2022-01-28	AAIC.C-DELISTED	Stock	24.9064	24.92	24.9	24.9	1574.0
2022-01-28	AAL	Stock	15.67	15.78	14.91	15.64	51662600.0
2022-01-28	AAM.A-DELISTED	Stock	25.61	25.61	25.26	25.35	65662.0
2022-01-28	AAM.B-DELISTED	Stock	26.73	26.74	26.35	26.35	52926.0
2022-01-28	AAME	Stock	2.45	2.59	2.41	2.5	9500.0
2022-01-28	AAMI	Stock	20.36	20.85	19.93	20.81	498400.0
2022-01-28	AAN-DELISTED	Stock	20.88	20.94	20.09	20.76	422600.0
2022-01-28	AAOI	Stock	3.76	3.82	3.66	3.82	228200.0
2022-01-28	AAON	Stock	41.2733	41.68	40.22	41.68	208950.0
2022-01-28	AAP	Stock	223.77	228.35	222.31	228.22	533700.0
2022-01-28	AAQC-DELISTED	Stock	9.68	9.68	9.68	9.68	624.0
2022-01-28	AAT	Stock	34.72	35.59	34.08	35.56	261000.0
2022-01-28	AATC	Stock	6.3	6.35	6.1743	6.35	34815.0
2022-01-28	AAU-DELISTED	Stock	0.2864	0.29	0.2715	0.2794	453596.0
2022-01-28	AAUAF-DELISTED	Stock	0.2864	0.29	0.2715	0.2794	456454.0
2022-01-28	AAWW-DELISTED	Stock	75.86	76.35	74.1	75.84	474010.0
2022-01-28	AAXJ	Stock	78.69	79.0	77.87	78.98	1109577.0
2022-01-28	AB	Stock	46.48	46.49	44.4	45.6	396700.0
2022-01-28	ABB-DELISTED	Stock	33.54	33.97	33.12	33.96	2524788.0
2022-01-28	ABBNY-DELISTED	Stock	33.54	33.97	33.12	33.96	2794189.0
2022-01-28	ABBV	Stock	135.99	137.98	134.6	137.92	8014400.0
2022-01-28	ABC-DELISTED	Stock	134.55	136.88	132.75	136.79	549740.0
2022-01-28	ABCB	Stock	48.46	50.0	46.22	48.89	661900.0
2022-01-28	ABCL	Stock	8.22	8.62	7.71	8.59	2707500.0
2022-01-28	ABCM-DELISTED	Stock	17.19	17.53	17.04	17.53	67773.0
2022-01-28	ABEO	Stock	5.75	6.0	5.5	5.75	90844.0
2022-01-28	ABEV	Stock	2.82	2.82	2.74	2.77	28171200.0
2022-01-28	ABG	Stock	155.61	157.79	153.01	156.9	277900.0
2022-01-28	ABGI-DELISTED	Stock	9.7	9.7	9.7	9.7	100.0
2022-01-28	ABM	Stock	40.39	40.72	39.52	40.71	474600.0
2022-01-28	ABMD-DELISTED	Stock	278.63	278.63	268.5	277.22	575690.0
2022-01-28	ABNB	Stock	138.545	143.11	134.374	142.77	5604400.0
2022-01-28	ABOS	Stock	4.81	5.084	4.6	5.01	473300.0

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

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