PREVIEW / stock_daily / 2022-11-08

all stock daily files

  file:    by_date/stock_daily/2022/2022-11-08.parquet
  size:    251 KB
  rows:    7,796
  symbols: 2,068

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-08	AAPL	Stock	140.41	141.43	137.49	139.5	89908500.0
2022-11-08	MSFT	Stock	228.7	231.65	225.84	228.87	28192500.0
2022-11-08	NVDA	Stock	14.801	14.891	14.216	14.602	595292000.0
2022-11-08	AMZN	Stock	90.79	91.72	88.23	89.98	88703400.0
2022-11-08	GOOGL	Stock	88.9	90.32	87.5901	88.9	30429025.0
2022-11-08	META	Stock	95.92	97.8	94.79	96.47	52088300.0
2022-11-08	TSLA	Stock	194.02	195.2	186.75	191.3	128803400.0
2022-11-08	TLT	Stock	93.8	94.96	93.7698	94.3	20360550.0
2022-11-08	ES	Stock	75.37	76.49	75.13	75.95	1489100.0
2022-11-08	CL	Stock	73.87	74.75	73.35	73.81	3291500.0
2022-11-08	A	Stock	138.5	140.69	136.6	138.75	1028100.0
2022-11-08	AA	Stock	42.18	43.385	41.46	43.23	4740200.0
2022-11-08	AAC-DELISTED	Stock	9.98	10.0	9.98	10.0	58665.0
2022-11-08	AACG	Stock	1.86	1.88	1.82	1.87	12400.0
2022-11-08	AACIW-DELISTED	Stock	0.05	0.0517	0.05	0.0517	4800.0
2022-11-08	AAIC-DELISTED	Stock	3.05	3.12	3.0	3.105	122263.0
2022-11-08	AAL	Stock	14.29	14.45	14.08	14.25	25415700.0
2022-11-08	AAM.A-DELISTED	Stock	21.55	22.35	21.55	22.34	32662.0
2022-11-08	AAM.B-DELISTED	Stock	21.61	22.36	21.3533	22.31	15987.0
2022-11-08	AAMC-DELISTED	Stock	5.5853	5.6588	5.5735	5.5735	2387.0
2022-11-08	AAME	Stock	3.13	3.13	2.88	2.88	800.0
2022-11-08	AAMI	Stock	19.43	19.7	19.14	19.27	296800.0
2022-11-08	AAN-DELISTED	Stock	9.98	10.13	9.73	10.12	432300.0
2022-11-08	AAOI	Stock	2.18	2.22	2.12	2.15	156600.0
2022-11-08	AAON	Stock	48.0933	53.66	47.7333	49.8333	1039200.0
2022-11-08	AAP	Stock	184.26	184.73	180.09	182.64	571200.0
2022-11-08	AAQC-DELISTED	Stock	9.94	9.94	9.92	9.94	128086.0
2022-11-08	AAT	Stock	28.05	28.15	27.42	27.7	248100.0
2022-11-08	AATC	Stock	4.3299	4.4	4.25	4.25	10674.0
2022-11-08	AAU-DELISTED	Stock	0.2319	0.243	0.2298	0.24	490951.0
2022-11-08	AAUAF-DELISTED	Stock	0.2319	0.243	0.2298	0.24	494823.0
2022-11-08	AAWW-DELISTED	Stock	100.49	100.67	100.0	100.1	283363.0
2022-11-08	AAXJ	Stock	59.69	60.33	59.53	60.07	661355.0
2022-11-08	AB	Stock	36.42	37.18	36.23	36.77	252600.0
2022-11-08	ABB-DELISTED	Stock	28.96	29.285	28.845	29.07	845767.0
2022-11-08	ABBNY-DELISTED	Stock	28.96	29.285	28.845	29.07	998405.0
2022-11-08	ABBV	Stock	148.83	151.63	147.96	148.53	4637500.0
2022-11-08	ABC-DELISTED	Stock	154.91	160.145	154.91	159.62	5558228.0
2022-11-08	ABCB	Stock	52.21	52.5	51.55	51.78	350100.0
2022-11-08	ABCL	Stock	12.0	12.55	11.82	12.24	2499700.0
2022-11-08	ABCM-DELISTED	Stock	14.49	15.28	14.44	15.02	223249.0
2022-11-08	ABEO	Stock	3.84	4.24	3.62	3.81	1225000.0
2022-11-08	ABEV	Stock	3.14	3.22	3.13	3.2	32263600.0
2022-11-08	ABG	Stock	161.85	165.51	159.9	165.03	159400.0
2022-11-08	ABGI-DELISTED	Stock	9.97	9.97	9.97	9.97	300.0
2022-11-08	ABLV	Stock	10.05	10.06	10.05	10.06	26000.0
2022-11-08	ABM	Stock	43.5	44.36	43.15	43.74	179700.0
2022-11-08	ABMD-DELISTED	Stock	373.6	374.45	373.26	374.0	1285030.0
2022-11-08	ABNB	Stock	95.53	101.919	94.27	98.9	7829400.0
2022-11-08	ABOS	Stock	6.48	7.0	6.42	6.71	107500.0

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

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