PREVIEW / stock_daily / 2023-06-09

all stock daily files

  file:    by_date/stock_daily/2023/2023-06-09.parquet
  size:    241 KB
  rows:    7,492
  symbols: 1,610

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-06-09	AAPL	Stock	181.5	182.23	180.63	180.96	48870700.0
2023-06-09	MSFT	Stock	324.99	329.99	324.41	326.79	22514900.0
2023-06-09	NVDA	Stock	39.037	39.711	38.567	38.77	427717000.0
2023-06-09	AMZN	Stock	124.08	125.8	123.19	123.43	51330000.0
2023-06-09	GOOGL	Stock	122.25	123.755	121.91	122.23	23778319.0
2023-06-09	META	Stock	262.48	267.95	261.7	264.95	16938500.0
2023-06-09	TSLA	Stock	249.07	252.42	242.02	244.4	199882300.0
2023-06-09	TLT	Stock	101.6	102.265	101.34	101.92	22148561.0
2023-06-09	ES	Stock	71.72	71.8	70.33	70.37	1620200.0
2023-06-09	CL	Stock	75.46	76.06	75.33	75.84	3186700.0
2023-06-09	A	Stock	115.58	116.0	114.16	115.79	1981500.0
2023-06-09	AA	Stock	35.61	35.83	34.83	35.23	3071100.0
2023-06-09	AAC-DELISTED	Stock	10.49	10.5	10.49	10.5	17150.0
2023-06-09	AACG	Stock	1.5	1.5	1.23	1.29	31800.0
2023-06-09	AACIU	Stock	10.23	10.2353	10.23	10.2353	803.0
2023-06-09	AACIW-DELISTED	Stock	0.0701	0.0701	0.06	0.06	519.0
2023-06-09	AAIC-DELISTED	Stock	4.31	4.315	4.2699	4.295	183966.0
2023-06-09	AAIC.C-DELISTED	Stock	22.9	22.9	22.89	22.89	481.0
2023-06-09	AAL	Stock	15.31	15.67	15.31	15.57	21126900.0
2023-06-09	AAM.A-DELISTED	Stock	24.08	24.34	24.05	24.26	8475.0
2023-06-09	AAM.B-DELISTED	Stock	24.45	24.45	23.7295	24.45	3287.0
2023-06-09	AAMC-DELISTED	Stock	26.9088	27.0588	23.5882	24.4971	66079.0
2023-06-09	AAME	Stock	2.15	2.16	2.15	2.16	700.0
2023-06-09	AAMI	Stock	22.74	23.15	22.56	22.78	178500.0
2023-06-09	AAN-DELISTED	Stock	14.37	14.39	13.873	13.98	240000.0
2023-06-09	AAOI	Stock	3.25	3.3	3.16	3.21	836400.0
2023-06-09	AAON	Stock	63.42	64.3267	62.9733	63.68	798150.0
2023-06-09	AAP	Stock	64.65	64.88	63.56	63.58	3300100.0
2023-06-09	AAT	Stock	19.71	19.96	19.52	19.84	284800.0
2023-06-09	AATC	Stock	4.22	4.27	4.21	4.27	6764.0
2023-06-09	AAU-DELISTED	Stock	0.13	0.13	0.125	0.126	148318.0
2023-06-09	AAUAF-DELISTED	Stock	0.13	0.13	0.125	0.126	141427.0
2023-06-09	AAXJ	Stock	67.24	67.56	67.2	67.23	334192.0
2023-06-09	AB	Stock	34.57	34.76	34.22	34.35	121400.0
2023-06-09	ABBNY-DELISTED	Stock	38.0	38.26	37.91	38.25	361434.0
2023-06-09	ABBV	Stock	137.56	139.19	137.08	138.18	4359500.0
2023-06-09	ABC-DELISTED	Stock	176.62	178.27	175.99	178.19	518267.0
2023-06-09	ABCB	Stock	36.57	36.85	35.26	35.64	419300.0
2023-06-09	ABCL	Stock	7.19	7.23	6.99	7.09	2599600.0
2023-06-09	ABCM-DELISTED	Stock	16.09	17.01	15.95	16.8	3615412.0
2023-06-09	ABEO	Stock	4.38	4.38	3.79	4.25	623100.0
2023-06-09	ABEV	Stock	3.02	3.1	3.01	3.1	15043300.0
2023-06-09	ABG	Stock	232.53	232.53	224.82	226.26	121400.0
2023-06-09	ABM	Stock	47.11	47.11	46.03	46.38	367700.0
2023-06-09	ABNB	Stock	120.25	122.74	117.45	117.86	7427200.0
2023-06-09	ABOS	Stock	4.91	4.97	4.76	4.85	122700.0
2023-06-09	ABR	Stock	14.08	14.17	13.92	14.09	1687900.0
2023-06-09	ABR.D	Stock	18.2501	18.45	18.2501	18.39	3615.0
2023-06-09	ABR.E	Stock	17.7475	17.81	17.68	17.6999	4954.0
2023-06-09	ABR.F	Stock	18.66	19.0673	18.66	18.8	6553.0

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

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