PREVIEW / stock_daily / 2023-05-22

all stock daily files

  file:    by_date/stock_daily/2023/2023-05-22.parquet
  size:    242 KB
  rows:    7,532
  symbols: 1,639

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
2023-05-22	AAPL	Stock	173.98	174.71	173.45	174.2	43570900.0
2023-05-22	MSFT	Stock	318.6	322.59	318.01	321.18	24115700.0
2023-05-22	NVDA	Stock	30.901	31.52	30.68	31.176	372000000.0
2023-05-22	AMZN	Stock	116.77	116.77	114.25	115.01	70741100.0
2023-05-22	GOOGL	Stock	122.94	126.43	122.74	125.05	35253034.0
2023-05-22	META	Stock	245.41	253.57	245.12	248.32	27738500.0
2023-05-22	TSLA	Stock	180.7	189.32	180.11	188.87	132001400.0
2023-05-22	TLT	Stock	101.25	101.71	100.67	100.74	20131107.0
2023-05-22	ES	Stock	73.37	73.8	72.68	72.75	1830200.0
2023-05-22	CL	Stock	79.58	79.66	78.22	78.41	6066200.0
2023-05-22	A	Stock	128.66	129.75	128.29	129.09	1764500.0
2023-05-22	AA	Stock	36.18	36.94	36.06	36.4	3252800.0
2023-05-22	AAC-DELISTED	Stock	10.48	10.49	10.45	10.48	86890.0
2023-05-22	AACG	Stock	1.49	1.57	1.49	1.52	9700.0
2023-05-22	AACIW-DELISTED	Stock	0.08	0.1089	0.08	0.1089	2270.0
2023-05-22	AAIC-DELISTED	Stock	2.56	2.66	2.56	2.65	106742.0
2023-05-22	AAIC.C-DELISTED	Stock	21.1	21.1	21.1	21.1	100.0
2023-05-22	AAL	Stock	14.92	14.98	14.1	14.38	28517200.0
2023-05-22	AAM.A-DELISTED	Stock	23.5258	24.17	23.5258	23.9949	6013.0
2023-05-22	AAM.B-DELISTED	Stock	23.72	24.45	23.3572	24.18	15417.0
2023-05-22	AAMC-DELISTED	Stock	28.3235	29.5529	28.141	28.8176	9972.0
2023-05-22	AAME	Stock	2.23	2.23	2.23	2.23	300.0
2023-05-22	AAMI	Stock	22.84	23.155	22.505	23.0	91900.0
2023-05-22	AAN-DELISTED	Stock	12.66	12.85	12.45	12.75	144200.0
2023-05-22	AAOI	Stock	1.7	1.78	1.7	1.76	120000.0
2023-05-22	AAON	Stock	61.2133	61.52	60.1133	60.38	551550.0
2023-05-22	AAP	Stock	118.23	119.87	117.7	119.44	1117300.0
2023-05-22	AAT	Stock	19.1	19.49	18.88	19.32	509100.0
2023-05-22	AATC	Stock	4.31	4.46	4.31	4.45	12904.0
2023-05-22	AAU-DELISTED	Stock	0.125	0.1251	0.117	0.122	281425.0
2023-05-22	AAUAF-DELISTED	Stock	0.125	0.1251	0.115	0.115	284037.0
2023-05-22	AAXJ	Stock	66.38	66.96	66.38	66.68	475328.0
2023-05-22	AB	Stock	34.25	35.0	34.25	34.67	99400.0
2023-05-22	ABB-DELISTED	Stock	37.51	37.575	37.11	37.13	6039261.0
2023-05-22	ABBNY-DELISTED	Stock	37.51	37.575	37.11	37.13	6388480.0
2023-05-22	ABBV	Stock	145.47	146.66	143.78	144.9	3867300.0
2023-05-22	ABC-DELISTED	Stock	173.94	173.94	169.81	172.22	1061348.0
2023-05-22	ABCB	Stock	31.44	32.19	30.92	32.0	298000.0
2023-05-22	ABCL	Stock	5.84	6.68	5.755	6.61	5692300.0
2023-05-22	ABCM-DELISTED	Stock	16.96	16.965	16.55	16.69	1073704.0
2023-05-22	ABEO	Stock	3.1	3.39	3.07	3.24	417200.0
2023-05-22	ABEV	Stock	2.94	2.94	2.89	2.89	15018600.0
2023-05-22	ABG	Stock	205.57	206.24	202.08	204.35	141400.0
2023-05-22	ABM	Stock	43.6	43.94	43.41	43.49	208200.0
2023-05-22	ABNB	Stock	106.26	110.73	106.2	109.93	7350600.0
2023-05-22	ABOS	Stock	5.87	5.878	5.04	5.31	663800.0
2023-05-22	ABR	Stock	12.3	12.58	12.13	12.51	3333300.0
2023-05-22	ABR.D	Stock	17.15	17.27	17.02	17.0201	11719.0
2023-05-22	ABR.E	Stock	16.6976	16.95	16.575	16.9	13059.0
2023-05-22	ABR.F	Stock	18.0	18.12	17.9	18.08	12023.0

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

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