PREVIEW / stock_daily / 2022-06-01

all stock daily files

  file:    by_date/stock_daily/2022/2022-06-01.parquet
  size:    259 KB
  rows:    7,989
  symbols: 2,410

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-01	AAPL	Stock	149.9	151.74	147.68	148.71	74286600.0
2022-06-01	MSFT	Stock	275.2	277.69	270.04	272.42	25292200.0
2022-06-01	NVDA	Stock	18.724	19.053	18.122	18.32	544514000.0
2022-06-01	AMZN	Stock	122.256	125.179	120.6225	121.684	127528000.0
2022-06-01	GOOGL	Stock	114.855	117.1016	113.25	113.892	36605520.0
2022-06-01	META	Stock	196.51	199.53	185.0	188.64	36623500.0
2022-06-01	TSLA	Stock	251.72	257.3267	243.64	246.79	77247900.0
2022-06-01	TLT	Stock	117.03	117.34	115.69	116.22	15544848.0
2022-06-01	ES	Stock	92.55	92.55	91.24	92.12	1602800.0
2022-06-01	CL	Stock	79.01	79.06	77.92	78.2	3963400.0
2022-06-01	A	Stock	127.86	128.98	122.43	123.09	1757600.0
2022-06-01	AA	Stock	61.135	63.71	60.64	62.41	4459100.0
2022-06-01	AAC-DELISTED	Stock	9.81	9.83	9.805	9.825	226253.0
2022-06-01	AACG	Stock	1.07	1.09	0.97	0.97	15100.0
2022-06-01	AACIW-DELISTED	Stock	0.23	0.23	0.2299	0.23	30670.0
2022-06-01	AAIC-DELISTED	Stock	3.52	3.59	3.48	3.59	55281.0
2022-06-01	AAIC.C-DELISTED	Stock	23.4205	23.4205	23.1419	23.1419	296.0
2022-06-01	AAL	Stock	18.07	18.1	16.98	17.29	32637900.0
2022-06-01	AAM.A-DELISTED	Stock	24.76	24.99	24.68	24.68	29992.0
2022-06-01	AAM.B-DELISTED	Stock	25.42	26.7	25.3	25.5895	24378.0
2022-06-01	AAMC-DELISTED	Stock	3.0378	3.0662	3.0294	3.0294	13532.0
2022-06-01	AAME	Stock	3.19	3.22	2.97	2.99	10100.0
2022-06-01	AAMI	Stock	20.33	20.46	19.89	20.25	297100.0
2022-06-01	AAN-DELISTED	Stock	19.56	20.04	17.9	17.95	272000.0
2022-06-01	AAOI	Stock	2.37	2.4	2.23	2.29	201900.0
2022-06-01	AAON	Stock	35.7	36.2733	35.3533	36.24	222450.0
2022-06-01	AAP	Stock	191.62	192.04	187.29	187.66	728600.0
2022-06-01	AAQC-DELISTED	Stock	9.765	9.765	9.76	9.765	5388.0
2022-06-01	AAT	Stock	34.13	34.13	33.0	33.3	346600.0
2022-06-01	AATC	Stock	6.0	6.0	5.78	5.78	5336.0
2022-06-01	AAU-DELISTED	Stock	0.2448	0.25	0.24	0.2421	316339.0
2022-06-01	AAUAF-DELISTED	Stock	0.2448	0.25	0.24	0.25	319817.0
2022-06-01	AAWW-DELISTED	Stock	70.2	70.48	68.425	69.11	367788.0
2022-06-01	AAXJ	Stock	72.05	72.17	70.86	71.11	855899.0
2022-06-01	AB	Stock	42.55	43.0	41.91	42.11	247100.0
2022-06-01	ABB-DELISTED	Stock	31.02	31.12	30.495	30.65	1638379.0
2022-06-01	ABBNY-DELISTED	Stock	31.02	31.12	30.495	30.66	1891961.0
2022-06-01	ABBV	Stock	147.79	147.89	144.32	146.02	5597900.0
2022-06-01	ABC-DELISTED	Stock	156.47	156.89	145.365	150.01	1823513.0
2022-06-01	ABCB	Stock	45.68	45.71	44.29	45.01	220000.0
2022-06-01	ABCL	Stock	7.69	8.15	7.5	7.8	3597100.0
2022-06-01	ABCM-DELISTED	Stock	15.14	15.18	14.745	14.91	53567.0
2022-06-01	ABEO	Stock	4.5	4.5	3.75	4.0	46912.0
2022-06-01	ABEV	Stock	2.95	2.95	2.89	2.93	39422500.0
2022-06-01	ABG	Stock	181.99	185.4	178.99	184.71	230900.0
2022-06-01	ABGI-DELISTED	Stock	9.78	9.78	9.78	9.78	23560.0
2022-06-01	ABM	Stock	48.0	48.81	47.56	48.3	308900.0
2022-06-01	ABMD-DELISTED	Stock	266.65	268.41	252.05	255.38	149340.0
2022-06-01	ABNB	Stock	121.05	121.074	114.395	116.72	6879600.0
2022-06-01	ABOS	Stock	3.59	3.59	3.25	3.27	150400.0

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

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