PREVIEW / stock_daily / 2022-03-02

all stock daily files

  file:    by_date/stock_daily/2022/2022-03-02.parquet
  size:    260 KB
  rows:    8,033
  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-03-02	AAPL	Stock	164.39	167.36	162.95	166.56	79724800.0
2022-03-02	MSFT	Stock	295.36	301.47	293.7	300.19	31873000.0
2022-03-02	NVDA	Stock	23.756	24.409	23.415	24.22	389642000.0
2022-03-02	AMZN	Stock	150.849	152.9995	148.75	152.0525	47334000.0
2022-03-02	GOOGL	Stock	134.628	135.2625	133.0715	134.5715	23519800.0
2022-03-02	META	Stock	204.78	209.15	202.02	208.11	29452100.0
2022-03-02	TSLA	Stock	290.71	295.4933	281.4233	293.2967	74643300.0
2022-03-02	TLT	Stock	139.84	140.42	136.41	136.47	30397410.0
2022-03-02	ES	Stock	80.0	81.0	79.47	80.75	3372100.0
2022-03-02	CL	Stock	75.97	77.03	75.77	76.7	3952800.0
2022-03-02	A	Stock	132.68	133.96	131.8	133.16	1863100.0
2022-03-02	AA	Stock	81.01	83.16	78.782	82.56	10760800.0
2022-03-02	AAC-DELISTED	Stock	9.75	9.755	9.75	9.75	600.0
2022-03-02	AACG	Stock	1.29	1.33	1.25	1.25	10700.0
2022-03-02	AACIU	Stock	9.84	9.84	9.84	9.84	165.0
2022-03-02	AACIW-DELISTED	Stock	0.2303	0.238	0.2303	0.238	687.0
2022-03-02	AAIC-DELISTED	Stock	3.15	3.35	3.15	3.33	89216.0
2022-03-02	AAIC.C-DELISTED	Stock	24.795	24.985	24.7002	24.89	4062.0
2022-03-02	AAL	Stock	16.5	16.92	16.29	16.37	43654300.0
2022-03-02	AAM.A-DELISTED	Stock	25.03	25.06	24.99	25.03	16496.0
2022-03-02	AAM.B-DELISTED	Stock	25.43	25.43	25.27	25.35	31558.0
2022-03-02	AAME	Stock	2.55	2.55	2.52	2.52	1500.0
2022-03-02	AAMI	Stock	23.34	24.535	23.29	24.37	603300.0
2022-03-02	AAN-DELISTED	Stock	20.82	21.38	20.74	21.05	169500.0
2022-03-02	AAOI	Stock	3.62	3.73	3.51	3.7	214700.0
2022-03-02	AAON	Stock	38.1733	38.5067	36.7667	36.9467	494400.0
2022-03-02	AAP	Stock	203.35	210.75	201.35	209.07	1090900.0
2022-03-02	AAQC-DELISTED	Stock	9.71	9.71	9.71	9.71	400.0
2022-03-02	AAT	Stock	36.45	37.2	36.23	37.03	211500.0
2022-03-02	AATC	Stock	6.71	6.95	6.68	6.89	7025.0
2022-03-02	AAU-DELISTED	Stock	0.3098	0.3148	0.3078	0.313	223618.0
2022-03-02	AAUAF-DELISTED	Stock	0.3098	0.3147	0.3078	0.312	227750.0
2022-03-02	AAWW-DELISTED	Stock	80.5	82.785	80.5	80.76	529065.0
2022-03-02	AAXJ	Stock	78.0	78.29	77.3	78.03	1253291.0
2022-03-02	AB	Stock	43.29	45.74	43.29	44.81	341900.0
2022-03-02	ABB-DELISTED	Stock	33.17	33.51	32.93	33.37	2547766.0
2022-03-02	ABBNY-DELISTED	Stock	33.17	33.51	32.93	33.37	2791984.0
2022-03-02	ABBV	Stock	147.7	151.25	147.22	149.57	8247200.0
2022-03-02	ABC-DELISTED	Stock	142.65	144.11	142.18	143.0	742300.0
2022-03-02	ABCB	Stock	47.17	49.21	47.17	48.78	487200.0
2022-03-02	ABCL	Stock	9.4	9.7	9.06	9.43	1821000.0
2022-03-02	ABCM-DELISTED	Stock	16.56	16.765	16.43	16.71	45706.0
2022-03-02	ABEO	Stock	7.5	7.5	6.75	7.25	99836.0
2022-03-02	ABEV	Stock	2.84	2.89	2.81	2.85	36509800.0
2022-03-02	ABG	Stock	192.83	201.77	192.72	200.88	363400.0
2022-03-02	ABGI-DELISTED	Stock	9.7401	9.7501	9.7401	9.7501	70213.0
2022-03-02	ABM	Stock	44.94	45.97	44.91	45.6	264100.0
2022-03-02	ABMD-DELISTED	Stock	314.45	318.25	308.27	316.33	103018.0
2022-03-02	ABNB	Stock	152.48	158.08	151.89	157.53	5028300.0
2022-03-02	ABOS	Stock	6.13	6.3	5.77	5.85	232500.0

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

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