PREVIEW / stock_daily / 2022-02-07

all stock daily files

  file:    by_date/stock_daily/2022/2022-02-07.parquet
  size:    260 KB
  rows:    8,052
  symbols: 2,586

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-02-07	AAPL	Stock	172.86	173.95	170.95	171.66	77251200.0
2022-02-07	MSFT	Stock	306.17	307.84	299.9	300.95	28533300.0
2022-02-07	NVDA	Stock	24.372	25.182	24.202	24.728	376868000.0
2022-02-07	AMZN	Stock	158.52	162.691	157.25	157.9355	102624000.0
2022-02-07	GOOGL	Stock	144.25	144.25	138.9	139.201	54973300.0
2022-02-07	META	Stock	237.7	238.3	224.01	224.91	88613800.0
2022-02-07	TSLA	Stock	307.93	315.9233	300.9033	302.4467	60994500.0
2022-02-07	TLT	Stock	138.91	139.31	138.55	139.1	12962436.0
2022-02-07	ES	Stock	87.63	88.71	86.78	88.49	1568100.0
2022-02-07	CL	Stock	81.47	81.73	80.37	81.12	3502800.0
2022-02-07	A	Stock	141.5	142.49	139.81	140.37	1444100.0
2022-02-07	AA	Stock	64.95	65.77	63.02	63.75	5021900.0
2022-02-07	AAC-DELISTED	Stock	9.75	9.76	9.74	9.75	40043.0
2022-02-07	AACG	Stock	1.58	1.64	1.51	1.59	67800.0
2022-02-07	AAIC-DELISTED	Stock	3.41	3.47	3.4	3.47	67385.0
2022-02-07	AAIC.C-DELISTED	Stock	24.98	25.15	24.75	24.94	4272.0
2022-02-07	AAL	Stock	16.69	17.51	16.64	17.28	52927500.0
2022-02-07	AAM.A-DELISTED	Stock	25.21	25.23	25.2	25.23	15226.0
2022-02-07	AAM.B-DELISTED	Stock	25.79	25.84	25.75	25.805	19964.0
2022-02-07	AAME	Stock	2.58	2.58	2.52	2.54	2800.0
2022-02-07	AAMI	Stock	23.26	23.91	23.14	23.72	1120900.0
2022-02-07	AAN-DELISTED	Stock	20.65	21.56	20.65	21.18	210900.0
2022-02-07	AAOI	Stock	3.95	4.01	3.84	3.93	534700.0
2022-02-07	AAON	Stock	39.8933	40.1467	39.44	39.5133	229500.0
2022-02-07	AAP	Stock	228.44	228.97	223.93	225.94	709900.0
2022-02-07	AAQC-DELISTED	Stock	9.7001	9.71	9.7	9.71	4400.0
2022-02-07	AAT	Stock	35.16	35.47	35.09	35.18	152700.0
2022-02-07	AATC	Stock	7.05	7.3	6.9301	7.08	35346.0
2022-02-07	AAU-DELISTED	Stock	0.32	0.3249	0.3012	0.31	535192.0
2022-02-07	AAUAF-DELISTED	Stock	0.32	0.3249	0.3012	0.31	540228.0
2022-02-07	AAWW-DELISTED	Stock	77.755	79.28	76.79	78.38	448298.0
2022-02-07	AAXJ	Stock	81.29	81.66	81.04	81.3	1251555.0
2022-02-07	AB	Stock	46.87	47.48	46.17	46.55	374700.0
2022-02-07	ABB-DELISTED	Stock	34.61	34.9463	34.54	34.69	1902514.0
2022-02-07	ABBNY-DELISTED	Stock	34.61	34.9463	34.54	34.69	2147690.0
2022-02-07	ABBV	Stock	141.17	143.01	140.33	142.53	9597800.0
2022-02-07	ABC-DELISTED	Stock	137.02	140.24	135.39	139.42	1235779.0
2022-02-07	ABCB	Stock	48.98	49.78	48.35	49.63	290400.0
2022-02-07	ABCL	Stock	9.3	9.75	9.25	9.46	1311500.0
2022-02-07	ABCM-DELISTED	Stock	17.32	17.48	17.1	17.4	79979.0
2022-02-07	ABEO	Stock	6.5	6.75	6.25	6.5	37584.0
2022-02-07	ABEV	Stock	2.7	2.74	2.69	2.72	16655400.0
2022-02-07	ABG	Stock	151.32	154.0	146.43	151.49	418000.0
2022-02-07	ABGI-DELISTED	Stock	9.73	9.74	9.73	9.74	4777.0
2022-02-07	ABM	Stock	40.38	40.62	40.13	40.24	301300.0
2022-02-07	ABMD-DELISTED	Stock	296.0	300.41	289.35	290.04	133564.0
2022-02-07	ABNB	Stock	156.79	160.88	155.95	157.91	4690700.0
2022-02-07	ABOS	Stock	4.93	5.3	4.82	5.21	734100.0
2022-02-07	ABR	Stock	17.15	17.44	17.12	17.2	1103600.0
2022-02-07	ABR.D	Stock	24.45	24.45	23.8911	23.98	44459.0

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

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