PREVIEW / etf_daily / 2014-09-09

all etf daily files

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

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-09	SPY	ETF	200.41	200.55	198.91	199.32	88591000.0
2014-09-09	QQQ	ETF	100.06	100.46	99.0645	99.25	36449189.0
2014-09-09	IWM	ETF	116.36	116.39	115.0	115.18	36390100.0
2014-09-09	DIA	ETF	170.79	170.84	169.89	170.12	4252400.0
2014-09-09	GLD	ETF	120.57	120.94	120.0	120.87	6157300.0
2014-09-09	TLT	ETF	115.49	115.89	115.45	115.69	5353100.0
2014-09-09	AADR	ETF	38.6	38.6	38.6	38.6	35000.0
2014-09-09	AAXJ	ETF	65.86	65.92	65.24	65.45	675900.0
2014-09-09	ACWI	ETF	60.62	60.62	60.26	60.4	528400.0
2014-09-09	ACWV	ETF	68.1	68.1	67.64	67.75	35500.0
2014-09-09	ACWX	ETF	47.47	47.47	47.215	47.36	511721.0
2014-09-09	ADRE	ETF	43.59	43.59	43.02	43.11	25681.0
2014-09-09	AFK	ETF	33.26	33.26	32.96	32.98	33979.0
2014-09-09	AGG	ETF	109.17	109.23	109.09	109.11	689500.0
2014-09-09	AGQ	ETF	57.4	58.13	56.81	58.11	167500.0
2014-09-09	AGZ	ETF	112.4	112.62	112.21	112.4099	17928.0
2014-09-09	AGZD	ETF	24.95	24.95	24.88	24.93	23600.0
2014-09-09	AIA	ETF	50.88	50.88	50.3822	50.48	17055.0
2014-09-09	AIQ	ETF	27.49	29.76	26.3	26.44	24970.0
2014-09-09	AIRR	ETF	19.397	19.425	19.32	19.34	4000.0
2014-09-09	AIVI	ETF	49.16	49.16	48.82	48.92	9900.0
2014-09-09	ALTL	ETF	36.1	36.13	36.1	36.1	578.0
2014-09-09	AMJ	ETF	53.54	53.89	53.37	53.73	523770.0
2014-09-09	AMLP	ETF	96.3	96.45	95.95	96.3	417780.0
2014-09-09	AOA	ETF	47.13	47.13	46.73	46.76	39100.0
2014-09-09	AOK	ETF	33.05	33.05	32.7499	32.77	70054.0
2014-09-09	AOM	ETF	35.6	35.6	35.38	35.4	31153.0
2014-09-09	AOR	ETF	40.5	40.5	40.16	40.2	58987.0
2014-09-09	ARGT	ETF	21.3	21.3	21.16	21.26	6300.0
2014-09-09	ASEA	ETF	17.38	17.4	17.37	17.39	1100.0
2014-09-09	ASHR	ETF	26.0	26.0	25.78	25.85	357000.0
2014-09-09	ASHS	ETF	32.2	32.3	32.2	32.25	10200.0
2014-09-09	ATMP	ETF	32.57	32.68	32.5	32.57	35400.0
2014-09-09	AVIV	ETF	28.84	28.8802	28.56	28.73	172401.0
2014-09-09	AWAY	ETF	33.94	34.05	33.57	33.68	1056646.0
2014-09-09	BAB	ETF	29.64	29.7245	29.58	29.68	38157.0
2014-09-09	BAL	ETF	43.5	44.23	43.5	44.0325	12780.0
2014-09-09	BALT	ETF	5.98	5.98	5.81	5.84	321100.0
2014-09-09	BAR	ETF	3.3995	3.4	3.373	3.396	95660.0
2014-09-09	BBH	ETF	105.58	105.58	104.13	104.49	32200.0
2014-09-09	BCHP	ETF	20.169	20.169	20.169	20.169	100.0
2014-09-09	BCM	ETF	38.53	38.53	38.378	38.378	4887.0
2014-09-09	BFOR	ETF	7.885	7.885	7.7025	7.8125	39600.0
2014-09-09	BIB	ETF	51.605	51.68	50.23	50.535	263070.0
2014-09-09	BICK	ETF	27.34	27.47	27.27	27.29	5323.0
2014-09-09	BIL	ETF	91.5	91.52	91.5	91.5	64600.0
2014-09-09	BIS	ETF	488.4	504.8	488.4	501.2	7676.0
2014-09-09	BIV	ETF	84.38	84.43	84.27	84.32	230800.0
2014-09-09	BIZD	ETF	20.53	20.57	20.46	20.46	47400.0
2014-09-09	BJK	ETF	46.12	46.43	46.1	46.32	8200.0

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

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