PREVIEW / stock_daily / 2023-01-13

all stock daily files

  file:    by_date/stock_daily/2023/2023-01-13.parquet
  size:    249 KB
  rows:    7,711
  symbols: 1,914

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-01-13	AAPL	Stock	132.03	134.92	131.66	134.76	57809700.0
2023-01-13	MSFT	Stock	237.0	239.37	234.92	239.23	21333300.0
2023-01-13	NVDA	Stock	16.278	16.922	16.165	16.899	447287000.0
2023-01-13	AMZN	Stock	94.18	98.37	94.12	98.12	85549400.0
2023-01-13	GOOGL	Stock	90.85	92.19	90.1299	92.12	26329212.0
2023-01-13	META	Stock	134.97	137.39	134.84	136.98	22423800.0
2023-01-13	TSLA	Stock	116.55	122.63	115.6	122.4	180714100.0
2023-01-13	TLT	Stock	107.1	107.8	106.38	106.75	17750775.0
2023-01-13	ES	Stock	84.69	84.79	83.06	84.02	1726100.0
2023-01-13	CL	Stock	76.69	78.0	76.57	77.85	3800100.0
2023-01-13	A	Stock	155.54	157.28	154.5	156.92	921700.0
2023-01-13	AA	Stock	52.84	55.02	52.45	54.61	4697000.0
2023-01-13	AAC-DELISTED	Stock	10.12	10.14	10.12	10.13	11835.0
2023-01-13	AACG	Stock	1.38	1.38	1.37	1.37	600.0
2023-01-13	AACIW-DELISTED	Stock	0.1	0.1	0.06	0.07	13597.0
2023-01-13	AAIC-DELISTED	Stock	3.0	3.03	2.995	3.02	81455.0
2023-01-13	AAIC.C-DELISTED	Stock	21.6	21.6	21.5	21.5	500.0
2023-01-13	AAL	Stock	16.22	17.07	16.01	17.02	50828000.0
2023-01-13	AAM.A-DELISTED	Stock	24.2966	24.78	24.2	24.2	10079.0
2023-01-13	AAM.B-DELISTED	Stock	24.36	24.777	24.36	24.4	2228.0
2023-01-13	AAMC-DELISTED	Stock	7.7059	8.2353	7.4623	8.2353	40181.0
2023-01-13	AAME	Stock	2.52	2.52	2.51	2.51	1100.0
2023-01-13	AAMI	Stock	20.97	21.54	20.664	21.43	98900.0
2023-01-13	AAN-DELISTED	Stock	14.07	14.44	14.07	14.35	199700.0
2023-01-13	AAOI	Stock	2.33	2.465	2.32	2.43	163600.0
2023-01-13	AAON	Stock	50.6733	52.1867	50.6733	51.9133	161700.0
2023-01-13	AAP	Stock	150.35	152.0	149.75	151.03	832700.0
2023-01-13	AAT	Stock	27.51	27.74	27.46	27.64	214100.0
2023-01-13	AATC	Stock	3.8	3.85	3.8	3.85	35291.0
2023-01-13	AAU-DELISTED	Stock	0.243	0.25	0.243	0.2449	325168.0
2023-01-13	AAUAF-DELISTED	Stock	0.243	0.25	0.243	0.2451	329556.0
2023-01-13	AAWW-DELISTED	Stock	101.82	101.96	101.74	101.75	257192.0
2023-01-13	AAXJ	Stock	70.16	70.795	70.16	70.75	942792.0
2023-01-13	AB	Stock	38.95	39.2	38.01	39.03	262600.0
2023-01-13	ABB-DELISTED	Stock	33.28	33.66	33.26	33.59	680352.0
2023-01-13	ABBNY-DELISTED	Stock	33.28	33.66	33.26	33.58	775748.0
2023-01-13	ABBV	Stock	152.09	153.81	151.34	153.6	6019300.0
2023-01-13	ABC-DELISTED	Stock	164.32	166.01	164.16	164.26	975222.0
2023-01-13	ABCB	Stock	48.44	49.57	47.7	49.32	287600.0
2023-01-13	ABCL	Stock	10.07	10.65	10.07	10.38	1620900.0
2023-01-13	ABCM-DELISTED	Stock	15.45	15.755	15.19	15.535	773313.0
2023-01-13	ABEO	Stock	2.68	2.75	2.64	2.65	225400.0
2023-01-13	ABEV	Stock	2.7	2.74	2.68	2.71	30224200.0
2023-01-13	ABG	Stock	189.7	191.48	185.89	189.05	139700.0
2023-01-13	ABM	Stock	45.44	46.54	45.37	46.36	348200.0
2023-01-13	ABNB	Stock	97.5	100.7	97.42	100.37	6529000.0
2023-01-13	ABOS	Stock	5.87	6.24	5.87	6.24	43600.0
2023-01-13	ABR	Stock	14.01	14.33	14.01	14.3	1066900.0
2023-01-13	ABR.D	Stock	19.885	20.13	19.85	20.0895	11395.0
2023-01-13	ABR.E	Stock	18.59	19.0	18.59	19.0	12359.0

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

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