PREVIEW / stock_daily / 2022-02-04

all stock daily files

  file:    by_date/stock_daily/2022/2022-02-04.parquet
  size:    259 KB
  rows:    7,985
  symbols: 2,510

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-04	AAPL	Stock	171.68	174.1	170.68	172.39	82465400.0
2022-02-04	MSFT	Stock	300.21	308.8	299.97	305.94	35096500.0
2022-02-04	NVDA	Stock	23.972	24.635	23.632	24.319	354829000.0
2022-02-04	AMZN	Stock	155.6065	161.2	150.608	157.6395	253456000.0
2022-02-04	GOOGL	Stock	143.4446	144.875	140.515	143.293	57998220.0
2022-02-04	META	Stock	234.97	242.61	230.11	237.09	89342200.0
2022-02-04	TSLA	Stock	299.0733	312.1667	293.7233	307.7733	73625400.0
2022-02-04	TLT	Stock	139.85	140.14	138.78	139.01	23609757.0
2022-02-04	ES	Stock	87.3	88.69	86.29	87.74	2426700.0
2022-02-04	CL	Stock	82.21	82.39	80.81	81.12	5173100.0
2022-02-04	A	Stock	141.48	142.35	139.67	141.12	1087400.0
2022-02-04	AA	Stock	62.26	65.6	61.88	64.22	7161200.0
2022-02-04	AAC-DELISTED	Stock	9.77	9.77	9.7225	9.75	48285.0
2022-02-04	AACG	Stock	1.6	1.68	1.5	1.56	61800.0
2022-02-04	AAIC-DELISTED	Stock	3.35	3.43	3.28	3.425	108929.0
2022-02-04	AAIC.C-DELISTED	Stock	24.82	24.8947	24.7	24.7	2509.0
2022-02-04	AAL	Stock	16.54	16.57	16.04	16.45	38585200.0
2022-02-04	AAM.A-DELISTED	Stock	25.23	25.26	25.17	25.22	35800.0
2022-02-04	AAM.B-DELISTED	Stock	25.86	25.86	25.71	25.78	29785.0
2022-02-04	AAME	Stock	2.44	2.59	2.44	2.56	3300.0
2022-02-04	AAMI	Stock	22.41	23.615	22.41	23.45	906300.0
2022-02-04	AAN-DELISTED	Stock	21.17	21.29	20.25	20.77	356700.0
2022-02-04	AAOI	Stock	3.85	3.99	3.78	3.95	244800.0
2022-02-04	AAON	Stock	40.5133	41.8467	39.4133	39.9733	304800.0
2022-02-04	AAP	Stock	231.53	231.63	223.34	226.99	689100.0
2022-02-04	AAQC-DELISTED	Stock	9.7	9.74	9.7	9.74	33632.0
2022-02-04	AAT	Stock	34.89	35.5	34.44	35.14	149100.0
2022-02-04	AATC	Stock	6.71	6.9399	6.71	6.93	9549.0
2022-02-04	AAU-DELISTED	Stock	0.3	0.325	0.295	0.325	468654.0
2022-02-04	AAUAF-DELISTED	Stock	0.3	0.325	0.295	0.325	476570.0
2022-02-04	AAWW-DELISTED	Stock	79.88	80.45	76.03	76.77	404448.0
2022-02-04	AAXJ	Stock	80.93	81.8	80.78	81.52	643734.0
2022-02-04	AB	Stock	45.8	47.38	45.7	46.66	357700.0
2022-02-04	ABB-DELISTED	Stock	34.18	34.295	33.815	34.04	2498203.0
2022-02-04	ABBNY-DELISTED	Stock	34.18	34.295	33.815	34.05	2765045.0
2022-02-04	ABBV	Stock	140.15	142.8	139.23	140.65	6921500.0
2022-02-04	ABC-DELISTED	Stock	136.22	137.79	134.625	136.61	918714.0
2022-02-04	ABCB	Stock	49.08	49.39	48.33	48.97	291200.0
2022-02-04	ABCL	Stock	9.23	9.47	9.0	9.3	1827600.0
2022-02-04	ABCM-DELISTED	Stock	17.44	17.5866	17.26	17.28	60050.0
2022-02-04	ABEO	Stock	6.0	6.5	6.0	6.25	47500.0
2022-02-04	ABEV	Stock	2.68	2.73	2.67	2.71	16433600.0
2022-02-04	ABG	Stock	162.18	162.18	152.01	152.72	278600.0
2022-02-04	ABGI-DELISTED	Stock	9.7	9.74	9.7	9.74	75200.0
2022-02-04	ABM	Stock	40.95	41.48	40.23	40.42	284400.0
2022-02-04	ABMD-DELISTED	Stock	287.27	299.24	285.45	295.66	121708.0
2022-02-04	ABNB	Stock	150.14	157.24	150.0	155.56	4687700.0
2022-02-04	ABOS	Stock	4.76	5.0	4.66	4.98	224900.0
2022-02-04	ABR	Stock	17.04	17.23	16.85	17.06	1678600.0
2022-02-04	ABR.D	Stock	24.56	24.56	24.4	24.43	6881.0

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

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