PREVIEW / stock_daily / 2023-05-18

all stock daily files

  file:    by_date/stock_daily/2023/2023-05-18.parquet
  size:    242 KB
  rows:    7,495
  symbols: 1,629

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-18	AAPL	Stock	173.0	175.24	172.58	175.05	65496700.0
2023-05-18	MSFT	Stock	314.53	319.04	313.72	318.52	27276000.0
2023-05-18	NVDA	Stock	30.41	31.828	30.32	31.678	748725000.0
2023-05-18	AMZN	Stock	116.69	118.6	116.34	118.15	73174100.0
2023-05-18	GOOGL	Stock	120.95	123.31	120.83	122.83	35234233.0
2023-05-18	META	Stock	241.3	247.09	241.19	246.85	22943300.0
2023-05-18	TSLA	Stock	174.22	177.06	172.45	176.89	109520300.0
2023-05-18	TLT	Stock	102.2	102.26	101.75	101.82	25536613.0
2023-05-18	ES	Stock	73.62	73.94	72.87	73.62	2210300.0
2023-05-18	CL	Stock	80.11	80.26	79.01	79.69	4043700.0
2023-05-18	A	Stock	127.65	129.33	126.49	129.14	1637000.0
2023-05-18	AA	Stock	36.29	36.93	35.67	36.81	3326300.0
2023-05-18	AAC-DELISTED	Stock	10.48	10.48	10.45	10.455	6095.0
2023-05-18	AACG	Stock	1.56	1.58	1.48	1.49	24600.0
2023-05-18	AAIC-DELISTED	Stock	2.59	2.5969	2.56	2.58	67869.0
2023-05-18	AAIC.C-DELISTED	Stock	21.2	21.21	21.2	21.21	599.0
2023-05-18	AAL	Stock	14.91	15.08	14.8	15.05	21604500.0
2023-05-18	AAM.A-DELISTED	Stock	23.08	24.05	23.08	24.05	4538.0
2023-05-18	AAM.B-DELISTED	Stock	23.9	23.9799	23.15	23.9799	3563.0
2023-05-18	AAMC-DELISTED	Stock	29.8588	30.3676	27.6765	29.3471	75626.0
2023-05-18	AAME	Stock	2.19	2.19	2.19	2.19	100.0
2023-05-18	AAMI	Stock	21.89	22.6	21.86	22.52	115800.0
2023-05-18	AAN-DELISTED	Stock	12.67	13.07	12.58	12.99	212300.0
2023-05-18	AAOI	Stock	1.74	1.758	1.71	1.75	104300.0
2023-05-18	AAON	Stock	60.9867	61.48	60.1067	61.0	960300.0
2023-05-18	AAP	Stock	121.26	122.11	119.29	121.48	737700.0
2023-05-18	AAT	Stock	18.63	18.89	18.44	18.84	332400.0
2023-05-18	AATC	Stock	4.11	4.15	4.11	4.15	613.0
2023-05-18	AAU-DELISTED	Stock	0.1174	0.12	0.113	0.115	95708.0
2023-05-18	AAUAF-DELISTED	Stock	0.1174	0.12	0.113	0.115	98168.0
2023-05-18	AAXJ	Stock	66.08	66.08	65.68	65.96	497588.0
2023-05-18	AB	Stock	33.85	35.02	33.85	34.89	245000.0
2023-05-18	ABB-DELISTED	Stock	37.01	37.0892	36.791	37.025	901007.0
2023-05-18	ABBNY-DELISTED	Stock	37.01	37.0892	36.791	37.03	1023913.0
2023-05-18	ABBV	Stock	142.61	143.56	141.98	143.44	4791200.0
2023-05-18	ABC-DELISTED	Stock	174.24	175.22	171.36	174.82	923974.0
2023-05-18	ABCB	Stock	31.86	32.28	31.34	31.94	678300.0
2023-05-18	ABCL	Stock	5.83	6.08	5.745	5.85	2763400.0
2023-05-18	ABCM-DELISTED	Stock	17.2	17.3	16.82	16.94	254349.0
2023-05-18	ABEO	Stock	2.97	3.05	2.91	2.99	61200.0
2023-05-18	ABEV	Stock	2.91	2.91	2.85	2.9	18159100.0
2023-05-18	ABG	Stock	205.22	208.97	204.2	208.76	111300.0
2023-05-18	ABM	Stock	44.37	44.96	44.03	44.25	398500.0
2023-05-18	ABNB	Stock	108.34	112.34	108.34	111.87	6945900.0
2023-05-18	ABOS	Stock	5.69	5.71	5.26	5.59	150600.0
2023-05-18	ABR	Stock	12.6	12.85	12.49	12.81	4275900.0
2023-05-18	ABR.D	Stock	17.35	17.35	17.04	17.18	6613.0
2023-05-18	ABR.E	Stock	16.84	16.8499	16.53	16.8	12438.0
2023-05-18	ABR.F	Stock	17.95	18.0909	17.95	18.08	12231.0
2023-05-18	ABSI	Stock	1.21	1.21	1.14	1.18	387900.0

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

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