PREVIEW / stock_daily / 2022-02-08

all stock daily files

  file:    by_date/stock_daily/2022/2022-02-08.parquet
  size:    260 KB
  rows:    8,030
  symbols: 2,556

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-08	AAPL	Stock	171.73	175.35	171.43	174.83	74829200.0
2022-02-08	MSFT	Stock	301.25	305.56	299.95	304.56	32421200.0
2022-02-08	NVDA	Stock	24.359	25.23	23.98	25.108	410359000.0
2022-02-08	AMZN	Stock	156.7505	161.7925	155.5505	161.4135	76040000.0
2022-02-08	GOOGL	Stock	139.0265	140.0	137.0139	139.399	54283600.0
2022-02-08	META	Stock	220.85	225.77	216.15	220.18	94729700.0
2022-02-08	TSLA	Stock	301.8433	308.7633	298.2667	307.3333	50729100.0
2022-02-08	TLT	Stock	138.21	138.58	137.82	138.17	16269187.0
2022-02-08	ES	Stock	88.84	89.0	87.66	87.76	1911500.0
2022-02-08	CL	Stock	81.3	81.53	80.84	80.92	4014100.0
2022-02-08	A	Stock	139.11	141.41	138.29	140.81	1515400.0
2022-02-08	AA	Stock	65.83	71.97	65.6	69.97	16122900.0
2022-02-08	AAC-DELISTED	Stock	9.75	9.7601	9.74	9.76	16752.0
2022-02-08	AACG	Stock	1.56	1.61	1.56	1.58	28800.0
2022-02-08	AACIW-DELISTED	Stock	0.2103	0.35	0.2103	0.35	7150.0
2022-02-08	AAIC-DELISTED	Stock	3.44	3.49	3.43	3.44	56944.0
2022-02-08	AAIC.C-DELISTED	Stock	24.8501	24.8525	24.75	24.75	3099.0
2022-02-08	AAL	Stock	17.4	18.28	17.21	18.26	46702500.0
2022-02-08	AAM.A-DELISTED	Stock	25.23	25.25	25.21	25.2301	33928.0
2022-02-08	AAM.B-DELISTED	Stock	25.78	25.78	25.66	25.69	48117.0
2022-02-08	AAME	Stock	2.51	2.61	2.5	2.61	1300.0
2022-02-08	AAMI	Stock	23.72	24.15	23.72	24.09	1018800.0
2022-02-08	AAN-DELISTED	Stock	21.2	21.92	21.08	21.87	177500.0
2022-02-08	AAOI	Stock	3.94	4.0	3.835	3.87	597600.0
2022-02-08	AAON	Stock	39.7	40.2533	39.1	39.8467	853650.0
2022-02-08	AAP	Stock	226.7	231.57	226.06	230.2	564100.0
2022-02-08	AAQC-DELISTED	Stock	9.72	9.72	9.72	9.72	100.0
2022-02-08	AAT	Stock	35.22	35.48	34.99	35.1	164800.0
2022-02-08	AATC	Stock	7.28	7.28	7.0	7.15	14568.0
2022-02-08	AAU-DELISTED	Stock	0.3193	0.325	0.31	0.325	469054.0
2022-02-08	AAUAF-DELISTED	Stock	0.3193	0.325	0.31	0.325	472606.0
2022-02-08	AAWW-DELISTED	Stock	78.36	79.63	78.07	78.42	170855.0
2022-02-08	AAXJ	Stock	81.08	81.99	81.08	81.92	709743.0
2022-02-08	AB	Stock	46.95	48.72	46.61	48.03	351400.0
2022-02-08	ABB-DELISTED	Stock	34.81	35.0	34.6	34.95	1823656.0
2022-02-08	ABBNY-DELISTED	Stock	34.81	35.0	34.6	34.94	2035133.0
2022-02-08	ABBV	Stock	142.03	143.6	141.25	143.51	7559500.0
2022-02-08	ABC-DELISTED	Stock	139.57	142.98	138.915	142.23	1116463.0
2022-02-08	ABCB	Stock	50.29	50.8	49.4	50.78	455700.0
2022-02-08	ABCL	Stock	9.38	9.54	9.19	9.24	1474000.0
2022-02-08	ABCM-DELISTED	Stock	17.22	17.47	17.02	17.24	64382.0
2022-02-08	ABEO	Stock	6.5	6.5	6.25	6.25	55388.0
2022-02-08	ABEV	Stock	2.69	2.73	2.69	2.71	21206800.0
2022-02-08	ABG	Stock	151.58	157.65	150.45	156.83	349000.0
2022-02-08	ABGI-DELISTED	Stock	9.74	9.74	9.74	9.74	15229.0
2022-02-08	ABM	Stock	40.5	41.58	40.42	41.5	283700.0
2022-02-08	ABMD-DELISTED	Stock	289.84	310.0	285.49	309.03	506460.0
2022-02-08	ABNB	Stock	154.0	163.079	153.44	162.26	4309100.0
2022-02-08	ABOS	Stock	5.17	5.63	5.17	5.47	327700.0
2022-02-08	ABR	Stock	17.11	17.37	17.09	17.21	1831000.0

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

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