PREVIEW / etf_daily / 2017-06-13

all etf daily files

  file:    by_date/etf_daily/2017/2017-06-13.parquet
  size:    55 KB
  rows:    1,398

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-13	SPY	ETF	243.98	244.61	243.58	244.55	60067000.0
2017-06-13	QQQ	ETF	140.01	140.56	139.28	140.36	51193010.0
2017-06-13	IWM	ETF	141.8	142.31	141.47	142.1	22046800.0
2017-06-13	DIA	ETF	212.8	213.39	212.75	213.37	2426500.0
2017-06-13	GLD	ETF	119.95	120.71	119.92	120.48	3786600.0
2017-06-13	TLT	ETF	124.01	124.52	123.99	124.38	4742600.0
2017-06-13	AADR	ETF	47.37	47.37	46.93	47.21	9900.0
2017-06-13	AAXJ	ETF	67.79	67.9	67.63	67.82	1393500.0
2017-06-13	ACSI	ETF	28.97	29.01	28.93	29.01	10721.0
2017-06-13	ACTX	ETF	100.3009	101.4809	94.4008	96.0529	904.0
2017-06-13	ACWF	ETF	27.4099	27.45	27.4099	27.45	11674.0
2017-06-13	ACWI	ETF	66.38	66.51	66.27	66.48	850700.0
2017-06-13	ACWV	ETF	80.45	80.63	80.36	80.62	89000.0
2017-06-13	ACWX	ETF	46.3	46.37	46.22	46.35	258144.0
2017-06-13	ADRE	ETF	38.6	38.6144	38.334	38.4564	3385.0
2017-06-13	AFK	ETF	21.9429	21.99	21.83	21.99	4657.0
2017-06-13	AFTY	ETF	15.14	15.14	15.14	15.14	600.0
2017-06-13	AGG	ETF	109.43	109.6	109.43	109.59	1474300.0
2017-06-13	AGGY	ETF	50.54	50.65	50.54	50.65	8800.0
2017-06-13	AGQ	ETF	34.38	35.07	34.33	34.92	163500.0
2017-06-13	AGZ	ETF	113.5653	113.779	113.5653	113.72	8490.0
2017-06-13	AGZD	ETF	23.95	23.97	23.95	23.97	600.0
2017-06-13	AIA	ETF	56.69	56.98	56.69	56.93	36315.0
2017-06-13	AIQ	ETF	13.2	13.25	13.1	13.15	23027.0
2017-06-13	AIRR	ETF	24.08	24.21	24.0	24.08	40200.0
2017-06-13	AIVI	ETF	41.8	41.95	41.8	41.92	8900.0
2017-06-13	ALTY	ETF	15.56	15.58	15.4	15.58	4300.0
2017-06-13	AMJ	ETF	29.38	29.57	29.35	29.4	1530260.0
2017-06-13	AMLP	ETF	59.35	59.4	59.05	59.2	1187580.0
2017-06-13	AMZA	ETF	98.9	99.3	98.3	98.7	58330.0
2017-06-13	ANGL	ETF	29.69	29.76	29.66	29.76	124800.0
2017-06-13	AOA	ETF	51.94	52.05	51.89	52.02	83100.0
2017-06-13	AOK	ETF	34.02	34.09	33.9801	34.08	63914.0
2017-06-13	AOM	ETF	37.34	37.4	37.2776	37.32	73312.0
2017-06-13	AOR	ETF	43.7	43.8299	43.7	43.76	75204.0
2017-06-13	ARCM	ETF	100.245	100.245	100.245	100.245	40.0
2017-06-13	ARGT	ETF	29.82	30.03	29.73	29.96	152400.0
2017-06-13	ARKG	ETF	21.06	21.37	21.05	21.37	7400.0
2017-06-13	ARKK	ETF	28.37	28.76	28.37	28.71	59200.0
2017-06-13	ARKQ	ETF	28.71	28.871	28.5	28.86	33000.0
2017-06-13	ARKW	ETF	34.85	35.2	34.8	35.12	68600.0
2017-06-13	ASEA	ETF	15.2	15.2	15.15	15.15	1400.0
2017-06-13	ASET	ETF	27.74	27.74	27.74	27.74	209.0
2017-06-13	ASHR	ETF	26.44	26.51	26.39	26.49	426800.0
2017-06-13	ASHS	ETF	31.94	32.1	31.94	32.1	12000.0
2017-06-13	ASHX	ETF	20.1511	20.1511	20.1511	20.1511	1000.0
2017-06-13	ATMP	ETF	22.08	22.08	21.85	21.89	114400.0
2017-06-13	BAB	ETF	29.96	30.02	29.96	30.01	169424.0
2017-06-13	BAL	ETF	47.59	47.59	47.39	47.55	7560.0
2017-06-13	BBC	ETF	22.16	22.31	22.07	22.31	4088.0

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

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