PREVIEW / stock_daily / 2022-10-26

all stock daily files

  file:    by_date/stock_daily/2022/2022-10-26.parquet
  size:    253 KB
  rows:    7,898
  symbols: 2,168

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-26	AAPL	Stock	150.96	151.99	148.04	149.35	88194300.0
2022-10-26	MSFT	Stock	231.17	238.3	230.06	231.32	82543200.0
2022-10-26	NVDA	Stock	12.869	13.388	12.708	12.896	532953000.0
2022-10-26	AMZN	Stock	116.0	119.35	114.76	115.66	68802300.0
2022-10-26	GOOGL	Stock	96.43	98.31	94.69	94.93	88279042.0
2022-10-26	META	Stock	131.68	135.55	128.53	129.82	82791500.0
2022-10-26	TSLA	Stock	219.4	230.6	218.2	224.64	85012500.0
2022-10-26	TLT	Stock	95.77	96.69	95.765	96.46	24854742.0
2022-10-26	ES	Stock	74.63	75.16	73.53	74.03	1714100.0
2022-10-26	CL	Stock	73.01	73.66	72.51	73.43	3624800.0
2022-10-26	A	Stock	134.43	139.31	134.0	137.69	1381900.0
2022-10-26	AA	Stock	42.09	43.08	41.28	42.65	6082400.0
2022-10-26	AAC-DELISTED	Stock	9.98	9.98	9.97	9.975	7541.0
2022-10-26	AACG	Stock	1.79	1.81	1.77	1.8	17900.0
2022-10-26	AACIW-DELISTED	Stock	0.05	0.05	0.04	0.04	3101.0
2022-10-26	AAIC-DELISTED	Stock	2.85	2.96	2.82	2.93	46864.0
2022-10-26	AAIC.C-DELISTED	Stock	20.0	20.0	19.54	20.0	4957.0
2022-10-26	AAL	Stock	14.14	14.44	13.99	14.0	28273700.0
2022-10-26	AAM.A-DELISTED	Stock	21.58	21.97	21.265	21.52	35207.0
2022-10-26	AAM.B-DELISTED	Stock	22.07	22.71	21.79	22.4006	8566.0
2022-10-26	AAMC-DELISTED	Stock	4.0971	4.0971	4.0971	4.0971	1459.0
2022-10-26	AAME	Stock	2.92	3.0	2.76	3.0	4100.0
2022-10-26	AAMI	Stock	18.47	18.7	18.31	18.37	120200.0
2022-10-26	AAN-DELISTED	Stock	10.24	10.83	9.89	9.89	1517600.0
2022-10-26	AAOI	Stock	2.83	2.955	2.83	2.89	149300.0
2022-10-26	AAON	Stock	40.9333	42.0333	40.7667	40.9067	178650.0
2022-10-26	AAP	Stock	182.28	183.9	179.54	181.81	573200.0
2022-10-26	AAQC-DELISTED	Stock	9.92	9.93	9.92	9.93	6900.0
2022-10-26	AAT	Stock	28.41	28.91	27.23	27.64	428300.0
2022-10-26	AATC	Stock	4.4255	4.4831	4.37	4.4229	1800.0
2022-10-26	AAU-DELISTED	Stock	0.235	0.2388	0.2202	0.235	508419.0
2022-10-26	AAUAF-DELISTED	Stock	0.235	0.2388	0.2202	0.235	512577.0
2022-10-26	AAWW-DELISTED	Stock	100.84	101.25	100.67	100.705	381310.0
2022-10-26	AAXJ	Stock	55.99	57.34	55.911	56.9	659143.0
2022-10-26	AB	Stock	35.68	36.42	35.68	35.79	271600.0
2022-10-26	ABB-DELISTED	Stock	28.11	28.475	28.03	28.26	1329479.0
2022-10-26	ABBNY-DELISTED	Stock	28.11	28.475	28.03	28.27	1474961.0
2022-10-26	ABBV	Stock	151.01	152.89	150.7	152.51	4727900.0
2022-10-26	ABC-DELISTED	Stock	153.97	155.35	153.47	154.79	554546.0
2022-10-26	ABCB	Stock	51.15	51.53	50.45	51.16	392400.0
2022-10-26	ABCL	Stock	10.76	11.05	10.46	10.82	1850800.0
2022-10-26	ABCM-DELISTED	Stock	15.05	15.79	15.01	15.68	243960.0
2022-10-26	ABEO	Stock	4.35	4.68	4.17	4.33	374900.0
2022-10-26	ABEV	Stock	2.75	2.8	2.74	2.8	31789600.0
2022-10-26	ABG	Stock	156.7	159.83	152.09	154.61	186200.0
2022-10-26	ABGI-DELISTED	Stock	9.95	9.95	9.95	9.95	125000.0
2022-10-26	ABM	Stock	43.6	44.66	43.44	43.86	242500.0
2022-10-26	ABMD-DELISTED	Stock	265.33	274.955	264.79	268.26	101754.0
2022-10-26	ABNB	Stock	117.0	119.91	114.97	115.31	4263100.0
2022-10-26	ABOS	Stock	7.55	7.9	7.425	7.45	166600.0

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

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