PREVIEW / stock_daily / 2021-11-26

all stock daily files

  file:    by_date/stock_daily/2021/2021-11-26.parquet
  size:    256 KB
  rows:    7,892
  symbols: 2,584

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
2021-11-26	AAPL	Stock	159.57	160.45	156.36	156.81	76959800.0
2021-11-26	MSFT	Stock	334.35	337.93	328.12	329.68	24217200.0
2021-11-26	NVDA	Stock	32.6	32.71	31.35	31.503	283069000.0
2021-11-26	AMZN	Stock	180.105	181.675	175.2075	175.228	59826000.0
2021-11-26	GOOGL	Stock	144.3485	144.5575	141.8425	142.183	30469240.0
2021-11-26	META	Stock	335.8	337.75	331.9	333.12	14750700.0
2021-11-26	TSLA	Stock	366.49	369.5933	360.3333	360.64	35042700.0
2021-11-26	TLT	Stock	148.83	150.68	148.67	150.53	20064778.0
2021-11-26	ES	Stock	84.56	85.38	84.41	84.72	964100.0
2021-11-26	CL	Stock	77.78	78.6	76.96	77.06	2439900.0
2021-11-26	A	Stock	153.29	159.09	151.57	152.07	1632200.0
2021-11-26	AA	Stock	47.74	48.14	45.82	47.95	7291200.0
2021-11-26	AAC-DELISTED	Stock	9.78	9.8201	9.78	9.8	275880.0
2021-11-26	AACG	Stock	1.73	1.75	1.7	1.72	16900.0
2021-11-26	AACIU	Stock	10.53	10.53	10.03	10.03	400.0
2021-11-26	AACIW-DELISTED	Stock	0.51	0.5101	0.5001	0.5001	5050.0
2021-11-26	AAIC-DELISTED	Stock	3.75	3.78	3.675	3.71	91403.0
2021-11-26	AAIC.C-DELISTED	Stock	25.9	25.91	25.85	25.85	1000.0
2021-11-26	AAL	Stock	18.27	18.27	16.9	17.75	84177500.0
2021-11-26	AAM.A-DELISTED	Stock	25.54	25.59	25.42	25.59	14454.0
2021-11-26	AAM.B-DELISTED	Stock	26.66	26.66	26.36	26.59	4637.0
2021-11-26	AAMC-DELISTED	Stock	5.5912	5.9176	5.3265	5.3265	53186.0
2021-11-26	AAME	Stock	4.03	4.05	3.9	3.97	5800.0
2021-11-26	AAMI	Stock	30.2	30.31	29.8	30.15	1071100.0
2021-11-26	AAN-DELISTED	Stock	24.02	24.44	23.55	24.06	192400.0
2021-11-26	AAOI	Stock	5.94	6.08	5.89	6.03	282200.0
2021-11-26	AAON	Stock	51.2933	52.1533	51.1867	52.06	588450.0
2021-11-26	AAP	Stock	229.42	229.57	225.07	226.73	334100.0
2021-11-26	AAQC-DELISTED	Stock	9.72	9.73	9.71	9.72	14674.0
2021-11-26	AAT	Stock	37.03	37.33	35.21	36.01	157900.0
2021-11-26	AATC	Stock	6.68	6.9843	6.68	6.94	18135.0
2021-11-26	AAU-DELISTED	Stock	0.335	0.34	0.322	0.34	815805.0
2021-11-26	AAUAF-DELISTED	Stock	0.335	0.34	0.322	0.34	820193.0
2021-11-26	AAWW-DELISTED	Stock	91.0	92.94	90.23	92.31	201487.0
2021-11-26	AAXJ	Stock	83.825	83.9	82.955	83.39	1817256.0
2021-11-26	AB	Stock	54.11	54.89	53.3	54.18	194200.0
2021-11-26	ABB-DELISTED	Stock	34.28	34.435	34.04	34.19	968113.0
2021-11-26	ABBNY-DELISTED	Stock	34.28	34.435	34.04	34.19	1080298.0
2021-11-26	ABBV	Stock	117.61	118.11	115.83	116.51	5016700.0
2021-11-26	ABC-DELISTED	Stock	121.92	123.64	119.93	123.05	447526.0
2021-11-26	ABCB	Stock	51.08	51.49	48.98	50.06	258200.0
2021-11-26	ABCL	Stock	14.45	14.47	13.75	13.99	1096100.0
2021-11-26	ABCM-DELISTED	Stock	22.48	22.64	22.28	22.45	19212.0
2021-11-26	ABEO	Stock	18.75	19.0	17.75	18.25	28944.0
2021-11-26	ABEV	Stock	2.97	2.99	2.93	2.95	17163000.0
2021-11-26	ABG	Stock	156.82	162.11	156.82	159.79	245800.0
2021-11-26	ABGI-DELISTED	Stock	9.75	9.82	9.75	9.79	1628.0
2021-11-26	ABM	Stock	46.93	47.52	45.95	46.53	218900.0
2021-11-26	ABMD-DELISTED	Stock	338.52	346.71	324.9	325.98	112117.0
2021-11-26	ABNB	Stock	167.76	174.64	167.04	173.86	6044100.0

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

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