PREVIEW / stock_daily / 2022-01-27

all stock daily files

  file:    by_date/stock_daily/2022/2022-01-27.parquet
  size:    264 KB
  rows:    8,176
  symbols: 2,678

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-27	AAPL	Stock	162.45	163.84	158.28	159.22	121954600.0
2022-01-27	MSFT	Stock	302.66	307.3	297.93	299.84	53481300.0
2022-01-27	NVDA	Stock	23.568	23.995	21.675	21.944	573353000.0
2022-01-27	AMZN	Stock	140.8	144.2435	139.35	139.6375	77516000.0
2022-01-27	GOOGL	Stock	131.304	132.6522	128.9323	129.005	32018780.0
2022-01-27	META	Stock	297.75	301.71	294.26	294.64	21629900.0
2022-01-27	TSLA	Stock	311.12	311.7967	276.3333	276.3667	147109500.0
2022-01-27	TLT	Stock	142.41	143.365	142.33	143.08	21501789.0
2022-01-27	ES	Stock	85.32	86.79	84.97	85.74	1104900.0
2022-01-27	CL	Stock	81.96	83.61	81.6	82.7	6242100.0
2022-01-27	A	Stock	135.28	136.36	131.68	132.09	1715800.0
2022-01-27	AA	Stock	60.6	61.66	57.47	58.03	6441500.0
2022-01-27	AAC-DELISTED	Stock	9.72	9.72	9.7	9.715	2592011.0
2022-01-27	AACG	Stock	1.64	1.71	1.54	1.54	49600.0
2022-01-27	AACIW-DELISTED	Stock	0.3151	0.33245	0.2798	0.28	163470.0
2022-01-27	AAIC-DELISTED	Stock	3.4	3.43	3.31	3.31	106370.0
2022-01-27	AAIC.C-DELISTED	Stock	24.9	24.92	24.847	24.91	5500.0
2022-01-27	AAL	Stock	16.43	16.84	15.62	15.78	43507400.0
2022-01-27	AAM.A-DELISTED	Stock	25.42	25.73	25.38	25.59	81155.0
2022-01-27	AAM.B-DELISTED	Stock	26.69	26.8	26.57	26.77	71237.0
2022-01-27	AAME	Stock	2.47	2.57	2.28	2.49	21000.0
2022-01-27	AAMI	Stock	21.1	21.38	20.5	20.52	663000.0
2022-01-27	AAN-DELISTED	Stock	21.42	21.58	20.491	20.72	193300.0
2022-01-27	AAOI	Stock	3.99	3.99	3.75	3.77	350100.0
2022-01-27	AAON	Stock	42.58	42.96	41.2267	41.3067	232050.0
2022-01-27	AAP	Stock	227.66	229.68	224.94	225.11	558500.0
2022-01-27	AAQC-DELISTED	Stock	9.68	9.69	9.68	9.68	971.0
2022-01-27	AAT	Stock	35.37	35.84	34.47	34.71	192800.0
2022-01-27	AATC	Stock	5.92	6.21	5.89	6.18	106819.0
2022-01-27	AAU-DELISTED	Stock	0.285	0.2888	0.2839	0.285	359374.0
2022-01-27	AAUAF-DELISTED	Stock	0.285	0.2888	0.2839	0.285	367484.0
2022-01-27	AAWW-DELISTED	Stock	78.22	79.32	75.61	76.17	328620.0
2022-01-27	AAXJ	Stock	79.77	79.82	78.76	78.76	785278.0
2022-01-27	AB	Stock	46.77	47.63	45.21	46.21	501400.0
2022-01-27	ABB-DELISTED	Stock	35.23	35.461	34.37	34.53	2717587.0
2022-01-27	ABBNY-DELISTED	Stock	35.23	35.461	34.37	34.54	2976279.0
2022-01-27	ABBV	Stock	135.5	138.3	135.36	135.97	8869100.0
2022-01-27	ABC-DELISTED	Stock	131.03	135.1	131.03	134.56	861467.0
2022-01-27	ABCB	Stock	51.37	51.83	49.18	49.67	460300.0
2022-01-27	ABCL	Stock	8.05	8.05	7.621	7.77	2161900.0
2022-01-27	ABCM-DELISTED	Stock	17.09	17.42	16.89	17.0	105599.0
2022-01-27	ABEO	Stock	6.5	6.5	5.5	5.5	87464.0
2022-01-27	ABEV	Stock	2.78	2.87	2.78	2.83	29825900.0
2022-01-27	ABG	Stock	159.82	161.88	153.96	154.94	161000.0
2022-01-27	ABGI-DELISTED	Stock	9.7	9.7	9.7	9.7	300.0
2022-01-27	ABM	Stock	41.18	41.9	40.1	40.42	531300.0
2022-01-27	ABMD-DELISTED	Stock	300.83	300.83	275.0	277.08	231223.0
2022-01-27	ABNB	Stock	143.48	145.548	137.92	138.41	4493800.0
2022-01-27	ABOS	Stock	4.97	4.97	4.615	4.85	212800.0
2022-01-27	ABR	Stock	17.45	17.55	16.82	16.99	2017700.0

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

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