PREVIEW / stock_daily / 2022-01-26

all stock daily files

  file:    by_date/stock_daily/2022/2022-01-26.parquet
  size:    263 KB
  rows:    8,097
  symbols: 2,615

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-26	AAPL	Stock	163.5	164.39	157.82	159.69	108275300.0
2022-01-26	MSFT	Stock	307.99	308.5	293.03	296.71	90428900.0
2022-01-26	NVDA	Stock	23.24	24.057	22.3	22.772	755959000.0
2022-01-26	AMZN	Stock	144.75	145.185	137.3185	138.8725	95602000.0
2022-01-26	GOOGL	Stock	131.119	133.0	127.142	129.233	49129500.0
2022-01-26	META	Stock	307.01	307.51	290.85	294.63	28348800.0
2022-01-26	TSLA	Stock	317.4767	329.23	302.0	312.47	104867400.0
2022-01-26	TLT	Stock	142.26	142.57	140.49	140.5	23655546.0
2022-01-26	ES	Stock	85.69	86.36	84.23	84.65	1953800.0
2022-01-26	CL	Stock	79.93	81.72	79.59	81.39	7455000.0
2022-01-26	A	Stock	135.54	138.05	132.27	133.51	1999500.0
2022-01-26	AA	Stock	61.54	63.64	59.88	60.75	9267400.0
2022-01-26	AAC-DELISTED	Stock	9.7111	9.73	9.71	9.71	150797.0
2022-01-26	AACG	Stock	1.79	1.8	1.6	1.68	64200.0
2022-01-26	AAIC-DELISTED	Stock	3.48	3.4901	3.3832	3.41	63294.0
2022-01-26	AAIC.C-DELISTED	Stock	24.9499	24.95	24.8	24.82	6343.0
2022-01-26	AAL	Stock	16.7	16.97	16.14	16.24	39331800.0
2022-01-26	AAM.A-DELISTED	Stock	25.42	25.43	25.29	25.36	46118.0
2022-01-26	AAM.B-DELISTED	Stock	26.48	26.75	26.44	26.71	32328.0
2022-01-26	AAME	Stock	2.66	2.66	2.33	2.46	18000.0
2022-01-26	AAMI	Stock	21.42	21.695	20.7	20.89	575200.0
2022-01-26	AAN-DELISTED	Stock	22.59	22.72	21.198	21.42	181800.0
2022-01-26	AAOI	Stock	4.0	4.15	3.86	3.92	421500.0
2022-01-26	AAON	Stock	44.2733	44.4867	42.0133	42.4067	257550.0
2022-01-26	AAP	Stock	232.19	232.3	223.79	225.12	645300.0
2022-01-26	AAQC-DELISTED	Stock	9.68	9.68	9.68	9.68	437.0
2022-01-26	AAT	Stock	35.9	36.48	35.06	35.26	203700.0
2022-01-26	AATC	Stock	5.75	5.8507	5.57	5.57	23690.0
2022-01-26	AAU-DELISTED	Stock	0.28	0.2898	0.28	0.285	178993.0
2022-01-26	AAUAF-DELISTED	Stock	0.28	0.2898	0.28	0.2888	182388.0
2022-01-26	AAWW-DELISTED	Stock	79.24	79.65	76.8	77.1	720640.0
2022-01-26	AAXJ	Stock	81.7	81.7	79.97	80.11	1134829.0
2022-01-26	AB	Stock	46.16	48.24	45.53	46.14	473200.0
2022-01-26	ABB-DELISTED	Stock	35.97	36.08	34.97	35.24	2504261.0
2022-01-26	ABBNY-DELISTED	Stock	35.97	36.08	34.97	35.25	2751644.0
2022-01-26	ABBV	Stock	133.29	135.48	132.83	134.23	8040300.0
2022-01-26	ABC-DELISTED	Stock	130.75	132.3093	129.095	130.53	530868.0
2022-01-26	ABCB	Stock	51.85	52.63	50.27	51.23	642600.0
2022-01-26	ABCL	Stock	8.63	8.67	7.78	7.81	2465800.0
2022-01-26	ABCM-DELISTED	Stock	17.24	17.6679	16.93	17.04	119927.0
2022-01-26	ABEO	Stock	6.75	6.75	5.75	6.0	112696.0
2022-01-26	ABEV	Stock	2.8	2.83	2.72	2.75	46485200.0
2022-01-26	ABG	Stock	167.81	168.9	157.77	158.57	194200.0
2022-01-26	ABGI-DELISTED	Stock	9.71	9.71	9.71	9.71	100.0
2022-01-26	ABM	Stock	42.66	42.76	40.75	41.17	637000.0
2022-01-26	ABMD-DELISTED	Stock	298.59	305.01	294.3	297.57	531949.0
2022-01-26	ABNB	Stock	149.285	152.4	140.041	142.14	6990300.0
2022-01-26	ABOS	Stock	5.15	5.25	4.81	4.98	875600.0
2022-01-26	ABR	Stock	17.53	17.73	17.11	17.26	2041700.0
2022-01-26	ABR.D	Stock	25.14	25.14	25.06	25.08	7108.0

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

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