PREVIEW / stock_daily / 2022-05-17

all stock daily files

  file:    by_date/stock_daily/2022/2022-05-17.parquet
  size:    257 KB
  rows:    7,979
  symbols: 2,398

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-17	AAPL	Stock	148.86	149.77	146.68	149.24	78336300.0
2022-05-17	MSFT	Stock	266.11	268.33	262.46	266.82	28828800.0
2022-05-17	NVDA	Stock	18.074	18.371	17.634	18.177	585830000.0
2022-05-17	AMZN	Stock	113.275	115.8	111.2765	115.3685	76448000.0
2022-05-17	GOOGL	Stock	116.8405	116.9	114.8698	116.473	23053160.0
2022-05-17	META	Stock	202.12	205.46	198.36	202.62	24872700.0
2022-05-17	TSLA	Stock	249.12	254.8267	242.95	253.87	80236200.0
2022-05-17	TLT	Stock	114.71	115.35	114.36	114.46	15040753.0
2022-05-17	ES	Stock	89.31	90.13	88.02	90.06	952200.0
2022-05-17	CL	Stock	78.51	78.89	77.45	78.77	4017100.0
2022-05-17	A	Stock	122.7	123.7	121.45	123.08	2216200.0
2022-05-17	AA	Stock	64.17	64.71	61.8	63.4	6836900.0
2022-05-17	AAC-DELISTED	Stock	9.8	9.82	9.79	9.82	2191988.0
2022-05-17	AACG	Stock	1.13	1.13	1.07	1.09	12900.0
2022-05-17	AACIW-DELISTED	Stock	0.26	0.26	0.2594	0.26	30218.0
2022-05-17	AAIC-DELISTED	Stock	3.65	3.69	3.58	3.59	76332.0
2022-05-17	AAIC.C-DELISTED	Stock	22.725	22.725	22.6	22.61	500.0
2022-05-17	AAL	Stock	17.16	17.83	17.07	17.82	28978500.0
2022-05-17	AAM.A-DELISTED	Stock	24.39	24.39	24.05	24.16	51649.0
2022-05-17	AAM.B-DELISTED	Stock	24.39	24.98	24.385	24.78	32867.0
2022-05-17	AAMC-DELISTED	Stock	3.0118	3.1676	3.0118	3.1676	6032.0
2022-05-17	AAME	Stock	2.89	3.14	2.81	2.83	4800.0
2022-05-17	AAMI	Stock	19.86	20.57	19.86	20.57	412500.0
2022-05-17	AAN-DELISTED	Stock	20.31	20.92	19.99	20.86	232800.0
2022-05-17	AAOI	Stock	2.35	2.48	2.35	2.47	138000.0
2022-05-17	AAON	Stock	34.5933	34.8333	34.2267	34.5667	357450.0
2022-05-17	AAP	Stock	215.46	217.35	211.82	216.26	705400.0
2022-05-17	AAQC-DELISTED	Stock	9.74	9.7402	9.7201	9.73	13660.0
2022-05-17	AAT	Stock	33.1	33.65	32.91	33.56	218800.0
2022-05-17	AATC	Stock	5.77	6.11	5.74	5.9501	30118.0
2022-05-17	AAU-DELISTED	Stock	0.2851	0.2899	0.2712	0.2859	301275.0
2022-05-17	AAUAF-DELISTED	Stock	0.2851	0.2899	0.2712	0.2899	314617.0
2022-05-17	AAWW-DELISTED	Stock	70.72	72.81	70.62	72.7	209175.0
2022-05-17	AAXJ	Stock	69.69	69.91	69.04	69.66	1355810.0
2022-05-17	AB	Stock	38.51	40.04	38.51	39.55	389500.0
2022-05-17	ABB-DELISTED	Stock	29.1	29.395	28.945	29.32	2492489.0
2022-05-17	ABBNY-DELISTED	Stock	29.1	29.395	28.945	29.32	2859442.0
2022-05-17	ABBV	Stock	155.38	155.79	152.85	154.78	6032200.0
2022-05-17	ABC-DELISTED	Stock	155.67	157.49	152.655	156.93	1166593.0
2022-05-17	ABCB	Stock	43.34	44.41	43.21	44.33	358400.0
2022-05-17	ABCL	Stock	8.0	8.24	7.79	8.15	2464100.0
2022-05-17	ABCM-DELISTED	Stock	13.83	14.02	13.76	13.96	58373.0
2022-05-17	ABEO	Stock	5.5	5.5	4.25	4.25	103308.0
2022-05-17	ABEV	Stock	2.94	2.99	2.92	2.94	30461400.0
2022-05-17	ABG	Stock	188.66	194.64	187.98	192.92	176600.0
2022-05-17	ABM	Stock	46.05	47.08	45.72	46.95	839700.0
2022-05-17	ABMD-DELISTED	Stock	259.02	262.96	255.45	257.86	130359.0
2022-05-17	ABNB	Stock	119.97	120.18	114.51	117.5	6962900.0
2022-05-17	ABOS	Stock	3.36	3.66	3.24	3.65	242600.0
2022-05-17	ABR	Stock	17.3	17.43	17.12	17.36	3548100.0

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

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