PREVIEW / etf_daily / 2014-06-09

all etf daily files

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

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-06-09	SPY	ETF	195.35	196.05	195.17	195.58	65119000.0
2014-06-09	QQQ	ETF	92.85	92.98	92.495	92.75	23402469.0
2014-06-09	IWM	ETF	115.88	117.48	115.66	116.9	44025700.0
2014-06-09	DIA	ETF	169.12	169.58	169.02	169.24	2713200.0
2014-06-09	GLD	ETF	120.79	120.85	120.57	120.65	2788000.0
2014-06-09	TLT	ETF	111.45	111.64	111.2	111.43	5162800.0
2014-06-09	AADR	ETF	38.25	38.41	38.25	38.41	800.0
2014-06-09	AAXJ	ETF	62.83	62.97	62.64	62.94	312700.0
2014-06-09	ACWI	ETF	60.81	60.96	60.71	60.88	241700.0
2014-06-09	ACWV	ETF	67.01	67.11	66.99	67.02	216600.0
2014-06-09	ACWX	ETF	48.58	48.84	48.58	48.81	427559.0
2014-06-09	ADRE	ETF	38.61	38.96	38.59	38.9401	7710.0
2014-06-09	AFK	ETF	33.65	33.65	33.25	33.37	75737.0
2014-06-09	AGG	ETF	108.84	108.87	108.76	108.78	1133400.0
2014-06-09	AGQ	ETF	58.91	59.08	58.67	58.77	173000.0
2014-06-09	AGZ	ETF	112.35	112.36	112.2101	112.33	12371.0
2014-06-09	AGZD	ETF	25.0	25.03	25.0	25.03	800.0
2014-06-09	AIA	ETF	48.66	48.726	48.54	48.69	13474.0
2014-06-09	AIQ	ETF	30.0	30.5	29.74	30.07	17346.0
2014-06-09	AIRR	ETF	19.33	19.62	19.33	19.62	15100.0
2014-06-09	AIVI	ETF	51.73	51.81	51.55	51.74	14300.0
2014-06-09	AMJ	ETF	50.3	50.53	50.2	50.32	446777.0
2014-06-09	AMLP	ETF	92.45	92.7	92.35	92.45	505920.0
2014-06-09	ANGL	ETF	28.33	28.33	28.25	28.26	2300.0
2014-06-09	AOA	ETF	46.9	47.02	46.85	46.93	15600.0
2014-06-09	AOK	ETF	32.93	32.96	32.89	32.9298	20808.0
2014-06-09	AOM	ETF	35.57	35.61	35.511	35.58	21029.0
2014-06-09	AOR	ETF	40.25	40.31	40.202	40.27	29145.0
2014-06-09	ARGT	ETF	20.77	21.36	20.77	21.36	22200.0
2014-06-09	ASEA	ETF	16.82	16.83	16.78	16.83	2800.0
2014-06-09	ASHR	ETF	22.0	22.07	21.93	22.03	443700.0
2014-06-09	ASHS	ETF	25.58	25.58	25.38	25.38	69600.0
2014-06-09	ATMP	ETF	30.36	30.36	30.16	30.24	42600.0
2014-06-09	AVIV	ETF	29.27	29.34	28.96	29.21	516657.0
2014-06-09	AWAY	ETF	29.17	29.69	27.95	28.91	4355816.0
2014-06-09	BAB	ETF	29.22	29.2699	29.19	29.24	64353.0
2014-06-09	BAL	ETF	51.9	51.95	51.65	51.94	7713.0
2014-06-09	BALT	ETF	6.36	6.49	6.3	6.38	389584.0
2014-06-09	BBH	ETF	93.5	94.08	93.02	93.42	62000.0
2014-06-09	BCHP	ETF	20.61	20.62	20.5875	20.62	1484.0
2014-06-09	BCM	ETF	40.81	40.842	40.77	40.842	904.0
2014-06-09	BFOR	ETF	7.735	7.7975	7.735	7.765	231600.0
2014-06-09	BIB	ETF	43.0	43.9	42.75	43.23	505578.0
2014-06-09	BICK	ETF	26.33	26.57	26.33	26.57	1814.0
2014-06-09	BIL	ETF	91.52	91.54	91.52	91.54	80650.0
2014-06-09	BIS	ETF	616.8	620.4	603.6	612.0	6858.0
2014-06-09	BIV	ETF	84.17	84.17	84.02	84.13	184700.0
2014-06-09	BIZD	ETF	20.05	20.11	19.97	20.09	14400.0
2014-06-09	BJK	ETF	48.37	48.55	48.17	48.33	27700.0
2014-06-09	BKF	ETF	38.68	39.1499	38.68	39.09	110106.0

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

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