PREVIEW / stock_daily / 2022-05-18

all stock daily files

  file:    by_date/stock_daily/2022/2022-05-18.parquet
  size:    256 KB
  rows:    7,957
  symbols: 2,405

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-18	AAPL	Stock	146.85	147.36	139.9	140.82	109742900.0
2022-05-18	MSFT	Stock	263.0	263.6	252.77	254.08	31356000.0
2022-05-18	NVDA	Stock	17.705	18.118	16.864	16.938	545161000.0
2022-05-18	AMZN	Stock	111.4395	112.853	106.249	107.1125	108380000.0
2022-05-18	GOOGL	Stock	115.0	115.4	111.5555	111.8995	35125980.0
2022-05-18	META	Stock	200.0	201.0	191.63	192.24	23960000.0
2022-05-18	TSLA	Stock	248.1733	253.5	233.6033	236.6033	87811800.0
2022-05-18	TLT	Stock	114.72	117.0	114.61	116.9	21337265.0
2022-05-18	ES	Stock	89.81	90.05	88.84	89.18	1758100.0
2022-05-18	CL	Stock	78.28	78.47	75.51	75.71	4590300.0
2022-05-18	A	Stock	121.19	121.91	120.31	120.79	1336000.0
2022-05-18	AA	Stock	62.62	63.819	60.01	60.51	6828100.0
2022-05-18	AAC-DELISTED	Stock	9.82	9.82	9.79	9.805	159488.0
2022-05-18	AACG	Stock	1.1	1.1	1.08	1.08	3100.0
2022-05-18	AAIC-DELISTED	Stock	3.55	3.6	3.45	3.476	46092.0
2022-05-18	AAIC.C-DELISTED	Stock	22.52	22.7	22.5	22.7	700.0
2022-05-18	AAL	Stock	17.45	17.84	16.78	16.89	29441900.0
2022-05-18	AAM.A-DELISTED	Stock	24.06	24.07	23.77	23.99	32442.0
2022-05-18	AAM.B-DELISTED	Stock	24.53	24.845	24.53	24.6886	15312.0
2022-05-18	AAMC-DELISTED	Stock	3.0824	3.0824	3.0466	3.0466	3760.0
2022-05-18	AAME	Stock	2.8	2.8	2.78	2.79	2000.0
2022-05-18	AAMI	Stock	20.11	20.39	19.62	19.88	561000.0
2022-05-18	AAN-DELISTED	Stock	20.39	20.66	19.26	19.62	338300.0
2022-05-18	AAOI	Stock	2.45	2.56	2.37	2.38	74700.0
2022-05-18	AAON	Stock	33.84	34.2133	33.0533	33.3867	373650.0
2022-05-18	AAP	Stock	212.86	212.86	192.42	195.5	1398000.0
2022-05-18	AAQC-DELISTED	Stock	9.74	9.75	9.74	9.745	98178.0
2022-05-18	AAT	Stock	33.33	33.42	32.52	32.75	289200.0
2022-05-18	AATC	Stock	6.085	6.1	5.96	6.02	19473.0
2022-05-18	AAU-DELISTED	Stock	0.28	0.287	0.2711	0.2725	250684.0
2022-05-18	AAUAF-DELISTED	Stock	0.28	0.287	0.2711	0.2725	254746.0
2022-05-18	AAWW-DELISTED	Stock	72.5	72.5	68.97	69.09	344879.0
2022-05-18	AAXJ	Stock	69.13	69.35	67.87	67.99	1737582.0
2022-05-18	AB	Stock	39.25	39.71	38.6	39.01	398400.0
2022-05-18	ABB-DELISTED	Stock	29.26	29.43	28.765	28.82	3592786.0
2022-05-18	ABBNY-DELISTED	Stock	29.26	29.43	28.765	28.81	3841050.0
2022-05-18	ABBV	Stock	154.79	155.7	151.75	152.43	6498100.0
2022-05-18	ABC-DELISTED	Stock	156.93	157.56	150.78	151.16	1189579.0
2022-05-18	ABCB	Stock	43.54	43.92	42.5	42.86	557500.0
2022-05-18	ABCL	Stock	7.92	8.57	7.9	8.03	1675700.0
2022-05-18	ABCM-DELISTED	Stock	13.81	13.88	13.56	13.58	121046.0
2022-05-18	ABEO	Stock	4.75	4.75	4.0	4.0	34248.0
2022-05-18	ABEV	Stock	2.91	2.94	2.8	2.8	49194000.0
2022-05-18	ABG	Stock	188.68	189.97	173.8	176.43	280600.0
2022-05-18	ABGI-DELISTED	Stock	9.79	9.79	9.79	9.79	10273.0
2022-05-18	ABM	Stock	46.93	46.94	45.29	45.61	559300.0
2022-05-18	ABMD-DELISTED	Stock	253.22	254.88	239.21	240.19	174983.0
2022-05-18	ABNB	Stock	116.11	117.04	107.62	108.03	9718700.0
2022-05-18	ABOS	Stock	3.5	3.7	3.46	3.49	152300.0
2022-05-18	ABR	Stock	17.03	17.23	16.72	16.8	4252300.0

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

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