PREVIEW / etf_daily / 2013-05-08

all etf daily files

  file:    by_date/etf_daily/2013/2013-05-08.parquet
  size:    41 KB
  rows:    991

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-08	SPY	ETF	162.42	163.39	162.33	163.34	97419200.0
2013-05-08	QQQ	ETF	72.31	72.77	72.2	72.71	24257984.0
2013-05-08	IWM	ETF	95.93	96.47	95.68	96.43	37669300.0
2013-05-08	DIA	ETF	150.13	150.96	150.1	150.94	4087100.0
2013-05-08	GLD	ETF	141.78	142.81	141.49	142.46	11161100.0
2013-05-08	TLT	ETF	120.27	120.83	120.17	120.35	5732900.0
2013-05-08	AADR	ETF	35.04	35.04	34.88	34.88	1500.0
2013-05-08	AAXJ	ETF	61.4	61.55	61.3	61.55	251100.0
2013-05-08	ACTV	ETF	5.73	5.9	5.69	5.82	772317.0
2013-05-08	ACWI	ETF	53.02	53.37	53.02	53.37	459600.0
2013-05-08	ACWV	ETF	64.07	64.22	64.04	64.21	177200.0
2013-05-08	ACWX	ETF	45.04	45.26	45.0201	45.24	96561.0
2013-05-08	ADRE	ETF	39.81	40.089	39.81	40.01	75900.0
2013-05-08	AFK	ETF	30.25	30.67	30.19	30.67	25853.0
2013-05-08	AGEM	ETF	23.1906	23.25	23.17	23.22	3396.0
2013-05-08	AGG	ETF	110.83	110.9	110.76	110.85	1032600.0
2013-05-08	AGQ	ETF	103.4	104.2	101.44	103.6	285575.0
2013-05-08	AGZ	ETF	113.45	113.54	113.43	113.53	6394.0
2013-05-08	AIA	ETF	47.69	47.84	47.63	47.84	25841.0
2013-05-08	AIQ	ETF	12.86	12.91	11.1205	12.9	29208.0
2013-05-08	AIVI	ETF	44.53	44.72	44.53	44.71	30100.0
2013-05-08	ALTL	ETF	29.62	29.62	29.62	29.62	800.0
2013-05-08	AMJ	ETF	47.02	48.15	47.02	47.59	954872.0
2013-05-08	AMLP	ETF	87.75	88.4	87.55	88.4	701700.0
2013-05-08	ANGL	ETF	27.63	27.78	27.63	27.78	1400.0
2013-05-08	AOA	ETF	41.09	41.23	41.06	41.23	63300.0
2013-05-08	AOK	ETF	31.66	31.72	31.65	31.72	28905.0
2013-05-08	AOM	ETF	33.38	33.4807	33.38	33.46	25357.0
2013-05-08	AOR	ETF	36.47	36.67	36.47	36.67	33657.0
2013-05-08	ARB	ETF	46.73	46.8	46.73	46.8	175390.0
2013-05-08	ARGT	ETF	18.06	18.12	18.04	18.04	850.0
2013-05-08	ASEA	ETF	18.87	18.98	18.87	18.98	285500.0
2013-05-08	ATMP	ETF	26.16	26.37	26.11	26.36	43200.0
2013-05-08	AVIV	ETF	28.28	29.58	28.26	29.08	404593.0
2013-05-08	AWAY	ETF	28.72	29.0	28.13	28.84	1239324.0
2013-05-08	BAB	ETF	30.72	30.742	30.61	30.7136	120366.0
2013-05-08	BAL	ETF	55.04	55.47	54.0	55.459	63305.0
2013-05-08	BALT	ETF	3.44	3.517	3.26	3.43	92115.0
2013-05-08	BBH	ETF	70.63	71.13	70.31	70.69	49100.0
2013-05-08	BCM	ETF	41.03	41.094	40.99	41.094	1010.0
2013-05-08	BIB	ETF	23.34	23.5547	22.5175	23.2325	511244.0
2013-05-08	BICK	ETF	24.5	24.68	24.5	24.67	4128.0
2013-05-08	BIL	ETF	91.6	91.62	91.6	91.62	186750.0
2013-05-08	BIS	ETF	1560.0	1580.76	1548.4	1580.76	101.5
2013-05-08	BIV	ETF	88.1	88.23	88.05	88.15	207000.0
2013-05-08	BIZD	ETF	20.71	20.71	20.5	20.62	6500.0
2013-05-08	BJK	ETF	43.35	43.38	43.2	43.35	10700.0
2013-05-08	BKF	ETF	40.28	40.5038	40.26	40.45	56856.0
2013-05-08	BKLN	ETF	25.26	25.29	25.26	25.29	2896700.0
2013-05-08	BLV	ETF	93.1	93.49	93.07	93.25	88500.0

> showing 50 of 991 rows — these rows as CSV

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