PREVIEW / stock_daily / 2022-11-09

all stock daily files

  file:    by_date/stock_daily/2022/2022-11-09.parquet
  size:    249 KB
  rows:    7,779
  symbols: 2,084

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
2022-11-09	AAPL	Stock	138.5	138.55	134.59	134.87	74917800.0
2022-11-09	MSFT	Stock	227.37	228.63	224.33	224.51	27852900.0
2022-11-09	NVDA	Stock	14.162	14.211	13.759	13.776	454414000.0
2022-11-09	AMZN	Stock	89.47	89.48	85.87	86.14	90796200.0
2022-11-09	GOOGL	Stock	88.45	89.435	87.28	87.32	31769099.0
2022-11-09	META	Stock	101.72	104.9	100.74	101.47	107677300.0
2022-11-09	TSLA	Stock	190.78	195.89	177.12	177.59	127062700.0
2022-11-09	TLT	Stock	93.82	95.02	93.69	94.61	15637456.0
2022-11-09	ES	Stock	75.8	76.34	74.79	74.91	1614100.0
2022-11-09	CL	Stock	73.77	73.88	73.42	73.46	3368700.0
2022-11-09	A	Stock	138.31	139.42	136.66	137.0	971200.0
2022-11-09	AA	Stock	42.53	42.745	40.34	40.68	4181200.0
2022-11-09	AAC-DELISTED	Stock	9.99	10.0	9.99	9.995	18583.0
2022-11-09	AACG	Stock	1.84	1.87	1.75	1.83	9400.0
2022-11-09	AAIC-DELISTED	Stock	3.04	3.12	2.984	3.03	100041.0
2022-11-09	AAIC.C-DELISTED	Stock	21.38	21.38	21.3	21.3	425.0
2022-11-09	AAL	Stock	14.12	14.34	13.97	13.98	21047200.0
2022-11-09	AAM.A-DELISTED	Stock	22.35	22.35	21.737	21.9	27638.0
2022-11-09	AAM.B-DELISTED	Stock	22.13	22.396	21.553	21.85	37097.0
2022-11-09	AAMC-DELISTED	Stock	5.0735	5.3353	4.95	5.3353	4604.0
2022-11-09	AAME	Stock	3.03	3.03	2.86	2.93	4100.0
2022-11-09	AAMI	Stock	19.14	19.36	18.39	18.56	218500.0
2022-11-09	AAN-DELISTED	Stock	10.08	10.1	9.8	10.02	359500.0
2022-11-09	AAOI	Stock	2.24	2.24	2.08	2.09	231400.0
2022-11-09	AAON	Stock	49.22	50.72	48.5467	49.6933	543900.0
2022-11-09	AAP	Stock	181.35	182.07	175.24	175.35	927900.0
2022-11-09	AAQC-DELISTED	Stock	9.93	9.935	9.92	9.92	50192.0
2022-11-09	AAT	Stock	27.48	27.77	27.08	27.22	331200.0
2022-11-09	AATC	Stock	4.25	4.25	4.11	4.11	7179.0
2022-11-09	AAU-DELISTED	Stock	0.2366	0.2479	0.23	0.2479	421362.0
2022-11-09	AAUAF-DELISTED	Stock	0.2366	0.2488	0.23	0.2488	427576.0
2022-11-09	AAWW-DELISTED	Stock	100.06	100.43	99.16	99.7	791788.0
2022-11-09	AAXJ	Stock	59.65	59.75	58.85	58.91	2885055.0
2022-11-09	AB	Stock	36.5	36.64	35.28	35.39	235300.0
2022-11-09	ABB-DELISTED	Stock	29.07	29.39	28.93	28.955	927139.0
2022-11-09	ABBNY-DELISTED	Stock	29.07	29.39	28.93	28.95	1079125.0
2022-11-09	ABBV	Stock	148.59	150.57	147.04	147.62	4573700.0
2022-11-09	ABC-DELISTED	Stock	159.66	162.39	157.81	158.16	1379962.0
2022-11-09	ABCB	Stock	51.29	51.85	51.05	51.12	288900.0
2022-11-09	ABCL	Stock	12.99	12.995	11.554	11.81	5098200.0
2022-11-09	ABCM-DELISTED	Stock	14.72	15.16	14.69	15.0	301746.0
2022-11-09	ABEO	Stock	3.74	4.25	3.6	4.11	991400.0
2022-11-09	ABEV	Stock	3.19	3.22	3.12	3.15	32807000.0
2022-11-09	ABG	Stock	164.1	165.34	159.24	159.55	121000.0
2022-11-09	ABM	Stock	43.27	43.56	42.81	43.12	167400.0
2022-11-09	ABMD-DELISTED	Stock	373.82	374.44	373.6	374.08	2248414.0
2022-11-09	ABNB	Stock	97.75	99.09	95.15	95.79	4650900.0
2022-11-09	ABOS	Stock	6.63	6.81	6.21	6.21	83100.0
2022-11-09	ABR	Stock	14.18	14.5	14.02	14.13	1975900.0
2022-11-09	ABR.D	Stock	18.4	19.12	17.61	17.6541	19732.0

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

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