PREVIEW / etf_daily / 2013-05-21

all etf daily files

  file:    by_date/etf_daily/2013/2013-05-21.parquet
  size:    41 KB
  rows:    992

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-21	SPY	ETF	167.08	167.8	166.5	167.17	95804200.0
2013-05-21	QQQ	ETF	74.18	74.54	73.89	74.27	25899967.0
2013-05-21	IWM	ETF	99.2	99.55	98.88	99.23	23596700.0
2013-05-21	DIA	ETF	153.28	154.02	152.89	153.51	5734900.0
2013-05-21	GLD	ETF	132.17	133.65	131.45	132.88	14542500.0
2013-05-21	TLT	ETF	116.93	117.87	116.42	117.84	7781800.0
2013-05-21	AADR	ETF	35.28	35.28	34.89	35.01	1800.0
2013-05-21	AAXJ	ETF	60.98	61.29	60.8	61.18	468800.0
2013-05-21	ACTV	ETF	6.23	6.28	6.1	6.13	873025.0
2013-05-21	ACWI	ETF	53.84	54.17	53.71	54.03	1459100.0
2013-05-21	ACWV	ETF	63.96	64.1	63.71	63.96	27500.0
2013-05-21	ACWX	ETF	45.12	45.43	44.99	45.31	283689.0
2013-05-21	ADRE	ETF	39.3	39.31	38.94	39.24	33744.0
2013-05-21	AFK	ETF	30.3	30.541	30.29	30.48	20751.0
2013-05-21	AGEM	ETF	22.78	22.93	22.655	22.8455	8780.0
2013-05-21	AGG	ETF	110.13	110.32	110.07	110.29	992300.0
2013-05-21	AGQ	ETF	88.96	91.88	87.6	90.08	753950.0
2013-05-21	AGZ	ETF	113.13	113.24	113.13	113.24	19248.0
2013-05-21	AIA	ETF	47.08	47.29	46.97	47.21	10679.0
2013-05-21	AIQ	ETF	12.53	12.7	12.4101	12.7	19942.0
2013-05-21	AIVI	ETF	44.27	44.75	44.26	44.67	83500.0
2013-05-21	ALTL	ETF	29.9699	29.9699	29.9699	29.9699	100.0
2013-05-21	AMJ	ETF	47.97	48.7	47.608	48.45	908283.0
2013-05-21	AMLP	ETF	89.1	90.05	89.1	90.0	627300.0
2013-05-21	ANGL	ETF	28.06	28.06	27.93	28.01	1200.0
2013-05-21	AOA	ETF	41.72	41.86	41.62	41.8	38600.0
2013-05-21	AOK	ETF	31.73	31.79	31.7	31.78	44806.0
2013-05-21	AOM	ETF	33.61	33.679	33.5376	33.61	36034.0
2013-05-21	AOR	ETF	36.93	37.05	36.84	36.99	67236.0
2013-05-21	ARB	ETF	46.78	46.8601	46.7499	46.82	339473.0
2013-05-21	ARGT	ETF	18.18	18.19	18.09	18.19	3800.0
2013-05-21	ASEA	ETF	18.8	18.88	18.76	18.81	34200.0
2013-05-21	ATMP	ETF	26.82	27.07	26.75	27.05	23800.0
2013-05-21	AVIV	ETF	29.94	30.23	29.825	30.12	98956.0
2013-05-21	AWAY	ETF	30.61	31.4	30.61	31.02	954302.0
2013-05-21	BAB	ETF	30.42	30.49	30.27	30.47	288906.0
2013-05-21	BAL	ETF	53.76	53.76	52.7735	52.858	13643.0
2013-05-21	BALT	ETF	3.97	4.1	3.97	4.05	130053.0
2013-05-21	BBH	ETF	72.17	73.3	72.17	72.93	200900.0
2013-05-21	BCM	ETF	40.3101	40.311	40.31	40.311	21831.0
2013-05-21	BIB	ETF	24.72	25.175	24.375	24.8875	143756.0
2013-05-21	BICK	ETF	24.4	24.468	24.338	24.44	4600.0
2013-05-21	BIL	ETF	91.62	91.62	91.6	91.62	113100.0
2013-05-21	BIS	ETF	1467.96	1472.0	1426.0	1436.72	135.0
2013-05-21	BIV	ETF	87.42	87.58	87.27	87.58	421600.0
2013-05-21	BIZD	ETF	20.75	20.9	20.69	20.75	5800.0
2013-05-21	BJK	ETF	43.68	43.8	43.56	43.65	381500.0
2013-05-21	BKF	ETF	39.98	40.17	39.78	40.0601	27296.0
2013-05-21	BKLN	ETF	25.22	25.23	25.21	25.22	3931600.0
2013-05-21	BLV	ETF	91.27	91.9	91.05	91.9	70100.0

> showing 50 of 992 rows — these rows as CSV

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