PREVIEW / stock_daily / 2023-10-20

all stock daily files

  file:    by_date/stock_daily/2023/2023-10-20.parquet
  size:    233 KB
  rows:    7,332
  symbols: 1,342

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-20	AAPL	Stock	175.31	175.42	172.64	172.88	64189300.0
2023-10-20	MSFT	Stock	331.72	331.92	325.45	326.67	25012600.0
2023-10-20	NVDA	Stock	41.89	42.47	41.078	41.387	477266000.0
2023-10-20	AMZN	Stock	128.05	128.17	124.97	125.17	56343300.0
2023-10-20	GOOGL	Stock	137.33	137.87	135.08	135.6	26335673.0
2023-10-20	META	Stock	314.14	315.3	306.47	308.65	22287400.0
2023-10-20	TSLA	Stock	217.01	218.86	210.42	211.99	137734000.0
2023-10-20	TLT	Stock	82.99	83.54	82.77	83.24	52188750.0
2023-10-20	ES	Stock	53.94	54.82	53.37	53.5	2906000.0
2023-10-20	CL	Stock	73.18	73.61	72.91	73.27	6560000.0
2023-10-20	A	Stock	109.54	110.59	109.18	109.23	2367300.0
2023-10-20	AA	Stock	23.5	24.37	23.26	24.01	9203200.0
2023-10-20	AAC-DELISTED	Stock	10.75	10.77	10.75	10.765	20172.0
2023-10-20	AACG	Stock	1.02	1.05	1.02	1.05	2000.0
2023-10-20	AACT	Stock	10.29	10.3	10.28	10.28	647600.0
2023-10-20	AAIC-DELISTED	Stock	4.31	4.35	4.28	4.29	26692.0
2023-10-20	AAIC.C-DELISTED	Stock	24.0	24.0	23.75	23.75	956.0
2023-10-20	AAL	Stock	11.4	11.43	11.04	11.08	49956600.0
2023-10-20	AAMC-DELISTED	Stock	3.8618	3.9647	3.8529	3.8882	12240.0
2023-10-20	AAME	Stock	1.97	1.97	1.78	1.81	1500.0
2023-10-20	AAMI	Stock	17.02	17.02	16.48	16.48	131300.0
2023-10-20	AAN-DELISTED	Stock	9.37	9.37	9.2	9.28	404400.0
2023-10-20	AAOI	Stock	7.4	7.4	6.8	6.91	1720100.0
2023-10-20	AAON	Stock	52.85	53.91	52.28	53.17	472400.0
2023-10-20	AAP	Stock	51.1	52.19	51.01	51.2	1355200.0
2023-10-20	AAT	Stock	18.19	18.29	17.98	17.98	197300.0
2023-10-20	AATC	Stock	5.51	5.51	5.51	5.51	1152.0
2023-10-20	AAU-DELISTED	Stock	0.135	0.157	0.135	0.1408	811166.0
2023-10-20	AAUAF-DELISTED	Stock	0.135	0.157	0.135	0.1408	817468.0
2023-10-20	AAXJ	Stock	61.96	62.155	61.685	61.7	579593.0
2023-10-20	AB	Stock	29.16	29.16	28.57	29.03	257300.0
2023-10-20	ABAT	Stock	6.75	6.81	6.0401	6.11	355419.0
2023-10-20	ABBNY-DELISTED	Stock	33.39	33.55	33.08	33.1	465802.0
2023-10-20	ABBV	Stock	145.28	147.51	145.28	146.23	4223800.0
2023-10-20	ABCB	Stock	37.31	37.31	36.15	36.19	446600.0
2023-10-20	ABCL	Stock	4.32	4.35	4.262	4.32	1492500.0
2023-10-20	ABCM-DELISTED	Stock	22.75	22.78	22.6	22.62	5794697.0
2023-10-20	ABEO	Stock	4.22	4.31	4.13	4.14	45700.0
2023-10-20	ABEV	Stock	2.45	2.48	2.44	2.46	6294500.0
2023-10-20	ABG	Stock	207.47	208.56	204.23	204.71	145200.0
2023-10-20	ABLLW	Stock	0.30803	0.3396	0.30803	0.3301	19739.0
2023-10-20	ABLV	Stock	2.81	2.81	2.66	2.72	10300.0
2023-10-20	ABM	Stock	41.65	41.77	40.26	40.29	491900.0
2023-10-20	ABNB	Stock	119.49	119.92	116.08	116.49	6194900.0
2023-10-20	ABOS	Stock	3.45	3.625	3.392	3.46	366300.0
2023-10-20	ABR	Stock	13.97	14.26	13.85	14.0	3303600.0
2023-10-20	ABR.D	Stock	16.7	16.75	16.54	16.7	6850.0
2023-10-20	ABR.E	Stock	16.68	16.69	16.4	16.69	2568.0
2023-10-20	ABR.F	Stock	17.76	17.9033	17.61	17.67	6885.0
2023-10-20	ABSI	Stock	1.33	1.35	1.258	1.26	199200.0

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

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