PREVIEW / etf_daily / 2014-12-04

all etf daily files

  file:    by_date/etf_daily/2014/2014-12-04.parquet
  size:    46 KB
  rows:    1,145

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-12-04	SPY	ETF	207.54	208.27	206.7	207.66	91316600.0
2014-12-04	QQQ	ETF	105.32	105.78	104.93	105.37	31008791.0
2014-12-04	IWM	ETF	117.19	117.3	116.22	116.81	28631900.0
2014-12-04	DIA	ETF	178.73	179.3	178.03	178.83	4791000.0
2014-12-04	GLD	ETF	116.01	116.34	115.61	115.88	3623600.0
2014-12-04	TLT	ETF	120.75	121.8	120.62	121.8	4250500.0
2014-12-04	AADR	ETF	38.17	38.17	38.17	38.17	900.0
2014-12-04	AAXJ	ETF	62.71	62.84	62.56	62.68	381900.0
2014-12-04	ACWI	ETF	60.4	60.5	60.12	60.33	2324400.0
2014-12-04	ACWV	ETF	70.12	70.24	69.94	70.05	286100.0
2014-12-04	ACWX	ETF	45.17	45.25	45.0	45.08	574030.0
2014-12-04	ADRE	ETF	37.74	37.7999	37.65	37.67	12366.0
2014-12-04	AFK	ETF	27.62	27.62	27.46	27.5	15521.0
2014-12-04	AGG	ETF	109.85	110.11	109.78	110.09	3001700.0
2014-12-04	AGQ	ETF	42.67	42.9	42.02	42.04	149600.0
2014-12-04	AGZ	ETF	113.014	113.25	112.819	113.06	23165.0
2014-12-04	AGZD	ETF	24.845	24.925	24.76	24.925	4800.0
2014-12-04	AIA	ETF	48.13	48.13	47.755	47.86	27335.0
2014-12-04	AIQ	ETF	21.84	22.46	21.18	21.81	16704.0
2014-12-04	AIRR	ETF	18.3	18.46	18.19	18.26	34500.0
2014-12-04	AIVI	ETF	45.62	45.85	45.53	45.62	41000.0
2014-12-04	AMJ	ETF	48.61	49.07	47.94	48.69	1449960.0
2014-12-04	AMLP	ETF	89.95	91.1	89.6	90.65	575740.0
2014-12-04	AMZA	ETF	241.1	242.2	240.7	240.8	880.0
2014-12-04	ANGL	ETF	27.32	27.42	27.05	27.42	4700.0
2014-12-04	AOA	ETF	47.0	47.05	46.82	46.96	28200.0
2014-12-04	AOK	ETF	32.86	32.87	32.8	32.81	39345.0
2014-12-04	AOM	ETF	35.43	35.5399	35.41	35.51	335417.0
2014-12-04	AOR	ETF	40.52	40.56	40.4	40.4758	109351.0
2014-12-04	ARGT	ETF	20.37	20.46	20.37	20.43	4800.0
2014-12-04	ARKG	ETF	20.33	20.35	20.32	20.35	1200.0
2014-12-04	ARKK	ETF	20.13	20.18	20.04	20.06	1900.0
2014-12-04	ARKQ	ETF	20.11	20.15	20.11	20.15	400.0
2014-12-04	ARKW	ETF	20.25	20.25	20.218	20.25	1100.0
2014-12-04	ASEA	ETF	16.25	16.25	16.18	16.24	2100.0
2014-12-04	ASHR	ETF	34.0	34.8	33.91	34.79	4119500.0
2014-12-04	ASHS	ETF	37.93	37.93	37.26	37.55	127100.0
2014-12-04	ATMP	ETF	31.28	31.6	31.28	31.4	21900.0
2014-12-04	AVIV	ETF	34.18	34.23	33.91	34.22	113876.0
2014-12-04	AWAY	ETF	31.74	32.19	31.57	31.85	755059.0
2014-12-04	BAB	ETF	29.85	29.9679	29.81	29.9495	66155.0
2014-12-04	BAL	ETF	41.1405	41.3101	41.08	41.309	2775.0
2014-12-04	BALT	ETF	2.75	2.88	2.7	2.82	516261.0
2014-12-04	BAR	ETF	2.904	2.94	2.904	2.939	14080.0
2014-12-04	BBH	ETF	118.56	118.92	117.58	118.05	52600.0
2014-12-04	BCHP	ETF	18.64	18.72	18.612	18.72	33533.0
2014-12-04	BCM	ETF	34.0634	34.12	34.04	34.08	15595.0
2014-12-04	BFOR	ETF	7.9075	7.915	7.8775	7.89	14400.0
2014-12-04	BIB	ETF	65.375	65.6	64.0	64.46	307222.0
2014-12-04	BICK	ETF	24.75	24.82	24.75	24.82	2038.0

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

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