PREVIEW / etf_daily / 2017-08-15

all etf daily files

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

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-15	SPY	ETF	246.98	247.0	246.16	246.51	55242700.0
2017-08-15	QQQ	ETF	144.22	144.302	143.64	144.03	25509181.0
2017-08-15	IWM	ETF	138.8	138.82	137.34	137.4	16646000.0
2017-08-15	DIA	ETF	220.58	220.58	219.86	220.16	1835700.0
2017-08-15	GLD	ETF	120.6	121.23	120.58	120.98	6731300.0
2017-08-15	TLT	ETF	124.73	125.54	124.71	125.25	7473200.0
2017-08-15	AADR	ETF	50.78	50.91	50.65	50.66	23100.0
2017-08-15	AAXJ	ETF	70.04	70.05	69.75	69.98	250900.0
2017-08-15	ACSI	ETF	28.98	28.98	28.94	28.95	11246.0
2017-08-15	ACTX	ETF	81.4207	81.4207	71.9806	73.1607	698.0
2017-08-15	ACWF	ETF	27.85	27.865	27.76	27.865	3138.0
2017-08-15	ACWI	ETF	66.94	66.95	66.74	66.85	871800.0
2017-08-15	ACWV	ETF	80.64	80.71	80.53	80.64	78100.0
2017-08-15	ACWX	ETF	46.73	46.7599	46.59	46.71	584212.0
2017-08-15	ADRE	ETF	41.21	41.462	41.2	41.44	4570.0
2017-08-15	AFK	ETF	22.61	22.66	22.55	22.65	13046.0
2017-08-15	AFTY	ETF	15.946	15.95	15.946	15.95	800.0
2017-08-15	AGG	ETF	109.56	109.72	109.56	109.66	2177400.0
2017-08-15	AGGY	ETF	50.62	50.68	50.571	50.67	9600.0
2017-08-15	AGNG	ETF	18.603	18.624	18.526	18.526	1400.0
2017-08-15	AGQ	ETF	33.26	33.89	33.23	33.51	181100.0
2017-08-15	AGZ	ETF	113.8573	113.92	113.8383	113.88	9255.0
2017-08-15	AGZD	ETF	23.99	23.99	23.99	23.99	400.0
2017-08-15	AIA	ETF	59.53	59.53	59.3	59.4	32597.0
2017-08-15	AIQ	ETF	13.1	13.2	13.1	13.2	40400.0
2017-08-15	AIRR	ETF	23.45	23.45	23.04	23.07	37100.0
2017-08-15	AIVI	ETF	41.5	41.6	41.41	41.48	40600.0
2017-08-15	ALTY	ETF	15.575	15.6	15.545	15.6	2300.0
2017-08-15	AMJ	ETF	28.19	28.19	27.581	27.66	6424515.0
2017-08-15	AMLP	ETF	55.15	55.3	53.9	54.15	4717240.0
2017-08-15	AMZA	ETF	90.6	90.8	88.5	89.5	211020.0
2017-08-15	ANGL	ETF	29.71	29.72	29.6	29.72	183300.0
2017-08-15	AOA	ETF	52.41	52.41	52.17	52.21	44300.0
2017-08-15	AOK	ETF	34.13	34.1499	34.07	34.1	31537.0
2017-08-15	AOM	ETF	37.49	37.49	37.34	37.37	76992.0
2017-08-15	AOR	ETF	44.04	44.04	43.88	43.95	94239.0
2017-08-15	ARCM	ETF	100.05	100.05	100.05	100.05	20.0
2017-08-15	ARGT	ETF	29.36	29.36	28.87	29.14	74800.0
2017-08-15	ARKG	ETF	22.756	22.891	22.6	22.6	7700.0
2017-08-15	ARKK	ETF	32.06	32.08	31.07	31.28	72800.0
2017-08-15	ARKQ	ETF	29.89	29.89	29.33	29.371	21200.0
2017-08-15	ARKW	ETF	38.92	38.92	37.998	38.37	70600.0
2017-08-15	ASEA	ETF	15.31	15.31	15.22	15.22	1300.0
2017-08-15	ASET	ETF	27.828	27.828	27.8268	27.8268	356.0
2017-08-15	ASHR	ETF	27.86	27.9	27.83	27.85	386600.0
2017-08-15	ASHS	ETF	34.19	34.29	34.19	34.29	3200.0
2017-08-15	ASHX	ETF	20.88	20.92	20.88	20.88	874.0
2017-08-15	ATMP	ETF	21.13	21.14	20.89	21.02	37200.0
2017-08-15	BAB	ETF	30.18	30.21	30.16	30.18	110760.0
2017-08-15	BAL	ETF	44.41	44.41	44.08	44.19	13023.0

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

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