PREVIEW / stock_daily / 2022-03-11

all stock daily files

  file:    by_date/stock_daily/2022/2022-03-11.parquet
  size:    259 KB
  rows:    7,996
  symbols: 2,491

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-03-11	AAPL	Stock	158.93	159.28	154.5	154.73	96970100.0
2022-03-11	MSFT	Stock	287.96	289.51	279.43	280.07	27209300.0
2022-03-11	NVDA	Stock	23.022	23.145	22.046	22.1	367209000.0
2022-03-11	AMZN	Stock	149.5745	149.675	145.369	145.5245	68900000.0
2022-03-11	GOOGL	Stock	133.4885	133.7955	129.6315	129.8705	31526440.0
2022-03-11	META	Stock	192.64	193.56	186.67	187.61	34694500.0
2022-03-11	TSLA	Stock	280.0667	281.2667	264.59	265.1167	67037100.0
2022-03-11	TLT	Stock	134.33	135.45	134.21	134.91	15583795.0
2022-03-11	ES	Stock	84.56	85.12	83.72	83.81	1998200.0
2022-03-11	CL	Stock	74.21	75.18	73.7	73.77	4278900.0
2022-03-11	A	Stock	135.43	136.44	130.16	130.31	1815700.0
2022-03-11	AA	Stock	80.49	81.867	78.65	79.04	5690000.0
2022-03-11	AAC-DELISTED	Stock	9.7543	9.76	9.75	9.75	33606.0
2022-03-11	AACG	Stock	1.25	1.25	1.18	1.18	23100.0
2022-03-11	AACIW-DELISTED	Stock	0.33	0.33	0.3236	0.3257	2620.0
2022-03-11	AAIC-DELISTED	Stock	3.5	3.61	3.5	3.61	92892.0
2022-03-11	AAIC.C-DELISTED	Stock	25.12	25.2	25.05	25.05	8362.0
2022-03-11	AAL	Stock	14.4	14.56	13.9	14.02	48409500.0
2022-03-11	AAM.A-DELISTED	Stock	24.9975	25.0	24.94	24.94	7818.0
2022-03-11	AAM.B-DELISTED	Stock	25.11	25.3	25.1	25.15	12064.0
2022-03-11	AAME	Stock	2.26	2.41	2.26	2.34	6000.0
2022-03-11	AAMI	Stock	23.96	24.19	23.6	23.63	572300.0
2022-03-11	AAN-DELISTED	Stock	21.82	22.3	21.08	21.84	318200.0
2022-03-11	AAOI	Stock	3.67	3.67	3.45	3.45	148500.0
2022-03-11	AAON	Stock	36.46	36.6667	35.6667	35.8933	223050.0
2022-03-11	AAP	Stock	205.58	207.5	203.86	204.08	527500.0
2022-03-11	AAQC-DELISTED	Stock	9.715	9.73	9.71	9.73	88270.0
2022-03-11	AAT	Stock	36.79	37.27	36.29	36.39	199200.0
2022-03-11	AATC	Stock	6.75	6.75	6.52	6.52	3192.0
2022-03-11	AAU-DELISTED	Stock	0.4595	0.47	0.375	0.391	10829351.0
2022-03-11	AAUAF-DELISTED	Stock	0.4595	0.47	0.375	0.3964	10880336.0
2022-03-11	AAWW-DELISTED	Stock	82.42	83.26	81.01	81.01	237001.0
2022-03-11	AAXJ	Stock	73.32	73.4	71.13	71.14	1766597.0
2022-03-11	AB	Stock	44.61	44.95	43.83	43.84	210600.0
2022-03-11	ABB-DELISTED	Stock	33.32	33.41	32.49	32.5	1963590.0
2022-03-11	ABBNY-DELISTED	Stock	33.32	33.41	32.49	32.5	2239995.0
2022-03-11	ABBV	Stock	149.34	150.4	148.98	149.06	5171400.0
2022-03-11	ABC-DELISTED	Stock	146.09	147.53	144.46	144.56	738130.0
2022-03-11	ABCB	Stock	46.97	48.07	46.78	47.81	501700.0
2022-03-11	ABCL	Stock	8.45	8.46	7.73	7.75	1948700.0
2022-03-11	ABCM-DELISTED	Stock	15.89	16.02	15.63	15.64	75518.0
2022-03-11	ABEO	Stock	7.5	8.0	7.0	7.0	85296.0
2022-03-11	ABEV	Stock	2.67	2.68	2.59	2.6	22138400.0
2022-03-11	ABG	Stock	183.35	190.12	183.35	187.95	300600.0
2022-03-11	ABGI-DELISTED	Stock	9.76	9.77	9.76	9.76	500.0
2022-03-11	ABM	Stock	46.27	46.42	45.56	46.0	292900.0
2022-03-11	ABMD-DELISTED	Stock	309.35	309.35	286.73	286.79	116341.0
2022-03-11	ABNB	Stock	154.13	155.0	145.0	145.14	4577300.0
2022-03-11	ABOS	Stock	5.81	5.98	5.46	5.51	188000.0
2022-03-11	ABR	Stock	17.69	17.89	17.48	17.49	1635700.0

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

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