PREVIEW / stock_daily / 2022-07-26

all stock daily files

  file:    by_date/stock_daily/2022/2022-07-26.parquet
  size:    251 KB
  rows:    7,850
  symbols: 2,251

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-26	AAPL	Stock	152.26	153.09	150.8	151.6	55138700.0
2022-07-26	MSFT	Stock	259.86	259.88	249.57	251.9	39348000.0
2022-07-26	NVDA	Stock	16.889	16.919	16.478	16.533	397865000.0
2022-07-26	AMZN	Stock	115.79	118.15	114.53	114.81	67075100.0
2022-07-26	GOOGL	Stock	106.6	107.2	104.07	105.02	47990963.0
2022-07-26	META	Stock	165.94	166.0	157.95	159.15	28468400.0
2022-07-26	TSLA	Stock	266.5133	267.31	256.2633	258.86	66820800.0
2022-07-26	TLT	Stock	118.86	119.24	117.395	117.48	13535963.0
2022-07-26	ES	Stock	84.93	85.69	84.83	85.4	840200.0
2022-07-26	CL	Stock	77.32	78.61	77.15	78.53	2572400.0
2022-07-26	A	Stock	124.66	125.63	123.37	125.17	1260000.0
2022-07-26	AA	Stock	47.13	48.225	46.16	46.99	5336700.0
2022-07-26	AAC-DELISTED	Stock	9.86	9.88	9.86	9.86	162021.0
2022-07-26	AACG	Stock	1.53	1.55	1.53	1.54	4300.0
2022-07-26	AACIW-DELISTED	Stock	0.1503	0.1503	0.15	0.15	7860.0
2022-07-26	AAIC-DELISTED	Stock	3.2248	3.2248	3.1701	3.21	32835.0
2022-07-26	AAIC.C-DELISTED	Stock	20.4	20.4	20.375	20.4	5267.0
2022-07-26	AAL	Stock	13.52	13.65	13.35	13.43	23978100.0
2022-07-26	AAM.A-DELISTED	Stock	24.96	25.15	24.9449	25.14	14384.0
2022-07-26	AAM.B-DELISTED	Stock	25.49	25.49	25.2006	25.48	4789.0
2022-07-26	AAMC-DELISTED	Stock	4.7794	5.2059	4.6971	4.8412	103445.0
2022-07-26	AAME	Stock	3.03	3.08	2.65	2.68	14300.0
2022-07-26	AAMI	Stock	18.8	18.86	18.63	18.66	159200.0
2022-07-26	AAN-DELISTED	Stock	13.07	14.03	12.29	13.13	1317900.0
2022-07-26	AAOI	Stock	1.62	1.75	1.62	1.66	86900.0
2022-07-26	AAON	Stock	37.4867	37.92	36.98	37.7467	142800.0
2022-07-26	AAP	Stock	186.0	186.39	182.5	182.87	727600.0
2022-07-26	AAQC-DELISTED	Stock	9.8	9.81	9.8	9.805	13364.0
2022-07-26	AAT	Stock	29.99	30.18	29.62	29.7	179400.0
2022-07-26	AATC	Stock	5.07	5.19	5.07	5.15	1843.0
2022-07-26	AAU-DELISTED	Stock	0.2152	0.225	0.2126	0.2167	193482.0
2022-07-26	AAUAF-DELISTED	Stock	0.2152	0.225	0.2126	0.2167	199738.0
2022-07-26	AAWW-DELISTED	Stock	68.77	70.64	68.77	69.4	230181.0
2022-07-26	AAXJ	Stock	67.97	68.04	67.235	67.31	534352.0
2022-07-26	AB	Stock	41.61	41.61	41.07	41.25	156200.0
2022-07-26	ABB-DELISTED	Stock	28.35	28.545	28.28	28.35	1058489.0
2022-07-26	ABBNY-DELISTED	Stock	28.35	28.545	28.28	28.35	1177710.0
2022-07-26	ABBV	Stock	151.15	153.56	150.33	150.87	4900600.0
2022-07-26	ABC-DELISTED	Stock	144.57	145.365	143.85	145.18	455916.0
2022-07-26	ABCB	Stock	43.19	43.6	42.5	42.91	298900.0
2022-07-26	ABCL	Stock	10.11	10.355	9.874	10.19	1281000.0
2022-07-26	ABCM-DELISTED	Stock	14.27	14.75	14.25	14.58	396725.0
2022-07-26	ABEO	Stock	4.24	4.24	3.99	4.0	56100.0
2022-07-26	ABEV	Stock	2.7	2.74	2.68	2.72	32240000.0
2022-07-26	ABG	Stock	161.18	164.13	159.1	160.58	212600.0
2022-07-26	ABM	Stock	43.54	43.76	43.19	43.52	181500.0
2022-07-26	ABMD-DELISTED	Stock	279.54	281.76	276.98	278.38	107250.0
2022-07-26	ABNB	Stock	102.38	103.63	101.1	101.91	4191000.0
2022-07-26	ABOS	Stock	5.16	5.68	5.05	5.52	43500.0
2022-07-26	ABR	Stock	15.5	15.62	15.26	15.61	1932400.0

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

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