PREVIEW / stock_daily / 2022-08-02

all stock daily files

  file:    by_date/stock_daily/2022/2022-08-02.parquet
  size:    253 KB
  rows:    7,890
  symbols: 2,265

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-08-02	AAPL	Stock	160.1	162.41	159.63	160.01	59907000.0
2022-08-02	MSFT	Stock	276.0	277.89	272.38	274.82	22754200.0
2022-08-02	NVDA	Stock	18.122	18.938	18.092	18.526	489527000.0
2022-08-02	AMZN	Stock	134.72	137.44	134.09	134.16	61922400.0
2022-08-02	GOOGL	Stock	114.0	116.35	113.72	115.13	20236029.0
2022-08-02	META	Stock	158.31	162.24	158.01	160.19	27374500.0
2022-08-02	TSLA	Stock	294.0033	307.8333	292.6667	300.5867	95577600.0
2022-08-02	TLT	Stock	120.15	120.69	117.285	117.5	17896257.0
2022-08-02	ES	Stock	89.42	91.05	89.28	90.24	1907000.0
2022-08-02	CL	Stock	81.52	81.56	80.11	80.26	20428800.0
2022-08-02	A	Stock	132.41	134.68	131.09	131.28	1398600.0
2022-08-02	AA	Stock	47.84	49.56	47.261	48.34	4685900.0
2022-08-02	AAC-DELISTED	Stock	9.87	9.895	9.87	9.87	744025.0
2022-08-02	AACG	Stock	1.82	1.92	1.8	1.91	57900.0
2022-08-02	AAIC-DELISTED	Stock	3.15	3.17	3.08	3.1	138445.0
2022-08-02	AAIC.C-DELISTED	Stock	20.715	20.84	20.61	20.7	5830.0
2022-08-02	AAL	Stock	14.05	14.4	13.9	14.06	27440000.0
2022-08-02	AAM.A-DELISTED	Stock	25.49	25.65	25.35	25.45	53190.0
2022-08-02	AAM.B-DELISTED	Stock	26.28	26.99	26.0	26.8	47232.0
2022-08-02	AAMC-DELISTED	Stock	4.8735	5.3585	4.6618	4.8529	71274.0
2022-08-02	AAME	Stock	2.83	2.88	2.79	2.79	4000.0
2022-08-02	AAMI	Stock	18.98	19.04	18.57	18.57	267800.0
2022-08-02	AAN-DELISTED	Stock	12.97	13.04	12.575	12.98	472100.0
2022-08-02	AAOI	Stock	1.69	1.89	1.66	1.85	237700.0
2022-08-02	AAON	Stock	40.52	40.6	39.6333	39.8	130650.0
2022-08-02	AAP	Stock	195.73	196.25	193.56	195.02	466200.0
2022-08-02	AAQC-DELISTED	Stock	9.8	9.82	9.8	9.81	802978.0
2022-08-02	AAT	Stock	29.91	29.94	29.17	29.23	281900.0
2022-08-02	AATC	Stock	5.1493	5.1493	5.05	5.05	666.0
2022-08-02	AAU-DELISTED	Stock	0.24	0.2401	0.2307	0.2386	191838.0
2022-08-02	AAUAF-DELISTED	Stock	0.24	0.2401	0.2307	0.2386	208532.0
2022-08-02	AAWW-DELISTED	Stock	84.87	89.67	84.75	87.37	1365370.0
2022-08-02	AAXJ	Stock	66.7	67.81	66.59	67.05	942915.0
2022-08-02	AB	Stock	44.01	44.59	43.22	43.99	243500.0
2022-08-02	ABB-DELISTED	Stock	29.8	29.97	29.62	29.64	1331472.0
2022-08-02	ABBNY-DELISTED	Stock	29.82	29.97	29.62	29.64	1521054.0
2022-08-02	ABBV	Stock	141.18	142.84	140.1	140.39	5197100.0
2022-08-02	ABC-DELISTED	Stock	146.31	146.71	142.48	142.91	931020.0
2022-08-02	ABCB	Stock	47.35	47.56	46.31	46.49	280300.0
2022-08-02	ABCL	Stock	10.11	11.005	10.11	10.72	1733100.0
2022-08-02	ABCM-DELISTED	Stock	14.57	15.07	14.57	15.05	264420.0
2022-08-02	ABEO	Stock	3.9	4.2	3.83	3.91	131200.0
2022-08-02	ABEV	Stock	2.76	2.79	2.73	2.73	25128400.0
2022-08-02	ABG	Stock	180.32	180.32	174.1	174.8	192200.0
2022-08-02	ABGI-DELISTED	Stock	9.84	9.855	9.84	9.85	56769.0
2022-08-02	ABM	Stock	45.42	45.42	44.47	44.48	280500.0
2022-08-02	ABMD-DELISTED	Stock	291.06	299.085	290.46	293.62	125371.0
2022-08-02	ABNB	Stock	111.67	117.78	111.1	116.34	15208200.0
2022-08-02	ABOS	Stock	4.93	5.19	4.7	4.98	62700.0
2022-08-02	ABR	Stock	15.92	16.27	15.14	15.19	9157000.0

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

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