PREVIEW / stock_daily / 2022-09-09

all stock daily files

  file:    by_date/stock_daily/2022/2022-09-09.parquet
  size:    252 KB
  rows:    7,867
  symbols: 2,195

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-09-09	AAPL	Stock	155.47	157.82	154.75	157.37	68028800.0
2022-09-09	MSFT	Stock	260.5	265.23	260.29	264.46	22084700.0
2022-09-09	NVDA	Stock	14.157	14.474	14.126	14.387	486612000.0
2022-09-09	AMZN	Stock	130.91	133.69	130.76	133.27	49387600.0
2022-09-09	GOOGL	Stock	109.065	110.99	109.02	110.65	23213585.0
2022-09-09	META	Stock	163.25	169.54	163.02	169.15	22086800.0
2022-09-09	TSLA	Stock	291.67	299.85	291.25	299.68	54338100.0
2022-09-09	TLT	Stock	108.33	108.795	107.63	108.31	12529797.0
2022-09-09	ES	Stock	91.74	92.19	90.95	91.63	1420200.0
2022-09-09	CL	Stock	77.62	78.82	77.21	78.03	6405300.0
2022-09-09	A	Stock	135.98	137.92	135.43	137.63	2425200.0
2022-09-09	AA	Stock	50.4	53.07	50.27	52.62	7268800.0
2022-09-09	AAC-DELISTED	Stock	9.91	9.92	9.91	9.915	52514.0
2022-09-09	AACG	Stock	2.12	2.18	1.96	2.04	31200.0
2022-09-09	AACIW-DELISTED	Stock	0.18	0.18	0.0921	0.107	21038.0
2022-09-09	AAIC-DELISTED	Stock	3.22	3.235	3.14	3.2	55483.0
2022-09-09	AAIC.C-DELISTED	Stock	21.38	21.38	21.37	21.37	849.0
2022-09-09	AAL	Stock	14.1	14.25	14.01	14.19	23927900.0
2022-09-09	AAM.A-DELISTED	Stock	23.65	24.15	23.65	24.15	20258.0
2022-09-09	AAM.B-DELISTED	Stock	23.67	24.08	23.65	23.97	15815.0
2022-09-09	AAMC-DELISTED	Stock	5.7324	5.8221	5.4029	5.6559	111659.0
2022-09-09	AAME	Stock	2.86	3.05	2.86	3.03	2800.0
2022-09-09	AAMI	Stock	18.09	18.53	18.09	18.43	171800.0
2022-09-09	AAN-DELISTED	Stock	11.83	12.28	11.83	12.26	256600.0
2022-09-09	AAOI	Stock	2.4	2.54	2.4	2.5	151200.0
2022-09-09	AAON	Stock	38.22	38.7933	37.86	38.3667	209400.0
2022-09-09	AAP	Stock	180.3	181.96	179.85	180.65	520900.0
2022-09-09	AAQC-DELISTED	Stock	9.82	9.83	9.81	9.82	1051.0
2022-09-09	AAT	Stock	28.21	28.31	28.03	28.05	136800.0
2022-09-09	AATC	Stock	5.06	5.1101	5.01	5.09	16196.0
2022-09-09	AAU-DELISTED	Stock	0.2229	0.2329	0.2229	0.2306	232161.0
2022-09-09	AAUAF-DELISTED	Stock	0.2229	0.2329	0.2229	0.2328	265072.0
2022-09-09	AAWW-DELISTED	Stock	99.99	100.09	99.9	99.91	422117.0
2022-09-09	AAXJ	Stock	65.75	66.17	65.75	66.06	390193.0
2022-09-09	AB	Stock	43.62	44.2	43.62	43.98	170000.0
2022-09-09	ABB-DELISTED	Stock	28.41	28.695	28.405	28.52	1641974.0
2022-09-09	ABBNY-DELISTED	Stock	28.41	28.695	28.405	28.52	1857765.0
2022-09-09	ABBV	Stock	140.4	142.17	140.1	141.42	4427000.0
2022-09-09	ABC-DELISTED	Stock	147.54	148.02	146.63	147.27	527899.0
2022-09-09	ABCB	Stock	47.12	47.72	46.22	47.32	201600.0
2022-09-09	ABCL	Stock	11.39	11.57	11.19	11.2	1003000.0
2022-09-09	ABCM-DELISTED	Stock	14.74	15.21	14.74	15.12	191171.0
2022-09-09	ABEO	Stock	3.82	4.08	3.82	3.92	92100.0
2022-09-09	ABEV	Stock	2.95	3.02	2.94	3.0	9843100.0
2022-09-09	ABG	Stock	166.35	171.8	165.72	170.69	115800.0
2022-09-09	ABGI-DELISTED	Stock	9.9	9.9	9.88	9.88	25300.0
2022-09-09	ABM	Stock	47.2	48.0	45.97	46.0	479800.0
2022-09-09	ABMD-DELISTED	Stock	276.8	283.55	274.06	282.19	147075.0
2022-09-09	ABNB	Stock	120.018	123.71	119.9	123.48	5413300.0
2022-09-09	ABOS	Stock	6.69	6.792	6.55	6.74	103900.0

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

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