PREVIEW / etf_daily / 2014-10-02

all etf daily files

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

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-02	SPY	ETF	194.18	195.06	192.35	194.38	157285000.0
2014-10-02	QQQ	ETF	97.19	97.51	95.97	97.21	54501347.0
2014-10-02	IWM	ETF	107.79	109.28	106.94	108.83	71825900.0
2014-10-02	DIA	ETF	167.39	168.27	166.43	167.65	9093700.0
2014-10-02	GLD	ETF	116.86	117.21	116.33	116.74	6349900.0
2014-10-02	TLT	ETF	117.83	118.2	117.14	117.2	8251800.0
2014-10-02	AADR	ETF	36.83	36.89	36.47	36.89	5300.0
2014-10-02	AAXJ	ETF	60.27	60.77	59.74	60.53	733100.0
2014-10-02	ACWI	ETF	57.93	58.07	57.33	57.9	1546200.0
2014-10-02	ACWV	ETF	66.0	66.27	65.58	66.15	60200.0
2014-10-02	ACWX	ETF	44.75	44.78	44.12	44.54	341422.0
2014-10-02	ADRE	ETF	38.24	38.6365	37.79	38.4716	16072.0
2014-10-02	AFK	ETF	31.11	31.11	30.62	31.02	31293.0
2014-10-02	AGG	ETF	109.56	109.63	109.35	109.35	4826800.0
2014-10-02	AGQ	ETF	46.24	46.67	45.63	46.34	239300.0
2014-10-02	AGZ	ETF	112.45	112.9	112.397	112.4154	5795.0
2014-10-02	AGZD	ETF	24.77	24.885	24.77	24.785	3800.0
2014-10-02	AIA	ETF	45.73	45.98	45.38	45.9	38042.0
2014-10-02	AIQ	ETF	22.333	22.333	21.19	22.08	25089.0
2014-10-02	AIRR	ETF	17.89	18.22	17.89	18.11	453200.0
2014-10-02	AIVI	ETF	45.96	45.98	45.4	45.77	141100.0
2014-10-02	ALTL	ETF	34.77	34.8999	34.77	34.89	9773.0
2014-10-02	AMJ	ETF	52.15	52.6	51.12	52.47	3363336.0
2014-10-02	AMLP	ETF	94.9	95.35	93.45	95.2	879420.0
2014-10-02	AMZA	ETF	251.0	251.8	247.6	251.3	3437.0
2014-10-02	ANGL	ETF	27.78	27.8	27.5	27.75	1700.0
2014-10-02	AOA	ETF	44.91	45.04	44.48	44.92	86500.0
2014-10-02	AOK	ETF	32.28	32.328	32.1929	32.3	18047.0
2014-10-02	AOM	ETF	34.62	34.633	34.4401	34.6	24802.0
2014-10-02	AOR	ETF	39.01	39.08	38.75	39.03	40013.0
2014-10-02	ARGT	ETF	20.79	20.79	19.9	20.19	47300.0
2014-10-02	ARKQ	ETF	19.33	19.58	19.33	19.58	15600.0
2014-10-02	ARKW	ETF	19.4	19.45	19.4	19.43	15500.0
2014-10-02	ASEA	ETF	16.67	16.67	16.44	16.55	8200.0
2014-10-02	ASHR	ETF	25.51	25.57	25.17	25.45	353900.0
2014-10-02	ASHS	ETF	33.0	33.32	32.98	33.26	5800.0
2014-10-02	ATMP	ETF	31.86	32.14	31.31	32.11	36300.0
2014-10-02	AVIV	ETF	26.32	26.46	26.09	26.45	326813.0
2014-10-02	AWAY	ETF	34.97	35.33	34.26	35.01	816560.0
2014-10-02	BAB	ETF	29.85	29.8787	29.64	29.75	112415.0
2014-10-02	BAL	ETF	41.32	41.32	40.93	41.2	7831.0
2014-10-02	BALT	ETF	3.86	3.93	3.6	3.8	2112939.0
2014-10-02	BAR	ETF	3.075	3.105	3.075	3.083	12320.0
2014-10-02	BBH	ETF	104.16	104.67	102.25	103.71	87100.0
2014-10-02	BCHP	ETF	18.63	18.63	18.63	18.63	600.0
2014-10-02	BFOR	ETF	7.43	7.49	7.355	7.4675	167200.0
2014-10-02	BIB	ETF	49.995	50.875	48.6555	50.165	577252.0
2014-10-02	BIL	ETF	91.5	91.52	91.5	91.52	269900.0
2014-10-02	BIS	ETF	500.0	512.8	491.6	498.8	18939.0
2014-10-02	BIV	ETF	84.59	84.65	84.41	84.46	293700.0

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

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