PREVIEW / stock_daily / 2023-10-06

all stock daily files

  file:    by_date/stock_daily/2023/2023-10-06.parquet
  size:    234 KB
  rows:    7,362
  symbols: 1,371

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-10-06	AAPL	Stock	173.8	177.99	173.18	177.49	57224100.0
2023-10-06	MSFT	Stock	316.55	329.19	316.3	327.26	25645500.0
2023-10-06	NVDA	Stock	44.193	45.789	44.026	45.762	434436000.0
2023-10-06	AMZN	Stock	124.16	128.45	124.13	127.96	46795900.0
2023-10-06	GOOGL	Stock	134.01	138.155	134.01	137.58	27597598.0
2023-10-06	META	Stock	301.44	316.31	300.91	315.43	21784000.0
2023-10-06	TSLA	Stock	253.98	261.65	250.65	260.53	117947000.0
2023-10-06	TLT	Stock	84.2	85.685	84.06	84.79	62787857.0
2023-10-06	ES	Stock	54.45	55.98	53.1	55.81	3080800.0
2023-10-06	CL	Stock	69.01	69.57	67.62	69.43	6481000.0
2023-10-06	A	Stock	109.49	111.77	109.36	110.64	1796100.0
2023-10-06	AA	Stock	26.57	27.5	26.13	27.15	6242500.0
2023-10-06	AAC-DELISTED	Stock	10.75	10.76	10.74	10.76	1344904.0
2023-10-06	AACG	Stock	1.1	1.14	1.1	1.1	3800.0
2023-10-06	AAIC-DELISTED	Stock	4.29	4.31	4.23	4.28	65130.0
2023-10-06	AAIC.C-DELISTED	Stock	23.38	23.38	23.38	23.38	150.0
2023-10-06	AAL	Stock	12.8	13.0	12.67	12.76	31822200.0
2023-10-06	AAMC-DELISTED	Stock	4.0059	4.1059	3.9353	3.9353	12750.0
2023-10-06	AAME	Stock	1.83	1.92	1.81	1.81	8400.0
2023-10-06	AAMI	Stock	18.15	18.32	17.76	17.95	179300.0
2023-10-06	AAN-DELISTED	Stock	9.74	9.85	9.59	9.79	286500.0
2023-10-06	AAOI	Stock	8.77	9.42	8.77	9.08	1068800.0
2023-10-06	AAON	Stock	55.5	57.5	55.5	57.28	284300.0
2023-10-06	AAP	Stock	52.22	53.41	51.78	51.99	1780700.0
2023-10-06	AAT	Stock	18.2	18.38	17.64	18.19	232000.0
2023-10-06	AATC	Stock	5.75	5.75	5.6	5.73	2681.0
2023-10-06	AAU-DELISTED	Stock	0.137	0.137	0.1305	0.131	84328.0
2023-10-06	AAUAF-DELISTED	Stock	0.137	0.137	0.1305	0.131	86789.0
2023-10-06	AAXJ	Stock	62.87	63.8801	62.83	63.75	297816.0
2023-10-06	AB	Stock	30.7	31.08	30.18	30.92	400900.0
2023-10-06	ABAT	Stock	7.16	7.3	7.05	7.15	103810.0
2023-10-06	ABBNY-DELISTED	Stock	35.87	36.65	35.72	36.52	571833.0
2023-10-06	ABBV	Stock	146.49	149.33	146.12	148.24	5370100.0
2023-10-06	ABCB	Stock	37.38	38.71	37.03	38.28	269300.0
2023-10-06	ABCL	Stock	4.4	4.475	4.35	4.42	712500.0
2023-10-06	ABCM-DELISTED	Stock	22.74	22.77	22.64	22.67	7261130.0
2023-10-06	ABEO	Stock	4.35	4.4	4.11	4.15	167800.0
2023-10-06	ABEV	Stock	2.46	2.56	2.43	2.54	21619100.0
2023-10-06	ABG	Stock	206.8	214.85	206.8	210.88	159200.0
2023-10-06	ABLLW	Stock	0.38	0.3974	0.3342	0.3925	17700.0
2023-10-06	ABLV	Stock	3.298	3.298	3.18	3.19	2300.0
2023-10-06	ABM	Stock	40.6	41.49	40.47	41.31	459600.0
2023-10-06	ABNB	Stock	123.0	127.4	122.02	126.36	5152300.0
2023-10-06	ABOS	Stock	4.41	4.6	4.37	4.405	469700.0
2023-10-06	ABR	Stock	13.65	14.0	13.54	13.68	4923200.0
2023-10-06	ABR.D	Stock	17.3473	17.55	17.18	17.2	21263.0
2023-10-06	ABR.E	Stock	16.75	17.6047	16.7482	17.6047	2891.0
2023-10-06	ABR.F	Stock	18.0	18.349	17.96	18.265	13407.0
2023-10-06	ABSI	Stock	1.37	1.39	1.303	1.38	248500.0
2023-10-06	ABT	Stock	95.81	97.51	95.45	96.88	4790500.0

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

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