PREVIEW / etf_daily / 2014-10-22

all etf daily files

  file:    by_date/etf_daily/2014/2014-10-22.parquet
  size:    46 KB
  rows:    1,136

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-10-22	SPY	ETF	194.41	194.91	192.61	192.69	151822000.0
2014-10-22	QQQ	ETF	97.16	97.3	96.305	96.37	39178048.0
2014-10-22	IWM	ETF	110.8	111.06	108.86	108.95	48798300.0
2014-10-22	DIA	ETF	166.17	166.23	164.28	164.38	6025100.0
2014-10-22	GLD	ETF	119.69	119.79	119.25	119.34	3740200.0
2014-10-22	TLT	ETF	120.47	120.85	120.22	120.67	9260200.0
2014-10-22	AADR	ETF	36.15	36.15	36.15	36.15	200.0
2014-10-22	AAXJ	ETF	61.42	61.48	61.03	61.19	648800.0
2014-10-22	ACWI	ETF	57.55	57.73	57.09	57.11	1482500.0
2014-10-22	ACWV	ETF	66.97	67.26	66.74	66.77	203900.0
2014-10-22	ACWX	ETF	43.95	44.02	43.55	43.56	264000.0
2014-10-22	ADRE	ETF	38.87	39.07	38.596	38.596	7987.0
2014-10-22	AFK	ETF	29.62	29.76	29.42	29.42	14435.0
2014-10-22	AGG	ETF	110.5	110.54	110.4	110.49	3179200.0
2014-10-22	AGQ	ETF	47.16	47.16	46.31	46.45	300500.0
2014-10-22	AGZ	ETF	113.1892	113.37	112.951	113.2199	7912.0
2014-10-22	AGZD	ETF	24.755	24.81	24.71	24.725	7800.0
2014-10-22	AIA	ETF	46.66	46.665	46.35	46.35	24023.0
2014-10-22	AIQ	ETF	22.92	23.25	22.505	22.56	30225.0
2014-10-22	AIRR	ETF	18.29	18.29	17.82	17.82	36000.0
2014-10-22	AIVI	ETF	44.73	44.97	44.53	44.55	12500.0
2014-10-22	ALTL	ETF	34.75	34.75	34.75	34.75	364.0
2014-10-22	AMJ	ETF	51.0	51.56	50.31	50.34	1271108.0
2014-10-22	AMLP	ETF	93.5	94.2	92.6	92.7	957260.0
2014-10-22	AMZA	ETF	247.7	247.7	241.2	241.2	3770.0
2014-10-22	ANGL	ETF	27.74	27.84	27.72	27.79	4700.0
2014-10-22	AOA	ETF	45.09	45.14	44.72	44.72	45300.0
2014-10-22	AOK	ETF	32.35	32.44	32.32	32.32	32894.0
2014-10-22	AOM	ETF	34.71	34.79	34.6055	34.61	42001.0
2014-10-22	AOR	ETF	39.24	39.2631	39.0	39.0	66547.0
2014-10-22	ARGT	ETF	19.71	19.89	19.5	19.5	7500.0
2014-10-22	ARKQ	ETF	19.59	19.59	19.3	19.3	6900.0
2014-10-22	ARKW	ETF	19.55	19.57	19.397	19.397	3300.0
2014-10-22	ASEA	ETF	16.57	16.57	16.42	16.43	2300.0
2014-10-22	ASHR	ETF	25.63	25.65	25.46	25.47	628300.0
2014-10-22	ASHS	ETF	33.23	33.23	33.01	33.01	14800.0
2014-10-22	ATMP	ETF	31.4	31.64	30.95	30.95	17800.0
2014-10-22	AVIV	ETF	28.97	29.23	28.85	28.95	177361.0
2014-10-22	AWAY	ETF	33.0	33.195	32.44	32.72	1192282.0
2014-10-22	BAB	ETF	29.96	30.013	29.91	29.99	58583.0
2014-10-22	BAL	ETF	42.15	42.2	41.75	41.86	3347.0
2014-10-22	BALT	ETF	4.1	4.3	3.65	3.67	1655467.0
2014-10-22	BAR	ETF	3.2925	3.299	3.259	3.259	24710.0
2014-10-22	BBH	ETF	107.1	107.35	105.29	106.67	159600.0
2014-10-22	BCHP	ETF	18.268	18.268	18.268	18.268	214.0
2014-10-22	BCM	ETF	35.9299	35.9299	35.9299	35.9299	336.0
2014-10-22	BFOR	ETF	7.515	7.555	7.43	7.43	102400.0
2014-10-22	BIB	ETF	52.5	53.625	51.67	52.695	686980.0
2014-10-22	BICK	ETF	24.36	24.36	24.36	24.36	188.0
2014-10-22	BIL	ETF	91.48	91.5	91.48	91.5	1261150.0

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

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