PREVIEW / stock_daily / 2018-03-14

all stock daily files

  file:    by_date/stock_daily/2018/2018-03-14.parquet
  size:    216 KB
  rows:    6,467
  symbols: 2,837

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-03-14	AAPL	Stock	45.08	45.13	44.4525	44.61	117473600.0
2018-03-14	MSFT	Stock	95.12	95.41	93.5	93.85	32132000.0
2018-03-14	NVDA	Stock	6.2362	6.2638	6.1555	6.2185	505496000.0
2018-03-14	AMZN	Stock	79.85	80.322	79.5445	79.55	85188000.0
2018-03-14	GOOGL	Stock	57.29	57.988	57.1175	57.4445	41869640.0
2018-03-14	META	Stock	182.6	184.25	181.85	184.19	16821700.0
2018-03-14	TSLA	Stock	22.4507	22.654	21.5953	21.7753	119511000.0
2018-03-14	TLT	Stock	119.4	120.4	119.37	120.24	10175049.0
2018-03-14	ES	Stock	56.79	57.49	56.75	57.19	1718000.0
2018-03-14	CL	Stock	70.88	70.98	69.71	69.99	4161400.0
2018-03-14	A	Stock	71.07	71.16	69.69	69.92	1866300.0
2018-03-14	AA	Stock	49.09	49.43	46.21	46.57	4121900.0
2018-03-14	AABA-DELISTED	Stock	76.27	77.67	76.27	77.21	3872498.0
2018-03-14	AAC-DELISTED	Stock	11.95	12.25	11.81	12.03	176372.0
2018-03-14	AACG	Stock	5.27	5.27	5.07	5.07	700.0
2018-03-14	AAIC-DELISTED	Stock	11.81	11.905	11.81	11.81	406501.0
2018-03-14	AAL	Stock	56.57	57.21	55.16	55.28	4267000.0
2018-03-14	AAM.A-DELISTED	Stock	25.19	25.28	25.19	25.26	65334.0
2018-03-14	AAMC-DELISTED	Stock	19.1176	19.1176	17.2353	17.2353	10996.0
2018-03-14	AAME	Stock	3.3	3.3	3.25	3.3	1900.0
2018-03-14	AAMI	Stock	16.02	16.07	15.81	15.96	1236900.0
2018-03-14	AAOI	Stock	29.74	30.11	29.03	29.12	917400.0
2018-03-14	AAON	Stock	25.9	25.9333	25.0667	25.6667	273300.0
2018-03-14	AAP	Stock	119.16	119.88	116.55	117.06	681800.0
2018-03-14	AAT	Stock	32.99	33.19	32.88	33.06	614500.0
2018-03-14	AAU-DELISTED	Stock	0.87	0.87	0.85	0.854	162808.0
2018-03-14	AAUAF-DELISTED	Stock	0.87	0.87	0.85	0.854	173443.0
2018-03-14	AAV-DELISTED	Stock	2.8	2.9	2.775	2.825	307302.0
2018-03-14	AAWW-DELISTED	Stock	62.4	62.95	61.8	62.95	147414.0
2018-03-14	AAXJ	Stock	79.73	79.95	79.06	79.49	597203.0
2018-03-14	AAXN-DELISTED	Stock	39.49	39.585	38.95	39.0175	603914.0
2018-03-14	AB	Stock	26.9	26.9	26.25	26.35	242300.0
2018-03-14	ABAX-DELISTED	Stock	73.21	74.14	72.835	73.75	79082.0
2018-03-14	ABB-DELISTED	Stock	24.48	24.48	24.11	24.22	1112836.0
2018-03-14	ABBNY-DELISTED	Stock	24.48	24.48	24.11	24.22	1177233.0
2018-03-14	ABBV	Stock	120.34	120.67	117.95	118.94	3556100.0
2018-03-14	ABC-DELISTED	Stock	100.88	101.12	98.151	98.59	1142942.0
2018-03-14	ABCB	Stock	57.65	57.65	56.35	56.5	341700.0
2018-03-14	ABCD-DELISTED	Stock	9.61	9.9	9.51	9.835	237854.0
2018-03-14	ABDC-DELISTED	Stock	7.7	7.859	7.7	7.7501	25474.0
2018-03-14	ABE-DELISTED	Stock	15.16	15.17	15.16	15.17	701.0
2018-03-14	ABEO	Stock	381.25	387.0	376.25	383.75	23084.0
2018-03-14	ABEOW-DELISTED	Stock	10.7092	10.7299	10.5039	10.5039	1000.0
2018-03-14	ABEV	Stock	7.35	7.43	7.31	7.39	20061200.0
2018-03-14	ABG	Stock	69.3	69.95	68.55	69.05	161000.0
2018-03-14	ABIL-DELISTED	Stock	0.4005	0.4088	0.3721	0.3887	65161.0
2018-03-14	ABLX-DELISTED	Stock	54.25	54.44	54.0	54.22	1130496.0
2018-03-14	ABM	Stock	37.78	37.95	36.97	37.12	801000.0
2018-03-14	ABMD-DELISTED	Stock	294.0	296.02	290.83	295.83	278620.0
2018-03-14	ABR	Stock	8.81	8.88	8.79	8.83	668900.0

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

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