PREVIEW / stock_daily / 2022-01-07

all stock daily files

  file:    by_date/stock_daily/2022/2022-01-07.parquet
  size:    262 KB
  rows:    8,032
  symbols: 2,586

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-01-07	AAPL	Stock	172.89	174.14	171.03	172.17	86709100.0
2022-01-07	MSFT	Stock	314.15	316.5	310.09	314.04	32720000.0
2022-01-07	NVDA	Stock	28.141	28.422	27.057	27.247	409939000.0
2022-01-07	AMZN	Stock	163.839	165.2435	162.031	162.554	46606000.0
2022-01-07	GOOGL	Stock	138.1455	138.4485	135.7665	137.017	29760560.0
2022-01-07	META	Stock	332.74	337.0	328.88	331.79	14722000.0
2022-01-07	TSLA	Stock	360.1233	360.31	336.6667	342.32	84164700.0
2022-01-07	TLT	Stock	143.13	143.236	141.56	142.26	18756845.0
2022-01-07	ES	Stock	88.96	90.23	88.2	89.66	1043800.0
2022-01-07	CL	Stock	84.78	84.93	84.11	84.44	2818200.0
2022-01-07	A	Stock	149.12	149.73	145.09	145.15	2058600.0
2022-01-07	AA	Stock	60.14	62.89	59.65	62.37	8071300.0
2022-01-07	AAC-DELISTED	Stock	9.75	9.78	9.75	9.76	215583.0
2022-01-07	AACG	Stock	1.93	2.94	1.85	2.64	9718000.0
2022-01-07	AACIW-DELISTED	Stock	0.5201	0.55	0.4606	0.54	66828.0
2022-01-07	AAIC-DELISTED	Stock	3.61	3.64	3.6	3.6	94790.0
2022-01-07	AAL	Stock	18.75	19.59	18.58	19.28	42399500.0
2022-01-07	AAM.A-DELISTED	Stock	25.28	25.4	25.27	25.4	13870.0
2022-01-07	AAM.B-DELISTED	Stock	26.29	26.48	26.29	26.48	4151.0
2022-01-07	AAME	Stock	2.9	2.95	2.8	2.9	8700.0
2022-01-07	AAMI	Stock	24.2	24.39	23.83	24.29	709500.0
2022-01-07	AAN-DELISTED	Stock	24.12	24.535	23.67	23.74	176400.0
2022-01-07	AAOI	Stock	4.8	4.847	4.63	4.69	556600.0
2022-01-07	AAON	Stock	50.9667	50.9667	49.3	49.3733	474450.0
2022-01-07	AAP	Stock	239.96	242.15	237.32	238.09	553600.0
2022-01-07	AAQC-DELISTED	Stock	9.72	9.72	9.72	9.72	148.0
2022-01-07	AAT	Stock	38.32	39.16	38.0	38.59	246400.0
2022-01-07	AATC	Stock	6.25	6.38	6.25	6.38	8649.0
2022-01-07	AAU-DELISTED	Stock	0.28	0.296	0.28	0.2821	650963.0
2022-01-07	AAUAF-DELISTED	Stock	0.28	0.296	0.28	0.282	654179.0
2022-01-07	AAWW-DELISTED	Stock	88.81	90.46	88.03	88.22	517358.0
2022-01-07	AAXJ	Stock	82.44	82.84	82.06	82.73	950336.0
2022-01-07	AB	Stock	47.08	48.8	46.77	48.62	263100.0
2022-01-07	ABB-DELISTED	Stock	38.09	38.25	37.8122	38.09	1250775.0
2022-01-07	ABBNY-DELISTED	Stock	38.09	38.25	37.8122	38.1	1372133.0
2022-01-07	ABBV	Stock	135.25	135.84	134.13	134.88	8630300.0
2022-01-07	ABC-DELISTED	Stock	131.11	133.48	128.9	133.12	835049.0
2022-01-07	ABCB	Stock	54.13	54.53	53.51	54.07	417200.0
2022-01-07	ABCL	Stock	12.17	12.59	11.5	11.82	1573000.0
2022-01-07	ABCM-DELISTED	Stock	21.1	21.2	20.78	20.95	46773.0
2022-01-07	ABEO	Stock	8.0	8.25	7.75	7.75	103668.0
2022-01-07	ABEV	Stock	2.6	2.63	2.57	2.59	14488900.0
2022-01-07	ABG	Stock	175.9	179.3	174.0	175.17	176600.0
2022-01-07	ABGI-DELISTED	Stock	9.77	9.77	9.765	9.765	5600.0
2022-01-07	ABM	Stock	42.4	43.56	42.4	42.88	575500.0
2022-01-07	ABMD-DELISTED	Stock	334.79	336.025	319.04	319.15	298115.0
2022-01-07	ABNB	Stock	159.18	166.88	158.455	166.05	5624600.0
2022-01-07	ABOS	Stock	5.7	6.045	5.65	5.75	103700.0
2022-01-07	ABR	Stock	18.68	18.88	18.64	18.74	1021200.0
2022-01-07	ABR.D	Stock	25.37	25.49	25.28	25.405	12459.0

> showing 50 of 8,032 rows — these rows as CSV

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