PREVIEW / etf_daily / 2013-05-15

all etf daily files

  file:    by_date/etf_daily/2013/2013-05-15.parquet
  size:    41 KB
  rows:    998

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-15	SPY	ETF	164.96	166.45	164.91	166.12	120718500.0
2013-05-15	QQQ	ETF	73.38	73.74	73.2	73.67	27214313.0
2013-05-15	IWM	ETF	97.8	98.67	97.69	98.2	34000200.0
2013-05-15	DIA	ETF	151.88	153.11	151.86	152.78	5770700.0
2013-05-15	GLD	ETF	136.59	136.98	134.23	134.63	19062400.0
2013-05-15	TLT	ETF	117.53	117.72	116.42	117.34	14608600.0
2013-05-15	AADR	ETF	35.2	35.2	35.2	35.2	100.0
2013-05-15	AAXJ	ETF	60.58	60.75	60.45	60.71	371400.0
2013-05-15	ACTV	ETF	6.01	6.12	5.75	6.07	360022.0
2013-05-15	ACWI	ETF	53.32	53.66	53.3	53.63	446800.0
2013-05-15	ACWV	ETF	63.93	64.33	63.88	64.31	125700.0
2013-05-15	ACWX	ETF	44.7401	44.99	44.7401	44.99	195557.0
2013-05-15	ADRE	ETF	39.15	39.39	39.12	39.22	18988.0
2013-05-15	AFK	ETF	30.35	30.52	30.3101	30.5	23311.0
2013-05-15	AGEM	ETF	22.92	22.95	22.92	22.95	2152.0
2013-05-15	AGG	ETF	110.27	110.32	110.1	110.28	926800.0
2013-05-15	AGQ	ETF	95.04	95.72	91.36	91.68	812800.0
2013-05-15	AGZ	ETF	113.1	113.19	113.1	113.16	9408.0
2013-05-15	AIA	ETF	46.8	46.99	46.78	46.99	163095.0
2013-05-15	AIQ	ETF	12.59	12.6	12.3	12.6	20795.0
2013-05-15	AIVI	ETF	44.05	44.32	44.02	44.32	28400.0
2013-05-15	ALTL	ETF	29.7	29.71	29.7	29.71	400.0
2013-05-15	AMJ	ETF	47.5	47.93	47.42	47.59	883168.0
2013-05-15	AMLP	ETF	89.0	89.5	88.85	89.05	533600.0
2013-05-15	ANGL	ETF	27.7	27.93	27.7	27.85	9000.0
2013-05-15	AOA	ETF	41.36	41.58	41.31	41.56	33900.0
2013-05-15	AOK	ETF	31.64	31.684	31.6	31.684	33020.0
2013-05-15	AOM	ETF	33.46	33.54	33.431	33.54	46484.0
2013-05-15	AOR	ETF	36.69	36.83	36.6813	36.82	71129.0
2013-05-15	ARB	ETF	46.79	46.8801	46.78	46.84	101283.0
2013-05-15	ARGT	ETF	17.76	17.88	17.76	17.86	6750.0
2013-05-15	ASEA	ETF	18.89	18.89	18.77	18.85	229800.0
2013-05-15	ATMP	ETF	26.62	26.67	26.54	26.65	64700.0
2013-05-15	AVIV	ETF	30.2	30.87	29.32	30.27	678133.0
2013-05-15	AWAY	ETF	30.1	31.45	30.01	31.41	2046191.0
2013-05-15	BAB	ETF	30.43	30.45	30.18	30.3	206555.0
2013-05-15	BAL	ETF	54.43	54.479	54.14	54.45	8630.0
2013-05-15	BALT	ETF	3.58	3.68	3.51	3.66	53001.0
2013-05-15	BBH	ETF	75.36	75.44	73.46	73.99	237100.0
2013-05-15	BCM	ETF	40.03	40.2101	39.94	40.131	29560.0
2013-05-15	BIB	ETF	26.49	26.76	25.345	25.7175	308320.0
2013-05-15	BICK	ETF	24.21	24.3	24.16	24.22	5923.0
2013-05-15	BIL	ETF	91.6	91.62	91.6	91.6	110150.0
2013-05-15	BIS	ETF	1361.6	1416.0	1361.6	1416.0	63.5
2013-05-15	BIV	ETF	87.45	87.54	87.26	87.46	258100.0
2013-05-15	BIZD	ETF	20.8	20.8	20.5	20.75	18500.0
2013-05-15	BJK	ETF	43.66	43.69	43.37	43.5	28600.0
2013-05-15	BKF	ETF	39.63	39.759	39.531	39.67	58338.0
2013-05-15	BKLN	ETF	25.21	25.21	25.2	25.2	2582200.0
2013-05-15	BLV	ETF	91.61	91.99	91.04	91.57	44900.0

> showing 50 of 998 rows — these rows as CSV

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