PREVIEW / stock_daily / 2023-09-28

all stock daily files

  file:    by_date/stock_daily/2023/2023-09-28.parquet
  size:    235 KB
  rows:    7,360
  symbols: 1,393

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-09-28	AAPL	Stock	169.34	172.03	167.62	170.69	56294400.0
2023-09-28	MSFT	Stock	310.99	315.48	309.45	313.64	19683600.0
2023-09-28	NVDA	Stock	42.46	43.446	42.115	43.089	424663000.0
2023-09-28	AMZN	Stock	124.04	126.58	123.04	125.98	54555000.0
2023-09-28	GOOGL	Stock	129.84	133.3	129.79	132.31	22513132.0
2023-09-28	META	Stock	298.94	306.33	296.7	303.96	22167100.0
2023-09-28	TSLA	Stock	240.02	247.55	238.65	246.38	117058900.0
2023-09-28	TLT	Stock	87.62	88.73	87.1	88.68	60238010.0
2023-09-28	ES	Stock	59.15	59.19	57.22	57.36	2882100.0
2023-09-28	CL	Stock	71.29	71.53	70.87	71.31	3364000.0
2023-09-28	A	Stock	110.48	112.68	110.44	112.0	1959900.0
2023-09-28	AA	Stock	26.59	28.15	26.411	28.14	7998100.0
2023-09-28	AAC-DELISTED	Stock	10.76	10.76	10.75	10.75	12003.0
2023-09-28	AACG	Stock	1.13	1.15	1.12	1.15	900.0
2023-09-28	AACT	Stock	10.265	10.27	10.265	10.27	1200.0
2023-09-28	AAIC-DELISTED	Stock	4.22	4.245	4.14	4.22	50496.0
2023-09-28	AAIC.C-DELISTED	Stock	23.75	23.93	23.75	23.9	1497.0
2023-09-28	AAL	Stock	12.6	13.09	12.56	12.92	35234200.0
2023-09-28	AAMC-DELISTED	Stock	4.0588	4.1118	3.9471	3.9471	15300.0
2023-09-28	AAME	Stock	1.86	1.92	1.76	1.84	3100.0
2023-09-28	AAMI	Stock	19.32	19.56	19.205	19.56	341700.0
2023-09-28	AAN-DELISTED	Stock	10.26	10.66	10.25	10.64	356100.0
2023-09-28	AAOI	Stock	10.3	11.29	10.16	11.02	2229400.0
2023-09-28	AAON	Stock	57.11	58.05	56.44	57.5	333500.0
2023-09-28	AAP	Stock	53.87	55.23	53.26	55.07	2090100.0
2023-09-28	AAT	Stock	19.09	19.6	19.09	19.51	358600.0
2023-09-28	AATC	Stock	6.06	6.06	6.0	6.0	10040.0
2023-09-28	AAU-DELISTED	Stock	0.134	0.139	0.13	0.137	131646.0
2023-09-28	AAUAF-DELISTED	Stock	0.134	0.139	0.13	0.137	135747.0
2023-09-28	AAXJ	Stock	62.98	63.495	62.88	63.41	315505.0
2023-09-28	AB	Stock	30.6	31.11	30.59	30.62	327200.0
2023-09-28	ABAT	Stock	9.14	9.14	8.0	8.42	264040.0
2023-09-28	ABBNY-DELISTED	Stock	35.51	35.98	35.45	35.9	205828.0
2023-09-28	ABBV	Stock	153.64	153.83	151.37	152.25	3697400.0
2023-09-28	ABCB	Stock	37.18	37.98	37.1	37.63	405400.0
2023-09-28	ABCL	Stock	4.69	4.72	4.51	4.66	1099700.0
2023-09-28	ABCM-DELISTED	Stock	22.68	22.71	22.63	22.66	3549541.0
2023-09-28	ABEO	Stock	3.95	4.11	3.84	3.93	93200.0
2023-09-28	ABEV	Stock	2.54	2.58	2.53	2.56	29250300.0
2023-09-28	ABG	Stock	218.34	230.45	218.34	229.19	182300.0
2023-09-28	ABLLW	Stock	0.3188	0.35	0.3	0.35	4636.0
2023-09-28	ABLV	Stock	3.39	3.39	3.3	3.32	3300.0
2023-09-28	ABM	Stock	39.72	40.46	39.72	40.18	605100.0
2023-09-28	ABNB	Stock	133.65	138.23	132.88	136.47	4058900.0
2023-09-28	ABOS	Stock	4.2	4.2	4.0	4.17	228700.0
2023-09-28	ABR	Stock	14.82	15.28	14.78	15.23	2615400.0
2023-09-28	ABR.D	Stock	17.3	18.23	17.3	18.23	19270.0
2023-09-28	ABR.E	Stock	17.79	18.4266	17.79	18.34	3245.0
2023-09-28	ABR.F	Stock	19.27	19.86	19.11	19.11	24499.0
2023-09-28	ABSI	Stock	1.36	1.38	1.291	1.38	193200.0

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

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