PREVIEW / stock_daily / 2022-11-02

all stock daily files

  file:    by_date/stock_daily/2022/2022-11-02.parquet
  size:    250 KB
  rows:    7,778
  symbols: 2,073

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-11-02	AAPL	Stock	148.95	152.17	145.0	145.03	93604600.0
2022-11-02	MSFT	Stock	229.46	231.3	220.04	220.1	38407000.0
2022-11-02	NVDA	Stock	13.85	14.21	13.211	13.219	672628000.0
2022-11-02	AMZN	Stock	97.32	97.74	92.01	92.12	135761800.0
2022-11-02	GOOGL	Stock	90.94	91.18	86.88	86.97	57038282.0
2022-11-02	META	Stock	94.21	95.2	90.48	90.54	71821100.0
2022-11-02	TSLA	Stock	226.04	227.87	214.82	214.98	63070300.0
2022-11-02	TLT	Stock	96.91	97.63	95.96	96.35	25010515.0
2022-11-02	ES	Stock	77.04	78.25	76.2	76.24	1761100.0
2022-11-02	CL	Stock	73.62	74.4	72.76	72.77	3991800.0
2022-11-02	A	Stock	140.61	140.94	135.21	135.27	1806100.0
2022-11-02	AA	Stock	40.71	41.14	37.77	37.77	5221800.0
2022-11-02	AAC-DELISTED	Stock	9.97	9.98	9.97	9.97	17705.0
2022-11-02	AACG	Stock	1.85	1.95	1.8	1.95	16500.0
2022-11-02	AAIC-DELISTED	Stock	2.96	3.0	2.89	2.9336	32155.0
2022-11-02	AAIC.C-DELISTED	Stock	19.91	19.9645	19.91	19.9645	300.0
2022-11-02	AAL	Stock	14.0	14.27	13.55	13.58	34816100.0
2022-11-02	AAM.A-DELISTED	Stock	21.51	21.68	21.02	21.24	16594.0
2022-11-02	AAM.B-DELISTED	Stock	21.8	21.92	21.3	21.59	10003.0
2022-11-02	AAMC-DELISTED	Stock	4.8971	5.7324	4.6868	5.2941	68078.0
2022-11-02	AAME	Stock	3.02	3.03	2.81	3.0	2000.0
2022-11-02	AAMI	Stock	19.09	19.415	18.48	18.53	367500.0
2022-11-02	AAN-DELISTED	Stock	10.19	10.39	9.76	9.77	422800.0
2022-11-02	AAOI	Stock	2.72	2.86	2.57	2.59	166200.0
2022-11-02	AAON	Stock	43.42	44.3333	42.2133	42.2133	167700.0
2022-11-02	AAP	Stock	189.21	194.35	186.74	186.89	1011700.0
2022-11-02	AAQC-DELISTED	Stock	9.95	9.95	9.95	9.95	3500.0
2022-11-02	AAT	Stock	27.79	28.25	27.44	27.49	415700.0
2022-11-02	AATC	Stock	4.36	4.36	4.3381	4.3381	787.0
2022-11-02	AAU-DELISTED	Stock	0.2298	0.2298	0.22	0.22	384257.0
2022-11-02	AAUAF-DELISTED	Stock	0.2298	0.2298	0.22	0.2221	386549.0
2022-11-02	AAWW-DELISTED	Stock	101.05	101.24	100.81	100.97	252498.0
2022-11-02	AAXJ	Stock	56.95	57.64	56.36	56.36	712345.0
2022-11-02	AB	Stock	37.65	37.87	36.55	37.07	306400.0
2022-11-02	ABB-DELISTED	Stock	27.91	28.32	27.39	27.41	1382329.0
2022-11-02	ABBNY-DELISTED	Stock	27.91	28.32	27.39	27.41	1634120.0
2022-11-02	ABBV	Stock	147.03	148.08	144.48	144.52	5345000.0
2022-11-02	ABC-DELISTED	Stock	155.97	158.24	154.77	154.88	772549.0
2022-11-02	ABCB	Stock	50.83	52.17	50.49	50.8	371300.0
2022-11-02	ABCL	Stock	11.61	12.47	11.51	12.0	2133600.0
2022-11-02	ABCM-DELISTED	Stock	15.46	15.63	15.13	15.13	314859.0
2022-11-02	ABEO	Stock	4.85	4.91	4.44	4.46	306800.0
2022-11-02	ABEV	Stock	3.02	3.05	2.97	2.97	12166400.0
2022-11-02	ABG	Stock	166.36	166.36	155.0	155.34	223100.0
2022-11-02	ABGI-DELISTED	Stock	9.97	9.97	9.97	9.97	100.0
2022-11-02	ABM	Stock	45.17	46.19	44.26	44.37	211000.0
2022-11-02	ABMD-DELISTED	Stock	377.75	377.965	372.0	373.58	2297798.0
2022-11-02	ABNB	Stock	102.645	104.98	94.25	94.41	29191400.0
2022-11-02	ABOS	Stock	7.0	7.07	6.79	6.89	188000.0
2022-11-02	ABR	Stock	13.6	13.92	13.33	13.34	1378500.0

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

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