PREVIEW / stock_daily / 2023-10-09

all stock daily files

  file:    by_date/stock_daily/2023/2023-10-09.parquet
  size:    234 KB
  rows:    7,350
  symbols: 1,358

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-09	AAPL	Stock	176.81	179.05	175.8	178.99	42390800.0
2023-10-09	MSFT	Stock	324.75	330.3	323.18	329.82	19891200.0
2023-10-09	NVDA	Stock	44.842	45.605	44.368	45.273	409675000.0
2023-10-09	AMZN	Stock	126.22	128.79	124.76	128.26	38773700.0
2023-10-09	GOOGL	Stock	136.94	138.94	135.61	138.42	19278070.0
2023-10-09	META	Stock	312.5	320.33	311.82	318.36	22503700.0
2023-10-09	TSLA	Stock	255.31	261.36	252.05	259.67	101377900.0
2023-10-09	TLT	Stock	85.5	86.8	84.95	86.78	29424888.0
2023-10-09	ES	Stock	55.81	57.27	55.6	57.24	2771100.0
2023-10-09	CL	Stock	69.2	69.55	68.44	69.31	3983500.0
2023-10-09	A	Stock	109.97	111.31	109.12	111.28	1320300.0
2023-10-09	AA	Stock	26.68	27.465	26.62	27.25	3857100.0
2023-10-09	AAC-DELISTED	Stock	10.77	10.77	10.76	10.77	231735.0
2023-10-09	AACG	Stock	1.11	1.14	1.1	1.1	1400.0
2023-10-09	AACIW-DELISTED	Stock	0.0799	0.08	0.0799	0.08	800.0
2023-10-09	AACT	Stock	10.271	10.271	10.27	10.27	2700.0
2023-10-09	AAIC-DELISTED	Stock	4.25	4.39	4.25	4.39	60497.0
2023-10-09	AAIC.C-DELISTED	Stock	23.5178	23.96	23.5178	23.96	800.0
2023-10-09	AAL	Stock	12.37	12.37	11.94	12.24	51462700.0
2023-10-09	AAMC-DELISTED	Stock	3.9882	4.0706	3.8882	3.9471	10370.0
2023-10-09	AAME	Stock	1.79	1.81	1.75	1.75	6900.0
2023-10-09	AAMI	Stock	17.68	18.22	17.57	18.19	122200.0
2023-10-09	AAN-DELISTED	Stock	9.68	9.92	9.59	9.87	199000.0
2023-10-09	AAOI	Stock	8.74	8.882	7.358	7.585	3246600.0
2023-10-09	AAON	Stock	56.95	57.89	56.1	57.72	198000.0
2023-10-09	AAP	Stock	51.56	51.87	50.14	51.36	2010600.0
2023-10-09	AAT	Stock	17.97	18.52	17.97	18.36	147800.0
2023-10-09	AATC	Stock	5.68	5.68	5.68	5.68	904.0
2023-10-09	AAU-DELISTED	Stock	0.131	0.1349	0.13	0.13	77757.0
2023-10-09	AAUAF-DELISTED	Stock	0.131	0.1349	0.13	0.13	80250.0
2023-10-09	AAXJ	Stock	63.0	63.49	62.87	63.45	245392.0
2023-10-09	AB	Stock	30.6	31.18	30.38	30.98	325500.0
2023-10-09	ABAT	Stock	7.15	7.24	6.72	6.72	219662.0
2023-10-09	ABBNY-DELISTED	Stock	35.81	36.02	35.7	35.93	629761.0
2023-10-09	ABBV	Stock	148.27	149.75	147.16	149.11	2903300.0
2023-10-09	ABCB	Stock	37.94	38.7	37.56	38.22	185200.0
2023-10-09	ABCL	Stock	4.39	4.41	4.28	4.4	840500.0
2023-10-09	ABCM-DELISTED	Stock	22.67	22.79	22.65	22.77	2684104.0
2023-10-09	ABEO	Stock	4.14	4.24	3.85	4.23	193900.0
2023-10-09	ABEV	Stock	2.52	2.55	2.51	2.53	3917400.0
2023-10-09	ABG	Stock	209.73	218.82	208.57	217.09	177300.0
2023-10-09	ABLLW	Stock	0.3875	0.3875	0.323	0.375	3456.0
2023-10-09	ABLV	Stock	3.22	3.22	3.22	3.22	500.0
2023-10-09	ABM	Stock	41.11	42.41	41.1	42.27	390300.0
2023-10-09	ABNB	Stock	124.0	127.92	121.81	127.77	5092000.0
2023-10-09	ABOS	Stock	4.34	4.37	4.1	4.19	383400.0
2023-10-09	ABR	Stock	13.58	14.22	13.57	14.19	2810800.0
2023-10-09	ABR.D	Stock	17.45	17.5042	17.1101	17.13	23074.0
2023-10-09	ABR.E	Stock	17.4014	17.4014	17.15	17.225	3171.0
2023-10-09	ABR.F	Stock	18.37	18.3805	18.15	18.3	8714.0

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

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