PREVIEW / stock_daily / 2023-05-26

all stock daily files

  file:    by_date/stock_daily/2023/2023-05-26.parquet
  size:    242 KB
  rows:    7,520
  symbols: 1,639

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-26	AAPL	Stock	173.32	175.77	173.11	175.43	54835000.0
2023-05-26	MSFT	Stock	324.02	333.4	323.88	332.89	36630600.0
2023-05-26	NVDA	Stock	37.89	39.17	37.55	38.946	714397000.0
2023-05-26	AMZN	Stock	116.04	121.5	116.02	120.11	96779900.0
2023-05-26	GOOGL	Stock	123.17	125.26	122.45	124.61	35635937.0
2023-05-26	META	Stock	252.93	262.31	252.71	262.04	25727200.0
2023-05-26	TSLA	Stock	184.62	198.6	184.53	193.17	162061500.0
2023-05-26	TLT	Stock	100.12	101.1733	100.0	101.09	17030266.0
2023-05-26	ES	Stock	70.08	70.3	67.93	68.69	3965800.0
2023-05-26	CL	Stock	76.2	76.72	76.14	76.21	5750000.0
2023-05-26	A	Stock	120.07	120.72	118.38	120.42	2089100.0
2023-05-26	AA	Stock	34.59	34.79	33.61	33.69	5876800.0
2023-05-26	AAC-DELISTED	Stock	10.49	10.5	10.47	10.47	26917.0
2023-05-26	AACG	Stock	1.5	1.54	1.48	1.5	11200.0
2023-05-26	AAIC-DELISTED	Stock	2.69	2.8	2.69	2.76	62222.0
2023-05-26	AAIC.C-DELISTED	Stock	21.745	22.3899	21.1	22.3899	2017.0
2023-05-26	AAL	Stock	14.41	14.54	14.28	14.35	17083800.0
2023-05-26	AAM.A-DELISTED	Stock	23.81	23.83	23.58	23.6612	4887.0
2023-05-26	AAM.B-DELISTED	Stock	24.27	24.42	23.32	23.77	11075.0
2023-05-26	AAMC-DELISTED	Stock	28.6765	29.5588	28.5294	28.7441	25718.0
2023-05-26	AAME	Stock	2.13	2.15	2.13	2.15	400.0
2023-05-26	AAMI	Stock	21.57	22.14	21.57	21.86	68500.0
2023-05-26	AAN-DELISTED	Stock	12.37	12.63	12.25	12.59	115000.0
2023-05-26	AAOI	Stock	1.78	1.909	1.76	1.9	274500.0
2023-05-26	AAON	Stock	59.9467	60.56	59.4067	60.1267	292350.0
2023-05-26	AAP	Stock	110.92	112.2	109.76	112.15	1443000.0
2023-05-26	AAT	Stock	18.93	19.05	18.7	18.97	378400.0
2023-05-26	AATC	Stock	4.37	4.62	4.33	4.48	19529.0
2023-05-26	AAU-DELISTED	Stock	0.12	0.1235	0.12	0.1201	152867.0
2023-05-26	AAUAF-DELISTED	Stock	0.12	0.1235	0.12	0.1201	158110.0
2023-05-26	AAXJ	Stock	65.4	66.18	65.4	66.1	1255078.0
2023-05-26	AB	Stock	33.45	34.86	33.4	34.34	213600.0
2023-05-26	ABBNY-DELISTED	Stock	36.94	37.25	36.93	37.08	578002.0
2023-05-26	ABBV	Stock	138.72	139.85	137.1	137.56	7590300.0
2023-05-26	ABC-DELISTED	Stock	169.91	171.25	168.19	168.42	682169.0
2023-05-26	ABCB	Stock	32.18	32.57	31.55	32.51	180300.0
2023-05-26	ABCL	Stock	6.93	6.96	6.35	6.8	4894300.0
2023-05-26	ABCM-DELISTED	Stock	16.3	16.53	15.91	16.36	1018662.0
2023-05-26	ABEO	Stock	3.15	3.22	3.09	3.14	98500.0
2023-05-26	ABEV	Stock	2.94	2.95	2.89	2.91	10736600.0
2023-05-26	ABG	Stock	210.04	214.07	206.09	212.6	169000.0
2023-05-26	ABM	Stock	43.09	44.85	42.99	44.64	505100.0
2023-05-26	ABNB	Stock	105.18	107.615	104.99	106.81	4677600.0
2023-05-26	ABOS	Stock	4.88	4.98	4.697	4.81	82000.0
2023-05-26	ABR	Stock	12.28	12.82	12.23	12.64	2907700.0
2023-05-26	ABR.D	Stock	17.11	17.26	17.11	17.15	9848.0
2023-05-26	ABR.E	Stock	16.8	16.9399	16.46	16.805	2622.0
2023-05-26	ABR.F	Stock	17.9	17.9435	17.84	17.865	8757.0
2023-05-26	ABSI	Stock	1.61	1.77	1.581	1.71	548600.0
2023-05-26	ABST-DELISTED	Stock	11.37	11.42	11.37	11.4	429358.0

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

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