PREVIEW / stock_daily / 2022-05-02

all stock daily files

  file:    by_date/stock_daily/2022/2022-05-02.parquet
  size:    261 KB
  rows:    8,090
  symbols: 2,495

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-02	AAPL	Stock	156.71	158.23	153.27	157.96	123055300.0
2022-05-02	MSFT	Stock	277.71	284.94	276.22	284.47	35151100.0
2022-05-02	NVDA	Stock	18.541	19.574	18.391	19.533	572049000.0
2022-05-02	AMZN	Stock	122.401	124.668	118.375	124.5	148788000.0
2022-05-02	GOOGL	Stock	113.405	116.7455	112.6	116.583	35533020.0
2022-05-02	META	Stock	201.17	211.88	200.99	211.13	49915300.0
2022-05-02	TSLA	Stock	286.9233	302.12	282.6767	300.98	75781500.0
2022-05-02	TLT	Stock	117.86	118.27	116.93	117.18	29233885.0
2022-05-02	ES	Stock	88.11	88.59	85.29	86.18	1465800.0
2022-05-02	CL	Stock	77.07	77.37	74.21	75.18	7133000.0
2022-05-02	A	Stock	118.38	120.34	116.49	119.57	1756200.0
2022-05-02	AA	Stock	67.0	67.62	64.43	66.16	5816700.0
2022-05-02	AAC-DELISTED	Stock	9.83	9.8396	9.82	9.82	130460.0
2022-05-02	AACG	Stock	1.17	1.18	1.15	1.16	5300.0
2022-05-02	AAIC-DELISTED	Stock	3.07	3.18	3.05	3.15	210484.0
2022-05-02	AAIC.C-DELISTED	Stock	24.5	24.54	24.5	24.53	6084.0
2022-05-02	AAL	Stock	18.75	18.95	18.03	18.56	32639400.0
2022-05-02	AAM.A-DELISTED	Stock	24.79	24.87	24.45	24.8	26704.0
2022-05-02	AAM.B-DELISTED	Stock	25.36	25.48	25.15	25.16	22738.0
2022-05-02	AAMC-DELISTED	Stock	2.5824	2.7324	2.5824	2.7176	36948.0
2022-05-02	AAME	Stock	2.95	3.11	2.95	2.98	1900.0
2022-05-02	AAMI	Stock	20.04	20.4	19.65	20.24	329100.0
2022-05-02	AAN-DELISTED	Stock	20.63	21.36	20.43	21.34	217900.0
2022-05-02	AAOI	Stock	2.54	2.6	2.52	2.59	326900.0
2022-05-02	AAON	Stock	32.5133	33.4667	32.1067	33.0	284700.0
2022-05-02	AAP	Stock	200.49	202.86	197.11	200.49	733500.0
2022-05-02	AAQC-DELISTED	Stock	9.78	9.78	9.78	9.78	33300.0
2022-05-02	AAT	Stock	36.72	36.72	34.89	35.26	323800.0
2022-05-02	AATC	Stock	6.89	6.89	6.44	6.46	13670.0
2022-05-02	AAU-DELISTED	Stock	0.292	0.2978	0.28	0.285	419316.0
2022-05-02	AAUAF-DELISTED	Stock	0.292	0.2978	0.28	0.285	424044.0
2022-05-02	AAWW-DELISTED	Stock	69.05	69.34	67.29	69.14	307585.0
2022-05-02	AAXJ	Stock	70.89	71.19	70.12	71.01	2869661.0
2022-05-02	AB	Stock	39.94	40.41	38.68	39.72	621600.0
2022-05-02	ABB-DELISTED	Stock	29.64	29.75	29.015	29.6	2388362.0
2022-05-02	ABBNY-DELISTED	Stock	29.64	29.75	29.015	29.6	2797357.0
2022-05-02	ABBV	Stock	146.65	148.9	143.44	147.87	9690800.0
2022-05-02	ABC-DELISTED	Stock	152.27	152.9	147.85	149.03	1268143.0
2022-05-02	ABCB	Stock	42.0	43.15	41.38	42.99	550000.0
2022-05-02	ABCL	Stock	7.63	8.1	7.58	8.07	1305500.0
2022-05-02	ABCM-DELISTED	Stock	15.59	15.75	15.38	15.62	67131.0
2022-05-02	ABEO	Stock	5.25	5.75	5.25	5.5	76240.0
2022-05-02	ABEV	Stock	2.87	2.89	2.78	2.82	34277300.0
2022-05-02	ABG	Stock	184.55	188.73	179.48	187.86	301100.0
2022-05-02	ABGI-DELISTED	Stock	9.82	9.82	9.82	9.82	7198.0
2022-05-02	ABM	Stock	48.13	48.65	47.11	47.97	631100.0
2022-05-02	ABMD-DELISTED	Stock	287.01	289.76	275.94	285.96	187292.0
2022-05-02	ABNB	Stock	153.21	155.13	147.211	152.78	5945300.0
2022-05-02	ABOS	Stock	3.82	4.04	3.8	4.03	117300.0
2022-05-02	ABR	Stock	17.15	17.26	16.76	16.98	1853100.0

> showing 50 of 8,090 rows — these rows as CSV

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