PREVIEW / etf_daily / 2012-06-08

all etf daily files

  file:    by_date/etf_daily/2012/2012-06-08.parquet
  size:    38 KB
  rows:    923

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-08	SPY	ETF	131.71	133.13	131.29	133.1	143915400.0
2012-06-08	QQQ	ETF	62.16	62.95	61.96	62.87	39737101.0
2012-06-08	IWM	ETF	75.9	77.06	75.35	76.97	50420100.0
2012-06-08	DIA	ETF	124.12	125.43	123.86	125.43	4432700.0
2012-06-08	GLD	ETF	153.02	154.83	153.0	154.73	11074800.0
2012-06-08	TLT	ETF	126.75	126.95	124.57	125.21	11239600.0
2012-06-08	AAXJ	ETF	50.74	51.02	50.51	50.95	314100.0
2012-06-08	ACTV	ETF	14.61	14.62	14.44	14.59	392596.0
2012-06-08	ACWI	ETF	42.52	42.94	42.36	42.91	348000.0
2012-06-08	ACWV	ETF	53.13	54.19	52.88	53.67	8400.0
2012-06-08	ACWX	ETF	35.77	36.1	35.66	36.06	497389.0
2012-06-08	ADRE	ETF	36.45	36.65	36.365	36.58	15930.0
2012-06-08	AFK	ETF	27.06	27.36	26.93	27.34	39390.0
2012-06-08	AGEM	ETF	20.17	20.25	20.17	20.228	873.0
2012-06-08	AGG	ETF	111.17	111.18	110.84	110.9	710200.0
2012-06-08	AGQ	ETF	161.44	166.52	161.28	166.4	256200.0
2012-06-08	AGZ	ETF	113.54	113.54	113.3742	113.38	12635.0
2012-06-08	AIA	ETF	39.99	40.292	39.87	40.17	16704.0
2012-06-08	AIQ	ETF	4.85	5.1	4.7	5.0	15877.0
2012-06-08	AIS	ETF	3.12	3.2	3.07	3.19	1081514.0
2012-06-08	AIVI	ETF	36.79	37.27	36.68	37.27	20500.0
2012-06-08	AMJ	ETF	35.95	36.44	35.95	36.41	856862.0
2012-06-08	AMLP	ETF	77.55	78.9	77.55	78.2	237600.0
2012-06-08	ANGL	ETF	25.46	25.46	24.93	24.93	1700.0
2012-06-08	AOA	ETF	34.0	34.27	34.0	34.27	2900.0
2012-06-08	AOK	ETF	29.6	29.65	29.5653	29.61	31113.0
2012-06-08	AOM	ETF	30.36	30.45	30.28	30.4	23336.0
2012-06-08	AOR	ETF	31.91	32.0799	31.89	32.0799	18623.0
2012-06-08	ARB	ETF	34.07	34.41	33.5	34.21	89189.0
2012-06-08	ASEA	ETF	14.66	14.9	14.65	14.86	30500.0
2012-06-08	AWAY	ETF	22.04	23.18	21.49	21.87	535686.0
2012-06-08	BAB	ETF	29.97	30.0	29.86	29.92	183078.0
2012-06-08	BAL	ETF	44.65	45.55	44.03	45.36	120376.0
2012-06-08	BALT	ETF	3.17	3.28	3.14	3.28	56442.0
2012-06-08	BBH	ETF	45.12	45.28	45.1	45.23	4600.0
2012-06-08	BCM	ETF	40.42	40.718	40.42	40.61	9066.0
2012-06-08	BIB	ETF	11.625	11.9772	11.625	11.9772	30808.0
2012-06-08	BICK	ETF	22.08	22.175	21.9925	22.098	3818.0
2012-06-08	BIL	ETF	91.64	91.66	91.64	91.64	158900.0
2012-06-08	BIS	ETF	3680.0	3681.6	3560.0	3560.0	21.25
2012-06-08	BIV	ETF	88.71	88.75	88.45	88.56	251800.0
2012-06-08	BJK	ETF	31.28	31.71	31.1	31.71	32700.0
2012-06-08	BKF	ETF	35.09	35.29	34.93	35.26	84121.0
2012-06-08	BKLN	ETF	24.08	24.15	23.9	24.15	240900.0
2012-06-08	BLV	ETF	95.2	95.36	94.12	94.39	54000.0
2012-06-08	BMVP	ETF	14.41	14.6	14.37	14.6	1117.0
2012-06-08	BND	ETF	84.25	84.3	84.07	84.16	1572200.0
2012-06-08	BNO	ETF	34.63	35.345	34.5	35.345	110200.0
2012-06-08	BOIL	ETF	661800.0	680200.0	658200.0	667400.0	8.6
2012-06-08	BOND	ETF	105.35	105.35	105.095	105.145	437880.0

> showing 50 of 923 rows — these rows as CSV

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