PREVIEW / stock_daily / 2023-09-27

all stock daily files

  file:    by_date/stock_daily/2023/2023-09-27.parquet
  size:    236 KB
  rows:    7,378
  symbols: 1,396

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-27	AAPL	Stock	172.62	173.04	169.05	170.43	66921800.0
2023-09-27	MSFT	Stock	312.3	314.3	309.69	312.79	19410100.0
2023-09-27	NVDA	Stock	42.33	42.872	41.629	42.468	444935000.0
2023-09-27	AMZN	Stock	125.76	127.48	124.13	125.98	66553400.0
2023-09-27	GOOGL	Stock	128.57	130.895	128.57	130.54	22746452.0
2023-09-27	META	Stock	300.45	301.3	286.79	297.74	36429800.0
2023-09-27	TSLA	Stock	244.26	245.33	234.58	240.5	136597200.0
2023-09-27	TLT	Stock	89.535	89.62	88.09	88.41	47111201.0
2023-09-27	ES	Stock	59.56	59.91	58.47	58.77	2377900.0
2023-09-27	CL	Stock	71.93	72.22	70.82	71.05	3572800.0
2023-09-27	A	Stock	110.96	111.25	109.62	110.5	2268300.0
2023-09-27	AA	Stock	26.07	26.78	25.95	26.2	5604900.0
2023-09-27	AAC-DELISTED	Stock	10.76	10.76	10.74	10.76	7136.0
2023-09-27	AACG	Stock	1.13	1.19	1.13	1.13	3800.0
2023-09-27	AACIW-DELISTED	Stock	0.0736	0.0736	0.0736	0.0736	100.0
2023-09-27	AACT	Stock	10.27	10.27	10.27	10.27	260100.0
2023-09-27	AAIC-DELISTED	Stock	4.23	4.3	4.21	4.23	65070.0
2023-09-27	AAIC.C-DELISTED	Stock	24.0699	24.0699	24.0699	24.0699	400.0
2023-09-27	AAL	Stock	12.74	12.83	12.5	12.61	29983300.0
2023-09-27	AAMC-DELISTED	Stock	4.0412	4.2588	3.9294	3.9294	60010.0
2023-09-27	AAME	Stock	1.87	1.87	1.87	1.87	400.0
2023-09-27	AAMI	Stock	19.41	19.49	19.2	19.23	125600.0
2023-09-27	AAN-DELISTED	Stock	10.3	10.49	10.21	10.39	268700.0
2023-09-27	AAOI	Stock	9.88	10.4	9.87	10.28	1951300.0
2023-09-27	AAON	Stock	55.5	57.12	55.5	56.87	370100.0
2023-09-27	AAP	Stock	55.06	55.87	54.5	54.82	1714900.0
2023-09-27	AAT	Stock	18.96	19.28	18.9	18.99	411300.0
2023-09-27	AATC	Stock	6.12	6.12	6.03	6.0908	1275.0
2023-09-27	AAU-DELISTED	Stock	0.1325	0.134	0.1278	0.134	259038.0
2023-09-27	AAUAF-DELISTED	Stock	0.1325	0.134	0.1278	0.134	262829.0
2023-09-27	AAXJ	Stock	63.5	63.56	63.05	63.35	376676.0
2023-09-27	AB	Stock	30.99	31.03	30.67	30.84	195300.0
2023-09-27	ABAT	Stock	9.7	9.73	8.52	8.75	325075.0
2023-09-27	ABBNY-DELISTED	Stock	35.35	35.35	35.08	35.19	279614.0
2023-09-27	ABBV	Stock	153.84	154.0	151.61	153.13	3621300.0
2023-09-27	ABCB	Stock	37.4	37.74	37.08	37.23	266200.0
2023-09-27	ABCL	Stock	4.73	5.02	4.685	4.71	1425800.0
2023-09-27	ABCM-DELISTED	Stock	22.67	22.765	22.645	22.725	1976832.0
2023-09-27	ABEO	Stock	4.05	4.3	3.82	3.96	176100.0
2023-09-27	ABEV	Stock	2.59	2.59	2.51	2.53	29839700.0
2023-09-27	ABG	Stock	221.56	228.35	221.56	225.47	97000.0
2023-09-27	ABLLW	Stock	0.32	0.32415	0.29	0.32	10446.0
2023-09-27	ABLV	Stock	3.4	3.432	3.31	3.31	16700.0
2023-09-27	ABLVW	Stock	0.0255	0.0255	0.0255	0.0255	200.0
2023-09-27	ABM	Stock	39.23	39.73	38.95	39.47	601800.0
2023-09-27	ABNB	Stock	133.8	134.9	131.22	134.03	3771300.0
2023-09-27	ABOS	Stock	4.29	4.34	4.19	4.21	193100.0
2023-09-27	ABR	Stock	14.82	15.05	14.78	14.84	2218600.0
2023-09-27	ABR.D	Stock	18.01	18.093	17.4	17.55	18431.0
2023-09-27	ABR.E	Stock	17.8	17.88	17.7	17.88	6363.0

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

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