PREVIEW / etf_daily / 2013-05-24

all etf daily files

  file:    by_date/etf_daily/2013/2013-05-24.parquet
  size:    41 KB
  rows:    999

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
2013-05-24	SPY	ETF	164.47	165.38	163.98	165.31	151573900.0
2013-05-24	QQQ	ETF	72.96	73.43	72.76	73.41	26435957.0
2013-05-24	IWM	ETF	97.3	97.95	96.71	97.88	33332500.0
2013-05-24	DIA	ETF	152.16	152.82	151.73	152.77	4535300.0
2013-05-24	GLD	ETF	134.11	134.51	133.64	133.76	5522600.0
2013-05-24	TLT	ETF	116.98	117.42	116.71	116.8	5357600.0
2013-05-24	AAXJ	ETF	59.23	59.35	59.03	59.19	2296000.0
2013-05-24	ACTV	ETF	6.15	6.4	6.11	6.29	346499.0
2013-05-24	ACWI	ETF	52.65	52.92	52.53	52.92	662000.0
2013-05-24	ACWV	ETF	62.63	62.75	62.28	62.73	34000.0
2013-05-24	ACWX	ETF	43.86	44.0	43.72	43.99	126059.0
2013-05-24	ADRE	ETF	38.28	38.2993	38.05	38.26	61785.0
2013-05-24	AFK	ETF	30.3	30.42	30.0984	30.2401	44840.0
2013-05-24	AGEM	ETF	22.33	22.33	22.09	22.1	1278.0
2013-05-24	AGG	ETF	109.94	110.05	109.83	109.88	640100.0
2013-05-24	AGQ	ETF	90.04	91.56	89.48	89.8	326100.0
2013-05-24	AGZ	ETF	113.156	113.3099	113.05	113.1301	6764.0
2013-05-24	AIA	ETF	45.86	45.89	45.7214	45.82	9936.0
2013-05-24	AIQ	ETF	12.66	12.95	12.63	12.82	5298.0
2013-05-24	AIVI	ETF	43.52	43.67	43.4	43.66	16600.0
2013-05-24	ALTL	ETF	29.19	29.32	29.19	29.32	1353.0
2013-05-24	AMJ	ETF	47.63	47.78	47.14	47.17	635371.0
2013-05-24	AMLP	ETF	89.7	89.95	89.4	89.55	1028600.0
2013-05-24	ANGL	ETF	27.84	28.06	27.7	28.01	10400.0
2013-05-24	AOA	ETF	40.95	41.07	40.82	41.07	24400.0
2013-05-24	AOK	ETF	31.462	31.57	31.44	31.47	19927.0
2013-05-24	AOM	ETF	33.24	33.2799	33.1999	33.2555	7535.0
2013-05-24	AOR	ETF	36.41	36.4761	36.328	36.452	13471.0
2013-05-24	ARB	ETF	46.76	46.86	46.73	46.79	562493.0
2013-05-24	ARGT	ETF	17.74	17.74	17.74	17.74	100.0
2013-05-24	ASEA	ETF	18.4	18.4	18.3	18.31	18700.0
2013-05-24	ATMP	ETF	26.68	26.68	26.42	26.45	11900.0
2013-05-24	AVIV	ETF	28.47	28.5	27.8	27.91	419831.0
2013-05-24	AWAY	ETF	30.24	30.84	30.0	30.36	485999.0
2013-05-24	BAB	ETF	30.37	30.4	30.28	30.33	103937.0
2013-05-24	BAL	ETF	51.17	51.35	50.94	51.3	25174.0
2013-05-24	BALT	ETF	3.65	3.92	3.65	3.88	154129.0
2013-05-24	BBH	ETF	72.79	72.8	71.95	72.77	67200.0
2013-05-24	BCM	ETF	40.164	40.256	40.144	40.144	1328.0
2013-05-24	BIB	ETF	24.67	24.835	24.1877	24.7548	155296.0
2013-05-24	BICK	ETF	23.64	23.6928	23.61	23.66	10697.0
2013-05-24	BIL	ETF	91.62	91.62	91.6	91.62	55200.0
2013-05-24	BIS	ETF	1460.0	1468.4	1448.56	1448.56	234.0
2013-05-24	BIV	ETF	87.1	87.27	87.06	87.16	142000.0
2013-05-24	BIZD	ETF	20.32	20.41	20.21	20.4	13400.0
2013-05-24	BJK	ETF	41.94	42.11	41.87	42.06	15700.0
2013-05-24	BKF	ETF	38.86	38.91	38.68	38.88	62824.0
2013-05-24	BKLN	ETF	25.19	25.2	25.13	25.14	3018400.0
2013-05-24	BLV	ETF	91.09	91.56	90.98	90.98	31900.0
2013-05-24	BMVP	ETF	19.19	19.2537	19.1564	19.2134	4549.0

> showing 50 of 999 rows — these rows as CSV

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