PREVIEW / stock_daily / 2022-03-15

all stock daily files

  file:    by_date/stock_daily/2022/2022-03-15.parquet
  size:    259 KB
  rows:    8,004
  symbols: 2,481

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-15	AAPL	Stock	150.9	155.57	150.38	155.09	92964300.0
2022-03-15	MSFT	Stock	280.35	287.82	278.73	287.15	34245100.0
2022-03-15	NVDA	Stock	21.518	23.038	21.322	22.973	491996000.0
2022-03-15	AMZN	Stock	142.85	147.985	142.0	147.3665	75584000.0
2022-03-15	GOOGL	Stock	126.976	129.8545	125.7205	129.198	30919520.0
2022-03-15	META	Stock	190.8	192.28	185.91	192.03	31721700.0
2022-03-15	TSLA	Stock	258.4233	268.5233	252.19	267.2967	66841200.0
2022-03-15	TLT	Stock	132.86	133.15	131.19	131.53	17518754.0
2022-03-15	ES	Stock	84.01	84.27	83.36	84.17	3722500.0
2022-03-15	CL	Stock	74.8	75.74	74.52	75.49	4319400.0
2022-03-15	A	Stock	129.22	131.15	128.87	130.28	1649200.0
2022-03-15	AA	Stock	71.07	74.0	69.93	73.71	7090300.0
2022-03-15	AAC-DELISTED	Stock	9.76	9.77	9.75	9.76	527266.0
2022-03-15	AACG	Stock	1.25	1.25	1.17	1.18	13900.0
2022-03-15	AACIU	Stock	9.89	9.89	9.83	9.83	3003.0
2022-03-15	AACIW-DELISTED	Stock	0.33	0.33	0.24	0.3182	7942.0
2022-03-15	AAIC-DELISTED	Stock	3.61	3.65	3.5	3.52	70756.0
2022-03-15	AAIC.C-DELISTED	Stock	25.2799	25.2799	24.7201	24.7201	1007.0
2022-03-15	AAL	Stock	14.91	15.8	14.9	15.57	76398400.0
2022-03-15	AAM.A-DELISTED	Stock	24.86	24.97	24.82	24.9	14215.0
2022-03-15	AAM.B-DELISTED	Stock	25.09	25.19	25.05	25.19	70266.0
2022-03-15	AAME	Stock	2.34	2.5	2.27	2.35	15800.0
2022-03-15	AAMI	Stock	24.34	24.63	23.91	24.48	710000.0
2022-03-15	AAN-DELISTED	Stock	21.87	22.52	21.47	22.0	235900.0
2022-03-15	AAOI	Stock	3.0	3.17	3.0	3.14	144200.0
2022-03-15	AAON	Stock	35.5267	36.16	35.1467	36.1333	500850.0
2022-03-15	AAP	Stock	201.24	204.95	199.51	204.27	814700.0
2022-03-15	AAQC-DELISTED	Stock	9.74	9.74	9.71	9.7264	59785.0
2022-03-15	AAT	Stock	36.27	36.72	35.81	36.07	329700.0
2022-03-15	AATC	Stock	6.7381	6.7381	6.4202	6.43	10654.0
2022-03-15	AAU-DELISTED	Stock	0.36	0.3646	0.3206	0.33	1458630.0
2022-03-15	AAUAF-DELISTED	Stock	0.36	0.3646	0.3206	0.34	1479307.0
2022-03-15	AAWW-DELISTED	Stock	81.52	84.25	80.96	84.2	594175.0
2022-03-15	AAXJ	Stock	68.4	69.63	67.99	69.55	5299336.0
2022-03-15	AB	Stock	42.6	43.49	42.48	42.85	397100.0
2022-03-15	ABB-DELISTED	Stock	33.09	33.4	32.84	33.3	2226541.0
2022-03-15	ABBNY-DELISTED	Stock	33.09	33.4	32.84	33.31	2506123.0
2022-03-15	ABBV	Stock	152.26	156.43	152.16	155.88	8384300.0
2022-03-15	ABC-DELISTED	Stock	146.97	151.55	146.53	151.43	1316642.0
2022-03-15	ABCB	Stock	47.16	47.85	46.69	47.25	366500.0
2022-03-15	ABCL	Stock	7.53	7.93	7.42	7.77	2808600.0
2022-03-15	ABCM-DELISTED	Stock	16.39	16.85	16.26	16.52	120770.0
2022-03-15	ABEO	Stock	6.75	7.0	6.25	6.5	68264.0
2022-03-15	ABEV	Stock	2.62	2.66	2.59	2.62	28274300.0
2022-03-15	ABG	Stock	181.85	186.74	180.95	185.5	255000.0
2022-03-15	ABM	Stock	45.94	46.28	43.96	44.62	403500.0
2022-03-15	ABMD-DELISTED	Stock	282.59	293.295	279.31	289.82	141776.0
2022-03-15	ABNB	Stock	140.0	144.73	138.32	143.95	5488700.0
2022-03-15	ABOS	Stock	5.42	5.51	5.25	5.46	148600.0
2022-03-15	ABR	Stock	17.3	17.49	17.19	17.26	2755600.0

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

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