PREVIEW / stock_daily / 2023-03-10

all stock daily files

  file:    by_date/stock_daily/2023/2023-03-10.parquet
  size:    247 KB
  rows:    7,624
  symbols: 1,784

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-03-10	AAPL	Stock	150.21	150.94	147.61	148.5	68572400.0
2023-03-10	MSFT	Stock	251.08	252.79	247.6	248.59	28333900.0
2023-03-10	NVDA	Stock	23.409	23.627	22.726	22.965	474866000.0
2023-03-10	AMZN	Stock	92.67	93.57	90.25	90.73	69827500.0
2023-03-10	GOOGL	Stock	92.17	92.79	90.395	90.63	35941046.0
2023-03-10	META	Stock	181.01	184.77	178.8	179.51	25665000.0
2023-03-10	TSLA	Stock	175.13	178.29	168.44	173.44	191488900.0
2023-03-10	TLT	Stock	104.03	105.6939	104.0	105.59	43921484.0
2023-03-10	ES	Stock	74.44	74.58	72.46	72.88	1631000.0
2023-03-10	CL	Stock	71.73	71.78	71.19	71.31	3694600.0
2023-03-10	A	Stock	139.19	139.44	134.71	135.72	1896000.0
2023-03-10	AA	Stock	48.12	48.12	44.46	44.91	6195500.0
2023-03-10	AAC-DELISTED	Stock	10.28	10.3	10.25	10.25	138675.0
2023-03-10	AACG	Stock	2.48	2.48	2.0	2.0	38000.0
2023-03-10	AACIW-DELISTED	Stock	0.11	0.11	0.1	0.1	2700.0
2023-03-10	AAIC-DELISTED	Stock	2.93	2.96	2.81	2.83	90817.0
2023-03-10	AAIC.C-DELISTED	Stock	21.51	21.51	21.0	21.2535	3075.0
2023-03-10	AAL	Stock	15.98	16.0	15.11	15.46	27280200.0
2023-03-10	AAM.A-DELISTED	Stock	22.1	22.92	21.775	21.99	26279.0
2023-03-10	AAM.B-DELISTED	Stock	23.39	23.5	21.42	21.9999	24845.0
2023-03-10	AAMC-DELISTED	Stock	17.3206	17.9412	16.5382	17.6059	113771.0
2023-03-10	AAME	Stock	2.34	2.37	2.34	2.37	1000.0
2023-03-10	AAMI	Stock	24.02	24.27	22.93	23.06	125100.0
2023-03-10	AAN-DELISTED	Stock	11.47	11.47	10.94	11.16	260100.0
2023-03-10	AAOI	Stock	2.8	2.83	2.66	2.66	222900.0
2023-03-10	AAON	Stock	61.12	61.34	59.3	60.32	346650.0
2023-03-10	AAP	Stock	129.12	130.54	127.48	128.04	1419000.0
2023-03-10	AAT	Stock	21.21	21.5	19.55	19.79	1393100.0
2023-03-10	AATC	Stock	4.191	4.235	4.16	4.16	3696.0
2023-03-10	AAU-DELISTED	Stock	0.19	0.2029	0.19	0.195	217114.0
2023-03-10	AAUAF-DELISTED	Stock	0.19	0.2029	0.19	0.195	218594.0
2023-03-10	AAWW-DELISTED	Stock	100.48	100.48	99.6675	99.86	292017.0
2023-03-10	AAXJ	Stock	64.77	65.22	64.55	64.61	737765.0
2023-03-10	AB	Stock	36.5	37.49	35.61	36.87	372600.0
2023-03-10	ABB-DELISTED	Stock	34.05	34.06	33.09	33.145	1585788.0
2023-03-10	ABBNY-DELISTED	Stock	34.05	34.06	33.09	33.14	1758011.0
2023-03-10	ABBV	Stock	147.84	150.64	147.47	149.71	6825500.0
2023-03-10	ABC-DELISTED	Stock	150.26	152.67	149.09	149.59	662653.0
2023-03-10	ABCB	Stock	41.53	42.9	39.63	42.45	1230800.0
2023-03-10	ABCL	Stock	7.94	7.94	7.33	7.55	3242100.0
2023-03-10	ABCM-DELISTED	Stock	14.66	14.6673	13.5	13.84	714477.0
2023-03-10	ABEO	Stock	2.8	2.88	2.62	2.69	261500.0
2023-03-10	ABEV	Stock	2.59	2.64	2.57	2.58	13539500.0
2023-03-10	ABG	Stock	232.49	232.49	223.37	225.24	287500.0
2023-03-10	ABM	Stock	45.86	45.86	44.55	44.75	488500.0
2023-03-10	ABNB	Stock	119.735	121.44	115.85	118.3	5254800.0
2023-03-10	ABOS	Stock	5.2	5.2	4.51	4.56	110500.0
2023-03-10	ABR	Stock	13.59	13.65	12.93	13.15	5387200.0
2023-03-10	ABR.D	Stock	18.1	18.29	17.61	17.7587	27734.0
2023-03-10	ABR.E	Stock	18.14	18.26	17.7101	18.228	10276.0

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

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