PREVIEW / etf_daily / 2012-06-14

all etf daily files

  file:    by_date/etf_daily/2012/2012-06-14.parquet
  size:    38 KB
  rows:    928

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-14	SPY	ETF	132.34	134.0	131.98	133.47	230615500.0
2012-06-14	QQQ	ETF	62.14	62.61	61.8	62.36	65170503.0
2012-06-14	IWM	ETF	75.38	76.47	75.16	76.2	53619000.0
2012-06-14	DIA	ETF	125.12	126.94	124.95	126.37	8162700.0
2012-06-14	GLD	ETF	157.64	157.94	156.24	157.75	11502400.0
2012-06-14	TLT	ETF	125.95	126.28	125.19	125.7	7688200.0
2012-06-14	AADR	ETF	28.06	28.06	27.95	27.95	500.0
2012-06-14	AAXJ	ETF	51.16	51.73	51.02	51.55	202900.0
2012-06-14	ACTV	ETF	15.25	15.34	15.1	15.2	452971.0
2012-06-14	ACWI	ETF	42.69	43.19	42.6	43.06	234600.0
2012-06-14	ACWV	ETF	54.06	54.06	53.6	53.75	2700.0
2012-06-14	ACWX	ETF	36.14	36.44	35.95	36.34	121257.0
2012-06-14	ADRE	ETF	36.6	36.884	36.42	36.7901	78805.0
2012-06-14	AFK	ETF	27.25	27.37	27.14	27.2699	18026.0
2012-06-14	AGEM	ETF	20.21	20.4054	20.21	20.4054	1185.0
2012-06-14	AGG	ETF	111.1	111.18	111.03	111.12	559200.0
2012-06-14	AGQ	ETF	169.64	169.64	160.96	167.0	445550.0
2012-06-14	AGZ	ETF	113.3	113.46	113.3	113.39	9061.0
2012-06-14	AIA	ETF	40.58	40.8099	40.46	40.8	26452.0
2012-06-14	AIQ	ETF	4.816	5.0	4.7	4.989	8857.0
2012-06-14	AIS	ETF	3.18	3.3	3.17	3.3	575621.0
2012-06-14	AIVI	ETF	37.04	37.42	37.0	37.34	25500.0
2012-06-14	AMJ	ETF	36.48	36.54	36.0601	36.27	838176.0
2012-06-14	AMLP	ETF	78.4	79.0	77.9	78.15	273600.0
2012-06-14	ANGL	ETF	25.02	25.2	25.02	25.15	1100.0
2012-06-14	AOA	ETF	34.11	34.32	34.11	34.32	4500.0
2012-06-14	AOK	ETF	29.61	29.6587	29.6028	29.63	7095.0
2012-06-14	AOM	ETF	30.35	30.48	30.35	30.48	9213.0
2012-06-14	AOR	ETF	31.95	32.1	31.95	32.1	8689.0
2012-06-14	ARB	ETF	33.62	34.15	33.4	33.97	102077.0
2012-06-14	ARGT	ETF	15.16	15.16	15.16	15.16	50.0
2012-06-14	ASEA	ETF	14.93	15.04	14.85	14.92	19400.0
2012-06-14	AWAY	ETF	19.99	21.21	19.19	21.07	819814.0
2012-06-14	BAB	ETF	29.93	29.99	29.81	29.84	181752.0
2012-06-14	BAL	ETF	47.44	47.5101	46.47	46.5401	7120.0
2012-06-14	BALT	ETF	3.19	3.25	3.13	3.24	89589.0
2012-06-14	BBH	ETF	44.57	45.46	44.57	45.3	11800.0
2012-06-14	BCM	ETF	40.58	40.599	40.24	40.599	1991.0
2012-06-14	BIB	ETF	11.6487	11.905	11.6487	11.7363	41224.0
2012-06-14	BICK	ETF	22.14	22.34	22.13	22.322	6134.0
2012-06-14	BIL	ETF	91.64	91.66	91.64	91.66	169450.0
2012-06-14	BIS	ETF	3574.4	3574.4	3544.0	3544.0	3.595
2012-06-14	BIV	ETF	88.53	88.57	88.28	88.36	366600.0
2012-06-14	BJK	ETF	31.35	31.7	31.35	31.6	3500.0
2012-06-14	BKF	ETF	35.29	35.62	35.1	35.5	101939.0
2012-06-14	BKLN	ETF	24.17	24.3	24.17	24.3	76200.0
2012-06-14	BLV	ETF	94.71	94.8	94.31	94.67	40400.0
2012-06-14	BMVP	ETF	14.5267	14.7	14.5267	14.6619	8537.0
2012-06-14	BND	ETF	84.29	84.29	84.15	84.23	718800.0
2012-06-14	BNO	ETF	34.125	34.855	34.075	34.675	49400.0

> showing 50 of 928 rows — these rows as CSV

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