PREVIEW / etf_daily / 2014-10-16

all etf daily files

  file:    by_date/etf_daily/2014/2014-10-16.parquet
  size:    46 KB
  rows:    1,139

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-10-16	SPY	ETF	183.06	187.58	182.89	186.27	270391000.0
2014-10-16	QQQ	ETF	90.43	92.58	90.39	91.79	93165782.0
2014-10-16	IWM	ETF	105.15	108.57	104.95	107.8	100532300.0
2014-10-16	DIA	ETF	159.0	161.95	158.73	160.98	18926600.0
2014-10-16	GLD	ETF	119.02	119.65	118.88	119.22	6545400.0
2014-10-16	TLT	ETF	124.12	124.13	121.44	121.75	18096600.0
2014-10-16	AADR	ETF	34.92	34.92	34.87	34.87	700.0
2014-10-16	AAXJ	ETF	59.22	60.48	59.15	60.1	1301600.0
2014-10-16	ACWI	ETF	54.72	55.99	54.57	55.53	2372700.0
2014-10-16	ACWV	ETF	64.57	65.59	64.26	65.11	80700.0
2014-10-16	ACWX	ETF	41.98	42.97	41.87	42.64	480604.0
2014-10-16	ADRE	ETF	37.73	38.8	37.73	38.37	36477.0
2014-10-16	AFK	ETF	28.49	28.89	28.22	28.62	53765.0
2014-10-16	AGG	ETF	111.0	111.15	110.54	110.67	1792900.0
2014-10-16	AGQ	ETF	47.15	48.17	46.8	47.79	160300.0
2014-10-16	AGZ	ETF	112.54	113.9	112.54	113.4699	10432.0
2014-10-16	AGZD	ETF	24.555	24.84	24.555	24.83	10400.0
2014-10-16	AIA	ETF	45.13	46.1657	45.0101	45.79	41554.0
2014-10-16	AIQ	ETF	22.42	23.26	21.7567	23.17	26712.0
2014-10-16	AIRR	ETF	17.38	17.75	17.1	17.71	299700.0
2014-10-16	AIVI	ETF	42.9	43.86	42.86	43.65	65700.0
2014-10-16	ALTL	ETF	33.25	33.25	33.25	33.25	392.0
2014-10-16	AMJ	ETF	46.94	50.2	46.56	49.59	3213300.0
2014-10-16	AMLP	ETF	88.7	92.5	88.0	91.75	2646300.0
2014-10-16	AMZA	ETF	227.2	240.4	225.7	237.9	1380.0
2014-10-16	ANGL	ETF	27.16	27.4	27.16	27.23	3200.0
2014-10-16	AOA	ETF	42.94	43.82	42.94	43.65	28600.0
2014-10-16	AOK	ETF	31.88	32.04	31.88	31.97	50026.0
2014-10-16	AOM	ETF	33.83	34.21	33.83	34.16	35293.0
2014-10-16	AOR	ETF	37.83	38.344	37.83	38.23	16196.0
2014-10-16	ARGT	ETF	18.45	19.04	18.45	19.0	4100.0
2014-10-16	ARKQ	ETF	18.7	19.02	18.63	19.02	3800.0
2014-10-16	ARKW	ETF	18.58	18.95	18.58	18.95	3800.0
2014-10-16	ASEA	ETF	15.93	16.09	15.89	16.04	4200.0
2014-10-16	ASHR	ETF	25.39	25.74	25.37	25.6	457800.0
2014-10-16	ASHS	ETF	33.28	33.54	33.09	33.53	3500.0
2014-10-16	ATMP	ETF	28.62	30.66	28.62	30.45	42800.0
2014-10-16	AVIV	ETF	28.54	28.89	28.2	28.23	525064.0
2014-10-16	AWAY	ETF	30.11	30.42	29.52	30.07	1723783.0
2014-10-16	BAB	ETF	30.37	30.3879	29.91	29.95	173895.0
2014-10-16	BAL	ETF	42.75	42.9101	42.0	42.0	16347.0
2014-10-16	BALT	ETF	3.53	3.67	3.34	3.41	1224338.0
2014-10-16	BAR	ETF	3.251	3.274	3.243	3.271	19900.0
2014-10-16	BBH	ETF	96.04	101.0	96.01	99.59	234100.0
2014-10-16	BCHP	ETF	17.7579	17.7579	17.7579	17.7579	142.0
2014-10-16	BCM	ETF	35.73	36.066	35.73	36.062	3922.0
2014-10-16	BFOR	ETF	7.045	7.2575	7.045	7.225	100000.0
2014-10-16	BIB	ETF	43.47	48.2185	43.47	47.1001	627570.0
2014-10-16	BICK	ETF	23.99	24.0652	23.83	24.05	5200.0
2014-10-16	BIL	ETF	91.5	91.5	91.48	91.5	601100.0

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

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