PREVIEW / stock_daily / 2018-02-15

all stock daily files

  file:    by_date/stock_daily/2018/2018-02-15.parquet
  size:    217 KB
  rows:    6,480
  symbols: 2,859

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
2018-02-15	AAPL	Stock	42.4475	43.2725	42.25	43.2475	204588800.0
2018-02-15	MSFT	Stock	91.21	92.72	90.62	92.66	27823900.0
2018-02-15	NVDA	Stock	6.1198	6.2093	6.038	6.1625	698900000.0
2018-02-15	AMZN	Stock	73.3445	73.447	71.842	73.088	113054000.0
2018-02-15	GOOGL	Stock	54.1725	54.705	53.3615	54.568	37395260.0
2018-02-15	META	Stock	180.5	180.5	176.84	179.96	20922100.0
2018-02-15	TSLA	Stock	21.6333	22.2747	21.4933	22.2713	88693500.0
2018-02-15	TLT	Stock	118.19	118.7964	117.99	118.07	8222416.0
2018-02-15	ES	Stock	57.84	58.58	57.65	58.57	3189100.0
2018-02-15	CL	Stock	69.82	71.22	69.5	71.22	3617100.0
2018-02-15	A	Stock	74.94	74.99	71.22	72.02	4899100.0
2018-02-15	AA	Stock	48.99	48.99	46.19	47.57	5113200.0
2018-02-15	AABA-DELISTED	Stock	74.25	74.7	73.23	74.44	4027977.0
2018-02-15	AAC-DELISTED	Stock	8.3183	8.5	8.13	8.37	50496.0
2018-02-15	AACG	Stock	5.3	5.88	5.16	5.16	17600.0
2018-02-15	AAIC-DELISTED	Stock	11.0	11.35	10.88	11.29	805932.0
2018-02-15	AAL	Stock	51.45	51.88	50.94	51.67	3140800.0
2018-02-15	AAM.A-DELISTED	Stock	25.15	25.3	25.15	25.2499	45196.0
2018-02-15	AAMC-DELISTED	Stock	18.8235	20.2059	18.8235	20.2059	8932.0
2018-02-15	AAMI	Stock	16.2	16.2	15.62	15.7	1006900.0
2018-02-15	AAOI	Stock	31.28	32.51	31.28	31.99	1150900.0
2018-02-15	AAON	Stock	23.0667	23.1667	22.7333	23.0667	72300.0
2018-02-15	AAP	Stock	109.23	110.28	107.57	108.78	818400.0
2018-02-15	AAT	Stock	32.07	32.74	31.48	32.19	431600.0
2018-02-15	AAU-DELISTED	Stock	0.93	0.9525	0.9101	0.9501	100217.0
2018-02-15	AAUAF-DELISTED	Stock	0.93	0.9525	0.9101	0.9501	112428.0
2018-02-15	AAV-DELISTED	Stock	2.95	3.05	2.775	2.975	451836.0
2018-02-15	AAWW-DELISTED	Stock	55.2	55.6	54.65	55.5	220939.0
2018-02-15	AAXJ	Stock	78.88	79.39	78.0261	79.16	1484311.0
2018-02-15	AAXN-DELISTED	Stock	28.0	28.489	27.88	28.4	614051.0
2018-02-15	AB	Stock	26.75	27.25	26.65	27.1	493200.0
2018-02-15	ABAC-DELISTED	Stock	2.45	2.55	1.95	1.96	58521.0
2018-02-15	ABAX-DELISTED	Stock	68.24	69.29	67.31	69.01	105866.0
2018-02-15	ABB-DELISTED	Stock	25.41	25.5	25.25	25.47	2029363.0
2018-02-15	ABBNY-DELISTED	Stock	25.41	25.5	25.25	25.47	2113303.0
2018-02-15	ABBV	Stock	113.62	116.33	112.38	114.9	7401100.0
2018-02-15	ABC-DELISTED	Stock	96.93	97.62	94.505	97.6	2453049.0
2018-02-15	ABCB	Stock	54.2	54.2	53.4	54.1	172800.0
2018-02-15	ABCD-DELISTED	Stock	7.66	7.66	7.35	7.63	76934.0
2018-02-15	ABDC-DELISTED	Stock	7.52	7.575	7.47	7.49	41346.0
2018-02-15	ABE-DELISTED	Stock	15.2612	15.3298	15.014	15.17	5576.0
2018-02-15	ABEO	Stock	287.5	305.0	262.5	301.25	103888.0
2018-02-15	ABEOW-DELISTED	Stock	6.0	7.2	5.9	7.2	6145.0
2018-02-15	ABEV	Stock	6.85	6.9	6.82	6.88	15283700.0
2018-02-15	ABG	Stock	69.1	69.3	67.0	68.55	224400.0
2018-02-15	ABIL-DELISTED	Stock	0.3796	0.4	0.372	0.372	95511.0
2018-02-15	ABLX-DELISTED	Stock	54.52	54.72	54.41	54.62	149738.0
2018-02-15	ABM	Stock	36.6	36.74	36.31	36.45	243400.0
2018-02-15	ABMD-DELISTED	Stock	259.08	262.61	255.03	261.27	405767.0
2018-02-15	ABR	Stock	8.29	8.32	8.23	8.3	288600.0

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

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