PREVIEW / stock_daily / 2022-06-02

all stock daily files

  file:    by_date/stock_daily/2022/2022-06-02.parquet
  size:    257 KB
  rows:    7,949
  symbols: 2,362

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-06-02	AAPL	Stock	147.83	151.27	146.86	151.21	72348100.0
2022-06-02	MSFT	Stock	264.45	274.65	261.6	274.58	44008200.0
2022-06-02	NVDA	Stock	18.292	19.619	18.198	19.592	648656000.0
2022-06-02	AMZN	Stock	121.684	125.61	120.045	125.511	100560000.0
2022-06-02	GOOGL	Stock	114.0	117.8995	112.9465	117.6225	37992280.0
2022-06-02	META	Stock	188.45	200.94	187.73	198.86	31951600.0
2022-06-02	TSLA	Stock	244.1567	264.21	242.0667	258.3333	93473100.0
2022-06-02	TLT	Stock	116.63	116.71	115.46	116.28	9832015.0
2022-06-02	ES	Stock	92.58	92.73	90.41	92.42	1099400.0
2022-06-02	CL	Stock	78.51	79.3	77.26	79.27	3588900.0
2022-06-02	A	Stock	122.96	129.19	122.3	129.1	1444400.0
2022-06-02	AA	Stock	63.7	65.14	62.85	63.83	3923400.0
2022-06-02	AAC-DELISTED	Stock	9.83	9.83	9.81	9.82	126940.0
2022-06-02	AACG	Stock	0.97	1.03	0.97	1.03	15700.0
2022-06-02	AACIU	Stock	9.93	9.93	9.93	9.93	500.0
2022-06-02	AAIC-DELISTED	Stock	3.6	3.62	3.55	3.55	18770.0
2022-06-02	AAIC.C-DELISTED	Stock	23.3	23.57	23.3	23.5014	1376.0
2022-06-02	AAL	Stock	17.27	17.51	17.18	17.46	23337700.0
2022-06-02	AAM.A-DELISTED	Stock	24.73	24.85	24.7065	24.84	11312.0
2022-06-02	AAM.B-DELISTED	Stock	25.66	25.66	25.3643	25.58	2626.0
2022-06-02	AAME	Stock	3.01	3.01	3.01	3.01	600.0
2022-06-02	AAMI	Stock	20.2	20.78	19.955	20.75	353600.0
2022-06-02	AAN-DELISTED	Stock	17.92	18.56	17.64	18.52	256600.0
2022-06-02	AAOI	Stock	2.28	2.4	2.25	2.31	257300.0
2022-06-02	AAON	Stock	36.3733	37.0867	36.24	36.9467	195750.0
2022-06-02	AAP	Stock	188.45	191.25	185.9	191.09	729300.0
2022-06-02	AAQC-DELISTED	Stock	9.76	9.77	9.76	9.76	9300.0
2022-06-02	AAT	Stock	33.35	33.44	32.65	33.41	160100.0
2022-06-02	AATC	Stock	5.91	5.96	5.91	5.96	5296.0
2022-06-02	AAU-DELISTED	Stock	0.2435	0.26	0.241	0.2599	463880.0
2022-06-02	AAUAF-DELISTED	Stock	0.2435	0.26	0.241	0.2599	468254.0
2022-06-02	AAWW-DELISTED	Stock	69.32	71.15	69.28	70.89	327807.0
2022-06-02	AAXJ	Stock	71.33	72.49	71.29	72.49	2624215.0
2022-06-02	AB	Stock	42.2	43.47	42.07	43.35	198400.0
2022-06-02	ABB-DELISTED	Stock	31.21	31.98	31.19	31.97	2249948.0
2022-06-02	ABBNY-DELISTED	Stock	31.21	31.98	31.19	31.97	2470039.0
2022-06-02	ABBV	Stock	146.65	147.07	142.9	146.75	5998900.0
2022-06-02	ABC-DELISTED	Stock	149.92	150.32	145.61	148.2	925632.0
2022-06-02	ABCB	Stock	45.04	45.93	44.74	45.89	192700.0
2022-06-02	ABCL	Stock	7.8	7.95	7.63	7.72	1782200.0
2022-06-02	ABCM-DELISTED	Stock	14.96	15.18	14.7	15.11	91595.0
2022-06-02	ABEO	Stock	4.0	4.0	3.75	4.0	34576.0
2022-06-02	ABEV	Stock	2.91	2.94	2.86	2.93	27072800.0
2022-06-02	ABG	Stock	185.17	186.24	180.37	181.92	165000.0
2022-06-02	ABGI-DELISTED	Stock	9.79	9.79	9.79	9.79	7100.0
2022-06-02	ABM	Stock	48.32	49.0	48.05	49.0	307700.0
2022-06-02	ABMD-DELISTED	Stock	256.5	270.1	253.68	269.78	96884.0
2022-06-02	ABNB	Stock	117.13	123.0	116.27	121.26	5166200.0
2022-06-02	ABOS	Stock	3.28	3.62	3.25	3.53	116800.0
2022-06-02	ABR	Stock	16.43	16.57	16.24	16.49	2059800.0

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

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