PREVIEW / stock_daily / 2023-09-11

all stock daily files

  file:    by_date/stock_daily/2023/2023-09-11.parquet
  size:    236 KB
  rows:    7,379
  symbols: 1,411

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-09-11	AAPL	Stock	180.07	180.3	177.34	179.36	58953100.0
2023-09-11	MSFT	Stock	337.24	338.42	335.43	337.94	16583300.0
2023-09-11	NVDA	Stock	46.148	46.163	44.312	45.178	473966000.0
2023-09-11	AMZN	Stock	138.75	143.62	138.64	143.1	56764500.0
2023-09-11	GOOGL	Stock	136.54	137.48	135.785	136.92	20763350.0
2023-09-11	META	Stock	301.41	309.04	301.28	307.56	19489300.0
2023-09-11	TSLA	Stock	264.27	274.85	260.61	273.58	174667900.0
2023-09-11	TLT	Stock	93.7	93.98	93.55	93.69	17061472.0
2023-09-11	ES	Stock	62.04	62.71	62.02	62.36	1860000.0
2023-09-11	CL	Stock	73.2	74.13	73.19	73.95	3286600.0
2023-09-11	A	Stock	114.29	114.39	112.62	113.1	2046900.0
2023-09-11	AA	Stock	28.82	29.05	28.43	28.68	5012400.0
2023-09-11	AAC-DELISTED	Stock	10.72	10.72	10.7	10.705	24786.0
2023-09-11	AACG	Stock	1.18	1.21	1.12	1.12	9900.0
2023-09-11	AACT	Stock	10.24	10.29	10.24	10.29	34500.0
2023-09-11	AAIC-DELISTED	Stock	4.68	4.68	4.6	4.61	58313.0
2023-09-11	AAIC.C-DELISTED	Stock	24.8	24.8	24.48	24.5	8067.0
2023-09-11	AAL	Stock	14.02	14.19	13.94	14.09	20957900.0
2023-09-11	AAM.A-DELISTED	Stock	24.97	25.0	24.97	25.0	18518.0
2023-09-11	AAM.B-DELISTED	Stock	24.98	24.9877	24.97	24.9801	9855.0
2023-09-11	AAMC-DELISTED	Stock	3.9647	4.4412	3.9647	4.1765	92650.0
2023-09-11	AAME	Stock	1.96	1.96	1.96	1.96	900.0
2023-09-11	AAMI	Stock	20.57	20.7	20.4	20.49	121600.0
2023-09-11	AAN-DELISTED	Stock	10.4	10.501	10.195	10.26	570500.0
2023-09-11	AAOI	Stock	12.08	12.08	11.43	11.65	1532900.0
2023-09-11	AAON	Stock	65.81	66.37	64.52	64.73	394100.0
2023-09-11	AAP	Stock	64.78	65.01	62.44	62.54	1872200.0
2023-09-11	AAT	Stock	20.66	20.8	20.35	20.48	394100.0
2023-09-11	AATC	Stock	6.04	6.05	5.93	6.05	7596.0
2023-09-11	AAU-DELISTED	Stock	0.121	0.1262	0.12	0.1243	127893.0
2023-09-11	AAUAF-DELISTED	Stock	0.121	0.1262	0.12	0.1243	133668.0
2023-09-11	AAXJ	Stock	65.47	65.685	65.3	65.61	202515.0
2023-09-11	AB	Stock	32.07	32.61	31.99	32.0	207300.0
2023-09-11	ABBNY-DELISTED	Stock	37.01	37.14	36.89	37.02	230545.0
2023-09-11	ABBV	Stock	148.86	149.41	148.42	149.04	2911600.0
2023-09-11	ABCB	Stock	39.35	39.65	38.75	38.92	386500.0
2023-09-11	ABCL	Stock	5.42	5.45	5.265	5.36	1461500.0
2023-09-11	ABCM-DELISTED	Stock	22.89	22.98	22.74	22.74	3644300.0
2023-09-11	ABEO	Stock	4.1	4.41	4.03	4.39	103600.0
2023-09-11	ABEV	Stock	2.75	2.79	2.75	2.78	7540300.0
2023-09-11	ABG	Stock	225.58	225.58	220.94	221.04	121500.0
2023-09-11	ABLLW	Stock	0.4666	0.4666	0.3995	0.41	9855.0
2023-09-11	ABLV	Stock	2.82	2.88	2.781	2.85	15500.0
2023-09-11	ABLVW	Stock	0.06	0.06	0.025	0.034	8374.0
2023-09-11	ABM	Stock	39.65	40.38	38.89	39.1	441600.0
2023-09-11	ABNB	Stock	146.22	148.25	144.86	147.33	7179000.0
2023-09-11	ABOS	Stock	5.66	5.76	5.54	5.66	107100.0
2023-09-11	ABR	Stock	16.0	16.07	15.84	15.99	2091600.0
2023-09-11	ABR.D	Stock	19.0	19.0	18.7007	18.97	3707.0
2023-09-11	ABR.E	Stock	18.3	18.7134	18.3	18.6999	7347.0

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

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