PREVIEW / etf_daily / 2014-09-11

all etf daily files

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

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-11	SPY	ETF	199.27	200.33	199.12	200.3	66774400.0
2014-09-11	QQQ	ETF	99.65	100.04	99.24	99.99	28761940.0
2014-09-11	IWM	ETF	115.17	116.73	115.14	116.61	27075600.0
2014-09-11	DIA	ETF	169.89	170.62	169.82	170.51	3026200.0
2014-09-11	GLD	ETF	119.61	119.7	118.77	119.47	7612000.0
2014-09-11	TLT	ETF	115.26	115.54	114.57	114.58	9274800.0
2014-09-11	AADR	ETF	38.64	38.69	38.21	38.69	2100.0
2014-09-11	AAXJ	ETF	64.83	64.98	64.61	64.95	404100.0
2014-09-11	ACWI	ETF	60.32	60.43	60.21	60.4	2468900.0
2014-09-11	ACWV	ETF	67.89	67.89	67.56	67.77	76500.0
2014-09-11	ACWX	ETF	47.2	47.25	47.13	47.2	1810019.0
2014-09-11	ADRE	ETF	42.55	42.83	42.55	42.71	13284.0
2014-09-11	AFK	ETF	32.52	32.5388	32.35	32.37	39165.0
2014-09-11	AGG	ETF	109.01	109.06	108.83	108.85	753500.0
2014-09-11	AGQ	ETF	55.7	55.91	54.9	55.82	400200.0
2014-09-11	AGZ	ETF	112.25	112.35	112.24	112.24	4363.0
2014-09-11	AGZD	ETF	24.89	24.89	24.875	24.89	5200.0
2014-09-11	AIA	ETF	49.96	50.05	49.81	50.05	25566.0
2014-09-11	AIQ	ETF	26.46	27.04	26.01	26.18	52296.0
2014-09-11	AIRR	ETF	19.48	19.59	19.401	19.587	27700.0
2014-09-11	AIVI	ETF	48.87	48.87	48.58	48.71	9100.0
2014-09-11	AMJ	ETF	53.61	53.718	52.98	53.54	653886.0
2014-09-11	AMLP	ETF	96.2	96.2	95.45	96.15	564400.0
2014-09-11	ANGL	ETF	27.93	27.96	27.9	27.9	1800.0
2014-09-11	AOA	ETF	46.68	46.83	46.64	46.83	22500.0
2014-09-11	AOK	ETF	32.71	32.77	32.7001	32.77	16187.0
2014-09-11	AOM	ETF	35.35	35.43	35.35	35.43	44763.0
2014-09-11	AOR	ETF	40.16	40.23	40.082	40.23	58767.0
2014-09-11	ARGT	ETF	21.46	21.7	21.4	21.65	18700.0
2014-09-11	ASEA	ETF	17.31	17.31	17.26	17.29	5700.0
2014-09-11	ASHR	ETF	25.63	25.76	25.59	25.71	361200.0
2014-09-11	ASHS	ETF	32.19	32.26	32.18	32.26	3200.0
2014-09-11	ATMP	ETF	32.33	32.48	32.18	32.47	17600.0
2014-09-11	AVIV	ETF	28.01	28.26	27.91	28.24	173954.0
2014-09-11	AWAY	ETF	33.37	33.57	32.87	32.9	841313.0
2014-09-11	BAB	ETF	29.73	29.74	29.62	29.6612	119714.0
2014-09-11	BAL	ETF	44.67	45.84	44.67	45.69	43737.0
2014-09-11	BALT	ETF	5.96	5.99	5.835	5.88	231828.0
2014-09-11	BAR	ETF	3.316	3.316	3.255	3.255	28300.0
2014-09-11	BBH	ETF	106.32	106.32	105.13	106.08	27600.0
2014-09-11	BCHP	ETF	19.9801	19.9801	19.98	19.98	383.0
2014-09-11	BFOR	ETF	7.8025	7.8625	7.8025	7.8625	22000.0
2014-09-11	BIB	ETF	51.73	52.495	50.965	51.99	256598.0
2014-09-11	BICK	ETF	27.01	27.09	27.01	27.0828	10669.0
2014-09-11	BIL	ETF	91.5	91.52	91.5	91.5	70400.0
2014-09-11	BIS	ETF	485.2	497.2	482.42	486.0	7244.0
2014-09-11	BIV	ETF	84.23	84.27	84.08	84.1	324200.0
2014-09-11	BIZD	ETF	20.52	20.52	20.52	20.52	900.0
2014-09-11	BJK	ETF	45.7	45.93	45.66	45.8	6300.0
2014-09-11	BKF	ETF	40.56	40.72	40.5326	40.64	110971.0

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

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