PREVIEW / stock_daily / 2023-10-30

all stock daily files

  file:    by_date/stock_daily/2023/2023-10-30.parquet
  size:    234 KB
  rows:    7,383
  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-30	AAPL	Stock	169.02	171.17	168.87	170.29	51131000.0
2023-10-30	MSFT	Stock	333.41	339.45	331.83	337.31	22828100.0
2023-10-30	NVDA	Stock	41.087	41.766	40.481	41.161	388028000.0
2023-10-30	AMZN	Stock	129.72	133.0	128.56	132.71	72485500.0
2023-10-30	GOOGL	Stock	123.21	125.4	122.75	124.46	28940081.0
2023-10-30	META	Stock	299.09	309.4	299.05	302.66	28435100.0
2023-10-30	TSLA	Stock	209.28	210.88	194.67	197.36	136448200.0
2023-10-30	TLT	Stock	83.81	84.5	83.24	83.99	45026920.0
2023-10-30	ES	Stock	53.44	53.97	52.45	53.39	2651700.0
2023-10-30	CL	Stock	72.77	74.2	72.36	73.88	6534000.0
2023-10-30	A	Stock	102.71	102.78	96.8	101.17	3684900.0
2023-10-30	AA	Stock	24.0	25.425	23.85	25.32	9442600.0
2023-10-30	AAC-DELISTED	Stock	9.85	9.9	9.72	9.85	33310.0
2023-10-30	AACG	Stock	1.01	1.05	0.92	1.05	6500.0
2023-10-30	AACIU	Stock	10.8	10.8	10.7	10.7	205.0
2023-10-30	AACT	Stock	10.29	10.31	10.285	10.3	454300.0
2023-10-30	AAIC-DELISTED	Stock	4.15	4.1613	4.08	4.08	36219.0
2023-10-30	AAIC.C-DELISTED	Stock	23.65	23.65	23.57	23.57	3331.0
2023-10-30	AAL	Stock	11.01	11.24	11.0	11.18	38208500.0
2023-10-30	AAMC-DELISTED	Stock	3.5588	3.5588	3.4706	3.5235	13940.0
2023-10-30	AAME	Stock	1.85	1.86	1.68	1.69	8200.0
2023-10-30	AAMI	Stock	15.81	16.0	15.615	15.89	172800.0
2023-10-30	AAN-DELISTED	Stock	7.3	7.49	7.26	7.4	359400.0
2023-10-30	AAOI	Stock	7.14	7.31	6.875	7.08	754000.0
2023-10-30	AAON	Stock	54.45	54.6	53.64	54.46	312500.0
2023-10-30	AAP	Stock	50.13	51.58	50.13	51.33	1490200.0
2023-10-30	AAT	Stock	17.85	18.04	17.52	17.93	245900.0
2023-10-30	AATC	Stock	5.7	5.725	5.12	5.23	37295.0
2023-10-30	AAU-DELISTED	Stock	0.14	0.1456	0.135	0.1381	262227.0
2023-10-30	AAUAF-DELISTED	Stock	0.14	0.1456	0.135	0.136	264479.0
2023-10-30	AAXJ	Stock	62.14	62.33	61.8	62.06	365597.0
2023-10-30	AB	Stock	28.5	29.17	28.5	28.62	409800.0
2023-10-30	ABAT	Stock	4.46	5.409	4.12	5.39	704704.0
2023-10-30	ABBNY-DELISTED	Stock	33.21	33.3	33.07	33.25	234743.0
2023-10-30	ABBV	Stock	140.67	145.71	140.67	141.89	9258500.0
2023-10-30	ABCB	Stock	34.76	37.13	34.76	37.0	590600.0
2023-10-30	ABCL	Stock	3.95	4.06	3.87	4.04	1439000.0
2023-10-30	ABCM-DELISTED	Stock	22.9	22.95	22.85	22.92	1637629.0
2023-10-30	ABEO	Stock	3.71	3.89	3.7	3.79	42300.0
2023-10-30	ABEV	Stock	2.47	2.48	2.42	2.43	11550400.0
2023-10-30	ABG	Stock	189.71	190.15	184.47	186.07	184900.0
2023-10-30	ABLLW	Stock	0.3	0.3396	0.27	0.3152	100084.0
2023-10-30	ABLV	Stock	2.355	2.355	2.04	2.1	9500.0
2023-10-30	ABM	Stock	39.62	39.62	38.98	39.3	252300.0
2023-10-30	ABNB	Stock	117.15	118.59	115.35	116.95	5218000.0
2023-10-30	ABOS	Stock	2.44	2.448	2.17	2.205	1116100.0
2023-10-30	ABR	Stock	12.74	12.76	12.19	12.45	6703100.0
2023-10-30	ABR.D	Stock	16.03	16.32	16.03	16.1	26752.0
2023-10-30	ABR.E	Stock	16.5	16.5942	16.13	16.1499	6159.0
2023-10-30	ABR.F	Stock	17.6	17.6	17.389	17.46	6282.0

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

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