PREVIEW / stock_daily / 2023-02-02

all stock daily files

  file:    by_date/stock_daily/2023/2023-02-02.parquet
  size:    251 KB
  rows:    7,725
  symbols: 1,900

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-02	AAPL	Stock	148.9	151.18	148.17	150.82	118339000.0
2023-02-02	MSFT	Stock	258.82	264.69	257.25	264.6	39940400.0
2023-02-02	NVDA	Stock	21.0	21.949	20.7	21.709	564276000.0
2023-02-02	AMZN	Stock	110.25	114.0	108.88	112.91	158154200.0
2023-02-02	GOOGL	Stock	105.8	107.85	105.61	107.74	69883762.0
2023-02-02	META	Stock	183.38	197.16	180.16	188.77	150475700.0
2023-02-02	TSLA	Stock	187.33	196.75	182.61	188.27	217448300.0
2023-02-02	TLT	Stock	108.92	109.352	108.085	108.32	19548415.0
2023-02-02	ES	Stock	83.06	84.0	82.23	83.4	2265900.0
2023-02-02	CL	Stock	74.18	74.2	73.31	73.73	5024700.0
2023-02-02	A	Stock	156.66	157.31	154.77	155.5	1725600.0
2023-02-02	AA	Stock	54.28	54.469	51.92	53.66	4665600.0
2023-02-02	AAC-DELISTED	Stock	10.17	10.17	10.1518	10.16	42281.0
2023-02-02	AACG	Stock	1.5	1.5	1.4	1.43	7900.0
2023-02-02	AACIW-DELISTED	Stock	0.1	0.1	0.1	0.1	6079.0
2023-02-02	AAIC-DELISTED	Stock	3.06	3.1	3.03	3.1	136204.0
2023-02-02	AAIC.C-DELISTED	Stock	22.63	22.63	22.6	22.6	783.0
2023-02-02	AAL	Stock	16.73	17.32	16.72	17.06	31552200.0
2023-02-02	AAM.A-DELISTED	Stock	25.23	25.45	25.195	25.37	15727.0
2023-02-02	AAM.B-DELISTED	Stock	25.27	25.58	24.9	25.58	10004.0
2023-02-02	AAMC-DELISTED	Stock	11.3471	11.35	10.0147	10.9412	58922.0
2023-02-02	AAME	Stock	2.57	2.57	2.5	2.54	1900.0
2023-02-02	AAMI	Stock	24.81	25.565	24.415	25.07	343700.0
2023-02-02	AAN-DELISTED	Stock	15.15	15.91	15.05	15.71	198500.0
2023-02-02	AAOI	Stock	2.6	2.88	2.589	2.82	713300.0
2023-02-02	AAON	Stock	52.1	53.2867	52.1	53.2867	232050.0
2023-02-02	AAP	Stock	157.0	158.22	155.17	155.24	737000.0
2023-02-02	AAT	Stock	29.09	29.73	29.09	29.66	225300.0
2023-02-02	AATC	Stock	4.15	4.18	4.08	4.14	16274.0
2023-02-02	AAU-DELISTED	Stock	0.2327	0.239	0.2302	0.2334	312008.0
2023-02-02	AAUAF-DELISTED	Stock	0.2327	0.239	0.2302	0.2334	294875.0
2023-02-02	AAWW-DELISTED	Stock	102.2	102.25	102.18	102.25	273550.0
2023-02-02	AAXJ	Stock	72.22	72.22	71.21	71.54	1216521.0
2023-02-02	AB	Stock	38.88	39.94	38.88	39.55	345300.0
2023-02-02	ABB-DELISTED	Stock	33.93	34.215	33.63	33.93	1563560.0
2023-02-02	ABBNY-DELISTED	Stock	33.93	34.215	33.63	33.93	1769206.0
2023-02-02	ABBV	Stock	145.93	145.93	143.44	144.84	6160800.0
2023-02-02	ABC-DELISTED	Stock	161.5	161.825	157.715	158.5	1673641.0
2023-02-02	ABCB	Stock	48.08	49.83	47.86	49.79	442600.0
2023-02-02	ABCL	Stock	10.92	11.11	10.82	11.01	1331200.0
2023-02-02	ABCM-DELISTED	Stock	14.73	15.33	14.53	15.23	631314.0
2023-02-02	ABEO	Stock	2.68	2.84	2.62	2.82	254600.0
2023-02-02	ABEV	Stock	2.63	2.64	2.56	2.58	45248000.0
2023-02-02	ABG	Stock	235.84	253.67	234.67	241.71	1012700.0
2023-02-02	ABGI-DELISTED	Stock	10.15	10.155	10.15	10.155	400.0
2023-02-02	ABM	Stock	47.36	48.04	47.24	47.94	249000.0
2023-02-02	ABNB	Stock	116.25	119.85	116.24	118.52	7166900.0
2023-02-02	ABOS	Stock	6.5	6.5	5.83	5.94	144300.0
2023-02-02	ABR	Stock	15.31	15.39	15.14	15.34	1973400.0
2023-02-02	ABR.D	Stock	20.86	21.05	20.7	20.871	31073.0

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

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