PREVIEW / stock_daily / 2023-12-13

all stock daily files

  file:    by_date/stock_daily/2023/2023-12-13.parquet
  size:    238 KB
  rows:    7,413
  symbols: 1,298

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-12-13	AAPL	Stock	195.09	198.0	194.85	197.96	70404200.0
2023-12-13	MSFT	Stock	376.02	377.64	370.77	374.37	30955500.0
2023-12-13	NVDA	Stock	47.629	48.594	47.608	48.088	447792000.0
2023-12-13	AMZN	Stock	148.12	149.46	146.82	148.84	52766200.0
2023-12-13	GOOGL	Stock	133.38	133.5	131.57	132.57	30104775.0
2023-12-13	META	Stock	333.93	338.37	332.64	334.74	16353300.0
2023-12-13	TSLA	Stock	234.19	240.3	228.2	239.29	146286300.0
2023-12-13	TLT	Stock	95.17	96.98	95.02	96.84	70828499.0
2023-12-13	ES	Stock	60.17	63.21	59.72	63.09	2357900.0
2023-12-13	CL	Stock	78.42	79.44	78.04	79.39	4000100.0
2023-12-13	A	Stock	129.09	134.04	128.77	133.74	1731400.0
2023-12-13	AA	Stock	24.04	26.04	23.885	25.99	7919100.0
2023-12-13	AACG	Stock	0.9	0.91	0.88	0.89	7400.0
2023-12-13	AACIW-DELISTED	Stock	0.03	0.03	0.021	0.021	4244.0
2023-12-13	AACT	Stock	10.41	10.41	10.41	10.41	10300.0
2023-12-13	AAGR-DELISTED	Stock	0.6814	0.74	0.63	0.7279	1225397.0
2023-12-13	AAGRW-DELISTED	Stock	0.0312	0.035	0.025	0.0251	85528.0
2023-12-13	AAIC-DELISTED	Stock	4.79	4.83	4.69	4.82	327928.0
2023-12-13	AAIC.C-DELISTED	Stock	24.4	24.65	24.4	24.55	18845.0
2023-12-13	AAL	Stock	13.88	14.15	13.64	14.09	39046300.0
2023-12-13	AAMC-DELISTED	Stock	5.79	5.79	5.1	5.31	60700.0
2023-12-13	AAME	Stock	1.92	2.02	1.88	1.88	14900.0
2023-12-13	AAMI	Stock	18.88	19.51	18.74	19.39	166500.0
2023-12-13	AAN-DELISTED	Stock	10.34	11.31	10.25	11.29	581000.0
2023-12-13	AAOI	Stock	18.77	21.65	18.645	21.62	5601100.0
2023-12-13	AAON	Stock	67.0	67.55	64.53	67.37	508300.0
2023-12-13	AAP	Stock	56.44	61.18	55.99	60.83	2805600.0
2023-12-13	AAT	Stock	21.53	22.7	21.31	22.52	462200.0
2023-12-13	AATC	Stock	6.93	6.97	6.69	6.85	23217.0
2023-12-13	AAU-DELISTED	Stock	0.145	0.147	0.141	0.1453	178449.0
2023-12-13	AAUAF-DELISTED	Stock	0.145	0.147	0.141	0.1453	175889.0
2023-12-13	AAXJ	Stock	64.47	65.42	64.125	65.4	790643.0
2023-12-13	AB	Stock	30.52	31.28	30.16	30.81	452400.0
2023-12-13	ABAT	Stock	4.05	4.34	3.94	4.19	830701.0
2023-12-13	ABBNY-DELISTED	Stock	42.63	42.73	42.06	42.62	197863.0
2023-12-13	ABBV	Stock	152.98	154.77	152.73	154.3	8104500.0
2023-12-13	ABCB	Stock	47.06	50.2	46.8	50.1	496400.0
2023-12-13	ABCL	Stock	4.8	5.06	4.67	5.04	1200100.0
2023-12-13	ABEO	Stock	4.74	4.78	4.59	4.72	103600.0
2023-12-13	ABEV	Stock	2.87	2.98	2.87	2.96	12754700.0
2023-12-13	ABG	Stock	211.0	222.78	208.42	221.75	211300.0
2023-12-13	ABLLW	Stock	0.506	0.6375	0.5	0.58	512288.0
2023-12-13	ABLV	Stock	3.084	3.084	2.772	3.0	3100.0
2023-12-13	ABM	Stock	48.3	52.5	48.3	52.3	2600300.0
2023-12-13	ABNB	Stock	142.95	144.94	140.34	144.51	6673900.0
2023-12-13	ABOS	Stock	2.8	2.92	2.765	2.91	560600.0
2023-12-13	ABR	Stock	14.17	14.98	13.86	14.88	6063500.0
2023-12-13	ABR.D	Stock	17.35	17.6499	17.15	17.36	57791.0
2023-12-13	ABR.E	Stock	17.6	18.7946	17.315	17.61	10166.0
2023-12-13	ABR.F	Stock	18.75	19.26	18.585	18.8	33822.0

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

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