PREVIEW / stock_daily / 2022-05-16

all stock daily files

  file:    by_date/stock_daily/2022/2022-05-16.parquet
  size:    257 KB
  rows:    7,982
  symbols: 2,426

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-16	AAPL	Stock	145.55	147.52	144.18	145.54	86643800.0
2022-05-16	MSFT	Stock	259.96	265.82	255.78	261.5	32550900.0
2022-05-16	NVDA	Stock	17.509	17.788	17.106	17.264	521446000.0
2022-05-16	AMZN	Stock	113.1	113.9925	110.354	110.8105	74566000.0
2022-05-16	GOOGL	Stock	114.9555	116.17	113.8895	114.445	25990440.0
2022-05-16	META	Stock	197.05	205.37	195.93	200.04	27112600.0
2022-05-16	TSLA	Stock	255.72	256.5867	239.6967	241.4567	86098500.0
2022-05-16	TLT	Stock	116.21	116.935	115.85	115.86	11050571.0
2022-05-16	ES	Stock	89.63	90.12	88.72	89.27	1598500.0
2022-05-16	CL	Stock	78.14	79.24	77.61	78.73	3981100.0
2022-05-16	A	Stock	119.63	121.03	118.83	120.3	2011600.0
2022-05-16	AA	Stock	59.5	61.15	58.6	60.28	6681500.0
2022-05-16	AAC-DELISTED	Stock	9.79	9.8099	9.79	9.79	345144.0
2022-05-16	AACG	Stock	1.15	1.15	1.01	1.01	10300.0
2022-05-16	AACIW-DELISTED	Stock	0.2699	0.27	0.2675	0.2678	9953.0
2022-05-16	AAIC-DELISTED	Stock	3.5	3.68	3.49	3.64	116052.0
2022-05-16	AAIC.C-DELISTED	Stock	22.85	22.85	22.3226	22.3226	1333.0
2022-05-16	AAL	Stock	16.5	17.03	16.42	16.55	25223400.0
2022-05-16	AAM.A-DELISTED	Stock	24.09	24.5	24.0	24.43	7940.0
2022-05-16	AAM.B-DELISTED	Stock	23.99	24.4799	23.82	24.422	22572.0
2022-05-16	AAMC-DELISTED	Stock	2.9412	3.1382	2.9412	3.0059	13209.0
2022-05-16	AAME	Stock	2.85	2.98	2.71	2.71	8100.0
2022-05-16	AAMI	Stock	19.48	19.785	19.095	19.47	370700.0
2022-05-16	AAN-DELISTED	Stock	19.7	20.17	19.17	19.89	204600.0
2022-05-16	AAOI	Stock	2.3	2.43	2.271	2.33	165300.0
2022-05-16	AAON	Stock	35.3533	35.36	33.2133	34.0	264450.0
2022-05-16	AAP	Stock	210.57	215.75	208.59	213.69	541200.0
2022-05-16	AAQC-DELISTED	Stock	9.75	9.75	9.75	9.75	100.0
2022-05-16	AAT	Stock	32.84	33.19	32.56	32.82	253400.0
2022-05-16	AATC	Stock	5.7	5.865	5.5979	5.8	12737.0
2022-05-16	AAU-DELISTED	Stock	0.28	0.2898	0.2741	0.2804	204481.0
2022-05-16	AAUAF-DELISTED	Stock	0.28	0.2898	0.2741	0.275	208185.0
2022-05-16	AAWW-DELISTED	Stock	70.32	70.75	68.92	69.52	178267.0
2022-05-16	AAXJ	Stock	67.64	68.07	67.48	67.72	1200104.0
2022-05-16	AB	Stock	38.2	38.41	37.16	37.84	508400.0
2022-05-16	ABB-DELISTED	Stock	28.485	28.625	28.205	28.44	2152642.0
2022-05-16	ABBNY-DELISTED	Stock	28.485	28.625	28.205	28.44	2425923.0
2022-05-16	ABBV	Stock	153.93	156.89	153.27	155.47	6565600.0
2022-05-16	ABC-DELISTED	Stock	153.82	156.56	153.285	154.55	1142152.0
2022-05-16	ABCB	Stock	42.45	42.97	41.89	42.45	400200.0
2022-05-16	ABCL	Stock	7.22	7.91	6.92	7.81	2600300.0
2022-05-16	ABCM-DELISTED	Stock	13.44	13.64	13.33	13.55	92403.0
2022-05-16	ABEO	Stock	4.25	4.75	4.0	4.5	65200.0
2022-05-16	ABEV	Stock	2.84	2.92	2.84	2.89	26222900.0
2022-05-16	ABG	Stock	191.67	191.67	182.68	186.05	192500.0
2022-05-16	ABGI-DELISTED	Stock	9.79	9.79	9.79	9.79	12000.0
2022-05-16	ABM	Stock	44.2	45.35	43.75	45.19	729000.0
2022-05-16	ABMD-DELISTED	Stock	251.49	256.93	248.0	253.67	161207.0
2022-05-16	ABNB	Stock	121.0	121.07	113.25	114.44	7588400.0
2022-05-16	ABOS	Stock	3.36	3.44	3.11	3.23	210600.0

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

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