PREVIEW / stock_daily / 2023-05-31

all stock daily files

  file:    by_date/stock_daily/2023/2023-05-31.parquet
  size:    242 KB
  rows:    7,508
  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-05-31	AAPL	Stock	177.33	179.35	176.76	177.25	99625300.0
2023-05-31	MSFT	Stock	332.29	335.94	327.33	328.39	45950600.0
2023-05-31	NVDA	Stock	39.488	40.295	37.822	37.834	1002580000.0
2023-05-31	AMZN	Stock	121.45	122.04	119.17	120.58	72800800.0
2023-05-31	GOOGL	Stock	122.75	124.0601	122.5	122.87	37325787.0
2023-05-31	META	Stock	260.0	265.0	258.45	264.72	25473700.0
2023-05-31	TSLA	Stock	199.78	203.95	195.12	203.93	150711700.0
2023-05-31	TLT	Stock	101.99	103.18	101.87	102.99	23787034.0
2023-05-31	ES	Stock	68.16	69.83	67.9	69.23	3574800.0
2023-05-31	CL	Stock	75.14	75.22	74.3	74.38	19133300.0
2023-05-31	A	Stock	116.99	117.15	114.8	115.67	3998800.0
2023-05-31	AA	Stock	32.5	32.697	31.14	31.72	6457600.0
2023-05-31	AAC-DELISTED	Stock	10.48	10.49	10.47	10.49	2582990.0
2023-05-31	AACG	Stock	1.49	1.54	1.49	1.49	9300.0
2023-05-31	AACIW-DELISTED	Stock	0.08	0.09	0.08	0.09	290.0
2023-05-31	AAIC-DELISTED	Stock	4.05	4.14	4.04	4.09	650095.0
2023-05-31	AAIC.C-DELISTED	Stock	22.5	22.7418	21.84	22.2	6082.0
2023-05-31	AAL	Stock	15.09	15.11	14.49	14.78	31783200.0
2023-05-31	AAM.A-DELISTED	Stock	23.59	24.03	23.59	23.6	35203.0
2023-05-31	AAM.B-DELISTED	Stock	23.37	24.0	23.1128	23.99	36415.0
2023-05-31	AAMC-DELISTED	Stock	29.2912	29.5853	28.2676	28.6824	36295.0
2023-05-31	AAME	Stock	2.1	2.14	2.1	2.14	6200.0
2023-05-31	AAMI	Stock	21.78	22.1	21.31	21.49	218300.0
2023-05-31	AAN-DELISTED	Stock	12.39	12.395	12.05	12.24	257200.0
2023-05-31	AAOI	Stock	2.32	2.44	2.191	2.22	341300.0
2023-05-31	AAON	Stock	58.6667	58.9067	57.32	57.74	614100.0
2023-05-31	AAP	Stock	79.23	80.81	72.6	72.89	21832300.0
2023-05-31	AAT	Stock	19.1	19.28	19.0	19.05	744500.0
2023-05-31	AATC	Stock	4.17	4.26	4.17	4.26	539.0
2023-05-31	AAU-DELISTED	Stock	0.12	0.1237	0.1198	0.12	230127.0
2023-05-31	AAUAF-DELISTED	Stock	0.12	0.1237	0.12	0.12	243518.0
2023-05-31	AAXJ	Stock	64.74	64.83	64.26	64.81	892839.0
2023-05-31	AB	Stock	34.67	34.83	34.03	34.77	198000.0
2023-05-31	ABBNY-DELISTED	Stock	36.95	37.07	36.21	36.45	666604.0
2023-05-31	ABBV	Stock	136.62	138.71	135.77	137.96	12579100.0
2023-05-31	ABC-DELISTED	Stock	163.96	170.81	163.37	170.15	2847109.0
2023-05-31	ABCB	Stock	32.22	32.22	30.85	31.56	573300.0
2023-05-31	ABCL	Stock	6.97	7.15	6.81	6.97	2709100.0
2023-05-31	ABCM-DELISTED	Stock	16.26	16.65	16.12	16.145	973326.0
2023-05-31	ABEO	Stock	3.08	3.1	2.99	3.09	58700.0
2023-05-31	ABEV	Stock	2.81	2.82	2.76	2.79	19068400.0
2023-05-31	ABG	Stock	212.23	214.9	207.32	209.11	474200.0
2023-05-31	ABM	Stock	44.92	44.96	43.99	44.16	342900.0
2023-05-31	ABNB	Stock	105.6	110.095	103.74	109.77	10263100.0
2023-05-31	ABOS	Stock	5.05	5.05	4.77	4.93	65000.0
2023-05-31	ABR	Stock	12.65	12.78	12.46	12.61	2618400.0
2023-05-31	ABR.D	Stock	17.41	18.37	17.4048	18.25	71427.0
2023-05-31	ABR.E	Stock	17.38	17.97	17.28	17.97	35671.0
2023-05-31	ABR.F	Stock	18.31	18.74	18.16	18.74	103477.0
2023-05-31	ABSI	Stock	1.94	1.94	1.81	1.9	628200.0

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

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