PREVIEW / etf_daily / 2014-09-03

all etf daily files

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

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-03	SPY	ETF	201.38	201.41	200.22	200.5	57462000.0
2014-09-03	QQQ	ETF	100.32	100.34	99.3	99.48	25950656.0
2014-09-03	IWM	ETF	117.76	117.8	116.27	116.46	33266600.0
2014-09-03	DIA	ETF	171.38	171.48	170.53	170.72	2847400.0
2014-09-03	GLD	ETF	121.7	122.2	121.66	122.15	3414600.0
2014-09-03	TLT	ETF	116.4	117.38	116.31	117.38	6553900.0
2014-09-03	AADR	ETF	38.89	38.89	38.89	38.89	200.0
2014-09-03	AAXJ	ETF	66.57	66.57	66.15	66.23	368800.0
2014-09-03	ACWI	ETF	61.3	61.32	61.03	61.09	1407100.0
2014-09-03	ACWV	ETF	68.31	68.5	68.29	68.36	34200.0
2014-09-03	ACWX	ETF	48.34	48.34	48.16	48.21	117132.0
2014-09-03	ADRE	ETF	44.66	44.66	44.2401	44.48	27408.0
2014-09-03	AFK	ETF	33.49	33.81	33.49	33.72	24650.0
2014-09-03	AGG	ETF	109.39	109.58	109.37	109.57	1311700.0
2014-09-03	AGQ	ETF	58.55	58.91	58.41	58.91	148200.0
2014-09-03	AGZ	ETF	112.61	112.69	112.4301	112.53	4935.0
2014-09-03	AGZD	ETF	25.5	25.915	24.935	25.035	38200.0
2014-09-03	AIA	ETF	51.09	51.17	51.0	51.05	91936.0
2014-09-03	AIQ	ETF	28.39	28.39	27.83	28.02	22956.0
2014-09-03	AIRR	ETF	19.69	19.69	19.42	19.43	11800.0
2014-09-03	AIVI	ETF	49.92	49.99	49.82	49.83	15600.0
2014-09-03	AMJ	ETF	53.88	54.13	53.56	53.68	629713.0
2014-09-03	AMLP	ETF	96.45	96.55	96.2	96.4	771160.0
2014-09-03	ANGL	ETF	28.17	28.18	28.17	28.18	3700.0
2014-09-03	AOA	ETF	47.44	47.44	47.2	47.22	15100.0
2014-09-03	AOK	ETF	33.0067	33.0067	32.96	32.98	9449.0
2014-09-03	AOM	ETF	35.76	35.76	35.65	35.66	41282.0
2014-09-03	AOR	ETF	40.66	40.66	40.4871	40.5	38765.0
2014-09-03	ARGT	ETF	21.03	21.73	21.03	21.71	21400.0
2014-09-03	ASEA	ETF	17.39	17.46	17.39	17.46	700.0
2014-09-03	ASHR	ETF	25.5	25.72	25.5	25.65	528300.0
2014-09-03	ASHS	ETF	31.74	31.74	31.65	31.7	7400.0
2014-09-03	ATMP	ETF	32.88	32.88	32.6	32.69	20400.0
2014-09-03	AVIV	ETF	29.13	29.22	28.57	28.7	3472104.0
2014-09-03	AWAY	ETF	32.66	33.34	32.4401	32.84	751880.0
2014-09-03	BAB	ETF	29.79	29.91	29.7404	29.91	55168.0
2014-09-03	BAL	ETF	43.85	44.42	43.85	44.272	16390.0
2014-09-03	BALT	ETF	5.84	5.99	5.4623	5.62	719669.0
2014-09-03	BAR	ETF	3.501	3.527	3.495	3.524	53930.0
2014-09-03	BBH	ETF	107.66	107.82	106.62	107.01	71300.0
2014-09-03	BCHP	ETF	20.5	20.5	20.41	20.41	775.0
2014-09-03	BCM	ETF	38.96	39.03	38.96	39.03	1958.0
2014-09-03	BFOR	ETF	7.955	7.955	7.8825	7.885	80000.0
2014-09-03	BIB	ETF	53.92	53.92	52.54	52.925	375848.0
2014-09-03	BICK	ETF	27.95	28.01	27.95	28.01	1225.0
2014-09-03	BIL	ETF	91.5	91.52	91.5	91.52	39450.0
2014-09-03	BIS	ETF	470.8	483.836	470.4	480.4	5857.0
2014-09-03	BIV	ETF	84.66	84.82	84.6	84.82	233400.0
2014-09-03	BIZD	ETF	20.62	20.63	20.53	20.54	7500.0
2014-09-03	BJK	ETF	46.78	46.89	46.64	46.82	15000.0

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

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