PREVIEW / etf_daily / 2012-08-15

all etf daily files

  file:    by_date/etf_daily/2012/2012-08-15.parquet
  size:    38 KB
  rows:    932

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-08-15	SPY	ETF	140.64	141.19	140.55	140.95	71085900.0
2012-08-15	QQQ	ETF	67.0	67.3199	66.99	67.22	29110347.0
2012-08-15	IWM	ETF	79.38	80.3	79.31	80.3	27061400.0
2012-08-15	DIA	ETF	131.51	131.99	131.44	131.72	2834800.0
2012-08-15	GLD	ETF	155.32	155.82	155.27	155.63	4993900.0
2012-08-15	TLT	ETF	123.02	123.2	121.9	122.05	11191000.0
2012-08-15	AADR	ETF	29.1	29.14	29.1	29.14	300.0
2012-08-15	AAXJ	ETF	54.34	54.39	54.14	54.27	128400.0
2012-08-15	ACTV	ETF	11.43	11.68	11.4	11.5	424934.0
2012-08-15	ACWI	ETF	45.49	45.59	45.42	45.48	305100.0
2012-08-15	ACWV	ETF	55.87	55.97	55.71	55.8	7600.0
2012-08-15	ACWX	ETF	38.41	38.48	38.32	38.41	181402.0
2012-08-15	ADRE	ETF	38.78	39.01	38.78	38.948	73974.0
2012-08-15	AFK	ETF	29.27	29.32	29.15	29.23	17490.0
2012-08-15	AGEM	ETF	21.95	21.95	21.86	21.938	6180.0
2012-08-15	AGG	ETF	111.45	111.45	111.19	111.24	550000.0
2012-08-15	AGQ	ETF	155.12	156.6	153.84	154.4	105150.0
2012-08-15	AGZ	ETF	113.35	113.35	113.191	113.2	12393.0
2012-08-15	AIA	ETF	43.44	43.61	43.44	43.53	10092.0
2012-08-15	AIQ	ETF	5.75	7.25	5.75	6.8	44270.0
2012-08-15	AIVI	ETF	39.19	39.27	39.16	39.24	13500.0
2012-08-15	AMJ	ETF	39.67	39.83	39.55	39.77	312458.0
2012-08-15	AMLP	ETF	81.35	81.7	81.25	81.5	447920.0
2012-08-15	ANGL	ETF	26.4	26.4	26.0	26.04	11300.0
2012-08-15	AOA	ETF	35.84	35.93	35.84	35.89	13700.0
2012-08-15	AOK	ETF	30.12	30.15	30.06	30.06	38178.0
2012-08-15	AOM	ETF	31.13	31.19	31.1	31.1436	28498.0
2012-08-15	AOR	ETF	33.03	33.16	33.03	33.14	33755.0
2012-08-15	ARB	ETF	35.15	36.32	35.15	36.27	74473.0
2012-08-15	ARGT	ETF	17.12	17.24	17.02	17.2	3350.0
2012-08-15	ASEA	ETF	16.39	16.49	16.38	16.43	8700.0
2012-08-15	AWAY	ETF	23.85	24.46	23.7125	24.45	254068.0
2012-08-15	BAB	ETF	29.83	29.83	29.6	29.63	200278.0
2012-08-15	BAL	ETF	47.98	48.29	47.65	48.2204	9836.0
2012-08-15	BALT	ETF	3.27	3.34	3.15	3.26	76387.0
2012-08-15	BBH	ETF	50.2	50.55	50.2	50.41	44800.0
2012-08-15	BCM	ETF	44.32	44.43	44.32	44.412	2226.0
2012-08-15	BIB	ETF	13.8837	14.1638	13.8837	14.0465	17896.0
2012-08-15	BICK	ETF	23.14	23.199	23.124	23.183	3639.0
2012-08-15	BIL	ETF	91.62	91.64	91.62	91.62	85150.0
2012-08-15	BIS	ETF	2916.8	2916.8	2881.6	2883.04	39.5
2012-08-15	BIV	ETF	88.9	88.91	88.65	88.71	181400.0
2012-08-15	BJK	ETF	31.06	31.26	31.04	31.16	23700.0
2012-08-15	BKF	ETF	36.66	36.9	36.66	36.78	119102.0
2012-08-15	BKLN	ETF	24.66	24.66	24.6	24.65	430600.0
2012-08-15	BLV	ETF	95.08	95.08	94.27	94.42	106200.0
2012-08-15	BMVP	ETF	15.88	15.95	15.88	15.93	27305.0
2012-08-15	BND	ETF	84.36	84.36	84.17	84.18	780400.0
2012-08-15	BNO	ETF	40.44	41.32	40.41	41.2	116800.0
2012-08-15	BOIL	ETF	860200.0	863800.0	834400.0	846800.0	13.4

> showing 50 of 932 rows — these rows as CSV

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