PREVIEW / stock_daily / 2022-10-17

all stock daily files

  file:    by_date/stock_daily/2022/2022-10-17.parquet
  size:    251 KB
  rows:    7,845
  symbols: 2,158

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-17	AAPL	Stock	141.07	142.9	140.27	142.41	85250900.0
2022-10-17	MSFT	Stock	235.82	238.96	235.14	237.53	28142300.0
2022-10-17	NVDA	Stock	11.518	11.948	11.517	11.888	580774000.0
2022-10-17	AMZN	Stock	110.11	114.19	110.09	113.79	62782000.0
2022-10-17	GOOGL	Stock	98.86	100.93	98.83	99.97	28419192.0
2022-10-17	META	Stock	130.3	134.79	130.18	134.04	29612200.0
2022-10-17	TSLA	Stock	210.04	221.86	209.45	219.35	79428800.0
2022-10-17	TLT	Stock	99.29	99.66	97.94	98.09	18969871.0
2022-10-17	ES	Stock	73.53	74.61	73.53	73.87	2453200.0
2022-10-17	CL	Stock	71.54	72.71	71.27	72.14	4118000.0
2022-10-17	A	Stock	127.38	131.09	127.38	130.56	1197900.0
2022-10-17	AA	Stock	39.45	40.29	38.4	39.38	5538000.0
2022-10-17	AAC-DELISTED	Stock	9.94	9.95	9.94	9.95	10742.0
2022-10-17	AACG	Stock	1.85	1.85	1.83	1.84	5100.0
2022-10-17	AAIC-DELISTED	Stock	2.81	2.88	2.78	2.8	9329.0
2022-10-17	AAIC.C-DELISTED	Stock	19.4	19.48	19.368	19.368	1247.0
2022-10-17	AAL	Stock	13.53	13.59	12.92	13.2	39973800.0
2022-10-17	AAM.A-DELISTED	Stock	23.38	23.38	22.7721	22.9806	8017.0
2022-10-17	AAM.B-DELISTED	Stock	22.7	23.02	22.7	22.9	8167.0
2022-10-17	AAME	Stock	2.85	2.85	2.7	2.7	2700.0
2022-10-17	AAMI	Stock	17.94	18.095	17.3	17.61	327900.0
2022-10-17	AAN-DELISTED	Stock	9.11	9.23	8.98	9.08	302100.0
2022-10-17	AAOI	Stock	2.73	2.91	2.73	2.8	204200.0
2022-10-17	AAON	Stock	36.56	37.2867	36.56	37.0667	217200.0
2022-10-17	AAP	Stock	170.7	172.15	169.11	169.86	979900.0
2022-10-17	AAQC-DELISTED	Stock	9.88	9.88	9.86	9.87	35234.0
2022-10-17	AAT	Stock	25.4	26.21	25.4	26.01	304200.0
2022-10-17	AATC	Stock	4.32	4.4299	4.19	4.387	6371.0
2022-10-17	AAU-DELISTED	Stock	0.22	0.2388	0.22	0.237	215100.0
2022-10-17	AAUAF-DELISTED	Stock	0.22	0.2388	0.22	0.237	216027.0
2022-10-17	AAWW-DELISTED	Stock	99.87	100.21	99.685	99.87	153872.0
2022-10-17	AAXJ	Stock	57.9	58.5	57.83	58.29	777336.0
2022-10-17	AB	Stock	33.31	34.43	32.86	34.23	388500.0
2022-10-17	ABB-DELISTED	Stock	26.13	26.35	26.06	26.09	1990614.0
2022-10-17	ABBNY-DELISTED	Stock	26.13	26.35	26.06	26.09	2182513.0
2022-10-17	ABBV	Stock	142.65	144.93	142.1	144.41	4016200.0
2022-10-17	ABC-DELISTED	Stock	141.45	143.48	141.45	142.41	612974.0
2022-10-17	ABCB	Stock	50.3	50.99	49.49	50.4	409000.0
2022-10-17	ABCL	Stock	10.58	10.89	10.49	10.64	898500.0
2022-10-17	ABCM-DELISTED	Stock	15.18	15.45	15.14	15.31	102675.0
2022-10-17	ABEO	Stock	4.3	4.51	3.96	4.04	565400.0
2022-10-17	ABEV	Stock	2.77	2.82	2.76	2.79	15363100.0
2022-10-17	ABG	Stock	158.83	159.4	154.71	156.9	254600.0
2022-10-17	ABGI-DELISTED	Stock	9.93	9.95	9.93	9.93	603.0
2022-10-17	ABM	Stock	40.37	41.17	40.37	40.89	239800.0
2022-10-17	ABMD-DELISTED	Stock	255.74	258.79	251.465	258.05	148848.0
2022-10-17	ABNB	Stock	112.33	116.76	111.03	116.5	5423900.0
2022-10-17	ABOS	Stock	7.99	8.3	7.92	7.97	270800.0
2022-10-17	ABR	Stock	12.3	12.6	12.2	12.33	2812300.0
2022-10-17	ABR.D	Stock	17.97	17.97	17.1	17.58	54825.0

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

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