PREVIEW / stock_daily / 2023-11-06

all stock daily files

  file:    by_date/stock_daily/2023/2023-11-06.parquet
  size:    234 KB
  rows:    7,368
  symbols: 1,319

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-11-06	AAPL	Stock	176.38	179.43	176.21	179.23	63841300.0
2023-11-06	MSFT	Stock	353.45	357.54	353.35	356.53	23828300.0
2023-11-06	NVDA	Stock	45.285	45.935	44.899	45.751	400733000.0
2023-11-06	AMZN	Stock	138.76	140.73	138.36	139.74	44970400.0
2023-11-06	GOOGL	Stock	129.05	130.34	128.67	130.25	19052740.0
2023-11-06	META	Stock	315.98	318.33	314.45	315.8	12887700.0
2023-11-06	TSLA	Stock	223.98	226.32	215.0	219.27	117335800.0
2023-11-06	TLT	Stock	87.07	87.2	86.6	86.78	41341870.0
2023-11-06	ES	Stock	54.83	56.61	54.69	56.56	5270700.0
2023-11-06	CL	Stock	74.86	75.44	74.72	75.21	4288100.0
2023-11-06	A	Stock	108.81	109.52	107.17	107.53	1412000.0
2023-11-06	AA	Stock	26.71	26.73	25.76	25.97	3869500.0
2023-11-06	AAC-DELISTED	Stock	10.77	10.79	10.77	10.79	597880.0
2023-11-06	AACG	Stock	1.05	1.1	0.91	0.91	3000.0
2023-11-06	AACT	Stock	10.32	10.32	10.32	10.32	3900.0
2023-11-06	AAIC-DELISTED	Stock	4.44	4.51	4.44	4.478	66648.0
2023-11-06	AAIC.C-DELISTED	Stock	23.95	23.95	23.94	23.94	300.0
2023-11-06	AAL	Stock	12.06	12.1	11.54	11.66	33159500.0
2023-11-06	AAMC-DELISTED	Stock	3.51	3.83	3.51	3.62	29100.0
2023-11-06	AAME	Stock	1.75	1.86	1.7	1.76	9100.0
2023-11-06	AAMI	Stock	16.62	16.745	16.39	16.58	199700.0
2023-11-06	AAN-DELISTED	Stock	7.49	7.59	7.3	7.53	309800.0
2023-11-06	AAOI	Stock	9.48	10.08	9.32	9.69	1889800.0
2023-11-06	AAON	Stock	57.41	57.89	56.7	57.69	469700.0
2023-11-06	AAP	Stock	57.06	58.18	56.56	56.66	1710400.0
2023-11-06	AAT	Stock	19.86	20.14	19.5	19.7	260500.0
2023-11-06	AATC	Stock	5.62	5.65	5.62	5.63	3593.0
2023-11-06	AAU-DELISTED	Stock	0.14	0.1425	0.135	0.1401	224507.0
2023-11-06	AAUAF-DELISTED	Stock	0.14	0.1425	0.135	0.1401	226436.0
2023-11-06	AAXJ	Stock	65.1	65.189	64.71	64.79	392786.0
2023-11-06	AB	Stock	28.35	28.5	27.95	28.32	343000.0
2023-11-06	ABAT	Stock	4.59	4.7	4.3501	4.45	175092.0
2023-11-06	ABBNY-DELISTED	Stock	34.71	34.76	34.48	34.59	184838.0
2023-11-06	ABBV	Stock	141.89	142.37	140.98	141.2	4377000.0
2023-11-06	ABCB	Stock	41.8	41.8	41.12	41.36	249900.0
2023-11-06	ABCL	Stock	4.64	4.78	4.44	4.475	1428900.0
2023-11-06	ABCM-DELISTED	Stock	23.22	23.29	23.17	23.28	2103341.0
2023-11-06	ABEO	Stock	4.44	4.71	4.32	4.42	80100.0
2023-11-06	ABEV	Stock	2.71	2.77	2.71	2.75	27468300.0
2023-11-06	ABG	Stock	208.15	208.15	201.92	204.29	104000.0
2023-11-06	ABLLW	Stock	0.3299	0.3396	0.28	0.3396	9073.0
2023-11-06	ABLV	Stock	1.93	1.96	1.86	1.95	14800.0
2023-11-06	ABM	Stock	40.74	40.93	40.05	40.24	513700.0
2023-11-06	ABNB	Stock	123.215	123.93	116.85	118.17	7702000.0
2023-11-06	ABOS	Stock	2.2	2.25	2.06	2.08	616100.0
2023-11-06	ABR	Stock	12.95	13.06	12.37	12.43	7065400.0
2023-11-06	ABR.D	Stock	16.23	16.3099	16.08	16.09	45811.0
2023-11-06	ABR.E	Stock	16.5	16.6899	16.2	16.2	4703.0
2023-11-06	ABR.F	Stock	17.98	17.98	17.6	17.6	7490.0
2023-11-06	ABSI	Stock	1.46	1.485	1.335	1.34	317800.0

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

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