PREVIEW / stock_daily / 2022-02-23

all stock daily files

  file:    by_date/stock_daily/2022/2022-02-23.parquet
  size:    261 KB
  rows:    8,056
  symbols: 2,541

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-02-23	AAPL	Stock	165.54	166.15	159.75	160.07	90009200.0
2022-02-23	MSFT	Stock	290.18	291.7	280.1	280.27	37811200.0
2022-02-23	NVDA	Stock	23.802	24.155	22.301	22.387	566511000.0
2022-02-23	AMZN	Stock	151.6505	151.763	144.651	144.827	64244000.0
2022-02-23	GOOGL	Stock	131.6485	132.051	127.5275	127.588	32786020.0
2022-02-23	META	Stock	204.16	206.94	198.05	198.45	44481400.0
2022-02-23	TSLA	Stock	276.81	278.4333	253.52	254.68	95256900.0
2022-02-23	TLT	Stock	137.68	137.8499	136.565	136.68	17757840.0
2022-02-23	ES	Stock	81.3	81.77	79.64	79.7	2592300.0
2022-02-23	CL	Stock	79.22	79.52	78.54	78.64	3703600.0
2022-02-23	A	Stock	129.88	134.37	125.95	126.0	3938700.0
2022-02-23	AA	Stock	74.25	75.68	73.11	75.32	6588200.0
2022-02-23	AAC-DELISTED	Stock	9.74	9.75	9.725	9.75	362082.0
2022-02-23	AACG	Stock	1.27	1.35	1.24	1.26	12000.0
2022-02-23	AACIU	Stock	10.02	10.02	10.02	10.02	187.0
2022-02-23	AACIW-DELISTED	Stock	0.3099	0.31	0.27505	0.31	6279.0
2022-02-23	AAIC-DELISTED	Stock	3.31	3.34	3.21	3.22	80722.0
2022-02-23	AAIC.C-DELISTED	Stock	24.99	25.0	24.95	24.95	1400.0
2022-02-23	AAL	Stock	17.62	17.76	16.61	16.64	35359100.0
2022-02-23	AAM.A-DELISTED	Stock	25.285	25.285	25.25	25.25	14472.0
2022-02-23	AAM.B-DELISTED	Stock	25.52	25.5401	25.45	25.5	13863.0
2022-02-23	AAME	Stock	2.65	2.65	2.5	2.59	6500.0
2022-02-23	AAMI	Stock	24.5	24.5	23.49	23.6	430100.0
2022-02-23	AAN-DELISTED	Stock	20.54	20.54	19.58	20.03	429700.0
2022-02-23	AAOI	Stock	4.0	4.09	3.81	3.84	333000.0
2022-02-23	AAON	Stock	38.5	39.52	37.6667	37.7533	216900.0
2022-02-23	AAP	Stock	207.8	208.1	195.75	196.8	1494000.0
2022-02-23	AAQC-DELISTED	Stock	9.69	9.7	9.69	9.7	2688.0
2022-02-23	AAT	Stock	36.26	36.58	35.64	35.69	234800.0
2022-02-23	AATC	Stock	6.95	6.95	6.73	6.731	11232.0
2022-02-23	AAU-DELISTED	Stock	0.2752	0.2797	0.265	0.2752	532462.0
2022-02-23	AAUAF-DELISTED	Stock	0.2752	0.2797	0.265	0.2751	537151.0
2022-02-23	AAWW-DELISTED	Stock	74.88	76.58	74.72	75.41	389254.0
2022-02-23	AAXJ	Stock	80.52	80.53	79.1	79.19	1296955.0
2022-02-23	AB	Stock	42.88	43.48	42.12	42.24	445400.0
2022-02-23	ABB-DELISTED	Stock	34.09	34.125	33.05	33.1	1825107.0
2022-02-23	ABBNY-DELISTED	Stock	34.09	34.125	33.05	33.1	2006465.0
2022-02-23	ABBV	Stock	146.22	148.35	145.36	146.76	9271000.0
2022-02-23	ABC-DELISTED	Stock	141.23	141.73	139.22	139.42	672872.0
2022-02-23	ABCB	Stock	49.62	49.89	48.3	48.44	202500.0
2022-02-23	ABCL	Stock	8.89	8.93	8.25	8.26	1716200.0
2022-02-23	ABCM-DELISTED	Stock	16.33	16.36	16.08	16.17	69796.0
2022-02-23	ABEO	Stock	5.75	6.25	5.75	5.75	33196.0
2022-02-23	ABEV	Stock	3.01	3.03	2.94	2.96	16907600.0
2022-02-23	ABG	Stock	184.18	190.45	182.12	183.17	395000.0
2022-02-23	ABGI-DELISTED	Stock	9.71	9.73	9.71	9.72	97717.0
2022-02-23	ABM	Stock	42.73	43.54	42.73	42.98	296800.0
2022-02-23	ABMD-DELISTED	Stock	299.1	301.1	290.25	290.99	128378.0
2022-02-23	ABNB	Stock	165.93	166.655	149.85	150.04	9778500.0
2022-02-23	ABOS	Stock	5.72	6.05	5.56	5.66	238200.0

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

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