PREVIEW / etf_daily / 2016-01-22

all etf daily files

  file:    by_date/etf_daily/2016/2016-01-22.parquet
  size:    50 KB
  rows:    1,242

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-01-22	SPY	ETF	189.78	190.76	188.88	190.52	168319600.0
2016-01-22	QQQ	ETF	102.84	103.81	102.5305	103.77	42229803.0
2016-01-22	IWM	ETF	100.65	101.61	100.13	101.37	46056700.0
2016-01-22	DIA	ETF	160.91	161.24	159.62	160.79	7390600.0
2016-01-22	GLD	ETF	104.93	105.51	104.76	105.0	4185300.0
2016-01-22	TLT	ETF	124.91	125.53	124.52	125.34	10164300.0
2016-01-22	AADR	ETF	35.6	35.85	35.6	35.85	800.0
2016-01-22	AAXJ	ETF	48.56	48.67	48.27	48.61	1215700.0
2016-01-22	ACTX	ETF	6.9621	6.9621	6.4901	6.4901	221.0
2016-01-22	ACWF	ETF	21.26	21.2601	21.26	21.2601	272.0
2016-01-22	ACWI	ETF	51.54	51.9	51.45	51.82	3822500.0
2016-01-22	ACWV	ETF	66.02	66.37	65.73	66.28	211300.0
2016-01-22	ACWX	ETF	36.32	36.57	36.28	36.54	1820919.0
2016-01-22	ADRE	ETF	26.38	26.6999	26.26	26.46	10949.0
2016-01-22	AFK	ETF	15.45	15.6	15.36	15.58	96183.0
2016-01-22	AFTY	ETF	12.21	12.301	12.21	12.27	12200.0
2016-01-22	AGG	ETF	108.72	108.85	108.59	108.84	3258700.0
2016-01-22	AGGY	ETF	49.48	49.51	49.435	49.51	28700.0
2016-01-22	AGQ	ETF	28.56	29.04	27.79	27.82	236600.0
2016-01-22	AGZ	ETF	113.68	113.7099	113.4	113.59	35439.0
2016-01-22	AGZD	ETF	23.8	23.825	23.755	23.82	5800.0
2016-01-22	AIA	ETF	38.27	38.384	38.1634	38.29	39309.0
2016-01-22	AIQ	ETF	7.01	7.29	6.94	7.12	20892.0
2016-01-22	AIRR	ETF	14.67	14.88	14.58	14.583	4500.0
2016-01-22	AIVI	ETF	35.85	35.97	35.75	35.96	72000.0
2016-01-22	ALTY	ETF	12.856	12.856	12.856	12.856	300.0
2016-01-22	AMJ	ETF	23.3	24.77	23.28	24.22	7624133.0
2016-01-22	AMLP	ETF	47.5	50.45	47.3	49.6	5355520.0
2016-01-22	AMZA	ETF	80.0	84.98	76.1	84.9	16900.0
2016-01-22	ANGL	ETF	23.28	23.99	23.28	23.68	35800.0
2016-01-22	AOA	ETF	42.16	42.28	42.0	42.28	315400.0
2016-01-22	AOK	ETF	30.96	31.0199	30.87	30.95	73852.0
2016-01-22	AOM	ETF	33.17	33.17	33.01	33.11	250571.0
2016-01-22	AOR	ETF	36.97	37.17	36.97	37.15	569390.0
2016-01-22	ARGT	ETF	16.03	16.47	16.03	16.47	12300.0
2016-01-22	ARKG	ETF	17.91	18.001	17.9	17.91	15500.0
2016-01-22	ARKK	ETF	17.589	17.589	17.53	17.53	400.0
2016-01-22	ARKQ	ETF	16.56	16.56	16.56	16.56	100.0
2016-01-22	ARKW	ETF	19.722	19.722	19.722	19.722	200.0
2016-01-22	ASEA	ETF	11.46	11.55	11.46	11.49	3300.0
2016-01-22	ASET	ETF	22.9	22.97	22.9	22.97	200.0
2016-01-22	ASHR	ETF	23.41	23.47	23.25	23.44	1002200.0
2016-01-22	ASHS	ETF	32.29	32.49	32.18	32.23	44700.0
2016-01-22	ASHX	ETF	21.24	21.32	21.24	21.32	2800.0
2016-01-22	ATMP	ETF	15.85	16.4	15.7	16.4	41100.0
2016-01-22	BAB	ETF	29.68	29.76	29.6	29.74	177710.0
2016-01-22	BAL	ETF	41.4512	41.4512	41.4	41.4001	5086.0
2016-01-22	BBC	ETF	21.67	21.67	20.8401	21.22	18853.0
2016-01-22	BBH	ETF	108.26	109.81	107.48	109.57	176500.0
2016-01-22	BBP	ETF	25.7	25.83	25.36	25.59	11500.0

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

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