PREVIEW / stock_daily / 2023-02-03

all stock daily files

  file:    by_date/stock_daily/2023/2023-02-03.parquet
  size:    249 KB
  rows:    7,698
  symbols: 1,889

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-02-03	AAPL	Stock	148.03	157.38	147.83	154.5	154357300.0
2023-02-03	MSFT	Stock	259.54	264.2	257.1	258.35	29077300.0
2023-02-03	NVDA	Stock	21.0	21.745	20.789	21.1	429366000.0
2023-02-03	AMZN	Stock	105.26	108.78	102.52	103.39	144374800.0
2023-02-03	GOOGL	Stock	102.93	107.81	102.58	104.78	65309261.0
2023-02-03	META	Stock	183.47	196.77	182.89	186.53	76809700.0
2023-02-03	TSLA	Stock	183.95	199.0	183.69	189.98	232662000.0
2023-02-03	TLT	Stock	106.77	107.11	106.08	106.7	20619484.0
2023-02-03	ES	Stock	82.93	83.18	79.52	80.35	1739600.0
2023-02-03	CL	Stock	73.96	74.4	73.22	74.29	3861200.0
2023-02-03	A	Stock	153.17	155.42	152.74	154.55	992800.0
2023-02-03	AA	Stock	53.4	54.38	52.58	52.74	3546200.0
2023-02-03	AAC-DELISTED	Stock	10.16	10.21	10.16	10.19	972633.0
2023-02-03	AACG	Stock	1.5	1.62	1.49	1.5	6500.0
2023-02-03	AAIC-DELISTED	Stock	3.08	3.08	3.03	3.03	50313.0
2023-02-03	AAIC.C-DELISTED	Stock	22.8	22.8	22.58	22.8	1200.0
2023-02-03	AAL	Stock	16.85	17.22	16.85	17.02	22108200.0
2023-02-03	AAM.A-DELISTED	Stock	25.39	25.39	25.03	25.25	5279.0
2023-02-03	AAM.B-DELISTED	Stock	25.26	25.57	25.21	25.21	3748.0
2023-02-03	AAMC-DELISTED	Stock	11.1618	11.3706	10.9103	10.9941	40066.0
2023-02-03	AAME	Stock	2.54	2.57	2.5	2.51	2400.0
2023-02-03	AAMI	Stock	24.87	26.01	24.87	25.77	290700.0
2023-02-03	AAN-DELISTED	Stock	15.5	15.74	15.37	15.47	257600.0
2023-02-03	AAOI	Stock	2.81	2.896	2.67	2.7	193900.0
2023-02-03	AAON	Stock	52.6667	53.9533	52.6667	53.8533	246750.0
2023-02-03	AAP	Stock	153.28	155.72	151.8	152.17	580700.0
2023-02-03	AAT	Stock	29.28	29.28	28.72	28.89	315100.0
2023-02-03	AATC	Stock	4.14	4.18	4.14	4.18	1271.0
2023-02-03	AAU-DELISTED	Stock	0.2302	0.2389	0.23	0.2301	240416.0
2023-02-03	AAUAF-DELISTED	Stock	0.2302	0.2389	0.23	0.2301	244739.0
2023-02-03	AAWW-DELISTED	Stock	102.24	102.25	102.07	102.12	635540.0
2023-02-03	AAXJ	Stock	71.07	71.12	70.16	70.24	720777.0
2023-02-03	AB	Stock	39.25	40.07	39.1	39.26	284400.0
2023-02-03	ABB-DELISTED	Stock	34.02	34.58	33.96	34.38	1404563.0
2023-02-03	ABBNY-DELISTED	Stock	34.02	34.58	33.96	34.39	1605095.0
2023-02-03	ABBV	Stock	145.92	146.8	144.7	145.2	6553000.0
2023-02-03	ABC-DELISTED	Stock	159.35	159.72	155.9	156.82	1030333.0
2023-02-03	ABCB	Stock	49.42	50.54	49.27	50.18	522100.0
2023-02-03	ABCL	Stock	10.83	11.375	10.73	11.18	1253800.0
2023-02-03	ABCM-DELISTED	Stock	14.92	15.36	14.7	14.85	397036.0
2023-02-03	ABEO	Stock	2.77	2.9	2.72	2.76	158400.0
2023-02-03	ABEV	Stock	2.54	2.57	2.49	2.51	33203800.0
2023-02-03	ABG	Stock	237.45	251.76	236.9	243.13	464300.0
2023-02-03	ABGI-DELISTED	Stock	10.15	10.15	10.15	10.15	200.0
2023-02-03	ABLV	Stock	10.27	10.27	10.2403	10.2403	700.0
2023-02-03	ABM	Stock	47.72	48.27	47.42	48.01	309800.0
2023-02-03	ABNB	Stock	116.04	121.4	115.85	118.7	6130700.0
2023-02-03	ABOS	Stock	5.87	5.98	5.65	5.75	81700.0
2023-02-03	ABR	Stock	15.15	15.37	15.02	15.31	1502400.0
2023-02-03	ABR.D	Stock	20.8	20.9699	20.5557	20.75	15173.0

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

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