PREVIEW / stock_daily / 2023-05-25

all stock daily files

  file:    by_date/stock_daily/2023/2023-05-25.parquet
  size:    242 KB
  rows:    7,554
  symbols: 1,662

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-05-25	AAPL	Stock	172.41	173.9	171.69	172.99	56058300.0
2023-05-25	MSFT	Stock	323.24	326.9	320.0	325.92	43301700.0
2023-05-25	NVDA	Stock	38.523	39.48	36.635	37.98	1543911000.0
2023-05-25	AMZN	Stock	116.63	116.87	114.31	115.0	66496700.0
2023-05-25	GOOGL	Stock	124.52	125.32	121.96	123.48	42316986.0
2023-05-25	META	Stock	253.4	255.62	249.17	252.69	22371400.0
2023-05-25	TSLA	Stock	186.54	186.78	180.58	184.47	96870700.0
2023-05-25	TLT	Stock	100.7	100.8	100.03	100.28	22492819.0
2023-05-25	ES	Stock	71.51	71.57	70.42	70.86	1726200.0
2023-05-25	CL	Stock	76.25	76.63	75.54	76.25	6149900.0
2023-05-25	A	Stock	121.41	121.41	117.64	119.49	3218900.0
2023-05-25	AA	Stock	34.21	34.64	33.51	33.79	3906500.0
2023-05-25	AAC-DELISTED	Stock	10.45	10.49	10.45	10.48	21906.0
2023-05-25	AACG	Stock	1.5	1.52	1.48	1.48	12600.0
2023-05-25	AAIC-DELISTED	Stock	2.7	2.75	2.66	2.72	590728.0
2023-05-25	AAIC.C-DELISTED	Stock	21.2073	21.6654	21.0	21.1	3904.0
2023-05-25	AAL	Stock	13.88	14.39	13.8	14.38	29719900.0
2023-05-25	AAM.A-DELISTED	Stock	24.19	24.2	23.66	23.8	5754.0
2023-05-25	AAM.B-DELISTED	Stock	24.07	24.61	23.9	24.595	2249.0
2023-05-25	AAMC-DELISTED	Stock	28.6239	28.85	28.5294	28.5294	5542.0
2023-05-25	AAME	Stock	2.19	2.19	2.15	2.15	800.0
2023-05-25	AAMI	Stock	21.64	21.9	21.33	21.64	94600.0
2023-05-25	AAN-DELISTED	Stock	12.7	12.74	12.25	12.37	103100.0
2023-05-25	AAOI	Stock	1.77	1.78	1.72	1.75	166000.0
2023-05-25	AAON	Stock	58.7133	60.06	58.7133	59.94	267600.0
2023-05-25	AAP	Stock	114.57	114.57	111.35	111.62	1301300.0
2023-05-25	AAT	Stock	18.75	19.0	18.44	18.85	380600.0
2023-05-25	AATC	Stock	4.56	4.815	4.52	4.79	40291.0
2023-05-25	AAU-DELISTED	Stock	0.12	0.1275	0.117	0.1201	328918.0
2023-05-25	AAUAF-DELISTED	Stock	0.12	0.1275	0.117	0.1201	339435.0
2023-05-25	AAXJ	Stock	65.09	65.16	64.79	64.91	1274887.0
2023-05-25	AB	Stock	34.27	34.5	33.21	33.41	265800.0
2023-05-25	ABBNY-DELISTED	Stock	36.63	36.74	36.35	36.58	1881584.0
2023-05-25	ABBV	Stock	140.03	140.2	138.26	138.62	6986600.0
2023-05-25	ABC-DELISTED	Stock	170.07	170.93	168.23	170.18	1189865.0
2023-05-25	ABCB	Stock	32.08	32.4	31.42	32.21	296000.0
2023-05-25	ABCL	Stock	7.01	7.56	6.68	6.91	4177000.0
2023-05-25	ABCM-DELISTED	Stock	16.9	17.01	16.22	16.29	876275.0
2023-05-25	ABEO	Stock	3.3	3.33	3.18	3.21	86500.0
2023-05-25	ABEV	Stock	2.92	2.95	2.9	2.91	18283000.0
2023-05-25	ABG	Stock	203.06	205.65	197.53	201.04	113200.0
2023-05-25	ABLV	Stock	10.5	10.5	10.5	10.5	2500.0
2023-05-25	ABM	Stock	42.59	43.58	42.35	43.08	382600.0
2023-05-25	ABNB	Stock	106.1	106.52	103.74	104.42	4834500.0
2023-05-25	ABOS	Stock	5.23	5.23	4.744	4.85	147700.0
2023-05-25	ABR	Stock	12.22	12.29	11.92	12.24	2392800.0
2023-05-25	ABR.D	Stock	17.24	17.4514	17.24	17.25	2812.0
2023-05-25	ABR.E	Stock	16.78	16.88	16.7001	16.87	1279.0
2023-05-25	ABR.F	Stock	18.03	18.03	17.84	17.91	4901.0
2023-05-25	ABSI	Stock	1.75	1.96	1.57	1.61	1475800.0

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

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