PREVIEW / etf_daily / 2016-04-01

all etf daily files

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

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-04-01	SPY	ETF	204.35	207.14	203.98	206.92	114423500.0
2016-04-01	QQQ	ETF	108.58	110.4	108.39	110.36	26389045.0
2016-04-01	IWM	ETF	109.61	111.22	109.48	111.12	29981400.0
2016-04-01	DIA	ETF	175.71	177.85	175.41	177.72	4035200.0
2016-04-01	GLD	ETF	116.08	116.98	115.55	116.93	10405400.0
2016-04-01	TLT	ETF	130.98	131.13	129.9	130.68	9341400.0
2016-04-01	AAXJ	ETF	53.57	54.42	53.4	54.31	889000.0
2016-04-01	ACTX	ETF	6.4901	6.4901	5.9001	6.4901	731.0
2016-04-01	ACWF	ETF	22.8301	22.8301	22.83	22.83	534.0
2016-04-01	ACWI	ETF	55.36	56.05	55.26	56.02	3811200.0
2016-04-01	ACWV	ETF	72.8	73.61	72.76	73.6	788000.0
2016-04-01	ACWX	ETF	38.71	39.18	38.64	39.15	461129.0
2016-04-01	ADRE	ETF	30.56	31.0399	30.42	31.0299	7040.0
2016-04-01	AFK	ETF	18.94	19.33	18.3	19.33	49255.0
2016-04-01	AFTY	ETF	12.91	12.99	12.91	12.98	15600.0
2016-04-01	AGG	ETF	110.53	110.66	110.35	110.51	5374200.0
2016-04-01	AGGY	ETF	50.5	50.61	50.5	50.59	3700.0
2016-04-01	AGQ	ETF	31.02	31.51	30.2	31.39	401700.0
2016-04-01	AGZ	ETF	114.5852	114.72	114.52	114.57	13531.0
2016-04-01	AGZD	ETF	23.715	24.06	23.715	23.865	6600.0
2016-04-01	AIA	ETF	42.42	42.96	42.3	42.96	22701.0
2016-04-01	AIQ	ETF	6.95	7.09	6.95	7.0	7043.0
2016-04-01	AIRR	ETF	17.355	17.542	17.355	17.542	1000.0
2016-04-01	AIVI	ETF	37.49	37.98	37.49	37.89	14100.0
2016-04-01	ALTY	ETF	14.188	14.279	14.188	14.279	500.0
2016-04-01	AMJ	ETF	26.8	26.92	26.04	26.38	1634905.0
2016-04-01	AMLP	ETF	53.5	53.85	52.35	53.0	1695040.0
2016-04-01	AMZA	ETF	90.0	91.82	88.0	88.5	10410.0
2016-04-01	ANGL	ETF	25.64	25.73	25.52	25.61	34100.0
2016-04-01	AOA	ETF	44.93	45.28	44.79	45.25	68600.0
2016-04-01	AOK	ETF	32.16	32.31	32.13	32.29	204435.0
2016-04-01	AOM	ETF	34.65	34.79	34.53	34.77	45892.0
2016-04-01	AOR	ETF	39.16	39.407	39.1	39.37	33444.0
2016-04-01	ARGT	ETF	19.1	19.28	19.0	19.2	61700.0
2016-04-01	ARKG	ETF	17.88	17.88	17.84	17.84	1400.0
2016-04-01	ARKQ	ETF	18.81	18.81	18.81	18.81	100.0
2016-04-01	ARKW	ETF	20.63	20.76	20.63	20.76	1300.0
2016-04-01	ASEA	ETF	13.33	13.52	13.23	13.52	6400.0
2016-04-01	ASET	ETF	25.31	25.31	25.28	25.28	406.0
2016-04-01	ASHR	ETF	24.3	24.77	24.3	24.7	1596600.0
2016-04-01	ASHS	ETF	34.32	34.75	34.32	34.67	18700.0
2016-04-01	ASHX	ETF	21.8001	21.8001	21.8001	21.8001	222.0
2016-04-01	ATMP	ETF	17.83	17.83	17.41	17.57	43300.0
2016-04-01	BAB	ETF	30.22	30.3	30.04	30.12	507189.0
2016-04-01	BAL	ETF	38.17	38.84	38.17	38.79	10129.0
2016-04-01	BBC	ETF	18.87	19.58	18.87	19.5525	9797.0
2016-04-01	BBH	ETF	103.33	106.43	102.67	106.23	117400.0
2016-04-01	BBP	ETF	24.19	25.05	24.19	25.04	5200.0
2016-04-01	BCM	ETF	24.08	24.1299	24.08	24.1299	938.0
2016-04-01	BFOR	ETF	7.515	7.58	7.4875	7.57	37600.0

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

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