PREVIEW / stock_daily / 2023-06-02

all stock daily files

  file:    by_date/stock_daily/2023/2023-06-02.parquet
  size:    241 KB
  rows:    7,497
  symbols: 1,617

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
2023-06-02	AAPL	Stock	181.03	181.78	179.26	180.95	61945900.0
2023-06-02	MSFT	Stock	334.25	337.5	332.55	335.4	25864000.0
2023-06-02	NVDA	Stock	40.097	40.5	39.058	39.327	482731000.0
2023-06-02	AMZN	Stock	124.92	126.39	124.02	124.25	61215000.0
2023-06-02	GOOGL	Stock	123.99	126.15	123.76	124.67	26980147.0
2023-06-02	META	Stock	272.66	275.35	271.12	272.61	19405300.0
2023-06-02	TSLA	Stock	210.15	217.25	209.75	213.97	164129000.0
2023-06-02	TLT	Stock	103.0	103.065	101.94	101.99	19136515.0
2023-06-02	ES	Stock	68.41	70.3	68.05	70.01	2754200.0
2023-06-02	CL	Stock	74.75	76.12	74.6	76.05	4755200.0
2023-06-02	A	Stock	117.77	118.41	116.02	118.22	3263100.0
2023-06-02	AA	Stock	34.29	35.39	33.94	34.94	8042300.0
2023-06-02	AAC-DELISTED	Stock	10.5	10.5	10.48	10.49	18727.0
2023-06-02	AACG	Stock	1.47	1.52	1.47	1.49	14800.0
2023-06-02	AACIW-DELISTED	Stock	0.0899	0.09	0.0393	0.0409	11703.0
2023-06-02	AAIC-DELISTED	Stock	4.13	4.2	4.1	4.16	1357439.0
2023-06-02	AAIC.C-DELISTED	Stock	22.7	22.8412	22.3	22.6947	4140.0
2023-06-02	AAL	Stock	14.9	15.07	14.64	14.87	31041300.0
2023-06-02	AAM.A-DELISTED	Stock	23.97	24.65	23.77	24.55	40408.0
2023-06-02	AAM.B-DELISTED	Stock	24.26	24.9	23.7	24.6743	15347.0
2023-06-02	AAMC-DELISTED	Stock	28.2206	28.3353	27.65	27.9412	51524.0
2023-06-02	AAME	Stock	2.1	2.17	2.1	2.12	4700.0
2023-06-02	AAMI	Stock	22.67	22.99	22.4	22.59	191100.0
2023-06-02	AAN-DELISTED	Stock	12.47	12.93	12.44	12.89	298800.0
2023-06-02	AAOI	Stock	2.21	2.27	2.16	2.27	148200.0
2023-06-02	AAON	Stock	59.2133	61.12	59.1533	61.0533	365100.0
2023-06-02	AAP	Stock	68.47	68.98	66.27	67.56	7020500.0
2023-06-02	AAT	Stock	19.2	19.74	19.08	19.59	392800.0
2023-06-02	AATC	Stock	4.35	4.35	4.2	4.25	4484.0
2023-06-02	AAU-DELISTED	Stock	0.125	0.125	0.12	0.12	130215.0
2023-06-02	AAUAF-DELISTED	Stock	0.125	0.125	0.12	0.1202	131748.0
2023-06-02	AAXJ	Stock	66.91	67.235	66.91	67.04	522466.0
2023-06-02	AB	Stock	35.5	35.84	35.23	35.5	195200.0
2023-06-02	ABBNY-DELISTED	Stock	37.3395	37.42	37.16	37.27	440524.0
2023-06-02	ABBV	Stock	133.71	136.97	133.5	136.87	6661200.0
2023-06-02	ABC-DELISTED	Stock	172.96	175.34	172.37	174.52	1372769.0
2023-06-02	ABCB	Stock	33.23	34.94	32.88	34.61	463000.0
2023-06-02	ABCL	Stock	6.89	7.02	6.67	6.79	2357500.0
2023-06-02	ABCM-DELISTED	Stock	16.34	17.05	16.31	16.9	1249295.0
2023-06-02	ABEO	Stock	3.09	3.45	3.02	3.31	236500.0
2023-06-02	ABEV	Stock	2.86	2.92	2.84	2.9	14976400.0
2023-06-02	ABG	Stock	207.89	220.0	207.39	218.49	193300.0
2023-06-02	ABM	Stock	44.58	46.34	44.58	46.22	332500.0
2023-06-02	ABNB	Stock	112.93	118.45	112.93	118.06	10122000.0
2023-06-02	ABOS	Stock	5.0	5.298	4.82	5.17	183300.0
2023-06-02	ABR	Stock	13.04	13.62	13.04	13.44	4850300.0
2023-06-02	ABR.D	Stock	17.93	18.36	17.905	18.29	15673.0
2023-06-02	ABR.E	Stock	17.84	17.84	17.626	17.75	10210.0
2023-06-02	ABR.F	Stock	18.65	18.99	18.65	18.9	34155.0
2023-06-02	ABSI	Stock	1.86	1.89	1.82	1.88	490200.0

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

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