PREVIEW / stock_daily / 2022-05-20

all stock daily files

  file:    by_date/stock_daily/2022/2022-05-20.parquet
  size:    257 KB
  rows:    7,961
  symbols: 2,391

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-20	AAPL	Stock	139.09	140.7	132.61	137.59	137426100.0
2022-05-20	MSFT	Stock	257.24	258.54	246.44	252.56	39199300.0
2022-05-20	NVDA	Stock	17.332	17.41	15.755	16.694	739105000.0
2022-05-20	AMZN	Stock	109.5685	109.898	105.0095	107.591	99500000.0
2022-05-20	GOOGL	Stock	111.951	112.1835	105.7964	108.908	48962960.0
2022-05-20	META	Stock	194.97	197.91	187.87	193.54	31465600.0
2022-05-20	TSLA	Stock	237.9967	240.5267	211.0	221.3	144973200.0
2022-05-20	TLT	Stock	117.09	119.02	117.06	118.51	22780940.0
2022-05-20	ES	Stock	89.65	90.44	88.86	90.37	1487000.0
2022-05-20	CL	Stock	75.38	75.63	73.87	75.13	6937200.0
2022-05-20	A	Stock	124.03	125.58	122.44	125.13	2594600.0
2022-05-20	AA	Stock	63.06	63.75	58.51	60.57	8741000.0
2022-05-20	AAC-DELISTED	Stock	9.79	9.795	9.79	9.79	49949.0
2022-05-20	AACG	Stock	1.03	1.03	1.01	1.01	7900.0
2022-05-20	AAIC-DELISTED	Stock	3.4316	3.45	3.38	3.38	36039.0
2022-05-20	AAIC.C-DELISTED	Stock	22.68	22.68	22.68	22.68	100.0
2022-05-20	AAL	Stock	17.06	17.16	15.83	16.26	34090600.0
2022-05-20	AAM.A-DELISTED	Stock	24.19	24.2	23.76	23.88	60113.0
2022-05-20	AAM.B-DELISTED	Stock	24.8	24.95	24.6	24.86	31084.0
2022-05-20	AAMC-DELISTED	Stock	2.9382	3.0432	2.9	3.0432	21587.0
2022-05-20	AAME	Stock	2.86	2.86	2.7	2.71	7000.0
2022-05-20	AAMI	Stock	20.16	20.33	19.353	19.82	290800.0
2022-05-20	AAN-DELISTED	Stock	19.12	19.44	17.26	18.17	316400.0
2022-05-20	AAOI	Stock	2.5	2.5	2.26	2.29	156900.0
2022-05-20	AAON	Stock	34.0067	34.3867	33.0533	34.38	471600.0
2022-05-20	AAP	Stock	197.55	197.55	176.72	181.89	1919600.0
2022-05-20	AAT	Stock	32.16	32.16	30.97	31.69	291900.0
2022-05-20	AATC	Stock	6.12	6.12	5.88	6.06	14598.0
2022-05-20	AAU-DELISTED	Stock	0.2801	0.2801	0.271	0.2711	270033.0
2022-05-20	AAUAF-DELISTED	Stock	0.2801	0.2801	0.271	0.2711	273999.0
2022-05-20	AAWW-DELISTED	Stock	67.68	67.82	62.87	65.06	488478.0
2022-05-20	AAXJ	Stock	69.77	70.04	68.38	69.37	3378369.0
2022-05-20	AB	Stock	38.86	39.4	38.33	39.05	416800.0
2022-05-20	ABB-DELISTED	Stock	29.7	29.72	28.97	29.51	2458411.0
2022-05-20	ABBNY-DELISTED	Stock	29.7	29.72	28.97	29.5	2693240.0
2022-05-20	ABBV	Stock	152.33	153.52	147.81	151.01	6746400.0
2022-05-20	ABC-DELISTED	Stock	149.59	151.68	148.08	150.23	1778211.0
2022-05-20	ABCB	Stock	42.69	43.09	41.74	43.01	456500.0
2022-05-20	ABCL	Stock	8.45	8.48	7.65	7.9	1300400.0
2022-05-20	ABCM-DELISTED	Stock	14.3	14.53	14.26	14.5	61421.0
2022-05-20	ABEO	Stock	4.25	4.5	3.75	4.0	46260.0
2022-05-20	ABEV	Stock	2.83	2.86	2.79	2.82	36230500.0
2022-05-20	ABG	Stock	180.69	180.69	165.04	170.96	311200.0
2022-05-20	ABGI-DELISTED	Stock	9.79	9.79	9.79	9.79	50100.0
2022-05-20	ABM	Stock	45.38	45.52	44.31	45.45	507700.0
2022-05-20	ABMD-DELISTED	Stock	241.06	242.43	226.46	236.08	315968.0
2022-05-20	ABNB	Stock	115.46	116.25	108.5	112.55	6961900.0
2022-05-20	ABOS	Stock	3.57	3.57	3.27	3.48	156500.0
2022-05-20	ABR	Stock	16.27	16.28	15.55	15.67	4666900.0
2022-05-20	ABR.D	Stock	20.7908	20.7908	20.65	20.77	10866.0

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

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