PREVIEW / stock_daily / 2023-05-03

all stock daily files

  file:    by_date/stock_daily/2023/2023-05-03.parquet
  size:    242 KB
  rows:    7,528
  symbols: 1,633

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-03	AAPL	Stock	169.5	170.92	167.16	167.45	65136000.0
2023-05-03	MSFT	Stock	306.62	308.61	304.09	304.4	22360800.0
2023-05-03	NVDA	Stock	27.84	28.367	27.472	27.802	383387000.0
2023-05-03	AMZN	Stock	103.74	105.96	103.28	103.65	65051900.0
2023-05-03	GOOGL	Stock	105.53	107.49	104.96	105.41	21795405.0
2023-05-03	META	Stock	239.47	241.75	232.75	237.03	34463900.0
2023-05-03	TSLA	Stock	160.01	165.0	159.91	160.61	119728000.0
2023-05-03	TLT	Stock	106.0	106.6	105.275	106.29	23656168.0
2023-05-03	ES	Stock	77.26	77.49	76.2	76.64	1797800.0
2023-05-03	CL	Stock	80.8	81.83	80.62	81.26	6380000.0
2023-05-03	A	Stock	135.89	136.54	134.63	134.77	1529100.0
2023-05-03	AA	Stock	35.61	36.25	34.86	35.02	3564600.0
2023-05-03	AAC-DELISTED	Stock	10.37	10.39	10.37	10.39	130598.0
2023-05-03	AACG	Stock	1.91	1.92	1.86	1.89	12300.0
2023-05-03	AACIW-DELISTED	Stock	0.105	0.105	0.105	0.105	100.0
2023-05-03	AAIC-DELISTED	Stock	2.56	2.59	2.56	2.58	40220.0
2023-05-03	AAIC.C-DELISTED	Stock	20.86	21.0	20.725	21.0	4200.0
2023-05-03	AAL	Stock	13.79	14.04	13.68	13.79	20844800.0
2023-05-03	AAM.A-DELISTED	Stock	24.49	24.83	23.835	23.87	29809.0
2023-05-03	AAM.B-DELISTED	Stock	24.85	25.11	23.9	23.9	5369.0
2023-05-03	AAMC-DELISTED	Stock	26.9118	26.9118	25.0441	25.0441	25031.0
2023-05-03	AAME	Stock	2.18	2.28	2.18	2.19	2800.0
2023-05-03	AAMI	Stock	22.18	22.52	21.98	22.37	211700.0
2023-05-03	AAN-DELISTED	Stock	12.35	12.5	12.11	12.12	259200.0
2023-05-03	AAOI	Stock	1.83	1.86	1.78	1.79	385700.0
2023-05-03	AAON	Stock	65.6067	66.3067	64.76	65.0333	476100.0
2023-05-03	AAP	Stock	124.49	126.28	123.79	123.8	1056800.0
2023-05-03	AAT	Stock	17.86	18.25	17.59	17.77	739200.0
2023-05-03	AATC	Stock	3.875	3.91	3.86	3.9	1935.0
2023-05-03	AAU-DELISTED	Stock	0.1177	0.1269	0.1162	0.118	148628.0
2023-05-03	AAUAF-DELISTED	Stock	0.1177	0.1269	0.1162	0.1225	151403.0
2023-05-03	AAXJ	Stock	65.85	66.21	65.72	65.76	341327.0
2023-05-03	AB	Stock	33.78	34.48	33.44	33.56	167500.0
2023-05-03	ABB-DELISTED	Stock	36.11	36.38	35.95	35.96	1602231.0
2023-05-03	ABBNY-DELISTED	Stock	36.11	36.38	35.95	35.96	1741844.0
2023-05-03	ABBV	Stock	151.07	151.51	148.45	149.25	6815300.0
2023-05-03	ABC-DELISTED	Stock	169.7	170.63	166.2598	166.89	792774.0
2023-05-03	ABCB	Stock	31.16	32.31	30.54	30.76	588100.0
2023-05-03	ABCL	Stock	6.53	6.71	6.43	6.59	1619100.0
2023-05-03	ABCM-DELISTED	Stock	17.53	17.93	17.3954	17.55	737621.0
2023-05-03	ABEO	Stock	3.3	3.33	3.06	3.1	107100.0
2023-05-03	ABEV	Stock	2.84	2.91	2.84	2.88	18940700.0
2023-05-03	ABG	Stock	195.7	198.5	190.84	191.82	290300.0
2023-05-03	ABM	Stock	42.2	42.78	42.0	42.05	217500.0
2023-05-03	ABNB	Stock	120.85	121.19	117.97	118.86	3687700.0
2023-05-03	ABOS	Stock	3.89	4.65	3.89	3.98	992300.0
2023-05-03	ABR	Stock	11.3	11.52	11.02	11.02	4007600.0
2023-05-03	ABR.D	Stock	17.99	17.99	17.67	17.7	24070.0
2023-05-03	ABR.E	Stock	17.62	17.8	17.62	17.712	4542.0
2023-05-03	ABR.F	Stock	18.22	18.22	17.75	17.75	24749.0

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

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