PREVIEW / etf_daily / 2012-11-23

all etf daily files

  file:    by_date/etf_daily/2012/2012-11-23.parquet
  size:    37 KB
  rows:    914

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-11-23	SPY	ETF	140.13	141.4	140.04	141.35	65409200.0
2012-11-23	QQQ	ETF	64.32	64.92	64.2501	64.9	16462833.0
2012-11-23	IWM	ETF	79.9	80.56	79.86	80.47	20093300.0
2012-11-23	DIA	ETF	128.67	129.91	128.66	129.89	3345800.0
2012-11-23	GLD	ETF	167.97	170.01	167.8	169.61	6110100.0
2012-11-23	TLT	ETF	124.3	124.45	124.11	124.21	987200.0
2012-11-23	AADR	ETF	29.86	30.03	29.86	29.93	3400.0
2012-11-23	AAXJ	ETF	57.14	57.55	57.14	57.46	151200.0
2012-11-23	ACTV	ETF	4.83	4.85	4.6	4.83	338820.0
2012-11-23	ACWI	ETF	46.63	46.94	46.61	46.94	276600.0
2012-11-23	ACWV	ETF	55.99	56.86	55.99	56.3	40700.0
2012-11-23	ACWX	ETF	40.0	40.29	40.0	40.29	86944.0
2012-11-23	ADRE	ETF	38.24	38.52	38.24	38.52	19053.0
2012-11-23	AFK	ETF	30.81	31.21	30.71	31.2	20941.0
2012-11-23	AGEM	ETF	22.4	22.46	22.2501	22.46	1248.0
2012-11-23	AGG	ETF	111.96	111.98	111.89	111.96	220300.0
2012-11-23	AGQ	ETF	216.52	225.48	215.96	224.16	264200.0
2012-11-23	AGZ	ETF	113.88	113.88	113.72	113.8209	4863.0
2012-11-23	AIA	ETF	45.6	45.89	45.6	45.87	47542.0
2012-11-23	AIQ	ETF	6.15	6.25	5.755	6.0	3739.0
2012-11-23	AIVI	ETF	39.97	40.29	39.97	40.29	11800.0
2012-11-23	AMJ	ETF	39.88	39.99	39.76	39.94	137806.0
2012-11-23	AMLP	ETF	81.1	81.1	80.85	81.05	145540.0
2012-11-23	ANGL	ETF	26.83	26.83	26.64	26.68	1100.0
2012-11-23	AOA	ETF	36.43	36.5	36.43	36.5	1800.0
2012-11-23	AOK	ETF	30.44	30.44	30.41	30.44	6626.0
2012-11-23	AOM	ETF	31.34	31.52	31.34	31.52	5636.0
2012-11-23	AOR	ETF	33.36	33.57	33.36	33.57	17046.0
2012-11-23	ARB	ETF	35.26	36.1	35.26	36.1	103301.0
2012-11-23	ARGT	ETF	15.74	15.96	15.74	15.92	1250.0
2012-11-23	ASEA	ETF	16.69	16.71	16.59	16.7	6500.0
2012-11-23	AWAY	ETF	20.94	20.98	20.75	20.94	69343.0
2012-11-23	BAB	ETF	30.42	30.42	30.2201	30.3	41625.0
2012-11-23	BAL	ETF	47.34	47.3545	46.6	46.81	4731.0
2012-11-23	BALT	ETF	2.88	3.06	2.79	3.05	27105.0
2012-11-23	BBH	ETF	54.22	54.5	54.16	54.5	20600.0
2012-11-23	BIB	ETF	14.6925	14.6925	14.536	14.6675	39660.0
2012-11-23	BICK	ETF	23.6	23.669	23.5978	23.626	1143.0
2012-11-23	BIL	ETF	91.62	91.64	91.62	91.62	52900.0
2012-11-23	BIS	ETF	2660.0	2663.94	2660.0	2663.94	15.75
2012-11-23	BIV	ETF	90.1	90.16	90.07	90.12	172100.0
2012-11-23	BJK	ETF	34.96	35.11	34.96	35.11	300.0
2012-11-23	BKF	ETF	37.86	38.17	37.85	38.16	45525.0
2012-11-23	BKLN	ETF	24.67	24.71	24.61	24.7	132600.0
2012-11-23	BLV	ETF	96.6	96.71	96.4	96.58	24300.0
2012-11-23	BMVP	ETF	15.86	15.88	15.86	15.88	776.0
2012-11-23	BND	ETF	84.69	84.78	84.66	84.75	664200.0
2012-11-23	BNO	ETF	40.505	40.825	40.505	40.765	92800.0
2012-11-23	BOIL	ETF	1133800.0	1170000.0	1130200.0	1165600.0	4.4
2012-11-23	BOND	ETF	109.9	109.9	109.75	109.75	200326.0

> showing 50 of 914 rows — these rows as CSV

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