PREVIEW / stock_daily / 2023-02-09

all stock daily files

  file:    by_date/stock_daily/2023/2023-02-09.parquet
  size:    248 KB
  rows:    7,647
  symbols: 1,843

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-09	AAPL	Stock	153.78	154.33	150.42	150.87	56007100.0
2023-02-09	MSFT	Stock	273.8	273.98	262.8	263.62	42375100.0
2023-02-09	NVDA	Stock	22.606	23.02	22.12	22.337	523876000.0
2023-02-09	AMZN	Stock	101.32	101.78	97.57	98.24	64622500.0
2023-02-09	GOOGL	Stock	100.0	100.03	93.63	95.01	119455020.0
2023-02-09	META	Stock	186.13	186.65	177.27	177.92	37118800.0
2023-02-09	TSLA	Stock	207.78	214.0	204.77	207.32	215431400.0
2023-02-09	TLT	Stock	106.47	106.62	104.39	104.56	20469923.0
2023-02-09	ES	Stock	79.24	79.77	78.08	78.19	1075100.0
2023-02-09	CL	Stock	73.51	73.75	72.81	72.83	3740400.0
2023-02-09	A	Stock	155.67	156.32	151.54	152.38	852200.0
2023-02-09	AA	Stock	51.47	51.67	49.714	50.01	4197600.0
2023-02-09	AAC-DELISTED	Stock	10.18	10.2061	10.18	10.19	214880.0
2023-02-09	AACG	Stock	1.71	1.78	1.62	1.71	14700.0
2023-02-09	AACIW-DELISTED	Stock	0.126	0.136	0.0828	0.125	728.0
2023-02-09	AAIC-DELISTED	Stock	3.03	3.04	2.995	3.01	137626.0
2023-02-09	AAIC.C-DELISTED	Stock	22.5	22.5	22.4999	22.5	1240.0
2023-02-09	AAL	Stock	17.11	17.16	16.59	16.66	17558700.0
2023-02-09	AAM.A-DELISTED	Stock	24.66	24.66	24.62	24.66	3686.0
2023-02-09	AAM.B-DELISTED	Stock	24.95	25.07	24.51	24.7	3198.0
2023-02-09	AAMC-DELISTED	Stock	10.5882	10.7088	10.3824	10.7	38478.0
2023-02-09	AAME	Stock	2.48	2.57	2.35	2.42	6500.0
2023-02-09	AAMI	Stock	25.96	26.07	25.43	25.47	219600.0
2023-02-09	AAN-DELISTED	Stock	15.19	15.35	14.86	14.88	196600.0
2023-02-09	AAOI	Stock	2.6	2.7	2.6	2.63	117200.0
2023-02-09	AAON	Stock	51.9733	52.0133	50.38	50.68	292950.0
2023-02-09	AAP	Stock	150.51	152.33	148.72	151.91	1025600.0
2023-02-09	AAT	Stock	27.41	27.69	26.33	26.45	537000.0
2023-02-09	AATC	Stock	4.4	4.425	4.21	4.315	11465.0
2023-02-09	AAU-DELISTED	Stock	0.225	0.2275	0.215	0.2167	192487.0
2023-02-09	AAUAF-DELISTED	Stock	0.225	0.2275	0.215	0.2167	196891.0
2023-02-09	AAWW-DELISTED	Stock	102.2	102.217	102.14	102.15	188766.0
2023-02-09	AAXJ	Stock	70.69	70.75	69.83	70.03	412117.0
2023-02-09	AB	Stock	40.05	40.55	39.71	40.03	425700.0
2023-02-09	ABB-DELISTED	Stock	33.99	34.01	33.435	33.53	903638.0
2023-02-09	ABBNY-DELISTED	Stock	33.99	34.01	33.435	33.53	1034858.0
2023-02-09	ABBV	Stock	148.5	153.7	147.9	148.7	12216900.0
2023-02-09	ABC-DELISTED	Stock	157.7	158.1125	154.95	155.06	736062.0
2023-02-09	ABCB	Stock	49.66	49.66	48.32	48.4	217100.0
2023-02-09	ABCL	Stock	10.5	10.59	9.72	9.78	1754200.0
2023-02-09	ABCM-DELISTED	Stock	15.2	15.22	14.51	14.58	140986.0
2023-02-09	ABEO	Stock	2.63	2.71	2.51	2.51	180100.0
2023-02-09	ABEV	Stock	2.49	2.5	2.43	2.45	31123400.0
2023-02-09	ABG	Stock	234.12	236.06	230.36	231.45	179600.0
2023-02-09	ABGI-DELISTED	Stock	10.15	10.16	10.15	10.15	73839.0
2023-02-09	ABLV	Stock	10.26	10.27	10.26	10.27	1325645.0
2023-02-09	ABM	Stock	47.28	47.6	46.33	46.35	173500.0
2023-02-09	ABNB	Stock	118.0	119.28	114.52	114.94	4508700.0
2023-02-09	ABOS	Stock	5.97	5.97	5.81	5.82	24200.0
2023-02-09	ABR	Stock	15.0	15.06	14.34	14.44	2750400.0

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

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