PREVIEW / etf_daily / 2015-04-20

all etf daily files

  file:    by_date/etf_daily/2015/2015-04-20.parquet
  size:    48 KB
  rows:    1,183

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
2015-04-20	SPY	ETF	209.06	210.25	208.96	209.85	92189500.0
2015-04-20	QQQ	ETF	106.54	107.79	106.5	107.6	28945909.0
2015-04-20	IWM	ETF	125.05	125.95	124.83	125.65	24602300.0
2015-04-20	DIA	ETF	179.31	180.61	179.15	180.03	5355800.0
2015-04-20	GLD	ETF	114.82	114.95	114.32	114.72	3932800.0
2015-04-20	TLT	ETF	130.94	131.01	129.93	130.29	4949400.0
2015-04-20	AAXJ	ETF	67.84	68.1	67.67	67.95	726000.0
2015-04-20	ACWI	ETF	61.58	61.88	61.52	61.75	759900.0
2015-04-20	ACWV	ETF	73.08	73.33	73.08	73.12	109500.0
2015-04-20	ACWX	ETF	46.39	46.59	46.39	46.46	2882929.0
2015-04-20	ADRE	ETF	36.76	37.03	36.76	36.911	8485.0
2015-04-20	AFK	ETF	26.09	26.35	26.0705	26.11	46200.0
2015-04-20	AFTY	ETF	22.02	22.3	22.02	22.25	126800.0
2015-04-20	AGG	ETF	111.67	111.73	111.47	111.59	1289400.0
2015-04-20	AGQ	ETF	38.67	38.67	37.79	38.33	281000.0
2015-04-20	AGZ	ETF	114.58	114.58	114.247	114.31	7921.0
2015-04-20	AGZD	ETF	24.555	24.555	24.48	24.485	2000.0
2015-04-20	AIA	ETF	52.92	53.25	52.8601	53.19	20806.0
2015-04-20	AIQ	ETF	24.23	24.25	24.06	24.23	7727.0
2015-04-20	AIRR	ETF	19.08	19.08	18.82	18.84	6800.0
2015-04-20	AIVI	ETF	45.11	45.3	45.05	45.1	19200.0
2015-04-20	AMJ	ETF	44.2	44.7764	44.08	44.37	515858.0
2015-04-20	AMLP	ETF	84.8	85.35	84.6	84.95	535760.0
2015-04-20	AMZA	ETF	222.3	222.3	219.9	220.7	840.0
2015-04-20	ANGL	ETF	27.65	27.71	27.64	27.71	7900.0
2015-04-20	AOA	ETF	48.41	48.41	48.15	48.32	45400.0
2015-04-20	AOK	ETF	33.2	33.27	33.2	33.25	19425.0
2015-04-20	AOM	ETF	36.02	36.02	35.871	35.98	49313.0
2015-04-20	AOR	ETF	41.48	41.48	41.36	41.42	62760.0
2015-04-20	ARGT	ETF	21.73	21.74	21.61	21.61	3700.0
2015-04-20	ARKG	ETF	23.74	23.74	23.348	23.472	1500.0
2015-04-20	ARKK	ETF	21.5	21.5	21.5	21.5	100.0
2015-04-20	ARKQ	ETF	20.51	20.51	20.23	20.35	1300.0
2015-04-20	ARKW	ETF	22.67	22.67	22.54	22.67	1100.0
2015-04-20	ASEA	ETF	16.17	16.26	16.17	16.2	6300.0
2015-04-20	ASHR	ETF	46.09	46.47	45.83	46.44	2490600.0
2015-04-20	ASHS	ETF	51.0	51.95	51.0	51.95	149400.0
2015-04-20	ATMP	ETF	30.43	30.47	30.16	30.19	36100.0
2015-04-20	AWAY	ETF	32.63	32.838	31.59	31.66	1818136.0
2015-04-20	BAB	ETF	30.43	30.52	30.385	30.41	73341.0
2015-04-20	BAL	ETF	42.82	42.989	42.64	42.93	4522.0
2015-04-20	BALT	ETF	1.56	1.56	1.47	1.52	677667.0
2015-04-20	BAR	ETF	2.732	2.797	2.6852	2.733	18430.0
2015-04-20	BBC	ETF	34.87	34.9899	33.81	34.39	25642.0
2015-04-20	BBH	ETF	132.86	132.95	131.57	132.7	79100.0
2015-04-20	BBP	ETF	33.28	33.28	32.65	32.9	7500.0
2015-04-20	BCHP	ETF	19.89	19.94	19.88	19.89	1594.0
2015-04-20	BCM	ETF	31.65	31.65	31.64	31.64	550.0
2015-04-20	BFOR	ETF	8.4075	8.4775	8.4075	8.4575	76400.0
2015-04-20	BIB	ETF	86.3	86.555	84.06	85.755	791496.0

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

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