PREVIEW / stock_daily / 2019-10-02

all stock daily files

  file:    by_date/stock_daily/2019/2019-10-02.parquet
  size:    220 KB
  rows:    6,569
  symbols: 2,467

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
2019-10-02	AAPL	Stock	55.765	55.895	54.4825	54.74	138449200.0
2019-10-02	MSFT	Stock	136.25	136.37	133.58	134.65	30521700.0
2019-10-02	NVDA	Stock	4.328	4.34	4.2533	4.326	293372000.0
2019-10-02	AMZN	Stock	86.387	86.4445	85.25	85.6615	66022000.0
2019-10-02	GOOGL	Stock	59.825	59.938	58.6315	58.896	33495480.0
2019-10-02	META	Stock	174.84	176.53	173.09	174.6	16151700.0
2019-10-02	TSLA	Stock	16.2193	16.31	15.962	16.2087	84471000.0
2019-10-02	TLT	Stock	143.46	144.27	143.24	143.61	12896884.0
2019-10-02	ES	Stock	85.38	85.49	84.17	84.42	2092800.0
2019-10-02	CL	Stock	71.4	71.85	70.07	70.52	3352600.0
2019-10-02	A	Stock	74.32	74.54	72.9	73.35	1999400.0
2019-10-02	AA	Stock	19.42	19.55	18.82	19.3	3069500.0
2019-10-02	AABA-DELISTED	Stock	19.57	19.68	19.41	19.64	45027587.0
2019-10-02	AAC-DELISTED	Stock	0.6794	0.7	0.6501	0.666	45590.0
2019-10-02	AACG	Stock	1.48	1.6	1.46	1.6	19500.0
2019-10-02	AAIC-DELISTED	Stock	5.35	5.38	5.26	5.3	358492.0
2019-10-02	AAIC.C-DELISTED	Stock	21.2332	21.25	21.166	21.166	7959.0
2019-10-02	AAL	Stock	26.5	26.51	25.02	25.37	14178200.0
2019-10-02	AAM.A-DELISTED	Stock	26.62	26.62	26.4707	26.55	19740.0
2019-10-02	AAM.B-DELISTED	Stock	26.74	26.83	26.6894	26.77	23090.0
2019-10-02	AAMC-DELISTED	Stock	2.9118	3.0559	2.9118	3.0	25843.0
2019-10-02	AAME	Stock	2.6	2.72	2.52	2.52	1900.0
2019-10-02	AAMI	Stock	9.35	9.45	9.24	9.34	721700.0
2019-10-02	AAOI	Stock	10.06	10.32	9.8	10.25	405500.0
2019-10-02	AAON	Stock	30.26	30.4067	28.6067	29.0933	429600.0
2019-10-02	AAP	Stock	166.27	166.87	161.95	162.96	975400.0
2019-10-02	AAT	Stock	46.15	46.58	45.79	46.02	190000.0
2019-10-02	AAU-DELISTED	Stock	0.63	0.6701	0.63	0.6448	136691.0
2019-10-02	AAUAF-DELISTED	Stock	0.63	0.6701	0.63	0.6462	146946.0
2019-10-02	AAWW-DELISTED	Stock	23.56	23.585	22.81	22.945	358823.0
2019-10-02	AAXJ	Stock	65.47	65.665	65.31	65.64	823951.0
2019-10-02	AAXN-DELISTED	Stock	53.68	53.68	51.28	53.28	939379.0
2019-10-02	AB	Stock	28.75	28.9	28.06	28.34	198700.0
2019-10-02	ABB-DELISTED	Stock	18.71	18.77	18.5	18.56	2939142.0
2019-10-02	ABBNY-DELISTED	Stock	18.71	18.77	18.5	18.55	4098030.0
2019-10-02	ABBV	Stock	72.89	73.0	71.57	72.13	8380500.0
2019-10-02	ABC-DELISTED	Stock	81.32	81.775	80.45	81.0	1019546.0
2019-10-02	ABCB	Stock	39.42	39.75	38.98	39.28	436100.0
2019-10-02	ABDC-DELISTED	Stock	8.87	8.915	8.82	8.86	42332.0
2019-10-02	ABEO	Stock	56.75	56.75	51.75	55.5	34120.0
2019-10-02	ABEV	Stock	4.62	4.64	4.54	4.54	20598500.0
2019-10-02	ABG	Stock	98.54	99.23	96.71	98.66	145700.0
2019-10-02	ABIL-DELISTED	Stock	0.5413	0.5683	0.522	0.5326	37920.0
2019-10-02	ABM	Stock	35.2	35.2	33.94	34.05	388100.0
2019-10-02	ABMD-DELISTED	Stock	168.63	169.07	163.22	163.4	439172.0
2019-10-02	ABR	Stock	13.04	13.07	12.86	12.97	983600.0
2019-10-02	ABR.A-DELISTED	Stock	26.16	26.1808	26.12	26.1463	1354.0
2019-10-02	ABR.B-DELISTED	Stock	25.83	25.9905	25.83	25.9905	625.0
2019-10-02	ABR.C-DELISTED	Stock	26.2537	26.2537	26.1527	26.1527	300.0
2019-10-02	ABT	Stock	81.4	81.55	78.77	79.53	5547100.0

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

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