PREVIEW / stock_daily / 2017-06-19

all stock daily files

  file:    by_date/stock_daily/2017/2017-06-19.parquet
  size:    215 KB
  rows:    6,480
  symbols: 3,009

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
2017-06-19	AAPL	Stock	35.915	36.685	35.915	36.585	130165600.0
2017-06-19	MSFT	Stock	70.5	70.94	70.35	70.87	23798300.0
2017-06-19	NVDA	Stock	3.8352	3.9382	3.8315	3.933	778176000.0
2017-06-19	AMZN	Stock	50.85	50.85	49.495	49.7585	100868000.0
2017-06-19	GOOGL	Stock	48.4825	48.965	48.41	48.761	29376740.0
2017-06-19	META	Stock	151.71	153.57	151.71	152.87	19026500.0
2017-06-19	TSLA	Stock	25.0	25.1133	24.52	24.6533	98239500.0
2017-06-19	TLT	Stock	126.32	126.475	126.03	126.17	5641338.0
2017-06-19	ES	Stock	63.22	63.34	62.56	62.79	966300.0
2017-06-19	CL	Stock	76.5	76.9	76.09	76.9	2889900.0
2017-06-19	A	Stock	59.58	60.67	59.58	60.55	2383700.0
2017-06-19	AA	Stock	30.37	31.3	30.16	30.89	3909100.0
2017-06-19	AAAP-DELISTED	Stock	37.0	37.8	36.7	37.79	28245.0
2017-06-19	AABA-DELISTED	Stock	54.0	55.03	53.8	54.51	33662272.0
2017-06-19	AAC-DELISTED	Stock	6.31	6.6	6.13	6.52	56489.0
2017-06-19	AACG	Stock	4.65	4.9	4.65	4.87	27100.0
2017-06-19	AAIC-DELISTED	Stock	14.65	14.899	14.47	14.82	635199.0
2017-06-19	AAL	Stock	49.13	49.72	48.82	49.66	4104300.0
2017-06-19	AAM.A-DELISTED	Stock	25.59	25.84	25.57	25.84	83646.0
2017-06-19	AAMC-DELISTED	Stock	26.3088	26.3088	25.0588	25.0588	3655.0
2017-06-19	AAME	Stock	3.6	3.7	3.6	3.65	1500.0
2017-06-19	AAMI	Stock	14.98	15.1	14.72	14.81	886500.0
2017-06-19	AAOI	Stock	63.3	65.23	62.291	63.2	2596600.0
2017-06-19	AAON	Stock	24.9333	25.0667	24.7333	24.8333	188550.0
2017-06-19	AAP	Stock	130.3	131.07	128.58	129.6	1069500.0
2017-06-19	AAT	Stock	40.06	40.06	39.59	39.76	214200.0
2017-06-19	AAU-DELISTED	Stock	1.34	1.37	1.32	1.34	160810.0
2017-06-19	AAUAF-DELISTED	Stock	1.34	1.37	1.32	1.34	162284.0
2017-06-19	AAV-DELISTED	Stock	6.2	6.3	6.2	6.25	53712.0
2017-06-19	AAWW-DELISTED	Stock	52.5	54.0	51.1	51.95	289890.0
2017-06-19	AAXJ	Stock	67.77	68.015	67.68	67.92	570947.0
2017-06-19	AAXN-DELISTED	Stock	25.53	25.69	25.29	25.42	393862.0
2017-06-19	AB	Stock	23.3	23.37	23.15	23.25	308500.0
2017-06-19	ABAC-DELISTED	Stock	2.013	2.1	2.0001	2.1	5160.0
2017-06-19	ABAX-DELISTED	Stock	51.02	51.9	50.8	51.55	63007.0
2017-06-19	ABB-DELISTED	Stock	25.41	25.52	25.385	25.5	2067186.0
2017-06-19	ABBNY-DELISTED	Stock	25.41	25.52	25.385	25.5	2105524.0
2017-06-19	ABBV	Stock	71.11	71.59	70.94	71.34	6396300.0
2017-06-19	ABC-DELISTED	Stock	92.61	94.02	91.76	93.76	918196.0
2017-06-19	ABCB	Stock	48.0	48.43	47.4	47.55	93200.0
2017-06-19	ABCD-DELISTED	Stock	4.84	4.94	4.67	4.86	126454.0
2017-06-19	ABCO-DELISTED	Stock	51.5	52.03	51.4	51.825	218905.0
2017-06-19	ABDC-DELISTED	Stock	13.26	13.5396	13.26	13.5	41428.0
2017-06-19	ABE-DELISTED	Stock	13.88	13.98	13.88	13.95	1999.0
2017-06-19	ABEO	Stock	117.5	123.75	117.5	120.0	5540.0
2017-06-19	ABEOW-DELISTED	Stock	2.65	2.6501	2.65	2.6501	1996.0
2017-06-19	ABEV	Stock	5.34	5.43	5.3	5.4	35722900.0
2017-06-19	ABG	Stock	54.85	56.1	54.1	55.75	248000.0
2017-06-19	ABIL-DELISTED	Stock	1.22	1.2519	1.15	1.23	181422.0
2017-06-19	ABM	Stock	41.8	42.09	41.47	41.63	235000.0

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

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