PREVIEW / stock_daily / 2023-12-08

all stock daily files

  file:    by_date/stock_daily/2023/2023-12-08.parquet
  size:    234 KB
  rows:    7,333
  symbols: 1,259

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-08	AAPL	Stock	194.2	195.99	193.67	195.71	53377300.0
2023-12-08	MSFT	Stock	369.2	374.46	368.23	374.23	20144800.0
2023-12-08	NVDA	Stock	46.595	47.741	46.55	47.506	359224000.0
2023-12-08	AMZN	Stock	145.48	147.84	145.4	147.42	41858000.0
2023-12-08	GOOGL	Stock	134.2	136.4	134.025	134.99	32260112.0
2023-12-08	META	Stock	323.09	333.17	323.0	332.75	14077500.0
2023-12-08	TSLA	Stock	240.27	245.27	239.27	243.84	102980100.0
2023-12-08	TLT	Stock	94.42	94.715	93.91	94.54	44809246.0
2023-12-08	ES	Stock	60.45	60.68	59.47	59.65	1921800.0
2023-12-08	CL	Stock	77.56	77.56	76.69	77.17	4317800.0
2023-12-08	A	Stock	128.09	129.0	126.97	127.2	1438100.0
2023-12-08	AA	Stock	25.04	25.725	24.87	25.02	5128100.0
2023-12-08	AACG	Stock	0.89	0.89	0.8	0.81	20900.0
2023-12-08	AACT	Stock	10.38	10.4	10.38	10.4	261900.0
2023-12-08	AAGR-DELISTED	Stock	3.89	3.9806	2.21	2.3	1148978.0
2023-12-08	AAGRW-DELISTED	Stock	0.05	0.074	0.0311	0.0312	28625.0
2023-12-08	AAIC-DELISTED	Stock	4.65	4.75	4.635	4.75	326346.0
2023-12-08	AAIC.C-DELISTED	Stock	24.47	24.4989	24.47	24.4989	1241.0
2023-12-08	AAL	Stock	13.87	13.98	13.71	13.76	30175300.0
2023-12-08	AAMC-DELISTED	Stock	5.29	6.8	4.86	6.65	508000.0
2023-12-08	AAME	Stock	1.92	1.92	1.9	1.91	5200.0
2023-12-08	AAMI	Stock	18.69	18.74	18.35	18.59	94400.0
2023-12-08	AAN-DELISTED	Stock	10.42	10.59	10.21	10.42	481400.0
2023-12-08	AAOI	Stock	17.83	19.84	17.83	19.76	4868900.0
2023-12-08	AAON	Stock	64.77	66.44	64.39	65.34	298900.0
2023-12-08	AAP	Stock	56.31	56.54	54.95	56.27	4233600.0
2023-12-08	AAT	Stock	21.37	21.53	21.11	21.51	414600.0
2023-12-08	AATC	Stock	7.36	7.36	7.11	7.1518	4036.0
2023-12-08	AAU-DELISTED	Stock	0.1422	0.1475	0.1422	0.1451	161412.0
2023-12-08	AAUAF-DELISTED	Stock	0.1422	0.1475	0.1422	0.145	161937.0
2023-12-08	AAXJ	Stock	64.27	64.55	64.13	64.39	796891.0
2023-12-08	AB	Stock	29.29	30.5	29.29	30.03	447700.0
2023-12-08	ABAT	Stock	4.11	4.2097	3.9999	4.0	480487.0
2023-12-08	ABBNY-DELISTED	Stock	40.78	41.0742	40.78	40.91	205286.0
2023-12-08	ABBV	Stock	148.07	150.07	148.0	149.28	5694600.0
2023-12-08	ABCB	Stock	46.99	47.59	46.43	47.0	344900.0
2023-12-08	ABCL	Stock	4.79	4.97	4.7	4.87	1524300.0
2023-12-08	ABEO	Stock	4.75	4.88	4.7	4.78	111200.0
2023-12-08	ABEV	Stock	2.86	2.92	2.86	2.89	7909700.0
2023-12-08	ABG	Stock	215.84	218.32	213.51	215.21	63000.0
2023-12-08	ABLLW	Stock	0.357	0.3999	0.357	0.3864	5359.0
2023-12-08	ABLV	Stock	2.85	2.99	2.815	2.989	12800.0
2023-12-08	ABM	Stock	43.48	43.97	43.44	43.67	312800.0
2023-12-08	ABNB	Stock	138.19	141.54	137.8	140.68	4410400.0
2023-12-08	ABOS	Stock	2.83	2.84	2.71	2.77	307300.0
2023-12-08	ABR	Stock	13.54	13.77	13.47	13.65	2897000.0
2023-12-08	ABR.D	Stock	16.97	17.36	16.97	17.0981	12159.0
2023-12-08	ABR.E	Stock	17.24	17.24	17.05	17.16	4296.0
2023-12-08	ABR.F	Stock	19.01	19.045	18.8809	18.92	7455.0
2023-12-08	ABSI	Stock	2.34	2.49	2.22	2.3	931800.0

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

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