PREVIEW / etf_daily / 2014-09-18

all etf daily files

  file:    by_date/etf_daily/2014/2014-09-18.parquet
  size:    45 KB
  rows:    1,120

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
2014-09-18	SPY	ETF	201.36	201.85	201.1	201.82	94990000.0
2014-09-18	QQQ	ETF	99.83	100.29	99.73	100.28	30196722.0
2014-09-18	IWM	ETF	115.24	115.53	114.91	115.43	24714600.0
2014-09-18	DIA	ETF	172.01	172.8	171.9	172.61	6458100.0
2014-09-18	GLD	ETF	117.41	118.09	117.19	117.78	5368700.0
2014-09-18	TLT	ETF	113.18	113.48	112.85	113.16	7031200.0
2014-09-18	AADR	ETF	38.15	38.48	38.15	38.44	4600.0
2014-09-18	AAXJ	ETF	64.15	64.21	63.98	64.13	600900.0
2014-09-18	ACWI	ETF	60.45	60.66	60.45	60.63	459000.0
2014-09-18	ACWV	ETF	67.84	67.84	67.58	67.7	100700.0
2014-09-18	ACWX	ETF	47.18	47.23	47.07	47.16	216247.0
2014-09-18	ADRE	ETF	42.1	42.326	42.087	42.2053	12916.0
2014-09-18	AFK	ETF	32.25	32.43	32.22	32.42	21715.0
2014-09-18	AGG	ETF	108.5	108.55	108.45	108.5	707600.0
2014-09-18	AGQ	ETF	53.95	55.21	53.75	54.53	192800.0
2014-09-18	AGZ	ETF	112.16	112.22	111.9601	112.11	8777.0
2014-09-18	AGZD	ETF	24.93	24.93	24.9	24.92	9200.0
2014-09-18	AIA	ETF	49.1	49.125	49.01	49.06	28375.0
2014-09-18	AIQ	ETF	24.8	24.93	24.08	24.72	11830.0
2014-09-18	AIRR	ETF	19.35	19.44	19.34	19.42	12600.0
2014-09-18	AIVI	ETF	48.87	48.87	48.49	48.8	15400.0
2014-09-18	AMJ	ETF	53.28	53.53	52.83	53.43	1921025.0
2014-09-18	AMLP	ETF	95.55	96.05	95.05	95.9	608680.0
2014-09-18	ANGL	ETF	27.85	27.94	27.8	27.86	3600.0
2014-09-18	AOA	ETF	46.8	46.8	46.68	46.78	28200.0
2014-09-18	AOK	ETF	32.75	32.75	32.7194	32.74	17380.0
2014-09-18	AOM	ETF	35.57	35.57	35.34	35.38	29219.0
2014-09-18	AOR	ETF	40.32	40.32	39.7501	40.19	37311.0
2014-09-18	ARGT	ETF	21.77	21.9	21.77	21.81	26600.0
2014-09-18	ASEA	ETF	17.02	17.07	17.02	17.05	2700.0
2014-09-18	ASHR	ETF	25.34	25.42	25.32	25.38	217500.0
2014-09-18	ASHS	ETF	32.34	32.39	32.31	32.39	7500.0
2014-09-18	ATMP	ETF	32.14	32.46	32.14	32.45	25700.0
2014-09-18	AVIV	ETF	27.73	27.73	27.34	27.47	187699.0
2014-09-18	AWAY	ETF	33.0	34.92	33.0	33.55	1289013.0
2014-09-18	BAB	ETF	29.35	29.4299	29.27	29.31	128634.0
2014-09-18	BAL	ETF	43.74	43.9599	43.35	43.81	12895.0
2014-09-18	BALT	ETF	5.4	5.55	5.38	5.46	331162.0
2014-09-18	BAR	ETF	3.1246	3.181	3.122	3.178	111170.0
2014-09-18	BBH	ETF	106.0	106.64	105.38	106.64	83200.0
2014-09-18	BCHP	ETF	20.199	20.199	20.19	20.19	800.0
2014-09-18	BCM	ETF	37.74	37.74	37.64	37.64	803.0
2014-09-18	BFOR	ETF	7.8325	7.85	7.8325	7.84	81600.0
2014-09-18	BIB	ETF	52.075	52.625	51.725	52.6	367008.0
2014-09-18	BICK	ETF	26.7147	26.7147	26.641	26.641	1223.0
2014-09-18	BIL	ETF	91.52	91.52	91.5	91.52	92100.0
2014-09-18	BIS	ETF	480.4	486.524	478.8	478.804	5359.0
2014-09-18	BIV	ETF	83.69	83.76	83.61	83.74	251500.0
2014-09-18	BIZD	ETF	20.3	20.3	20.22	20.22	15800.0
2014-09-18	BJK	ETF	44.39	45.0	44.39	44.84	15800.0

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

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