PREVIEW / etf_daily / 2013-05-07

all etf daily files

  file:    by_date/etf_daily/2013/2013-05-07.parquet
  size:    41 KB
  rows:    1,000

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-07	SPY	ETF	162.13	162.65	161.67	162.6	90359200.0
2013-05-07	QQQ	ETF	72.5	72.57	72.09	72.36	25838016.0
2013-05-07	IWM	ETF	95.51	96.17	95.13	96.15	29920800.0
2013-05-07	DIA	ETF	149.77	150.28	149.44	150.26	5361800.0
2013-05-07	GLD	ETF	140.38	140.64	139.37	140.38	13627400.0
2013-05-07	TLT	ETF	120.19	120.5	120.05	120.16	5049200.0
2013-05-07	AADR	ETF	34.78	34.78	34.78	34.78	300.0
2013-05-07	AAXJ	ETF	61.0	61.2	60.86	61.11	451300.0
2013-05-07	ACTV	ETF	6.02	6.09	5.68	5.76	710945.0
2013-05-07	ACWI	ETF	52.87	52.98	52.69	52.92	628700.0
2013-05-07	ACWV	ETF	63.84	64.03	63.83	64.02	104400.0
2013-05-07	ACWX	ETF	44.67	44.83	44.59	44.8	501625.0
2013-05-07	ADRE	ETF	39.31	39.716	39.31	39.62	52501.0
2013-05-07	AFK	ETF	30.08	30.08	29.9001	29.99	27285.0
2013-05-07	AGEM	ETF	23.0899	23.0899	22.87	22.9648	61446.0
2013-05-07	AGG	ETF	110.79	110.85	110.75	110.75	931600.0
2013-05-07	AGQ	ETF	100.68	103.96	99.8	103.64	349475.0
2013-05-07	AGZ	ETF	113.52	113.52	113.3801	113.4	7317.0
2013-05-07	AIA	ETF	47.4	47.526	47.26	47.45	28306.0
2013-05-07	AIQ	ETF	12.83	13.0	12.62	12.78	16535.0
2013-05-07	AIVI	ETF	44.39	44.39	44.14	44.22	22000.0
2013-05-07	ALTL	ETF	29.6576	29.6576	29.6576	29.6576	300.0
2013-05-07	AMJ	ETF	47.68	47.85	47.09	47.11	735329.0
2013-05-07	AMLP	ETF	87.7	87.75	87.4	87.6	604840.0
2013-05-07	ANGL	ETF	27.83	27.83	27.83	27.83	300.0
2013-05-07	AOA	ETF	40.9	41.05	40.86	41.02	82400.0
2013-05-07	AOK	ETF	31.63	31.64	31.5901	31.64	18826.0
2013-05-07	AOM	ETF	33.37	33.41	33.3101	33.4	12072.0
2013-05-07	AOR	ETF	36.49	36.529	36.41	36.52	93814.0
2013-05-07	ARB	ETF	46.74	46.79	46.71	46.78	137423.0
2013-05-07	ARGT	ETF	17.86	18.06	17.78	18.02	4450.0
2013-05-07	ASEA	ETF	18.73	18.79	18.66	18.76	51800.0
2013-05-07	ATMP	ETF	26.18	26.19	26.11	26.18	31200.0
2013-05-07	AVIV	ETF	27.57	29.01	27.57	28.24	678577.0
2013-05-07	AWAY	ETF	29.42	29.73	28.63	28.8	1207278.0
2013-05-07	BAB	ETF	30.73	30.74	30.67	30.696	175705.0
2013-05-07	BAL	ETF	54.47	54.98	54.2935	54.81	30701.0
2013-05-07	BALT	ETF	3.51	3.56	3.4	3.47	71599.0
2013-05-07	BBH	ETF	71.55	71.55	70.46	70.58	67300.0
2013-05-07	BCM	ETF	40.82	40.9	40.82	40.8999	9225.0
2013-05-07	BIB	ETF	23.775	23.8525	23.07	23.1671	148904.0
2013-05-07	BICK	ETF	24.43	24.549	24.43	24.491	4838.0
2013-05-07	BIL	ETF	91.6	91.62	91.6	91.6	51250.0
2013-05-07	BIS	ETF	1550.0	1571.6	1550.0	1571.6	52.0
2013-05-07	BIV	ETF	88.09	88.11	88.0	88.09	200200.0
2013-05-07	BIZD	ETF	20.55	20.55	20.47	20.52	9100.0
2013-05-07	BJK	ETF	43.0	43.05	42.88	43.01	7400.0
2013-05-07	BKF	ETF	39.9	40.31	39.9	40.23	164867.0
2013-05-07	BKLN	ETF	25.26	25.27	25.25	25.26	1744100.0
2013-05-07	BLNG	ETF	40.46	41.55	40.46	41.55	375.0

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

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