PREVIEW / etf_daily / 2014-08-29

all etf daily files

  file:    by_date/etf_daily/2014/2014-08-29.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-08-29	SPY	ETF	200.45	200.73	199.82	200.71	65907000.0
2014-08-29	QQQ	ETF	99.65	99.9141	99.2701	99.78	17912339.0
2014-08-29	IWM	ETF	116.16	116.81	115.65	116.56	26231100.0
2014-08-29	DIA	ETF	170.9	171.0	170.25	170.88	3280300.0
2014-08-29	GLD	ETF	123.75	124.22	123.62	123.86	3683500.0
2014-08-29	TLT	ETF	118.92	119.43	118.75	119.05	8512900.0
2014-08-29	AADR	ETF	39.1	39.1	38.63	38.71	3300.0
2014-08-29	AAXJ	ETF	65.73	65.9	65.5	65.72	429500.0
2014-08-29	ACWI	ETF	60.84	60.92	60.65	60.92	2565100.0
2014-08-29	ACWV	ETF	68.09	68.17	67.96	68.11	28300.0
2014-08-29	ACWX	ETF	47.76	47.81	47.6212	47.78	214663.0
2014-08-29	ADRE	ETF	43.32	43.5246	43.229	43.51	20341.0
2014-08-29	AFK	ETF	33.5	33.73	33.43	33.67	65614.0
2014-08-29	AGG	ETF	110.0	110.09	109.94	109.98	1473300.0
2014-08-29	AGQ	ETF	61.05	61.5	60.38	60.51	173300.0
2014-08-29	AGZ	ETF	112.75	113.14	112.23	112.23	19872.0
2014-08-29	AIA	ETF	50.68	50.71	50.53	50.58	16589.0
2014-08-29	AIQ	ETF	27.25	28.59	26.65	28.45	26700.0
2014-08-29	AIRR	ETF	19.38	19.38	19.261	19.34	2000.0
2014-08-29	AIVI	ETF	49.69	49.69	49.46	49.57	8800.0
2014-08-29	AMJ	ETF	53.6	54.02	53.4928	53.93	1539919.0
2014-08-29	AMLP	ETF	96.2	96.7	95.9	96.55	444140.0
2014-08-29	ANGL	ETF	28.44	28.44	28.36	28.36	2200.0
2014-08-29	AOA	ETF	47.13	47.13	46.98	47.12	12200.0
2014-08-29	AOK	ETF	32.95	33.01	32.95	33.01	31072.0
2014-08-29	AOM	ETF	35.7	35.7	35.57	35.65	19507.0
2014-08-29	AOR	ETF	40.48	40.49	40.373	40.49	30337.0
2014-08-29	ARGT	ETF	21.14	21.14	20.83	20.83	27800.0
2014-08-29	ASEA	ETF	17.45	17.45	17.37	17.37	1300.0
2014-08-29	ASHR	ETF	24.68	24.7	24.58	24.63	212600.0
2014-08-29	ASHS	ETF	30.15	30.15	30.1	30.11	2000.0
2014-08-29	ATMP	ETF	32.57	32.75	32.57	32.7	12200.0
2014-08-29	AVIV	ETF	29.13	29.43	28.96	29.26	458836.0
2014-08-29	AWAY	ETF	33.14	33.34	32.78	33.2	494819.0
2014-08-29	BAB	ETF	30.0	30.08	29.9509	30.04	65254.0
2014-08-29	BAL	ETF	44.23	44.82	44.2001	44.784	17001.0
2014-08-29	BALT	ETF	5.84	5.89	5.74	5.87	169235.0
2014-08-29	BBH	ETF	106.38	107.21	106.1	107.06	56100.0
2014-08-29	BCM	ETF	39.41	39.41	39.401	39.401	404.0
2014-08-29	BFOR	ETF	7.875	7.9	7.845	7.9	43600.0
2014-08-29	BIB	ETF	52.455	53.3545	52.3	53.25	234132.0
2014-08-29	BICK	ETF	27.58	27.6	27.4601	27.5732	1389.0
2014-08-29	BIL	ETF	91.5	91.52	91.5	91.52	66950.0
2014-08-29	BIS	ETF	487.2	487.2	476.88	478.8	7125.5
2014-08-29	BIV	ETF	85.27	85.35	85.17	85.29	146400.0
2014-08-29	BIZD	ETF	20.53	20.56	20.51	20.56	6800.0
2014-08-29	BJK	ETF	48.03	48.03	47.66	47.75	10300.0
2014-08-29	BKF	ETF	41.18	41.18	40.995	41.11	80695.0
2014-08-29	BKLN	ETF	24.73	24.73	24.71	24.73	1755600.0
2014-08-29	BLV	ETF	92.63	93.0	92.63	92.82	393700.0

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

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