PREVIEW / stock_daily / 2022-11-17

all stock daily files

  file:    by_date/stock_daily/2022/2022-11-17.parquet
  size:    250 KB
  rows:    7,821
  symbols: 2,077

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-11-17	AAPL	Stock	146.43	151.48	146.15	150.72	80389400.0
2022-11-17	MSFT	Stock	237.78	243.25	237.63	241.68	23123500.0
2022-11-17	NVDA	Stock	15.715	16.266	15.535	15.677	710894000.0
2022-11-17	AMZN	Stock	95.37	96.97	94.03	94.85	82617900.0
2022-11-17	GOOGL	Stock	96.97	99.28	96.79	98.36	26052599.0
2022-11-17	META	Stock	110.41	112.33	109.8	111.45	35093800.0
2022-11-17	TSLA	Stock	183.96	186.16	180.9	183.17	64336000.0
2022-11-17	TLT	Stock	100.2	100.57	99.78	100.33	24536378.0
2022-11-17	ES	Stock	78.74	79.07	77.68	78.1	2331700.0
2022-11-17	CL	Stock	75.85	76.25	75.04	75.29	4618500.0
2022-11-17	A	Stock	145.33	145.56	142.16	144.44	1465000.0
2022-11-17	AA	Stock	46.93	47.46	45.55	47.37	5688200.0
2022-11-17	AAC-DELISTED	Stock	10.0	10.0	9.9804	9.995	3916.0
2022-11-17	AACG	Stock	1.69	1.75	1.68	1.68	4700.0
2022-11-17	AACIW-DELISTED	Stock	0.03	0.0306	0.03	0.0306	4900.0
2022-11-17	AAIC-DELISTED	Stock	3.1	3.11	3.0	3.0	105580.0
2022-11-17	AAL	Stock	13.82	14.02	13.68	13.95	24041700.0
2022-11-17	AAM.A-DELISTED	Stock	24.4	24.9	24.35	24.75	20497.0
2022-11-17	AAM.B-DELISTED	Stock	24.42	25.11	24.42	24.98	12551.0
2022-11-17	AAMC-DELISTED	Stock	5.9706	5.9706	5.3824	5.3824	3995.0
2022-11-17	AAME	Stock	2.99	3.04	2.99	3.04	400.0
2022-11-17	AAMI	Stock	19.42	19.57	19.16	19.57	129100.0
2022-11-17	AAN-DELISTED	Stock	10.06	10.54	9.9	10.51	269200.0
2022-11-17	AAOI	Stock	2.1	2.24	2.09	2.19	95200.0
2022-11-17	AAON	Stock	52.62	52.9667	52.0733	52.9667	207450.0
2022-11-17	AAP	Stock	153.1	153.75	147.48	148.31	2470600.0
2022-11-17	AAQC-DELISTED	Stock	10.04	10.04	10.01	10.01	55116.0
2022-11-17	AAT	Stock	27.52	28.09	27.35	28.02	280400.0
2022-11-17	AATC	Stock	4.26	4.4099	4.26	4.4099	27510.0
2022-11-17	AAU-DELISTED	Stock	0.251	0.26	0.25	0.251	207168.0
2022-11-17	AAUAF-DELISTED	Stock	0.251	0.26	0.25	0.251	210385.0
2022-11-17	AAWW-DELISTED	Stock	100.22	100.67	99.89	100.0	1023911.0
2022-11-17	AAXJ	Stock	62.87	64.445	62.87	64.37	654378.0
2022-11-17	AB	Stock	39.64	39.93	39.36	39.79	132700.0
2022-11-17	ABB-DELISTED	Stock	30.52	30.64	30.315	30.5	2734657.0
2022-11-17	ABBNY-DELISTED	Stock	30.52	30.64	30.315	30.49	2957026.0
2022-11-17	ABBV	Stock	150.97	153.07	149.97	152.16	5069500.0
2022-11-17	ABC-DELISTED	Stock	155.0	158.98	154.91	158.93	1162535.0
2022-11-17	ABCB	Stock	51.19	51.51	50.78	51.27	278000.0
2022-11-17	ABCL	Stock	14.27	14.27	13.81	14.08	2080300.0
2022-11-17	ABCM-DELISTED	Stock	16.55	16.88	16.47	16.57	310551.0
2022-11-17	ABEO	Stock	3.86	4.06	3.81	3.97	233200.0
2022-11-17	ABEV	Stock	2.75	2.83	2.75	2.82	26287500.0
2022-11-17	ABG	Stock	174.0	179.8	173.93	179.4	122600.0
2022-11-17	ABGI-DELISTED	Stock	10.0	10.0	10.0	10.0	55714.0
2022-11-17	ABLV	Stock	10.1	10.1	10.1	10.1	500.0
2022-11-17	ABM	Stock	44.37	45.11	43.53	45.04	364200.0
2022-11-17	ABMD-DELISTED	Stock	374.52	376.9	374.11	376.78	1053132.0
2022-11-17	ABNB	Stock	101.83	101.98	98.85	99.3	5181200.0
2022-11-17	ABOS	Stock	6.09	6.51	6.075	6.51	157200.0

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

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