PREVIEW / stock_daily / 2022-05-31

all stock daily files

  file:    by_date/stock_daily/2022/2022-05-31.parquet
  size:    258 KB
  rows:    7,988
  symbols: 2,402

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-05-31	AAPL	Stock	149.07	150.66	146.84	148.84	103718400.0
2022-05-31	MSFT	Stock	272.53	274.77	268.93	271.87	37827700.0
2022-05-31	NVDA	Stock	18.98	19.2	18.35	18.672	664100000.0
2022-05-31	AMZN	Stock	116.28	121.9945	115.675	120.2095	144634000.0
2022-05-31	GOOGL	Stock	112.7465	115.735	112.0785	113.762	50012260.0
2022-05-31	META	Stock	194.89	197.6	192.01	193.64	26131100.0
2022-05-31	TSLA	Stock	257.9467	259.6	244.7433	252.7533	101914500.0
2022-05-31	TLT	Stock	117.18	117.23	115.928	116.56	28393674.0
2022-05-31	ES	Stock	92.69	93.03	91.45	92.32	2526700.0
2022-05-31	CL	Stock	78.52	79.31	77.83	78.81	5916500.0
2022-05-31	A	Stock	128.91	130.07	126.72	127.56	3403100.0
2022-05-31	AA	Stock	66.09	67.52	61.305	61.72	18488800.0
2022-05-31	AAC-DELISTED	Stock	9.81	9.81	9.8	9.805	651456.0
2022-05-31	AACG	Stock	1.11	1.11	1.03	1.06	8700.0
2022-05-31	AAIC-DELISTED	Stock	3.51	3.545	3.5	3.5	38185.0
2022-05-31	AAIC.C-DELISTED	Stock	23.37	23.39	23.37	23.38	300.0
2022-05-31	AAL	Stock	17.7	18.22	17.51	17.87	31158300.0
2022-05-31	AAM.A-DELISTED	Stock	24.88	24.88	24.66	24.74	67987.0
2022-05-31	AAM.B-DELISTED	Stock	25.5	25.95	25.24	25.67	76348.0
2022-05-31	AAMC-DELISTED	Stock	3.1235	3.1256	3.0838	3.0838	3641.0
2022-05-31	AAME	Stock	2.61	3.15	2.53	3.14	12500.0
2022-05-31	AAMI	Stock	20.14	20.54	19.84	20.39	435600.0
2022-05-31	AAN-DELISTED	Stock	18.96	19.62	18.51	19.56	374700.0
2022-05-31	AAOI	Stock	2.29	2.39	2.24	2.37	216200.0
2022-05-31	AAON	Stock	35.4467	35.7533	34.6067	35.72	358200.0
2022-05-31	AAP	Stock	191.23	191.8	188.25	189.86	987500.0
2022-05-31	AAQC-DELISTED	Stock	9.76	9.77	9.75	9.76	60698.0
2022-05-31	AAT	Stock	33.85	34.17	33.55	34.1	515800.0
2022-05-31	AATC	Stock	5.98	6.0199	5.7601	5.78	10003.0
2022-05-31	AAU-DELISTED	Stock	0.25	0.2601	0.2427	0.25	193018.0
2022-05-31	AAUAF-DELISTED	Stock	0.25	0.2601	0.2427	0.25	196749.0
2022-05-31	AAWW-DELISTED	Stock	69.14	70.51	67.99	69.71	292806.0
2022-05-31	AAXJ	Stock	72.37	72.43	71.67	71.69	1159639.0
2022-05-31	AB	Stock	42.9	42.9	41.74	42.54	282700.0
2022-05-31	ABB-DELISTED	Stock	30.9	31.0808	30.55	30.96	2995868.0
2022-05-31	ABBNY-DELISTED	Stock	30.9	31.0808	30.55	30.97	3179126.0
2022-05-31	ABBV	Stock	148.64	148.88	146.67	147.37	11227800.0
2022-05-31	ABC-DELISTED	Stock	156.0	156.38	153.73	154.95	3301145.0
2022-05-31	ABCB	Stock	45.57	45.89	44.87	45.59	372100.0
2022-05-31	ABCL	Stock	7.86	7.98	7.54	7.62	1445300.0
2022-05-31	ABCM-DELISTED	Stock	14.96	15.03	14.77	14.86	134388.0
2022-05-31	ABEO	Stock	4.25	4.5	4.0	4.25	25848.0
2022-05-31	ABEV	Stock	2.97	2.99	2.92	2.96	24248800.0
2022-05-31	ABG	Stock	183.35	184.14	179.88	181.15	207300.0
2022-05-31	ABM	Stock	48.01	48.6	47.4	48.35	309300.0
2022-05-31	ABMD-DELISTED	Stock	263.94	265.04	256.13	263.7	450434.0
2022-05-31	ABNB	Stock	120.5	122.299	117.16	120.87	9117600.0
2022-05-31	ABOS	Stock	3.58	3.67	3.46	3.54	95600.0
2022-05-31	ABR	Stock	16.64	16.65	16.32	16.42	2054300.0
2022-05-31	ABR.D	Stock	22.89	22.89	21.5	22.01	34268.0

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

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