PREVIEW / stock_daily / 2022-10-31

all stock daily files

  file:    by_date/stock_daily/2022/2022-10-31.parquet
  size:    252 KB
  rows:    7,859
  symbols: 2,122

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-31	AAPL	Stock	153.16	154.24	151.92	153.34	97943200.0
2022-10-31	MSFT	Stock	233.76	234.92	231.15	232.13	28357300.0
2022-10-31	NVDA	Stock	13.778	13.838	13.297	13.497	486341000.0
2022-10-31	AMZN	Stock	103.56	104.87	100.74	102.44	99251400.0
2022-10-31	GOOGL	Stock	95.42	96.03	93.98	94.51	31675036.0
2022-10-31	META	Stock	98.22	99.32	92.6	93.16	121361400.0
2022-10-31	TSLA	Stock	226.19	229.85	221.94	227.54	61554300.0
2022-10-31	TLT	Stock	96.36	96.62	95.03	96.11	23956687.0
2022-10-31	ES	Stock	76.46	76.92	75.82	76.28	2348000.0
2022-10-31	CL	Stock	74.61	75.1	73.57	73.84	6690600.0
2022-10-31	A	Stock	137.69	138.93	137.35	138.35	1307600.0
2022-10-31	AA	Stock	38.86	40.03	38.82	39.03	5388700.0
2022-10-31	AAC-DELISTED	Stock	9.97	9.9779	9.97	9.975	20289.0
2022-10-31	AACG	Stock	1.78	1.86	1.78	1.86	5900.0
2022-10-31	AACIW-DELISTED	Stock	0.12	0.12	0.05	0.05	16902.0
2022-10-31	AAIC-DELISTED	Stock	3.03	3.03	2.99	3.03	67478.0
2022-10-31	AAIC.C-DELISTED	Stock	19.7418	19.9402	19.7418	19.928	613.0
2022-10-31	AAL	Stock	14.03	14.32	13.89	14.18	26486700.0
2022-10-31	AAM.A-DELISTED	Stock	22.17	22.33	21.62	21.75	78657.0
2022-10-31	AAM.B-DELISTED	Stock	22.32	22.69	21.6	21.6	51091.0
2022-10-31	AAMC-DELISTED	Stock	4.4118	4.6765	4.2647	4.3706	8476.0
2022-10-31	AAME	Stock	2.91	3.01	2.86	2.87	1400.0
2022-10-31	AAMI	Stock	18.58	18.94	18.555	18.82	161000.0
2022-10-31	AAN-DELISTED	Stock	10.22	10.57	10.18	10.42	472400.0
2022-10-31	AAOI	Stock	2.79	2.83	2.71	2.75	175000.0
2022-10-31	AAON	Stock	42.92	43.3267	41.7667	42.9933	222900.0
2022-10-31	AAP	Stock	190.61	192.81	189.46	189.92	704900.0
2022-10-31	AAQC-DELISTED	Stock	9.94	9.94	9.92	9.94	55561.0
2022-10-31	AAT	Stock	27.3	27.48	27.1	27.48	475700.0
2022-10-31	AATC	Stock	4.4	4.4	4.26	4.26	3988.0
2022-10-31	AAU-DELISTED	Stock	0.2381	0.2394	0.2126	0.2181	4728700.0
2022-10-31	AAUAF-DELISTED	Stock	0.2381	0.2394	0.212	0.212	4759344.0
2022-10-31	AAWW-DELISTED	Stock	101.0	101.25	100.8	101.12	388698.0
2022-10-31	AAXJ	Stock	55.22	55.68	55.19	55.51	869533.0
2022-10-31	AB	Stock	37.13	38.53	37.13	37.63	476200.0
2022-10-31	ABB-DELISTED	Stock	27.7	27.9362	27.64	27.83	1237668.0
2022-10-31	ABBNY-DELISTED	Stock	27.7	27.9362	27.64	27.84	1362848.0
2022-10-31	ABBV	Stock	145.17	146.78	144.08	146.4	8604800.0
2022-10-31	ABC-DELISTED	Stock	158.38	159.45	156.41	157.26	662366.0
2022-10-31	ABCB	Stock	50.49	51.95	50.29	51.51	701400.0
2022-10-31	ABCL	Stock	11.63	12.07	11.623	11.83	2244100.0
2022-10-31	ABCM-DELISTED	Stock	15.61	15.85	15.46	15.565	275851.0
2022-10-31	ABEO	Stock	4.4	4.68	4.4	4.59	333500.0
2022-10-31	ABEV	Stock	2.93	3.05	2.92	3.04	43040400.0
2022-10-31	ABG	Stock	156.29	159.6	155.73	157.75	323000.0
2022-10-31	ABGI-DELISTED	Stock	9.96	9.97	9.96	9.97	3607.0
2022-10-31	ABM	Stock	44.74	45.24	44.42	44.51	562600.0
2022-10-31	ABMD-DELISTED	Stock	257.39	257.39	245.17	251.95	440544.0
2022-10-31	ABNB	Stock	113.06	113.8	106.67	106.91	10733800.0
2022-10-31	ABOS	Stock	7.12	7.45	6.82	6.92	261500.0

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

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