PREVIEW / stock_daily / 2023-04-05

all stock daily files

  file:    by_date/stock_daily/2023/2023-04-05.parquet
  size:    243 KB
  rows:    7,545
  symbols: 1,697

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-04-05	AAPL	Stock	164.74	165.05	161.8	163.76	51511700.0
2023-04-05	MSFT	Stock	285.85	287.15	282.92	284.34	22064800.0
2023-04-05	NVDA	Stock	26.829	26.998	26.395	26.881	515015000.0
2023-04-05	AMZN	Stock	103.91	103.91	100.75	101.1	45175400.0
2023-04-05	GOOGL	Stock	105.78	106.1	103.66	104.47	28290503.0
2023-04-05	META	Stock	214.15	215.19	209.94	211.48	19396600.0
2023-04-05	TSLA	Stock	190.52	190.68	183.76	185.52	133882500.0
2023-04-05	TLT	Stock	107.77	108.37	107.41	108.25	23047703.0
2023-04-05	ES	Stock	78.56	80.72	78.42	80.52	1808900.0
2023-04-05	CL	Stock	75.33	76.09	75.32	75.36	4949500.0
2023-04-05	A	Stock	137.74	139.27	136.67	138.09	2312100.0
2023-04-05	AA	Stock	39.82	40.19	38.72	39.43	4251000.0
2023-04-05	AAC-DELISTED	Stock	10.33	10.34	10.32	10.325	66101.0
2023-04-05	AACG	Stock	1.9	1.9	1.84	1.87	8700.0
2023-04-05	AACIW-DELISTED	Stock	0.1075	0.1079	0.0985	0.1079	360.0
2023-04-05	AAIC-DELISTED	Stock	2.75	2.85	2.7	2.82	148785.0
2023-04-05	AAIC.C-DELISTED	Stock	21.25	21.74	21.25	21.73	1390.0
2023-04-05	AAL	Stock	14.06	14.14	13.7	13.89	19213300.0
2023-04-05	AAM.A-DELISTED	Stock	21.57	22.48	21.2667	22.335	19950.0
2023-04-05	AAM.B-DELISTED	Stock	22.4489	22.86	21.8289	22.595	9568.0
2023-04-05	AAMC-DELISTED	Stock	20.0794	20.4118	18.6235	18.6647	63407.0
2023-04-05	AAME	Stock	2.49	2.49	2.43	2.48	5700.0
2023-04-05	AAMI	Stock	22.14	22.27	21.89	21.99	137800.0
2023-04-05	AAN-DELISTED	Stock	9.51	9.68	9.42	9.54	232900.0
2023-04-05	AAOI	Stock	2.21	2.21	2.028	2.11	129400.0
2023-04-05	AAON	Stock	62.1533	62.8	60.6667	61.8667	640950.0
2023-04-05	AAP	Stock	121.0	121.56	119.58	120.21	896500.0
2023-04-05	AAT	Stock	18.0	18.49	17.93	18.45	659500.0
2023-04-05	AATC	Stock	4.0	4.0	3.93	3.93	2365.0
2023-04-05	AAU-DELISTED	Stock	0.202	0.2089	0.1915	0.1955	230151.0
2023-04-05	AAUAF-DELISTED	Stock	0.202	0.2089	0.1915	0.1955	232388.0
2023-04-05	AAXJ	Stock	67.88	67.985	67.27	67.49	253706.0
2023-04-05	AB	Stock	34.47	34.7	33.9	34.12	171300.0
2023-04-05	ABB-DELISTED	Stock	33.39	33.45	32.95	33.11	1496989.0
2023-04-05	ABBNY-DELISTED	Stock	33.39	33.45	32.95	33.11	1690619.0
2023-04-05	ABBV	Stock	160.0	161.67	159.01	160.8	5743000.0
2023-04-05	ABC-DELISTED	Stock	163.97	167.9219	163.655	167.36	959590.0
2023-04-05	ABCB	Stock	34.28	34.54	33.35	33.59	617100.0
2023-04-05	ABCL	Stock	7.19	7.3	7.1	7.15	1130000.0
2023-04-05	ABCM-DELISTED	Stock	12.74	12.895	12.52	12.6	319207.0
2023-04-05	ABEO	Stock	2.78	2.84	2.75	2.81	47300.0
2023-04-05	ABEV	Stock	2.85	2.87	2.78	2.82	16550000.0
2023-04-05	ABG	Stock	200.8	201.0	192.5	194.67	192000.0
2023-04-05	ABM	Stock	42.98	43.38	42.93	43.35	245200.0
2023-04-05	ABNB	Stock	117.87	117.87	111.49	115.34	6737000.0
2023-04-05	ABOS	Stock	3.88	3.99	3.8	3.82	91300.0
2023-04-05	ABR	Stock	11.12	11.29	11.05	11.21	2618900.0
2023-04-05	ABR.D	Stock	18.13	18.13	17.8993	18.0	25185.0
2023-04-05	ABR.E	Stock	17.66	17.75	17.5	17.5	11284.0
2023-04-05	ABR.F	Stock	17.89	17.94	17.75	17.75	39583.0

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

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