PREVIEW / etf_daily / 2014-09-12

all etf daily files

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

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-12	SPY	ETF	200.1	200.12	198.56	199.13	117409300.0
2014-09-12	QQQ	ETF	99.9	99.93	99.17	99.48	30445999.0
2014-09-12	IWM	ETF	116.55	116.56	114.97	115.37	32892900.0
2014-09-12	DIA	ETF	170.38	170.44	169.4	169.9	5000800.0
2014-09-12	GLD	ETF	118.63	118.9	118.07	118.38	8126500.0
2014-09-12	TLT	ETF	113.69	113.92	113.22	113.38	11114900.0
2014-09-12	AADR	ETF	38.18	38.18	38.18	38.18	100.0
2014-09-12	AAXJ	ETF	64.91	64.91	64.4	64.57	272300.0
2014-09-12	ACWI	ETF	60.3	60.31	59.97	60.1	850200.0
2014-09-12	ACWV	ETF	67.84	67.84	67.26	67.38	48100.0
2014-09-12	ACWX	ETF	47.17	47.17	46.54	47.06	769564.0
2014-09-12	ADRE	ETF	42.44	42.44	41.82	42.02	27134.0
2014-09-12	AFK	ETF	32.32	32.358	32.1999	32.25	64422.0
2014-09-12	AGG	ETF	108.69	108.74	108.6	108.63	1327600.0
2014-09-12	AGQ	ETF	54.94	55.5	54.62	55.44	217100.0
2014-09-12	AGZ	ETF	112.33	112.5799	112.1079	112.36	14078.0
2014-09-12	AGZD	ETF	24.99	25.005	24.93	25.005	10200.0
2014-09-12	AIA	ETF	50.07	50.07	49.64	49.83	23867.0
2014-09-12	AIQ	ETF	26.21	27.9199	25.7	25.98	23686.0
2014-09-12	AIRR	ETF	19.51	19.519	19.322	19.37	17900.0
2014-09-12	AIVI	ETF	48.83	48.83	48.51	48.63	12600.0
2014-09-12	ALTL	ETF	35.98	35.98	35.98	35.98	333.0
2014-09-12	AMJ	ETF	53.47	53.47	52.14	52.55	860453.0
2014-09-12	AMLP	ETF	96.05	96.05	94.3	94.8	682180.0
2014-09-12	ANGL	ETF	27.92	27.93	27.81	27.93	3300.0
2014-09-12	AOA	ETF	46.82	46.82	46.42	46.54	22200.0
2014-09-12	AOK	ETF	32.7	32.7023	32.65	32.66	23336.0
2014-09-12	AOM	ETF	35.47	35.47	35.234	35.29	41386.0
2014-09-12	AOR	ETF	40.1	40.1332	39.95	40.02	24352.0
2014-09-12	ARGT	ETF	21.66	21.89	21.56	21.86	32300.0
2014-09-12	ASEA	ETF	17.2	17.2	17.09	17.12	32800.0
2014-09-12	ASHR	ETF	25.82	25.87	25.68	25.74	539900.0
2014-09-12	ASHS	ETF	32.6	32.6	32.56	32.57	2000.0
2014-09-12	ATMP	ETF	32.55	32.55	31.7	31.88	13600.0
2014-09-12	AVIV	ETF	28.61	28.876	27.28	27.4	201464.0
2014-09-12	AWAY	ETF	32.91	33.35	32.81	33.35	635212.0
2014-09-12	BAB	ETF	29.59	29.59	29.461	29.47	111949.0
2014-09-12	BAL	ETF	45.45	46.04	45.4	45.6089	29774.0
2014-09-12	BALT	ETF	5.88	5.88	5.57	5.63	375534.0
2014-09-12	BAR	ETF	3.23	3.23	3.19	3.213	55180.0
2014-09-12	BBH	ETF	105.96	106.16	103.99	104.59	131000.0
2014-09-12	BCHP	ETF	19.9676	19.9676	19.9601	19.9601	391.0
2014-09-12	BCM	ETF	37.8407	37.8407	37.768	37.814	700.0
2014-09-12	BFOR	ETF	7.8575	7.8575	7.7925	7.82	75200.0
2014-09-12	BIB	ETF	51.86	51.86	50.09	50.6	233266.0
2014-09-12	BICK	ETF	26.8688	26.8799	26.77	26.78	1561.0
2014-09-12	BIL	ETF	91.5	91.52	91.5	91.5	163750.0
2014-09-12	BIS	ETF	488.0	504.8	485.244	500.0	8357.0
2014-09-12	BIV	ETF	83.93	83.97	83.82	83.85	260900.0
2014-09-12	BIZD	ETF	20.45	20.52	20.45	20.45	3300.0

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

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