PREVIEW / etf_daily / 2016-07-01

all etf daily files

  file:    by_date/etf_daily/2016/2016-07-01.parquet
  size:    51 KB
  rows:    1,288

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-07-01	SPY	ETF	209.48	210.49	209.29	209.92	106055300.0
2016-07-01	QQQ	ETF	107.49	108.48	107.45	108.08	19902803.0
2016-07-01	IWM	ETF	115.05	115.95	114.8	115.39	24401900.0
2016-07-01	DIA	ETF	178.78	179.8	178.78	179.31	3998200.0
2016-07-01	GLD	ETF	127.66	128.42	127.44	128.41	14940700.0
2016-07-01	TLT	ETF	140.81	140.82	139.19	140.57	15430200.0
2016-07-01	AADR	ETF	39.4	39.41	39.4	39.4	800.0
2016-07-01	AAXJ	ETF	55.2	55.29	55.02	55.12	490000.0
2016-07-01	ACTX	ETF	4.72	4.72	4.13	4.13	141.0
2016-07-01	ACWF	ETF	22.9	22.9093	22.9	22.9093	575.0
2016-07-01	ACWI	ETF	56.22	56.49	56.2	56.35	1466300.0
2016-07-01	ACWV	ETF	76.62	76.84	76.53	76.72	261700.0
2016-07-01	ACWX	ETF	39.05	39.19	39.03	39.09	899824.0
2016-07-01	ADRE	ETF	31.46	31.52	31.3301	31.39	7014.0
2016-07-01	AFK	ETF	20.02	20.38	20.02	20.34	3674.0
2016-07-01	AFTY	ETF	12.383	12.383	12.38	12.38	500.0
2016-07-01	AGG	ETF	112.72	112.77	112.52	112.65	5235200.0
2016-07-01	AGGY	ETF	52.04	52.04	51.8	52.04	2300.0
2016-07-01	AGQ	ETF	49.95	53.26	49.73	52.25	1144200.0
2016-07-01	AGZ	ETF	115.89	115.96	115.681	115.96	10262.0
2016-07-01	AGZD	ETF	23.815	23.82	23.77	23.77	2200.0
2016-07-01	AIA	ETF	45.0	45.25	45.0	45.17	14035.0
2016-07-01	AIQ	ETF	6.25	6.5	6.1	6.26	36743.0
2016-07-01	AIRR	ETF	18.34	18.649	18.34	18.452	3700.0
2016-07-01	AIVI	ETF	37.85	37.98	37.81	37.9	12900.0
2016-07-01	ALTY	ETF	15.14	15.16	15.12	15.14	1300.0
2016-07-01	AMJ	ETF	32.17	32.17	31.37	31.54	2237168.0
2016-07-01	AMLP	ETF	63.6	64.3	63.6	63.8	1121860.0
2016-07-01	AMZA	ETF	116.0	116.41	114.2	114.8	25110.0
2016-07-01	ANGL	ETF	27.59	27.8	27.59	27.68	266100.0
2016-07-01	AOA	ETF	45.71	46.13	45.71	46.01	21700.0
2016-07-01	AOK	ETF	32.87	33.0699	32.8	32.955	29215.0
2016-07-01	AOM	ETF	35.37	35.5	35.37	35.44	22669.0
2016-07-01	AOR	ETF	40.12	40.21	40.05	40.17	211877.0
2016-07-01	ARGT	ETF	22.4	22.53	22.3	22.43	148500.0
2016-07-01	ARKG	ETF	16.8	17.074	16.8	17.074	300.0
2016-07-01	ARKK	ETF	19.451	19.451	19.451	19.451	100.0
2016-07-01	ARKQ	ETF	19.37	19.37	19.37	19.37	100.0
2016-07-01	ARKW	ETF	22.53	22.53	22.53	22.53	500.0
2016-07-01	ASEA	ETF	13.69	13.7	13.46	13.69	1500.0
2016-07-01	ASET	ETF	26.79	26.79	26.79	26.79	100.0
2016-07-01	ASHR	ETF	23.65	23.67	23.55	23.59	728200.0
2016-07-01	ASHS	ETF	33.95	33.95	33.86	33.88	24300.0
2016-07-01	ASHX	ETF	21.6	21.6	21.6	21.6	200.0
2016-07-01	ATMP	ETF	22.03	22.31	21.93	22.03	29700.0
2016-07-01	BAB	ETF	31.6	31.68	31.4801	31.57	315354.0
2016-07-01	BAL	ETF	42.84	43.16	42.65	43.16	7948.0
2016-07-01	BBC	ETF	18.213	18.64	18.213	18.64	11238.0
2016-07-01	BBH	ETF	102.14	104.71	102.08	104.39	83500.0
2016-07-01	BBP	ETF	27.06	27.57	27.06	27.4	5000.0

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

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