PREVIEW / stock_daily / 2022-05-25

all stock daily files

  file:    by_date/stock_daily/2022/2022-05-25.parquet
  size:    254 KB
  rows:    7,895
  symbols: 2,338

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
2022-05-25	AAPL	Stock	138.43	141.79	138.34	140.52	92482700.0
2022-05-25	MSFT	Stock	258.14	264.58	257.13	262.52	28547900.0
2022-05-25	NVDA	Stock	16.02	17.111	16.0	16.975	781132000.0
2022-05-25	AMZN	Stock	103.6555	108.175	103.65	106.775	93120000.0
2022-05-25	GOOGL	Stock	104.9855	106.5	103.8565	105.805	40257340.0
2022-05-25	META	Stock	180.4	185.45	179.32	183.83	28030200.0
2022-05-25	TSLA	Stock	207.95	223.1067	207.67	219.6	92139300.0
2022-05-25	TLT	Stock	119.61	119.62	118.59	119.33	14410842.0
2022-05-25	ES	Stock	92.81	92.96	91.89	92.15	1455000.0
2022-05-25	CL	Stock	77.31	77.93	76.87	77.49	3733900.0
2022-05-25	A	Stock	127.21	127.46	119.18	120.38	3524500.0
2022-05-25	AA	Stock	60.03	61.459	58.88	60.94	6188500.0
2022-05-25	AAC-DELISTED	Stock	9.8	9.805	9.8	9.8	853195.0
2022-05-25	AACG	Stock	1.01	1.01	0.97	0.97	23900.0
2022-05-25	AAIC-DELISTED	Stock	3.41	3.49	3.41	3.44	20639.0
2022-05-25	AAIC.C-DELISTED	Stock	22.84	22.9	22.7047	22.85	5111.0
2022-05-25	AAL	Stock	15.44	16.18	15.41	16.13	31846900.0
2022-05-25	AAM.A-DELISTED	Stock	24.21	24.6199	24.21	24.5	80649.0
2022-05-25	AAM.B-DELISTED	Stock	24.82	25.24	24.82	25.2302	11864.0
2022-05-25	AAMC-DELISTED	Stock	2.9509	2.9509	2.9509	2.9509	1459.0
2022-05-25	AAME	Stock	2.68	2.81	2.68	2.76	7500.0
2022-05-25	AAMI	Stock	19.27	19.81	19.24	19.63	274900.0
2022-05-25	AAN-DELISTED	Stock	17.51	18.925	17.38	18.52	341800.0
2022-05-25	AAOI	Stock	2.12	2.195	2.12	2.19	74300.0
2022-05-25	AAON	Stock	34.14	34.9267	33.9467	34.5333	181800.0
2022-05-25	AAP	Stock	177.61	187.26	177.23	185.31	1493100.0
2022-05-25	AAT	Stock	32.63	33.27	32.58	33.05	145000.0
2022-05-25	AATC	Stock	5.5001	5.6	5.5	5.51	6221.0
2022-05-25	AAU-DELISTED	Stock	0.22	0.35	0.22	0.2432	2208160.0
2022-05-25	AAUAF-DELISTED	Stock	0.22	0.35	0.22	0.24	2219986.0
2022-05-25	AAWW-DELISTED	Stock	65.9	67.7	65.61	66.93	159413.0
2022-05-25	AAXJ	Stock	68.15	68.7416	67.99	68.59	1057493.0
2022-05-25	AB	Stock	39.46	41.35	39.42	41.05	413800.0
2022-05-25	ABB-DELISTED	Stock	29.83	29.96	29.475	29.78	2465170.0
2022-05-25	ABBNY-DELISTED	Stock	29.83	29.96	29.475	29.78	2690995.0
2022-05-25	ABBV	Stock	150.36	152.99	149.79	151.96	5042600.0
2022-05-25	ABC-DELISTED	Stock	152.69	155.01	151.85	154.34	922284.0
2022-05-25	ABCB	Stock	43.71	44.57	43.51	44.13	246600.0
2022-05-25	ABCL	Stock	7.22	7.54	7.22	7.5	937400.0
2022-05-25	ABCM-DELISTED	Stock	14.09	14.37	14.07	14.25	81667.0
2022-05-25	ABEO	Stock	3.75	4.0	3.75	3.75	28028.0
2022-05-25	ABEV	Stock	2.85	2.9	2.83	2.87	34872600.0
2022-05-25	ABG	Stock	166.27	179.5	166.27	177.96	198700.0
2022-05-25	ABM	Stock	46.56	47.85	46.56	47.22	251600.0
2022-05-25	ABMD-DELISTED	Stock	247.85	255.48	244.2	254.41	185657.0
2022-05-25	ABNB	Stock	105.89	111.94	104.97	110.4	6203300.0
2022-05-25	ABOS	Stock	3.36	3.49	3.36	3.45	89800.0
2022-05-25	ABR	Stock	16.15	16.36	16.04	16.11	2146800.0
2022-05-25	ABR.D	Stock	20.866	21.0173	20.56	21.0173	19029.0
2022-05-25	ABR.E	Stock	20.9	20.95	20.7562	20.9082	2084.0

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

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