PREVIEW / etf_daily / 2016-11-23

all etf daily files

  file:    by_date/etf_daily/2016/2016-11-23.parquet
  size:    53 KB
  rows:    1,339

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
2016-11-23	SPY	ETF	219.98	220.76	219.75	220.7	56620200.0
2016-11-23	QQQ	ETF	118.51	118.64	117.9	118.42	22925954.0
2016-11-23	IWM	ETF	132.48	133.65	132.1	133.63	37939200.0
2016-11-23	DIA	ETF	189.93	190.64	189.87	190.59	2465900.0
2016-11-23	GLD	ETF	113.87	113.88	112.65	113.25	20982100.0
2016-11-23	TLT	ETF	119.99	120.91	119.25	120.64	13563500.0
2016-11-23	AADR	ETF	41.2	41.2	40.45	40.79	15500.0
2016-11-23	AAXJ	ETF	56.12	56.26	56.0	56.23	604400.0
2016-11-23	ACSI	ETF	26.59	26.63	26.5585	26.59	15359.0
2016-11-23	ACTX	ETF	37.1703	38.3503	27.1402	31.8603	3765.0
2016-11-23	ACWF	ETF	24.22	24.37	24.1594	24.1594	2620.0
2016-11-23	ACWI	ETF	58.38	58.57	58.21	58.57	1868700.0
2016-11-23	ACWV	ETF	72.4	72.64	72.33	72.57	487500.0
2016-11-23	ACWX	ETF	39.53	39.775	39.495	39.75	1201183.0
2016-11-23	ADRE	ETF	33.02	33.08	32.9195	33.08	9197.0
2016-11-23	AFK	ETF	19.67	19.9402	19.1801	19.38	5093.0
2016-11-23	AFTY	ETF	13.71	13.71	13.71	13.71	200.0
2016-11-23	AGG	ETF	108.18	108.33	107.92	108.18	2497600.0
2016-11-23	AGGY	ETF	49.66	49.794	49.64	49.69	16200.0
2016-11-23	AGNG	ETF	15.265	15.265	15.265	15.265	100.0
2016-11-23	AGQ	ETF	34.26	34.66	33.48	34.27	199200.0
2016-11-23	AGZ	ETF	113.2	113.2986	112.9801	113.19	13150.0
2016-11-23	AIA	ETF	47.54	47.67	47.52	47.67	30351.0
2016-11-23	AIQ	ETF	7.4	7.5	7.3	7.4	10678.0
2016-11-23	AIRR	ETF	23.03	23.235	22.863	23.23	324000.0
2016-11-23	AIVI	ETF	36.04	36.27	35.93	36.25	90300.0
2016-11-23	ALTY	ETF	14.75	14.826	14.75	14.825	3000.0
2016-11-23	AMJ	ETF	30.65	30.92	30.5801	30.85	2243084.0
2016-11-23	AMLP	ETF	61.5	61.7	61.2	61.55	1129740.0
2016-11-23	AMUB	ETF	19.4599	19.4599	19.4215	19.4215	300.0
2016-11-23	AMZA	ETF	109.4	109.8	108.8	109.5	10410.0
2016-11-23	ANGL	ETF	28.36	28.6	28.32	28.56	107000.0
2016-11-23	AOA	ETF	46.77	46.77	46.53	46.73	99700.0
2016-11-23	AOK	ETF	32.41	32.42	32.24	32.35	101217.0
2016-11-23	AOM	ETF	35.17	35.17	34.9183	35.02	213191.0
2016-11-23	AOR	ETF	40.27	40.27	40.0101	40.19	166237.0
2016-11-23	ARGT	ETF	23.04	23.32	23.04	23.28	27700.0
2016-11-23	ARKG	ETF	18.31	18.538	18.31	18.518	90500.0
2016-11-23	ARKK	ETF	20.83	20.83	20.83	20.83	200.0
2016-11-23	ARKQ	ETF	21.9	22.09	21.9	22.09	500.0
2016-11-23	ARKW	ETF	25.784	25.784	25.77	25.77	400.0
2016-11-23	ASEA	ETF	12.84	12.88	12.83	12.86	4400.0
2016-11-23	ASET	ETF	24.97	24.97	24.97	24.97	206.0
2016-11-23	ASHR	ETF	25.23	25.3	25.15	25.25	798700.0
2016-11-23	ASHS	ETF	34.48	34.76	34.48	34.74	1200.0
2016-11-23	ASHX	ETF	23.8439	23.9151	23.8439	23.9151	546.0
2016-11-23	ATMP	ETF	22.98	23.27	22.98	23.18	80600.0
2016-11-23	BAB	ETF	29.25	29.299	29.1	29.28	224148.0
2016-11-23	BAL	ETF	47.0	47.4	47.0	47.23	32515.0
2016-11-23	BBC	ETF	20.38	21.5	20.2501	21.5	7634.0

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

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