PREVIEW / stock_daily / 2023-02-13

all stock daily files

  file:    by_date/stock_daily/2023/2023-02-13.parquet
  size:    247 KB
  rows:    7,678
  symbols: 1,847

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
2023-02-13	AAPL	Stock	150.95	154.26	150.92	153.85	62199000.0
2023-02-13	MSFT	Stock	267.64	274.6	267.15	271.32	44630900.0
2023-02-13	NVDA	Stock	21.538	22.048	20.962	21.788	474919000.0
2023-02-13	AMZN	Stock	97.85	99.68	96.91	99.54	52841500.0
2023-02-13	GOOGL	Stock	94.74	95.2	93.84	94.61	50076120.0
2023-02-13	META	Stock	178.22	181.0	175.82	179.43	31463200.0
2023-02-13	TSLA	Stock	194.42	196.3	187.61	194.64	172475500.0
2023-02-13	TLT	Stock	103.71	104.415	103.58	104.26	13134299.0
2023-02-13	ES	Stock	80.08	80.71	79.95	80.29	1556600.0
2023-02-13	CL	Stock	73.87	74.04	73.46	73.77	3664300.0
2023-02-13	A	Stock	153.27	154.66	152.01	154.6	925400.0
2023-02-13	AA	Stock	48.39	48.7	47.12	47.95	3334100.0
2023-02-13	AAC-DELISTED	Stock	10.19	10.21	10.18	10.2	8486.0
2023-02-13	AACG	Stock	1.79	1.82	1.75	1.77	13000.0
2023-02-13	AACIW-DELISTED	Stock	0.1119	0.1119	0.1029	0.1029	260.0
2023-02-13	AAIC-DELISTED	Stock	3.0	3.01	2.98	3.0	116058.0
2023-02-13	AAL	Stock	16.25	16.6	16.21	16.51	15649900.0
2023-02-13	AAM.A-DELISTED	Stock	24.4497	24.73	24.26	24.6024	13208.0
2023-02-13	AAM.B-DELISTED	Stock	24.6	24.78	24.45	24.57	17744.0
2023-02-13	AAMC-DELISTED	Stock	11.1647	12.0412	11.1647	11.75	40052.0
2023-02-13	AAME	Stock	2.42	2.43	2.42	2.42	900.0
2023-02-13	AAMI	Stock	26.17	26.54	25.98	26.5	82300.0
2023-02-13	AAN-DELISTED	Stock	14.61	14.84	14.4	14.81	158900.0
2023-02-13	AAOI	Stock	2.7	2.815	2.62	2.64	131900.0
2023-02-13	AAON	Stock	50.4667	52.0067	50.04	51.8667	208200.0
2023-02-13	AAP	Stock	149.88	152.21	148.82	152.19	695400.0
2023-02-13	AAT	Stock	26.56	26.72	26.45	26.49	509900.0
2023-02-13	AATC	Stock	4.39	4.39	4.2625	4.27	7097.0
2023-02-13	AAU-DELISTED	Stock	0.22	0.2268	0.22	0.225	135321.0
2023-02-13	AAUAF-DELISTED	Stock	0.22	0.2268	0.22	0.225	137693.0
2023-02-13	AAWW-DELISTED	Stock	102.14	102.23	102.14	102.18	177676.0
2023-02-13	AAXJ	Stock	69.44	69.84	69.22	69.74	514965.0
2023-02-13	AB	Stock	39.94	40.57	39.84	40.39	459700.0
2023-02-13	ABB-DELISTED	Stock	33.7	34.115	33.66	34.05	652656.0
2023-02-13	ABBNY-DELISTED	Stock	33.7	34.115	33.66	34.06	741178.0
2023-02-13	ABBV	Stock	152.02	153.78	151.26	153.73	5602600.0
2023-02-13	ABC-DELISTED	Stock	158.89	159.915	158.15	158.68	806315.0
2023-02-13	ABCB	Stock	48.49	49.11	47.82	48.83	286500.0
2023-02-13	ABCL	Stock	9.9	9.925	9.62	9.77	1259400.0
2023-02-13	ABCM-DELISTED	Stock	15.0	15.22	14.68	15.18	179953.0
2023-02-13	ABEO	Stock	2.48	2.52	2.4	2.45	89200.0
2023-02-13	ABEV	Stock	2.48	2.52	2.47	2.51	10837000.0
2023-02-13	ABG	Stock	230.59	232.87	229.25	232.24	152000.0
2023-02-13	ABGI-DELISTED	Stock	10.16	10.16	10.16	10.16	1200.0
2023-02-13	ABM	Stock	47.86	48.64	47.81	48.59	230500.0
2023-02-13	ABNB	Stock	110.0	116.9	109.81	116.42	7657200.0
2023-02-13	ABOS	Stock	5.76	5.906	5.36	5.51	65100.0
2023-02-13	ABR	Stock	14.7	15.07	14.66	15.0	1865700.0
2023-02-13	ABR.D	Stock	20.625	20.73	20.5001	20.64	5861.0
2023-02-13	ABR.E	Stock	21.35	21.47	20.77	21.3	21984.0

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

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