PREVIEW / stock_daily / 2022-10-25

all stock daily files

  file:    by_date/stock_daily/2022/2022-10-25.parquet
  size:    251 KB
  rows:    7,867
  symbols: 2,151

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-10-25	AAPL	Stock	150.09	152.49	149.36	152.34	74732300.0
2022-10-25	MSFT	Stock	247.26	251.04	245.83	250.66	34775500.0
2022-10-25	NVDA	Stock	12.694	13.3	12.664	13.261	505482000.0
2022-10-25	AMZN	Stock	119.65	121.32	118.95	120.6	50934600.0
2022-10-25	GOOGL	Stock	102.9	104.82	102.72	104.48	40611375.0
2022-10-25	META	Stock	130.88	138.35	130.59	137.51	38433200.0
2022-10-25	TSLA	Stock	210.1	224.35	210.0	222.42	96507900.0
2022-10-25	TLT	Stock	94.58	95.225	94.44	95.09	31213113.0
2022-10-25	ES	Stock	72.93	74.21	72.87	74.15	1797400.0
2022-10-25	CL	Stock	72.0	72.95	71.79	72.76	3983300.0
2022-10-25	A	Stock	132.3	135.1	132.3	134.5	1206000.0
2022-10-25	AA	Stock	38.765	42.39	38.44	41.49	8522200.0
2022-10-25	AAC-DELISTED	Stock	9.96	9.97	9.96	9.96	39661.0
2022-10-25	AACG	Stock	1.8	1.82	1.76	1.76	15100.0
2022-10-25	AACIW-DELISTED	Stock	0.08	0.08	0.08	0.08	301.0
2022-10-25	AAIC-DELISTED	Stock	2.8227	2.95	2.8227	2.87	30748.0
2022-10-25	AAIC.C-DELISTED	Stock	19.63	20.4994	19.63	20.4994	900.0
2022-10-25	AAL	Stock	14.05	14.37	13.93	14.29	27677200.0
2022-10-25	AAM.A-DELISTED	Stock	21.53	21.9	21.33	21.56	48322.0
2022-10-25	AAM.B-DELISTED	Stock	21.45	22.63	21.45	22.15	36121.0
2022-10-25	AAMC-DELISTED	Stock	4.0882	4.25	4.0882	4.1176	13199.0
2022-10-25	AAME	Stock	2.85	2.86	2.85	2.86	2400.0
2022-10-25	AAMI	Stock	17.57	18.42	17.57	18.41	225300.0
2022-10-25	AAN-DELISTED	Stock	9.28	10.5	9.27	10.29	2372000.0
2022-10-25	AAOI	Stock	2.73	2.96	2.73	2.86	239100.0
2022-10-25	AAON	Stock	39.2733	41.3533	39.2733	41.14	234150.0
2022-10-25	AAP	Stock	177.05	181.85	175.14	181.4	709500.0
2022-10-25	AAQC-DELISTED	Stock	9.89	9.91	9.89	9.91	40926.0
2022-10-25	AAT	Stock	26.77	28.02	26.77	27.63	359200.0
2022-10-25	AATC	Stock	4.37	4.39	4.25	4.25	8032.0
2022-10-25	AAU-DELISTED	Stock	0.2123	0.2375	0.2123	0.2351	542561.0
2022-10-25	AAUAF-DELISTED	Stock	0.2123	0.2375	0.2123	0.2351	557082.0
2022-10-25	AAWW-DELISTED	Stock	100.72	100.95	100.51	100.55	377291.0
2022-10-25	AAXJ	Stock	55.22	55.76	55.22	55.71	1373229.0
2022-10-25	AB	Stock	34.89	35.65	34.89	35.59	219500.0
2022-10-25	ABB-DELISTED	Stock	27.35	28.015	27.35	27.995	1836053.0
2022-10-25	ABBNY-DELISTED	Stock	27.35	28.015	27.35	28.0	2014779.0
2022-10-25	ABBV	Stock	148.03	150.6	147.29	149.82	5229400.0
2022-10-25	ABC-DELISTED	Stock	149.04	152.89	148.805	152.79	757613.0
2022-10-25	ABCB	Stock	49.66	51.32	49.46	50.8	429000.0
2022-10-25	ABCL	Stock	10.36	10.93	10.35	10.73	2064500.0
2022-10-25	ABCM-DELISTED	Stock	14.41	14.98	14.41	14.98	119975.0
2022-10-25	ABEO	Stock	3.82	4.47	3.81	4.18	428100.0
2022-10-25	ABEV	Stock	2.79	2.81	2.76	2.77	31908800.0
2022-10-25	ABG	Stock	149.39	155.0	148.57	154.15	305100.0
2022-10-25	ABM	Stock	42.21	43.47	41.97	43.12	190500.0
2022-10-25	ABMD-DELISTED	Stock	261.1	266.67	261.1	264.32	136042.0
2022-10-25	ABNB	Stock	115.37	119.38	112.63	118.45	6278900.0
2022-10-25	ABOS	Stock	7.51	7.68	7.21	7.27	106800.0
2022-10-25	ABR	Stock	12.55	13.21	12.48	13.07	1871100.0

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

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