PREVIEW / etf_daily / 2012-06-27

all etf daily files

  file:    by_date/etf_daily/2012/2012-06-27.parquet
  size:    38 KB
  rows:    922

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
2012-06-27	SPY	ETF	132.42	133.43	131.97	133.17	108088000.0
2012-06-27	QQQ	ETF	62.76	63.18	62.6899	62.9	35705771.0
2012-06-27	IWM	ETF	76.43	77.46	76.36	77.44	38510400.0
2012-06-27	DIA	ETF	125.4	126.23	125.32	126.01	3717100.0
2012-06-27	GLD	ETF	153.3	153.45	152.15	152.83	4840700.0
2012-06-27	TLT	ETF	126.56	126.79	126.03	126.54	5860700.0
2012-06-27	AADR	ETF	27.88	27.94	27.88	27.94	400.0
2012-06-27	AAXJ	ETF	51.01	51.27	50.97	51.18	214100.0
2012-06-27	ACTV	ETF	15.45	16.0	15.18	15.25	363810.0
2012-06-27	ACWI	ETF	42.49	42.71	42.38	42.66	730200.0
2012-06-27	ACWV	ETF	53.78	53.81	53.7	53.77	11400.0
2012-06-27	ACWX	ETF	35.74	36.0	35.68	35.94	308401.0
2012-06-27	ADRE	ETF	36.1	36.3091	36.0318	36.16	28884.0
2012-06-27	AFK	ETF	26.9	27.211	26.89	27.17	26446.0
2012-06-27	AGEM	ETF	20.22	20.62	20.22	20.46	16389.0
2012-06-27	AGG	ETF	111.35	111.39	111.24	111.32	1552600.0
2012-06-27	AGQ	ETF	150.16	150.8	144.92	146.48	225675.0
2012-06-27	AGZ	ETF	113.47	113.57	113.4	113.57	11144.0
2012-06-27	AIA	ETF	40.17	40.2295	40.03	40.09	9882.0
2012-06-27	AIQ	ETF	4.585	5.1	4.313	4.35	19910.0
2012-06-27	AIVI	ETF	36.21	36.53	36.19	36.45	38600.0
2012-06-27	AMJ	ETF	36.23	37.35	36.11	37.08	1796935.0
2012-06-27	AMLP	ETF	77.7	78.8	77.7	78.75	401000.0
2012-06-27	ANGL	ETF	25.35	25.37	25.35	25.35	12800.0
2012-06-27	AOA	ETF	34.05	34.24	34.05	34.24	7000.0
2012-06-27	AOK	ETF	29.7101	29.75	29.69	29.711	913840.0
2012-06-27	AOM	ETF	30.23	30.36	30.23	30.328	7334.0
2012-06-27	AOR	ETF	31.9	31.98	31.9	31.966	8401.0
2012-06-27	ARB	ETF	34.32	34.79	34.2	34.77	91047.0
2012-06-27	ARGT	ETF	15.78	15.78	15.78	15.78	450.0
2012-06-27	ASEA	ETF	15.34	15.34	15.22	15.3	5000.0
2012-06-27	AWAY	ETF	21.0	21.66	20.875	21.28	602284.0
2012-06-27	BAB	ETF	29.87	29.87	29.75	29.81	158064.0
2012-06-27	BAL	ETF	45.1904	45.4	44.85	45.1528	10805.0
2012-06-27	BALT	ETF	3.31	3.32	3.19	3.24	118063.0
2012-06-27	BBH	ETF	46.58	47.17	46.58	47.17	8400.0
2012-06-27	BIB	ETF	12.95	13.236	12.865	13.155	25536.0
2012-06-27	BICK	ETF	21.71	21.71	21.5812	21.6206	7805.0
2012-06-27	BIL	ETF	91.64	91.66	91.64	91.64	118550.0
2012-06-27	BIS	ETF	3275.2	3275.2	3196.8	3201.6	34.4
2012-06-27	BIV	ETF	88.77	88.8	88.62	88.8	140800.0
2012-06-27	BJK	ETF	31.35	31.44	31.25	31.29	6000.0
2012-06-27	BKF	ETF	34.38	34.51	34.22	34.37	117174.0
2012-06-27	BKLN	ETF	24.17	24.3	24.16	24.3	783800.0
2012-06-27	BLV	ETF	95.27	95.63	95.23	95.56	23300.0
2012-06-27	BMVP	ETF	14.9333	15.021	14.9333	15.0113	2228.0
2012-06-27	BND	ETF	84.37	84.38	84.27	84.35	669200.0
2012-06-27	BNO	ETF	33.175	33.285	33.075	33.2	43400.0
2012-06-27	BOIL	ETF	974600.0	985000.0	891000.0	892200.0	26.0
2012-06-27	BOND	ETF	105.75	105.79	105.6431	105.79	399509.0

> showing 50 of 922 rows — these rows as CSV

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