PREVIEW / stock_daily / 2023-02-14

all stock daily files

  file:    by_date/stock_daily/2023/2023-02-14.parquet
  size:    248 KB
  rows:    7,644
  symbols: 1,855

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-14	AAPL	Stock	152.12	153.77	150.86	153.2	61707600.0
2023-02-14	MSFT	Stock	272.67	274.97	269.28	272.17	37047900.0
2023-02-14	NVDA	Stock	21.578	23.049	21.366	22.971	675474000.0
2023-02-14	AMZN	Stock	98.41	100.92	97.52	99.7	56202900.0
2023-02-14	GOOGL	Stock	94.43	94.845	92.26	94.68	54726120.0
2023-02-14	META	Stock	177.16	181.51	175.88	179.48	24034600.0
2023-02-14	TSLA	Stock	191.94	209.82	189.44	209.25	216455700.0
2023-02-14	TLT	Stock	104.2	104.83	103.135	104.02	15440317.0
2023-02-14	ES	Stock	81.23	81.23	78.74	78.89	2182200.0
2023-02-14	CL	Stock	73.91	73.91	72.9	73.18	2382500.0
2023-02-14	A	Stock	154.34	155.75	151.45	153.04	895400.0
2023-02-14	AA	Stock	47.5	49.08	46.94	48.93	4296200.0
2023-02-14	AAC-DELISTED	Stock	10.2	10.22	10.19	10.22	800906.0
2023-02-14	AACG	Stock	1.85	1.85	1.77	1.78	8300.0
2023-02-14	AACIW-DELISTED	Stock	0.1	0.1	0.1	0.1	39725.0
2023-02-14	AAIC-DELISTED	Stock	3.0	3.03	2.99	3.02	94551.0
2023-02-14	AAIC.C-DELISTED	Stock	22.73	22.73	22.5901	22.5901	600.0
2023-02-14	AAL	Stock	16.49	16.85	16.33	16.79	17467900.0
2023-02-14	AAM.A-DELISTED	Stock	24.48	24.81	24.45	24.75	9000.0
2023-02-14	AAM.B-DELISTED	Stock	24.75	24.91	24.62	24.84	10606.0
2023-02-14	AAMC-DELISTED	Stock	11.8235	11.9412	11.3007	11.5441	61506.0
2023-02-14	AAME	Stock	2.35	2.43	2.35	2.39	2000.0
2023-02-14	AAMI	Stock	26.38	26.88	25.67	25.87	300900.0
2023-02-14	AAN-DELISTED	Stock	14.69	15.0	14.65	14.84	171900.0
2023-02-14	AAOI	Stock	2.66	2.712	2.61	2.7	165700.0
2023-02-14	AAON	Stock	51.5933	52.7133	51.2933	52.1667	301650.0
2023-02-14	AAP	Stock	151.92	153.14	150.07	150.76	954500.0
2023-02-14	AAT	Stock	26.33	26.88	26.31	26.4	268900.0
2023-02-14	AATC	Stock	4.39	4.47	4.32	4.33	8022.0
2023-02-14	AAU-DELISTED	Stock	0.2355	0.2355	0.22	0.224	406744.0
2023-02-14	AAUAF-DELISTED	Stock	0.2355	0.2355	0.22	0.224	409123.0
2023-02-14	AAWW-DELISTED	Stock	102.2	102.25	102.2	102.23	154747.0
2023-02-14	AAXJ	Stock	69.35	69.74	68.98	69.53	455978.0
2023-02-14	AB	Stock	40.31	42.0	40.22	41.53	490700.0
2023-02-14	ABB-DELISTED	Stock	33.79	34.1282	33.67	33.81	1880241.0
2023-02-14	ABBNY-DELISTED	Stock	33.79	34.1282	33.67	33.81	2034834.0
2023-02-14	ABBV	Stock	153.92	154.0	151.76	152.59	4662800.0
2023-02-14	ABC-DELISTED	Stock	159.28	160.2225	157.005	157.28	843590.0
2023-02-14	ABCB	Stock	48.73	49.25	47.96	48.48	225100.0
2023-02-14	ABCL	Stock	9.7	10.035	9.658	9.97	1420400.0
2023-02-14	ABCM-DELISTED	Stock	15.18	15.315	14.96	15.11	281587.0
2023-02-14	ABEO	Stock	2.47	2.52	2.37	2.4	83500.0
2023-02-14	ABEV	Stock	2.55	2.56	2.47	2.49	28393100.0
2023-02-14	ABG	Stock	231.73	234.99	230.21	233.19	186200.0
2023-02-14	ABGI-DELISTED	Stock	10.16	10.16	10.16	10.16	509.0
2023-02-14	ABM	Stock	48.35	48.83	48.02	48.73	245900.0
2023-02-14	ABNB	Stock	116.29	121.32	115.2	120.87	17145000.0
2023-02-14	ABOS	Stock	5.51	5.75	5.44	5.47	129700.0
2023-02-14	ABR	Stock	14.95	14.98	14.72	14.89	1312400.0
2023-02-14	ABR.D	Stock	20.71	20.71	20.12	20.12	15866.0

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

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