PREVIEW / stock_daily / 2020-10-07

all stock daily files

  file:    by_date/stock_daily/2020/2020-10-07.parquet
  size:    229 KB
  rows:    6,946
  symbols: 2,484

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
2020-10-07	AAPL	Stock	114.62	115.55	114.13	115.08	96849000.0
2020-10-07	MSFT	Stock	207.06	210.11	206.72	209.83	25681100.0
2020-10-07	NVDA	Stock	13.9998	14.1192	13.8635	13.964	418084000.0
2020-10-07	AMZN	Stock	156.75	160.0	156.6195	159.7845	86188000.0
2020-10-07	GOOGL	Stock	72.9655	73.4485	71.6615	72.957	36108960.0
2020-10-07	META	Stock	259.21	260.18	254.82	258.12	23133400.0
2020-10-07	TSLA	Stock	139.9567	143.3	137.95	141.7667	129383100.0
2020-10-07	TLT	Stock	159.56	160.417	158.86	159.26	9429580.0
2020-10-07	ES	Stock	91.37	91.79	90.26	91.4	1264900.0
2020-10-07	CL	Stock	77.83	78.39	77.69	78.13	1928300.0
2020-10-07	A	Stock	102.47	104.75	102.42	103.88	1322100.0
2020-10-07	AA	Stock	11.96	12.3	11.96	12.24	3928900.0
2020-10-07	AACG	Stock	1.12	1.12	1.1	1.1	6400.0
2020-10-07	AACQ-DELISTED	Stock	9.78	9.84	9.75	9.8	236515.0
2020-10-07	AACQU-DELISTED	Stock	10.26	10.27	10.18	10.25	18353.0
2020-10-07	AACQW-DELISTED	Stock	1.47	1.47	1.4199	1.47	107838.0
2020-10-07	AAIC-DELISTED	Stock	2.84	2.87	2.82	2.82	188709.0
2020-10-07	AAIC.C-DELISTED	Stock	18.9025	18.9236	18.9025	18.9236	306.0
2020-10-07	AAL	Stock	12.98	13.18	12.81	13.07	61274200.0
2020-10-07	AAM.A-DELISTED	Stock	26.31	26.37	26.22	26.22	13828.0
2020-10-07	AAM.B-DELISTED	Stock	27.35	27.47	27.26	27.35	52281.0
2020-10-07	AAMC-DELISTED	Stock	6.1294	6.1382	6.0441	6.0441	3420.0
2020-10-07	AAME	Stock	1.97	2.0	1.97	2.0	800.0
2020-10-07	AAMI	Stock	13.81	14.19	13.79	14.04	694300.0
2020-10-07	AAOI	Stock	11.28	11.61	11.26	11.48	364400.0
2020-10-07	AAON	Stock	42.0733	42.86	41.74	41.9	349050.0
2020-10-07	AAP	Stock	155.62	158.5	155.28	156.81	1065700.0
2020-10-07	AAT	Stock	25.59	25.62	24.64	24.71	276100.0
2020-10-07	AAU-DELISTED	Stock	0.8	0.81	0.771	0.7874	274186.0
2020-10-07	AAUAF-DELISTED	Stock	0.8	0.81	0.771	0.7886	285510.0
2020-10-07	AAWW-DELISTED	Stock	65.1	67.16	65.05	67.02	455581.0
2020-10-07	AAXJ	Stock	79.05	79.42	78.87	79.29	1558191.0
2020-10-07	AAXN-DELISTED	Stock	94.54	96.355	93.91	96.08	257135.0
2020-10-07	AB	Stock	27.96	28.32	27.68	28.1	323700.0
2020-10-07	ABB-DELISTED	Stock	26.22	26.355	26.17	26.3	1331214.0
2020-10-07	ABBNY-DELISTED	Stock	26.22	26.355	26.17	26.3	1414016.0
2020-10-07	ABBV	Stock	86.16	87.3	86.03	87.07	5899700.0
2020-10-07	ABC-DELISTED	Stock	96.02	96.45	95.56	95.59	552108.0
2020-10-07	ABCB	Stock	25.87	26.5	25.39	25.62	496200.0
2020-10-07	ABEO	Stock	30.0	33.5	29.25	30.75	126248.0
2020-10-07	ABEV	Stock	2.42	2.5	2.42	2.43	29383900.0
2020-10-07	ABG	Stock	114.05	117.45	112.13	113.71	235100.0
2020-10-07	ABM	Stock	37.19	37.46	36.74	37.39	604200.0
2020-10-07	ABMD-DELISTED	Stock	268.22	272.795	267.83	268.47	124347.0
2020-10-07	ABR	Stock	11.71	11.96	11.54	11.73	889900.0
2020-10-07	ABR.A-DELISTED	Stock	25.35	25.35	25.26	25.2815	1500.0
2020-10-07	ABR.B-DELISTED	Stock	25.195	25.195	25.195	25.195	100.0
2020-10-07	ABR.C-DELISTED	Stock	25.59	25.7664	25.59	25.7664	800.0
2020-10-07	ABT	Stock	107.37	108.18	106.93	107.74	4162400.0
2020-10-07	ABTC	Stock	117900.0	130500.0	115500.0	119700.0	16.333333333333332

> showing 50 of 6,946 rows — these rows as CSV

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