PREVIEW / stock_daily / 2022-06-10

all stock daily files

  file:    by_date/stock_daily/2022/2022-06-10.parquet
  size:    255 KB
  rows:    7,922
  symbols: 2,350

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-06-10	AAPL	Stock	140.28	140.76	137.06	137.13	91437900.0
2022-06-10	MSFT	Stock	260.58	260.58	252.53	252.99	31422800.0
2022-06-10	NVDA	Stock	17.6	17.697	16.869	16.974	465248000.0
2022-06-10	AMZN	Stock	113.42	114.5	109.05	109.65	87266000.0
2022-06-10	GOOGL	Stock	112.445	113.279	110.3661	111.1615	41481840.0
2022-06-10	META	Stock	183.04	183.1	175.02	175.57	27450800.0
2022-06-10	TSLA	Stock	235.1567	239.5	227.9133	232.23	97536600.0
2022-06-10	TLT	Stock	114.36	114.61	112.965	113.77	21917058.0
2022-06-10	ES	Stock	87.01	88.74	86.65	88.03	1439000.0
2022-06-10	CL	Stock	76.18	77.25	75.15	76.63	4294600.0
2022-06-10	A	Stock	121.63	121.93	119.9	120.57	1379600.0
2022-06-10	AA	Stock	54.04	54.75	52.57	53.01	9352200.0
2022-06-10	AAC-DELISTED	Stock	9.83	9.835	9.82	9.825	200540.0
2022-06-10	AACG	Stock	1.16	1.16	1.09	1.1	4300.0
2022-06-10	AAIC-DELISTED	Stock	3.56	3.56	3.5	3.53	36850.0
2022-06-10	AAIC.C-DELISTED	Stock	23.62	23.64	23.62	23.64	850.0
2022-06-10	AAL	Stock	15.09	15.83	14.71	14.71	46180100.0
2022-06-10	AAM.A-DELISTED	Stock	24.65	24.76	24.3043	24.4	63989.0
2022-06-10	AAM.B-DELISTED	Stock	25.28	25.28	24.66	24.8	11492.0
2022-06-10	AAMC-DELISTED	Stock	4.0294	4.0294	3.7353	3.7853	27441.0
2022-06-10	AAME	Stock	3.03	3.03	3.03	3.03	1500.0
2022-06-10	AAMI	Stock	20.13	20.24	19.67	19.72	437300.0
2022-06-10	AAN-DELISTED	Stock	18.31	18.6	17.96	17.96	231600.0
2022-06-10	AAOI	Stock	2.2	2.201	2.05	2.09	318800.0
2022-06-10	AAON	Stock	36.1667	36.1667	34.6333	34.6667	247200.0
2022-06-10	AAP	Stock	181.57	183.31	178.81	179.43	632200.0
2022-06-10	AAQC-DELISTED	Stock	9.76	9.76	9.76	9.76	257.0
2022-06-10	AAT	Stock	30.7	31.12	30.46	30.87	195200.0
2022-06-10	AATC	Stock	5.75	5.78	5.6304	5.735	8539.0
2022-06-10	AAU-DELISTED	Stock	0.2545	0.27	0.2468	0.2607	282201.0
2022-06-10	AAUAF-DELISTED	Stock	0.2545	0.27	0.2468	0.2607	285370.0
2022-06-10	AAWW-DELISTED	Stock	66.02	67.58	65.43	65.48	263725.0
2022-06-10	AAXJ	Stock	70.85	70.94	69.95	70.13	1224666.0
2022-06-10	AB	Stock	42.42	43.25	41.85	43.0	438500.0
2022-06-10	ABB-DELISTED	Stock	29.46	29.505	29.07	29.23	1876085.0
2022-06-10	ABBNY-DELISTED	Stock	29.46	29.505	29.07	29.22	2034633.0
2022-06-10	ABBV	Stock	144.34	144.63	142.15	143.2	5464700.0
2022-06-10	ABC-DELISTED	Stock	142.54	145.94	142.23	144.44	726874.0
2022-06-10	ABCB	Stock	42.75	43.35	42.02	42.42	353200.0
2022-06-10	ABCL	Stock	8.21	8.6	8.18	8.34	3327200.0
2022-06-10	ABCM-DELISTED	Stock	14.63	14.7	14.44	14.625	107937.0
2022-06-10	ABEO	Stock	4.25	4.5	4.0	4.25	90392.0
2022-06-10	ABEV	Stock	2.65	2.7	2.61	2.67	50056000.0
2022-06-10	ABG	Stock	185.99	188.48	180.85	183.14	188000.0
2022-06-10	ABGI-DELISTED	Stock	9.83	9.84	9.83	9.8327	6279.0
2022-06-10	ABM	Stock	42.83	43.28	41.42	41.98	874300.0
2022-06-10	ABMD-DELISTED	Stock	251.13	253.26	248.92	250.74	74621.0
2022-06-10	ABNB	Stock	111.8	115.13	108.32	108.91	6936900.0
2022-06-10	ABOS	Stock	3.77	3.91	3.66	3.84	175700.0
2022-06-10	ABR	Stock	15.52	15.61	15.09	15.19	2873400.0

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

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