PREVIEW / stock_daily / 2023-06-13

all stock daily files

  file:    by_date/stock_daily/2023/2023-06-13.parquet
  size:    243 KB
  rows:    7,561
  symbols: 1,627

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-13	AAPL	Stock	182.8	184.15	182.44	183.31	54929100.0
2023-06-13	MSFT	Stock	334.47	336.98	330.39	334.29	22951300.0
2023-06-13	NVDA	Stock	40.186	41.101	39.74	41.022	613208000.0
2023-06-13	AMZN	Stock	128.12	128.41	125.18	126.66	50564800.0
2023-06-13	GOOGL	Stock	124.98	125.16	123.18	123.83	22278313.0
2023-06-13	META	Stock	274.88	275.72	269.09	271.32	16164000.0
2023-06-13	TSLA	Stock	253.51	259.68	251.34	258.71	162384300.0
2023-06-13	TLT	Stock	102.11	102.33	100.965	101.21	25910828.0
2023-06-13	ES	Stock	69.56	70.06	69.36	70.06	2362100.0
2023-06-13	CL	Stock	75.29	75.51	75.04	75.24	4121200.0
2023-06-13	A	Stock	118.68	121.16	118.68	119.5	2502400.0
2023-06-13	AA	Stock	36.02	37.61	35.89	36.7	6175900.0
2023-06-13	AAC-DELISTED	Stock	10.49	10.5169	10.49	10.5	17013.0
2023-06-13	AACG	Stock	1.26	1.3	1.25	1.29	16900.0
2023-06-13	AACIW-DELISTED	Stock	0.06	0.0627	0.06	0.0627	465.0
2023-06-13	AACT	Stock	10.14	10.14	10.11	10.11	5515.0
2023-06-13	AAIC-DELISTED	Stock	4.38	4.43	4.37	4.39	251575.0
2023-06-13	AAIC.C-DELISTED	Stock	22.8998	22.9	22.8997	22.9	1969.0
2023-06-13	AAL	Stock	16.25	16.35	16.1	16.31	21911600.0
2023-06-13	AAM.A-DELISTED	Stock	23.98	24.05	23.45	23.45	7081.0
2023-06-13	AAM.B-DELISTED	Stock	23.59	23.82	23.2	23.2	6600.0
2023-06-13	AAMC-DELISTED	Stock	22.6471	22.6471	17.9412	18.1265	680228.0
2023-06-13	AAME	Stock	2.31	2.32	2.17	2.19	5000.0
2023-06-13	AAMI	Stock	22.31	22.78	22.14	22.46	444500.0
2023-06-13	AAN-DELISTED	Stock	14.24	14.67	14.17	14.26	242400.0
2023-06-13	AAOI	Stock	3.28	3.71	3.28	3.64	1280800.0
2023-06-13	AAON	Stock	63.6267	64.9867	63.5	64.44	1014450.0
2023-06-13	AAP	Stock	66.97	70.47	66.65	68.66	5142400.0
2023-06-13	AAT	Stock	19.7	20.12	19.62	19.66	296700.0
2023-06-13	AATC	Stock	4.32	4.39	4.1	4.105	47253.0
2023-06-13	AAU-DELISTED	Stock	0.128	0.1299	0.1276	0.1295	132011.0
2023-06-13	AAUAF-DELISTED	Stock	0.128	0.1299	0.1276	0.1295	133334.0
2023-06-13	AAXJ	Stock	68.27	68.46	68.1	68.28	514518.0
2023-06-13	AB	Stock	33.75	34.38	33.69	34.13	237600.0
2023-06-13	ABBNY-DELISTED	Stock	38.66	39.0	38.58	38.915	230921.0
2023-06-13	ABBV	Stock	137.51	138.47	137.2	138.31	4229100.0
2023-06-13	ABC-DELISTED	Stock	178.44	180.5599	178.145	179.8	854029.0
2023-06-13	ABCB	Stock	35.31	36.23	34.95	36.06	313900.0
2023-06-13	ABCL	Stock	7.42	7.549	7.28	7.47	2591600.0
2023-06-13	ABCM-DELISTED	Stock	18.02	19.22	17.865	18.95	2483304.0
2023-06-13	ABEO	Stock	4.4	4.73	4.35	4.62	202400.0
2023-06-13	ABEV	Stock	3.09	3.13	3.07	3.1	13213900.0
2023-06-13	ABG	Stock	228.34	234.54	226.91	227.85	303300.0
2023-06-13	ABM	Stock	44.96	45.17	43.65	43.7	504200.0
2023-06-13	ABNB	Stock	124.61	125.74	123.22	124.9	5276800.0
2023-06-13	ABOS	Stock	5.33	6.48	5.33	5.89	672800.0
2023-06-13	ABR	Stock	14.12	14.32	14.08	14.18	2301400.0
2023-06-13	ABR.D	Stock	18.53	18.53	18.17	18.42	6066.0
2023-06-13	ABR.E	Stock	17.8	18.0065	17.8	17.895	11808.0
2023-06-13	ABR.F	Stock	18.8	18.94	18.71	18.9	7734.0

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

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