PREVIEW / etf_daily / 2017-08-14

all etf daily files

  file:    by_date/etf_daily/2017/2017-08-14.parquet
  size:    56 KB
  rows:    1,430

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-08-14	SPY	ETF	245.59	246.79	245.55	246.54	73291900.0
2017-08-14	QQQ	ETF	143.23	144.15	143.19	143.93	34161024.0
2017-08-14	IWM	ETF	137.26	138.59	137.23	138.54	21710900.0
2017-08-14	DIA	ETF	219.88	220.29	219.81	219.97	2605000.0
2017-08-14	GLD	ETF	121.98	122.24	121.68	121.92	6035300.0
2017-08-14	TLT	ETF	125.99	126.28	125.73	125.78	5111000.0
2017-08-14	AADR	ETF	49.64	50.9	49.27	50.9	5400.0
2017-08-14	AAXJ	ETF	70.02	70.21	69.88	70.07	531500.0
2017-08-14	ACSI	ETF	29.02	29.06	29.0054	29.04	14602.0
2017-08-14	ACTX	ETF	76.1697	85.5508	73.7507	81.4207	415.0
2017-08-14	ACWF	ETF	27.8281	27.86	27.8212	27.86	1985.0
2017-08-14	ACWI	ETF	66.8	67.04	66.69	66.94	1033000.0
2017-08-14	ACWV	ETF	80.37	80.76	80.37	80.57	120500.0
2017-08-14	ACWX	ETF	46.75	46.895	46.67	46.76	201898.0
2017-08-14	ADRE	ETF	41.17	41.363	41.1	41.11	11864.0
2017-08-14	AFK	ETF	22.82	23.03	22.815	22.8453	9640.0
2017-08-14	AFTY	ETF	15.85	15.86	15.85	15.86	400.0
2017-08-14	AGG	ETF	109.84	109.9	109.74	109.82	2293900.0
2017-08-14	AGGY	ETF	50.73	50.767	50.63	50.72	15900.0
2017-08-14	AGNG	ETF	18.39	18.65	18.39	18.47	3800.0
2017-08-14	AGQ	ETF	35.27	35.57	34.98	35.27	148500.0
2017-08-14	AGZ	ETF	114.0	114.07	113.95	114.0	6969.0
2017-08-14	AGZD	ETF	23.98	23.98	23.975	23.975	600.0
2017-08-14	AIA	ETF	59.49	59.68	59.49	59.57	56462.0
2017-08-14	AIQ	ETF	13.05	13.15	13.025	13.15	95831.0
2017-08-14	AIRR	ETF	23.23	23.48	23.23	23.43	18000.0
2017-08-14	AIVI	ETF	41.59	41.63	41.56	41.56	4900.0
2017-08-14	ALTY	ETF	15.558	15.59	15.558	15.574	2500.0
2017-08-14	AMJ	ETF	28.43	28.66	28.28	28.3	2298053.0
2017-08-14	AMLP	ETF	55.7	56.15	55.35	55.4	1954500.0
2017-08-14	AMZA	ETF	91.5	92.5	90.9	91.1	171870.0
2017-08-14	ANGL	ETF	29.71	29.74	29.66	29.67	230600.0
2017-08-14	AOA	ETF	52.23	52.37	52.21	52.36	33900.0
2017-08-14	AOK	ETF	34.13	34.21	34.1	34.2	48276.0
2017-08-14	AOM	ETF	37.47	37.53	37.3839	37.5	61805.0
2017-08-14	AOR	ETF	43.92	44.03	43.9	43.99	74058.0
2017-08-14	ARCM	ETF	100.05	100.05	100.05	100.05	2500.0
2017-08-14	ARGT	ETF	28.61	29.3	28.52	29.27	313700.0
2017-08-14	ARKG	ETF	22.74	22.815	22.63	22.815	11800.0
2017-08-14	ARKK	ETF	31.26	31.911	31.26	31.75	278000.0
2017-08-14	ARKQ	ETF	29.66	29.66	29.02	29.609	22300.0
2017-08-14	ARKW	ETF	38.27	38.84	38.172	38.71	222000.0
2017-08-14	ASEA	ETF	15.3	15.38	15.3	15.38	2400.0
2017-08-14	ASET	ETF	27.9044	27.94	27.9044	27.94	660.0
2017-08-14	ASHR	ETF	27.79	27.88	27.75	27.86	719000.0
2017-08-14	ASHS	ETF	34.29	34.29	34.15	34.23	11900.0
2017-08-14	ASHX	ETF	20.87	20.87	20.87	20.87	203.0
2017-08-14	ATMP	ETF	21.53	21.54	21.36	21.38	8700.0
2017-08-14	BAB	ETF	30.35	30.49	30.21	30.23	509602.0
2017-08-14	BAL	ETF	44.64	44.71	44.56	44.59	16745.0

> showing 50 of 1,430 rows — these rows as CSV

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