PREVIEW / stock_daily / 2021-11-17

all stock daily files

  file:    by_date/stock_daily/2021/2021-11-17.parquet
  size:    262 KB
  rows:    8,015
  symbols: 2,677

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-17	AAPL	Stock	151.0	155.0	150.99	153.49	88807000.0
2021-11-17	MSFT	Stock	338.94	342.19	338.0	339.12	19053400.0
2021-11-17	NVDA	Stock	30.418	30.509	28.8	29.261	428508000.0
2021-11-17	AMZN	Stock	178.236	179.3625	177.2675	177.45	51206000.0
2021-11-17	GOOGL	Stock	148.0275	148.5595	147.24	148.047	19599500.0
2021-11-17	META	Stock	344.24	347.3	340.1	340.77	13602800.0
2021-11-17	TSLA	Stock	354.5033	373.2133	351.8333	363.0033	94336200.0
2021-11-17	TLT	Stock	144.57	146.29	144.46	146.26	14239864.0
2021-11-17	ES	Stock	82.82	84.03	82.5	83.77	893100.0
2021-11-17	CL	Stock	77.77	77.78	77.17	77.58	3144600.0
2021-11-17	A	Stock	161.92	161.92	159.9	161.54	872400.0
2021-11-17	AA	Stock	48.91	50.0	47.62	47.92	5365600.0
2021-11-17	AAC-DELISTED	Stock	9.82	9.84	9.8	9.815	91179.0
2021-11-17	AACG	Stock	2.14	2.14	2.05	2.05	21000.0
2021-11-17	AACIW-DELISTED	Stock	0.52	0.54	0.5198	0.5201	51320.0
2021-11-17	AAIC-DELISTED	Stock	3.79	3.79	3.74	3.74	145611.0
2021-11-17	AAL	Stock	19.71	20.06	19.58	19.86	17862800.0
2021-11-17	AAM.A-DELISTED	Stock	25.8299	25.8299	25.74	25.78	9337.0
2021-11-17	AAM.B-DELISTED	Stock	26.8	26.87	26.7804	26.7804	5867.0
2021-11-17	AAMC-DELISTED	Stock	7.1765	7.2647	6.9676	7.2647	22127.0
2021-11-17	AAME	Stock	4.0	4.31	4.0	4.22	10500.0
2021-11-17	AAMI	Stock	30.5	30.62	30.185	30.4	2614000.0
2021-11-17	AAN-DELISTED	Stock	25.39	25.39	24.835	25.08	142900.0
2021-11-17	AAOI	Stock	6.02	6.18	5.965	6.01	901400.0
2021-11-17	AAON	Stock	51.1	51.34	50.24	50.8667	345300.0
2021-11-17	AAP	Stock	237.3	239.72	231.39	232.55	771300.0
2021-11-17	AAQC-DELISTED	Stock	9.78	9.8	9.75	9.76	8836.0
2021-11-17	AAT	Stock	38.43	38.47	37.29	38.27	183300.0
2021-11-17	AATC	Stock	6.9	7.0544	6.8501	7.02	28034.0
2021-11-17	AAU-DELISTED	Stock	0.3774	0.3845	0.3774	0.38	620909.0
2021-11-17	AAUAF-DELISTED	Stock	0.3774	0.3845	0.3774	0.38	665026.0
2021-11-17	AAWW-DELISTED	Stock	87.83	88.78	86.21	88.47	248871.0
2021-11-17	AAXJ	Stock	88.12	88.39	87.32	87.52	786200.0
2021-11-17	AB	Stock	56.16	56.38	55.05	55.22	138100.0
2021-11-17	ABB-DELISTED	Stock	35.64	35.7	35.5	35.64	968778.0
2021-11-17	ABBNY-DELISTED	Stock	35.64	35.7	35.5	35.65	1091334.0
2021-11-17	ABBV	Stock	116.6	117.62	116.25	117.35	4361500.0
2021-11-17	ABC-DELISTED	Stock	123.81	125.09	123.07	124.67	621570.0
2021-11-17	ABCB	Stock	53.51	53.51	52.16	52.49	314000.0
2021-11-17	ABCL	Stock	16.25	16.25	14.65	14.82	2108100.0
2021-11-17	ABCM-DELISTED	Stock	22.86	23.2225	22.84	23.195	66609.0
2021-11-17	ABEO	Stock	21.5	21.75	20.75	21.25	25168.0
2021-11-17	ABEV	Stock	3.13	3.15	3.09	3.13	22272500.0
2021-11-17	ABG	Stock	182.5	182.5	165.4	166.29	438200.0
2021-11-17	ABGI-DELISTED	Stock	9.8	9.82	9.75	9.82	79732.0
2021-11-17	ABM	Stock	48.55	48.55	47.63	47.7	348200.0
2021-11-17	ABMD-DELISTED	Stock	352.0	352.0	342.3	343.51	91454.0
2021-11-17	ABNB	Stock	207.0	212.584	198.4	199.11	6383400.0
2021-11-17	ABOS	Stock	10.65	10.97	9.9	10.77	127300.0
2021-11-17	ABR	Stock	19.0	19.05	18.61	18.74	1712900.0

> showing 50 of 8,015 rows — these rows as CSV

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