PREVIEW / stock_daily / 2023-10-12

all stock daily files

  file:    by_date/stock_daily/2023/2023-10-12.parquet
  size:    235 KB
  rows:    7,371
  symbols: 1,370

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-10-12	AAPL	Stock	180.07	182.34	179.04	180.71	56743100.0
2023-10-12	MSFT	Stock	330.57	333.63	328.72	331.16	19313100.0
2023-10-12	NVDA	Stock	46.777	47.609	46.33	46.945	481325000.0
2023-10-12	AMZN	Stock	132.17	134.48	131.23	132.33	55528600.0
2023-10-12	GOOGL	Stock	141.05	141.22	138.26	138.97	24765537.0
2023-10-12	META	Stock	328.0	330.54	322.69	324.16	20530500.0
2023-10-12	TSLA	Stock	262.92	265.41	256.63	258.87	111508100.0
2023-10-12	TLT	Stock	88.05	88.1894	85.925	86.07	66986734.0
2023-10-12	ES	Stock	58.79	59.26	54.14	54.56	6297000.0
2023-10-12	CL	Stock	68.85	70.16	68.54	69.7	7153500.0
2023-10-12	A	Stock	113.11	113.4	108.33	108.94	3622500.0
2023-10-12	AA	Stock	28.04	28.06	26.41	26.9	4851800.0
2023-10-12	AAC-DELISTED	Stock	10.77	10.77	10.76	10.77	5358.0
2023-10-12	AACG	Stock	1.1	1.1	1.1	1.1	3000.0
2023-10-12	AACIW-DELISTED	Stock	0.08	0.08	0.08	0.08	100.0
2023-10-12	AACT	Stock	10.28	10.283	10.28	10.283	1900.0
2023-10-12	AAIC-DELISTED	Stock	4.47	4.47	4.38	4.43	41412.0
2023-10-12	AAIC.C-DELISTED	Stock	23.99	24.0	23.9	24.0	6200.0
2023-10-12	AAL	Stock	12.6	12.62	11.93	12.06	50281200.0
2023-10-12	AAMC-DELISTED	Stock	3.9824	4.0059	3.8824	4.0059	17850.0
2023-10-12	AAME	Stock	1.86	1.86	1.86	1.86	300.0
2023-10-12	AAMI	Stock	17.7	17.95	17.37	17.6	212300.0
2023-10-12	AAN-DELISTED	Stock	9.98	10.01	9.36	9.55	326100.0
2023-10-12	AAOI	Stock	7.84	8.67	7.8	7.95	1913600.0
2023-10-12	AAON	Stock	58.74	58.74	57.08	57.42	209300.0
2023-10-12	AAP	Stock	51.1	51.49	49.46	49.97	1594400.0
2023-10-12	AAT	Stock	18.81	18.81	18.25	18.44	182000.0
2023-10-12	AATC	Stock	5.51	5.6	5.5	5.6	10322.0
2023-10-12	AAU-DELISTED	Stock	0.136	0.136	0.13	0.1301	110317.0
2023-10-12	AAUAF-DELISTED	Stock	0.136	0.136	0.13	0.1301	93628.0
2023-10-12	AAXJ	Stock	64.83	64.83	63.92	64.03	527834.0
2023-10-12	AB	Stock	30.39	30.5	29.85	29.94	213300.0
2023-10-12	ABAT	Stock	7.13	7.25	6.93	7.14	248910.0
2023-10-12	ABBNY-DELISTED	Stock	37.15	37.18	36.68	36.71	1053027.0
2023-10-12	ABBV	Stock	148.13	148.6	147.01	148.3	4554400.0
2023-10-12	ABCB	Stock	39.34	39.34	38.43	38.7	192400.0
2023-10-12	ABCL	Stock	4.41	4.41	3.92	3.98	4206000.0
2023-10-12	ABCM-DELISTED	Stock	22.82	22.865	22.63	22.65	12369953.0
2023-10-12	ABEO	Stock	4.22	4.34	4.09	4.21	111200.0
2023-10-12	ABEV	Stock	2.68	2.72	2.54	2.54	5687200.0
2023-10-12	ABG	Stock	217.63	217.63	207.83	212.69	134100.0
2023-10-12	ABLLW	Stock	0.3396	0.38	0.265	0.3512	139580.0
2023-10-12	ABLV	Stock	3.41	3.6	3.05	3.05	27600.0
2023-10-12	ABLVW	Stock	0.0255	0.0255	0.0251	0.0251	4251.0
2023-10-12	ABM	Stock	43.89	43.95	43.2	43.72	438200.0
2023-10-12	ABNB	Stock	130.29	130.41	124.82	125.97	4023300.0
2023-10-12	ABOS	Stock	4.13	4.17	3.75	3.77	534900.0
2023-10-12	ABR	Stock	14.64	14.73	14.13	14.31	2752400.0
2023-10-12	ABR.D	Stock	17.18	17.38	17.0	17.0	21277.0
2023-10-12	ABR.E	Stock	17.15	17.39	16.67	16.7899	8524.0

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

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