PREVIEW / stock_daily / 2022-08-01

all stock daily files

  file:    by_date/stock_daily/2022/2022-08-01.parquet
  size:    254 KB
  rows:    7,953
  symbols: 2,335

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-08-01	AAPL	Stock	161.01	163.59	160.89	161.51	67829400.0
2022-08-01	MSFT	Stock	277.82	281.28	275.84	278.01	21539600.0
2022-08-01	NVDA	Stock	18.182	18.846	17.99	18.441	476469000.0
2022-08-01	AMZN	Stock	134.96	138.83	133.51	135.39	76846900.0
2022-08-01	GOOGL	Stock	115.3	116.72	114.34	114.86	26034288.0
2022-08-01	META	Stock	157.25	165.19	155.23	159.93	40596700.0
2022-08-01	TSLA	Stock	301.2767	311.8767	295.0	297.2767	117042900.0
2022-08-01	TLT	Stock	118.25	120.1	118.08	120.04	17974560.0
2022-08-01	ES	Stock	88.6	89.45	87.96	89.21	2062600.0
2022-08-01	CL	Stock	78.96	81.7	78.76	81.1	6899200.0
2022-08-01	A	Stock	133.51	135.23	133.26	133.43	1081700.0
2022-08-01	AA	Stock	49.88	50.22	48.06	48.28	5926900.0
2022-08-01	AAC-DELISTED	Stock	9.87	9.87	9.86	9.86	92353.0
2022-08-01	AACG	Stock	1.62	1.89	1.61	1.85	131700.0
2022-08-01	AACIU	Stock	10.0	10.0	9.98	9.98	1187.0
2022-08-01	AAIC-DELISTED	Stock	3.13	3.22	3.09	3.19	92334.0
2022-08-01	AAIC.C-DELISTED	Stock	20.75	20.9499	20.65	20.715	5300.0
2022-08-01	AAL	Stock	13.67	14.32	13.52	14.28	32730800.0
2022-08-01	AAM.A-DELISTED	Stock	25.43	25.74	25.4	25.5	18713.0
2022-08-01	AAM.B-DELISTED	Stock	25.95	26.39	25.95	26.22	18982.0
2022-08-01	AAMC-DELISTED	Stock	5.2706	5.2941	4.7059	4.8088	105648.0
2022-08-01	AAME	Stock	2.98	2.98	2.74	2.91	6900.0
2022-08-01	AAMI	Stock	18.66	19.16	18.555	19.03	281400.0
2022-08-01	AAN-DELISTED	Stock	13.0	13.18	12.74	13.02	356400.0
2022-08-01	AAOI	Stock	1.7	1.74	1.665	1.71	149900.0
2022-08-01	AAON	Stock	39.7267	41.58	39.46	40.88	274800.0
2022-08-01	AAP	Stock	192.3	196.71	192.01	195.99	545100.0
2022-08-01	AAQC-DELISTED	Stock	9.84	9.84	9.8	9.8	600.0
2022-08-01	AAT	Stock	30.11	30.31	29.87	30.02	275500.0
2022-08-01	AATC	Stock	5.07	5.1499	5.07	5.08	2840.0
2022-08-01	AAU-DELISTED	Stock	0.2257	0.24	0.223	0.231	171428.0
2022-08-01	AAUAF-DELISTED	Stock	0.2257	0.24	0.223	0.2385	175548.0
2022-08-01	AAWW-DELISTED	Stock	75.12	87.96	74.11	85.0	2993304.0
2022-08-01	AAXJ	Stock	67.25	67.79	66.95	67.41	882544.0
2022-08-01	AB	Stock	43.75	44.46	43.29	44.01	406300.0
2022-08-01	ABB-DELISTED	Stock	30.21	30.24	29.975	30.13	1384190.0
2022-08-01	ABBNY-DELISTED	Stock	30.21	30.24	29.975	30.13	1560784.0
2022-08-01	ABBV	Stock	141.51	142.84	139.15	140.22	8523900.0
2022-08-01	ABC-DELISTED	Stock	145.5	147.53	144.95	145.94	727387.0
2022-08-01	ABCB	Stock	47.08	47.94	46.75	47.46	425000.0
2022-08-01	ABCL	Stock	10.04	10.195	9.88	10.145	1981500.0
2022-08-01	ABCM-DELISTED	Stock	14.91	15.06	14.84	14.94	125171.0
2022-08-01	ABEO	Stock	3.9	4.07	3.81	3.9	36100.0
2022-08-01	ABEV	Stock	2.79	2.85	2.75	2.77	43896100.0
2022-08-01	ABG	Stock	170.49	184.24	169.95	180.75	282400.0
2022-08-01	ABGI-DELISTED	Stock	9.83	9.84	9.83	9.84	50036.0
2022-08-01	ABM	Stock	44.61	45.59	44.08	45.36	244800.0
2022-08-01	ABMD-DELISTED	Stock	287.85	295.69	287.85	291.9	101633.0
2022-08-01	ABNB	Stock	110.0	113.96	107.48	111.2	6019500.0
2022-08-01	ABOS	Stock	5.44	5.45	4.93	5.0	70200.0

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

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