PREVIEW / stock_daily / 2022-01-06

all stock daily files

  file:    by_date/stock_daily/2022/2022-01-06.parquet
  size:    261 KB
  rows:    8,029
  symbols: 2,593

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-06	AAPL	Stock	172.7	175.3	171.64	172.0	96904000.0
2022-01-06	MSFT	Stock	313.15	318.7	311.49	313.88	39646100.0
2022-01-06	NVDA	Stock	27.64	28.438	27.065	28.178	454186000.0
2022-01-06	AMZN	Stock	163.4505	164.8	161.937	163.254	51958000.0
2022-01-06	GOOGL	Stock	136.9985	139.94	136.5585	137.7475	37347420.0
2022-01-06	META	Stock	322.82	339.17	322.72	332.46	27962800.0
2022-01-06	TSLA	Stock	359.0	362.6667	340.1667	354.9	90336600.0
2022-01-06	TLT	Stock	142.59	143.44	142.29	143.29	18996353.0
2022-01-06	ES	Stock	89.35	89.83	88.52	88.9	1146400.0
2022-01-06	CL	Stock	84.98	85.61	84.16	84.66	4154800.0
2022-01-06	A	Stock	148.85	149.96	145.58	149.12	2298300.0
2022-01-06	AA	Stock	58.94	59.491	57.25	58.45	4363100.0
2022-01-06	AAC-DELISTED	Stock	9.79	9.79	9.75	9.76	35803.0
2022-01-06	AACG	Stock	1.89	2.34	1.87	1.98	2050700.0
2022-01-06	AACIW-DELISTED	Stock	0.5596	0.5955	0.5593	0.5955	2740.0
2022-01-06	AAIC-DELISTED	Stock	3.55	3.61	3.55	3.59	62046.0
2022-01-06	AAIC.C-DELISTED	Stock	25.195	25.195	25.17	25.17	400.0
2022-01-06	AAL	Stock	18.89	19.06	18.35	18.57	19097700.0
2022-01-06	AAM.A-DELISTED	Stock	25.2828	25.34	25.27	25.32	13534.0
2022-01-06	AAM.B-DELISTED	Stock	26.43	26.48	26.121	26.48	3415.0
2022-01-06	AAME	Stock	2.94	3.09	2.9	2.91	17400.0
2022-01-06	AAMI	Stock	24.37	24.56	24.02	24.26	511900.0
2022-01-06	AAN-DELISTED	Stock	24.14	24.67	24.07	24.42	133100.0
2022-01-06	AAOI	Stock	5.0	5.072	4.76	4.77	991200.0
2022-01-06	AAON	Stock	50.4867	51.28	50.38	50.8733	361350.0
2022-01-06	AAP	Stock	237.85	242.36	236.56	241.65	602500.0
2022-01-06	AAQC-DELISTED	Stock	9.72	9.72	9.72	9.72	227.0
2022-01-06	AAT	Stock	38.36	38.71	38.32	38.43	172400.0
2022-01-06	AATC	Stock	6.4	6.4	6.22	6.27	20003.0
2022-01-06	AAU-DELISTED	Stock	0.3	0.307	0.2848	0.2918	663858.0
2022-01-06	AAUAF-DELISTED	Stock	0.3	0.307	0.2848	0.2875	667700.0
2022-01-06	AAWW-DELISTED	Stock	90.8946	91.37	88.05	89.03	625525.0
2022-01-06	AAXJ	Stock	81.73	82.3	81.41	81.96	597357.0
2022-01-06	AB	Stock	46.83	47.4	46.51	46.91	288000.0
2022-01-06	ABB-DELISTED	Stock	38.31	38.55	38.19	38.26	1596357.0
2022-01-06	ABBNY-DELISTED	Stock	38.31	38.55	38.19	38.27	1772987.0
2022-01-06	ABBV	Stock	136.4	136.66	135.16	135.23	4667000.0
2022-01-06	ABC-DELISTED	Stock	132.67	132.995	130.16	130.45	492037.0
2022-01-06	ABCB	Stock	52.78	54.39	52.44	53.97	359000.0
2022-01-06	ABCL	Stock	12.316	12.4	11.432	12.09	2127100.0
2022-01-06	ABCM-DELISTED	Stock	21.27	21.48	21.0	21.13	59535.0
2022-01-06	ABEO	Stock	8.0	8.5	7.5	8.0	78608.0
2022-01-06	ABEV	Stock	2.63	2.64	2.58	2.6	14208900.0
2022-01-06	ABG	Stock	174.64	177.28	171.26	174.38	312900.0
2022-01-06	ABGI-DELISTED	Stock	9.75	9.79	9.75	9.77	118400.0
2022-01-06	ABM	Stock	42.86	43.75	42.37	42.47	477900.0
2022-01-06	ABMD-DELISTED	Stock	337.53	343.36	326.0	336.36	114290.0
2022-01-06	ABNB	Stock	160.29	163.73	156.34	159.75	5049600.0
2022-01-06	ABOS	Stock	5.95	6.1	5.65	5.73	57100.0
2022-01-06	ABR	Stock	18.57	18.8	18.5	18.66	1102200.0

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

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