PREVIEW / stock_daily / 2018-04-03

all stock daily files

  file:    by_date/stock_daily/2018/2018-04-03.parquet
  size:    217 KB
  rows:    6,507
  symbols: 2,842

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-04-03	AAPL	Stock	41.91	42.1875	41.22	42.0975	121112000.0
2018-04-03	MSFT	Stock	89.58	90.05	87.89	89.71	37213800.0
2018-04-03	NVDA	Stock	5.695	5.7588	5.5338	5.6338	667432000.0
2018-04-03	AMZN	Stock	69.569	70.7	67.7665	69.6025	204624000.0
2018-04-03	GOOGL	Stock	50.8075	51.25	49.8623	50.934	51322920.0
2018-04-03	META	Stock	156.55	157.39	150.81	156.11	42543900.0
2018-04-03	TSLA	Stock	17.988	18.2233	16.966	17.8353	282666000.0
2018-04-03	TLT	Stock	121.36	121.475	120.83	120.94	9855032.0
2018-04-03	ES	Stock	58.6	59.57	58.3	59.3	2708600.0
2018-04-03	CL	Stock	70.31	71.06	69.97	70.95	3717400.0
2018-04-03	A	Stock	64.94	65.88	64.62	65.42	2286100.0
2018-04-03	AA	Stock	44.63	45.9	44.63	45.35	2915000.0
2018-04-03	AABA-DELISTED	Stock	72.15	72.42	70.09	70.49	4049429.0
2018-04-03	AAC-DELISTED	Stock	11.15	11.47	11.09	11.24	51291.0
2018-04-03	AACG	Stock	5.3	5.39	5.07	5.27	26000.0
2018-04-03	AAIC-DELISTED	Stock	11.02	11.125	10.91	11.12	358723.0
2018-04-03	AAL	Stock	50.23	51.55	49.57	51.47	3863300.0
2018-04-03	AAM.A-DELISTED	Stock	24.94	25.0	24.84	25.0	43367.0
2018-04-03	AAM.B-DELISTED	Stock	24.77	24.95	24.7	24.95	218428.0
2018-04-03	AAMC-DELISTED	Stock	18.6029	18.6029	18.25	18.25	1996.0
2018-04-03	AAME	Stock	3.15	3.45	3.15	3.3	1800.0
2018-04-03	AAMI	Stock	15.11	15.36	15.09	15.27	319100.0
2018-04-03	AAOI	Stock	24.1	24.66	23.76	24.0	721900.0
2018-04-03	AAON	Stock	24.8667	24.9333	23.7333	24.2333	495450.0
2018-04-03	AAP	Stock	112.5	113.88	108.95	111.91	1504200.0
2018-04-03	AAT	Stock	33.71	34.28	33.43	34.1	270200.0
2018-04-03	AAU-DELISTED	Stock	0.85	0.85	0.82	0.82	60126.0
2018-04-03	AAUAF-DELISTED	Stock	0.85	0.85	0.82	0.82	63101.0
2018-04-03	AAV-DELISTED	Stock	2.9	3.1	2.9	3.1	393612.0
2018-04-03	AAWW-DELISTED	Stock	59.45	61.55	59.45	60.7	150532.0
2018-04-03	AAXJ	Stock	76.87	77.08	76.32	77.03	365524.0
2018-04-03	AAXN-DELISTED	Stock	39.78	42.45	39.501	42.41	1592338.0
2018-04-03	AB	Stock	26.4	26.5	26.05	26.3	228400.0
2018-04-03	ABAC-DELISTED	Stock	2.2	2.3956	2.19	2.3	4276.0
2018-04-03	ABAX-DELISTED	Stock	68.89	70.76	67.89	68.78	82418.0
2018-04-03	ABB-DELISTED	Stock	23.18	23.355	23.12	23.315	2095546.0
2018-04-03	ABBNY-DELISTED	Stock	23.18	23.355	23.12	23.31	2197566.0
2018-04-03	ABBV	Stock	92.34	92.46	88.22	90.59	10449200.0
2018-04-03	ABC-DELISTED	Stock	83.19	84.01	81.58	83.92	1158798.0
2018-04-03	ABCB	Stock	52.4	53.25	52.0	53.25	191800.0
2018-04-03	ABCD-DELISTED	Stock	11.12	11.29	10.821	11.0	203658.0
2018-04-03	ABDC-DELISTED	Stock	7.03	7.13	6.96	6.97	46561.0
2018-04-03	ABE-DELISTED	Stock	14.69	14.74	14.69	14.74	4411.0
2018-04-03	ABEO	Stock	355.0	362.5	346.25	350.0	37516.0
2018-04-03	ABEOW-DELISTED	Stock	9.2647	9.2647	9.2647	9.2647	300.0
2018-04-03	ABEV	Stock	7.19	7.23	7.11	7.18	19131600.0
2018-04-03	ABG	Stock	64.05	65.2	63.9	64.5	190600.0
2018-04-03	ABIL-DELISTED	Stock	3.03	3.0466	2.7601	2.89	14430.0
2018-04-03	ABLX-DELISTED	Stock	54.62	54.64	54.45	54.55	40144.0
2018-04-03	ABM	Stock	33.1	33.59	32.83	33.48	828000.0

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

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