PREVIEW / stock_daily / 2023-07-13

all stock daily files

  file:    by_date/stock_daily/2023/2023-07-13.parquet
  size:    242 KB
  rows:    7,513
  symbols: 1,572

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-07-13	AAPL	Stock	190.5	191.19	189.78	190.54	41342300.0
2023-07-13	MSFT	Stock	339.56	343.74	339.02	342.66	20567200.0
2023-07-13	NVDA	Stock	44.518	46.155	44.492	45.977	478204000.0
2023-07-13	AMZN	Stock	134.04	134.67	132.71	134.3	61170900.0
2023-07-13	GOOGL	Stock	120.93	124.83	120.45	124.54	44297915.0
2023-07-13	META	Stock	313.62	316.24	310.29	313.41	30281000.0
2023-07-13	TSLA	Stock	274.59	279.45	270.6	277.9	112681500.0
2023-07-13	TLT	Stock	101.31	101.97	101.03	101.89	32441493.0
2023-07-13	ES	Stock	72.26	73.18	72.05	73.04	2208700.0
2023-07-13	CL	Stock	75.39	76.03	75.03	75.86	4346200.0
2023-07-13	A	Stock	120.76	120.87	118.99	119.35	1229800.0
2023-07-13	AA	Stock	35.7	37.17	35.55	36.69	5835900.0
2023-07-13	AAC-DELISTED	Stock	10.58	10.58	10.57	10.58	122479.0
2023-07-13	AACG	Stock	1.42	1.62	1.42	1.51	22200.0
2023-07-13	AACIW-DELISTED	Stock	0.0666	0.0786	0.0468	0.064	36913.0
2023-07-13	AACT	Stock	10.16	10.16	10.16	10.16	115100.0
2023-07-13	AAIC-DELISTED	Stock	4.65	4.755	4.65	4.68	314689.0
2023-07-13	AAIC.C-DELISTED	Stock	23.2	23.3	23.2	23.262	1700.0
2023-07-13	AAL	Stock	19.05	19.08	18.24	18.45	30683600.0
2023-07-13	AAM.A-DELISTED	Stock	22.88	23.39	22.7801	23.15	6916.0
2023-07-13	AAM.B-DELISTED	Stock	23.0	23.18	22.64	22.9528	5022.0
2023-07-13	AAMC-DELISTED	Stock	36.2353	36.2353	32.0824	32.3235	38080.0
2023-07-13	AAME	Stock	1.92	1.96	1.81	1.86	39600.0
2023-07-13	AAMI	Stock	21.7	22.09	21.57	21.97	301700.0
2023-07-13	AAN-DELISTED	Stock	14.48	15.15	14.27	15.0	326500.0
2023-07-13	AAOI	Stock	9.5	11.48	9.49	10.66	7110300.0
2023-07-13	AAON	Stock	65.0067	65.4133	64.08	64.9333	254700.0
2023-07-13	AAP	Stock	70.65	71.08	69.85	70.66	1960000.0
2023-07-13	AAT	Stock	20.56	20.87	20.48	20.87	253200.0
2023-07-13	AATC	Stock	4.42	4.42	4.375	4.41	5419.0
2023-07-13	AAU-DELISTED	Stock	0.14	0.1489	0.14	0.1451	216482.0
2023-07-13	AAUAF-DELISTED	Stock	0.14	0.1489	0.14	0.1489	179520.0
2023-07-13	AAXJ	Stock	68.85	69.37	68.73	69.23	1737024.0
2023-07-13	AB	Stock	32.72	34.53	32.72	34.24	492500.0
2023-07-13	ABBNY-DELISTED	Stock	39.47	39.7	39.45	39.52	161251.0
2023-07-13	ABBV	Stock	132.93	134.1	132.7	133.59	4631800.0
2023-07-13	ABC-DELISTED	Stock	190.9	192.81	190.9	191.25	875369.0
2023-07-13	ABCB	Stock	36.52	37.28	36.21	37.2	426500.0
2023-07-13	ABCL	Stock	7.53	7.63	7.18	7.42	4167000.0
2023-07-13	ABCM-DELISTED	Stock	24.0	24.37	23.765	23.89	933977.0
2023-07-13	ABEO	Stock	3.98	4.08	3.94	3.99	364200.0
2023-07-13	ABEV	Stock	3.05	3.07	3.04	3.06	10646600.0
2023-07-13	ABG	Stock	251.51	254.0	248.03	248.3	283200.0
2023-07-13	ABLLW	Stock	0.33	0.3997	0.3118	0.3153	160797.0
2023-07-13	ABM	Stock	42.6	43.01	42.13	42.54	432900.0
2023-07-13	ABNB	Stock	138.96	140.6	137.3	140.09	5532300.0
2023-07-13	ABOS	Stock	6.21	6.477	5.85	6.12	574400.0
2023-07-13	ABR	Stock	15.85	15.95	15.72	15.9	2470600.0
2023-07-13	ABR.D	Stock	18.53	18.65	18.48	18.59	37790.0
2023-07-13	ABR.E	Stock	18.15	18.29	18.0307	18.21	20442.0

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

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