PREVIEW / stock_daily / 2023-06-28

all stock daily files

  file:    by_date/stock_daily/2023/2023-06-28.parquet
  size:    241 KB
  rows:    7,494
  symbols: 1,562

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-06-28	AAPL	Stock	187.93	189.9	187.6	189.25	51216800.0
2023-06-28	MSFT	Stock	334.66	337.98	333.81	335.85	20259500.0
2023-06-28	NVDA	Stock	40.66	41.845	40.518	41.117	582639000.0
2023-06-28	AMZN	Stock	128.94	131.48	128.44	129.04	52149500.0
2023-06-28	GOOGL	Stock	117.09	120.39	116.85	120.18	27091449.0
2023-06-28	META	Stock	284.82	289.55	284.06	285.29	16722100.0
2023-06-28	TSLA	Stock	249.7	259.88	248.89	256.24	159770800.0
2023-06-28	TLT	Stock	103.41	103.84	102.827	103.61	23826807.0
2023-06-28	ES	Stock	70.76	70.94	69.52	69.59	2252700.0
2023-06-28	CL	Stock	75.33	75.94	74.65	75.91	5100300.0
2023-06-28	A	Stock	116.7	117.11	115.71	116.37	2196800.0
2023-06-28	AA	Stock	34.0	34.03	33.39	33.66	3657200.0
2023-06-28	AAC-DELISTED	Stock	10.55	10.55	10.53	10.53	589341.0
2023-06-28	AACG	Stock	1.4	1.45	1.39	1.4	4800.0
2023-06-28	AACIW-DELISTED	Stock	0.112	0.11267	0.105	0.105	5105.0
2023-06-28	AACT	Stock	10.16	10.1601	10.16	10.1601	93524.0
2023-06-28	AAIC-DELISTED	Stock	4.47	4.54	4.465	4.51	270554.0
2023-06-28	AAL	Stock	17.35	17.58	17.28	17.55	26466300.0
2023-06-28	AAM.A-DELISTED	Stock	22.955	23.0373	22.9	22.92	11201.0
2023-06-28	AAM.B-DELISTED	Stock	22.59	22.73	22.345	22.5	16327.0
2023-06-28	AAMC-DELISTED	Stock	15.5265	16.1765	14.1191	14.6176	74722.0
2023-06-28	AAME	Stock	1.98	2.04	1.97	2.02	11900.0
2023-06-28	AAMI	Stock	20.51	20.579	20.32	20.48	148900.0
2023-06-28	AAN-DELISTED	Stock	13.83	14.1	13.69	14.06	178100.0
2023-06-28	AAOI	Stock	4.9	5.33	4.52	5.17	2038300.0
2023-06-28	AAON	Stock	64.1733	64.6133	63.4267	63.4933	435450.0
2023-06-28	AAP	Stock	67.68	68.35	66.76	68.08	1895600.0
2023-06-28	AAT	Stock	19.26	19.26	18.54	18.65	415800.0
2023-06-28	AATC	Stock	4.47	4.48	4.414	4.44	2187.0
2023-06-28	AAU-DELISTED	Stock	0.128	0.1284	0.127	0.1281	453917.0
2023-06-28	AAUAF-DELISTED	Stock	0.128	0.1284	0.127	0.1281	458916.0
2023-06-28	AAXJ	Stock	66.24	66.51	66.17	66.45	435140.0
2023-06-28	AB	Stock	31.65	31.74	31.18	31.48	524900.0
2023-06-28	ABBNY-DELISTED	Stock	39.23	39.36	38.8	38.83	314893.0
2023-06-28	ABBV	Stock	132.6	133.17	130.96	132.51	6911900.0
2023-06-28	ABC-DELISTED	Stock	188.77	190.255	188.69	189.78	671329.0
2023-06-28	ABCB	Stock	34.08	34.34	33.54	34.05	373700.0
2023-06-28	ABCL	Stock	6.38	6.68	6.31	6.61	2886900.0
2023-06-28	ABCM-DELISTED	Stock	23.75	24.04	23.3	23.63	1126600.0
2023-06-28	ABEO	Stock	4.55	4.74	4.26	4.37	181100.0
2023-06-28	ABEV	Stock	3.15	3.15	3.09	3.1	21844800.0
2023-06-28	ABG	Stock	234.44	242.99	234.44	240.99	178200.0
2023-06-28	ABM	Stock	41.42	42.0	41.1	41.94	358200.0
2023-06-28	ABNB	Stock	127.39	131.88	126.17	127.63	6130400.0
2023-06-28	ABOS	Stock	4.75	4.94	4.65	4.86	73000.0
2023-06-28	ABR	Stock	14.3	14.41	14.2	14.39	2392700.0
2023-06-28	ABR.D	Stock	18.34	18.34	18.1	18.13	9500.0
2023-06-28	ABR.E	Stock	18.19	18.2	18.03	18.17	3009.0
2023-06-28	ABR.F	Stock	19.43	20.4143	19.2301	19.66	14990.0
2023-06-28	ABSI	Stock	1.64	1.69	1.56	1.6	543700.0

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

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