PREVIEW / stock_daily / 2022-02-02

all stock daily files

  file:    by_date/stock_daily/2022/2022-02-02.parquet
  size:    259 KB
  rows:    8,015
  symbols: 2,543

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-02-02	AAPL	Stock	174.75	175.88	173.33	175.84	84914300.0
2022-02-02	MSFT	Stock	309.63	315.12	308.88	313.46	36636000.0
2022-02-02	NVDA	Stock	25.794	25.817	24.553	25.242	543419000.0
2022-02-02	AMZN	Stock	155.0505	155.075	148.8635	150.6125	87330000.0
2022-02-02	GOOGL	Stock	151.25	151.5466	145.5225	148.0	123199220.0
2022-02-02	META	Stock	327.82	328.0	316.87	323.0	58458300.0
2022-02-02	TSLA	Stock	309.3933	310.5	296.47	301.8867	66792900.0
2022-02-02	TLT	Stock	141.95	143.57	141.93	142.2	18404569.0
2022-02-02	ES	Stock	87.87	89.08	87.51	88.68	2037000.0
2022-02-02	CL	Stock	82.06	83.03	81.82	82.8	6814700.0
2022-02-02	A	Stock	140.99	144.76	140.78	144.24	1475700.0
2022-02-02	AA	Stock	58.19	59.585	57.25	59.21	5613800.0
2022-02-02	AAC-DELISTED	Stock	9.73	9.77	9.73	9.77	89080.0
2022-02-02	AACG	Stock	1.66	1.71	1.5	1.63	400400.0
2022-02-02	AACIW-DELISTED	Stock	0.2999	0.35	0.2999	0.3342	9692.0
2022-02-02	AAIC-DELISTED	Stock	3.45	3.45	3.3932	3.43	23117.0
2022-02-02	AAIC.C-DELISTED	Stock	25.03	25.03	25.03	25.03	120.0
2022-02-02	AAL	Stock	16.88	17.15	16.49	16.96	37904200.0
2022-02-02	AAM.A-DELISTED	Stock	25.25	25.28	25.2	25.27	132797.0
2022-02-02	AAM.B-DELISTED	Stock	25.98	26.07	25.87	25.95	76417.0
2022-02-02	AAME	Stock	2.5	2.63	2.46	2.58	6900.0
2022-02-02	AAMI	Stock	22.02	22.07	21.37	21.62	809500.0
2022-02-02	AAN-DELISTED	Stock	22.19	22.34	20.55	20.92	610200.0
2022-02-02	AAOI	Stock	4.15	4.2	3.87	4.0	236100.0
2022-02-02	AAON	Stock	42.6333	43.0133	41.06	41.2867	327750.0
2022-02-02	AAP	Stock	235.45	237.39	232.41	236.68	647300.0
2022-02-02	AAT	Stock	35.84	36.19	35.7	35.91	278400.0
2022-02-02	AATC	Stock	6.99	6.99	6.7501	6.88	15334.0
2022-02-02	AAU-DELISTED	Stock	0.3	0.3073	0.2954	0.303	501024.0
2022-02-02	AAUAF-DELISTED	Stock	0.3	0.3073	0.2954	0.303	503820.0
2022-02-02	AAWW-DELISTED	Stock	81.67	81.89	78.5	80.89	415761.0
2022-02-02	AAXJ	Stock	82.46	82.49	81.54	81.93	923707.0
2022-02-02	AB	Stock	48.98	49.0	47.35	47.55	354900.0
2022-02-02	ABB-DELISTED	Stock	35.35	35.65	35.3301	35.56	1843775.0
2022-02-02	ABBNY-DELISTED	Stock	35.35	35.65	35.3301	35.56	2054165.0
2022-02-02	ABBV	Stock	135.41	139.41	133.05	138.62	11363100.0
2022-02-02	ABC-DELISTED	Stock	134.33	137.99	132.0	136.08	1259159.0
2022-02-02	ABCB	Stock	48.76	50.64	48.03	49.15	597300.0
2022-02-02	ABCL	Stock	9.385	9.435	9.08	9.28	2889800.0
2022-02-02	ABCM-DELISTED	Stock	18.23	18.435	18.12	18.24	141552.0
2022-02-02	ABEO	Stock	7.5	7.5	6.25	6.5	149940.0
2022-02-02	ABEV	Stock	2.8	2.8	2.71	2.76	13040800.0
2022-02-02	ABG	Stock	167.13	172.59	165.0	170.25	660000.0
2022-02-02	ABM	Stock	41.79	42.0	41.34	41.82	407700.0
2022-02-02	ABMD-DELISTED	Stock	303.92	309.99	297.22	307.51	350713.0
2022-02-02	ABNB	Stock	156.313	156.51	150.712	151.76	3678300.0
2022-02-02	ABOS	Stock	5.2	5.2	4.7	4.98	228100.0
2022-02-02	ABR	Stock	17.57	17.58	17.16	17.34	1662300.0
2022-02-02	ABR.D	Stock	24.75	24.75	24.42	24.51	16330.0
2022-02-02	ABR.E	Stock	24.27	24.42	24.0	24.0	13451.0

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

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