PREVIEW / etf_daily / 2015-04-17

all etf daily files

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

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-17	SPY	ETF	208.94	209.23	207.01	207.95	191113200.0
2015-04-17	QQQ	ETF	106.66	106.95	105.55	106.01	46513964.0
2015-04-17	IWM	ETF	125.12	125.55	123.82	124.43	48283500.0
2015-04-17	DIA	ETF	179.27	179.41	177.16	177.94	8683500.0
2015-04-17	GLD	ETF	115.38	115.79	115.23	115.6	3496300.0
2015-04-17	TLT	ETF	129.77	131.7	129.7	131.45	7268800.0
2015-04-17	AAXJ	ETF	67.62	67.97	67.35	67.85	1668400.0
2015-04-17	ACWI	ETF	61.6	61.76	61.16	61.42	1030200.0
2015-04-17	ACWV	ETF	72.96	73.13	72.53	72.79	141000.0
2015-04-17	ACWX	ETF	46.36	46.47	46.21	46.41	210031.0
2015-04-17	ADRE	ETF	36.81	36.81	36.56	36.63	10707.0
2015-04-17	AFK	ETF	26.47	26.65	26.081	26.22	29286.0
2015-04-17	AFTY	ETF	21.61	21.64	21.2	21.48	107600.0
2015-04-17	AGG	ETF	111.53	111.8	111.46	111.67	1274300.0
2015-04-17	AGQ	ETF	39.96	40.15	39.49	39.64	71900.0
2015-04-17	AGZ	ETF	114.32	114.65	114.32	114.53	17061.0
2015-04-17	AGZD	ETF	24.52	24.585	24.515	24.54	12400.0
2015-04-17	AIA	ETF	52.7	52.93	52.2052	52.82	62403.0
2015-04-17	AIQ	ETF	23.74	24.12	23.74	24.0	12612.0
2015-04-17	AIRR	ETF	18.95	18.95	18.78	18.8	4600.0
2015-04-17	AIVI	ETF	45.09	45.13	44.85	45.11	43900.0
2015-04-17	ALTL	ETF	37.32	37.32	37.32	37.32	300.0
2015-04-17	AMJ	ETF	44.43	44.72	44.13	44.2	956881.0
2015-04-17	AMLP	ETF	84.85	84.95	84.4	84.55	1491380.0
2015-04-17	AMZA	ETF	219.5	219.5	218.4	218.4	960.0
2015-04-17	ANGL	ETF	27.62	27.63	27.57	27.62	5500.0
2015-04-17	AOA	ETF	48.44	48.51	47.94	48.13	52200.0
2015-04-17	AOK	ETF	33.26	33.27	33.13	33.21	26128.0
2015-04-17	AOM	ETF	36.01	36.01	35.81	35.94	68668.0
2015-04-17	AOR	ETF	41.46	41.46	41.1793	41.3	68623.0
2015-04-17	ARGT	ETF	21.56	21.72	21.55	21.6	8900.0
2015-04-17	ARKG	ETF	23.75	23.75	23.25	23.366	21700.0
2015-04-17	ARKK	ETF	21.53	21.53	21.4	21.4	1200.0
2015-04-17	ARKQ	ETF	20.433	20.433	20.25	20.27	7700.0
2015-04-17	ARKW	ETF	22.92	22.92	22.356	22.37	10300.0
2015-04-17	ASEA	ETF	16.18	16.19	16.16	16.19	5700.0
2015-04-17	ASHR	ETF	44.42	44.59	44.23	44.48	3357900.0
2015-04-17	ASHS	ETF	51.56	51.56	48.71	49.14	212600.0
2015-04-17	ATMP	ETF	30.27	30.32	30.13	30.16	29200.0
2015-04-17	AWAY	ETF	32.48	32.8	31.9	32.62	1507932.0
2015-04-17	BAB	ETF	30.32	30.56	30.28	30.54	114470.0
2015-04-17	BAL	ETF	43.65	43.65	42.88	42.99	10242.0
2015-04-17	BALT	ETF	1.42	1.57	1.41	1.49	1053389.0
2015-04-17	BAR	ETF	2.7944	2.7945	2.783	2.784	18430.0
2015-04-17	BBC	ETF	35.27	35.29	34.0	34.45	51824.0
2015-04-17	BBH	ETF	133.98	133.98	131.32	132.01	125900.0
2015-04-17	BBP	ETF	32.9	33.02	32.7	32.874	19300.0
2015-04-17	BCHP	ETF	19.77	19.79	19.77	19.79	2153.0
2015-04-17	BCM	ETF	31.93	31.93	31.816	31.824	2600.0
2015-04-17	BFOR	ETF	8.45	8.45	8.3525	8.3775	56800.0

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

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