PREVIEW / etf_daily / 2016-06-21

all etf daily files

  file:    by_date/etf_daily/2016/2016-06-21.parquet
  size:    50 KB
  rows:    1,268

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-06-21	SPY	ETF	208.3	208.92	207.78	208.44	72461700.0
2016-06-21	QQQ	ETF	107.33	107.715	107.1	107.5	22804112.0
2016-06-21	IWM	ETF	115.34	115.41	114.33	115.08	34706800.0
2016-06-21	DIA	ETF	178.12	178.53	177.73	178.06	1854700.0
2016-06-21	GLD	ETF	121.65	121.86	120.77	120.84	14585600.0
2016-06-21	TLT	ETF	134.29	134.58	133.46	133.54	6005800.0
2016-06-21	AADR	ETF	39.91	40.29	39.0	40.02	1200.0
2016-06-21	AAXJ	ETF	54.01	54.33	53.84	54.15	630700.0
2016-06-21	ACTX	ETF	3.54	4.13	3.54	4.13	272.0
2016-06-21	ACWF	ETF	23.26	23.26	23.26	23.26	400.0
2016-06-21	ACWI	ETF	57.08	57.38	56.94	57.15	1247200.0
2016-06-21	ACWV	ETF	75.12	75.32	74.93	75.09	533800.0
2016-06-21	ACWX	ETF	40.23	40.5	40.07	40.26	440067.0
2016-06-21	ADRE	ETF	30.6	30.65	30.4501	30.636	12240.0
2016-06-21	AFK	ETF	19.9724	20.0979	19.7511	19.88	2519.0
2016-06-21	AGG	ETF	111.55	111.57	111.35	111.4	1882500.0
2016-06-21	AGGY	ETF	51.19	51.2	51.05	51.11	5600.0
2016-06-21	AGNG	ETF	15.41	15.41	15.41	15.41	500.0
2016-06-21	AGQ	ETF	40.62	40.8	40.0	40.33	138500.0
2016-06-21	AGZ	ETF	115.2617	115.32	115.1001	115.14	15010.0
2016-06-21	AGZD	ETF	23.86	23.86	23.8	23.8	3400.0
2016-06-21	AIA	ETF	43.74	43.96	43.63	43.93	15633.0
2016-06-21	AIQ	ETF	6.26	6.2725	6.1	6.2	20545.0
2016-06-21	AIRR	ETF	18.416	18.416	18.35	18.404	3900.0
2016-06-21	AIVI	ETF	38.03	38.41	37.89	38.19	15300.0
2016-06-21	ALTY	ETF	14.826	14.826	14.826	14.826	200.0
2016-06-21	AMJ	ETF	30.78	31.62	30.78	31.57	4020660.0
2016-06-21	AMLP	ETF	62.5	63.85	62.4	63.7	1221800.0
2016-06-21	AMZA	ETF	111.9	115.2	111.0	115.0	21760.0
2016-06-21	ANGL	ETF	27.41	27.47	27.33	27.43	87900.0
2016-06-21	AOA	ETF	45.97	46.15	45.85	45.95	27300.0
2016-06-21	AOK	ETF	32.79	32.79	32.593	32.67	66469.0
2016-06-21	AOM	ETF	35.26	35.3086	35.1201	35.25	130361.0
2016-06-21	AOR	ETF	39.89	40.1099	39.89	39.97	47085.0
2016-06-21	ARGT	ETF	22.29	22.29	21.93	22.02	42900.0
2016-06-21	ARKG	ETF	16.83	16.94	16.83	16.94	300.0
2016-06-21	ARKK	ETF	19.49	19.61	19.49	19.58	2800.0
2016-06-21	ARKQ	ETF	19.97	19.97	19.76	19.76	600.0
2016-06-21	ARKW	ETF	22.78	22.78	22.47	22.47	1700.0
2016-06-21	ASEA	ETF	13.23	13.34	13.23	13.34	5200.0
2016-06-21	ASHR	ETF	23.41	23.45	23.31	23.35	520200.0
2016-06-21	ASHS	ETF	32.9	33.06	32.77	33.02	53700.0
2016-06-21	ATMP	ETF	21.51	22.04	21.51	22.04	10800.0
2016-06-21	BAB	ETF	31.09	31.12	30.91	30.94	176498.0
2016-06-21	BAL	ETF	42.76	42.77	42.3	42.6742	30662.0
2016-06-21	BBC	ETF	18.58	18.58	18.045	18.34	4766.0
2016-06-21	BBH	ETF	102.34	102.34	100.11	100.71	87200.0
2016-06-21	BBP	ETF	26.5	26.5	25.95	26.32	3200.0
2016-06-21	BCM	ETF	27.4	27.483	27.336	27.45	4747.0
2016-06-21	BFOR	ETF	7.6275	7.6275	7.56	7.59	19200.0

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

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