PREVIEW / stock_daily / 2023-10-27

all stock daily files

  file:    by_date/stock_daily/2023/2023-10-27.parquet
  size:    233 KB
  rows:    7,348
  symbols: 1,359

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-27	AAPL	Stock	166.91	168.96	166.83	168.22	58499100.0
2023-10-27	MSFT	Stock	330.43	336.72	328.4	329.81	29856500.0
2023-10-27	NVDA	Stock	41.13	41.206	40.015	40.5	416784000.0
2023-10-27	AMZN	Stock	126.2	130.02	125.52	127.74	125309300.0
2023-10-27	GOOGL	Stock	122.88	123.31	120.2057	122.17	44566506.0
2023-10-27	META	Stock	294.48	299.31	292.97	296.73	29596300.0
2023-10-27	TSLA	Stock	210.6	212.41	205.77	207.3	94881200.0
2023-10-27	TLT	Stock	84.19	84.97	83.74	84.37	32362270.0
2023-10-27	ES	Stock	54.0	54.59	52.98	53.16	2296800.0
2023-10-27	CL	Stock	73.31	74.55	71.47	71.79	12666500.0
2023-10-27	A	Stock	104.54	104.78	102.4	102.77	2004000.0
2023-10-27	AA	Stock	23.975	24.11	23.17	23.51	6325000.0
2023-10-27	AAC-DELISTED	Stock	9.75	9.7999	9.4401	9.6	69684.0
2023-10-27	AACG	Stock	1.05	1.05	0.95	0.96	10400.0
2023-10-27	AAIC-DELISTED	Stock	4.18	4.19	4.09	4.145	95542.0
2023-10-27	AAIC.C-DELISTED	Stock	23.7396	23.7396	23.55	23.63	3274.0
2023-10-27	AAL	Stock	11.18	11.23	10.88	10.92	39890700.0
2023-10-27	AAMC-DELISTED	Stock	3.6	3.6118	3.4765	3.5588	9860.0
2023-10-27	AAME	Stock	1.88	1.88	1.88	1.88	400.0
2023-10-27	AAMI	Stock	15.93	15.93	15.49	15.6	207200.0
2023-10-27	AAN-DELISTED	Stock	7.33	7.45	7.19	7.22	424900.0
2023-10-27	AAOI	Stock	7.1	7.32	6.89	7.04	897400.0
2023-10-27	AAON	Stock	53.74	54.23	53.03	53.74	343000.0
2023-10-27	AAP	Stock	50.99	51.27	49.71	49.9	1235500.0
2023-10-27	AAT	Stock	17.82	17.91	17.52	17.71	321000.0
2023-10-27	AATC	Stock	5.725	5.725	5.725	5.725	226.0
2023-10-27	AAU-DELISTED	Stock	0.14	0.1464	0.135	0.1448	396597.0
2023-10-27	AAUAF-DELISTED	Stock	0.14	0.1464	0.135	0.1448	399979.0
2023-10-27	AAXJ	Stock	61.78	61.9	61.19	61.27	630480.0
2023-10-27	AB	Stock	28.75	29.91	28.41	28.52	536400.0
2023-10-27	ABAT	Stock	4.08	4.25	3.33	4.24	865176.0
2023-10-27	ABBNY-DELISTED	Stock	33.16	33.25	32.96	33.08	318838.0
2023-10-27	ABBV	Stock	138.77	143.0	136.03	138.93	9427200.0
2023-10-27	ABCB	Stock	36.91	37.2	35.08	35.94	698400.0
2023-10-27	ABCL	Stock	4.15	4.16	3.91	3.91	1554900.0
2023-10-27	ABCM-DELISTED	Stock	22.92	22.97	22.73	22.895	2908227.0
2023-10-27	ABEO	Stock	3.85	3.91	3.71	3.71	47500.0
2023-10-27	ABEV	Stock	2.53	2.53	2.42	2.44	9261300.0
2023-10-27	ABG	Stock	189.65	190.35	185.13	186.56	193700.0
2023-10-27	ABLLW	Stock	0.3241	0.33	0.26	0.33	24192.0
2023-10-27	ABLV	Stock	2.51	2.51	2.45	2.49	8000.0
2023-10-27	ABM	Stock	39.51	39.58	38.99	39.23	297300.0
2023-10-27	ABNB	Stock	116.21	116.745	113.235	114.09	5201600.0
2023-10-27	ABOS	Stock	3.3	3.59	2.4	2.42	835300.0
2023-10-27	ABR	Stock	13.32	13.79	12.21	12.6	10348100.0
2023-10-27	ABR.D	Stock	16.55	16.55	16.0	16.03	62926.0
2023-10-27	ABR.E	Stock	16.25	16.55	16.0601	16.2	9248.0
2023-10-27	ABR.F	Stock	17.74	17.75	17.38	17.38	20445.0
2023-10-27	ABSI	Stock	1.17	1.27	1.15	1.22	431500.0
2023-10-27	ABT	Stock	94.75	95.32	92.38	92.85	5934100.0

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

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