PREVIEW / stock_daily / 2021-07-20

all stock daily files

  file:    by_date/stock_daily/2021/2021-07-20.parquet
  size:    258 KB
  rows:    7,904
  symbols: 2,832

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-07-20	AAPL	Stock	143.46	147.1	142.96	146.15	96350000.0
2021-07-20	MSFT	Stock	278.03	280.97	276.26	279.32	26259700.0
2021-07-20	NVDA	Stock	18.73	18.838	18.164	18.612	434687000.0
2021-07-20	AMZN	Stock	178.366	179.6	175.9	178.6595	65114000.0
2021-07-20	GOOGL	Stock	125.5275	127.0432	124.3505	126.2095	26316440.0
2021-07-20	META	Stock	338.8	343.45	334.5	341.66	11024300.0
2021-07-20	TSLA	Stock	217.33	220.7967	213.5	220.1667	46461300.0
2021-07-20	TLT	Stock	152.53	152.71	149.76	150.0	25674791.0
2021-07-20	ES	Stock	86.54	87.79	85.41	85.94	1777400.0
2021-07-20	CL	Stock	83.82	84.78	82.67	82.69	4884100.0
2021-07-20	A	Stock	148.45	151.25	147.83	149.3	2246000.0
2021-07-20	AA	Stock	31.55	35.26	31.26	34.95	15651300.0
2021-07-20	AAC-DELISTED	Stock	9.7717	9.7717	9.75	9.75	1465.0
2021-07-20	AACG	Stock	3.02	3.3	2.9	3.28	377300.0
2021-07-20	AAIC-DELISTED	Stock	3.68	3.83	3.66	3.79	176924.0
2021-07-20	AAIC.C-DELISTED	Stock	25.3	25.3	25.225	25.275	7420.0
2021-07-20	AAL	Stock	19.05	20.59	18.86	20.56	46295400.0
2021-07-20	AAM.A-DELISTED	Stock	26.57	26.59	26.38	26.59	1444.0
2021-07-20	AAM.B-DELISTED	Stock	27.06	27.0744	27.06	27.07	2725.0
2021-07-20	AAMC-DELISTED	Stock	4.9647	5.0	4.7497	4.8382	81559.0
2021-07-20	AAME	Stock	3.89	3.97	3.69	3.89	49700.0
2021-07-20	AAMI	Stock	23.19	23.71	23.01	23.29	619100.0
2021-07-20	AAN-DELISTED	Stock	27.48	29.09	27.07	28.54	358400.0
2021-07-20	AAOI	Stock	7.3	7.495	7.145	7.41	453900.0
2021-07-20	AAON	Stock	40.6267	41.9	40.54	40.9467	256950.0
2021-07-20	AAP	Stock	206.7	211.55	206.09	210.23	477400.0
2021-07-20	AAQC-DELISTED	Stock	9.7	9.75	9.65	9.68	34779.0
2021-07-20	AAT	Stock	35.11	36.98	35.01	36.68	445500.0
2021-07-20	AAU-DELISTED	Stock	0.4225	0.426	0.41	0.4158	684121.0
2021-07-20	AAUAF-DELISTED	Stock	0.4225	0.426	0.41	0.4247	700478.0
2021-07-20	AAWW-DELISTED	Stock	63.43	65.61	62.99	64.97	213594.0
2021-07-20	AAXJ	Stock	90.03	90.8	89.75	90.64	522257.0
2021-07-20	AB	Stock	44.98	45.44	44.51	45.09	187100.0
2021-07-20	ABB-DELISTED	Stock	34.55	35.22	34.46	35.11	1976663.0
2021-07-20	ABBNY-DELISTED	Stock	34.55	35.22	34.46	35.12	2121397.0
2021-07-20	ABBV	Stock	115.55	117.73	115.46	116.05	5581400.0
2021-07-20	ABC-DELISTED	Stock	118.5	119.8	116.35	116.56	1716835.0
2021-07-20	ABCB	Stock	45.49	47.98	45.4	46.52	498900.0
2021-07-20	ABCL	Stock	16.3	16.59	15.8	16.34	1168400.0
2021-07-20	ABCM-DELISTED	Stock	17.38	17.54	17.14	17.44	95539.0
2021-07-20	ABEO	Stock	31.25	32.25	30.75	31.5	36296.0
2021-07-20	ABEV	Stock	3.17	3.24	3.16	3.2	27403300.0
2021-07-20	ABG	Stock	185.48	194.9	185.48	192.65	260500.0
2021-07-20	ABGI-DELISTED	Stock	9.81	9.82	9.81	9.82	1730.0
2021-07-20	ABM	Stock	44.72	46.66	44.72	46.08	456800.0
2021-07-20	ABMD-DELISTED	Stock	315.47	324.81	315.47	323.47	127890.0
2021-07-20	ABNB	Stock	132.75	137.435	131.7	136.09	6274600.0
2021-07-20	ABOS	Stock	19.11	19.59	18.31	18.51	114300.0
2021-07-20	ABR	Stock	17.3	17.92	17.21	17.76	2190100.0
2021-07-20	ABR.D	Stock	25.51	25.52	25.47	25.49	19704.0

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

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