PREVIEW / stock_daily / 2022-07-29

all stock daily files

  file:    by_date/stock_daily/2022/2022-07-29.parquet
  size:    254 KB
  rows:    7,931
  symbols: 2,300

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-29	AAPL	Stock	161.24	163.63	159.5	162.51	101786900.0
2022-07-29	MSFT	Stock	277.7	282.0	276.63	280.74	32152800.0
2022-07-29	NVDA	Stock	17.813	18.244	17.692	18.163	435460000.0
2022-07-29	AMZN	Stock	134.9	137.65	132.41	134.95	148892900.0
2022-07-29	GOOGL	Stock	113.08	116.705	113.06	116.32	37223391.0
2022-07-29	META	Stock	157.69	160.14	155.17	159.1	42065400.0
2022-07-29	TSLA	Stock	280.7	298.32	279.1	297.15	95313000.0
2022-07-29	TLT	Stock	117.7	119.305	117.33	117.43	16655870.0
2022-07-29	ES	Stock	87.03	89.0	87.03	88.22	2022700.0
2022-07-29	CL	Stock	78.6	79.16	77.29	78.74	5749800.0
2022-07-29	A	Stock	131.27	134.5	130.9	134.1	2214900.0
2022-07-29	AA	Stock	49.82	51.015	49.09	50.89	5622000.0
2022-07-29	AAC-DELISTED	Stock	9.86	9.8799	9.86	9.865	81050.0
2022-07-29	AACG	Stock	1.56	1.64	1.56	1.64	12400.0
2022-07-29	AAIC-DELISTED	Stock	3.2371	3.279	3.13	3.13	111659.0
2022-07-29	AAIC.C-DELISTED	Stock	20.85	20.9	20.4	20.5	8396.0
2022-07-29	AAL	Stock	13.59	13.92	13.49	13.71	26238200.0
2022-07-29	AAM.A-DELISTED	Stock	25.35	25.6	25.1601	25.55	27471.0
2022-07-29	AAM.B-DELISTED	Stock	25.99	26.39	25.5468	25.98	39625.0
2022-07-29	AAMC-DELISTED	Stock	5.2941	5.4412	4.6912	5.2588	106250.0
2022-07-29	AAME	Stock	2.62	2.94	2.62	2.92	5900.0
2022-07-29	AAMI	Stock	19.02	19.03	18.6	18.91	429900.0
2022-07-29	AAN-DELISTED	Stock	13.06	13.27	12.77	13.02	572800.0
2022-07-29	AAOI	Stock	1.72	1.75	1.65	1.72	238800.0
2022-07-29	AAON	Stock	39.4	40.3267	39.0467	40.1133	168900.0
2022-07-29	AAP	Stock	191.27	194.2	189.28	193.62	519500.0
2022-07-29	AAQC-DELISTED	Stock	9.8	9.81	9.8	9.8	255226.0
2022-07-29	AAT	Stock	30.28	30.47	30.04	30.23	209100.0
2022-07-29	AATC	Stock	5.13	5.18	5.1153	5.1599	7182.0
2022-07-29	AAU-DELISTED	Stock	0.229	0.2317	0.2224	0.2316	168995.0
2022-07-29	AAUAF-DELISTED	Stock	0.229	0.2317	0.2211	0.2316	186898.0
2022-07-29	AAWW-DELISTED	Stock	73.47	76.18	73.02	75.7	467074.0
2022-07-29	AAXJ	Stock	67.48	68.025	67.2501	68.0	1071652.0
2022-07-29	AB	Stock	42.3	44.81	42.15	44.06	520600.0
2022-07-29	ABB-DELISTED	Stock	29.8	30.44	29.71	30.375	2146469.0
2022-07-29	ABBNY-DELISTED	Stock	29.8	30.44	29.71	30.37	2314427.0
2022-07-29	ABBV	Stock	145.44	146.3	139.05	143.51	17754700.0
2022-07-29	ABC-DELISTED	Stock	145.34	146.27	144.77	145.93	452139.0
2022-07-29	ABCB	Stock	46.27	47.39	45.68	47.29	368600.0
2022-07-29	ABCL	Stock	10.41	10.6	10.01	10.04	1830100.0
2022-07-29	ABCM-DELISTED	Stock	14.85	15.12	14.84	14.95	246515.0
2022-07-29	ABEO	Stock	4.09	4.18	3.91	3.96	99200.0
2022-07-29	ABEV	Stock	2.88	2.91	2.82	2.82	50263700.0
2022-07-29	ABG	Stock	171.69	173.68	166.13	171.64	214900.0
2022-07-29	ABGI-DELISTED	Stock	9.83	9.83	9.83	9.83	100.0
2022-07-29	ABM	Stock	44.2	45.13	44.2	44.84	749400.0
2022-07-29	ABMD-DELISTED	Stock	290.93	293.74	287.06	293.06	139331.0
2022-07-29	ABNB	Stock	108.195	111.16	107.11	110.98	4637800.0
2022-07-29	ABOS	Stock	5.47	5.805	5.39	5.44	27100.0
2022-07-29	ABR	Stock	16.56	16.77	16.45	16.62	2640400.0

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

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