PREVIEW / stock_daily / 2022-07-15

all stock daily files

  file:    by_date/stock_daily/2022/2022-07-15.parquet
  size:    251 KB
  rows:    7,847
  symbols: 2,266

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-07-15	AAPL	Stock	149.78	150.86	148.2	150.17	76259900.0
2022-07-15	MSFT	Stock	255.72	260.37	254.77	256.72	29774100.0
2022-07-15	NVDA	Stock	15.659	15.782	15.445	15.762	385935000.0
2022-07-15	AMZN	Stock	112.5	115.59	111.59	113.55	84317800.0
2022-07-15	GOOGL	Stock	112.0005	113.1405	110.9	111.7775	46769120.0
2022-07-15	META	Stock	160.54	164.98	159.82	164.7	23342800.0
2022-07-15	TSLA	Stock	240.0	243.6233	236.89	240.0667	69683100.0
2022-07-15	TLT	Stock	115.84	116.82	115.6	116.14	16022586.0
2022-07-15	ES	Stock	83.88	84.02	82.7	83.66	936700.0
2022-07-15	CL	Stock	78.75	78.99	77.97	78.15	4830600.0
2022-07-15	A	Stock	117.78	118.88	116.0	118.83	969400.0
2022-07-15	AA	Stock	41.56	43.06	40.31	43.06	5191700.0
2022-07-15	AAC-DELISTED	Stock	9.83	9.855	9.83	9.84	124662.0
2022-07-15	AACG	Stock	1.35	1.35	1.22	1.28	24000.0
2022-07-15	AAIC-DELISTED	Stock	3.075	3.13	3.06	3.07	31885.0
2022-07-15	AAIC.C-DELISTED	Stock	20.5638	20.88	20.5638	20.8502	2300.0
2022-07-15	AAL	Stock	14.49	14.56	14.05	14.47	30182000.0
2022-07-15	AAM.A-DELISTED	Stock	24.63	24.63	24.15	24.48	11513.0
2022-07-15	AAM.B-DELISTED	Stock	24.74	24.93	24.41	24.42	19123.0
2022-07-15	AAME	Stock	2.98	3.13	2.57	2.67	8200.0
2022-07-15	AAMI	Stock	17.5	17.68	17.15	17.6	188400.0
2022-07-15	AAN-DELISTED	Stock	14.37	14.69	14.34	14.67	1178500.0
2022-07-15	AAOI	Stock	1.56	1.68	1.53	1.63	149600.0
2022-07-15	AAON	Stock	35.8133	36.08	34.6467	35.9867	235500.0
2022-07-15	AAP	Stock	188.19	190.0	186.27	188.71	668500.0
2022-07-15	AAQC-DELISTED	Stock	9.78	9.78	9.78	9.78	119.0
2022-07-15	AAT	Stock	29.34	29.42	28.83	29.36	202100.0
2022-07-15	AATC	Stock	5.21	5.2573	5.11	5.11	6399.0
2022-07-15	AAU-DELISTED	Stock	0.215	0.2201	0.21	0.214	147091.0
2022-07-15	AAUAF-DELISTED	Stock	0.215	0.2201	0.21	0.214	165351.0
2022-07-15	AAWW-DELISTED	Stock	61.83	61.83	60.14	61.27	129577.0
2022-07-15	AAXJ	Stock	66.52	66.765	65.88	66.74	877850.0
2022-07-15	AB	Stock	40.97	41.3	40.29	41.03	200900.0
2022-07-15	ABB-DELISTED	Stock	26.55	26.95	26.33	26.93	1329450.0
2022-07-15	ABBNY-DELISTED	Stock	26.55	26.95	26.33	26.93	1463294.0
2022-07-15	ABBV	Stock	151.84	153.87	151.43	153.62	4873000.0
2022-07-15	ABC-DELISTED	Stock	141.53	142.28	139.89	142.21	707711.0
2022-07-15	ABCB	Stock	39.85	40.85	39.15	40.53	323000.0
2022-07-15	ABCL	Stock	10.95	11.04	10.09	10.54	3313800.0
2022-07-15	ABCM-DELISTED	Stock	13.59	13.81	13.58	13.66	119566.0
2022-07-15	ABEO	Stock	4.76	5.09	4.73	4.85	188400.0
2022-07-15	ABEV	Stock	2.68	2.71	2.65	2.65	32876100.0
2022-07-15	ABG	Stock	154.05	162.78	152.99	161.28	247600.0
2022-07-15	ABM	Stock	42.66	42.86	42.11	42.56	251700.0
2022-07-15	ABMD-DELISTED	Stock	263.83	268.345	260.2325	268.24	142594.0
2022-07-15	ABNB	Stock	92.55	95.65	90.66	94.66	7497200.0
2022-07-15	ABOS	Stock	6.47	6.77	6.22	6.29	201700.0
2022-07-15	ABR	Stock	13.81	13.91	13.41	13.83	1788000.0
2022-07-15	ABR.D	Stock	20.0	20.18	20.0	20.014	14705.0
2022-07-15	ABR.E	Stock	19.91	19.93	19.43	19.6744	16193.0

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

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