PREVIEW / etf_daily / 2014-06-04

all etf daily files

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

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-04	SPY	ETF	192.47	193.3	192.27	193.19	55529000.0
2014-06-04	QQQ	ETF	90.96	91.67	90.81	91.52	20128261.0
2014-06-04	IWM	ETF	111.48	112.57	111.16	112.42	28835500.0
2014-06-04	DIA	ETF	166.89	167.27	166.58	167.13	2264600.0
2014-06-04	GLD	ETF	120.1	120.16	119.68	119.76	3859500.0
2014-06-04	TLT	ETF	111.76	111.82	111.27	111.54	7882000.0
2014-06-04	AADR	ETF	38.6	38.61	38.6	38.61	600.0
2014-06-04	AAXJ	ETF	62.08	62.21	61.92	62.18	388600.0
2014-06-04	ACWI	ETF	59.84	60.16	59.84	60.13	334800.0
2014-06-04	ACWV	ETF	66.67	66.8	66.48	66.8	17100.0
2014-06-04	ACWX	ETF	48.13	48.2168	48.04	48.2	36150.0
2014-06-04	ADRE	ETF	37.87	37.87	37.71	37.7195	24334.0
2014-06-04	AFK	ETF	32.95	33.1	32.75	32.89	44954.0
2014-06-04	AGG	ETF	108.88	108.88	108.73	108.8	1445700.0
2014-06-04	AGQ	ETF	57.54	57.66	57.08	57.18	71100.0
2014-06-04	AGZ	ETF	113.25	113.6799	112.231	112.385	11090.0
2014-06-04	AGZD	ETF	25.025	25.025	24.95	24.96	9200.0
2014-06-04	AIA	ETF	48.66	48.69	48.504	48.58	31488.0
2014-06-04	AIQ	ETF	29.22	29.88	28.98	29.53	29133.0
2014-06-04	AIRR	ETF	18.62	18.693	18.56	18.59	22600.0
2014-06-04	AIVI	ETF	50.8	50.96	50.8	50.92	13200.0
2014-06-04	AMJ	ETF	49.78	50.075	49.766	50.02	254372.0
2014-06-04	AMLP	ETF	91.2	92.0	91.1	91.9	413340.0
2014-06-04	ANGL	ETF	28.12	28.23	28.08	28.2	4600.0
2014-06-04	AOA	ETF	46.22	46.34	46.21	46.34	8900.0
2014-06-04	AOK	ETF	32.74	32.76	32.6901	32.7406	22606.0
2014-06-04	AOM	ETF	35.28	35.32	35.1902	35.32	18556.0
2014-06-04	AOR	ETF	39.71	39.85	39.71	39.85	120223.0
2014-06-04	ARGT	ETF	20.23	20.33	20.23	20.32	4200.0
2014-06-04	ASEA	ETF	16.65	16.65	16.58	16.64	7500.0
2014-06-04	ASHR	ETF	21.84	21.86	21.76	21.84	37500.0
2014-06-04	ASHS	ETF	25.26	25.35	25.26	25.34	12500.0
2014-06-04	ATMP	ETF	30.13	30.17	29.89	30.17	68700.0
2014-06-04	AVIV	ETF	28.31	28.92	28.03	28.8	361339.0
2014-06-04	AWAY	ETF	30.41	30.76	30.01	30.07	1038697.0
2014-06-04	BAB	ETF	29.22	29.3296	29.22	29.26	128504.0
2014-06-04	BAL	ETF	53.62	53.62	52.8	52.8	11519.0
2014-06-04	BALT	ETF	6.2	6.42	6.15	6.4	514312.0
2014-06-04	BBH	ETF	91.57	92.91	91.2	92.84	81700.0
2014-06-04	BCHP	ETF	20.35	20.39	20.339	20.39	601.0
2014-06-04	BCM	ETF	40.63	40.63	40.53	40.55	3079.0
2014-06-04	BFOR	ETF	7.5725	7.6125	7.5325	7.6	72800.0
2014-06-04	BIB	ETF	40.405	41.71	40.25	41.6175	439212.0
2014-06-04	BICK	ETF	25.6433	25.7	25.6433	25.7	750.0
2014-06-04	BIL	ETF	91.54	91.54	91.52	91.52	158000.0
2014-06-04	BIS	ETF	657.2	660.0	636.4	636.8	7576.5
2014-06-04	BIV	ETF	84.22	84.22	84.04	84.12	161100.0
2014-06-04	BIZD	ETF	19.78	19.78	19.64	19.72	8300.0
2014-06-04	BJK	ETF	49.07	49.5	48.87	49.31	51300.0
2014-06-04	BKF	ETF	37.78	37.8127	37.6904	37.75	34963.0

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

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