PREVIEW / stock_daily / 2023-12-12

all stock daily files

  file:    by_date/stock_daily/2023/2023-12-12.parquet
  size:    236 KB
  rows:    7,376
  symbols: 1,278

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-12	AAPL	Stock	193.08	194.72	191.72	194.71	52696900.0
2023-12-12	MSFT	Stock	370.85	374.42	370.46	374.38	24838300.0
2023-12-12	NVDA	Stock	46.046	47.666	46.046	47.657	372387000.0
2023-12-12	AMZN	Stock	145.52	147.5	145.3	147.48	44944300.0
2023-12-12	GOOGL	Stock	131.81	133.0	131.26	132.52	29032831.0
2023-12-12	META	Stock	324.6	334.47	324.56	334.22	18485500.0
2023-12-12	TSLA	Stock	238.55	238.99	233.87	237.01	95328300.0
2023-12-12	TLT	Stock	94.15	94.7	93.9004	94.62	36996909.0
2023-12-12	ES	Stock	60.8	60.8	59.8	60.21	1773300.0
2023-12-12	CL	Stock	77.82	78.6	77.53	78.59	3798500.0
2023-12-12	A	Stock	128.05	129.2	127.0	128.79	1453500.0
2023-12-12	AA	Stock	24.68	24.75	23.8	24.05	5849300.0
2023-12-12	AACG	Stock	0.9	0.92	0.88	0.89	2400.0
2023-12-12	AACIW-DELISTED	Stock	0.0255	0.0255	0.021	0.021	78534.0
2023-12-12	AACT	Stock	10.42	10.425	10.4	10.425	463000.0
2023-12-12	AAGR-DELISTED	Stock	0.8801	0.92	0.776	0.7965	1059162.0
2023-12-12	AAGRW-DELISTED	Stock	0.0399	0.0399	0.0312	0.0312	11157.0
2023-12-12	AAIC-DELISTED	Stock	4.72	4.8199	4.72	4.8	231549.0
2023-12-12	AAIC.C-DELISTED	Stock	24.5	24.65	24.5	24.65	334.0
2023-12-12	AAL	Stock	13.81	14.18	13.8	14.04	34298800.0
2023-12-12	AAMC-DELISTED	Stock	6.45	6.57	5.8	5.99	60900.0
2023-12-12	AAME	Stock	1.88	1.92	1.84	1.84	8400.0
2023-12-12	AAMI	Stock	18.55	19.21	18.38	18.98	157000.0
2023-12-12	AAN-DELISTED	Stock	10.44	10.515	10.3	10.44	319300.0
2023-12-12	AAOI	Stock	18.51	19.43	18.0	18.58	2362100.0
2023-12-12	AAON	Stock	66.3	66.99	65.57	66.92	467700.0
2023-12-12	AAP	Stock	56.77	56.8	55.94	56.25	1868100.0
2023-12-12	AAT	Stock	21.49	21.59	21.25	21.42	850600.0
2023-12-12	AATC	Stock	6.83	6.975	6.54	6.94	32305.0
2023-12-12	AAU-DELISTED	Stock	0.143	0.152	0.143	0.145	279541.0
2023-12-12	AAUAF-DELISTED	Stock	0.143	0.152	0.143	0.145	287452.0
2023-12-12	AAXJ	Stock	64.58	64.898	64.35	64.88	808040.0
2023-12-12	AB	Stock	29.67	30.99	29.59	30.56	684500.0
2023-12-12	ABAT	Stock	4.05	4.11	3.9	4.03	466337.0
2023-12-12	ABBNY-DELISTED	Stock	42.15	42.25	42.0	42.16	125113.0
2023-12-12	ABBV	Stock	151.73	153.59	150.17	153.24	5882200.0
2023-12-12	ABCB	Stock	47.0	47.22	46.72	46.82	338800.0
2023-12-12	ABCL	Stock	4.78	4.8	4.65	4.78	1039600.0
2023-12-12	ABEO	Stock	4.64	4.76	4.58	4.68	71800.0
2023-12-12	ABEV	Stock	2.89	2.89	2.84	2.85	4826500.0
2023-12-12	ABG	Stock	215.63	217.15	211.03	211.2	124500.0
2023-12-12	ABLLW	Stock	0.4	0.56	0.3991	0.529	827040.0
2023-12-12	ABLV	Stock	2.915	3.12	2.8	3.12	6900.0
2023-12-12	ABLVW	Stock	0.05	0.05	0.0495	0.0495	4200.0
2023-12-12	ABM	Stock	43.99	44.84	43.77	44.36	482000.0
2023-12-12	ABNB	Stock	137.9	141.06	137.58	140.55	6823200.0
2023-12-12	ABOS	Stock	2.8	2.86	2.71	2.81	446300.0
2023-12-12	ABR	Stock	14.04	14.42	13.98	14.19	4370200.0
2023-12-12	ABR.D	Stock	17.42	17.46	17.1001	17.26	22939.0
2023-12-12	ABR.E	Stock	17.15	17.99	17.07	17.72	32149.0

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

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